3446: p_appl_conc_program_id,
3447: SYSDATE,
3448: p_wip_seq,
3449: 'WICDOL',
3450: WIP_CONSTANTS.ML_VALIDATION,
3451: WIP_CONSTANTS.PENDING, -- process_status
3452: l_ship_org, -- organization id
3453: WIP_CONSTANTS.CREATE_JOB, --Load_Type
3454: nvl(p_status_type, WIP_CONSTANTS.UNRELEASED), -- Status_Type
3447: SYSDATE,
3448: p_wip_seq,
3449: 'WICDOL',
3450: WIP_CONSTANTS.ML_VALIDATION,
3451: WIP_CONSTANTS.PENDING, -- process_status
3452: l_ship_org, -- organization id
3453: WIP_CONSTANTS.CREATE_JOB, --Load_Type
3454: nvl(p_status_type, WIP_CONSTANTS.UNRELEASED), -- Status_Type
3455: l_mlsupply_items(l_index).job_completion_date, -- Date Completed
3449: 'WICDOL',
3450: WIP_CONSTANTS.ML_VALIDATION,
3451: WIP_CONSTANTS.PENDING, -- process_status
3452: l_ship_org, -- organization id
3453: WIP_CONSTANTS.CREATE_JOB, --Load_Type
3454: nvl(p_status_type, WIP_CONSTANTS.UNRELEASED), -- Status_Type
3455: l_mlsupply_items(l_index).job_completion_date, -- Date Completed
3456: l_mlsupply_items(l_index).item_id, --Primary_Item_Id
3457: WIP_CONSTANTS.BASED_ON_BOM, -- Wip_Supply_Type
3450: WIP_CONSTANTS.ML_VALIDATION,
3451: WIP_CONSTANTS.PENDING, -- process_status
3452: l_ship_org, -- organization id
3453: WIP_CONSTANTS.CREATE_JOB, --Load_Type
3454: nvl(p_status_type, WIP_CONSTANTS.UNRELEASED), -- Status_Type
3455: l_mlsupply_items(l_index).job_completion_date, -- Date Completed
3456: l_mlsupply_items(l_index).item_id, --Primary_Item_Id
3457: WIP_CONSTANTS.BASED_ON_BOM, -- Wip_Supply_Type
3458: decode(p_class_code, null, null
3453: WIP_CONSTANTS.CREATE_JOB, --Load_Type
3454: nvl(p_status_type, WIP_CONSTANTS.UNRELEASED), -- Status_Type
3455: l_mlsupply_items(l_index).job_completion_date, -- Date Completed
3456: l_mlsupply_items(l_index).item_id, --Primary_Item_Id
3457: WIP_CONSTANTS.BASED_ON_BOM, -- Wip_Supply_Type
3458: decode(p_class_code, null, null
3459: , p_class_code), --Accouting Class
3460: 2, --Firm_Planned_Flag
3461: l_mlsupply_items(l_index).needed_item_qty,
3588: null,--706,
3589: SYSDATE,
3590: x_groupID,
3591: 'WICDOL',
3592: WIP_CONSTANTS.ML_VALIDATION,
3593: WIP_CONSTANTS.PENDING, -- process_status
3594: l_ship_org, -- organization id
3595: WIP_CONSTANTS.CREATE_JOB, --Load_Type
3596: nvl(p_status_type, WIP_CONSTANTS.UNRELEASED), -- Status_Type
3589: SYSDATE,
3590: x_groupID,
3591: 'WICDOL',
3592: WIP_CONSTANTS.ML_VALIDATION,
3593: WIP_CONSTANTS.PENDING, -- process_status
3594: l_ship_org, -- organization id
3595: WIP_CONSTANTS.CREATE_JOB, --Load_Type
3596: nvl(p_status_type, WIP_CONSTANTS.UNRELEASED), -- Status_Type
3597: l_mlsupply_items(l_index).job_completion_date, -- Date Completed
3591: 'WICDOL',
3592: WIP_CONSTANTS.ML_VALIDATION,
3593: WIP_CONSTANTS.PENDING, -- process_status
3594: l_ship_org, -- organization id
3595: WIP_CONSTANTS.CREATE_JOB, --Load_Type
3596: nvl(p_status_type, WIP_CONSTANTS.UNRELEASED), -- Status_Type
3597: l_mlsupply_items(l_index).job_completion_date, -- Date Completed
3598: l_mlsupply_items(l_index).item_id, --Primary_Item_Id
3599: WIP_CONSTANTS.BASED_ON_BOM, -- Wip_Supply_Type
3592: WIP_CONSTANTS.ML_VALIDATION,
3593: WIP_CONSTANTS.PENDING, -- process_status
3594: l_ship_org, -- organization id
3595: WIP_CONSTANTS.CREATE_JOB, --Load_Type
3596: nvl(p_status_type, WIP_CONSTANTS.UNRELEASED), -- Status_Type
3597: l_mlsupply_items(l_index).job_completion_date, -- Date Completed
3598: l_mlsupply_items(l_index).item_id, --Primary_Item_Id
3599: WIP_CONSTANTS.BASED_ON_BOM, -- Wip_Supply_Type
3600: decode(p_class_code, null, null
3595: WIP_CONSTANTS.CREATE_JOB, --Load_Type
3596: nvl(p_status_type, WIP_CONSTANTS.UNRELEASED), -- Status_Type
3597: l_mlsupply_items(l_index).job_completion_date, -- Date Completed
3598: l_mlsupply_items(l_index).item_id, --Primary_Item_Id
3599: WIP_CONSTANTS.BASED_ON_BOM, -- Wip_Supply_Type
3600: decode(p_class_code, null, null
3601: , p_class_code), --Accouting Class
3602: 2, --Firm_Planned_Flag
3603: l_mlsupply_items(l_index).needed_item_qty,
3620: (trunc (greatest(nvl(cal.calendar_date,SYSDATE),
3621: SYSDATE),'MI')+1/(60*24) )
3622: ),
3623: decode(nvl(wp.use_finite_scheduler,2), 1,
3624: WIP_CONSTANTS.ML_MANUAL,
3625: null),
3626: decode(nvl(wp.use_finite_scheduler,2), 1,
3627: l_mlsupply_items(l_index).job_start_date,
3628: null)
3723: null,
3724: null,
3725: false,
3726: to_char(x_groupID),
3727: to_char(WIP_CONSTANTS.ATO),
3728: to_char(WIP_CONSTANTS.NO));
3729:
3730:
3731:
3724: null,
3725: false,
3726: to_char(x_groupID),
3727: to_char(WIP_CONSTANTS.ATO),
3728: to_char(WIP_CONSTANTS.NO));
3729:
3730:
3731:
3732: if(l_requestId = 0) then --conc. req not spawned