APPS.INL_INTERFACE_PVT dependencies on INL_PARAMETERS

Line 64: NULL user_defined_ship_num_code, -- from inl_parameters (AUTOMATIC or MANUAL)

60: attribute12 ,
61: attribute13 ,
62: attribute14 ,
63: attribute15 ,
64: NULL user_defined_ship_num_code, -- from inl_parameters (AUTOMATIC or MANUAL)
65: NULL manual_ship_num_type, -- from inl_parameters (NUMERIC or ALPHA)
66: NULL LCM_FLOW, -- can be AAS=as a service PR= pre receiving
67: NULL dflt_country
68: FROM inl_ship_headers_int h

Line 65: NULL manual_ship_num_type, -- from inl_parameters (NUMERIC or ALPHA)

61: attribute13 ,
62: attribute14 ,
63: attribute15 ,
64: NULL user_defined_ship_num_code, -- from inl_parameters (AUTOMATIC or MANUAL)
65: NULL manual_ship_num_type, -- from inl_parameters (NUMERIC or ALPHA)
66: NULL LCM_FLOW, -- can be AAS=as a service PR= pre receiving
67: NULL dflt_country
68: FROM inl_ship_headers_int h
69: WHERE h.request_id = l_fnd_conc_request_id_int

Line 4238: -- The inl_parameters table should always be checked

4234: p_var_name => 'p_ship_header_id',
4235: p_var_value => p_ship_header_id) ;
4236:
4237: --=================================================================================
4238: -- The inl_parameters table should always be checked
4239: -- if a organization does not have this setup
4240: -- the record should be rejected otherwise we'll get a exception in import process
4241: -- BUG#8971635
4242: -- Begin

Line 4275: -- The inl_parameters table should always be checked

4271: END IF;
4272: ELSIF p_validation_flag = 'Y' THEN
4273: */ -- BUG#8971635
4274: --=================================================================================
4275: -- The inl_parameters table should always be checked
4276: -- if a organization does not have this setup
4277: -- the record should be rejected otherwise we'll get a exception in import process
4278: -- BUG#8971635
4279: -- End

Line 4324: inl_parameters ipa,

4320: x_user_defined_ship_num_code,
4321: x_manual_ship_num_type,
4322: l_count_org_def_lcm
4323: FROM org_organization_definitions ood,
4324: inl_parameters ipa,
4325: rcv_parameters rp
4326: WHERE
4327: ipa.organization_id (+) = ood.organization_id
4328: AND rp.organization_id (+) = ood.organization_id

Line 9342: FROM inl_parameters

9338: inl_ship_headers_all_s.NEXTVAL
9339: INTO l_user_defined_ship_num_code,
9340: l_next_ship_num,
9341: x_ship_hdr_int_rec.ship_header_id
9342: FROM inl_parameters
9343: WHERE organization_id = x_ship_hdr_int_rec.organization_id
9344: FOR UPDATE OF next_ship_num;
9345:
9346: INL_LOGGING_PVT.Log_Variable(

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

9360: p_procedure_name => l_program_name,
9361: p_var_name => 'x_ship_hdr_int_rec.ship_header_id',
9362: p_var_value => x_ship_hdr_int_rec.ship_header_id) ;
9363:
9364: l_debug_info := 'Setting the next Shipment Number in INL_PARAMETERS';
9365: INL_LOGGING_PVT.Log_Statement(
9366: p_module_name => g_module_name,
9367: p_procedure_name => l_program_name,
9368: p_debug_info => l_debug_info) ;

Line 9374: UPDATE inl_parameters

9370: IF l_user_defined_ship_num_code = 'AUTOMATIC'
9371: AND p_simulation_id IS NULL
9372: THEN -- Bug #9279355
9373: l_ship_num := l_next_ship_num;
9374: UPDATE inl_parameters
9375: SET next_ship_num = l_next_ship_num + 1,
9376: last_updated_by = L_FND_USER_ID ,
9377: last_update_date = SYSDATE ,
9378: last_update_login = L_FND_LOGIN_ID

Line 17237: inl_parameters p

17233:
17234: SELECT r.package_name
17235: INTO l_rule_package_name
17236: FROM inl_rules_vl r,
17237: inl_parameters p
17238: WHERE r.rule_id (+) = p.rule_id
17239: AND r.enabled_flag (+) = 'Y'
17240: AND p.organization_id = l_organization_id;
17241: