APPS.ARP_CMREQ_WF dependencies on RA_CM_REQUESTS_ALL

Line 57: FROM ra_cm_requests_all

53: p_result IN OUT NOCOPY VARCHAR2) IS
54:
55: CURSOR org IS
56: SELECT org_id
57: FROM ra_cm_requests_all
58: WHERE request_id = p_item_key;
59:
60: l_debug_mesg VARCHAR2(240);
61: l_org_id ra_cm_requests_all.org_id%TYPE;

Line 61: l_org_id ra_cm_requests_all.org_id%TYPE;

57: FROM ra_cm_requests_all
58: WHERE request_id = p_item_key;
59:
60: l_debug_mesg VARCHAR2(240);
61: l_org_id ra_cm_requests_all.org_id%TYPE;
62:
63: BEGIN
64:
65: OPEN org;

Line 150: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;

146: l_requestor_user_name varchar2(100);
147: l_requestor_display_name varchar2(100);
148: /* Bug 3206020 Changed comments width from 240 to 1760. */
149: l_comments varchar2(1760);
150: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;
151: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;
152:
153: /*7367350 storing internal comment and inserting notes*/
154: l_internal_comment VARCHAR2(1760) DEFAULT NULL;

Line 151: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;

147: l_requestor_display_name varchar2(100);
148: /* Bug 3206020 Changed comments width from 240 to 1760. */
149: l_comments varchar2(1760);
150: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;
151: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;
152:
153: /*7367350 storing internal comment and inserting notes*/
154: l_internal_comment VARCHAR2(1760) DEFAULT NULL;
155:

Line 401: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;

397: l_freight_amount number;
398: l_created_by number;
399: l_line_credit_flag varchar2(1);
400: l_tax_disclaimer varchar2(250);
401: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;
402: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;
403:
404:
405:

Line 402: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;

398: l_created_by number;
399: l_line_credit_flag varchar2(1);
400: l_tax_disclaimer varchar2(250);
401: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;
402: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;
403:
404:
405:
406: BEGIN

Line 4775: from ra_cm_requests_all

4771:
4772: BEGIN
4773:
4774: select org_id into l_org_id
4775: from ra_cm_requests_all
4776: where request_id = p_item_key;
4777: ----------------------------------------------------------
4778: l_debug_mesg := 'Get the org_id for the credit memo request';
4779: ----------------------------------------------------------