APPS.EAM_WORKORDER_PKG dependencies on WIP_DISCRETE_JOBS

Line 21: l_status WIP_DISCRETE_JOBS.status_type%TYPE;

17: x_returnStatus varchar2(5);
18: l_msgCount Number;
19: l_msgData varchar2(100);
20: l_error_message varchar2(4000);
21: l_status WIP_DISCRETE_JOBS.status_type%TYPE;
22:
23: BEGIN
24:
25: --added the following procedure to fix bug number 2899984. This procedure checks to see if

Line 56: from wip_discrete_jobs

52: if (x_maintenance_object_type = 3) then
53:
54: select status_type
55: into l_status
56: from wip_discrete_jobs
57: where wip_entity_id = X_parent_wip_entity_id
58: and organization_id = X_organization_id;
59:
60: if (l_status in (12, 14, 15, 4, 5, 7)) then

Line 521: select rowid into X_Rowid from WIP_DISCRETE_JOBS where wip_entity_id=X_wip_entity_id;

517:
518: X_wip_entity_id := l_workorder_rec1.wip_entity_id;
519:
520: select rowid into X_We_Rowid from WIP_ENTITIES where wip_entity_id=X_wip_entity_id;
521: select rowid into X_Rowid from WIP_DISCRETE_JOBS where wip_entity_id=X_wip_entity_id;
522: COMMIT;
523:
524: else
525: X_wip_entity_id := 0;

Line 1056: from wip_discrete_jobs

1052: ,l_prev_attribute14
1053: ,l_prev_attribute15
1054: ,l_prev_project_id --added for bug 5346446
1055: ,l_prev_task_id
1056: from wip_discrete_jobs
1057: where wip_entity_id =X_wip_Entity_Id
1058: and organization_id = X_organization_id;
1059:
1060: EXCEPTION

Line 1335: from wip_discrete_jobs

1331: SAVEPOINT UPDATE_WO;
1332:
1333: select parent_wip_entity_id
1334: into l_old_rebuild_source
1335: from wip_discrete_jobs
1336: where wip_entity_id=X_wip_Entity_Id;
1337:
1338: l_eam_wo_tbl(1) := l_workorder_rec;
1339: l_eam_wo_tbl1(1) := l_workorder_rec1;

Line 1748: FROM WIP_DISCRETE_JOBS

1744: X_activity_source VARCHAR2) IS
1745:
1746: CURSOR C_WDJ IS
1747: SELECT *
1748: FROM WIP_DISCRETE_JOBS
1749: WHERE rowid = X_Rowid
1750: FOR UPDATE of Wip_Entity_Id NOWAIT;
1751:
1752: CURSOR C_WE IS

Line 1769: -- Wip Discrete Jobs

1765: Recinfo2 C_WE%ROWTYPE;
1766: Recinfo3 C_EWOD%ROWTYPE;
1767:
1768: BEGIN
1769: -- Wip Discrete Jobs
1770: OPEN C_WDJ;
1771: FETCH C_WDJ INTO Recinfo1;
1772: if (C_WDJ%NOTFOUND) then
1773: CLOSE C_WDJ;

Line 1905: -- Wip Discrete Jobs

1901: null;
1902: end if;
1903:
1904: -- Wip Entities
1905: -- Wip Discrete Jobs
1906: OPEN C_WE;
1907: FETCH C_WE INTO Recinfo2;
1908: if (C_WE%NOTFOUND) then
1909: CLOSE C_WE;