APPS.BOM_UDA_OVERRIDES_PVT dependencies on BOM_COMPONENTS_EXT_B

Line 8: udab_new_base_rec BOM_COMPONENTS_EXT_B%ROWTYPE;

4:
5: PROCEDURE Copy_Comp_UDA_Overrides (p_old_comp_seq NUMBER, p_new_comp_seq NUMBER) IS
6:
7: x_return_status VARCHAR2(240);
8: udab_new_base_rec BOM_COMPONENTS_EXT_B%ROWTYPE;
9: udat_rec BOM_COMPONENTS_EXT_TL%ROWTYPE;
10: ctx_rec BOM_COMP_ATTR_CTX_ASSOCS_B%ROWTYPE;
11: new_ctx_rec BOM_COMP_ATTR_CTX_ASSOCS_B%ROWTYPE;
12: l_new_ovr_b_ext_rec BOM_COMPONENTS_EXT_B%ROWTYPE;

Line 12: l_new_ovr_b_ext_rec BOM_COMPONENTS_EXT_B%ROWTYPE;

8: udab_new_base_rec BOM_COMPONENTS_EXT_B%ROWTYPE;
9: udat_rec BOM_COMPONENTS_EXT_TL%ROWTYPE;
10: ctx_rec BOM_COMP_ATTR_CTX_ASSOCS_B%ROWTYPE;
11: new_ctx_rec BOM_COMP_ATTR_CTX_ASSOCS_B%ROWTYPE;
12: l_new_ovr_b_ext_rec BOM_COMPONENTS_EXT_B%ROWTYPE;
13: l_new_ovr_tl_ext_rec BOM_COMPONENTS_EXT_TL%ROWTYPE;
14: TYPE l_ext_b_tbl IS TABLE OF BOM_COMPONENTS_EXT_B%ROWTYPE INDEX BY BINARY_INTEGER;
15: TYPE l_ext_tl_tbl IS TABLE OF BOM_COMPONENTS_EXT_TL%ROWTYPE INDEX BY BINARY_INTEGER;
16: TYPE l_ct_tbl IS TABLE OF BOM_COMP_ATTR_CTX_ASSOCS_B%ROWTYPE INDEX BY BINARY_INTEGER;

Line 14: TYPE l_ext_b_tbl IS TABLE OF BOM_COMPONENTS_EXT_B%ROWTYPE INDEX BY BINARY_INTEGER;

10: ctx_rec BOM_COMP_ATTR_CTX_ASSOCS_B%ROWTYPE;
11: new_ctx_rec BOM_COMP_ATTR_CTX_ASSOCS_B%ROWTYPE;
12: l_new_ovr_b_ext_rec BOM_COMPONENTS_EXT_B%ROWTYPE;
13: l_new_ovr_tl_ext_rec BOM_COMPONENTS_EXT_TL%ROWTYPE;
14: TYPE l_ext_b_tbl IS TABLE OF BOM_COMPONENTS_EXT_B%ROWTYPE INDEX BY BINARY_INTEGER;
15: TYPE l_ext_tl_tbl IS TABLE OF BOM_COMPONENTS_EXT_TL%ROWTYPE INDEX BY BINARY_INTEGER;
16: TYPE l_ct_tbl IS TABLE OF BOM_COMP_ATTR_CTX_ASSOCS_B%ROWTYPE INDEX BY BINARY_INTEGER;
17: l_new_ovr_b_ext_tbl l_ext_b_tbl;
18: l_new_ovr_tl_ext_tbl l_ext_tl_tbl;

Line 52: FROM BOM_COMPONENTS_EXT_B

48: WHERE COMPONENT_SEQUENCE_ID = p_comp_seq;
49:
50: CURSOR C_NEW_BASE_ROW (p_bill_seq_id NUMBER, p_comp_seq_id NUMBER, p_attr_grp_id NUMBER) IS
51: SELECT *
52: FROM BOM_COMPONENTS_EXT_B
53: WHERE BILL_SEQUENCE_ID = p_bill_seq_id
54: AND COMPONENT_SEQUENCE_ID = p_comp_seq_id
55: AND ATTR_GROUP_ID = p_attr_grp_id
56: AND DATA_LEVEL_ID = l_data_level_id_comp

Line 61: FROM BOM_COMPONENTS_EXT_B

57: AND CONTEXT_ID IS NULL;
58:
59: CURSOR C_NEW_BASE_ROW_MULTI (p_extension_id NUMBER) IS
60: SELECT *
61: FROM BOM_COMPONENTS_EXT_B
62: WHERE EXTENSION_ID = p_extension_id;
63:
64: CURSOR C_OVR_B_ROWS (p_extension_id NUMBER) IS
65: SELECT *

Line 66: FROM BOM_COMPONENTS_EXT_B

62: WHERE EXTENSION_ID = p_extension_id;
63:
64: CURSOR C_OVR_B_ROWS (p_extension_id NUMBER) IS
65: SELECT *
66: FROM BOM_COMPONENTS_EXT_B
67: WHERE EXTENSION_ID = p_extension_id
68: AND DATA_LEVEL_ID = l_data_level_id_comp_ovr
69: AND CONTEXT_ID IS NOT NULL;
70:

Line 118: ' FROM BOM_COMPONENTS_EXT_B NEW, BOM_COMPONENTS_EXT_B OLD ' ||

114: --If ag is multi row, then multiple rows may be present for ag, we need to filter with correct primary key
115: IF(l_ag_metadata_obj.MULTI_ROW_CODE = 'Y') THEN
116: --generate the common sql
117: l_dynamic_sql := ' SELECT NEW.EXTENSION_ID ' ||
118: ' FROM BOM_COMPONENTS_EXT_B NEW, BOM_COMPONENTS_EXT_B OLD ' ||
119: ' WHERE OLD.EXTENSION_ID = :1 ' ||
120: ' AND NEW.BILL_SEQUENCE_ID = OLD.BILL_SEQUENCE_ID ' ||
121: ' AND NEW.ATTR_GROUP_ID = OLD.ATTR_GROUP_ID ' ||
122: ' AND NEW.COMPONENT_SEQUENCE_ID = :2 ' ||

Line 193: INTO BOM_COMPONENTS_EXT_B

189: l_new_ovr_b_ext_tbl(1) := l_new_ovr_b_ext_rec;
190:
191: FORALL i in l_new_ovr_b_ext_tbl.FIRST..l_new_ovr_b_ext_tbl.LAST
192: INSERT
193: INTO BOM_COMPONENTS_EXT_B
194: VALUES l_new_ovr_b_ext_tbl(i);
195:
196: FOR c_ovr_tl_row IN C_OVR_TL_ROWS(ctx_rec.EXTENSION_ID) LOOP
197: l_new_ovr_tl_ext_rec := c_ovr_tl_row;

Line 268: FROM BOM_COMPONENTS_EXT_B

264: l_data_level_id_comp_ovr := c_comp_level.DATA_LEVEL_ID;
265: END LOOP;
266:
267: DELETE
268: FROM BOM_COMPONENTS_EXT_B
269: WHERE COMPONENT_SEQUENCE_ID = p_del_comp_seq
270: AND DATA_LEVEL_ID = l_data_level_id_comp_ovr;
271:
272: DELETE