290: SYSDATE, /* Last Update Date */
291: p_wip_seq, /* group_id */
292: 'WICDOL', /* source_code */
293: oel.line_id, /* source line id */
294: WIP_CONSTANTS.ML_VALIDATION, /* process_phase */
295: WIP_CONSTANTS.PENDING, /* process_status */
296: oel.ship_from_org_id, /* organization id */
297: WIP_CONSTANTS.CREATE_JOB, /* Load_Type */
298: nvl(p_status_type, WIP_CONSTANTS.UNRELEASED),/* Status_Type */
291: p_wip_seq, /* group_id */
292: 'WICDOL', /* source_code */
293: oel.line_id, /* source line id */
294: WIP_CONSTANTS.ML_VALIDATION, /* process_phase */
295: WIP_CONSTANTS.PENDING, /* process_status */
296: oel.ship_from_org_id, /* organization id */
297: WIP_CONSTANTS.CREATE_JOB, /* Load_Type */
298: nvl(p_status_type, WIP_CONSTANTS.UNRELEASED),/* Status_Type */
299: oel.schedule_ship_date, /* Date Completed */
293: oel.line_id, /* source line id */
294: WIP_CONSTANTS.ML_VALIDATION, /* process_phase */
295: WIP_CONSTANTS.PENDING, /* process_status */
296: oel.ship_from_org_id, /* organization id */
297: WIP_CONSTANTS.CREATE_JOB, /* Load_Type */
298: nvl(p_status_type, WIP_CONSTANTS.UNRELEASED),/* Status_Type */
299: oel.schedule_ship_date, /* Date Completed */
300: oel.inventory_item_id, /* Primary_Item_Id */
301: WIP_CONSTANTS.BASED_ON_BOM, /* Wip_Supply_Type */
294: WIP_CONSTANTS.ML_VALIDATION, /* process_phase */
295: WIP_CONSTANTS.PENDING, /* process_status */
296: oel.ship_from_org_id, /* organization id */
297: WIP_CONSTANTS.CREATE_JOB, /* Load_Type */
298: nvl(p_status_type, WIP_CONSTANTS.UNRELEASED),/* Status_Type */
299: oel.schedule_ship_date, /* Date Completed */
300: oel.inventory_item_id, /* Primary_Item_Id */
301: WIP_CONSTANTS.BASED_ON_BOM, /* Wip_Supply_Type */
302: decode(p_class_code, null, null
297: WIP_CONSTANTS.CREATE_JOB, /* Load_Type */
298: nvl(p_status_type, WIP_CONSTANTS.UNRELEASED),/* Status_Type */
299: oel.schedule_ship_date, /* Date Completed */
300: oel.inventory_item_id, /* Primary_Item_Id */
301: WIP_CONSTANTS.BASED_ON_BOM, /* Wip_Supply_Type */
302: decode(p_class_code, null, null
303: , p_class_code), /* Accouting Class */
304: 2, /* Firm_Planned_Flag */
305: oel.demand_class_code, /* Demand Class */
507: SYSDATE, /* Last Update Date */
508: p_wip_seq, /* group_id */
509: 'WICDOL', /* source_code */
510: oel.line_id, /* source line id */
511: WIP_CONSTANTS.ML_VALIDATION, /* process_phase */
512: WIP_CONSTANTS.PENDING, /* process_status */
513: oel.ship_from_org_id, /* organization id */
514: WIP_CONSTANTS.CREATE_JOB, /* Load_Type */
515: nvl(p_status_type, WIP_CONSTANTS.UNRELEASED),/* Status_Type */
508: p_wip_seq, /* group_id */
509: 'WICDOL', /* source_code */
510: oel.line_id, /* source line id */
511: WIP_CONSTANTS.ML_VALIDATION, /* process_phase */
512: WIP_CONSTANTS.PENDING, /* process_status */
513: oel.ship_from_org_id, /* organization id */
514: WIP_CONSTANTS.CREATE_JOB, /* Load_Type */
515: nvl(p_status_type, WIP_CONSTANTS.UNRELEASED),/* Status_Type */
516: oel.schedule_ship_date, /* Date Completed */
510: oel.line_id, /* source line id */
511: WIP_CONSTANTS.ML_VALIDATION, /* process_phase */
512: WIP_CONSTANTS.PENDING, /* process_status */
513: oel.ship_from_org_id, /* organization id */
514: WIP_CONSTANTS.CREATE_JOB, /* Load_Type */
515: nvl(p_status_type, WIP_CONSTANTS.UNRELEASED),/* Status_Type */
516: oel.schedule_ship_date, /* Date Completed */
517: oel.inventory_item_id, /* Primary_Item_Id */
518: WIP_CONSTANTS.BASED_ON_BOM, /* Wip_Supply_Type */
511: WIP_CONSTANTS.ML_VALIDATION, /* process_phase */
512: WIP_CONSTANTS.PENDING, /* process_status */
513: oel.ship_from_org_id, /* organization id */
514: WIP_CONSTANTS.CREATE_JOB, /* Load_Type */
515: nvl(p_status_type, WIP_CONSTANTS.UNRELEASED),/* Status_Type */
516: oel.schedule_ship_date, /* Date Completed */
517: oel.inventory_item_id, /* Primary_Item_Id */
518: WIP_CONSTANTS.BASED_ON_BOM, /* Wip_Supply_Type */
519: decode(p_class_code, null, null
514: WIP_CONSTANTS.CREATE_JOB, /* Load_Type */
515: nvl(p_status_type, WIP_CONSTANTS.UNRELEASED),/* Status_Type */
516: oel.schedule_ship_date, /* Date Completed */
517: oel.inventory_item_id, /* Primary_Item_Id */
518: WIP_CONSTANTS.BASED_ON_BOM, /* Wip_Supply_Type */
519: decode(p_class_code, null, null
520: , p_class_code),
521: /* Accouting Class */
522: 2, /* Firm_Planned_Flag */