APPS.BOM_SUB_RESOURCES_PKG dependencies on BOM_SUB_OPERATION_RESOURCES

Line 43: INSERT INTO BOM_SUB_OPERATION_RESOURCES(

39: x_ATTRIBUTE14 VARCHAR2,
40: x_ATTRIBUTE15 VARCHAR2)
41: IS
42: BEGIN
43: INSERT INTO BOM_SUB_OPERATION_RESOURCES(
44: OPERATION_SEQUENCE_ID,
45: SUBSTITUTE_GROUP_NUM,
46: RESOURCE_ID,
47: SCHEDULE_SEQ_NUM,

Line 161: INSERT INTO BOM_SUB_OPERATION_RESOURCES(

157: x_ATTRIBUTE15 VARCHAR2,
158: x_SETUP_ID NUMBER)
159: IS
160: BEGIN
161: INSERT INTO BOM_SUB_OPERATION_RESOURCES(
162: OPERATION_SEQUENCE_ID,
163: SUBSTITUTE_GROUP_NUM,
164: RESOURCE_ID,
165: SCHEDULE_SEQ_NUM,

Line 307: FROM BOM_SUB_OPERATION_RESOURCES

303: attribute12,
304: attribute13,
305: attribute14,
306: attribute15
307: FROM BOM_SUB_OPERATION_RESOURCES
308: WHERE rowid = x_row_id
309: FOR UPDATE of operation_sequence_id, substitute_group_num, resource_id NOWAIT;
310: Recinfo C%ROWTYPE;
311: BEGIN

Line 474: FROM BOM_SUB_OPERATION_RESOURCES

470: attribute13,
471: attribute14,
472: attribute15,
473: setup_id
474: FROM BOM_SUB_OPERATION_RESOURCES
475: WHERE rowid = x_row_id
476: FOR UPDATE of operation_sequence_id, substitute_group_num, resource_id, replacement_group_num NOWAIT; --for bug 3287004
477: Recinfo C%ROWTYPE;
478: BEGIN

Line 617: UPDATE BOM_SUB_OPERATION_RESOURCES SET

613: x_ATTRIBUTE14 VARCHAR2,
614: x_ATTRIBUTE15 VARCHAR2)
615: IS
616: BEGIN
617: UPDATE BOM_SUB_OPERATION_RESOURCES SET
618: OPERATION_SEQUENCE_ID = x_OPERATION_SEQUENCE_ID,
619: SUBSTITUTE_GROUP_NUM = x_SUBSTITUTE_GROUP_NUM,
620: RESOURCE_ID = x_RESOURCE_ID,
621: SCHEDULE_SEQ_NUM = x_SCHEDULE_SEQ_NUM,

Line 701: UPDATE BOM_SUB_OPERATION_RESOURCES SET

697: x_ATTRIBUTE15 VARCHAR2,
698: x_SETUP_ID NUMBER)
699: IS
700: BEGIN
701: UPDATE BOM_SUB_OPERATION_RESOURCES SET
702: OPERATION_SEQUENCE_ID = x_OPERATION_SEQUENCE_ID,
703: SUBSTITUTE_GROUP_NUM = x_SUBSTITUTE_GROUP_NUM,
704: RESOURCE_ID = x_RESOURCE_ID,
705: SCHEDULE_SEQ_NUM = x_SCHEDULE_SEQ_NUM,

Line 748: DELETE FROM BOM_SUB_OPERATION_RESOURCES

744: END;
745:
746: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
747: BEGIN
748: DELETE FROM BOM_SUB_OPERATION_RESOURCES
749: WHERE rowid=x_rowid;
750: END Delete_Row;
751:
752: PROCEDURE CHECK_UNIQUE_LINK(X_ROWID VARCHAR2,

Line 881: FROM bom_sub_operation_resources bor ,

877: to_number(NULL) resource_seq_num,
878: bor.schedule_seq_num,
879: bor.substitute_group_num,
880: bor.schedule_flag
881: FROM bom_sub_operation_resources bor ,
882: bom_operation_sequences bos ,
883: bom_resources br ,
884: bom_department_resources bdr ,
885: cst_activities ca ,