3411: p_appl_conc_program_id,
3412: SYSDATE,
3413: p_wip_seq,
3414: 'WICDOL',
3415: WIP_CONSTANTS.ML_VALIDATION,
3416: WIP_CONSTANTS.PENDING, -- process_status
3417: l_ship_org, -- organization id
3418: WIP_CONSTANTS.CREATE_JOB, --Load_Type
3419: nvl(p_status_type, WIP_CONSTANTS.UNRELEASED), -- Status_Type
3412: SYSDATE,
3413: p_wip_seq,
3414: 'WICDOL',
3415: WIP_CONSTANTS.ML_VALIDATION,
3416: WIP_CONSTANTS.PENDING, -- process_status
3417: l_ship_org, -- organization id
3418: WIP_CONSTANTS.CREATE_JOB, --Load_Type
3419: nvl(p_status_type, WIP_CONSTANTS.UNRELEASED), -- Status_Type
3420: l_mlsupply_items(l_index).job_completion_date, -- Date Completed
3414: 'WICDOL',
3415: WIP_CONSTANTS.ML_VALIDATION,
3416: WIP_CONSTANTS.PENDING, -- process_status
3417: l_ship_org, -- organization id
3418: WIP_CONSTANTS.CREATE_JOB, --Load_Type
3419: nvl(p_status_type, WIP_CONSTANTS.UNRELEASED), -- Status_Type
3420: l_mlsupply_items(l_index).job_completion_date, -- Date Completed
3421: l_mlsupply_items(l_index).item_id, --Primary_Item_Id
3422: WIP_CONSTANTS.BASED_ON_BOM, -- Wip_Supply_Type
3415: WIP_CONSTANTS.ML_VALIDATION,
3416: WIP_CONSTANTS.PENDING, -- process_status
3417: l_ship_org, -- organization id
3418: WIP_CONSTANTS.CREATE_JOB, --Load_Type
3419: nvl(p_status_type, WIP_CONSTANTS.UNRELEASED), -- Status_Type
3420: l_mlsupply_items(l_index).job_completion_date, -- Date Completed
3421: l_mlsupply_items(l_index).item_id, --Primary_Item_Id
3422: WIP_CONSTANTS.BASED_ON_BOM, -- Wip_Supply_Type
3423: decode(p_class_code, null, null
3418: WIP_CONSTANTS.CREATE_JOB, --Load_Type
3419: nvl(p_status_type, WIP_CONSTANTS.UNRELEASED), -- Status_Type
3420: l_mlsupply_items(l_index).job_completion_date, -- Date Completed
3421: l_mlsupply_items(l_index).item_id, --Primary_Item_Id
3422: WIP_CONSTANTS.BASED_ON_BOM, -- Wip_Supply_Type
3423: decode(p_class_code, null, null
3424: , p_class_code), --Accouting Class
3425: 2, --Firm_Planned_Flag
3426: l_mlsupply_items(l_index).needed_item_qty,
3554: null,--706,
3555: SYSDATE,
3556: x_groupID,
3557: 'WICDOL',
3558: WIP_CONSTANTS.ML_VALIDATION,
3559: WIP_CONSTANTS.PENDING, -- process_status
3560: l_ship_org, -- organization id
3561: WIP_CONSTANTS.CREATE_JOB, --Load_Type
3562: nvl(p_status_type, WIP_CONSTANTS.UNRELEASED), -- Status_Type
3555: SYSDATE,
3556: x_groupID,
3557: 'WICDOL',
3558: WIP_CONSTANTS.ML_VALIDATION,
3559: WIP_CONSTANTS.PENDING, -- process_status
3560: l_ship_org, -- organization id
3561: WIP_CONSTANTS.CREATE_JOB, --Load_Type
3562: nvl(p_status_type, WIP_CONSTANTS.UNRELEASED), -- Status_Type
3563: l_mlsupply_items(l_index).job_completion_date, -- Date Completed
3557: 'WICDOL',
3558: WIP_CONSTANTS.ML_VALIDATION,
3559: WIP_CONSTANTS.PENDING, -- process_status
3560: l_ship_org, -- organization id
3561: WIP_CONSTANTS.CREATE_JOB, --Load_Type
3562: nvl(p_status_type, WIP_CONSTANTS.UNRELEASED), -- Status_Type
3563: l_mlsupply_items(l_index).job_completion_date, -- Date Completed
3564: l_mlsupply_items(l_index).item_id, --Primary_Item_Id
3565: WIP_CONSTANTS.BASED_ON_BOM, -- Wip_Supply_Type
3558: WIP_CONSTANTS.ML_VALIDATION,
3559: WIP_CONSTANTS.PENDING, -- process_status
3560: l_ship_org, -- organization id
3561: WIP_CONSTANTS.CREATE_JOB, --Load_Type
3562: nvl(p_status_type, WIP_CONSTANTS.UNRELEASED), -- Status_Type
3563: l_mlsupply_items(l_index).job_completion_date, -- Date Completed
3564: l_mlsupply_items(l_index).item_id, --Primary_Item_Id
3565: WIP_CONSTANTS.BASED_ON_BOM, -- Wip_Supply_Type
3566: decode(p_class_code, null, null
3561: WIP_CONSTANTS.CREATE_JOB, --Load_Type
3562: nvl(p_status_type, WIP_CONSTANTS.UNRELEASED), -- Status_Type
3563: l_mlsupply_items(l_index).job_completion_date, -- Date Completed
3564: l_mlsupply_items(l_index).item_id, --Primary_Item_Id
3565: WIP_CONSTANTS.BASED_ON_BOM, -- Wip_Supply_Type
3566: decode(p_class_code, null, null
3567: , p_class_code), --Accouting Class
3568: 2, --Firm_Planned_Flag
3569: l_mlsupply_items(l_index).needed_item_qty,
3584: (trunc (greatest(nvl(cal.calendar_date,SYSDATE),
3585: SYSDATE),'MI')+1/(60*24) )
3586: ),
3587: decode(nvl(wp.use_finite_scheduler,2), 1,
3588: WIP_CONSTANTS.ML_MANUAL,
3589: null),
3590: decode(nvl(wp.use_finite_scheduler,2), 1,
3591: l_mlsupply_items(l_index).job_start_date,
3592: null)
3687: null,
3688: null,
3689: false,
3690: to_char(x_groupID),
3691: to_char(WIP_CONSTANTS.ATO),
3692: to_char(WIP_CONSTANTS.NO));
3693:
3694:
3695:
3688: null,
3689: false,
3690: to_char(x_groupID),
3691: to_char(WIP_CONSTANTS.ATO),
3692: to_char(WIP_CONSTANTS.NO));
3693:
3694:
3695:
3696: if(l_requestId = 0) then --conc. req not spawned