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_SUB_OP_RESOURCES_PKG dependencies on WIP_SUB_OPERATION_RESOURCES

Line 25: insert into wip_sub_operation_resources(

21: x_user_id := FND_GLOBAL.USER_ID;
22: x_login_id := FND_GLOBAL.LOGIN_ID;
23: -- insert operation resource record
24: begin
25: insert into wip_sub_operation_resources(
26: last_update_date,
27: last_updated_by,
28: creation_date,
29: created_by,

Line 94: from wip_sub_operation_resources

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

Line 130: proc_name => 'WIP_SUB_OPERATION_RESOURCES_PKG.ADD_RESOURCE');

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

Line 170: insert into wip_sub_operation_resources(

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

Line 255: WIP_SUB_OPERATION_RESOURCES WOR

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

Line 270: WIP_SUB_OPERATION_RESOURCES WOR

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

Line 282: WIP_SUB_OPERATION_RESOURCES WOR

278: AND WOR.RESOURCE_SEQ_NUM = p_resource_seq_num)
279: AND NOT EXISTS
280: (SELECT '1'
281: FROM PO_REQUISITIONS_INTERFACE PRI,
282: WIP_SUB_OPERATION_RESOURCES WOR
283: WHERE WOR.WIP_ENTITY_ID = PRI.WIP_ENTITY_ID
284: AND WOR.ORGANIZATION_ID = PRI.DESTINATION_ORGANIZATION_ID
285: AND WOR.OPERATION_SEQ_NUM = PRI.WIP_OPERATION_SEQ_NUM
286: AND WOR.RESOURCE_SEQ_NUM = PRI.WIP_RESOURCE_SEQ_NUM

Line 298: WIP_SUB_OPERATION_RESOURCES WOR

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

Line 316: WIP_SUB_OPERATION_RESOURCES WOR

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

Line 331: WIP_SUB_OPERATION_RESOURCES WOR

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

Line 421: CURSOR C IS SELECT rowid FROM WIP_SUB_OPERATION_RESOURCES

417: X_Replacement_Group_Num NUMBER,
418: X_Setup_Id NUMBER
419:
420: ) IS
421: CURSOR C IS SELECT rowid FROM WIP_SUB_OPERATION_RESOURCES
422: WHERE wip_entity_id = X_Wip_Entity_Id
423: AND organization_id = X_Organization_Id
424: AND operation_seq_num = X_Operation_Seq_Num
425: AND resource_seq_num = X_Resource_Seq_Num

Line 431: INSERT INTO WIP_SUB_OPERATION_RESOURCES(

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

Line 574: FROM WIP_SUB_OPERATION_RESOURCES

570:
571: ) IS
572: CURSOR C IS
573: SELECT *
574: FROM WIP_SUB_OPERATION_RESOURCES
575: WHERE rowid = X_Rowid
576: FOR UPDATE of Wip_Entity_Id NOWAIT;
577: Recinfo C%ROWTYPE;
578: BEGIN

Line 723: UPDATE WIP_SUB_OPERATION_RESOURCES

719: X_Replacement_Group_Num NUMBER,
720: X_Setup_Id NUMBER
721: ) IS
722: BEGIN
723: UPDATE WIP_SUB_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 776: DELETE FROM WIP_SUB_OPERATION_RESOURCES

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

Line 903: INSERT INTO WIP_SUB_OPERATION_RESOURCES(

899: p_organization_id => l_org_id
900: );
901:
902:
903: INSERT INTO WIP_SUB_OPERATION_RESOURCES(
904: wip_entity_id,
905: operation_seq_num,
906: resource_seq_num,
907: organization_id,

Line 1140: FROM WIP_SUB_OPERATION_RESOURCES

1136: substitute_group_num,
1137: replacement_group_num,
1138: NULL,
1139: setup_id
1140: FROM WIP_SUB_OPERATION_RESOURCES
1141: WHERE
1142: wip_entity_id = l_Wip_Entity_Id and
1143: NVL(repetitive_schedule_id, -1) = NVL(l_Repetitive_Sched_Id, -1) and
1144: operation_seq_num = l_Operation_Seq_Num and

Line 1158: from bom_resources br1, WIP_SUB_OPERATION_RESOURCES wsor1

1154: -- Overwrite subinv/loc in WRO for pull components w/ the subinv/loc
1155: -- associated w/ the replacement resource
1156: select br1.supply_subinventory, br1.supply_locator_id
1157: into l_supply_subinventory, l_supply_locator_id
1158: from bom_resources br1, WIP_SUB_OPERATION_RESOURCES wsor1
1159: where br1.resource_id = wsor1.resource_id
1160: and br1.organization_id = wsor1.organization_id
1161: and wsor1.wip_entity_id = l_Wip_Entity_Id
1162: and NVL(wsor1.repetitive_schedule_id, -1) = NVL(l_Repetitive_Sched_Id, -1)

Line 1168: from bom_resources br2, WIP_SUB_OPERATION_RESOURCES wsor2

1164: and wsor1.substitute_group_num = l_Substitute_Group_Num
1165: and wsor1.replacement_group_num = l_Replacement_Group_Num
1166: and wsor1.resource_seq_num in
1167: (select min(wsor2.resource_seq_num)
1168: from bom_resources br2, WIP_SUB_OPERATION_RESOURCES wsor2
1169: where wsor2.wip_entity_id = wsor1.wip_entity_id
1170: and NVL(wsor2.repetitive_schedule_id, -1) = NVL(l_Repetitive_Sched_Id, -1)
1171: and wsor2.organization_id= wsor1.organization_id
1172: and wsor2.operation_seq_num = wsor1.operation_seq_num

Line 1215: DELETE FROM WIP_SUB_OPERATION_RESOURCES

1211: exception when no_data_found then null ;
1212: end;
1213: /* End of this block for bug 4996849 fix. */
1214:
1215: DELETE FROM WIP_SUB_OPERATION_RESOURCES
1216: WHERE
1217: wip_entity_id = l_Wip_Entity_Id and
1218: NVL(repetitive_schedule_id, -1) = NVL(l_Repetitive_Sched_Id, -1) and
1219: operation_seq_num = l_Operation_Seq_Num and