[Home] [Help]
124: from wip_job_schedule_interface
125: where rowid = wip_jsi_utils.current_rowid;
126:
127: -- Save Original org context
128: orig_org_context := nvl(fnd_profile.value('ORG_ID'), -1) ;
129:
130: --defaults all values in record
131: --issues any ignored value warnings
132: --sets the org context (needed for pjm validations)
1058: l_end_date DATE;
1059: l_dummy NUMBER;
1060: X_Eng_Items_Flag NUMBER;
1061: begin
1062: l_see_eng_items_flag := fnd_profile.value('WIP_SEE_ENG_ITEMS');
1063:
1064: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_sched,
1065: wip_constants.create_ns_job)) then
1066: if(wjsi_row.primary_item_id is null and wjsi_row.load_type <> wip_constants.create_ns_job) then
1084: end if;
1085: end if;
1086:
1087: if(wjsi_row.primary_item_id is not null) then
1088: X_Eng_Items_Flag := to_number(FND_PROFILE.value('WIP_SEE_ENG_ITEMS'));
1089: begin
1090: select 1
1091: into l_dummy
1092: from MTL_SYSTEM_ITEMS msi
1311: procedure project_id is begin
1312: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_eam_job) and
1313: wjsi_row.project_id is not null) then
1314: -- fix MOAC, set id so project view works
1315: fnd_profile.put('MFG_ORGANIZATION_ID',wjsi_row.organization_id);
1316: -- Bug 4890215. Performance Fix
1317: -- sugupta 26th-May-2006
1318: select mpv.project_id --this query will return multiple rows if the project has tasks
1319: into g_dummy
1732: and organization_id = wjsi_row.organization_id
1733: and secondary_inventory_name = wjsi_row.completion_subinventory;
1734: end if;
1735: --now validate unrestricted items
1736: elsif(fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') = 1) then
1737: select 1
1738: into g_dummy
1739: from mtl_subinventories_val_v
1740: where secondary_inventory_name = wjsi_row.completion_subinventory