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 950: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_CREDIT_RULES_REC_TYPE ;

946: j INTEGER:=0;
947: f INTEGER:=0;
948:
949:
950: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_CREDIT_RULES_REC_TYPE ;
951: l_system_parameters_rec OE_CREDIT_CHECK_UTIL.OE_SYSTEMS_PARAM_REC_TYPE ;
952: l_cust_unchk_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
953: l_site_unchk_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
954: l_total_exposure NUMBER;

Line 951: l_system_parameters_rec OE_CREDIT_CHECK_UTIL.OE_SYSTEMS_PARAM_REC_TYPE ;

947: f INTEGER:=0;
948:
949:
950: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_CREDIT_RULES_REC_TYPE ;
951: l_system_parameters_rec OE_CREDIT_CHECK_UTIL.OE_SYSTEMS_PARAM_REC_TYPE ;
952: l_cust_unchk_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
953: l_site_unchk_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
954: l_total_exposure NUMBER;
955: l_error_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;

Line 952: l_cust_unchk_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;

948:
949:
950: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_CREDIT_RULES_REC_TYPE ;
951: l_system_parameters_rec OE_CREDIT_CHECK_UTIL.OE_SYSTEMS_PARAM_REC_TYPE ;
952: l_cust_unchk_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
953: l_site_unchk_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
954: l_total_exposure NUMBER;
955: l_error_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
956: l_conversion_status OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;

Line 953: l_site_unchk_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;

949:
950: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_CREDIT_RULES_REC_TYPE ;
951: l_system_parameters_rec OE_CREDIT_CHECK_UTIL.OE_SYSTEMS_PARAM_REC_TYPE ;
952: l_cust_unchk_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
953: l_site_unchk_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
954: l_total_exposure NUMBER;
955: l_error_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
956: l_conversion_status OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
957: l_include_all_flag VARCHAR2(15);

Line 955: l_error_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;

951: l_system_parameters_rec OE_CREDIT_CHECK_UTIL.OE_SYSTEMS_PARAM_REC_TYPE ;
952: l_cust_unchk_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
953: l_site_unchk_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
954: l_total_exposure NUMBER;
955: l_error_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
956: l_conversion_status OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
957: l_include_all_flag VARCHAR2(15);
958:
959: l_order_amount NUMBER;

Line 956: l_conversion_status OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;

952: l_cust_unchk_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
953: l_site_unchk_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
954: l_total_exposure NUMBER;
955: l_error_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
956: l_conversion_status OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
957: l_include_all_flag VARCHAR2(15);
958:
959: l_order_amount NUMBER;
960: l_order_hold_amount NUMBER;

Line 970: OE_CREDIT_CHECK_UTIL.GET_credit_check_rule

966: x_return_status := FND_API.G_RET_STS_SUCCESS;
967:
968:
969: ---get credit check rule record
970: OE_CREDIT_CHECK_UTIL.GET_credit_check_rule
971: ( p_credit_check_rule_id => p_credit_check_rule_id
972: , x_credit_check_rules_rec => l_credit_check_rule_rec
973: );
974:

Line 976: OE_CREDIT_CHECK_UTIL.GET_System_parameters

972: , x_credit_check_rules_rec => l_credit_check_rule_rec
973: );
974:
975: -----Get system parameters record
976: OE_CREDIT_CHECK_UTIL.GET_System_parameters
977: ( x_system_parameter_rec=>l_system_parameters_rec
978: );
979:
980: -----Party level-------

Line 1288: OE_CREDIT_CHECK_UTIL.Get_order_exposure

1284: OE_DEBUG_PUB.ADD('p_header_id: '||'NULL');
1285: OE_DEBUG_PUB.ADD('p_limit_curr_code: '||p_base_currency);
1286: OE_DEBUG_PUB.ADD('p_include_all_flag: '||'N');
1287: /*
1288: OE_CREDIT_CHECK_UTIL.Get_order_exposure
1289: ( p_header_id => NULL
1290: , p_transaction_curr_code => NULL
1291: , p_customer_id => p_customer_id
1292: , p_site_use_id => NULL

Line 1305: OE_CREDIT_CHECK_UTIL.Get_order_exposure

1301: , x_conversion_status => l_conversion_status
1302: );
1303: */
1304:
1305: OE_CREDIT_CHECK_UTIL.Get_order_exposure
1306: ( p_header_id => NULL
1307: , p_transaction_curr_code => NULL
1308: , p_customer_id => p_customer_id
1309: , p_site_use_id => NULL

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

1495:
1496: ----non pre-calculate exposure
1497: ELSIF l_credit_check_rule_rec.quick_cr_check_flag ='N'
1498: THEN
1499: OE_DEBUG_PUB.ADD('OEXPCRGB: IN of OE_CREDIT_CHECK_UTIL.Get_order_Exposure ');
1500: OE_DEBUG_PUB.ADD('Parameters:');
1501: OE_DEBUG_PUB.ADD('p_header_id: '||'NULL');
1502: OE_DEBUG_PUB.ADD('p_transaction_curr_code: '||'NULL');
1503: OE_DEBUG_PUB.ADD('p_customer_id: '||p_customer_id);

Line 1509: OE_CREDIT_CHECK_UTIL.Get_order_exposure

1505: OE_DEBUG_PUB.ADD('p_credit_level: '||'SITE');
1506: OE_DEBUG_PUB.ADD('p_limit_curr_code: '||p_base_currency);
1507: OE_DEBUG_PUB.ADD('p_include_all_flag: '||'N');
1508: /*
1509: OE_CREDIT_CHECK_UTIL.Get_order_exposure
1510: ( p_header_id => NULL
1511: , p_transaction_curr_code => NULL
1512: , p_customer_id => p_customer_id
1513: , p_site_use_id => p_site_id

Line 1526: OE_CREDIT_CHECK_UTIL.Get_order_exposure

1522: , x_conversion_status => l_conversion_status
1523: );
1524: */
1525:
1526: OE_CREDIT_CHECK_UTIL.Get_order_exposure
1527: ( p_header_id => NULL
1528: , p_transaction_curr_code => NULL
1529: , p_customer_id => p_customer_id
1530: , p_site_use_id => p_site_id

Line 1786: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type

1782: AND n.child_object_type = 'ORGANIZATION'
1783: AND n.effective_start_date <= SYSDATE
1784: AND n.effective_end_date >= SYSDATE
1785: AND n.hierarchy_type
1786: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type
1787: AND n.parent_id=NVL(p_specific_party_id,p_spec_party_num_id)
1788: ORDER BY level_number;
1789:
1790: ---cursor to select parties if they are not part of the

Line 1921: l_empty_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;

1917: l_cust_unchk_exposure NUMBER;
1918: l_party_unchk_exposure NUMBER;
1919: l_site_unchk_exposure NUMBER;
1920: l_conversion_type VARCHAR2(30);
1921: l_empty_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
1922: l_global_exposure_flag VARCHAR2(1);
1923: l_prof_count NUMBER:=0;
1924: l_prof_count1 NUMBER:=0;
1925: l_order_hold_amount NUMBER;

Line 1941: l_base_currency:=OE_CREDIT_CHECK_UTIL.Get_GL_currency;

1937: l_return_status := FND_API.G_RET_STS_SUCCESS;
1938: l_global_exposure_flag := 'N' ;
1939:
1940: ----get base currency=currency of the current operating unit
1941: l_base_currency:=OE_CREDIT_CHECK_UTIL.Get_GL_currency;
1942:
1943: OE_DEBUG_PUB.ADD('l_base_currency= '||l_base_currency);
1944:
1945: ---get conversion type

Line 1954: l_profile_value:=OE_CREDIT_CHECK_UTIL.G_hierarchy_type;

1950: FROM oe_credit_check_rules
1951: WHERE credit_check_rule_id=p_cr_check_rule_id;
1952:
1953: ----get the hierarchy_type
1954: l_profile_value:=OE_CREDIT_CHECK_UTIL.G_hierarchy_type;
1955:
1956: OE_DEBUG_PUB.ADD('AR_CMGT_HIERARCHY_TYPE= '||l_profile_value);
1957:
1958: --------Party Range Summary Report-----------

Line 2755: OE_CREDIT_CHECK_UTIL.Get_global_exposure_flag

2751:
2752: OE_DEBUG_PUB.ADD('call Get_global_exposure_flag ');
2753:
2754: l_global_exposure_flag :=
2755: OE_CREDIT_CHECK_UTIL.Get_global_exposure_flag
2756: ( p_entity_type => 'CUSTOMER'
2757: , p_entity_id => party_cust_csr_rec.customer_id
2758: , p_limit_curr_code => cust_prof_csr_rec.cust_currency_code
2759: ) ;

Line 3360: OE_CREDIT_CHECK_UTIL.Get_global_exposure_flag

3356:
3357: OE_DEBUG_PUB.ADD('call Get_global_exposure_flag ');
3358:
3359: l_global_exposure_flag :=
3360: OE_CREDIT_CHECK_UTIL.Get_global_exposure_flag
3361: ( p_entity_type => 'CUSTOMER'
3362: , p_entity_id => party_cust_csr_rec.customer_id
3363: , p_limit_curr_code => cust_prof_csr_rec.cust_currency_code
3364: ) ;

Line 3870: OE_CREDIT_CHECK_UTIL.Get_global_exposure_flag

3866:
3867: OE_DEBUG_PUB.ADD('call Get_global_exposure_flag ');
3868:
3869: l_global_exposure_flag :=
3870: OE_CREDIT_CHECK_UTIL.Get_global_exposure_flag
3871: ( p_entity_type => 'CUSTOMER'
3872: , p_entity_id => cust_csr_rec.customer_id
3873: , p_limit_curr_code => cust_prof_csr_rec.cust_currency_code
3874: ) ;