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 296: from ar_cmgt_credit_requests

292: THEN
293: BEGIN
294: select status
295: into l_parent_cr_status
296: from ar_cmgt_credit_requests
297: where credit_request_id = p_parent_credit_request_id
298: and party_id = p_party_id
299: and nvl(cust_account_id,-99) = nvl(p_cust_account_id,-99)
300: and nvl(site_use_id,-99) = nvl(p_site_use_id,-99)

Line 405: FROM ar_cmgt_credit_requests

401:
402: BEGIN
403: SELECT credit_request_id
404: INTO l_credit_request_id
405: FROM ar_cmgt_credit_requests
406: WHERE source_name = p_source_name
407: AND source_column1 = p_source_column1
408: AND party_id = p_party_id
409: AND cust_account_id = nvl(p_cust_account_id, -99)

Line 424: FROM ar_cmgt_credit_requests

420: -- get the latest credit request id
421: BEGIN
422: SELECT max(credit_request_id)
423: INTO l_credit_request_id
424: FROM ar_cmgt_credit_requests
425: WHERE source_name = p_source_name
426: AND source_column1 = p_source_column1
427: AND party_id = p_party_id
428: AND cust_account_id = nvl(p_cust_account_id, -99)

Line 494: from ar_cmgt_credit_requests

490: IF l_isupdateable = 'Y'
491: THEN
492: select trx_amount,limit_amount
493: into l_trx_amount,l_requested_amount
494: from ar_cmgt_credit_requests
495: where credit_request_id = l_credit_request_id;
496:
497: IF l_trx_amount = p_trx_amount AND
498: l_requested_amount = p_requested_amount

Line 555: SELECT AR_CMGT_APPLICATION_NUM_S.NEXTVAL, AR_CMGT_CREDIT_REQUESTS_S.NEXTVAL

551:
552: IF l_application_number IS NULL
553: AND nvl(l_sys_params_rec.auto_application_num_flag, 'N') = 'Y'
554: THEN
555: SELECT AR_CMGT_APPLICATION_NUM_S.NEXTVAL, AR_CMGT_CREDIT_REQUESTS_S.NEXTVAL
556: INTO l_application_number, l_credit_request_id
557: FROM DUAL;
558:
559: END IF;

Line 562: SELECT AR_CMGT_CREDIT_REQUESTS_S.NEXTVAL

558:
559: END IF;
560:
561: IF l_credit_request_id IS NULL THEN
562: SELECT AR_CMGT_CREDIT_REQUESTS_S.NEXTVAL
563: INTO l_credit_request_id
564: FROM dual;
565: END IF;
566:

Line 696: INSERT INTO AR_CMGT_CREDIT_REQUESTS

692: +-----------------------------------------*/
693: /* bug4414414 : Added columns parent_credit_request_id and credit_request_type
694: */
695: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
696: INSERT INTO AR_CMGT_CREDIT_REQUESTS
697: (credit_request_id,
698: last_update_date,
699: last_updated_by,
700: creation_date,

Line 912: FROM ar_cmgt_credit_requests

908: RETURN VARCHAR2 IS
909:
910: CURSOR cApplicationNumber IS
911: SELECT application_number
912: FROM ar_cmgt_credit_requests
913: WHERE credit_request_id = p_credit_request_id;
914:
915: l_application_number VARCHAR2(30);
916: BEGIN