APPS.WSM_LBJ_INTERFACE_PVT dependencies on FND_PROFILE

Line 1076: select FND_Profile.value('WIP_JOB_PREFIX') || wip_job_number_s.nextval

1072: if p_load_type = 5 then -- Job creation
1073: if p_job_name is null then
1074: l_stmt_num := 20;
1075: -- Derive Job_Name.
1076: select FND_Profile.value('WIP_JOB_PREFIX') || wip_job_number_s.nextval
1077: into p_job_name
1078: from dual;
1079: end if;
1080:

Line 12178: l_del_int_prof_value := fnd_profile.value('WSM_INTERFACE_HISTORY_DAYS');

12174:
12175: -- delete marked rows (without error rows) from wlji and wljdi
12176: Begin
12177: -- bug 3126758
12178: l_del_int_prof_value := fnd_profile.value('WSM_INTERFACE_HISTORY_DAYS');
12179:
12180: if l_atleast_one_row_in_mmtt <> 0 then
12181: l_stmt_num := 1100;
12182: delete from wsm_starting_lots_interface

Line 13712: l_hour_uom := FND_PROFILE.value('BOM:HOUR_UOM_CODE');

13708:
13709: l_stmt_num := 142;
13710:
13711: -- Combined validations for UOM and autocharge... --
13712: l_hour_uom := FND_PROFILE.value('BOM:HOUR_UOM_CODE');
13713: l_hour_uom_class := wip_op_resources_utilities.get_uom_class(l_hour_uom);
13714: l_autocharge_type := p_new_res_tbl(l_index).autocharge_type;
13715:
13716: l_stmt_num := 145;