eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OCM_CREDIT_REQUEST_UPDATE_PUB dependencies on AR_CMGT_CREDIT_REQUESTS

Line 26: l_credit_request_status ar_cmgt_credit_requests.status%type;

22: p_credit_request_rec IN credit_request_rec ) IS
23:
24: l_conc_request_id NUMBER;
25: l_status VARCHAR2(2000);
26: l_credit_request_status ar_cmgt_credit_requests.status%type;
27: l_resultout VARCHAR2(2000);
28: itemtype VARCHAR2(30) := 'ARCMGTAP';
29: itemkey VARCHAR2(30);
30: l_check_flag VARCHAr2(60);

Line 61: FROM ar_cmgt_credit_requests

57: IF p_credit_request_rec.credit_request_id IS NOT NULL
58: THEN
59: SELECT STATUS
60: INTO l_credit_request_status
61: FROM ar_cmgt_credit_requests
62: WHERE credit_request_id = p_credit_request_rec.credit_request_id;
63: END IF;
64: ElSE
65: l_credit_request_status := p_credit_request_rec.credit_request_status;

Line 70: UPDATE ar_cmgt_credit_requests

66: END IF;
67: IF l_credit_request_status IN ( 'SUBMIT', 'IN_PROCESS' )
68: THEN
69:
70: UPDATE ar_cmgt_credit_requests
71: SET trx_amount = nvl(p_credit_request_rec.trx_amount, trx_amount),
72: limit_amount = nvl(p_credit_request_rec.requested_amount, limit_amount),
73: requestor_id = nvl(p_credit_request_rec.requestor_id, requestor_id),
74: last_updated_by = fnd_global.user_id,

Line 187: UPDATE ar_cmgt_credit_requests

183: return;
184:
185: END;
186: END IF;
187: UPDATE ar_cmgt_credit_requests
188: SET trx_amount = nvl(p_credit_request_rec.trx_amount, trx_amount),
189: limit_amount = nvl(p_credit_request_rec.requested_amount, limit_amount),
190: requestor_id = nvl(p_credit_request_rec.requestor_id, requestor_id),
191: last_updated_by = fnd_global.user_id,

Line 254: l_credit_request_id ar_cmgt_credit_requests.credit_request_id%type;

250: p_return_status OUT NOCOPY VARCHAR2,
251: p_error_msg OUT NOCOPY VARCHAR2,
252: p_credit_request_rec OUT NOCOPY credit_request_rec ) IS
253:
254: l_credit_request_id ar_cmgt_credit_requests.credit_request_id%type;
255: l_APPLICATION_NUMBER ar_cmgt_credit_requests.APPLICATION_NUMBER%type;
256: l_APPLICATION_DATE ar_cmgt_credit_requests.application_date%type;
257: l_REQUESTOR_TYPE ar_cmgt_credit_requests.requestor_type%type;
258: l_REQUESTOR_ID ar_cmgt_credit_requests.requestor_id%type;

Line 255: l_APPLICATION_NUMBER ar_cmgt_credit_requests.APPLICATION_NUMBER%type;

251: p_error_msg OUT NOCOPY VARCHAR2,
252: p_credit_request_rec OUT NOCOPY credit_request_rec ) IS
253:
254: l_credit_request_id ar_cmgt_credit_requests.credit_request_id%type;
255: l_APPLICATION_NUMBER ar_cmgt_credit_requests.APPLICATION_NUMBER%type;
256: l_APPLICATION_DATE ar_cmgt_credit_requests.application_date%type;
257: l_REQUESTOR_TYPE ar_cmgt_credit_requests.requestor_type%type;
258: l_REQUESTOR_ID ar_cmgt_credit_requests.requestor_id%type;
259: l_REVIEW_TYPE ar_cmgt_credit_requests.review_type%type;

Line 256: l_APPLICATION_DATE ar_cmgt_credit_requests.application_date%type;

252: p_credit_request_rec OUT NOCOPY credit_request_rec ) IS
253:
254: l_credit_request_id ar_cmgt_credit_requests.credit_request_id%type;
255: l_APPLICATION_NUMBER ar_cmgt_credit_requests.APPLICATION_NUMBER%type;
256: l_APPLICATION_DATE ar_cmgt_credit_requests.application_date%type;
257: l_REQUESTOR_TYPE ar_cmgt_credit_requests.requestor_type%type;
258: l_REQUESTOR_ID ar_cmgt_credit_requests.requestor_id%type;
259: l_REVIEW_TYPE ar_cmgt_credit_requests.review_type%type;
260: l_CREDIT_CLASSIFICATION ar_cmgt_credit_requests.credit_classification%type;

Line 257: l_REQUESTOR_TYPE ar_cmgt_credit_requests.requestor_type%type;

253:
254: l_credit_request_id ar_cmgt_credit_requests.credit_request_id%type;
255: l_APPLICATION_NUMBER ar_cmgt_credit_requests.APPLICATION_NUMBER%type;
256: l_APPLICATION_DATE ar_cmgt_credit_requests.application_date%type;
257: l_REQUESTOR_TYPE ar_cmgt_credit_requests.requestor_type%type;
258: l_REQUESTOR_ID ar_cmgt_credit_requests.requestor_id%type;
259: l_REVIEW_TYPE ar_cmgt_credit_requests.review_type%type;
260: l_CREDIT_CLASSIFICATION ar_cmgt_credit_requests.credit_classification%type;
261: l_CHECK_LIST_ID ar_cmgt_credit_requests.check_list_id%type;

Line 258: l_REQUESTOR_ID ar_cmgt_credit_requests.requestor_id%type;

254: l_credit_request_id ar_cmgt_credit_requests.credit_request_id%type;
255: l_APPLICATION_NUMBER ar_cmgt_credit_requests.APPLICATION_NUMBER%type;
256: l_APPLICATION_DATE ar_cmgt_credit_requests.application_date%type;
257: l_REQUESTOR_TYPE ar_cmgt_credit_requests.requestor_type%type;
258: l_REQUESTOR_ID ar_cmgt_credit_requests.requestor_id%type;
259: l_REVIEW_TYPE ar_cmgt_credit_requests.review_type%type;
260: l_CREDIT_CLASSIFICATION ar_cmgt_credit_requests.credit_classification%type;
261: l_CHECK_LIST_ID ar_cmgt_credit_requests.check_list_id%type;
262: l_CREDIT_ANALYST_ID ar_cmgt_credit_requests.credit_analyst_id%type;

Line 259: l_REVIEW_TYPE ar_cmgt_credit_requests.review_type%type;

255: l_APPLICATION_NUMBER ar_cmgt_credit_requests.APPLICATION_NUMBER%type;
256: l_APPLICATION_DATE ar_cmgt_credit_requests.application_date%type;
257: l_REQUESTOR_TYPE ar_cmgt_credit_requests.requestor_type%type;
258: l_REQUESTOR_ID ar_cmgt_credit_requests.requestor_id%type;
259: l_REVIEW_TYPE ar_cmgt_credit_requests.review_type%type;
260: l_CREDIT_CLASSIFICATION ar_cmgt_credit_requests.credit_classification%type;
261: l_CHECK_LIST_ID ar_cmgt_credit_requests.check_list_id%type;
262: l_CREDIT_ANALYST_ID ar_cmgt_credit_requests.credit_analyst_id%type;
263: l_LIMIT_AMOUNT ar_cmgt_credit_requests.limit_amount%type;

Line 260: l_CREDIT_CLASSIFICATION ar_cmgt_credit_requests.credit_classification%type;

256: l_APPLICATION_DATE ar_cmgt_credit_requests.application_date%type;
257: l_REQUESTOR_TYPE ar_cmgt_credit_requests.requestor_type%type;
258: l_REQUESTOR_ID ar_cmgt_credit_requests.requestor_id%type;
259: l_REVIEW_TYPE ar_cmgt_credit_requests.review_type%type;
260: l_CREDIT_CLASSIFICATION ar_cmgt_credit_requests.credit_classification%type;
261: l_CHECK_LIST_ID ar_cmgt_credit_requests.check_list_id%type;
262: l_CREDIT_ANALYST_ID ar_cmgt_credit_requests.credit_analyst_id%type;
263: l_LIMIT_AMOUNT ar_cmgt_credit_requests.limit_amount%type;
264: l_LIMIT_CURRENCY ar_cmgt_credit_requests.limit_currency%type;

Line 261: l_CHECK_LIST_ID ar_cmgt_credit_requests.check_list_id%type;

257: l_REQUESTOR_TYPE ar_cmgt_credit_requests.requestor_type%type;
258: l_REQUESTOR_ID ar_cmgt_credit_requests.requestor_id%type;
259: l_REVIEW_TYPE ar_cmgt_credit_requests.review_type%type;
260: l_CREDIT_CLASSIFICATION ar_cmgt_credit_requests.credit_classification%type;
261: l_CHECK_LIST_ID ar_cmgt_credit_requests.check_list_id%type;
262: l_CREDIT_ANALYST_ID ar_cmgt_credit_requests.credit_analyst_id%type;
263: l_LIMIT_AMOUNT ar_cmgt_credit_requests.limit_amount%type;
264: l_LIMIT_CURRENCY ar_cmgt_credit_requests.limit_currency%type;
265: l_TRX_AMOUNT ar_cmgt_credit_requests.trx_amount%type;

Line 262: l_CREDIT_ANALYST_ID ar_cmgt_credit_requests.credit_analyst_id%type;

258: l_REQUESTOR_ID ar_cmgt_credit_requests.requestor_id%type;
259: l_REVIEW_TYPE ar_cmgt_credit_requests.review_type%type;
260: l_CREDIT_CLASSIFICATION ar_cmgt_credit_requests.credit_classification%type;
261: l_CHECK_LIST_ID ar_cmgt_credit_requests.check_list_id%type;
262: l_CREDIT_ANALYST_ID ar_cmgt_credit_requests.credit_analyst_id%type;
263: l_LIMIT_AMOUNT ar_cmgt_credit_requests.limit_amount%type;
264: l_LIMIT_CURRENCY ar_cmgt_credit_requests.limit_currency%type;
265: l_TRX_AMOUNT ar_cmgt_credit_requests.trx_amount%type;
266: l_TRX_CURRENCY ar_cmgt_credit_requests.trx_currency%type;

Line 263: l_LIMIT_AMOUNT ar_cmgt_credit_requests.limit_amount%type;

259: l_REVIEW_TYPE ar_cmgt_credit_requests.review_type%type;
260: l_CREDIT_CLASSIFICATION ar_cmgt_credit_requests.credit_classification%type;
261: l_CHECK_LIST_ID ar_cmgt_credit_requests.check_list_id%type;
262: l_CREDIT_ANALYST_ID ar_cmgt_credit_requests.credit_analyst_id%type;
263: l_LIMIT_AMOUNT ar_cmgt_credit_requests.limit_amount%type;
264: l_LIMIT_CURRENCY ar_cmgt_credit_requests.limit_currency%type;
265: l_TRX_AMOUNT ar_cmgt_credit_requests.trx_amount%type;
266: l_TRX_CURRENCY ar_cmgt_credit_requests.trx_currency%type;
267: l_CREDIT_CHECK_RULE_ID ar_cmgt_credit_requests.credit_check_rule_id%type;

Line 264: l_LIMIT_CURRENCY ar_cmgt_credit_requests.limit_currency%type;

260: l_CREDIT_CLASSIFICATION ar_cmgt_credit_requests.credit_classification%type;
261: l_CHECK_LIST_ID ar_cmgt_credit_requests.check_list_id%type;
262: l_CREDIT_ANALYST_ID ar_cmgt_credit_requests.credit_analyst_id%type;
263: l_LIMIT_AMOUNT ar_cmgt_credit_requests.limit_amount%type;
264: l_LIMIT_CURRENCY ar_cmgt_credit_requests.limit_currency%type;
265: l_TRX_AMOUNT ar_cmgt_credit_requests.trx_amount%type;
266: l_TRX_CURRENCY ar_cmgt_credit_requests.trx_currency%type;
267: l_CREDIT_CHECK_RULE_ID ar_cmgt_credit_requests.credit_check_rule_id%type;
268: l_TERM_LENGTH ar_cmgt_credit_requests.term_length%type;

Line 265: l_TRX_AMOUNT ar_cmgt_credit_requests.trx_amount%type;

261: l_CHECK_LIST_ID ar_cmgt_credit_requests.check_list_id%type;
262: l_CREDIT_ANALYST_ID ar_cmgt_credit_requests.credit_analyst_id%type;
263: l_LIMIT_AMOUNT ar_cmgt_credit_requests.limit_amount%type;
264: l_LIMIT_CURRENCY ar_cmgt_credit_requests.limit_currency%type;
265: l_TRX_AMOUNT ar_cmgt_credit_requests.trx_amount%type;
266: l_TRX_CURRENCY ar_cmgt_credit_requests.trx_currency%type;
267: l_CREDIT_CHECK_RULE_ID ar_cmgt_credit_requests.credit_check_rule_id%type;
268: l_TERM_LENGTH ar_cmgt_credit_requests.term_length%type;
269: l_CREDIT_TYPE ar_cmgt_credit_requests.credit_type%type;

Line 266: l_TRX_CURRENCY ar_cmgt_credit_requests.trx_currency%type;

262: l_CREDIT_ANALYST_ID ar_cmgt_credit_requests.credit_analyst_id%type;
263: l_LIMIT_AMOUNT ar_cmgt_credit_requests.limit_amount%type;
264: l_LIMIT_CURRENCY ar_cmgt_credit_requests.limit_currency%type;
265: l_TRX_AMOUNT ar_cmgt_credit_requests.trx_amount%type;
266: l_TRX_CURRENCY ar_cmgt_credit_requests.trx_currency%type;
267: l_CREDIT_CHECK_RULE_ID ar_cmgt_credit_requests.credit_check_rule_id%type;
268: l_TERM_LENGTH ar_cmgt_credit_requests.term_length%type;
269: l_CREDIT_TYPE ar_cmgt_credit_requests.credit_type%type;
270: l_PARTY_ID ar_cmgt_credit_requests.party_id%type;

Line 267: l_CREDIT_CHECK_RULE_ID ar_cmgt_credit_requests.credit_check_rule_id%type;

263: l_LIMIT_AMOUNT ar_cmgt_credit_requests.limit_amount%type;
264: l_LIMIT_CURRENCY ar_cmgt_credit_requests.limit_currency%type;
265: l_TRX_AMOUNT ar_cmgt_credit_requests.trx_amount%type;
266: l_TRX_CURRENCY ar_cmgt_credit_requests.trx_currency%type;
267: l_CREDIT_CHECK_RULE_ID ar_cmgt_credit_requests.credit_check_rule_id%type;
268: l_TERM_LENGTH ar_cmgt_credit_requests.term_length%type;
269: l_CREDIT_TYPE ar_cmgt_credit_requests.credit_type%type;
270: l_PARTY_ID ar_cmgt_credit_requests.party_id%type;
271: l_CUST_ACCOUNT_ID ar_cmgt_credit_requests.cust_account_id%type;

Line 268: l_TERM_LENGTH ar_cmgt_credit_requests.term_length%type;

264: l_LIMIT_CURRENCY ar_cmgt_credit_requests.limit_currency%type;
265: l_TRX_AMOUNT ar_cmgt_credit_requests.trx_amount%type;
266: l_TRX_CURRENCY ar_cmgt_credit_requests.trx_currency%type;
267: l_CREDIT_CHECK_RULE_ID ar_cmgt_credit_requests.credit_check_rule_id%type;
268: l_TERM_LENGTH ar_cmgt_credit_requests.term_length%type;
269: l_CREDIT_TYPE ar_cmgt_credit_requests.credit_type%type;
270: l_PARTY_ID ar_cmgt_credit_requests.party_id%type;
271: l_CUST_ACCOUNT_ID ar_cmgt_credit_requests.cust_account_id%type;
272: l_CUST_ACCT_SITE_ID ar_cmgt_credit_requests.cust_acct_site_id%type;

Line 269: l_CREDIT_TYPE ar_cmgt_credit_requests.credit_type%type;

265: l_TRX_AMOUNT ar_cmgt_credit_requests.trx_amount%type;
266: l_TRX_CURRENCY ar_cmgt_credit_requests.trx_currency%type;
267: l_CREDIT_CHECK_RULE_ID ar_cmgt_credit_requests.credit_check_rule_id%type;
268: l_TERM_LENGTH ar_cmgt_credit_requests.term_length%type;
269: l_CREDIT_TYPE ar_cmgt_credit_requests.credit_type%type;
270: l_PARTY_ID ar_cmgt_credit_requests.party_id%type;
271: l_CUST_ACCOUNT_ID ar_cmgt_credit_requests.cust_account_id%type;
272: l_CUST_ACCT_SITE_ID ar_cmgt_credit_requests.cust_acct_site_id%type;
273: l_SITE_USE_ID ar_cmgt_credit_requests.site_use_id%type;

Line 270: l_PARTY_ID ar_cmgt_credit_requests.party_id%type;

266: l_TRX_CURRENCY ar_cmgt_credit_requests.trx_currency%type;
267: l_CREDIT_CHECK_RULE_ID ar_cmgt_credit_requests.credit_check_rule_id%type;
268: l_TERM_LENGTH ar_cmgt_credit_requests.term_length%type;
269: l_CREDIT_TYPE ar_cmgt_credit_requests.credit_type%type;
270: l_PARTY_ID ar_cmgt_credit_requests.party_id%type;
271: l_CUST_ACCOUNT_ID ar_cmgt_credit_requests.cust_account_id%type;
272: l_CUST_ACCT_SITE_ID ar_cmgt_credit_requests.cust_acct_site_id%type;
273: l_SITE_USE_ID ar_cmgt_credit_requests.site_use_id%type;
274: l_CONTACT_PARTY_ID ar_cmgt_credit_requests.contact_party_id%type;

Line 271: l_CUST_ACCOUNT_ID ar_cmgt_credit_requests.cust_account_id%type;

267: l_CREDIT_CHECK_RULE_ID ar_cmgt_credit_requests.credit_check_rule_id%type;
268: l_TERM_LENGTH ar_cmgt_credit_requests.term_length%type;
269: l_CREDIT_TYPE ar_cmgt_credit_requests.credit_type%type;
270: l_PARTY_ID ar_cmgt_credit_requests.party_id%type;
271: l_CUST_ACCOUNT_ID ar_cmgt_credit_requests.cust_account_id%type;
272: l_CUST_ACCT_SITE_ID ar_cmgt_credit_requests.cust_acct_site_id%type;
273: l_SITE_USE_ID ar_cmgt_credit_requests.site_use_id%type;
274: l_CONTACT_PARTY_ID ar_cmgt_credit_requests.contact_party_id%type;
275: l_STOCK_EXCHANGE ar_cmgt_credit_requests.stock_exchange%type;

Line 272: l_CUST_ACCT_SITE_ID ar_cmgt_credit_requests.cust_acct_site_id%type;

268: l_TERM_LENGTH ar_cmgt_credit_requests.term_length%type;
269: l_CREDIT_TYPE ar_cmgt_credit_requests.credit_type%type;
270: l_PARTY_ID ar_cmgt_credit_requests.party_id%type;
271: l_CUST_ACCOUNT_ID ar_cmgt_credit_requests.cust_account_id%type;
272: l_CUST_ACCT_SITE_ID ar_cmgt_credit_requests.cust_acct_site_id%type;
273: l_SITE_USE_ID ar_cmgt_credit_requests.site_use_id%type;
274: l_CONTACT_PARTY_ID ar_cmgt_credit_requests.contact_party_id%type;
275: l_STOCK_EXCHANGE ar_cmgt_credit_requests.stock_exchange%type;
276: l_CURRENT_STOCK_PRICE ar_cmgt_credit_requests.current_stock_price%type;

Line 273: l_SITE_USE_ID ar_cmgt_credit_requests.site_use_id%type;

269: l_CREDIT_TYPE ar_cmgt_credit_requests.credit_type%type;
270: l_PARTY_ID ar_cmgt_credit_requests.party_id%type;
271: l_CUST_ACCOUNT_ID ar_cmgt_credit_requests.cust_account_id%type;
272: l_CUST_ACCT_SITE_ID ar_cmgt_credit_requests.cust_acct_site_id%type;
273: l_SITE_USE_ID ar_cmgt_credit_requests.site_use_id%type;
274: l_CONTACT_PARTY_ID ar_cmgt_credit_requests.contact_party_id%type;
275: l_STOCK_EXCHANGE ar_cmgt_credit_requests.stock_exchange%type;
276: l_CURRENT_STOCK_PRICE ar_cmgt_credit_requests.current_stock_price%type;
277: l_STOCK_CURRENCY ar_cmgt_credit_requests.stock_currency%type;

Line 274: l_CONTACT_PARTY_ID ar_cmgt_credit_requests.contact_party_id%type;

270: l_PARTY_ID ar_cmgt_credit_requests.party_id%type;
271: l_CUST_ACCOUNT_ID ar_cmgt_credit_requests.cust_account_id%type;
272: l_CUST_ACCT_SITE_ID ar_cmgt_credit_requests.cust_acct_site_id%type;
273: l_SITE_USE_ID ar_cmgt_credit_requests.site_use_id%type;
274: l_CONTACT_PARTY_ID ar_cmgt_credit_requests.contact_party_id%type;
275: l_STOCK_EXCHANGE ar_cmgt_credit_requests.stock_exchange%type;
276: l_CURRENT_STOCK_PRICE ar_cmgt_credit_requests.current_stock_price%type;
277: l_STOCK_CURRENCY ar_cmgt_credit_requests.stock_currency%type;
278: l_MARKET_CAPITALIZATION ar_cmgt_credit_requests.market_capitalization%type;

Line 275: l_STOCK_EXCHANGE ar_cmgt_credit_requests.stock_exchange%type;

271: l_CUST_ACCOUNT_ID ar_cmgt_credit_requests.cust_account_id%type;
272: l_CUST_ACCT_SITE_ID ar_cmgt_credit_requests.cust_acct_site_id%type;
273: l_SITE_USE_ID ar_cmgt_credit_requests.site_use_id%type;
274: l_CONTACT_PARTY_ID ar_cmgt_credit_requests.contact_party_id%type;
275: l_STOCK_EXCHANGE ar_cmgt_credit_requests.stock_exchange%type;
276: l_CURRENT_STOCK_PRICE ar_cmgt_credit_requests.current_stock_price%type;
277: l_STOCK_CURRENCY ar_cmgt_credit_requests.stock_currency%type;
278: l_MARKET_CAPITALIZATION ar_cmgt_credit_requests.market_capitalization%type;
279: l_MARKET_CAP_MONETARY_UNIT ar_cmgt_credit_requests.market_cap_monetary_unit%type;

Line 276: l_CURRENT_STOCK_PRICE ar_cmgt_credit_requests.current_stock_price%type;

272: l_CUST_ACCT_SITE_ID ar_cmgt_credit_requests.cust_acct_site_id%type;
273: l_SITE_USE_ID ar_cmgt_credit_requests.site_use_id%type;
274: l_CONTACT_PARTY_ID ar_cmgt_credit_requests.contact_party_id%type;
275: l_STOCK_EXCHANGE ar_cmgt_credit_requests.stock_exchange%type;
276: l_CURRENT_STOCK_PRICE ar_cmgt_credit_requests.current_stock_price%type;
277: l_STOCK_CURRENCY ar_cmgt_credit_requests.stock_currency%type;
278: l_MARKET_CAPITALIZATION ar_cmgt_credit_requests.market_capitalization%type;
279: l_MARKET_CAP_MONETARY_UNIT ar_cmgt_credit_requests.market_cap_monetary_unit%type;
280: l_PENDING_LITIGATIONS ar_cmgt_credit_requests.pending_litigations%type;

Line 277: l_STOCK_CURRENCY ar_cmgt_credit_requests.stock_currency%type;

273: l_SITE_USE_ID ar_cmgt_credit_requests.site_use_id%type;
274: l_CONTACT_PARTY_ID ar_cmgt_credit_requests.contact_party_id%type;
275: l_STOCK_EXCHANGE ar_cmgt_credit_requests.stock_exchange%type;
276: l_CURRENT_STOCK_PRICE ar_cmgt_credit_requests.current_stock_price%type;
277: l_STOCK_CURRENCY ar_cmgt_credit_requests.stock_currency%type;
278: l_MARKET_CAPITALIZATION ar_cmgt_credit_requests.market_capitalization%type;
279: l_MARKET_CAP_MONETARY_UNIT ar_cmgt_credit_requests.market_cap_monetary_unit%type;
280: l_PENDING_LITIGATIONS ar_cmgt_credit_requests.pending_litigations%type;
281: l_BOND_RATING ar_cmgt_credit_requests.bond_rating%type;

Line 278: l_MARKET_CAPITALIZATION ar_cmgt_credit_requests.market_capitalization%type;

274: l_CONTACT_PARTY_ID ar_cmgt_credit_requests.contact_party_id%type;
275: l_STOCK_EXCHANGE ar_cmgt_credit_requests.stock_exchange%type;
276: l_CURRENT_STOCK_PRICE ar_cmgt_credit_requests.current_stock_price%type;
277: l_STOCK_CURRENCY ar_cmgt_credit_requests.stock_currency%type;
278: l_MARKET_CAPITALIZATION ar_cmgt_credit_requests.market_capitalization%type;
279: l_MARKET_CAP_MONETARY_UNIT ar_cmgt_credit_requests.market_cap_monetary_unit%type;
280: l_PENDING_LITIGATIONS ar_cmgt_credit_requests.pending_litigations%type;
281: l_BOND_RATING ar_cmgt_credit_requests.bond_rating%type;
282: l_LEGAL_ENTITY_NAME ar_cmgt_credit_requests.legal_entity_name%type;

Line 279: l_MARKET_CAP_MONETARY_UNIT ar_cmgt_credit_requests.market_cap_monetary_unit%type;

275: l_STOCK_EXCHANGE ar_cmgt_credit_requests.stock_exchange%type;
276: l_CURRENT_STOCK_PRICE ar_cmgt_credit_requests.current_stock_price%type;
277: l_STOCK_CURRENCY ar_cmgt_credit_requests.stock_currency%type;
278: l_MARKET_CAPITALIZATION ar_cmgt_credit_requests.market_capitalization%type;
279: l_MARKET_CAP_MONETARY_UNIT ar_cmgt_credit_requests.market_cap_monetary_unit%type;
280: l_PENDING_LITIGATIONS ar_cmgt_credit_requests.pending_litigations%type;
281: l_BOND_RATING ar_cmgt_credit_requests.bond_rating%type;
282: l_LEGAL_ENTITY_NAME ar_cmgt_credit_requests.legal_entity_name%type;
283: l_ENTITY_TYPE ar_cmgt_credit_requests.entity_type%type;

Line 280: l_PENDING_LITIGATIONS ar_cmgt_credit_requests.pending_litigations%type;

276: l_CURRENT_STOCK_PRICE ar_cmgt_credit_requests.current_stock_price%type;
277: l_STOCK_CURRENCY ar_cmgt_credit_requests.stock_currency%type;
278: l_MARKET_CAPITALIZATION ar_cmgt_credit_requests.market_capitalization%type;
279: l_MARKET_CAP_MONETARY_UNIT ar_cmgt_credit_requests.market_cap_monetary_unit%type;
280: l_PENDING_LITIGATIONS ar_cmgt_credit_requests.pending_litigations%type;
281: l_BOND_RATING ar_cmgt_credit_requests.bond_rating%type;
282: l_LEGAL_ENTITY_NAME ar_cmgt_credit_requests.legal_entity_name%type;
283: l_ENTITY_TYPE ar_cmgt_credit_requests.entity_type%type;
284: l_CASE_FOLDER_NUMBER ar_cmgt_credit_requests.case_folder_number%type;

Line 281: l_BOND_RATING ar_cmgt_credit_requests.bond_rating%type;

277: l_STOCK_CURRENCY ar_cmgt_credit_requests.stock_currency%type;
278: l_MARKET_CAPITALIZATION ar_cmgt_credit_requests.market_capitalization%type;
279: l_MARKET_CAP_MONETARY_UNIT ar_cmgt_credit_requests.market_cap_monetary_unit%type;
280: l_PENDING_LITIGATIONS ar_cmgt_credit_requests.pending_litigations%type;
281: l_BOND_RATING ar_cmgt_credit_requests.bond_rating%type;
282: l_LEGAL_ENTITY_NAME ar_cmgt_credit_requests.legal_entity_name%type;
283: l_ENTITY_TYPE ar_cmgt_credit_requests.entity_type%type;
284: l_CASE_FOLDER_NUMBER ar_cmgt_credit_requests.case_folder_number%type;
285: l_SCORE_MODEL_ID ar_cmgt_credit_requests.score_model_id%type;

Line 282: l_LEGAL_ENTITY_NAME ar_cmgt_credit_requests.legal_entity_name%type;

278: l_MARKET_CAPITALIZATION ar_cmgt_credit_requests.market_capitalization%type;
279: l_MARKET_CAP_MONETARY_UNIT ar_cmgt_credit_requests.market_cap_monetary_unit%type;
280: l_PENDING_LITIGATIONS ar_cmgt_credit_requests.pending_litigations%type;
281: l_BOND_RATING ar_cmgt_credit_requests.bond_rating%type;
282: l_LEGAL_ENTITY_NAME ar_cmgt_credit_requests.legal_entity_name%type;
283: l_ENTITY_TYPE ar_cmgt_credit_requests.entity_type%type;
284: l_CASE_FOLDER_NUMBER ar_cmgt_credit_requests.case_folder_number%type;
285: l_SCORE_MODEL_ID ar_cmgt_credit_requests.score_model_id%type;
286: l_STATUS ar_cmgt_credit_requests.status%type;

Line 283: l_ENTITY_TYPE ar_cmgt_credit_requests.entity_type%type;

279: l_MARKET_CAP_MONETARY_UNIT ar_cmgt_credit_requests.market_cap_monetary_unit%type;
280: l_PENDING_LITIGATIONS ar_cmgt_credit_requests.pending_litigations%type;
281: l_BOND_RATING ar_cmgt_credit_requests.bond_rating%type;
282: l_LEGAL_ENTITY_NAME ar_cmgt_credit_requests.legal_entity_name%type;
283: l_ENTITY_TYPE ar_cmgt_credit_requests.entity_type%type;
284: l_CASE_FOLDER_NUMBER ar_cmgt_credit_requests.case_folder_number%type;
285: l_SCORE_MODEL_ID ar_cmgt_credit_requests.score_model_id%type;
286: l_STATUS ar_cmgt_credit_requests.status%type;
287: l_SOURCE_NAME ar_cmgt_credit_requests.source_name%type;

Line 284: l_CASE_FOLDER_NUMBER ar_cmgt_credit_requests.case_folder_number%type;

280: l_PENDING_LITIGATIONS ar_cmgt_credit_requests.pending_litigations%type;
281: l_BOND_RATING ar_cmgt_credit_requests.bond_rating%type;
282: l_LEGAL_ENTITY_NAME ar_cmgt_credit_requests.legal_entity_name%type;
283: l_ENTITY_TYPE ar_cmgt_credit_requests.entity_type%type;
284: l_CASE_FOLDER_NUMBER ar_cmgt_credit_requests.case_folder_number%type;
285: l_SCORE_MODEL_ID ar_cmgt_credit_requests.score_model_id%type;
286: l_STATUS ar_cmgt_credit_requests.status%type;
287: l_SOURCE_NAME ar_cmgt_credit_requests.source_name%type;
288: l_SOURCE_USER_ID ar_cmgt_credit_requests.source_user_id%type;

Line 285: l_SCORE_MODEL_ID ar_cmgt_credit_requests.score_model_id%type;

281: l_BOND_RATING ar_cmgt_credit_requests.bond_rating%type;
282: l_LEGAL_ENTITY_NAME ar_cmgt_credit_requests.legal_entity_name%type;
283: l_ENTITY_TYPE ar_cmgt_credit_requests.entity_type%type;
284: l_CASE_FOLDER_NUMBER ar_cmgt_credit_requests.case_folder_number%type;
285: l_SCORE_MODEL_ID ar_cmgt_credit_requests.score_model_id%type;
286: l_STATUS ar_cmgt_credit_requests.status%type;
287: l_SOURCE_NAME ar_cmgt_credit_requests.source_name%type;
288: l_SOURCE_USER_ID ar_cmgt_credit_requests.source_user_id%type;
289: l_SOURCE_RESP_ID ar_cmgt_credit_requests.source_resp_id%type;

Line 286: l_STATUS ar_cmgt_credit_requests.status%type;

282: l_LEGAL_ENTITY_NAME ar_cmgt_credit_requests.legal_entity_name%type;
283: l_ENTITY_TYPE ar_cmgt_credit_requests.entity_type%type;
284: l_CASE_FOLDER_NUMBER ar_cmgt_credit_requests.case_folder_number%type;
285: l_SCORE_MODEL_ID ar_cmgt_credit_requests.score_model_id%type;
286: l_STATUS ar_cmgt_credit_requests.status%type;
287: l_SOURCE_NAME ar_cmgt_credit_requests.source_name%type;
288: l_SOURCE_USER_ID ar_cmgt_credit_requests.source_user_id%type;
289: l_SOURCE_RESP_ID ar_cmgt_credit_requests.source_resp_id%type;
290: l_SOURCE_RESP_APPLN_ID ar_cmgt_credit_requests.source_resp_appln_id%type;

Line 287: l_SOURCE_NAME ar_cmgt_credit_requests.source_name%type;

283: l_ENTITY_TYPE ar_cmgt_credit_requests.entity_type%type;
284: l_CASE_FOLDER_NUMBER ar_cmgt_credit_requests.case_folder_number%type;
285: l_SCORE_MODEL_ID ar_cmgt_credit_requests.score_model_id%type;
286: l_STATUS ar_cmgt_credit_requests.status%type;
287: l_SOURCE_NAME ar_cmgt_credit_requests.source_name%type;
288: l_SOURCE_USER_ID ar_cmgt_credit_requests.source_user_id%type;
289: l_SOURCE_RESP_ID ar_cmgt_credit_requests.source_resp_id%type;
290: l_SOURCE_RESP_APPLN_ID ar_cmgt_credit_requests.source_resp_appln_id%type;
291: l_SOURCE_SECURITY_GROUP_ID ar_cmgt_credit_requests.source_security_group_id%type;

Line 288: l_SOURCE_USER_ID ar_cmgt_credit_requests.source_user_id%type;

284: l_CASE_FOLDER_NUMBER ar_cmgt_credit_requests.case_folder_number%type;
285: l_SCORE_MODEL_ID ar_cmgt_credit_requests.score_model_id%type;
286: l_STATUS ar_cmgt_credit_requests.status%type;
287: l_SOURCE_NAME ar_cmgt_credit_requests.source_name%type;
288: l_SOURCE_USER_ID ar_cmgt_credit_requests.source_user_id%type;
289: l_SOURCE_RESP_ID ar_cmgt_credit_requests.source_resp_id%type;
290: l_SOURCE_RESP_APPLN_ID ar_cmgt_credit_requests.source_resp_appln_id%type;
291: l_SOURCE_SECURITY_GROUP_ID ar_cmgt_credit_requests.source_security_group_id%type;
292: l_SOURCE_ORG_ID ar_cmgt_credit_requests.source_org_id%type;

Line 289: l_SOURCE_RESP_ID ar_cmgt_credit_requests.source_resp_id%type;

285: l_SCORE_MODEL_ID ar_cmgt_credit_requests.score_model_id%type;
286: l_STATUS ar_cmgt_credit_requests.status%type;
287: l_SOURCE_NAME ar_cmgt_credit_requests.source_name%type;
288: l_SOURCE_USER_ID ar_cmgt_credit_requests.source_user_id%type;
289: l_SOURCE_RESP_ID ar_cmgt_credit_requests.source_resp_id%type;
290: l_SOURCE_RESP_APPLN_ID ar_cmgt_credit_requests.source_resp_appln_id%type;
291: l_SOURCE_SECURITY_GROUP_ID ar_cmgt_credit_requests.source_security_group_id%type;
292: l_SOURCE_ORG_ID ar_cmgt_credit_requests.source_org_id%type;
293: l_SOURCE_COLUMN1 ar_cmgt_credit_requests.source_column1%type;

Line 290: l_SOURCE_RESP_APPLN_ID ar_cmgt_credit_requests.source_resp_appln_id%type;

286: l_STATUS ar_cmgt_credit_requests.status%type;
287: l_SOURCE_NAME ar_cmgt_credit_requests.source_name%type;
288: l_SOURCE_USER_ID ar_cmgt_credit_requests.source_user_id%type;
289: l_SOURCE_RESP_ID ar_cmgt_credit_requests.source_resp_id%type;
290: l_SOURCE_RESP_APPLN_ID ar_cmgt_credit_requests.source_resp_appln_id%type;
291: l_SOURCE_SECURITY_GROUP_ID ar_cmgt_credit_requests.source_security_group_id%type;
292: l_SOURCE_ORG_ID ar_cmgt_credit_requests.source_org_id%type;
293: l_SOURCE_COLUMN1 ar_cmgt_credit_requests.source_column1%type;
294: l_SOURCE_COLUMN2 ar_cmgt_credit_requests.source_column2%type;

Line 291: l_SOURCE_SECURITY_GROUP_ID ar_cmgt_credit_requests.source_security_group_id%type;

287: l_SOURCE_NAME ar_cmgt_credit_requests.source_name%type;
288: l_SOURCE_USER_ID ar_cmgt_credit_requests.source_user_id%type;
289: l_SOURCE_RESP_ID ar_cmgt_credit_requests.source_resp_id%type;
290: l_SOURCE_RESP_APPLN_ID ar_cmgt_credit_requests.source_resp_appln_id%type;
291: l_SOURCE_SECURITY_GROUP_ID ar_cmgt_credit_requests.source_security_group_id%type;
292: l_SOURCE_ORG_ID ar_cmgt_credit_requests.source_org_id%type;
293: l_SOURCE_COLUMN1 ar_cmgt_credit_requests.source_column1%type;
294: l_SOURCE_COLUMN2 ar_cmgt_credit_requests.source_column2%type;
295: l_SOURCE_COLUMN3 ar_cmgt_credit_requests.source_column3%type;

Line 292: l_SOURCE_ORG_ID ar_cmgt_credit_requests.source_org_id%type;

288: l_SOURCE_USER_ID ar_cmgt_credit_requests.source_user_id%type;
289: l_SOURCE_RESP_ID ar_cmgt_credit_requests.source_resp_id%type;
290: l_SOURCE_RESP_APPLN_ID ar_cmgt_credit_requests.source_resp_appln_id%type;
291: l_SOURCE_SECURITY_GROUP_ID ar_cmgt_credit_requests.source_security_group_id%type;
292: l_SOURCE_ORG_ID ar_cmgt_credit_requests.source_org_id%type;
293: l_SOURCE_COLUMN1 ar_cmgt_credit_requests.source_column1%type;
294: l_SOURCE_COLUMN2 ar_cmgt_credit_requests.source_column2%type;
295: l_SOURCE_COLUMN3 ar_cmgt_credit_requests.source_column3%type;
296: l_NOTES ar_cmgt_credit_requests.notes%type;

Line 293: l_SOURCE_COLUMN1 ar_cmgt_credit_requests.source_column1%type;

289: l_SOURCE_RESP_ID ar_cmgt_credit_requests.source_resp_id%type;
290: l_SOURCE_RESP_APPLN_ID ar_cmgt_credit_requests.source_resp_appln_id%type;
291: l_SOURCE_SECURITY_GROUP_ID ar_cmgt_credit_requests.source_security_group_id%type;
292: l_SOURCE_ORG_ID ar_cmgt_credit_requests.source_org_id%type;
293: l_SOURCE_COLUMN1 ar_cmgt_credit_requests.source_column1%type;
294: l_SOURCE_COLUMN2 ar_cmgt_credit_requests.source_column2%type;
295: l_SOURCE_COLUMN3 ar_cmgt_credit_requests.source_column3%type;
296: l_NOTES ar_cmgt_credit_requests.notes%type;
297: l_REVIEW_CYCLE ar_cmgt_credit_requests.review_cycle%type;

Line 294: l_SOURCE_COLUMN2 ar_cmgt_credit_requests.source_column2%type;

290: l_SOURCE_RESP_APPLN_ID ar_cmgt_credit_requests.source_resp_appln_id%type;
291: l_SOURCE_SECURITY_GROUP_ID ar_cmgt_credit_requests.source_security_group_id%type;
292: l_SOURCE_ORG_ID ar_cmgt_credit_requests.source_org_id%type;
293: l_SOURCE_COLUMN1 ar_cmgt_credit_requests.source_column1%type;
294: l_SOURCE_COLUMN2 ar_cmgt_credit_requests.source_column2%type;
295: l_SOURCE_COLUMN3 ar_cmgt_credit_requests.source_column3%type;
296: l_NOTES ar_cmgt_credit_requests.notes%type;
297: l_REVIEW_CYCLE ar_cmgt_credit_requests.review_cycle%type;
298:

Line 295: l_SOURCE_COLUMN3 ar_cmgt_credit_requests.source_column3%type;

291: l_SOURCE_SECURITY_GROUP_ID ar_cmgt_credit_requests.source_security_group_id%type;
292: l_SOURCE_ORG_ID ar_cmgt_credit_requests.source_org_id%type;
293: l_SOURCE_COLUMN1 ar_cmgt_credit_requests.source_column1%type;
294: l_SOURCE_COLUMN2 ar_cmgt_credit_requests.source_column2%type;
295: l_SOURCE_COLUMN3 ar_cmgt_credit_requests.source_column3%type;
296: l_NOTES ar_cmgt_credit_requests.notes%type;
297: l_REVIEW_CYCLE ar_cmgt_credit_requests.review_cycle%type;
298:
299: BEGIN

Line 296: l_NOTES ar_cmgt_credit_requests.notes%type;

292: l_SOURCE_ORG_ID ar_cmgt_credit_requests.source_org_id%type;
293: l_SOURCE_COLUMN1 ar_cmgt_credit_requests.source_column1%type;
294: l_SOURCE_COLUMN2 ar_cmgt_credit_requests.source_column2%type;
295: l_SOURCE_COLUMN3 ar_cmgt_credit_requests.source_column3%type;
296: l_NOTES ar_cmgt_credit_requests.notes%type;
297: l_REVIEW_CYCLE ar_cmgt_credit_requests.review_cycle%type;
298:
299: BEGIN
300: IF pg_debug = 'Y'

Line 297: l_REVIEW_CYCLE ar_cmgt_credit_requests.review_cycle%type;

293: l_SOURCE_COLUMN1 ar_cmgt_credit_requests.source_column1%type;
294: l_SOURCE_COLUMN2 ar_cmgt_credit_requests.source_column2%type;
295: l_SOURCE_COLUMN3 ar_cmgt_credit_requests.source_column3%type;
296: l_NOTES ar_cmgt_credit_requests.notes%type;
297: l_REVIEW_CYCLE ar_cmgt_credit_requests.review_cycle%type;
298:
299: BEGIN
300: IF pg_debug = 'Y'
301: THEN

Line 394: FROM ar_cmgt_credit_requests

390: l_SOURCE_COLUMN2,
391: l_SOURCE_COLUMN3,
392: l_NOTES,
393: l_REVIEW_CYCLE
394: FROM ar_cmgt_credit_requests
395: WHERE credit_request_id = p_credit_request_id;
396:
397: IF pg_debug = 'Y'
398: THEN

Line 516: l_status ar_cmgt_credit_requests.status%type;

512: x_msg_data OUT NOCOPY VARCHAR2,
513: p_credit_request_id IN NUMBER,
514: p_credit_request_status IN VARCHAR2 DEFAULT 'SUBMIT') IS
515:
516: l_status ar_cmgt_credit_requests.status%type;
517:
518: CURSOR cCreditRequests IS
519: SELECT credit_request_id
520: FROM ar_cmgt_credit_requests

Line 520: FROM ar_cmgt_credit_requests

516: l_status ar_cmgt_credit_requests.status%type;
517:
518: CURSOR cCreditRequests IS
519: SELECT credit_request_id
520: FROM ar_cmgt_credit_requests
521: WHERE parent_credit_request_id = p_credit_request_id
522: AND status = 'SAVE';
523:
524: /* 6838491 */

Line 528: l_guar_credit_request_id ar_cmgt_credit_requests.credit_request_id%TYPE;

524: /* 6838491 */
525: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
526: l_msg_count NUMBER;
527: l_msg_data VARCHAR2(2000);
528: l_guar_credit_request_id ar_cmgt_credit_requests.credit_request_id%TYPE;
529: i NUMBER := 0;
530: datapoint_t id_type; -- table
531: guarcredreq_t id_type; -- table
532:

Line 545: ar_cmgt_credit_requests pr

541: pr.source_name parent_source_name,
542: pr.application_date parent_application_date,
543: pr.requestor_type, pr.requestor_id
544: FROM ar_cmgt_guarantor_data gd,
545: ar_cmgt_credit_requests pr
546: WHERE gd.credit_request_id = cp_credit_request_id
547: AND gd.credit_request_id = pr.credit_request_id
548: AND gd.guarantor_credit_request_id IS NULL; -- prevents duplics
549:

Line 578: FROM ar_cmgt_credit_requests

574: -- check for valid credit request id and status
575: BEGIN
576: SELECT status
577: INTO l_status
578: FROM ar_cmgt_credit_requests
579: WHERE credit_request_id = p_credit_request_id;
580:
581: EXCEPTION
582: WHEN NO_DATA_FOUND THEN

Line 599: UPDATE ar_cmgt_credit_requests

595: THEN
596: debug ( 'Updating Status to Submit anc calling WF (+)');
597: END IF;
598: -- submit workflow
599: UPDATE ar_cmgt_credit_requests
600: SET status = 'SUBMIT',
601: last_updated_by = fnd_global.user_id,
602: last_update_date = sysdate
603: WHERE credit_request_id = p_credit_request_id;

Line 719: UPDATE ar_cmgt_credit_requests

715: THEN
716: debug ( 'Submitting child credit requests '|| to_char(cCreditRequestsRec.credit_request_id));
717: END IF;
718:
719: UPDATE ar_cmgt_credit_requests
720: SET status = 'SUBMIT',
721: last_updated_by = fnd_global.user_id,
722: last_update_date = sysdate
723: WHERE credit_request_id = cCreditRequestsRec.credit_request_id;