DBA Data[Home] [Help]

APPS.CTO_SUBASSEMBLY_SUP_PK dependencies on WIP_CONSTANTS

Line 3415: WIP_CONSTANTS.ML_VALIDATION,

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

Line 3416: WIP_CONSTANTS.PENDING, -- process_status

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

Line 3418: WIP_CONSTANTS.CREATE_JOB, --Load_Type

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

Line 3419: nvl(p_status_type, WIP_CONSTANTS.UNRELEASED), -- Status_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

Line 3422: WIP_CONSTANTS.BASED_ON_BOM, -- Wip_Supply_Type

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,

Line 3558: WIP_CONSTANTS.ML_VALIDATION,

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

Line 3559: WIP_CONSTANTS.PENDING, -- process_status

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

Line 3561: WIP_CONSTANTS.CREATE_JOB, --Load_Type

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

Line 3562: nvl(p_status_type, WIP_CONSTANTS.UNRELEASED), -- Status_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

Line 3565: WIP_CONSTANTS.BASED_ON_BOM, -- Wip_Supply_Type

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,

Line 3588: WIP_CONSTANTS.ML_MANUAL,

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)

Line 3691: to_char(WIP_CONSTANTS.ATO),

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:

Line 3692: to_char(WIP_CONSTANTS.NO));

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