APPS.INL_CHARGE_PVT dependencies on QP_CHARGE_LOOKUP

Line 684: l_qp_charge_lookup NUMBER; -- Bug #9274538

680:
681: l_ship_ln_group_tbl ship_ln_group_rec;
682: l_ship_ln_tbl ship_ln_tbl;
683: l_log_all_input_var VARCHAR2(1):='Y';
684: l_qp_charge_lookup NUMBER; -- Bug #9274538
685: l_cost_factor_valid VARCHAR2(1):='T'; -- Bug #9274538
686:
687: BEGIN
688: -- Begin the procedure

Line 1372: INTO l_qp_charge_lookup

1368: p_var_value => nvl(l_freight_charge_tbl(n).charge_type_code,'NULL'));
1369:
1370: -- Bug #9274538
1371: SELECT COUNT(1)
1372: INTO l_qp_charge_lookup
1373: FROM qp_charge_lookup qcl
1374: WHERE qcl.lookup_code = l_freight_charge_tbl(n).charge_type_code
1375: AND qcl.lookup_type = 'FREIGHT_CHARGES_TYPE';
1376:

Line 1373: FROM qp_charge_lookup qcl

1369:
1370: -- Bug #9274538
1371: SELECT COUNT(1)
1372: INTO l_qp_charge_lookup
1373: FROM qp_charge_lookup qcl
1374: WHERE qcl.lookup_code = l_freight_charge_tbl(n).charge_type_code
1375: AND qcl.lookup_type = 'FREIGHT_CHARGES_TYPE';
1376:
1377: IF NVL(l_qp_charge_lookup,0) = 0 THEN

Line 1377: IF NVL(l_qp_charge_lookup,0) = 0 THEN

1373: FROM qp_charge_lookup qcl
1374: WHERE qcl.lookup_code = l_freight_charge_tbl(n).charge_type_code
1375: AND qcl.lookup_type = 'FREIGHT_CHARGES_TYPE';
1376:
1377: IF NVL(l_qp_charge_lookup,0) = 0 THEN
1378: SELECT COUNT(1)
1379: INTO l_qp_charge_lookup
1380: FROM qp_charge_lookup qcl
1381: WHERE qcl.lookup_code = l_freight_charge_tbl(n).charge_type_code

Line 1379: INTO l_qp_charge_lookup

1375: AND qcl.lookup_type = 'FREIGHT_CHARGES_TYPE';
1376:
1377: IF NVL(l_qp_charge_lookup,0) = 0 THEN
1378: SELECT COUNT(1)
1379: INTO l_qp_charge_lookup
1380: FROM qp_charge_lookup qcl
1381: WHERE qcl.lookup_code = l_freight_charge_tbl(n).charge_type_code
1382: AND qcl.lookup_type = 'FREIGHT_COST_TYPE';
1383: END IF;

Line 1380: FROM qp_charge_lookup qcl

1376:
1377: IF NVL(l_qp_charge_lookup,0) = 0 THEN
1378: SELECT COUNT(1)
1379: INTO l_qp_charge_lookup
1380: FROM qp_charge_lookup qcl
1381: WHERE qcl.lookup_code = l_freight_charge_tbl(n).charge_type_code
1382: AND qcl.lookup_type = 'FREIGHT_COST_TYPE';
1383: END IF;
1384:

Line 1388: p_var_name => 'l_qp_charge_lookup',

1384:
1385: INL_LOGGING_PVT.Log_Variable (
1386: p_module_name => g_module_name,
1387: p_procedure_name => l_proc_name,
1388: p_var_name => 'l_qp_charge_lookup',
1389: p_var_value => NVL(l_qp_charge_lookup,0));
1390:
1391: IF (NVL(l_qp_charge_lookup,0) > 0) THEN
1392: l_debug_info := 'LCM only accepts cost factors for charges. Charge ' || l_freight_charge_tbl(n).charge_type_code||

Line 1389: p_var_value => NVL(l_qp_charge_lookup,0));

1385: INL_LOGGING_PVT.Log_Variable (
1386: p_module_name => g_module_name,
1387: p_procedure_name => l_proc_name,
1388: p_var_name => 'l_qp_charge_lookup',
1389: p_var_value => NVL(l_qp_charge_lookup,0));
1390:
1391: IF (NVL(l_qp_charge_lookup,0) > 0) THEN
1392: l_debug_info := 'LCM only accepts cost factors for charges. Charge ' || l_freight_charge_tbl(n).charge_type_code||
1393: ' cannot be generated.' ;

Line 1391: IF (NVL(l_qp_charge_lookup,0) > 0) THEN

1387: p_procedure_name => l_proc_name,
1388: p_var_name => 'l_qp_charge_lookup',
1389: p_var_value => NVL(l_qp_charge_lookup,0));
1390:
1391: IF (NVL(l_qp_charge_lookup,0) > 0) THEN
1392: l_debug_info := 'LCM only accepts cost factors for charges. Charge ' || l_freight_charge_tbl(n).charge_type_code||
1393: ' cannot be generated.' ;
1394: INL_LOGGING_PVT.Log_Statement (
1395: p_module_name => g_module_name,