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 621: OE_Credit_Engine_GRP.Check_Credit

617: -- Retreive the header ID into output variable
618: --
619: DBMS_SQL.COLUMN_VALUE(v_release_cursorID, 1, f_release_header_id);
620: OE_DEBUG_PUB.ADD('f_release_header_id = '|| f_release_header_id,4);
621: OE_Credit_Engine_GRP.Check_Credit
622: ( p_header_id => f_release_header_id
623: , p_calling_action => 'AUTO RELEASE'
624: , x_msg_count => l_msg_count
625: , x_msg_data => l_msg_data

Line 666: OE_Credit_Engine_GRP.Check_Credit

662: -- Retreive the header ID into output variable
663: --
664: DBMS_SQL.COLUMN_VALUE(v_hold_cursorID, 1, f_hold_header_id);
665: OE_DEBUG_PUB.ADD('f_hold_header_id = '|| f_hold_header_id,4);
666: OE_Credit_Engine_GRP.Check_Credit
667: ( p_header_id => f_hold_header_id
668: , p_calling_action => 'AUTO HOLD'
669: , x_msg_count => l_msg_count
670: , x_msg_data => l_msg_data

Line 735: OE_Credit_Engine_GRP.Check_Credit

731: -- Retreive the header ID into output variable
732: --
733: DBMS_SQL.COLUMN_VALUE(v_release_cursorID, 1, f_release_header_id);
734: OE_DEBUG_PUB.ADD('f_release_header_id = '|| f_release_header_id,4);
735: OE_Credit_Engine_GRP.Check_Credit
736: ( p_header_id => f_release_header_id
737: , p_calling_action => 'AUTO RELEASE'
738: , x_msg_count => l_msg_count
739: , x_msg_data => l_msg_data

Line 778: OE_Credit_Engine_GRP.Check_Credit

774: -- Retreive the header ID into output variable
775: --
776: DBMS_SQL.COLUMN_VALUE(v_hold_cursorID, 1, f_hold_header_id);
777: OE_DEBUG_PUB.ADD('f_hold_header_id = '|| f_hold_header_id,4);
778: OE_Credit_Engine_GRP.Check_Credit
779: ( p_header_id => f_hold_header_id
780: , p_calling_action => 'AUTO HOLD'
781: , x_msg_count => l_msg_count
782: , x_msg_data => l_msg_data

Line 822: OE_Credit_Engine_GRP.Check_Credit

818: -- Call twice: once to release holds and once to place holds. This is not ideal, but we will
819: -- separate out the release and hold now.
820: -- Future: should give option to user to determine if program should place or release holds,
821: -- not both.
822: OE_Credit_Engine_GRP.Check_Credit
823: ( p_header_id => p_header_id
824: , p_calling_action => 'AUTO RELEASE'
825: , x_msg_count => l_msg_count
826: , x_msg_data => l_msg_data

Line 850: OE_Credit_Engine_GRP.Check_Credit

846: Insert_In_Temp_Table(p_header_id, 'ERROR');
847: END IF;
848: OE_DEBUG_PUB.ADD('Release: Right after inserting into temp table');
849:
850: OE_Credit_Engine_GRP.Check_Credit
851: ( p_header_id => p_header_id
852: , p_calling_action => 'AUTO HOLD'
853: , x_msg_count => l_msg_count
854: , x_msg_data => l_msg_data

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

980: -----Party level-------
981: IF p_party_id IS NOT NULL AND p_customer_id IS NULL
982: THEN
983: OE_DEBUG_PUB.ADD('global table has rows= '||
984: TO_CHAR(OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT));
985:
986: ----get unchecked usages
987: ---put checked currencies in one string with # as separator
988: FOR i in 1..OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT

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

984: TO_CHAR(OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT));
985:
986: ----get unchecked usages
987: ---put checked currencies in one string with # as separator
988: FOR i in 1..OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT
989: LOOP
990:
991: l_checked_curr_rec:=l_checked_curr_rec || l_seperator
992: || OE_Credit_Engine_GRP.G_cust_curr_tbl(i).usage_curr_code;

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

988: FOR i in 1..OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT
989: LOOP
990:
991: l_checked_curr_rec:=l_checked_curr_rec || l_seperator
992: || OE_Credit_Engine_GRP.G_cust_curr_tbl(i).usage_curr_code;
993:
994: END LOOP;
995:
996: ----build table for unchecked currencies

Line 999: IF OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT=0

995:
996: ----build table for unchecked currencies
997:
998: ---if there are no usage currencies
999: IF OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT=0
1000: THEN
1001: ---build the table for all currencies
1002: OE_DEBUG_PUB.ADD('Build table for all currencies as unchecked');
1003:

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

1134: ----Customer level
1135: ELSIF p_site_id IS NULL AND p_party_id IS NULL
1136: THEN
1137: OE_DEBUG_PUB.ADD('global table has rows= '||
1138: TO_CHAR(OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT));
1139:
1140: ----get unchecked usages
1141: ---put checked currencies in one string with # as separator
1142: FOR i in 1..OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT

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

1138: TO_CHAR(OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT));
1139:
1140: ----get unchecked usages
1141: ---put checked currencies in one string with # as separator
1142: FOR i in 1..OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT
1143: LOOP
1144:
1145: l_checked_curr_rec:=l_checked_curr_rec || l_seperator
1146: || OE_Credit_Engine_GRP.G_cust_curr_tbl(i).usage_curr_code;

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

1142: FOR i in 1..OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT
1143: LOOP
1144:
1145: l_checked_curr_rec:=l_checked_curr_rec || l_seperator
1146: || OE_Credit_Engine_GRP.G_cust_curr_tbl(i).usage_curr_code;
1147:
1148: END LOOP;
1149:
1150: ----build table for unchecked currencies

Line 1153: IF OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT=0

1149:
1150: ----build table for unchecked currencies
1151:
1152: ---if there are no usage currencies
1153: IF OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT=0
1154: THEN
1155: ---build the table for all currencies
1156: OE_DEBUG_PUB.ADD('Build table for all currencies as unchecked');
1157:

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

1362: ELSIF p_site_id IS NOT NULL
1363: THEN
1364:
1365: OE_DEBUG_PUB.ADD('global table has rows= '||
1366: TO_CHAR(OE_Credit_Engine_GRP.G_site_curr_tbl.COUNT));
1367: ----get unchecked usages
1368: ---put checked currencies in one string with # as separator
1369: FOR i in 1..OE_CREDIT_ENGINE_GRP.G_site_curr_tbl.COUNT
1370: LOOP

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

1365: OE_DEBUG_PUB.ADD('global table has rows= '||
1366: TO_CHAR(OE_Credit_Engine_GRP.G_site_curr_tbl.COUNT));
1367: ----get unchecked usages
1368: ---put checked currencies in one string with # as separator
1369: FOR i in 1..OE_CREDIT_ENGINE_GRP.G_site_curr_tbl.COUNT
1370: LOOP
1371: l_checked_curr_rec:=l_checked_curr_rec || l_seperator || OE_CREDIT_ENGINE_GRP.G_site_curr_tbl(i).usage_curr_code;
1372: END LOOP;
1373:

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

1367: ----get unchecked usages
1368: ---put checked currencies in one string with # as separator
1369: FOR i in 1..OE_CREDIT_ENGINE_GRP.G_site_curr_tbl.COUNT
1370: LOOP
1371: l_checked_curr_rec:=l_checked_curr_rec || l_seperator || OE_CREDIT_ENGINE_GRP.G_site_curr_tbl(i).usage_curr_code;
1372: END LOOP;
1373:
1374: ----build table for unchecked currencies
1375:

Line 1377: IF OE_Credit_Engine_GRP.G_site_curr_tbl.COUNT=0

1373:
1374: ----build table for unchecked currencies
1375:
1376: ---if there are no usage currencies
1377: IF OE_Credit_Engine_GRP.G_site_curr_tbl.COUNT=0
1378: THEN
1379: ---build the table for all currencies
1380: OE_DEBUG_PUB.ADD('Build table for all currencies as unchecked');
1381:

Line 2030: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;

2026:
2027: -- 5212830
2028:
2029: ----Empty global variables
2030: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;
2031: OE_Credit_Engine_GRP.G_cust_incl_all_flag:='N';
2032:
2033: ----start loop for party credit profiles
2034:

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

2027: -- 5212830
2028:
2029: ----Empty global variables
2030: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;
2031: OE_Credit_Engine_GRP.G_cust_incl_all_flag:='N';
2032:
2033: ----start loop for party credit profiles
2034:
2035:

Line 2040: OE_CREDIT_ENGINE_GRP.Get_Customer_Exposure

2036:
2037: FOR party_prof_csr_rec IN party_prof_csr(p_party_id=>party_csr_rec.party_id)
2038: LOOP
2039: ------calculate party credit exposure
2040: OE_CREDIT_ENGINE_GRP.Get_Customer_Exposure
2041: ( p_party_id => party_csr_rec.party_id
2042: , p_customer_id => NULL
2043: , p_site_id => NULL
2044: , p_limit_curr_code => party_prof_csr_rec.party_currency_code

Line 2195: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'

2191:
2192: ----calculate unchecked exposure
2193: ----if global variable G_cust_incl_all_flag is 'Y'
2194: ----then unchecked exposure will be 0
2195: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'
2196: THEN
2197: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_cust_incl_all_flag=Y,
2198: so l_party_unchk_exposure=0');
2199: l_party_unchk_exposure:=0;

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

2193: ----if global variable G_cust_incl_all_flag is 'Y'
2194: ----then unchecked exposure will be 0
2195: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'
2196: THEN
2197: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_cust_incl_all_flag=Y,
2198: so l_party_unchk_exposure=0');
2199: l_party_unchk_exposure:=0;
2200: ELSE
2201: OE_DEBUG_PUB.ADD('IN Get_unchecked_exposure for the party: '

Line 2374: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;

2370: FOR party_hier_csr_rec IN party_hier_csr
2371: LOOP
2372:
2373: ----Empty global variables
2374: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;
2375: OE_Credit_Engine_GRP.G_cust_incl_all_flag:='N';
2376:
2377: ----start loop for party credit profiles
2378: FOR party_prof_csr_rec IN party_prof_csr(p_party_id=>party_hier_csr_rec.party_id)

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

2371: LOOP
2372:
2373: ----Empty global variables
2374: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;
2375: OE_Credit_Engine_GRP.G_cust_incl_all_flag:='N';
2376:
2377: ----start loop for party credit profiles
2378: FOR party_prof_csr_rec IN party_prof_csr(p_party_id=>party_hier_csr_rec.party_id)
2379: LOOP

Line 2381: OE_CREDIT_ENGINE_GRP.Get_Customer_Exposure

2377: ----start loop for party credit profiles
2378: FOR party_prof_csr_rec IN party_prof_csr(p_party_id=>party_hier_csr_rec.party_id)
2379: LOOP
2380: ------calculate party credit exposure
2381: OE_CREDIT_ENGINE_GRP.Get_Customer_Exposure
2382: ( p_party_id => party_hier_csr_rec.party_id
2383: , p_customer_id => NULL
2384: , p_site_id => NULL
2385: , p_limit_curr_code => party_prof_csr_rec.party_currency_code

Line 2535: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'

2531:
2532: ----calculate unchecked exposure
2533: ----if global variable G_cust_incl_all_flag is 'Y'
2534: ----then unchecked exposure will be 0
2535: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'
2536: THEN
2537: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_cust_incl_all_flag=Y,
2538: so l_party_unchk_exposure=0');
2539: l_party_unchk_exposure:=0;

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

2533: ----if global variable G_cust_incl_all_flag is 'Y'
2534: ----then unchecked exposure will be 0
2535: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'
2536: THEN
2537: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_cust_incl_all_flag=Y,
2538: so l_party_unchk_exposure=0');
2539: l_party_unchk_exposure:=0;
2540: ELSE
2541: OE_DEBUG_PUB.ADD('IN Get_unchecked_exposure for the party: '

Line 2666: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;

2662: FOR party_cust_csr_rec IN party_cust_csr (p_party_id => party_hier_csr_rec.party_id)
2663: LOOP
2664:
2665: ----Empty global variables
2666: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;
2667: OE_Credit_Engine_GRP.G_cust_incl_all_flag:='N';
2668:
2669: ----start loop for customer credit profiles
2670: FOR cust_prof_csr_rec IN cust_prof_csr(p_customer_id=>party_cust_csr_rec.customer_id)

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

2663: LOOP
2664:
2665: ----Empty global variables
2666: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;
2667: OE_Credit_Engine_GRP.G_cust_incl_all_flag:='N';
2668:
2669: ----start loop for customer credit profiles
2670: FOR cust_prof_csr_rec IN cust_prof_csr(p_customer_id=>party_cust_csr_rec.customer_id)
2671: LOOP

Line 2673: OE_CREDIT_ENGINE_GRP.Get_Customer_Exposure

2669: ----start loop for customer credit profiles
2670: FOR cust_prof_csr_rec IN cust_prof_csr(p_customer_id=>party_cust_csr_rec.customer_id)
2671: LOOP
2672: ------calculate customer credit exposure
2673: OE_CREDIT_ENGINE_GRP.Get_Customer_Exposure
2674: ( p_customer_id => party_cust_csr_rec.customer_id
2675: , p_site_id => NULL
2676: , p_limit_curr_code => cust_prof_csr_rec.cust_currency_code
2677: , p_credit_check_rule_id => p_cr_check_rule_id

Line 2831: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'

2827: ----calculate unchecked exposure
2828: ----if global variable G_cust_incl_all_flag is 'Y'
2829: ----then unchecked exposure will be 0
2830:
2831: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'
2832: THEN
2833: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_cust_incl_all_flag=Y,
2834: so l_cust_unchk_exposure=0');
2835: l_cust_unchk_exposure:=0;

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

2829: ----then unchecked exposure will be 0
2830:
2831: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'
2832: THEN
2833: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_cust_incl_all_flag=Y,
2834: so l_cust_unchk_exposure=0');
2835: l_cust_unchk_exposure:=0;
2836: ELSE
2837:

Line 2975: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;

2971: FOR party_hier_csr1_rec IN party_hier_csr1
2972: LOOP
2973:
2974: ----Empty global variables
2975: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;
2976: OE_Credit_Engine_GRP.G_cust_incl_all_flag:='N';
2977:
2978: ----start loop for party credit profiles
2979: FOR party_prof_csr_rec IN party_prof_csr(p_party_id=>party_hier_csr1_rec.party_id)

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

2972: LOOP
2973:
2974: ----Empty global variables
2975: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;
2976: OE_Credit_Engine_GRP.G_cust_incl_all_flag:='N';
2977:
2978: ----start loop for party credit profiles
2979: FOR party_prof_csr_rec IN party_prof_csr(p_party_id=>party_hier_csr1_rec.party_id)
2980: LOOP

Line 2982: OE_CREDIT_ENGINE_GRP.Get_Customer_Exposure

2978: ----start loop for party credit profiles
2979: FOR party_prof_csr_rec IN party_prof_csr(p_party_id=>party_hier_csr1_rec.party_id)
2980: LOOP
2981: ------calculate party credit exposure
2982: OE_CREDIT_ENGINE_GRP.Get_Customer_Exposure
2983: ( p_party_id => party_hier_csr1_rec.party_id
2984: , p_customer_id => NULL
2985: , p_site_id => NULL
2986: , p_limit_curr_code => party_prof_csr_rec.party_currency_code

Line 3136: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'

3132:
3133: ----calculate unchecked exposure
3134: ----if global variable G_cust_incl_all_flag is 'Y'
3135: ----then unchecked exposure will be 0
3136: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'
3137: THEN
3138: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_cust_incl_all_flag=Y,
3139: so l_party_unchk_exposure=0');
3140:

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

3134: ----if global variable G_cust_incl_all_flag is 'Y'
3135: ----then unchecked exposure will be 0
3136: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'
3137: THEN
3138: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_cust_incl_all_flag=Y,
3139: so l_party_unchk_exposure=0');
3140:
3141: l_party_unchk_exposure:=0;
3142: ELSE

Line 3271: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;

3267: FOR party_cust_csr_rec IN party_cust_csr (p_party_id => party_hier_csr1_rec.party_id)
3268: LOOP
3269:
3270: ----Empty global variables
3271: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;
3272: OE_Credit_Engine_GRP.G_cust_incl_all_flag:='N';
3273:
3274: ----start loop for customer credit profiles
3275: FOR cust_prof_csr_rec IN cust_prof_csr(p_customer_id=>party_cust_csr_rec.customer_id)

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

3268: LOOP
3269:
3270: ----Empty global variables
3271: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;
3272: OE_Credit_Engine_GRP.G_cust_incl_all_flag:='N';
3273:
3274: ----start loop for customer credit profiles
3275: FOR cust_prof_csr_rec IN cust_prof_csr(p_customer_id=>party_cust_csr_rec.customer_id)
3276: LOOP

Line 3278: OE_CREDIT_ENGINE_GRP.Get_Customer_Exposure

3274: ----start loop for customer credit profiles
3275: FOR cust_prof_csr_rec IN cust_prof_csr(p_customer_id=>party_cust_csr_rec.customer_id)
3276: LOOP
3277: ------calculate customer credit exposure
3278: OE_CREDIT_ENGINE_GRP.Get_Customer_Exposure
3279: ( p_customer_id => party_cust_csr_rec.customer_id
3280: , p_site_id => NULL
3281: , p_limit_curr_code => cust_prof_csr_rec.cust_currency_code
3282: , p_credit_check_rule_id => p_cr_check_rule_id

Line 3434: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'

3430:
3431: ----calculate unchecked exposure
3432: ----if global variable G_cust_incl_all_flag is 'Y'
3433: ----then unchecked exposure will be 0
3434: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'
3435: THEN
3436: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_cust_incl_all_flag=Y,
3437: so l_cust_unchk_exposure=0');
3438:

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

3432: ----if global variable G_cust_incl_all_flag is 'Y'
3433: ----then unchecked exposure will be 0
3434: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'
3435: THEN
3436: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_cust_incl_all_flag=Y,
3437: so l_cust_unchk_exposure=0');
3438:
3439: l_cust_unchk_exposure:=0;
3440: ELSE

Line 3783: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;

3779: FETCH cust_cur INTO cust_csr_rec;
3780: EXIT WHEN cust_cur%NOTFOUND;
3781:
3782: ----Empty global variables
3783: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;
3784: OE_Credit_Engine_GRP.G_cust_incl_all_flag:='N';
3785:
3786: ----start loop for customer credit profiles
3787: FOR cust_prof_csr_rec IN cust_prof_csr(p_customer_id=>cust_csr_rec.customer_id)

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

3780: EXIT WHEN cust_cur%NOTFOUND;
3781:
3782: ----Empty global variables
3783: OE_Credit_Engine_GRP.G_cust_curr_tbl:=l_empty_curr_tbl;
3784: OE_Credit_Engine_GRP.G_cust_incl_all_flag:='N';
3785:
3786: ----start loop for customer credit profiles
3787: FOR cust_prof_csr_rec IN cust_prof_csr(p_customer_id=>cust_csr_rec.customer_id)
3788: LOOP

Line 3790: OE_CREDIT_ENGINE_GRP.Get_Customer_Exposure

3786: ----start loop for customer credit profiles
3787: FOR cust_prof_csr_rec IN cust_prof_csr(p_customer_id=>cust_csr_rec.customer_id)
3788: LOOP
3789: ------calculate customer credit exposure
3790: OE_CREDIT_ENGINE_GRP.Get_Customer_Exposure
3791: ( p_customer_id => cust_csr_rec.customer_id
3792: , p_site_id => NULL
3793: , p_limit_curr_code => cust_prof_csr_rec.cust_currency_code
3794: , p_credit_check_rule_id => p_cr_check_rule_id

Line 3945: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'

3941:
3942: ----calculate unchecked exposure
3943: ----if global variable G_cust_incl_all_flag is 'Y'
3944: ----then unchecked exposure will be 0
3945: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'
3946: THEN
3947: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_cust_incl_all_flag=Y,
3948: so l_cust_unchk_exposure=0');
3949:

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

3943: ----if global variable G_cust_incl_all_flag is 'Y'
3944: ----then unchecked exposure will be 0
3945: IF OE_Credit_Engine_GRP.G_cust_incl_all_flag='Y'
3946: THEN
3947: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_cust_incl_all_flag=Y,
3948: so l_cust_unchk_exposure=0');
3949:
3950: l_cust_unchk_exposure:=0;
3951: ELSE

Line 4081: OE_Credit_Engine_GRP.G_site_curr_tbl:=l_empty_curr_tbl;

4077: FOR site_csr_rec IN site_csr(cust_csr_rec.customer_id)
4078: LOOP
4079:
4080: ----Empty global variables
4081: OE_Credit_Engine_GRP.G_site_curr_tbl:=l_empty_curr_tbl;
4082: OE_Credit_Engine_GRP.G_site_incl_all_flag:='N';
4083:
4084:
4085: ----start loop for bill-to site credit profiles

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

4078: LOOP
4079:
4080: ----Empty global variables
4081: OE_Credit_Engine_GRP.G_site_curr_tbl:=l_empty_curr_tbl;
4082: OE_Credit_Engine_GRP.G_site_incl_all_flag:='N';
4083:
4084:
4085: ----start loop for bill-to site credit profiles
4086: FOR site_prof_csr_rec IN site_prof_csr( p_customer_id => cust_csr_rec.customer_id

Line 4093: OE_CREDIT_ENGINE_GRP.Get_Customer_Exposure

4089: OE_DEBUG_PUB.ADD('IN loop for bill-to sites ');
4090: OE_DEBUG_PUB.ADD('Processing site '||site_csr_rec.Customer_site);
4091:
4092: ------calculate bill-to site credit exposure
4093: OE_CREDIT_ENGINE_GRP.Get_Customer_Exposure
4094: ( p_customer_id => cust_csr_rec.customer_id
4095: , p_site_id => site_csr_rec.site_id
4096: , p_limit_curr_code => site_prof_csr_rec.site_currency_code
4097: , p_credit_check_rule_id => p_cr_check_rule_id

Line 4224: IF OE_Credit_Engine_GRP.G_site_incl_all_flag='Y'

4220: ----calculate unchecked exposure for bill-to site
4221: ----if global variable for include_all_flag is 'Y'
4222: ----then unchecked_exposure will be 0
4223:
4224: IF OE_Credit_Engine_GRP.G_site_incl_all_flag='Y'
4225: THEN
4226: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_site_incl_all_flag='
4227: ||OE_Credit_Engine_GRP.G_site_incl_all_flag
4228: ||'so l_site_unchk_exposure=0');

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

4222: ----then unchecked_exposure will be 0
4223:
4224: IF OE_Credit_Engine_GRP.G_site_incl_all_flag='Y'
4225: THEN
4226: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_site_incl_all_flag='
4227: ||OE_Credit_Engine_GRP.G_site_incl_all_flag
4228: ||'so l_site_unchk_exposure=0');
4229:
4230: l_site_unchk_exposure:=0;

Line 4227: ||OE_Credit_Engine_GRP.G_site_incl_all_flag

4223:
4224: IF OE_Credit_Engine_GRP.G_site_incl_all_flag='Y'
4225: THEN
4226: OE_DEBUG_PUB.ADD('OE_Credit_Engine_GRP.G_site_incl_all_flag='
4227: ||OE_Credit_Engine_GRP.G_site_incl_all_flag
4228: ||'so l_site_unchk_exposure=0');
4229:
4230: l_site_unchk_exposure:=0;
4231: ELSE