DBA Data[Home] [Help]

APPS.AR_CREDIT_MEMO_API_PUB dependencies on RA_CM_REQUESTS

Line 25: p_line_credit_flag IN ra_cm_requests.line_credits_flag%type,

21: x_msg_count OUT NOCOPY NUMBER,
22: x_msg_data OUT NOCOPY VARCHAR2,
23: -- credit memo request parameters
24: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
25: p_line_credit_flag IN ra_cm_requests.line_credits_flag%type,
26: p_line_amount IN NUMBER := 0 ,
27: p_tax_amount IN NUMBER := 0 ,
28: p_freight_amount IN NUMBER := 0,
29: p_cm_reason_code IN VARCHAR2,

Line 682: x_line_amount OUT NOCOPY ra_cm_requests.line_amount%type,

678: x_status_meaning OUT NOCOPY varchar2,
679: x_reason_meaning OUT NOCOPY varchar2,
680: x_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
681: x_cm_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
682: x_line_amount OUT NOCOPY ra_cm_requests.line_amount%type,
683: x_tax_amount OUT NOCOPY ra_cm_requests.tax_amount%type,
684: x_freight_amount OUT NOCOPY ra_cm_requests.freight_amount%type,
685: x_line_credits_flag OUT NOCOPY varchar2,
686: x_created_by OUT NOCOPY wf_users.display_name%type,

Line 683: x_tax_amount OUT NOCOPY ra_cm_requests.tax_amount%type,

679: x_reason_meaning OUT NOCOPY varchar2,
680: x_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
681: x_cm_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
682: x_line_amount OUT NOCOPY ra_cm_requests.line_amount%type,
683: x_tax_amount OUT NOCOPY ra_cm_requests.tax_amount%type,
684: x_freight_amount OUT NOCOPY ra_cm_requests.freight_amount%type,
685: x_line_credits_flag OUT NOCOPY varchar2,
686: x_created_by OUT NOCOPY wf_users.display_name%type,
687: x_creation_date OUT NOCOPY DATE,

Line 684: x_freight_amount OUT NOCOPY ra_cm_requests.freight_amount%type,

680: x_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
681: x_cm_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
682: x_line_amount OUT NOCOPY ra_cm_requests.line_amount%type,
683: x_tax_amount OUT NOCOPY ra_cm_requests.tax_amount%type,
684: x_freight_amount OUT NOCOPY ra_cm_requests.freight_amount%type,
685: x_line_credits_flag OUT NOCOPY varchar2,
686: x_created_by OUT NOCOPY wf_users.display_name%type,
687: x_creation_date OUT NOCOPY DATE,
688: x_approval_date OUT NOCOPY DATE,

Line 689: x_comments OUT NOCOPY ra_cm_requests.comments%type,

685: x_line_credits_flag OUT NOCOPY varchar2,
686: x_created_by OUT NOCOPY wf_users.display_name%type,
687: x_creation_date OUT NOCOPY DATE,
688: x_approval_date OUT NOCOPY DATE,
689: x_comments OUT NOCOPY ra_cm_requests.comments%type,
690: x_cm_line_tbl OUT NOCOPY Cm_Line_Tbl_Type_Cover%type,
691: x_cm_activity_tbl OUT NOCOPY x_cm_activity_tbl%type,
692: x_cm_notes_tbl OUT NOCOPY x_cm_notes_tbl%type)
693:

Line 834: FROM ra_cm_requests

830: l_created_by,
831: x_creation_date,
832: x_approval_date,
833: x_comments
834: FROM ra_cm_requests
835: WHERE request_id = p_request_id;
836:
837: p_line_credits_flag := x_line_credits_flag;
838: