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: l_employee_id number; -- bug 7559456

Line 439: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;

435: l_freight_amount number;
436: l_created_by number;
437: l_line_credit_flag varchar2(1);
438: l_tax_disclaimer varchar2(250);
439: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;
440: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;
441:
442:
443:

Line 440: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;

436: l_created_by number;
437: l_line_credit_flag varchar2(1);
438: l_tax_disclaimer varchar2(250);
439: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;
440: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;
441:
442:
443:
444: BEGIN

Line 4911: from ra_cm_requests_all

4907:
4908: BEGIN
4909:
4910: select org_id into l_org_id
4911: from ra_cm_requests_all
4912: where request_id = p_item_key;
4913: ----------------------------------------------------------
4914: l_debug_mesg := 'Get the org_id for the credit memo request';
4915: ----------------------------------------------------------