DBA Data[Home] [Help]

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 383: AND sort_order = Bom_Common_Definitions.G_Bom_Init_SortCode;

379: Select REQUEST_ID
380: FROM BOM_EXPLOSIONS
381: WHERE top_bill_sequence_id = top_bill_id
382: AND explosion_type = arg_expl_type
383: AND sort_order = Bom_Common_Definitions.G_Bom_Init_SortCode;
384:
385: Cursor GetExplodeFlags is
386: Select rowid,
387: plan_level,

Line 882: SET sort_order = Bom_Common_Definitions.G_Bom_Init_SortCode

878: */
879: IF l_plan_level = 0
880: THEN
881: UPDATE bom_explosions be
882: SET sort_order = Bom_Common_Definitions.G_Bom_Init_SortCode
883: WHERE be.plan_level = 0
884: AND be.top_bill_sequence_id = x_top_bill_id
885: AND be.explosion_type = arg_expl_type
886: AND be.rexplode_flag = 1;