eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_OPERATIONS_PKG dependencies on WIP_OPERATIONS

Line 1: PACKAGE BODY WIP_OPERATIONS_PKG AS

1: PACKAGE BODY WIP_OPERATIONS_PKG AS
2: /* $Header: wipoperb.pls 120.5.12020000.3 2012/08/30 06:02:18 akuppa ship $ */
3:
4: g_start_date DATE;
5:

Line 35: wip_operations wo1,

31: min(wo2.operation_seq_num)
32: into x_prev_op_seq_num,
33: x_next_op_seq_num
34: from dual sd,
35: wip_operations wo1,
36: wip_operations wo2
37: where wo1.organization_id(+) = p_org_id
38: and wo1.wip_entity_id(+) = decode(1, 1, p_wip_entity_id, sd.dummy)
39: and wo1.operation_seq_num(+) < p_operation_seq_num

Line 36: wip_operations wo2

32: into x_prev_op_seq_num,
33: x_next_op_seq_num
34: from dual sd,
35: wip_operations wo1,
36: wip_operations wo2
37: where wo1.organization_id(+) = p_org_id
38: and wo1.wip_entity_id(+) = decode(1, 1, p_wip_entity_id, sd.dummy)
39: and wo1.operation_seq_num(+) < p_operation_seq_num
40: and wo2.organization_id(+) = p_org_id

Line 48: FROM wip_operations

44: /* For Enhancement#2864382. Calculate cumulative_scrap_quantity for this operation */
45:
46: SELECT SUM(quantity_scrapped)
47: INTO l_scrap_qty
48: FROM wip_operations
49: WHERE organization_id = p_org_id
50: AND wip_entity_id = p_wip_entity_id
51: AND operation_seq_num < p_operation_seq_num;
52:

Line 59: update wip_operations

55: END IF;
56:
57: -- if prev operation exists in routing
58: if (x_prev_op_seq_num is NOT NULL) then
59: update wip_operations
60: set next_operation_seq_num = p_operation_seq_num
61: where organization_id = p_org_id
62: and wip_entity_id = p_wip_entity_id
63: and operation_seq_num = x_prev_op_seq_num;

Line 68: update wip_operations

64: end if;
65:
66: -- if next operation exists in routing
67: if (x_next_op_seq_num is NOT NULL) then
68: update wip_operations
69: set previous_operation_seq_num = p_operation_seq_num
70: where organization_id = p_org_id
71: and wip_entity_id = p_wip_entity_id
72: and operation_seq_num = x_next_op_seq_num;

Line 77: insert into wip_operations(

73: end if;
74:
75: -- add operation
76: begin
77: insert into wip_operations(
78: wip_entity_id,
79: operation_seq_num,
80: organization_id,
81: last_update_date,

Line 173: from wip_operations wo1,

169: bso.attribute13,
170: bso.attribute14,
171: bso.attribute15,
172: bso.check_skill
173: from wip_operations wo1,
174: wip_discrete_jobs wdj,
175: bom_standard_operations bso
176: where bso.standard_operation_id(+) = p_operation_id
177: /* %cfm Ignore cfm ops. */

Line 283: from wip_operations wo,

279: bsor.attribute15,
280: bsor.substitute_group_num, -- Added : -- bug 7371859
281: bsor.schedule_seq_num,bsor.principle_flag, -- Added : -- bug 7371859(Schedule Seq Num= Resource Seq Num)
282: 0 -- Added : -- bug 7371859
283: from wip_operations wo,
284: bom_resources br,
285: bom_std_op_resources bsor
286: where bsor.standard_operation_id = p_operation_id
287: and br.resource_id = bsor.resource_id

Line 321: WIP_OPERATIONS WO,

317: BOS.STANDARD_OPERATION_ID, BOS.COMPETENCE_ID, BOS.RATING_LEVEL_ID,
318: BOS.QUALIFICATION_TYPE_ID, WO.LAST_UPDATE_DATE, WO.LAST_UPDATED_BY,
319: WO.LAST_UPDATE_LOGIN, WO.CREATED_BY, WO.CREATION_DATE
320: FROM BOM_OPERATION_SKILLS BOS,
321: WIP_OPERATIONS WO,
322: WIP_ENTITIES WE
323: WHERE
324: WE.WIP_ENTITY_ID = WO.WIP_ENTITY_ID
325: AND WO.ORGANIZATION_ID = WO.ORGANIZATION_ID

Line 464: proc_name => 'WIP_OPERATIONS_PKG.ADD');

460: exception
461: when others then
462: wip_constants.get_ora_error(
463: application => 'WIP',
464: proc_name => 'WIP_OPERATIONS_PKG.ADD');
465: fnd_message.raise_error;
466:
467: end add;
468:

Line 519: CURSOR C IS SELECT rowid FROM WIP_OPERATIONS

515: X_Attribute13 VARCHAR2,
516: X_Attribute14 VARCHAR2,
517: X_Attribute15 VARCHAR2,
518: X_CHECK_SKILL NUMBER DEFAULT NULL) IS
519: CURSOR C IS SELECT rowid FROM WIP_OPERATIONS
520: WHERE wip_entity_id = X_Wip_Entity_Id
521: AND operation_seq_num = X_Operation_Seq_Num
522: AND organization_id = X_Organization_Id
523: AND (repetitive_Schedule_id = X_Repetitive_Schedule_Id

Line 541: FROM wip_operations

537: eration */
538:
539: SELECT SUM(quantity_scrapped)
540: INTO l_scrap_qty
541: FROM wip_operations
542: WHERE organization_id = X_Organization_Id
543: AND wip_entity_id = X_Wip_Entity_Id
544: AND (repetitive_schedule_id = X_Repetitive_Schedule_Id OR
545: (repetitive_schedule_id IS NULL AND X_Repetitive_Schedule_Id IS NULL))

Line 552: INSERT INTO WIP_OPERATIONS(

548: IF (l_scrap_qty IS NULL) THEN
549: l_scrap_qty :=0;
550: END IF;
551:
552: INSERT INTO WIP_OPERATIONS(
553: wip_entity_id,
554: operation_seq_num,
555: organization_id,
556: repetitive_schedule_id,

Line 698: WIP_OPERATIONS WO,

694: BOS.STANDARD_OPERATION_ID, BOS.COMPETENCE_ID, BOS.RATING_LEVEL_ID,
695: BOS.QUALIFICATION_TYPE_ID, WO.LAST_UPDATE_DATE, WO.LAST_UPDATED_BY,
696: WO.LAST_UPDATE_LOGIN, WO.CREATED_BY, WO.CREATION_DATE
697: FROM BOM_OPERATION_SKILLS BOS,
698: WIP_OPERATIONS WO,
699: WIP_ENTITIES WE
700: WHERE
701: WE.WIP_ENTITY_ID = WO.WIP_ENTITY_ID
702: AND WO.ORGANIZATION_ID = WO.ORGANIZATION_ID

Line 769: FROM WIP_OPERATIONS

765:
766: ) IS
767: CURSOR C IS
768: SELECT *
769: FROM WIP_OPERATIONS
770: WHERE rowid = X_Rowid
771: FOR UPDATE of Wip_Entity_Id NOWAIT;
772: Recinfo C%ROWTYPE;
773: BEGIN

Line 939: UPDATE WIP_OPERATIONS

935: X_CHECK_SKILL NUMBER DEFAULT NULL
936:
937: ) IS
938: BEGIN
939: UPDATE WIP_OPERATIONS
940: SET
941: wip_entity_id = X_Wip_Entity_Id,
942: operation_seq_num = X_Operation_Seq_Num,
943: organization_id = X_Organization_Id,

Line 995: DELETE FROM WIP_OPERATIONS

991: END Update_Row;
992:
993: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
994: BEGIN
995: DELETE FROM WIP_OPERATIONS
996: WHERE rowid = X_Rowid;
997:
998: if (SQL%NOTFOUND) then
999: Raise NO_DATA_FOUND;

Line 1310: WIP_OPERATIONS_UTILITIES.Delete_Resources(

1306: if (X_Return_Status <> fnd_api.g_ret_sts_success) then
1307: return;
1308: end if;
1309:
1310: WIP_OPERATIONS_UTILITIES.Delete_Resources(
1311: x_wip_entity_id => P_Wip_Entity_Id,
1312: x_organization_id => P_Organization_Id,
1313: x_operation_seq_num => P_Operation_Seq_Num,
1314: x_repetitive_schedule_id => null,

Line 1348: WIP_OPERATIONS_UTILITIES.Get_Prev_Next_Op(X_Wip_Entity_Id => P_Wip_Entity_Id,

1344: AND operation_seq_num = P_Operation_Seq_Num
1345: AND organization_id = P_Organization_Id;
1346:
1347: -- Bug 13770893. Adjust Previous and Next operations before deleting it.
1348: WIP_OPERATIONS_UTILITIES.Get_Prev_Next_Op(X_Wip_Entity_Id => P_Wip_Entity_Id,
1349: X_Organization_Id => P_Organization_Id,
1350: X_Operation_Seq_Num => P_Operation_Seq_Num,
1351: X_Repetitive_Schedule_Id => null,
1352: X_Insert_Flag => FALSE,

Line 1356: DELETE from WIP_OPERATIONS

1352: X_Insert_Flag => FALSE,
1353: X_Prev_Op_Seq => l_Prev_Op_Seq,
1354: X_Next_Op_Seq => l_Next_Op_Seq);
1355:
1356: DELETE from WIP_OPERATIONS
1357: WHERE wip_entity_id = P_Wip_Entity_Id
1358: AND operation_seq_num = P_Operation_Seq_Num
1359: AND organization_id = P_Organization_Id;
1360:

Line 1361: WIP_OPERATIONS_UTILITIES.Check_Requirements(P_Wip_Entity_Id,

1357: WHERE wip_entity_id = P_Wip_Entity_Id
1358: AND operation_seq_num = P_Operation_Seq_Num
1359: AND organization_id = P_Organization_Id;
1360:
1361: WIP_OPERATIONS_UTILITIES.Check_Requirements(P_Wip_Entity_Id,
1362: P_Organization_Id,
1363: P_Operation_Seq_Num,
1364: null,
1365: g_start_date);

Line 1409: from wip_operations

1405: and organization_id = P_Organization_Id;
1406:
1407: select quantity_in_queue,quantity_running,quantity_waiting_to_move,quantity_rejected,quantity_scrapped,quantity_completed
1408: into l_quantity_in_queue,l_quantity_running,l_quantity_waiting_to_move,l_quantity_rejected,l_quantity_scrapped,l_quantity_completed
1409: from wip_operations
1410: where wip_entity_id= P_Wip_Entity_Id
1411: and organization_id = P_Organization_Id
1412: and operation_seq_num = P_Operation_Seq_Num;
1413:

Line 1421: wip_operations_utilities.pending_op_txns(P_Wip_Entity_Id,P_Organization_Id,P_Operation_Seq_Num,null,null) = TRUE

1417: l_quantity_waiting_to_move <> 0 OR
1418: l_quantity_rejected <> 0 OR
1419: l_quantity_scrapped <> 0 OR
1420: l_quantity_completed <> 0 OR
1421: wip_operations_utilities.pending_op_txns(P_Wip_Entity_Id,P_Organization_Id,P_Operation_Seq_Num,null,null) = TRUE
1422: THEN
1423: FND_MESSAGE.SET_NAME('WIP','WIP_DELETE_OPERATION');
1424: X_Error_Message := fnd_message.get;
1425: X_Return_Status := fnd_api.g_ret_sts_error;

Line 1435: END WIP_OPERATIONS_PKG;

1431: X_Return_Status := fnd_api.g_ret_sts_unexp_error;
1432: return;
1433: END Valid_Op_Delete;
1434:
1435: END WIP_OPERATIONS_PKG;