DBA Data[Home] [Help]

APPS.CTO_SUBASSEMBLY_SUP_PK dependencies on WIP_CONSTANTS

Line 3450: WIP_CONSTANTS.ML_VALIDATION,

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

Line 3451: WIP_CONSTANTS.PENDING, -- process_status

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

Line 3453: WIP_CONSTANTS.CREATE_JOB, --Load_Type

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

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

Line 3457: WIP_CONSTANTS.BASED_ON_BOM, -- Wip_Supply_Type

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,

Line 3592: WIP_CONSTANTS.ML_VALIDATION,

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

Line 3593: WIP_CONSTANTS.PENDING, -- process_status

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

Line 3595: WIP_CONSTANTS.CREATE_JOB, --Load_Type

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

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

Line 3599: WIP_CONSTANTS.BASED_ON_BOM, -- Wip_Supply_Type

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,

Line 3624: WIP_CONSTANTS.ML_MANUAL,

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)

Line 3727: to_char(WIP_CONSTANTS.ATO),

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:

Line 3728: to_char(WIP_CONSTANTS.NO));

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