Versions Compared

Old Version 62

changes.mady.by.user David Backeberg

Saved on

compared with

New Version 63

changes.mady.by.user David Backeberg

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Note

We need charge_cd as one of the input arguments, we don't netid as input argument.

Existing oracle API:

FUNCTION updateCBAccount (a_node_name    IN VARCHAR2,
                            a_charge_cd    IN NUMBER,
                            a_project      IN VARCHAR2,
                            a_task         IN VARCHAR2,
                            a_award        IN VARCHAR2,
                            a_org          IN VARCHAR2,
       a_msg          OUT VARCHAR2)

new:

FUNCTION updateCBAccountViaSN (a_node_name    IN VARCHAR2,
                            a_charge_cd    IN NUMBER,
                            a_project      IN VARCHAR2,
                            a_task         IN VARCHAR2,
                            a_award        IN VARCHAR2,
                            a_org          IN VARCHAR2) 
RETURN number

0 success

-3 charge code invalid

-5 nodename has space

-10 nodename is invalid

-n database error occurred 

update method needs to return an error code indicating whether or not the add request was accepted, and for errors should indicate the problem with the data.

...