APPS.BOM_OE_EXPLODER_PKG dependencies on BOM_COMMON_DEFINITIONS

Line 161: X_SortWidth CONSTANT NUMBER := Bom_Common_Definitions.G_Bom_SortCode_Width ; -- at most 9999999 components

157: OB_SOURCE_BILL_SEQUENCE_ID number_tab_tp;
158: OB_COMMON_COMPONENT_SEQ_ID number_tab_tp;
159: OB_COMP_SOURCE_BILL_SEQ_ID number_tab_tp;
160:
161: X_SortWidth CONSTANT NUMBER := Bom_Common_Definitions.G_Bom_SortCode_Width ; -- at most 9999999 components
162: G_MAX_BATCH_FETCH_SIZE CONSTANT NUMBER := 10000;
163:
164: /*
165: ** Procedure: Empty_Sql_Tables

Line 387: --AND sort_order = Bom_Common_Definitions.G_Bom_Init_SortCode;

383: FROM BOM_EXPLOSIONS
384: WHERE top_bill_sequence_id = top_bill_id
385: AND explosion_type = arg_expl_type;
386: -- bug 15961704
387: --AND sort_order = Bom_Common_Definitions.G_Bom_Init_SortCode;
388:
389: Cursor GetExplodeFlags is
390: Select rowid,
391: plan_level,

Line 881: -- AND sort_order = Bom_Common_Definitions.G_Bom_Init_SortCode

877: SET request_id= -999
878: WHERE top_bill_sequence_id = x_top_bill_id
879: AND explosion_type = arg_expl_type
880: -- Bug 15961704
881: -- AND sort_order = Bom_Common_Definitions.G_Bom_Init_SortCode
882: AND request_id is null;
883:
884: If (sql%rowcount = 0) Then
885: raise x_bom_expl_run;

Line 951: SET sort_order = Bom_Common_Definitions.G_Bom_Init_SortCode

947: */
948: IF l_plan_level = 0
949: THEN
950: UPDATE bom_explosions be
951: SET sort_order = Bom_Common_Definitions.G_Bom_Init_SortCode
952: WHERE be.plan_level = 0
953: AND be.top_bill_sequence_id = x_top_bill_id
954: AND be.explosion_type = arg_expl_type
955: AND be.rexplode_flag = 1;

Line 1315: --AND sort_order = Bom_Common_Definitions.G_Bom_Init_SortCode

1311: SET request_id= NULL
1312: WHERE top_bill_sequence_id = x_top_bill_id
1313: AND explosion_type = arg_expl_type
1314: -- Bug 15961704
1315: --AND sort_order = Bom_Common_Definitions.G_Bom_Init_SortCode
1316: AND request_id = -999;
1317:
1318: commit;
1319: