APPS.INL_INTERFACE_PVT dependencies on INL_PARAMETERS

Line 561: FROM inl_parameters

557: SELECT
558: user_defined_ship_num_code
559: INTO
560: l_user_defined_ship_num_code
561: FROM inl_parameters
562: WHERE organization_id = p_organization_id;
563:
564: IF l_user_defined_ship_num_code = 'AUTOMATIC' THEN
565: IF p_ship_num IS NOT NULL THEN

Line 1104: FROM inl_parameters ipa

1100: p_debug_info => l_debug_info
1101: ) ;
1102: SELECT COUNT(1)
1103: INTO l_organization_count
1104: FROM inl_parameters ipa
1105: WHERE ipa.organization_id = p_organization_id;
1106: IF NVL(l_organization_count, 0) = 0 THEN
1107: l_result := FND_API.G_FALSE;
1108: -- Add a line into inl_ship_errors

Line 2451: FROM inl_parameters

2447: SELECT user_defined_ship_num_code,
2448: next_ship_num
2449: INTO l_user_defined_ship_num_code,
2450: l_next_ship_num
2451: FROM inl_parameters
2452: WHERE organization_id = validHeaders_List(iHead) .organization_id;
2453: IF validHeaders_List(iHead) .transaction_type = 'UPDATE' THEN
2454: l_debug_info := 'Updating the Shipment Header';
2455: INL_LOGGING_PVT.Log_Statement(

Line 2516: l_debug_info := 'Setting the next Shipment Number in INL_PARAMETERS';

2512: p_procedure_name => l_proc_name,
2513: p_var_name => 'l_next_ship_num',
2514: p_var_value => l_next_ship_num
2515: ) ;
2516: l_debug_info := 'Setting the next Shipment Number in INL_PARAMETERS';
2517: INL_LOGGING_PVT.Log_Statement(
2518: p_module_name => g_module_name,
2519: p_procedure_name => l_proc_name,
2520: p_debug_info => l_debug_info

Line 2525: UPDATE inl_parameters

2521: ) ;
2522: l_ship_num := NULL;
2523: IF l_user_defined_ship_num_code = 'AUTOMATIC' THEN
2524: l_ship_num := l_next_ship_num;
2525: UPDATE inl_parameters
2526: SET next_ship_num = l_next_ship_num + 1,
2527: last_updated_by = fnd_global.user_id ,
2528: last_update_date = SYSDATE ,
2529: last_update_login = fnd_global.login_id