DBA Data[Home] [Help]

APPS.BOMPIINQ dependencies on BOM_COMMON_DEFINITIONS

Line 184: Bom_Common_Definitions.G_Bom_Init_SortCode,

180: item_id,
181: NULL,
182: 0,
183: -- '0000001',
184: Bom_Common_Definitions.G_Bom_Init_SortCode,
185: NULL,
186: NULL,
187: t_org_code_list(I),
188: sysdate,

Line 219: Bom_Common_Definitions.G_Bom_Init_SortCode,

215: item_id,
216: NULL,
217: 0,
218: --'0001',
219: Bom_Common_Definitions.G_Bom_Init_SortCode,
220: NULL,
221: NULL,
222: t_org_code_list(I),
223: sysdate,

Line 238: AND SORT_CODE = Bom_Common_Definitions.G_Bom_Init_SortCode

234: AND CURRENT_ITEM_ID = item_id
235: AND PARENT_ITEM_ID = item_id
236: AND ALTERNATE_DESIGNATOR IS NULL
237: AND CURRENT_LEVEL = 0
238: AND SORT_CODE = Bom_Common_Definitions.G_Bom_Init_SortCode
239: AND CURRENT_ASSEMBLY_TYPE IS NULL
240: AND COMPONENT_SEQUENCE_ID IS NULL
241: AND ORGANIZATION_ID = t_org_code_list(I)
242: )

Line 801: cat_sort := lpad(total_rows, Bom_Common_Definitions.G_Bom_SortCode_Width, '0');

797:
798: total_rows := total_rows + 1;
799:
800: -- cat_sort := lpad(total_rows, 7, '0');
801: cat_sort := lpad(total_rows, Bom_Common_Definitions.G_Bom_SortCode_Width, '0');
802:
803: l_sc(i) := l_sc(i) || cat_sort;
804: Exception
805: When Prune_Tree then

Line 1410: cat_sort := lpad(cum_count, Bom_Common_Definitions.G_Bom_SortCode_Width , '0');

1406:
1407: cum_count := cum_count + 1;
1408:
1409: -- cat_sort := lpad(cum_count, 7, '0');
1410: cat_sort := lpad(cum_count, Bom_Common_Definitions.G_Bom_SortCode_Width , '0');
1411:
1412: l_SC(i) := l_SC(i) || cat_sort;
1413: Exception
1414: When Prune_tree then