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 17: adding_standard_op boolean := (p_operation_id is NOT NULL

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

Line 84: standard_operation_id,

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

Line 173: bom_standard_operations bso

169: bso.attribute15,
170: bso.check_skill
171: from wip_operations wo1,
172: wip_discrete_jobs wdj,
173: bom_standard_operations bso
174: where bso.standard_operation_id(+) = p_operation_id
175: /* %cfm Ignore cfm ops. */
176: and nvl(bso.operation_type, 1) = 1
177: and bso.line_id is null

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

170: bso.check_skill
171: from wip_operations wo1,
172: wip_discrete_jobs wdj,
173: bom_standard_operations bso
174: where bso.standard_operation_id(+) = p_operation_id
175: /* %cfm Ignore cfm ops. */
176: and nvl(bso.operation_type, 1) = 1
177: and bso.line_id is null
178: /* %/cfm */

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

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

Line 197: if (adding_standard_op) then

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

Line 216: standard_rate_flag,

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

Line 257: bsor.standard_rate_flag,

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

Line 284: where bsor.standard_operation_id = p_operation_id

280: 0 -- Added : -- bug 7371859
281: from wip_operations wo,
282: bom_resources br,
283: bom_std_op_resources bsor
284: where bsor.standard_operation_id = p_operation_id
285: and br.resource_id = bsor.resource_id
286: and nvl(br.disable_date, SYSDATE + 1) > SYSDATE
287: and wo.organization_id = p_org_id
288: and wo.wip_entity_id = p_wip_entity_id

Line 292: X_FROM_ENTITY_NAME => 'BOM_STANDARD_OPERATIONS',

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

Line 309: STANDARD_OPERATION_ID, COMPETENCE_ID, RATING_LEVEL_ID,

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

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

311: LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE)
312: SELECT
313: 3, WO.ORGANIZATION_ID,
314: WO.WIP_ENTITY_ID, WO.OPERATION_SEQ_NUM, BOS.OPERATION_SEQUENCE_ID,
315: BOS.STANDARD_OPERATION_ID, BOS.COMPETENCE_ID, BOS.RATING_LEVEL_ID,
316: BOS.QUALIFICATION_TYPE_ID, WO.LAST_UPDATE_DATE, WO.LAST_UPDATED_BY,
317: WO.LAST_UPDATE_LOGIN, WO.CREATED_BY, WO.CREATION_DATE
318: FROM BOM_OPERATION_SKILLS BOS,
319: WIP_OPERATIONS WO,

Line 329: AND BOS.STANDARD_OPERATION_ID = p_operation_id

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

Line 336: WHERE BSSOR.STANDARD_OPERATION_ID=p_operation_id;

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

Line 375: standard_rate_flag,

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

Line 419: BSSOR.standard_rate_flag,

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

Line 446: WHERE bssor.standard_operation_id=p_operation_id

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

Line 479: X_Standard_Operation_Id NUMBER,

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

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

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

Line 561: standard_operation_id,

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

Line 611: X_Standard_Operation_Id,

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

Line 655: X_FROM_ENTITY_NAME => 'BOM_STANDARD_OPERATIONS',

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

Line 656: X_FROM_PK1_VALUE => to_char(X_Standard_Operation_Id),

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

Line 668: X_FROM_ENTITY_NAME => 'BOM_STANDARD_OPERATIONS',

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

Line 669: X_FROM_PK1_VALUE => to_char(X_Standard_Operation_Id),

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

Line 686: STANDARD_OPERATION_ID, COMPETENCE_ID, RATING_LEVEL_ID,

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

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

688: LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE)
689: SELECT
690: 3, WO.ORGANIZATION_ID,
691: WO.WIP_ENTITY_ID, WO.OPERATION_SEQ_NUM, BOS.OPERATION_SEQUENCE_ID,
692: BOS.STANDARD_OPERATION_ID, BOS.COMPETENCE_ID, BOS.RATING_LEVEL_ID,
693: BOS.QUALIFICATION_TYPE_ID, WO.LAST_UPDATE_DATE, WO.LAST_UPDATED_BY,
694: WO.LAST_UPDATE_LOGIN, WO.CREATED_BY, WO.CREATION_DATE
695: FROM BOM_OPERATION_SKILLS BOS,
696: WIP_OPERATIONS WO,

Line 707: AND BOS.STANDARD_OPERATION_ID = X_Standard_Operation_Id

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

Line 727: X_Standard_Operation_Id NUMBER,

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

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

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

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

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

Line 793: AND (X_Standard_Operation_Id IS NULL)))

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

Line 898: X_Standard_Operation_Id NUMBER,

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

Line 947: standard_operation_id = X_Standard_Operation_Id,

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

Line 1013: X_Standard_Operation_Id NUMBER,

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

Line 1063: X_Standard_Operation_Id => X_Standard_Operation_Id,

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

Line 1110: X_Standard_Operation_Id NUMBER,

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

Line 1153: X_Standard_Operation_Id => X_Standard_Operation_Id,

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

Line 1201: X_Standard_Operation_Id NUMBER,

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

Line 1247: X_Standard_Operation_Id => X_Standard_Operation_Id,

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