APPS.BOM_UDA_OVERRIDES_PVT dependencies on BOM_COMPONENTS_EXT_TL

Line 9: udat_rec BOM_COMPONENTS_EXT_TL%ROWTYPE;

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;
13: l_new_ovr_tl_ext_rec BOM_COMPONENTS_EXT_TL%ROWTYPE;

Line 13: l_new_ovr_tl_ext_rec BOM_COMPONENTS_EXT_TL%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;
17: l_new_ovr_b_ext_tbl l_ext_b_tbl;

Line 15: TYPE l_ext_tl_tbl IS TABLE OF BOM_COMPONENTS_EXT_TL%ROWTYPE INDEX BY BINARY_INTEGER;

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;
19: l_new_ctx_tbl l_ct_tbl;

Line 73: FROM BOM_COMPONENTS_EXT_TL

69: AND CONTEXT_ID IS NOT NULL;
70:
71: CURSOR C_OVR_TL_ROWS (p_extension_id NUMBER) IS
72: SELECT *
73: FROM BOM_COMPONENTS_EXT_TL
74: WHERE EXTENSION_ID = p_extension_id
75: AND DATA_LEVEL_ID = l_data_level_id_comp_ovr
76: AND CONTEXT_ID IS NOT NULL;
77:

Line 212: INTO BOM_COMPONENTS_EXT_TL

208: l_new_ovr_tl_ext_tbl(1) := l_new_ovr_tl_ext_rec;
209:
210: FORALL i in l_new_ovr_tl_ext_tbl.FIRST..l_new_ovr_tl_ext_tbl.LAST
211: INSERT
212: INTO BOM_COMPONENTS_EXT_TL
213: VALUES l_new_ovr_tl_ext_tbl(i);
214:
215: END LOOP; --FOR c_ovr_tl_row IN C_OVR_TL_ROWS(ctx_rec.EXTENSION_ID) LOOP
216:

Line 273: FROM BOM_COMPONENTS_EXT_TL

269: WHERE COMPONENT_SEQUENCE_ID = p_del_comp_seq
270: AND DATA_LEVEL_ID = l_data_level_id_comp_ovr;
271:
272: DELETE
273: FROM BOM_COMPONENTS_EXT_TL
274: WHERE COMPONENT_SEQUENCE_ID = p_del_comp_seq
275: AND DATA_LEVEL_ID = l_data_level_id_comp_ovr;
276:
277: DELETE