Projects - EBS (MOSC)

MOSC Banner

pa_client_extn_inv_actions

edited Apr 11, 2017 5:00AM in Projects - EBS (MOSC) 6 commentsAnswered
 Hi All
We want to release the draft Invoice automatically after we approve the Draft Invoice. We used the above mentioned Extension with the below code.

PROCEDURE release_invoice (
      p_project_id                IN       NUMBER,
      p_draft_invoice_num         IN       NUMBER,
      p_invoice_class             IN       VARCHAR2,
      p_project_amount            IN       NUMBER,
      p_project_currency_code     IN       VARCHAR2,
      p_inv_currency_code         IN       VARCHAR2,
      p_invoice_amount            IN       NUMBER,
      x_release_flag              OUT      VARCHAR2,
      x_ra_invoice_date           OUT      DATE,
      x_ra_invoice_num            OUT      VARCHAR2,
      x_status                    OUT      NUMBER,
      x_credit_memo_reason_code   OUT      VARCHAR2
   )
   IS
   BEGIN
      -- Reset the output parameters.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center