DBA Data[Home] [Help]

APPS.WIP_REBUILD dependencies on WIP_CONSTANTS

Line 51: wip_constants.CREATE_EAM_JOB,

47: mmtt.request_id,
48: mmtt.program_application_id,
49: mmtt.program_id,
50: mmtt.program_update_date,
51: wip_constants.CREATE_EAM_JOB,
52: x_groupID,
53: wip_constants.routing,
54: SYSDATE,
55: mmtt.rebuild_job_name,

Line 53: wip_constants.routing,

49: mmtt.program_id,
50: mmtt.program_update_date,
51: wip_constants.CREATE_EAM_JOB,
52: x_groupID,
53: wip_constants.routing,
54: SYSDATE,
55: mmtt.rebuild_job_name,
56: msi.description,
57: mmtt.rebuild_activity_id,

Line 59: wip_constants.ML_VALIDATION,

55: mmtt.rebuild_job_name,
56: msi.description,
57: mmtt.rebuild_activity_id,
58: mmtt.organization_id,
59: wip_constants.ML_VALIDATION,
60: wip_constants.pending,
61: mmtt.rebuild_item_id,
62: mmtt.rebuild_serial_number,
63: mmtt.transaction_source_id,

Line 60: wip_constants.pending,

56: msi.description,
57: mmtt.rebuild_activity_id,
58: mmtt.organization_id,
59: wip_constants.ML_VALIDATION,
60: wip_constants.pending,
61: mmtt.rebuild_item_id,
62: mmtt.rebuild_serial_number,
63: mmtt.transaction_source_id,
64: 'N',

Line 142: if (l_serial_status <> WIP_CONSTANTS.DEF_NOT_USED) then /*Bug 3655393*/

138: and current_organization_id= l_orgID
139: and inventory_item_id = l_rebuildItemID;
140: end if;
141:
142: if (l_serial_status <> WIP_CONSTANTS.DEF_NOT_USED) then /*Bug 3655393*/
143: wip_eam_genealogy_pvt.update_eam_genealogy(
144: p_api_version => 1.0,
145: p_object_type => 2, -- serial number
146: p_serial_number => l_rebuildSerNum,