oracle 内置包，用于将表中数据以层次关系展开 将运行出的数据添加到零时表中
bompexpl.exploder_userexit(verify_flag => :verify_flag,
org_id => :rg_id,--organization_id --用户输入的组织号
order_by => :rder_by, --1 - Op seq, item seq
--2 - Item seq, op seq
grp_id => :grp_id, --unique value to identify current explosion use
--value from sequence bom_explosion_temp_s
session_id => :session_id, --unique value to identify current session
-- use value from bom_explosion_temp_session_s
levels_to_explode => :levels_to_explode, - -展开层数
bom_or_eng => :bom_or_eng, --1 - BOM； 2 - ENG
impl_flag => :impl_flag, -- 1 - implemented only 2 - both impl and unimpl
plan_factor_flag => lan_factor_flag, 默认2
explode_option => :explode_option, -- 1 - All| 2 - Current| 3 - Current and future
module => :module, -- 1 - Costing| 2 - Bom| 3 - Order entry| 4 - ATO| 5 - WSM
cst_type_id => :cst_type_id,--cost type id for costed explosion
std_comp_flag => :std_comp_flag, --std_comp_flag 1 - explode only standard components
-- 2 - all components
expl_qty => :expl_qty, -- explosion quantity
item_id => :item_id, --item id of assembly to explode--用户输入的库存号
alt_desg => :alt_desg, ---alternate bom designator
comp_code => :comp_code, --concatenated component code lpad 16
rev_date => :rev_date, -- explosion date YYYY/MM/DD HH24:MI:SS ；一定要这个格式to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS')
err_msg => :err_msg, --error message out buffer返回错误信息
error_code => :error_code--error code out.returns sql error code if sql error 返回错误代码
)[@more@]
bompexpl.exploder_userexit(verify_flag => :verify_flag,
org_id => :rg_id,--organization_id --用户输入的组织号
order_by => :rder_by, --1 - Op seq, item seq
--2 - Item seq, op seq
grp_id => :grp_id, --unique value to identify current explosion use
--value from sequence bom_explosion_temp_s
session_id => :session_id, --unique value to identify current session
-- use value from bom_explosion_temp_session_s
levels_to_explode => :levels_to_explode, - -展开层数
bom_or_eng => :bom_or_eng, --1 - BOM； 2 - ENG
impl_flag => :impl_flag, -- 1 - implemented only 2 - both impl and unimpl
plan_factor_flag => lan_factor_flag, 默认2
explode_option => :explode_option, -- 1 - All| 2 - Current| 3 - Current and future
module => :module, -- 1 - Costing| 2 - Bom| 3 - Order entry| 4 - ATO| 5 - WSM
cst_type_id => :cst_type_id,--cost type id for costed explosion
std_comp_flag => :std_comp_flag, --std_comp_flag 1 - explode only standard components
-- 2 - all components
expl_qty => :expl_qty, -- explosion quantity
item_id => :item_id, --item id of assembly to explode--用户输入的库存号
alt_desg => :alt_desg, ---alternate bom designator
comp_code => :comp_code, --concatenated component code lpad 16
rev_date => :rev_date, -- explosion date YYYY/MM/DD HH24:MI:SS ；一定要这个格式to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS')
err_msg => :err_msg, --error message out buffer返回错误信息
error_code => :error_code--error code out.returns sql error code if sql error 返回错误代码
)[@more@]
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/394664/viewspace-917843/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
