BOM的interface开发的示例代码

---- **** INSERT INTO BOM INTERFACE *****

insert into bom.bom_bill_of_mtls_interface
(last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
item_number,
organization_code,
assembly_type,
process_flag,
transaction_type)
values
(g_today,
g_user_id,
g_today,
g_user_id,
g_user_id,
p_assembly_item_number,
p_org_code,
1,
1,
'CREATE');

---- **** INSERT INTO BOM COMP INTERFACE *****

Insert into bom_inventory_comps_interface
(last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
operation_seq_num,
assembly_item_number,
component_item_number, --convert to 00 function,
organization_code,
component_quantity,
wip_supply_type,
COMPONENT_REMARKS,
attribute12,
attribute13,
effectivity_date, -- get effectivity date from Assebly revision effectivey date, from mtl_item_revisions table
process_flag,
transaction_type)

values
(g_today,
g_user_id,
g_today,
g_user_id,
g_user_id,
1,
p_assembly_item_number,
p_component_item_number,
p_org_code,
p_component_quantity,
p_wip_supply_type,
substr(p_bom_notes, 1, 235),
substr(p_bom_notes, 236, 145),
substr(p_bom_notes, 380, 145),
p_effectivity_date,
1,
'CREATE');

---- **** INSERT INTO BOM REF_DESGS INTERFACE *****
INSERT into BOM_REF_DESGS_INTERFACE
(last_update_date,
last_updated_by,
last_update_login,
creation_date,
created_by,
COMPONENT_REFERENCE_DESIGNATOR,
ACD_TYPE, --1
operation_seq_num, --1
component_item_number,
effectivity_date, --assebly effectity date
organization_code,
assembly_item_number,
process_flag, --1
transaction_type)
VALUES
(g_today,
g_User_Id,
g_User_Id,
g_today,
g_User_Id,
substr(p_comp_reference_desg,1,14),
1,
1,
p_component_item_number,
p_effectivity_date,
p_org_code,
p_assembly_item_number,
1,
'CREATE'
);

insert into BOM_DELETE_GROUPS
(
DELETE_GROUP_SEQUENCE_ID ,
DELETE_GROUP_NAME ,
ORGANIZATION_ID ,
DELETE_TYPE ,
ACTION_TYPE ,
DESCRIPTION ,
ENGINEERING_FLAG ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
CREATION_DATE ,
CREATED_BY ,
DELETE_COMMON_BILL_FLAG ,
DELETE_ORG_TYPE
) values (
l_delete_group_id,
'PC'||l_delete_group_id,
g_mst_org_id,
2,
1,
'PNO_CONVERSION',
1,
g_today,
g_user_id,
g_today,
g_user_id,
2,
1
);

insert into BOM_DELETE_ENTITIES
(
DELETE_ENTITY_SEQUENCE_ID ,
DELETE_GROUP_SEQUENCE_ID ,
DELETE_ENTITY_TYPE ,
BILL_SEQUENCE_ID ,
INVENTORY_ITEM_ID ,
ORGANIZATION_ID ,
ITEM_DESCRIPTION ,
ITEM_CONCAT_SEGMENTS ,
DELETE_STATUS_TYPE ,
PRIOR_PROCESS_FLAG ,
PRIOR_COMMIT_FLAG ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
CREATION_DATE ,
CREATED_BY
) values (
BOM_delete_entities_s.nextval,
l_delete_group_id,
2,
R.X_mst_bill_sequence_id,
R.X_MST_ITEM_ID,
g_mst_org_id,
l_bom_description,
R.X_OO_ITEM_ID,
1,
1,
1,
g_today,
g_user_id,
g_today,
g_user_id
);