APPS.BOM_STRUCTURE_TYPES_PKG dependencies on BOM_STRUCTURE_TYPES_B

Line 62: WHERE STRUCTURE_TYPE_ID = (SELECT STRUCTURE_TYPE_ID FROM BOM_STRUCTURE_TYPES_B

58: LAST_UPDATE_DATE = X_Last_Update_Date,
59: LAST_UPDATED_BY = X_Last_Updated_By,
60: LAST_UPDATE_LOGIN = X_Last_Update_Login,
61: SOURCE_LANG = USERENV('LANG')
62: WHERE STRUCTURE_TYPE_ID = (SELECT STRUCTURE_TYPE_ID FROM BOM_STRUCTURE_TYPES_B
63: WHERE STRUCTURE_TYPE_NAME = X_Structure_Type_Name)
64: AND USERENV('LANG') IN (LANGUAGE,SOURCE_LANG);
65: ELSE
66:

Line 79: FROM BOM_STRUCTURE_TYPES_B

75: BEGIN
76:
77: SELECT LAST_UPDATED_BY,LAST_UPDATE_DATE
78: INTO db_luby, db_ludate
79: FROM BOM_STRUCTURE_TYPES_B
80: WHERE STRUCTURE_TYPE_NAME = X_Structure_Type_Name;
81:
82: stype_exists := 1;
83:

Line 94: SELECT BOM_STRUCTURE_TYPES_B_S.nextval INTO str_id FROM dual;

90:
91: IF (stype_exists = 0)
92: THEN
93:
94: SELECT BOM_STRUCTURE_TYPES_B_S.nextval INTO str_id FROM dual;
95:
96: INSERT INTO BOM_STRUCTURE_TYPES_B
97: (
98: STRUCTURE_TYPE_ID,

Line 96: INSERT INTO BOM_STRUCTURE_TYPES_B

92: THEN
93:
94: SELECT BOM_STRUCTURE_TYPES_B_S.nextval INTO str_id FROM dual;
95:
96: INSERT INTO BOM_STRUCTURE_TYPES_B
97: (
98: STRUCTURE_TYPE_ID,
99: STRUCTURE_TYPE_NAME,
100: LAST_UPDATE_DATE,

Line 161: WHERE NOT EXISTS (SELECT 1 from BOM_STRUCTURE_TYPES_B

157: X_Parent_Structure_Type_Id,
158: X_Enable_Attachments_Flag,
159: X_Allow_Subtypes
160: FROM DUAL
161: WHERE NOT EXISTS (SELECT 1 from BOM_STRUCTURE_TYPES_B
162: WHERE STRUCTURE_TYPE_NAME = X_Structure_Type_Name );
163:
164:
165: INSERT INTO BOM_STRUCTURE_TYPES_TL

Line 191: (SELECT NULL FROM BOM_STRUCTURE_TYPES_TL TL,BOM_STRUCTURE_TYPES_B B

187: X_Last_Update_Login
188: FROM FND_LANGUAGES L
189: WHERE L.INSTALLED_FLAG IN ('I','B')
190: AND NOT EXISTS
191: (SELECT NULL FROM BOM_STRUCTURE_TYPES_TL TL,BOM_STRUCTURE_TYPES_B B
192: WHERE B.STRUCTURE_TYPE_ID = TL.STRUCTURE_TYPE_ID
193: AND B.STRUCTURE_TYPE_NAME = X_Structure_Type_Name
194: AND TL.LANGUAGE = L.LANGUAGE_CODE);
195:

Line 202: UPDATE BOM_STRUCTURE_TYPES_B

198: -- Row exists, test if it should be over-written.
199: IF (stype_exists = 1) AND (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_Custom_mode))
200: THEN
201:
202: UPDATE BOM_STRUCTURE_TYPES_B
203: SET
204: ITEM_CATALOG_GROUP_ID = X_Item_Catalog_Group_Id,
205: EFFECTIVE_DATE = X_Effective_Date,
206: STRUCTURE_CREATION_ALLOWED = X_Structure_Creation_Allowed,

Line 243: (SELECT STRUCTURE_TYPE_ID FROM BOM_STRUCTURE_TYPES_B

239: LAST_UPDATED_BY = X_Last_Updated_By,
240: LAST_UPDATE_LOGIN = X_Last_Update_Login,
241: SOURCE_LANG = USERENV('LANG')
242: WHERE STRUCTURE_TYPE_ID =
243: (SELECT STRUCTURE_TYPE_ID FROM BOM_STRUCTURE_TYPES_B
244: WHERE STRUCTURE_TYPE_NAME = X_Structure_Type_Name)
245: AND USERENV('LANG') IN (LANGUAGE,SOURCE_LANG);
246:
247: END IF; -- End of Test for Updates

Line 332: cursor C is select ROWID from BOM_STRUCTURE_TYPES_B

328: X_ENABLE_UNIMPLEMENTED_BOMS IN VARCHAR2,
329: X_ALLOW_SUBTYPES IN VARCHAR2
330:
331: ) is
332: cursor C is select ROWID from BOM_STRUCTURE_TYPES_B
333: where STRUCTURE_TYPE_ID = X_STRUCTURE_TYPE_ID
334: ;
335: begin
336: insert into BOM_STRUCTURE_TYPES_B (

Line 336: insert into BOM_STRUCTURE_TYPES_B (

332: cursor C is select ROWID from BOM_STRUCTURE_TYPES_B
333: where STRUCTURE_TYPE_ID = X_STRUCTURE_TYPE_ID
334: ;
335: begin
336: insert into BOM_STRUCTURE_TYPES_B (
337: ATTRIBUTE12,
338: ATTRIBUTE13,
339: DISABLE_DATE,
340: STRUCTURE_TYPE_ID,

Line 498: from BOM_STRUCTURE_TYPES_B

494: PARENT_STRUCTURE_TYPE_ID,
495: ENABLE_ATTACHMENTS_FLAG,
496: ENABLE_UNIMPLEMENTED_BOMS,
497: ALLOW_SUBTYPES
498: from BOM_STRUCTURE_TYPES_B
499: where STRUCTURE_TYPE_ID = X_STRUCTURE_TYPE_ID
500: for update of STRUCTURE_TYPE_ID nowait;
501: recinfo c%rowtype;
502:

Line 625: update BOM_STRUCTURE_TYPES_B set

621: X_ENABLE_UNIMPLEMENTED_BOMS in VARCHAR2,
622: X_ALLOW_SUBTYPES in VARCHAR2
623: ) is
624: begin
625: update BOM_STRUCTURE_TYPES_B set
626: ATTRIBUTE12 = X_ATTRIBUTE12,
627: ATTRIBUTE13 = X_ATTRIBUTE13,
628: DISABLE_DATE = X_DISABLE_DATE,
629: STRUCTURE_TYPE_NAME = X_STRUCTURE_TYPE_NAME,

Line 686: delete from BOM_STRUCTURE_TYPES_B

682: if (sql%notfound) then
683: raise no_data_found;
684: end if;
685:
686: delete from BOM_STRUCTURE_TYPES_B
687: where STRUCTURE_TYPE_ID = X_STRUCTURE_TYPE_ID;
688:
689: if (sql%notfound) then
690: raise no_data_found;

Line 700: from BOM_STRUCTURE_TYPES_B B

696: begin
697: delete from BOM_STRUCTURE_TYPES_TL T
698: where not exists
699: (select NULL
700: from BOM_STRUCTURE_TYPES_B B
701: where B.STRUCTURE_TYPE_ID = T.STRUCTURE_TYPE_ID
702: );
703:
704: update BOM_STRUCTURE_TYPES_TL T set (

Line 769: FROM bom_structure_types_b

765: x_return_status OUT NOCOPY VARCHAR2
766: ) IS
767: CURSOR c_tree_hierarchy(c_p_parent_structure_type_id IN NUMBER) IS
768: /* SELECT structure_type_id
769: FROM bom_structure_types_b
770: CONNECT BY PRIOR structure_type_id = parent_structure_type_id
771: START WITH parent_structure_Type_id = c_p_parent_structure_type_id ;
772: */
773: SELECT structure_type_id

Line 774: FROM bom_structure_types_b

770: CONNECT BY PRIOR structure_type_id = parent_structure_type_id
771: START WITH parent_structure_Type_id = c_p_parent_structure_type_id ;
772: */
773: SELECT structure_type_id
774: FROM bom_structure_types_b
775: CONNECT BY PRIOR parent_structure_type_id = structure_type_id
776: START WITH structure_type_id = c_p_parent_structure_type_id;
777: l_structure_type_id NUMBER ;
778: l_struct_type_id_orig NUMBER;

Line 783: FROM bom_structure_types_b

779: BEGIN
780:
781:
782: SELECT parent_structure_type_id INTO l_struct_type_id_orig
783: FROM bom_structure_types_b
784: WHERE structure_type_id = p_structure_type_id;
785:
786: IF l_struct_type_id_orig IS null THEN
787: x_return_status := 'T'; -- If parent structure type id is null