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 STANDARD

Line 19: adding_standard_op boolean := (p_operation_id is NOT NULL

15: x_login_id number := FND_GLOBAL.LOGIN_ID;
16: x_request_id number := FND_GLOBAL.CONC_REQUEST_ID;
17: x_appl_id number := FND_GLOBAL.PROG_APPL_ID;
18: x_program_id number := FND_GLOBAL.CONC_PROGRAM_ID;
19: adding_standard_op boolean := (p_operation_id is NOT NULL
20: or
21: p_operation_id = -1);
22: l_scrap_qty number := 0;
23: /* Added : -- bug 7371859 */

Line 86: standard_operation_id,

82: last_updated_by,
83: creation_date,
84: created_by,
85: last_update_login,
86: standard_operation_id,
87: department_id,
88: scheduled_quantity,
89: quantity_in_queue,
90: quantity_running,

Line 175: bom_standard_operations bso

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. */
178: and nvl(bso.operation_type, 1) = 1
179: and bso.line_id is null

Line 176: where bso.standard_operation_id(+) = p_operation_id

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. */
178: and nvl(bso.operation_type, 1) = 1
179: and bso.line_id is null
180: /* %/cfm */

Line 198: -- if standard operation, add resources and instructions

194: name => 'WIP_SAME_OP_EXISTS');
195: fnd_message.raise_error;
196: end;
197:
198: -- if standard operation, add resources and instructions
199: if (adding_standard_op) then
200: insert into wip_operation_resources
201: (wip_entity_id,
202: operation_seq_num,

Line 199: if (adding_standard_op) then

195: fnd_message.raise_error;
196: end;
197:
198: -- if standard operation, add resources and instructions
199: if (adding_standard_op) then
200: insert into wip_operation_resources
201: (wip_entity_id,
202: operation_seq_num,
203: resource_seq_num,

Line 218: standard_rate_flag,

214: activity_id,
215: scheduled_flag,
216: assigned_units,
217: autocharge_type,
218: standard_rate_flag,
219: applied_resource_units,
220: applied_resource_value,
221: start_date,
222: completion_date,

Line 259: bsor.standard_rate_flag,

255: bsor.activity_id,
256: bsor.schedule_flag,
257: bsor.assigned_units,
258: bsor.autocharge_type,
259: bsor.standard_rate_flag,
260: 0, -- applied_resource_units
261: 0, -- applied_resource_value
262: wo.first_unit_start_date,
263: wo.last_unit_completion_date,

Line 286: where bsor.standard_operation_id = p_operation_id

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
288: and nvl(br.disable_date, SYSDATE + 1) > SYSDATE
289: and wo.organization_id = p_org_id
290: and wo.wip_entity_id = p_wip_entity_id

Line 294: X_FROM_ENTITY_NAME => 'BOM_STANDARD_OPERATIONS',

290: and wo.wip_entity_id = p_wip_entity_id
291: and wo.operation_seq_num = p_operation_seq_num;
292:
293: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
294: X_FROM_ENTITY_NAME => 'BOM_STANDARD_OPERATIONS',
295: X_FROM_PK1_VALUE => to_char(p_operation_id),
296: X_TO_ENTITY_NAME => 'WIP_DISCRETE_OPERATIONS',
297: X_TO_PK1_VALUE => to_char(p_wip_entity_id),
298: X_TO_PK2_VALUE => to_char(p_operation_seq_num),

Line 311: STANDARD_OPERATION_ID, COMPETENCE_ID, RATING_LEVEL_ID,

307: /* Added for 12.1.1 Skills Validation project.*/
308: INSERT INTO WIP_OPERATION_COMPETENCIES
309: ( LEVEL_ID, ORGANIZATION_ID,
310: WIP_ENTITY_ID, OPERATION_SEQ_NUM, OPERATION_SEQUENCE_ID,
311: STANDARD_OPERATION_ID, COMPETENCE_ID, RATING_LEVEL_ID,
312: QUALIFICATION_TYPE_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
313: LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE)
314: SELECT
315: 3, WO.ORGANIZATION_ID,

Line 317: BOS.STANDARD_OPERATION_ID, BOS.COMPETENCE_ID, BOS.RATING_LEVEL_ID,

313: LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE)
314: SELECT
315: 3, WO.ORGANIZATION_ID,
316: WO.WIP_ENTITY_ID, WO.OPERATION_SEQ_NUM, BOS.OPERATION_SEQUENCE_ID,
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,

Line 331: AND BOS.STANDARD_OPERATION_ID = p_operation_id

327: AND WO.ORGANIZATION_ID = p_org_id
328: AND WO.WIP_ENTITY_ID = p_wip_entity_id
329: AND WO.OPERATION_SEQ_NUM = p_operation_seq_num
330: AND WO.ORGANIZATION_ID = BOS.ORGANIZATION_ID
331: AND BOS.STANDARD_OPERATION_ID = p_operation_id
332: AND BOS.LEVEL_ID = 1;
333:
334: BEGIN
335: SELECT count(*)

Line 338: WHERE BSSOR.STANDARD_OPERATION_ID=p_operation_id;

334: BEGIN
335: SELECT count(*)
336: INTO sub_res_count
337: FROM BOM_STD_SUB_OP_RESOURCES BSSOR
338: WHERE BSSOR.STANDARD_OPERATION_ID=p_operation_id;
339: EXCEPTION
340: WHEN no_data_found THEN
341: null;
342: END ;

Line 377: standard_rate_flag,

373: scheduled_flag,
374: assigned_units,
375: maximum_assigned_units,
376: autocharge_type,
377: standard_rate_flag,
378: applied_resource_units,
379: applied_resource_value,
380: attribute_category,
381: attribute1,

Line 421: BSSOR.standard_rate_flag,

417: BSSOR.schedule_flag,
418: BSSOR.assigned_units,
419: BSSOR.assigned_units,
420: BSSOR.autocharge_type,
421: BSSOR.standard_rate_flag,
422: 0, --WCOR.applied_resource_units,
423: 0, -- WCOR.applied_resource_value,
424: BSSOR.attribute_category,
425: BSSOR.attribute1,

Line 448: WHERE bssor.standard_operation_id=p_operation_id

444: BSSOR.replacement_group_num,
445: NULL --setup_id
446: FROM BOM_RESOURCES BR,
447: BOM_STD_SUB_OP_RESOURCES BSSOR
448: WHERE bssor.standard_operation_id=p_operation_id
449: AND BSSOR.RESOURCE_ID = BR.RESOURCE_ID;
450:
451: End IF;
452: /* End : -- bug 7371859 */

Line 481: X_Standard_Operation_Id NUMBER,

477: X_Creation_Date DATE,
478: X_Created_By NUMBER,
479: X_Last_Update_Login NUMBER,
480: X_Operation_Sequence_Id NUMBER,
481: X_Standard_Operation_Id NUMBER,
482: X_Department_Id NUMBER,
483: X_Description VARCHAR2,
484: X_Scheduled_Quantity NUMBER,
485: X_Quantity_In_Queue NUMBER,

Line 531: x_standard_op boolean := (X_Standard_Operation_Id is NOT NULL);

527: x_login_id number := FND_GLOBAL.LOGIN_ID;
528: x_request_id number := FND_GLOBAL.CONC_REQUEST_ID;
529: x_appl_id number := FND_GLOBAL.PROG_APPL_ID;
530: x_program_id number := FND_GLOBAL.CONC_PROGRAM_ID;
531: x_standard_op boolean := (X_Standard_Operation_Id is NOT NULL);
532: l_scrap_qty number :=0;
533:
534: BEGIN
535:

Line 563: standard_operation_id,

559: creation_date,
560: created_by,
561: last_update_login,
562: operation_sequence_id,
563: standard_operation_id,
564: department_id,
565: description,
566: scheduled_quantity,
567: quantity_in_queue,

Line 613: X_Standard_Operation_Id,

609: X_Creation_Date,
610: X_Created_By,
611: X_Last_Update_Login,
612: X_Operation_Sequence_Id,
613: X_Standard_Operation_Id,
614: X_Department_Id,
615: X_Description,
616: X_Scheduled_Quantity,
617: X_Quantity_In_Queue,

Line 657: X_FROM_ENTITY_NAME => 'BOM_STANDARD_OPERATIONS',

653:
654:
655: IF (X_Repetitive_Schedule_Id IS NULL) THEN
656: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
657: X_FROM_ENTITY_NAME => 'BOM_STANDARD_OPERATIONS',
658: X_FROM_PK1_VALUE => to_char(X_Standard_Operation_Id),
659: X_TO_ENTITY_NAME => 'WIP_DISCRETE_OPERATIONS',
660: X_TO_PK1_VALUE => to_char(X_Wip_Entity_Id),
661: X_TO_PK2_VALUE => to_char(X_Operation_Seq_Num),

Line 658: X_FROM_PK1_VALUE => to_char(X_Standard_Operation_Id),

654:
655: IF (X_Repetitive_Schedule_Id IS NULL) THEN
656: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
657: X_FROM_ENTITY_NAME => 'BOM_STANDARD_OPERATIONS',
658: X_FROM_PK1_VALUE => to_char(X_Standard_Operation_Id),
659: X_TO_ENTITY_NAME => 'WIP_DISCRETE_OPERATIONS',
660: X_TO_PK1_VALUE => to_char(X_Wip_Entity_Id),
661: X_TO_PK2_VALUE => to_char(X_Operation_Seq_Num),
662: X_TO_PK3_VALUE => to_char(X_Organization_Id),

Line 670: X_FROM_ENTITY_NAME => 'BOM_STANDARD_OPERATIONS',

666: X_PROGRAM_ID => x_program_id,
667: X_REQUEST_ID => x_request_id);
668: ELSE
669: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
670: X_FROM_ENTITY_NAME => 'BOM_STANDARD_OPERATIONS',
671: X_FROM_PK1_VALUE => to_char(X_Standard_Operation_Id),
672: X_TO_ENTITY_NAME => 'WIP_REPETITIVE_OPERATIONS',
673: X_TO_PK1_VALUE => to_char(X_Wip_Entity_Id),
674: X_TO_PK2_VALUE => to_char(X_Operation_Seq_Num),

Line 671: X_FROM_PK1_VALUE => to_char(X_Standard_Operation_Id),

667: X_REQUEST_ID => x_request_id);
668: ELSE
669: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
670: X_FROM_ENTITY_NAME => 'BOM_STANDARD_OPERATIONS',
671: X_FROM_PK1_VALUE => to_char(X_Standard_Operation_Id),
672: X_TO_ENTITY_NAME => 'WIP_REPETITIVE_OPERATIONS',
673: X_TO_PK1_VALUE => to_char(X_Wip_Entity_Id),
674: X_TO_PK2_VALUE => to_char(X_Operation_Seq_Num),
675: X_TO_PK3_VALUE => to_char(X_Organization_Id),

Line 688: STANDARD_OPERATION_ID, COMPETENCE_ID, RATING_LEVEL_ID,

684: /* Added for 12.1.1 Skills Validation project.*/
685: /*INSERT INTO WIP_OPERATION_COMPETENCIES
686: ( LEVEL_ID, ORGANIZATION_ID,
687: WIP_ENTITY_ID, OPERATION_SEQ_NUM, OPERATION_SEQUENCE_ID,
688: STANDARD_OPERATION_ID, COMPETENCE_ID, RATING_LEVEL_ID,
689: QUALIFICATION_TYPE_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
690: LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE)
691: SELECT
692: 3, WO.ORGANIZATION_ID,

Line 694: BOS.STANDARD_OPERATION_ID, BOS.COMPETENCE_ID, BOS.RATING_LEVEL_ID,

690: LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE)
691: SELECT
692: 3, WO.ORGANIZATION_ID,
693: WO.WIP_ENTITY_ID, WO.OPERATION_SEQ_NUM, BOS.OPERATION_SEQUENCE_ID,
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,

Line 709: AND BOS.STANDARD_OPERATION_ID = X_Standard_Operation_Id

705: AND WO.WIP_ENTITY_ID = X_Wip_Entity_Id
706: AND WO.OPERATION_SEQ_NUM = X_Operation_Seq_Num
707: AND NVL(WO.CHECK_SKILL,2) =1
708: AND WO.ORGANIZATION_ID = BOS.ORGANIZATION_ID
709: AND BOS.STANDARD_OPERATION_ID = X_Standard_Operation_Id
710: AND BOS.LEVEL_ID = 1;*/
711:
712: /* Commented out as the same piece of login is implemented directly in the form*/
713:

Line 729: X_Standard_Operation_Id NUMBER,

725: X_Operation_Seq_Num NUMBER,
726: X_Organization_Id NUMBER,
727: X_Repetitive_Schedule_Id NUMBER,
728: X_Operation_Sequence_Id NUMBER,
729: X_Standard_Operation_Id NUMBER,
730: X_Department_Id NUMBER,
731: X_Description VARCHAR2,
732: X_Scheduled_Quantity NUMBER,
733: X_Quantity_In_Queue NUMBER,

Line 793: AND ( (Recinfo.standard_operation_id = X_Standard_Operation_Id)

789: AND (X_Repetitive_Schedule_Id IS NULL)))
790: AND ( (Recinfo.operation_sequence_id = X_Operation_Sequence_Id)
791: OR ( (Recinfo.operation_sequence_id IS NULL)
792: AND (X_Operation_Sequence_Id IS NULL)))
793: AND ( (Recinfo.standard_operation_id = X_Standard_Operation_Id)
794: OR ( (Recinfo.standard_operation_id IS NULL)
795: AND (X_Standard_Operation_Id IS NULL)))
796: AND (Recinfo.department_id = X_Department_Id)
797: AND ( (Recinfo.description = X_Description)

Line 794: OR ( (Recinfo.standard_operation_id IS NULL)

790: AND ( (Recinfo.operation_sequence_id = X_Operation_Sequence_Id)
791: OR ( (Recinfo.operation_sequence_id IS NULL)
792: AND (X_Operation_Sequence_Id IS NULL)))
793: AND ( (Recinfo.standard_operation_id = X_Standard_Operation_Id)
794: OR ( (Recinfo.standard_operation_id IS NULL)
795: AND (X_Standard_Operation_Id IS NULL)))
796: AND (Recinfo.department_id = X_Department_Id)
797: AND ( (Recinfo.description = X_Description)
798: OR ( (Recinfo.description IS NULL)

Line 795: AND (X_Standard_Operation_Id IS NULL)))

791: OR ( (Recinfo.operation_sequence_id IS NULL)
792: AND (X_Operation_Sequence_Id IS NULL)))
793: AND ( (Recinfo.standard_operation_id = X_Standard_Operation_Id)
794: OR ( (Recinfo.standard_operation_id IS NULL)
795: AND (X_Standard_Operation_Id IS NULL)))
796: AND (Recinfo.department_id = X_Department_Id)
797: AND ( (Recinfo.description = X_Description)
798: OR ( (Recinfo.description IS NULL)
799: AND (X_Description IS NULL)))

Line 900: X_Standard_Operation_Id NUMBER,

896: X_Last_Update_Date DATE,
897: X_Last_Updated_By NUMBER,
898: X_Last_Update_Login NUMBER,
899: X_Operation_Sequence_Id NUMBER,
900: X_Standard_Operation_Id NUMBER,
901: X_Department_Id NUMBER,
902: X_Description VARCHAR2,
903: X_Scheduled_Quantity NUMBER,
904: X_Quantity_In_Queue NUMBER,

Line 949: standard_operation_id = X_Standard_Operation_Id,

945: last_update_date = X_Last_Update_Date,
946: last_updated_by = X_Last_Updated_By,
947: last_update_login = X_Last_Update_Login,
948: operation_sequence_id = X_Operation_Sequence_Id,
949: standard_operation_id = X_Standard_Operation_Id,
950: department_id = X_Department_Id,
951: description = X_Description,
952: scheduled_quantity = X_Scheduled_Quantity,
953: quantity_in_queue = X_Quantity_In_Queue,

Line 1015: X_Standard_Operation_Id NUMBER,

1011: X_Creation_Date DATE,
1012: X_Created_By NUMBER,
1013: X_Last_Update_Login NUMBER,
1014: X_Operation_Sequence_Id NUMBER,
1015: X_Standard_Operation_Id NUMBER,
1016: X_Department_Id NUMBER,
1017: X_Description VARCHAR2,
1018: X_Scheduled_Quantity NUMBER,
1019: X_Quantity_In_Queue NUMBER,

Line 1065: X_Standard_Operation_Id => X_Standard_Operation_Id,

1061: X_Creation_Date => X_Creation_Date,
1062: X_Created_By => X_Created_By,
1063: X_Last_Update_Login => X_Last_Update_Login,
1064: X_Operation_Sequence_Id => X_Operation_Sequence_Id,
1065: X_Standard_Operation_Id => X_Standard_Operation_Id,
1066: X_Department_Id => X_Department_Id,
1067: X_Description => X_Description,
1068: X_Scheduled_Quantity => X_Scheduled_Quantity,
1069: X_Quantity_In_Queue => X_Quantity_In_Queue,

Line 1112: X_Standard_Operation_Id NUMBER,

1108: X_Operation_Seq_Num NUMBER,
1109: X_Organization_Id NUMBER,
1110: X_Repetitive_Schedule_Id NUMBER,
1111: X_Operation_Sequence_Id NUMBER,
1112: X_Standard_Operation_Id NUMBER,
1113: X_Department_Id NUMBER,
1114: X_Description VARCHAR2,
1115: X_Scheduled_Quantity NUMBER,
1116: X_Quantity_In_Queue NUMBER,

Line 1155: X_Standard_Operation_Id => X_Standard_Operation_Id,

1151: X_Operation_Seq_Num => X_Operation_Seq_Num,
1152: X_Organization_Id => X_Organization_Id,
1153: X_Repetitive_Schedule_Id => X_Repetitive_Schedule_Id,
1154: X_Operation_Sequence_Id => X_Operation_Sequence_Id,
1155: X_Standard_Operation_Id => X_Standard_Operation_Id,
1156: X_Department_Id => X_Department_Id,
1157: X_Description => X_Description,
1158: X_Scheduled_Quantity => X_Scheduled_Quantity,
1159: X_Quantity_In_Queue => X_Quantity_In_Queue,

Line 1203: X_Standard_Operation_Id NUMBER,

1199: X_Last_Update_Date DATE,
1200: X_Last_Updated_By NUMBER,
1201: X_Last_Update_Login NUMBER,
1202: X_Operation_Sequence_Id NUMBER,
1203: X_Standard_Operation_Id NUMBER,
1204: X_Department_Id NUMBER,
1205: X_Description VARCHAR2,
1206: X_Scheduled_Quantity NUMBER,
1207: X_Quantity_In_Queue NUMBER,

Line 1249: X_Standard_Operation_Id => X_Standard_Operation_Id,

1245: X_Last_Update_Date => X_Last_Update_Date,
1246: X_Last_Updated_By => X_Last_Updated_By,
1247: X_Last_Update_Login => X_Last_Update_Login,
1248: X_Operation_Sequence_Id => X_Operation_Sequence_Id,
1249: X_Standard_Operation_Id => X_Standard_Operation_Id,
1250: X_Department_Id => X_Department_Id,
1251: X_Description => X_Description,
1252: X_Scheduled_Quantity => X_Scheduled_Quantity,
1253: X_Quantity_In_Queue => X_Quantity_In_Queue,