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_OPERATION_RESOURCES_PKG dependencies on WIP_OPERATION_RESOURCES

Line 1: PACKAGE BODY WIP_OPERATION_RESOURCES_PKG AS

1: PACKAGE BODY WIP_OPERATION_RESOURCES_PKG AS
2: /* $Header: wiporesb.pls 120.1 2005/06/20 14:46:44 appldev ship $ */
3:
4: procedure add_resource(
5: p_org_id in number,

Line 23: insert into wip_operation_resources(

19: x_check_for_dup boolean := FALSE;
20: begin
21: -- insert operation resource record
22: begin
23: insert into wip_operation_resources(
24: last_update_date,
25: last_updated_by,
26: creation_date,
27: created_by,

Line 92: from wip_operation_resources

88: select 'X'
89: from dual
90: where c_resource_id =
91: (select resource_id
92: from wip_operation_resources
93: where organization_id = c_org_id
94: and wip_entity_id = c_wip_entity_id
95: and operation_seq_num = c_operation_seq_num
96: and resource_seq_num = c_resource_seq_num

Line 128: proc_name => 'WIP_OPERATION_RESOURCES_PKG.ADD_RESOURCE');

124: exception
125: when OTHERS then
126: wip_constants.get_ora_error(
127: application => 'WIP',
128: proc_name => 'WIP_OPERATION_RESOURCES_PKG.ADD_RESOURCE');
129: fnd_message.raise_error;
130: end add_resource;
131:
132: procedure check_dup_resources(

Line 168: insert into wip_operation_resources(

164: begin
165: -- add resources from interface table
166: -- note: if adding op on the fly, then this procedure should only be called
167: -- after the new op has been added to wip_operations
168: insert into wip_operation_resources(
169: organization_id,
170: wip_entity_id,
171: repetitive_schedule_id,
172: operation_seq_num,

Line 253: WIP_OPERATION_RESOURCES WOR

249: FROM DUAL
250: WHERE NOT EXISTS
251: (SELECT '1'
252: FROM PO_DISTRIBUTIONS_ALL PD,
253: WIP_OPERATION_RESOURCES WOR
254: /* Fixed bug 3115844 */
255: WHERE pd.po_line_id IS NOT NULL
256: AND pd.line_location_id IS NOT NULL
257: AND WOR.WIP_ENTITY_ID = PD.WIP_ENTITY_ID

Line 268: WIP_OPERATION_RESOURCES WOR

264: AND WOR.RESOURCE_SEQ_NUM = p_resource_seq_num)
265: AND NOT EXISTS
266: (SELECT '1'
267: FROM PO_REQUISITION_LINES_ALL PRL,
268: WIP_OPERATION_RESOURCES WOR
269: WHERE WOR.WIP_ENTITY_ID = PRL.WIP_ENTITY_ID
270: AND WOR.ORGANIZATION_ID = PRL.DESTINATION_ORGANIZATION_ID
271: AND WOR.OPERATION_SEQ_NUM = PRL.WIP_OPERATION_SEQ_NUM
272: AND WOR.RESOURCE_SEQ_NUM = PRL.WIP_RESOURCE_SEQ_NUM

Line 280: WIP_OPERATION_RESOURCES WOR

276: AND WOR.RESOURCE_SEQ_NUM = p_resource_seq_num)
277: AND NOT EXISTS
278: (SELECT '1'
279: FROM PO_REQUISITIONS_INTERFACE_ALL PRI,
280: WIP_OPERATION_RESOURCES WOR
281: WHERE WOR.WIP_ENTITY_ID = PRI.WIP_ENTITY_ID
282: AND WOR.ORGANIZATION_ID = PRI.DESTINATION_ORGANIZATION_ID
283: AND WOR.OPERATION_SEQ_NUM = PRI.WIP_OPERATION_SEQ_NUM
284: AND WOR.RESOURCE_SEQ_NUM = PRI.WIP_RESOURCE_SEQ_NUM

Line 296: WIP_OPERATION_RESOURCES WOR

292: FROM DUAL
293: WHERE NOT EXISTS
294: (SELECT '1'
295: FROM PO_DISTRIBUTIONS_ALL PD,
296: WIP_OPERATION_RESOURCES WOR
297: /* Fixed bug 3115844 */
298: WHERE pd.po_line_id IS NOT NULL
299: AND pd.line_location_id IS NOT NULL
300: AND WOR.WIP_ENTITY_ID = PD.WIP_ENTITY_ID

Line 314: WIP_OPERATION_RESOURCES WOR

310: AND WOR.REPETITIVE_SCHEDULE_ID = p_rep_sched_id)
311: AND NOT EXISTS
312: (SELECT '1'
313: FROM PO_REQUISITION_LINES_ALL PRL,
314: WIP_OPERATION_RESOURCES WOR
315: WHERE WOR.WIP_ENTITY_ID = PRL.WIP_ENTITY_ID
316: AND WOR.ORGANIZATION_ID = PRL.DESTINATION_ORGANIZATION_ID
317: AND WOR.OPERATION_SEQ_NUM = PRL.WIP_OPERATION_SEQ_NUM
318: AND WOR.RESOURCE_SEQ_NUM = PRL.WIP_RESOURCE_SEQ_NUM

Line 329: WIP_OPERATION_RESOURCES WOR

325: AND WOR.REPETITIVE_SCHEDULE_ID = p_rep_sched_id)
326: AND NOT EXISTS
327: (SELECT '1'
328: FROM PO_REQUISITIONS_INTERFACE_ALL PRI,
329: WIP_OPERATION_RESOURCES WOR
330: WHERE WOR.WIP_ENTITY_ID = PRI.WIP_ENTITY_ID
331: AND WOR.ORGANIZATION_ID = PRI.DESTINATION_ORGANIZATION_ID
332: AND WOR.OPERATION_SEQ_NUM = PRI.WIP_OPERATION_SEQ_NUM
333: AND WOR.RESOURCE_SEQ_NUM = PRI.WIP_RESOURCE_SEQ_NUM

Line 419: CURSOR C IS SELECT rowid FROM WIP_OPERATION_RESOURCES

415: X_Replacement_Group_Num NUMBER,
416: X_Parent_Resource_Seq NUMBER,
417: X_SetUp_Id NUMBER DEFAULT NULL
418: ) IS
419: CURSOR C IS SELECT rowid FROM WIP_OPERATION_RESOURCES
420: WHERE wip_entity_id = X_Wip_Entity_Id
421: AND organization_id = X_Organization_Id
422: AND operation_seq_num = X_Operation_Seq_Num
423: AND resource_seq_num = X_Resource_Seq_Num

Line 429: INSERT INTO WIP_OPERATION_RESOURCES(

425: OR (repetitive_schedule_id IS NULL
426: AND X_Repetitive_Schedule_Id IS NULL));
427:
428: BEGIN
429: INSERT INTO WIP_OPERATION_RESOURCES(
430: wip_entity_id,
431: operation_seq_num,
432: resource_seq_num,
433: organization_id,

Line 572: FROM WIP_OPERATION_RESOURCES

568: X_Substitute_Group_Num NUMBER
569: ) IS
570: CURSOR C IS
571: SELECT *
572: FROM WIP_OPERATION_RESOURCES
573: WHERE rowid = X_Rowid
574: FOR UPDATE of Wip_Entity_Id NOWAIT;
575: Recinfo C%ROWTYPE;
576: BEGIN

Line 723: UPDATE WIP_OPERATION_RESOURCES

719: X_Parent_Resource_Seq NUMBER,
720: X_SetUp_Id NUMBER DEFAULT NULL
721: ) IS
722: BEGIN
723: UPDATE WIP_OPERATION_RESOURCES
724: SET
725: wip_entity_id = X_Wip_Entity_Id,
726: operation_seq_num = X_Operation_Seq_Num,
727: resource_seq_num = X_Resource_Seq_Num,

Line 777: DELETE FROM WIP_OPERATION_RESOURCES

773: END Update_Row;
774:
775: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
776: BEGIN
777: DELETE FROM WIP_OPERATION_RESOURCES
778: WHERE rowid = X_Rowid;
779:
780: if (SQL%NOTFOUND) then
781: Raise NO_DATA_FOUND;

Line 785: END WIP_OPERATION_RESOURCES_PKG;

781: Raise NO_DATA_FOUND;
782: end if;
783: END Delete_Row;
784:
785: END WIP_OPERATION_RESOURCES_PKG;