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 143: FROM ra_cm_requests_all

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

Line 974: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;

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

Line 975: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;

971: l_requestor_display_name wf_users.display_name%TYPE;
972: /*Bug3206020 Changed comments size from 240 to 1760. */
973: l_comments VARCHAR2(1760);
974: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;
975: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;
976: l_internal_comment VARCHAR2(1760) DEFAULT NULL; /*7367350*/
977:
978:
979: CURSOR c1 is

Line 1254: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;

1250: l_freight_amount NUMBER;
1251: l_created_by NUMBER;
1252: l_line_credit_flag VARCHAR2(1);
1253: l_tax_disclaimer VARCHAR2(250);
1254: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;
1255: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;
1256:
1257: CURSOR c IS
1258: SELECT r.request_id,

Line 1255: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;

1251: l_created_by NUMBER;
1252: l_line_credit_flag VARCHAR2(1);
1253: l_tax_disclaimer VARCHAR2(250);
1254: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;
1255: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;
1256:
1257: CURSOR c IS
1258: SELECT r.request_id,
1259: r.customer_trx_id,