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 276: select cm_customer_trx_id into temp_customer_trx_id from ra_cm_requests where customer_trx_id = p_customer_trx_id

272: p_return_flag boolean;
273: p_return_code number;
274: p_return_message varchar2(1024);
275: BEGIN
276: select cm_customer_trx_id into temp_customer_trx_id from ra_cm_requests where customer_trx_id = p_customer_trx_id
277: and request_id=x_request_id;
278:
279: jg_zz_ar_trx_pkg.do_trx_complete(null,temp_customer_trx_id,'CMAPI',p_return_flag, p_return_code,p_return_message);
280:

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

721: x_status_meaning OUT NOCOPY varchar2,
722: x_reason_meaning OUT NOCOPY varchar2,
723: x_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
724: x_cm_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
725: x_line_amount OUT NOCOPY ra_cm_requests.line_amount%type,
726: x_tax_amount OUT NOCOPY ra_cm_requests.tax_amount%type,
727: x_freight_amount OUT NOCOPY ra_cm_requests.freight_amount%type,
728: x_line_credits_flag OUT NOCOPY varchar2,
729: x_created_by OUT NOCOPY wf_users.display_name%type,

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

722: x_reason_meaning OUT NOCOPY varchar2,
723: x_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
724: x_cm_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
725: x_line_amount OUT NOCOPY ra_cm_requests.line_amount%type,
726: x_tax_amount OUT NOCOPY ra_cm_requests.tax_amount%type,
727: x_freight_amount OUT NOCOPY ra_cm_requests.freight_amount%type,
728: x_line_credits_flag OUT NOCOPY varchar2,
729: x_created_by OUT NOCOPY wf_users.display_name%type,
730: x_creation_date OUT NOCOPY DATE,

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

723: x_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
724: x_cm_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
725: x_line_amount OUT NOCOPY ra_cm_requests.line_amount%type,
726: x_tax_amount OUT NOCOPY ra_cm_requests.tax_amount%type,
727: x_freight_amount OUT NOCOPY ra_cm_requests.freight_amount%type,
728: x_line_credits_flag OUT NOCOPY varchar2,
729: x_created_by OUT NOCOPY wf_users.display_name%type,
730: x_creation_date OUT NOCOPY DATE,
731: x_approval_date OUT NOCOPY DATE,

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

728: x_line_credits_flag OUT NOCOPY varchar2,
729: x_created_by OUT NOCOPY wf_users.display_name%type,
730: x_creation_date OUT NOCOPY DATE,
731: x_approval_date OUT NOCOPY DATE,
732: x_comments OUT NOCOPY ra_cm_requests.comments%type,
733: x_cm_line_tbl OUT NOCOPY Cm_Line_Tbl_Type_Cover%type,
734: x_cm_activity_tbl OUT NOCOPY x_cm_activity_tbl%type,
735: x_cm_notes_tbl OUT NOCOPY x_cm_notes_tbl%type)
736:

Line 877: FROM ra_cm_requests

873: l_created_by,
874: x_creation_date,
875: x_approval_date,
876: x_comments
877: FROM ra_cm_requests
878: WHERE request_id = p_request_id;
879:
880: p_line_credits_flag := x_line_credits_flag;
881: