APPS.WSM_LBJ_INTERFACE_PVT dependencies on FND_PROFILE

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

1067: if p_load_type = 5 then -- Job creation
1068: if p_job_name is null then
1069: l_stmt_num := 20;
1070: -- Derive Job_Name.
1071: select FND_Profile.value('WIP_JOB_PREFIX') || wip_job_number_s.nextval
1072: into p_job_name
1073: from dual;
1074: end if;
1075:

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

12070:
12071: -- delete marked rows (without error rows) from wlji and wljdi
12072: Begin
12073: -- bug 3126758
12074: l_del_int_prof_value := fnd_profile.value('WSM_INTERFACE_HISTORY_DAYS');
12075:
12076: if l_atleast_one_row_in_mmtt <> 0 then
12077: l_stmt_num := 1100;
12078: delete from wsm_starting_lots_interface

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

13604:
13605: l_stmt_num := 142;
13606:
13607: -- Combined validations for UOM and autocharge... --
13608: l_hour_uom := FND_PROFILE.value('BOM:HOUR_UOM_CODE');
13609: l_hour_uom_class := wip_op_resources_utilities.get_uom_class(l_hour_uom);
13610: l_autocharge_type := p_new_res_tbl(l_index).autocharge_type;
13611:
13612: l_stmt_num := 145;