APPS.AR_CMGT_CREDIT_REQUEST_API dependencies on AR_CMGT_CREDIT_REQUESTS

Line 71: l_credit_type ar_cmgt_credit_requests.credit_type%type;

67: l_credit_request_id NUMBER(15);
68: l_application_date DATE;
69: l_credit_request_status VARCHAR2(10);
70: l_char VARCHAR2(1);
71: l_credit_type ar_cmgt_credit_requests.credit_type%type;
72: l_isupdateable VARCHAR2(1) := 'N';
73: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
74: l_case_folder_status ar_cmgt_case_folders.status%type;
75: p_credit_request_rec OCM_CREDIT_REQUEST_UPDATE_PUB.credit_request_rec;

Line 79: l_credit_request_type ar_cmgt_credit_requests.credit_request_type%type;

75: p_credit_request_rec OCM_CREDIT_REQUEST_UPDATE_PUB.credit_request_rec;
76: l_parent_cr_status VARCHAR2(15);
77: l_value1 VARCHAR2(60);
78: l_value2 VARCHAR2(60);
79: l_credit_request_type ar_cmgt_credit_requests.credit_request_type%type;
80: l_requestor_type ar_cmgt_credit_requests.requestor_type%type;
81: l_trx_amount NUMBER;
82: l_requested_amount NUMBER;
83: l_requestor_id NUMBER;

Line 80: l_requestor_type ar_cmgt_credit_requests.requestor_type%type;

76: l_parent_cr_status VARCHAR2(15);
77: l_value1 VARCHAR2(60);
78: l_value2 VARCHAR2(60);
79: l_credit_request_type ar_cmgt_credit_requests.credit_request_type%type;
80: l_requestor_type ar_cmgt_credit_requests.requestor_type%type;
81: l_trx_amount NUMBER;
82: l_requested_amount NUMBER;
83: l_requestor_id NUMBER;
84:

Line 311: from ar_cmgt_credit_requests

307: THEN
308: BEGIN
309: select status
310: into l_parent_cr_status
311: from ar_cmgt_credit_requests
312: where credit_request_id = p_parent_credit_request_id
313: and party_id = p_party_id
314: and nvl(cust_account_id,-99) = nvl(p_cust_account_id,-99)
315: and nvl(site_use_id,-99) = nvl(p_site_use_id,-99)

Line 420: FROM ar_cmgt_credit_requests

416:
417: BEGIN
418: SELECT credit_request_id
419: INTO l_credit_request_id
420: FROM ar_cmgt_credit_requests
421: WHERE source_name = p_source_name
422: AND source_column1 = p_source_column1
423: AND party_id = p_party_id
424: AND cust_account_id = nvl(p_cust_account_id, -99)

Line 439: FROM ar_cmgt_credit_requests

435: -- get the latest credit request id
436: BEGIN
437: SELECT max(credit_request_id)
438: INTO l_credit_request_id
439: FROM ar_cmgt_credit_requests
440: WHERE source_name = p_source_name
441: AND source_column1 = p_source_column1
442: AND party_id = p_party_id
443: AND cust_account_id = nvl(p_cust_account_id, -99)

Line 509: from ar_cmgt_credit_requests

505: IF l_isupdateable = 'Y'
506: THEN
507: select trx_amount,limit_amount
508: into l_trx_amount,l_requested_amount
509: from ar_cmgt_credit_requests
510: where credit_request_id = l_credit_request_id;
511:
512: IF l_trx_amount = p_trx_amount AND
513: l_requested_amount = p_requested_amount

Line 570: SELECT AR_CMGT_APPLICATION_NUM_S.NEXTVAL, AR_CMGT_CREDIT_REQUESTS_S.NEXTVAL

566:
567: IF l_application_number IS NULL
568: AND nvl(l_sys_params_rec.auto_application_num_flag, 'N') = 'Y'
569: THEN
570: SELECT AR_CMGT_APPLICATION_NUM_S.NEXTVAL, AR_CMGT_CREDIT_REQUESTS_S.NEXTVAL
571: INTO l_application_number, l_credit_request_id
572: FROM DUAL;
573:
574: END IF;

Line 577: SELECT AR_CMGT_CREDIT_REQUESTS_S.NEXTVAL

573:
574: END IF;
575:
576: IF l_credit_request_id IS NULL THEN
577: SELECT AR_CMGT_CREDIT_REQUESTS_S.NEXTVAL
578: INTO l_credit_request_id
579: FROM dual;
580: END IF;
581:

Line 704: INSERT INTO AR_CMGT_CREDIT_REQUESTS

700: +-----------------------------------------*/
701: /* bug4414414 : Added columns parent_credit_request_id and credit_request_type
702: */
703: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
704: INSERT INTO AR_CMGT_CREDIT_REQUESTS
705: (credit_request_id,
706: last_update_date,
707: last_updated_by,
708: creation_date,

Line 1115: FROM ar_cmgt_credit_requests

1111: RETURN VARCHAR2 IS
1112:
1113: CURSOR cApplicationNumber IS
1114: SELECT application_number
1115: FROM ar_cmgt_credit_requests
1116: WHERE credit_request_id = p_credit_request_id;
1117:
1118: l_application_number VARCHAR2(30);
1119: BEGIN