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_CHECK_UTIL

Line 16: p_gl_currency_code VARCHAR2(30) := OE_CREDIT_CHECK_UTIL.GET_GL_CURRENCY;

12:
13: --==============================================================
14: -- PUBLIC VARIABLES
15: --==============================================================
16: p_gl_currency_code VARCHAR2(30) := OE_CREDIT_CHECK_UTIL.GET_GL_CURRENCY;
17:
18: --==============================================================
19: -- PROCEDURES AND FUNCTIONS
20: --==============================================================

Line 942: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_CREDIT_RULES_REC_TYPE ;

938: j INTEGER:=0;
939: f INTEGER:=0;
940:
941:
942: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_CREDIT_RULES_REC_TYPE ;
943: l_system_parameters_rec OE_CREDIT_CHECK_UTIL.OE_SYSTEMS_PARAM_REC_TYPE ;
944: l_cust_unchk_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
945: l_site_unchk_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
946: l_total_exposure NUMBER;

Line 943: l_system_parameters_rec OE_CREDIT_CHECK_UTIL.OE_SYSTEMS_PARAM_REC_TYPE ;

939: f INTEGER:=0;
940:
941:
942: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_CREDIT_RULES_REC_TYPE ;
943: l_system_parameters_rec OE_CREDIT_CHECK_UTIL.OE_SYSTEMS_PARAM_REC_TYPE ;
944: l_cust_unchk_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
945: l_site_unchk_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
946: l_total_exposure NUMBER;
947: l_error_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;

Line 944: l_cust_unchk_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;

940:
941:
942: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_CREDIT_RULES_REC_TYPE ;
943: l_system_parameters_rec OE_CREDIT_CHECK_UTIL.OE_SYSTEMS_PARAM_REC_TYPE ;
944: l_cust_unchk_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
945: l_site_unchk_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
946: l_total_exposure NUMBER;
947: l_error_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
948: l_conversion_status OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;

Line 945: l_site_unchk_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;

941:
942: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_CREDIT_RULES_REC_TYPE ;
943: l_system_parameters_rec OE_CREDIT_CHECK_UTIL.OE_SYSTEMS_PARAM_REC_TYPE ;
944: l_cust_unchk_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
945: l_site_unchk_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
946: l_total_exposure NUMBER;
947: l_error_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
948: l_conversion_status OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
949: l_include_all_flag VARCHAR2(15);

Line 947: l_error_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;

943: l_system_parameters_rec OE_CREDIT_CHECK_UTIL.OE_SYSTEMS_PARAM_REC_TYPE ;
944: l_cust_unchk_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
945: l_site_unchk_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
946: l_total_exposure NUMBER;
947: l_error_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
948: l_conversion_status OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
949: l_include_all_flag VARCHAR2(15);
950:
951: l_order_amount NUMBER;

Line 948: l_conversion_status OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;

944: l_cust_unchk_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
945: l_site_unchk_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
946: l_total_exposure NUMBER;
947: l_error_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
948: l_conversion_status OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
949: l_include_all_flag VARCHAR2(15);
950:
951: l_order_amount NUMBER;
952: l_order_hold_amount NUMBER;

Line 962: OE_CREDIT_CHECK_UTIL.GET_credit_check_rule

958: x_return_status := FND_API.G_RET_STS_SUCCESS;
959:
960:
961: ---get credit check rule record
962: OE_CREDIT_CHECK_UTIL.GET_credit_check_rule
963: ( p_credit_check_rule_id => p_credit_check_rule_id
964: , x_credit_check_rules_rec => l_credit_check_rule_rec
965: );
966:

Line 968: OE_CREDIT_CHECK_UTIL.GET_System_parameters

964: , x_credit_check_rules_rec => l_credit_check_rule_rec
965: );
966:
967: -----Get system parameters record
968: OE_CREDIT_CHECK_UTIL.GET_System_parameters
969: ( x_system_parameter_rec=>l_system_parameters_rec
970: );
971:
972: -----Party level-------

Line 1280: OE_CREDIT_CHECK_UTIL.Get_order_exposure

1276: OE_DEBUG_PUB.ADD('p_header_id: '||'NULL');
1277: OE_DEBUG_PUB.ADD('p_limit_curr_code: '||p_base_currency);
1278: OE_DEBUG_PUB.ADD('p_include_all_flag: '||'N');
1279: /*
1280: OE_CREDIT_CHECK_UTIL.Get_order_exposure
1281: ( p_header_id => NULL
1282: , p_transaction_curr_code => NULL
1283: , p_customer_id => p_customer_id
1284: , p_site_use_id => NULL

Line 1297: OE_CREDIT_CHECK_UTIL.Get_order_exposure

1293: , x_conversion_status => l_conversion_status
1294: );
1295: */
1296:
1297: OE_CREDIT_CHECK_UTIL.Get_order_exposure
1298: ( p_header_id => NULL
1299: , p_transaction_curr_code => NULL
1300: , p_customer_id => p_customer_id
1301: , p_site_use_id => NULL

Line 1491: OE_DEBUG_PUB.ADD('OEXPCRGB: IN of OE_CREDIT_CHECK_UTIL.Get_order_Exposure ');

1487:
1488: ----non pre-calculate exposure
1489: ELSIF l_credit_check_rule_rec.quick_cr_check_flag ='N'
1490: THEN
1491: OE_DEBUG_PUB.ADD('OEXPCRGB: IN of OE_CREDIT_CHECK_UTIL.Get_order_Exposure ');
1492: OE_DEBUG_PUB.ADD('Parameters:');
1493: OE_DEBUG_PUB.ADD('p_header_id: '||'NULL');
1494: OE_DEBUG_PUB.ADD('p_transaction_curr_code: '||'NULL');
1495: OE_DEBUG_PUB.ADD('p_customer_id: '||p_customer_id);

Line 1501: OE_CREDIT_CHECK_UTIL.Get_order_exposure

1497: OE_DEBUG_PUB.ADD('p_credit_level: '||'SITE');
1498: OE_DEBUG_PUB.ADD('p_limit_curr_code: '||p_base_currency);
1499: OE_DEBUG_PUB.ADD('p_include_all_flag: '||'N');
1500: /*
1501: OE_CREDIT_CHECK_UTIL.Get_order_exposure
1502: ( p_header_id => NULL
1503: , p_transaction_curr_code => NULL
1504: , p_customer_id => p_customer_id
1505: , p_site_use_id => p_site_id

Line 1518: OE_CREDIT_CHECK_UTIL.Get_order_exposure

1514: , x_conversion_status => l_conversion_status
1515: );
1516: */
1517:
1518: OE_CREDIT_CHECK_UTIL.Get_order_exposure
1519: ( p_header_id => NULL
1520: , p_transaction_curr_code => NULL
1521: , p_customer_id => p_customer_id
1522: , p_site_use_id => p_site_id

Line 1778: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type

1774: AND n.child_object_type = 'ORGANIZATION'
1775: AND n.effective_start_date <= SYSDATE
1776: AND n.effective_end_date >= SYSDATE
1777: AND n.hierarchy_type
1778: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type
1779: AND n.parent_id=NVL(p_specific_party_id,p_spec_party_num_id)
1780: ORDER BY level_number;
1781:
1782: ---cursor to select parties if they are not part of the

Line 1910: l_empty_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;

1906: l_cust_unchk_exposure NUMBER;
1907: l_party_unchk_exposure NUMBER;
1908: l_site_unchk_exposure NUMBER;
1909: l_conversion_type VARCHAR2(30);
1910: l_empty_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
1911: l_global_exposure_flag VARCHAR2(1);
1912: l_prof_count NUMBER:=0;
1913: l_prof_count1 NUMBER:=0;
1914: l_order_hold_amount NUMBER;

Line 1930: l_base_currency:=OE_CREDIT_CHECK_UTIL.Get_GL_currency;

1926: l_return_status := FND_API.G_RET_STS_SUCCESS;
1927: l_global_exposure_flag := 'N' ;
1928:
1929: ----get base currency=currency of the current operating unit
1930: l_base_currency:=OE_CREDIT_CHECK_UTIL.Get_GL_currency;
1931:
1932: OE_DEBUG_PUB.ADD('l_base_currency= '||l_base_currency);
1933:
1934: ---get conversion type

Line 1943: l_profile_value:=OE_CREDIT_CHECK_UTIL.G_hierarchy_type;

1939: FROM oe_credit_check_rules
1940: WHERE credit_check_rule_id=p_cr_check_rule_id;
1941:
1942: ----get the hierarchy_type
1943: l_profile_value:=OE_CREDIT_CHECK_UTIL.G_hierarchy_type;
1944:
1945: OE_DEBUG_PUB.ADD('AR_CMGT_HIERARCHY_TYPE= '||l_profile_value);
1946:
1947: --------Party Range Summary Report-----------

Line 2742: OE_CREDIT_CHECK_UTIL.Get_global_exposure_flag

2738:
2739: OE_DEBUG_PUB.ADD('call Get_global_exposure_flag ');
2740:
2741: l_global_exposure_flag :=
2742: OE_CREDIT_CHECK_UTIL.Get_global_exposure_flag
2743: ( p_entity_type => 'CUSTOMER'
2744: , p_entity_id => party_cust_csr_rec.customer_id
2745: , p_limit_curr_code => cust_prof_csr_rec.cust_currency_code
2746: ) ;

Line 3345: OE_CREDIT_CHECK_UTIL.Get_global_exposure_flag

3341:
3342: OE_DEBUG_PUB.ADD('call Get_global_exposure_flag ');
3343:
3344: l_global_exposure_flag :=
3345: OE_CREDIT_CHECK_UTIL.Get_global_exposure_flag
3346: ( p_entity_type => 'CUSTOMER'
3347: , p_entity_id => party_cust_csr_rec.customer_id
3348: , p_limit_curr_code => cust_prof_csr_rec.cust_currency_code
3349: ) ;

Line 3845: OE_CREDIT_CHECK_UTIL.Get_global_exposure_flag

3841:
3842: OE_DEBUG_PUB.ADD('call Get_global_exposure_flag ');
3843:
3844: l_global_exposure_flag :=
3845: OE_CREDIT_CHECK_UTIL.Get_global_exposure_flag
3846: ( p_entity_type => 'CUSTOMER'
3847: , p_entity_id => cust_csr_rec.customer_id
3848: , p_limit_curr_code => cust_prof_csr_rec.cust_currency_code
3849: ) ;