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 519: select rowid into X_Rowid from WIP_DISCRETE_JOBS where wip_entity_id=X_wip_entity_id;

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

Line 1051: from wip_discrete_jobs

1047: ,l_prev_attribute14
1048: ,l_prev_attribute15
1049: ,l_prev_project_id --added for bug 5346446
1050: ,l_prev_task_id
1051: from wip_discrete_jobs
1052: where wip_entity_id =X_wip_Entity_Id
1053: and organization_id = X_organization_id;
1054:
1055: EXCEPTION

Line 1330: from wip_discrete_jobs

1326: SAVEPOINT UPDATE_WO;
1327:
1328: select parent_wip_entity_id
1329: into l_old_rebuild_source
1330: from wip_discrete_jobs
1331: where wip_entity_id=X_wip_Entity_Id;
1332:
1333: l_eam_wo_tbl(1) := l_workorder_rec;
1334: l_eam_wo_tbl1(1) := l_workorder_rec1;

Line 1742: FROM WIP_DISCRETE_JOBS

1738: X_activity_source VARCHAR2) IS
1739:
1740: CURSOR C_WDJ IS
1741: SELECT *
1742: FROM WIP_DISCRETE_JOBS
1743: WHERE rowid = X_Rowid
1744: FOR UPDATE of Wip_Entity_Id NOWAIT;
1745:
1746: CURSOR C_WE IS

Line 1763: -- Wip Discrete Jobs

1759: Recinfo2 C_WE%ROWTYPE;
1760: Recinfo3 C_EWOD%ROWTYPE;
1761:
1762: BEGIN
1763: -- Wip Discrete Jobs
1764: OPEN C_WDJ;
1765: FETCH C_WDJ INTO Recinfo1;
1766: if (C_WDJ%NOTFOUND) then
1767: CLOSE C_WDJ;

Line 1899: -- Wip Discrete Jobs

1895: null;
1896: end if;
1897:
1898: -- Wip Entities
1899: -- Wip Discrete Jobs
1900: OPEN C_WE;
1901: FETCH C_WE INTO Recinfo2;
1902: if (C_WE%NOTFOUND) then
1903: CLOSE C_WE;