APPS.AR_AME_CMWF_API dependencies on RA_CM_REQUESTS_ALL

Line 25: FROM ra_cm_requests_all

21: p_result IN OUT NOCOPY VARCHAR2) IS
22:
23: CURSOR org IS
24: SELECT org_id
25: FROM ra_cm_requests_all
26: WHERE request_id = p_item_key;
27:
28: l_debug_mesg VARCHAR2(240);
29: l_org_id ra_cm_requests_all.org_id%TYPE;

Line 29: l_org_id ra_cm_requests_all.org_id%TYPE;

25: FROM ra_cm_requests_all
26: WHERE request_id = p_item_key;
27:
28: l_debug_mesg VARCHAR2(240);
29: l_org_id ra_cm_requests_all.org_id%TYPE;
30:
31: BEGIN
32:
33: OPEN org;

Line 145: FROM ra_cm_requests_all

141: l_org_id wf_item_attribute_values.number_value%TYPE;
142:
143: CURSOR c IS
144: SELECT org_id
145: FROM ra_cm_requests_all
146: WHERE request_id = p_item_key;
147:
148: BEGIN
149:

Line 976: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;

972: l_requestor_user_name wf_users.name%TYPE;
973: l_requestor_display_name wf_users.display_name%TYPE;
974: /*Bug3206020 Changed comments size from 240 to 1760. */
975: l_comments VARCHAR2(1760);
976: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;
977: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;
978: l_internal_comment VARCHAR2(1760) DEFAULT NULL; /*7367350*/
979: l_employee_id number ; -- bug 7559456
980:

Line 977: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;

973: l_requestor_display_name wf_users.display_name%TYPE;
974: /*Bug3206020 Changed comments size from 240 to 1760. */
975: l_comments VARCHAR2(1760);
976: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;
977: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;
978: l_internal_comment VARCHAR2(1760) DEFAULT NULL; /*7367350*/
979: l_employee_id number ; -- bug 7559456
980:
981: -- bug 7559456

Line 1293: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;

1289: l_freight_amount NUMBER;
1290: l_created_by NUMBER;
1291: l_line_credit_flag VARCHAR2(1);
1292: l_tax_disclaimer VARCHAR2(250);
1293: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;
1294: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;
1295:
1296: CURSOR c IS
1297: SELECT r.request_id,

Line 1294: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;

1290: l_created_by NUMBER;
1291: l_line_credit_flag VARCHAR2(1);
1292: l_tax_disclaimer VARCHAR2(250);
1293: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;
1294: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;
1295:
1296: CURSOR c IS
1297: SELECT r.request_id,
1298: r.customer_trx_id,