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 786: cat_sort := lpad(total_rows, Bom_Common_Definitions.G_Bom_SortCode_Width, '0');

782:
783: total_rows := total_rows + 1;
784:
785: -- cat_sort := lpad(total_rows, 7, '0');
786: cat_sort := lpad(total_rows, Bom_Common_Definitions.G_Bom_SortCode_Width, '0');
787:
788: l_sc(i) := l_sc(i) || cat_sort;
789: Exception
790: When Prune_Tree then

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

1377:
1378: cum_count := cum_count + 1;
1379:
1380: -- cat_sort := lpad(cum_count, 7, '0');
1381: cat_sort := lpad(cum_count, Bom_Common_Definitions.G_Bom_SortCode_Width , '0');
1382:
1383: l_SC(i) := l_SC(i) || cat_sort;
1384: Exception
1385: When Prune_tree then