APPS.AR_CMGT_DATA_POINTS_PKG dependencies on AR_CMGT_CREDIT_REQUESTS

Line 7: g_intended_limit_currency ar_cmgt_credit_requests.limit_currency%type;

3:
4: pg_wf_debug VARCHAR2(1) := ar_cmgt_util.get_wf_debug_flag;
5:
6: /* 9560367 */
7: g_intended_limit_currency ar_cmgt_credit_requests.limit_currency%type;
8: g_conversion_type ar_cmgt_setup_options.default_exchange_rate_type%type;
9:
10: FUNCTION get_conversion_type( p_credit_request_id IN NUMBER)
11: return VARCHAR2 IS

Line 17: from ar_cmgt_credit_requests

13: CURSOR getCreditRequestDetails (p_cr_req_id IN NUMBER)
14: IS
15: select credit_check_rule_id,
16: source_name
17: from ar_cmgt_credit_requests
18: where credit_request_id = p_cr_req_id;
19:
20:
21: CURSOR getRateTYpeFromCreditChkRule(p_cr_chk_rule_id IN NUMBER) IS

Line 1233: l_limit_currency_code ar_cmgt_credit_requests.limit_currency%type;

1229: l_rec_bal NUMBER := 0;
1230: l_file_val VARCHAR2(60);
1231: /* 9560367 */
1232: l_limit_currency_overridden boolean;
1233: l_limit_currency_code ar_cmgt_credit_requests.limit_currency%type;
1234:
1235: CURSOR RecBalC IS
1236: SELECT data_point_value
1237: FROM ar_cmgt_cf_dtls

Line 1280: FROM ar_cmgt_credit_requests

1276: BEGIN
1277: -- Now if OM is installed get credit_check_rule_id
1278: SELECT credit_check_rule_id
1279: INTO l_credit_check_rule_id
1280: FROM ar_cmgt_credit_requests
1281: WHERE credit_request_id = p_credit_request_id;
1282:
1283: IF l_credit_check_rule_id IS NULL
1284: THEN

Line 1992: FROM ar_cmgt_credit_requests

1988: market_capitalization,
1989: nvl(limit_amount, trx_amount) requested_amount,
1990: market_cap_monetary_unit,
1991: legal_entity_name
1992: FROM ar_cmgt_credit_requests
1993: WHERE credit_request_id = p_credit_request_id;
1994:
1995: CURSOR c_case_folder IS
1996: SELECT last_updated, -- last_credit_review_date

Line 5689: l_orig_limit_currency ar_cmgt_credit_requests.limit_currency%type;

5685: and as_of_date >= (sysdate -l_certified_dso_days)
5686: group by currency);
5687:
5688: l_tag VARCHAR2(50);
5689: l_orig_limit_currency ar_cmgt_credit_requests.limit_currency%type;
5690: l_wadpl NUMBER;
5691: l_apd NUMBER;
5692:
5693: -- Added by rravikir (Bug 8581475)

Line 5780: FROM ar_cmgt_credit_requests

5776: BEGIN
5777: -- Get source_information
5778: SELECT nvl(source_name, 'OCM'), nvl(source_column1, -99), limit_currency
5779: INTO g_source_name, g_source_id, l_orig_limit_currency
5780: FROM ar_cmgt_credit_requests
5781: WHERE credit_request_id = p_credit_request_id;
5782:
5783: EXCEPTION
5784: WHEN OTHERS THEN

Line 5927: update ar_cmgt_credit_requests

5923: END IF;
5924: END IF;
5925:
5926: -- update credit request with the limit currency
5927: update ar_cmgt_credit_requests
5928: set limit_currency = l_limit_currency,
5929: LAST_UPDATE_DATE = sysdate,
5930: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5931: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id