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.OE_CREDIT_CHECK_UTIL dependencies on HZ_CREDIT_PROFILE_AMTS

Line 915: , hz_credit_profile_amts cpa

911: CURSOR dflt_global_exposure_csr IS
912: SELECT NVL(curs.global_exposure_flag,'N') global_exposure_flag
913: , curs.credit_usage_rule_set_id credit_usage_rule_set_id
914: FROM hz_credit_profiles cp
915: , hz_credit_profile_amts cpa
916: , hz_credit_usages cu
917: , hz_credit_usage_rule_sets_B curs
918: WHERE cp.organization_id = p_entity_id
919: AND cp.credit_profile_id = cpa.credit_profile_id

Line 1280: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE

1276: --------------------------------------------------------------------------------
1277: PROCEDURE GET_Single_Customer_Limit
1278: ( p_entity_id IN NUMBER
1279: , p_trx_curr_code IN
1280: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
1281: , x_limit_curr_code OUT NOCOPY
1282: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
1283: , x_trx_limit OUT NOCOPY NUMBER
1284: , x_overall_limit OUT NOCOPY NUMBER

Line 1282: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE

1278: ( p_entity_id IN NUMBER
1279: , p_trx_curr_code IN
1280: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
1281: , x_limit_curr_code OUT NOCOPY
1282: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
1283: , x_trx_limit OUT NOCOPY NUMBER
1284: , x_overall_limit OUT NOCOPY NUMBER
1285: , x_return_status OUT NOCOPY VARCHAR2
1286: )

Line 1374: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE

1370: --------------------------------------------------------------------------------
1371: PROCEDURE GET_Single_Site_Limit
1372: ( p_entity_id IN NUMBER
1373: , p_trx_curr_code IN
1374: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
1375: , x_limit_curr_code OUT NOCOPY
1376: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
1377: , x_trx_limit OUT NOCOPY NUMBER
1378: , x_overall_limit OUT NOCOPY NUMBER

Line 1376: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE

1372: ( p_entity_id IN NUMBER
1373: , p_trx_curr_code IN
1374: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
1375: , x_limit_curr_code OUT NOCOPY
1376: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
1377: , x_trx_limit OUT NOCOPY NUMBER
1378: , x_overall_limit OUT NOCOPY NUMBER
1379: , x_return_status OUT NOCOPY VARCHAR2
1380: )

Line 1472: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE

1468: --------------------------------------------------------------------------------
1469: PROCEDURE GET_multi_customer_Limit
1470: ( p_entity_id IN NUMBER
1471: , p_trx_curr_code IN
1472: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
1473: , x_limit_curr_code OUT NOCOPY
1474: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
1475: , x_trx_limit OUT NOCOPY NUMBER
1476: , x_overall_limit OUT NOCOPY NUMBER

Line 1474: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE

1470: ( p_entity_id IN NUMBER
1471: , p_trx_curr_code IN
1472: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
1473: , x_limit_curr_code OUT NOCOPY
1474: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
1475: , x_trx_limit OUT NOCOPY NUMBER
1476: , x_overall_limit OUT NOCOPY NUMBER
1477: , x_return_status OUT NOCOPY VARCHAR2
1478: , x_credit_usage_rule_set_id OUT NOCOPY NUMBER

Line 1662: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE

1658: --------------------------------------------------------------------------------
1659: PROCEDURE GET_multi_site_Limit
1660: ( p_entity_id IN NUMBER
1661: , p_trx_curr_code IN
1662: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
1663: , x_limit_curr_code OUT NOCOPY
1664: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
1665: , x_trx_limit OUT NOCOPY NUMBER
1666: , x_overall_limit OUT NOCOPY NUMBER

Line 1664: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE

1660: ( p_entity_id IN NUMBER
1661: , p_trx_curr_code IN
1662: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
1663: , x_limit_curr_code OUT NOCOPY
1664: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
1665: , x_trx_limit OUT NOCOPY NUMBER
1666: , x_overall_limit OUT NOCOPY NUMBER
1667: , x_return_status OUT NOCOPY VARCHAR2
1668: )

Line 1827: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE

1823: --------------------------------------------------------------------------------
1824: PROCEDURE GET_single_default_Limit
1825: ( p_entity_id IN NUMBER
1826: , p_trx_curr_code IN
1827: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
1828: , x_limit_curr_code OUT NOCOPY
1829: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
1830: , x_trx_limit OUT NOCOPY NUMBER
1831: , x_overall_limit OUT NOCOPY NUMBER

Line 1829: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE

1825: ( p_entity_id IN NUMBER
1826: , p_trx_curr_code IN
1827: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
1828: , x_limit_curr_code OUT NOCOPY
1829: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
1830: , x_trx_limit OUT NOCOPY NUMBER
1831: , x_overall_limit OUT NOCOPY NUMBER
1832: , x_return_status OUT NOCOPY VARCHAR2
1833: )

Line 1851: , hz_credit_profile_amts cpa

1847: , cpa.trx_credit_limit * ((100+nvl(cp.tolerance,0))/100)
1848: trx_limit
1849: , cp.credit_checking
1850: FROM hz_credit_profiles cp
1851: , hz_credit_profile_amts cpa
1852: WHERE cp.organization_id = G_ORG_ID
1853: AND cp.credit_profile_id = cpa.credit_profile_id
1854: AND cpa.currency_code = p_trx_curr_code
1855: AND cp.enable_flag = 'Y'

Line 1919: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE

1915: --------------------------------------------------------------------------------
1916: PROCEDURE GET_multi_default_Limit
1917: ( p_entity_id IN NUMBER
1918: , p_trx_curr_code IN
1919: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
1920: , x_limit_curr_code OUT NOCOPY
1921: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
1922: , x_trx_limit OUT NOCOPY NUMBER
1923: , x_overall_limit OUT NOCOPY NUMBER

Line 1921: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE

1917: ( p_entity_id IN NUMBER
1918: , p_trx_curr_code IN
1919: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
1920: , x_limit_curr_code OUT NOCOPY
1921: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
1922: , x_trx_limit OUT NOCOPY NUMBER
1923: , x_overall_limit OUT NOCOPY NUMBER
1924: , x_return_status OUT NOCOPY VARCHAR2
1925: , x_credit_usage_rule_set_id OUT NOCOPY NUMBER

Line 1950: , hz_credit_profile_amts cpa

1946: , cp.credit_checking
1947: , cu.credit_usage_rule_set_id
1948: , NVL(curs.global_exposure_flag,'N') global_exposure_flag
1949: FROM hz_credit_profiles cp
1950: , hz_credit_profile_amts cpa
1951: , hz_credit_usages cu
1952: , hz_credit_usage_rules cur
1953: , hz_credit_usage_rule_sets_B curs
1954: WHERE cp.organization_id = G_ORG_ID

Line 1987: , hz_credit_profile_amts cpa

1983: , cp.credit_checking
1984: , cu.credit_usage_rule_set_id
1985: , NVL(curs.global_exposure_flag,'N') global_exposure_flag
1986: FROM hz_credit_profiles cp
1987: , hz_credit_profile_amts cpa
1988: , hz_credit_usages cu
1989: , hz_credit_usage_rules cur
1990: , hz_credit_usage_rule_sets_B curs
1991: WHERE cp.organization_id = G_ORG_ID

Line 2122: , hz_credit_profile_amts cpa

2118: SELECT cpa.currency_code limit_curr_code
2119: , cpa.trx_credit_limit * ((100+nvl(cp.tolerance,0))/100)
2120: trx_limit
2121: FROM hz_credit_profiles cp
2122: , hz_credit_profile_amts cpa
2123: WHERE cp.item_category_id = p_category_id
2124: AND cp.credit_profile_id = cpa.credit_profile_id
2125: AND cpa.currency_code = p_trx_curr_code
2126: AND cp.enable_flag = 'Y'

Line 2194: , hz_credit_profile_amts cpa

2190: , cpa.trx_credit_limit * ((100+nvl(cp.tolerance,0))/100)
2191: trx_limit
2192: , cu.credit_usage_rule_set_id
2193: FROM hz_credit_profiles cp
2194: , hz_credit_profile_amts cpa
2195: , hz_credit_usages cu
2196: , hz_credit_usage_rules cur
2197: WHERE cp.credit_profile_id = cpa.credit_profile_id
2198: AND cpa.credit_profile_amt_id = cu.credit_profile_amt_id

Line 2222: , hz_credit_profile_amts cpa

2218: , cpa.trx_credit_limit * ((100+nvl(cp.tolerance,0))/100)
2219: trx_limit
2220: , cu.credit_usage_rule_set_id
2221: FROM hz_credit_profiles cp
2222: , hz_credit_profile_amts cpa
2223: , hz_credit_usages cu
2224: , hz_credit_usage_rules cur
2225: WHERE cp.credit_profile_id = cpa.credit_profile_id
2226: AND cpa.credit_profile_amt_id = cu.credit_profile_amt_id

Line 2721: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE

2717: PROCEDURE Get_Multi_Limit (
2718: p_entity_type IN VARCHAR2
2719: , p_entity_id IN NUMBER
2720: , p_trx_curr_code IN
2721: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
2722: , x_limit_curr_code OUT NOCOPY
2723: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
2724: , x_trx_limit OUT NOCOPY NUMBER
2725: , x_overall_limit OUT NOCOPY NUMBER

Line 2723: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE

2719: , p_entity_id IN NUMBER
2720: , p_trx_curr_code IN
2721: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
2722: , x_limit_curr_code OUT NOCOPY
2723: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
2724: , x_trx_limit OUT NOCOPY NUMBER
2725: , x_overall_limit OUT NOCOPY NUMBER
2726: , x_global_exposure_flag OUT NOCOPY VARCHAR2
2727: --bug 4212981

Line 2940: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE

2936: PROCEDURE Get_SIngle_Limit (
2937: p_entity_type IN VARCHAR2
2938: , p_entity_id IN NUMBER
2939: , p_trx_curr_code IN
2940: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
2941: , x_limit_curr_code OUT NOCOPY
2942: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
2943: , x_trx_limit OUT NOCOPY NUMBER
2944: , x_overall_limit OUT NOCOPY NUMBER

Line 2942: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE

2938: , p_entity_id IN NUMBER
2939: , p_trx_curr_code IN
2940: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
2941: , x_limit_curr_code OUT NOCOPY
2942: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
2943: , x_trx_limit OUT NOCOPY NUMBER
2944: , x_overall_limit OUT NOCOPY NUMBER
2945: , x_default_limit_flag OUT NOCOPY VARCHAR2
2946: )

Line 3034: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE

3030: PROCEDURE Get_Usages (
3031: p_entity_type IN VARCHAR2
3032: , p_entity_id IN NUMBER
3033: , p_limit_curr_code IN
3034: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
3035: , p_suppress_unused_usages_flag IN VARCHAR2 := 'N'
3036: , p_default_limit_flag IN VARCHAR2 := 'N'
3037: , p_global_exposure_flag IN VARCHAR2 := 'N'
3038: , x_include_all_flag OUT NOCOPY VARCHAR2

Line 3092: hz_credit_profile_amts amt

3088: CURSOR dflt_rule_set_csr IS
3089: SELECT credit_usage_rule_set_id
3090: FROM hz_credit_usages usg,
3091: hz_credit_profiles prf,
3092: hz_credit_profile_amts amt
3093: WHERE usg.credit_profile_amt_id = amt.credit_profile_amt_id
3094: AND prf.credit_profile_id = amt.credit_profile_id
3095: AND amt.currency_code = p_limit_curr_code
3096: AND prf.organization_id = G_ORG_ID ;

Line 11537: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE

11533: , p_entity_id IN NUMBER
11534: , p_cust_account_id IN NUMBER
11535: , p_party_id IN NUMBER
11536: , p_trx_curr_code IN
11537: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
11538: , p_suppress_unused_usages_flag IN VARCHAR2 := 'N'
11539: , p_navigate_to_next_level IN VARCHAR2 := 'Y'
11540: , p_precalc_exposure_used IN VARCHAR2 := 'N'
11541: , x_limit_curr_code OUT NOCOPY

Line 11542: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE

11538: , p_suppress_unused_usages_flag IN VARCHAR2 := 'N'
11539: , p_navigate_to_next_level IN VARCHAR2 := 'Y'
11540: , p_precalc_exposure_used IN VARCHAR2 := 'N'
11541: , x_limit_curr_code OUT NOCOPY
11542: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
11543: , x_trx_limit OUT NOCOPY NUMBER
11544: , x_overall_limit OUT NOCOPY NUMBER
11545: , x_include_all_flag OUT NOCOPY VARCHAR2
11546: , x_usage_curr_tbl OUT NOCOPY