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_RPT dependencies on OE_CREDIT_ENGINE_GRP

Line 613: OE_Credit_Engine_GRP.Check_Credit

609: -- Retreive the header ID into output variable
610: --
611: DBMS_SQL.COLUMN_VALUE(v_release_cursorID, 1, f_release_header_id);
612: OE_DEBUG_PUB.ADD('f_release_header_id = '|| f_release_header_id,4);
613: OE_Credit_Engine_GRP.Check_Credit
614: ( p_header_id => f_release_header_id
615: , p_calling_action => 'AUTO RELEASE'
616: , x_msg_count => l_msg_count
617: , x_msg_data => l_msg_data

Line 658: OE_Credit_Engine_GRP.Check_Credit

654: -- Retreive the header ID into output variable
655: --
656: DBMS_SQL.COLUMN_VALUE(v_hold_cursorID, 1, f_hold_header_id);
657: OE_DEBUG_PUB.ADD('f_hold_header_id = '|| f_hold_header_id,4);
658: OE_Credit_Engine_GRP.Check_Credit
659: ( p_header_id => f_hold_header_id
660: , p_calling_action => 'AUTO HOLD'
661: , x_msg_count => l_msg_count
662: , x_msg_data => l_msg_data

Line 727: OE_Credit_Engine_GRP.Check_Credit

723: -- Retreive the header ID into output variable
724: --
725: DBMS_SQL.COLUMN_VALUE(v_release_cursorID, 1, f_release_header_id);
726: OE_DEBUG_PUB.ADD('f_release_header_id = '|| f_release_header_id,4);
727: OE_Credit_Engine_GRP.Check_Credit
728: ( p_header_id => f_release_header_id
729: , p_calling_action => 'AUTO RELEASE'
730: , x_msg_count => l_msg_count
731: , x_msg_data => l_msg_data

Line 770: OE_Credit_Engine_GRP.Check_Credit

766: -- Retreive the header ID into output variable
767: --
768: DBMS_SQL.COLUMN_VALUE(v_hold_cursorID, 1, f_hold_header_id);
769: OE_DEBUG_PUB.ADD('f_hold_header_id = '|| f_hold_header_id,4);
770: OE_Credit_Engine_GRP.Check_Credit
771: ( p_header_id => f_hold_header_id
772: , p_calling_action => 'AUTO HOLD'
773: , x_msg_count => l_msg_count
774: , x_msg_data => l_msg_data

Line 814: OE_Credit_Engine_GRP.Check_Credit

810: -- Call twice: once to release holds and once to place holds. This is not ideal, but we will
811: -- separate out the release and hold now.
812: -- Future: should give option to user to determine if program should place or release holds,
813: -- not both.
814: OE_Credit_Engine_GRP.Check_Credit
815: ( p_header_id => p_header_id
816: , p_calling_action => 'AUTO RELEASE'
817: , x_msg_count => l_msg_count
818: , x_msg_data => l_msg_data

Line 842: OE_Credit_Engine_GRP.Check_Credit

838: Insert_In_Temp_Table(p_header_id, 'ERROR');
839: END IF;
840: OE_DEBUG_PUB.ADD('Release: Right after inserting into temp table');
841:
842: OE_Credit_Engine_GRP.Check_Credit
843: ( p_header_id => p_header_id
844: , p_calling_action => 'AUTO HOLD'
845: , x_msg_count => l_msg_count
846: , x_msg_data => l_msg_data

Line 976: TO_CHAR(OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT));

972: -----Party level-------
973: IF p_party_id IS NOT NULL AND p_customer_id IS NULL
974: THEN
975: OE_DEBUG_PUB.ADD('global table has rows= '||
976: TO_CHAR(OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT));
977:
978: ----get unchecked usages
979: ---put checked currencies in one string with # as separator
980: FOR i in 1..OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT

Line 980: FOR i in 1..OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT

976: TO_CHAR(OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT));
977:
978: ----get unchecked usages
979: ---put checked currencies in one string with # as separator
980: FOR i in 1..OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT
981: LOOP
982:
983: l_checked_curr_rec:=l_checked_curr_rec || l_seperator
984: || OE_Credit_Engine_GRP.G_cust_curr_tbl(i).usage_curr_code;

Line 984: || OE_Credit_Engine_GRP.G_cust_curr_tbl(i).usage_curr_code;

980: FOR i in 1..OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT
981: LOOP
982:
983: l_checked_curr_rec:=l_checked_curr_rec || l_seperator
984: || OE_Credit_Engine_GRP.G_cust_curr_tbl(i).usage_curr_code;
985:
986: END LOOP;
987:
988: ----build table for unchecked currencies

Line 991: IF OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT=0

987:
988: ----build table for unchecked currencies
989:
990: ---if there are no usage currencies
991: IF OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT=0
992: THEN
993: ---build the table for all currencies
994: OE_DEBUG_PUB.ADD('Build table for all currencies as unchecked');
995:

Line 1130: TO_CHAR(OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT));

1126: ----Customer level
1127: ELSIF p_site_id IS NULL AND p_party_id IS NULL
1128: THEN
1129: OE_DEBUG_PUB.ADD('global table has rows= '||
1130: TO_CHAR(OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT));
1131:
1132: ----get unchecked usages
1133: ---put checked currencies in one string with # as separator
1134: FOR i in 1..OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT

Line 1134: FOR i in 1..OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT

1130: TO_CHAR(OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT));
1131:
1132: ----get unchecked usages
1133: ---put checked currencies in one string with # as separator
1134: FOR i in 1..OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT
1135: LOOP
1136:
1137: l_checked_curr_rec:=l_checked_curr_rec || l_seperator
1138: || OE_Credit_Engine_GRP.G_cust_curr_tbl(i).usage_curr_code;

Line 1138: || OE_Credit_Engine_GRP.G_cust_curr_tbl(i).usage_curr_code;

1134: FOR i in 1..OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT
1135: LOOP
1136:
1137: l_checked_curr_rec:=l_checked_curr_rec || l_seperator
1138: || OE_Credit_Engine_GRP.G_cust_curr_tbl(i).usage_curr_code;
1139:
1140: END LOOP;
1141:
1142: ----build table for unchecked currencies

Line 1145: IF OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT=0

1141:
1142: ----build table for unchecked currencies
1143:
1144: ---if there are no usage currencies
1145: IF OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT=0
1146: THEN
1147: ---build the table for all currencies
1148: OE_DEBUG_PUB.ADD('Build table for all currencies as unchecked');
1149:

Line 1358: TO_CHAR(OE_Credit_Engine_GRP.G_site_curr_tbl.COUNT));

1354: ELSIF p_site_id IS NOT NULL
1355: THEN
1356:
1357: OE_DEBUG_PUB.ADD('global table has rows= '||
1358: TO_CHAR(OE_Credit_Engine_GRP.G_site_curr_tbl.COUNT));
1359: ----get unchecked usages
1360: ---put checked currencies in one string with # as separator
1361: FOR i in 1..OE_CREDIT_ENGINE_GRP.G_site_curr_tbl.COUNT
1362: LOOP

Line 1361: FOR i in 1..OE_CREDIT_ENGINE_GRP.G_site_curr_tbl.COUNT

1357: OE_DEBUG_PUB.ADD('global table has rows= '||
1358: TO_CHAR(OE_Credit_Engine_GRP.G_site_curr_tbl.COUNT));
1359: ----get unchecked usages
1360: ---put checked currencies in one string with # as separator
1361: FOR i in 1..OE_CREDIT_ENGINE_GRP.G_site_curr_tbl.COUNT
1362: LOOP
1363: l_checked_curr_rec:=l_checked_curr_rec || l_seperator || OE_CREDIT_ENGINE_GRP.G_site_curr_tbl(i).usage_curr_code;
1364: END LOOP;
1365:

Line 1363: l_checked_curr_rec:=l_checked_curr_rec || l_seperator || OE_CREDIT_ENGINE_GRP.G_site_curr_tbl(i).usage_curr_code;

1359: ----get unchecked usages
1360: ---put checked currencies in one string with # as separator
1361: FOR i in 1..OE_CREDIT_ENGINE_GRP.G_site_curr_tbl.COUNT
1362: LOOP
1363: l_checked_curr_rec:=l_checked_curr_rec || l_seperator || OE_CREDIT_ENGINE_GRP.G_site_curr_tbl(i).usage_curr_code;
1364: END LOOP;
1365:
1366: ----build table for unchecked currencies
1367:

Line 1369: IF OE_Credit_Engine_GRP.G_site_curr_tbl.COUNT=0

1365:
1366: ----build table for unchecked currencies
1367:
1368: ---if there are no usage currencies
1369: IF OE_Credit_Engine_GRP.G_site_curr_tbl.COUNT=0
1370: THEN
1371: ---build the table for all currencies
1372: OE_DEBUG_PUB.ADD('Build table for all currencies as unchecked');
1373:

Line 2019: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;

2015:
2016: -- 5212830
2017:
2018: ----Empty global variables
2019: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;
2020: OE_Credit_Engine_GRP.G_cust_incl_all_flag:='N';
2021:
2022: ----start loop for party credit profiles
2023:

Line 2020: OE_Credit_Engine_GRP.G_cust_incl_all_flag:='N';

2016: -- 5212830
2017:
2018: ----Empty global variables
2019: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;
2020: OE_Credit_Engine_GRP.G_cust_incl_all_flag:='N';
2021:
2022: ----start loop for party credit profiles
2023:
2024:

Line 2029: OE_CREDIT_ENGINE_GRP.Get_Customer_Exposure

2025:
2026: FOR party_prof_csr_rec IN party_prof_csr(p_party_id=>party_csr_rec.party_id)
2027: LOOP
2028: ------calculate party credit exposure
2029: OE_CREDIT_ENGINE_GRP.Get_Customer_Exposure
2030: ( p_party_id => party_csr_rec.party_id
2031: , p_customer_id => NULL
2032: , p_site_id => NULL
2033: , p_limit_curr_code => party_prof_csr_rec.party_currency_code

Line 2184: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'

2180:
2181: ----calculate unchecked exposure
2182: ----if global variable G_cust_incl_all_flag is 'Y'
2183: ----then unchecked exposure will be 0
2184: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'
2185: THEN
2186: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_cust_incl_all_flag=Y,
2187: so l_party_unchk_exposure=0');
2188: l_party_unchk_exposure:=0;

Line 2186: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_cust_incl_all_flag=Y,

2182: ----if global variable G_cust_incl_all_flag is 'Y'
2183: ----then unchecked exposure will be 0
2184: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'
2185: THEN
2186: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_cust_incl_all_flag=Y,
2187: so l_party_unchk_exposure=0');
2188: l_party_unchk_exposure:=0;
2189: ELSE
2190: OE_DEBUG_PUB.ADD('IN Get_unchecked_exposure for the party: '

Line 2362: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;

2358: FOR party_hier_csr_rec IN party_hier_csr
2359: LOOP
2360:
2361: ----Empty global variables
2362: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;
2363: OE_Credit_Engine_GRP.G_cust_incl_all_flag:='N';
2364:
2365: ----start loop for party credit profiles
2366: FOR party_prof_csr_rec IN party_prof_csr(p_party_id=>party_hier_csr_rec.party_id)

Line 2363: OE_Credit_Engine_GRP.G_cust_incl_all_flag:='N';

2359: LOOP
2360:
2361: ----Empty global variables
2362: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;
2363: OE_Credit_Engine_GRP.G_cust_incl_all_flag:='N';
2364:
2365: ----start loop for party credit profiles
2366: FOR party_prof_csr_rec IN party_prof_csr(p_party_id=>party_hier_csr_rec.party_id)
2367: LOOP

Line 2369: OE_CREDIT_ENGINE_GRP.Get_Customer_Exposure

2365: ----start loop for party credit profiles
2366: FOR party_prof_csr_rec IN party_prof_csr(p_party_id=>party_hier_csr_rec.party_id)
2367: LOOP
2368: ------calculate party credit exposure
2369: OE_CREDIT_ENGINE_GRP.Get_Customer_Exposure
2370: ( p_party_id => party_hier_csr_rec.party_id
2371: , p_customer_id => NULL
2372: , p_site_id => NULL
2373: , p_limit_curr_code => party_prof_csr_rec.party_currency_code

Line 2523: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'

2519:
2520: ----calculate unchecked exposure
2521: ----if global variable G_cust_incl_all_flag is 'Y'
2522: ----then unchecked exposure will be 0
2523: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'
2524: THEN
2525: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_cust_incl_all_flag=Y,
2526: so l_party_unchk_exposure=0');
2527: l_party_unchk_exposure:=0;

Line 2525: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_cust_incl_all_flag=Y,

2521: ----if global variable G_cust_incl_all_flag is 'Y'
2522: ----then unchecked exposure will be 0
2523: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'
2524: THEN
2525: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_cust_incl_all_flag=Y,
2526: so l_party_unchk_exposure=0');
2527: l_party_unchk_exposure:=0;
2528: ELSE
2529: OE_DEBUG_PUB.ADD('IN Get_unchecked_exposure for the party: '

Line 2653: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;

2649: FOR party_cust_csr_rec IN party_cust_csr (p_party_id => party_hier_csr_rec.party_id)
2650: LOOP
2651:
2652: ----Empty global variables
2653: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;
2654: OE_Credit_Engine_GRP.G_cust_incl_all_flag:='N';
2655:
2656: ----start loop for customer credit profiles
2657: FOR cust_prof_csr_rec IN cust_prof_csr(p_customer_id=>party_cust_csr_rec.customer_id)

Line 2654: OE_Credit_Engine_GRP.G_cust_incl_all_flag:='N';

2650: LOOP
2651:
2652: ----Empty global variables
2653: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;
2654: OE_Credit_Engine_GRP.G_cust_incl_all_flag:='N';
2655:
2656: ----start loop for customer credit profiles
2657: FOR cust_prof_csr_rec IN cust_prof_csr(p_customer_id=>party_cust_csr_rec.customer_id)
2658: LOOP

Line 2660: OE_CREDIT_ENGINE_GRP.Get_Customer_Exposure

2656: ----start loop for customer credit profiles
2657: FOR cust_prof_csr_rec IN cust_prof_csr(p_customer_id=>party_cust_csr_rec.customer_id)
2658: LOOP
2659: ------calculate customer credit exposure
2660: OE_CREDIT_ENGINE_GRP.Get_Customer_Exposure
2661: ( p_customer_id => party_cust_csr_rec.customer_id
2662: , p_site_id => NULL
2663: , p_limit_curr_code => cust_prof_csr_rec.cust_currency_code
2664: , p_credit_check_rule_id => p_cr_check_rule_id

Line 2818: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'

2814: ----calculate unchecked exposure
2815: ----if global variable G_cust_incl_all_flag is 'Y'
2816: ----then unchecked exposure will be 0
2817:
2818: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'
2819: THEN
2820: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_cust_incl_all_flag=Y,
2821: so l_cust_unchk_exposure=0');
2822: l_cust_unchk_exposure:=0;

Line 2820: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_cust_incl_all_flag=Y,

2816: ----then unchecked exposure will be 0
2817:
2818: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'
2819: THEN
2820: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_cust_incl_all_flag=Y,
2821: so l_cust_unchk_exposure=0');
2822: l_cust_unchk_exposure:=0;
2823: ELSE
2824:

Line 2961: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;

2957: FOR party_hier_csr1_rec IN party_hier_csr1
2958: LOOP
2959:
2960: ----Empty global variables
2961: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;
2962: OE_Credit_Engine_GRP.G_cust_incl_all_flag:='N';
2963:
2964: ----start loop for party credit profiles
2965: FOR party_prof_csr_rec IN party_prof_csr(p_party_id=>party_hier_csr1_rec.party_id)

Line 2962: OE_Credit_Engine_GRP.G_cust_incl_all_flag:='N';

2958: LOOP
2959:
2960: ----Empty global variables
2961: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;
2962: OE_Credit_Engine_GRP.G_cust_incl_all_flag:='N';
2963:
2964: ----start loop for party credit profiles
2965: FOR party_prof_csr_rec IN party_prof_csr(p_party_id=>party_hier_csr1_rec.party_id)
2966: LOOP

Line 2968: OE_CREDIT_ENGINE_GRP.Get_Customer_Exposure

2964: ----start loop for party credit profiles
2965: FOR party_prof_csr_rec IN party_prof_csr(p_party_id=>party_hier_csr1_rec.party_id)
2966: LOOP
2967: ------calculate party credit exposure
2968: OE_CREDIT_ENGINE_GRP.Get_Customer_Exposure
2969: ( p_party_id => party_hier_csr1_rec.party_id
2970: , p_customer_id => NULL
2971: , p_site_id => NULL
2972: , p_limit_curr_code => party_prof_csr_rec.party_currency_code

Line 3122: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'

3118:
3119: ----calculate unchecked exposure
3120: ----if global variable G_cust_incl_all_flag is 'Y'
3121: ----then unchecked exposure will be 0
3122: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'
3123: THEN
3124: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_cust_incl_all_flag=Y,
3125: so l_party_unchk_exposure=0');
3126:

Line 3124: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_cust_incl_all_flag=Y,

3120: ----if global variable G_cust_incl_all_flag is 'Y'
3121: ----then unchecked exposure will be 0
3122: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'
3123: THEN
3124: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_cust_incl_all_flag=Y,
3125: so l_party_unchk_exposure=0');
3126:
3127: l_party_unchk_exposure:=0;
3128: ELSE

Line 3256: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;

3252: FOR party_cust_csr_rec IN party_cust_csr (p_party_id => party_hier_csr1_rec.party_id)
3253: LOOP
3254:
3255: ----Empty global variables
3256: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;
3257: OE_Credit_Engine_GRP.G_cust_incl_all_flag:='N';
3258:
3259: ----start loop for customer credit profiles
3260: FOR cust_prof_csr_rec IN cust_prof_csr(p_customer_id=>party_cust_csr_rec.customer_id)

Line 3257: OE_Credit_Engine_GRP.G_cust_incl_all_flag:='N';

3253: LOOP
3254:
3255: ----Empty global variables
3256: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;
3257: OE_Credit_Engine_GRP.G_cust_incl_all_flag:='N';
3258:
3259: ----start loop for customer credit profiles
3260: FOR cust_prof_csr_rec IN cust_prof_csr(p_customer_id=>party_cust_csr_rec.customer_id)
3261: LOOP

Line 3263: OE_CREDIT_ENGINE_GRP.Get_Customer_Exposure

3259: ----start loop for customer credit profiles
3260: FOR cust_prof_csr_rec IN cust_prof_csr(p_customer_id=>party_cust_csr_rec.customer_id)
3261: LOOP
3262: ------calculate customer credit exposure
3263: OE_CREDIT_ENGINE_GRP.Get_Customer_Exposure
3264: ( p_customer_id => party_cust_csr_rec.customer_id
3265: , p_site_id => NULL
3266: , p_limit_curr_code => cust_prof_csr_rec.cust_currency_code
3267: , p_credit_check_rule_id => p_cr_check_rule_id

Line 3419: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'

3415:
3416: ----calculate unchecked exposure
3417: ----if global variable G_cust_incl_all_flag is 'Y'
3418: ----then unchecked exposure will be 0
3419: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'
3420: THEN
3421: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_cust_incl_all_flag=Y,
3422: so l_cust_unchk_exposure=0');
3423:

Line 3421: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_cust_incl_all_flag=Y,

3417: ----if global variable G_cust_incl_all_flag is 'Y'
3418: ----then unchecked exposure will be 0
3419: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'
3420: THEN
3421: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_cust_incl_all_flag=Y,
3422: so l_cust_unchk_exposure=0');
3423:
3424: l_cust_unchk_exposure:=0;
3425: ELSE

Line 3758: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;

3754: FETCH cust_cur INTO cust_csr_rec;
3755: EXIT WHEN cust_cur%NOTFOUND;
3756:
3757: ----Empty global variables
3758: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;
3759: OE_Credit_Engine_GRP.G_cust_incl_all_flag:='N';
3760:
3761: ----start loop for customer credit profiles
3762: FOR cust_prof_csr_rec IN cust_prof_csr(p_customer_id=>cust_csr_rec.customer_id)

Line 3759: OE_Credit_Engine_GRP.G_cust_incl_all_flag:='N';

3755: EXIT WHEN cust_cur%NOTFOUND;
3756:
3757: ----Empty global variables
3758: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;
3759: OE_Credit_Engine_GRP.G_cust_incl_all_flag:='N';
3760:
3761: ----start loop for customer credit profiles
3762: FOR cust_prof_csr_rec IN cust_prof_csr(p_customer_id=>cust_csr_rec.customer_id)
3763: LOOP

Line 3765: OE_CREDIT_ENGINE_GRP.Get_Customer_Exposure

3761: ----start loop for customer credit profiles
3762: FOR cust_prof_csr_rec IN cust_prof_csr(p_customer_id=>cust_csr_rec.customer_id)
3763: LOOP
3764: ------calculate customer credit exposure
3765: OE_CREDIT_ENGINE_GRP.Get_Customer_Exposure
3766: ( p_customer_id => cust_csr_rec.customer_id
3767: , p_site_id => NULL
3768: , p_limit_curr_code => cust_prof_csr_rec.cust_currency_code
3769: , p_credit_check_rule_id => p_cr_check_rule_id

Line 3920: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'

3916:
3917: ----calculate unchecked exposure
3918: ----if global variable G_cust_incl_all_flag is 'Y'
3919: ----then unchecked exposure will be 0
3920: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'
3921: THEN
3922: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_cust_incl_all_flag=Y,
3923: so l_cust_unchk_exposure=0');
3924:

Line 3922: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_cust_incl_all_flag=Y,

3918: ----if global variable G_cust_incl_all_flag is 'Y'
3919: ----then unchecked exposure will be 0
3920: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'
3921: THEN
3922: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_cust_incl_all_flag=Y,
3923: so l_cust_unchk_exposure=0');
3924:
3925: l_cust_unchk_exposure:=0;
3926: ELSE

Line 4055: OE_Credit_Engine_GRP.G_site_curr_tbl:=l_empty_curr_tbl;

4051: FOR site_csr_rec IN site_csr(cust_csr_rec.customer_id)
4052: LOOP
4053:
4054: ----Empty global variables
4055: OE_Credit_Engine_GRP.G_site_curr_tbl:=l_empty_curr_tbl;
4056: OE_Credit_Engine_GRP.G_site_incl_all_flag:='N';
4057:
4058:
4059: ----start loop for bill-to site credit profiles

Line 4056: OE_Credit_Engine_GRP.G_site_incl_all_flag:='N';

4052: LOOP
4053:
4054: ----Empty global variables
4055: OE_Credit_Engine_GRP.G_site_curr_tbl:=l_empty_curr_tbl;
4056: OE_Credit_Engine_GRP.G_site_incl_all_flag:='N';
4057:
4058:
4059: ----start loop for bill-to site credit profiles
4060: FOR site_prof_csr_rec IN site_prof_csr( p_customer_id => cust_csr_rec.customer_id

Line 4067: OE_CREDIT_ENGINE_GRP.Get_Customer_Exposure

4063: OE_DEBUG_PUB.ADD('IN loop for bill-to sites ');
4064: OE_DEBUG_PUB.ADD('Processing site '||site_csr_rec.Customer_site);
4065:
4066: ------calculate bill-to site credit exposure
4067: OE_CREDIT_ENGINE_GRP.Get_Customer_Exposure
4068: ( p_customer_id => cust_csr_rec.customer_id
4069: , p_site_id => site_csr_rec.site_id
4070: , p_limit_curr_code => site_prof_csr_rec.site_currency_code
4071: , p_credit_check_rule_id => p_cr_check_rule_id

Line 4198: IF OE_Credit_Engine_GRP.G_site_incl_all_flag='Y'

4194: ----calculate unchecked exposure for bill-to site
4195: ----if global variable for include_all_flag is 'Y'
4196: ----then unchecked_exposure will be 0
4197:
4198: IF OE_Credit_Engine_GRP.G_site_incl_all_flag='Y'
4199: THEN
4200: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_site_incl_all_flag='
4201: ||OE_Credit_Engine_GRP.G_site_incl_all_flag
4202: ||'so l_site_unchk_exposure=0');

Line 4200: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_site_incl_all_flag='

4196: ----then unchecked_exposure will be 0
4197:
4198: IF OE_Credit_Engine_GRP.G_site_incl_all_flag='Y'
4199: THEN
4200: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_site_incl_all_flag='
4201: ||OE_Credit_Engine_GRP.G_site_incl_all_flag
4202: ||'so l_site_unchk_exposure=0');
4203:
4204: l_site_unchk_exposure:=0;

Line 4201: ||OE_Credit_Engine_GRP.G_site_incl_all_flag

4197:
4198: IF OE_Credit_Engine_GRP.G_site_incl_all_flag='Y'
4199: THEN
4200: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_site_incl_all_flag='
4201: ||OE_Credit_Engine_GRP.G_site_incl_all_flag
4202: ||'so l_site_unchk_exposure=0');
4203:
4204: l_site_unchk_exposure:=0;
4205: ELSE