[Home] [Help]
1: PACKAGE BODY Bom_Import_Pub AS
2: /* $Header: BOMSIMPB.pls 120.118.12020000.7 2012/10/11 09:00:15 lanhuang ship $ */
3: /***************************************************************************
4: --
5: -- Copyright (c) 1996 Oracle Corporation, Redwood Shores, CA, USA
10: -- BOMSIMPB.pls
11: --
12: -- DESCRIPTION
13: --
14: -- Body of package Bom_Import_Pub
15: --
16: -- NOTES
17: --
18: --
31: BULKLOAD_PVT_PKG.PROCESS_BOM_INTERFACE_LINES
32: ***************************************************************************/
33: /* Package Globals */
34: pG_batch_options BATCH_OPTIONS;
35: pG_ouputFileName VARCHAR2(30) := 'BOM_IMPORT_PUB';
36:
37: /****************** Local functions/procedures Section ******************/
38:
39: FUNCTION Init_Debug RETURN BOOLEAN
2670: --dinu_log_message(l_src_query );
2671: --dinu_log_message(l_pdh_query );
2672: --dinu_log_message( ' WHERE attr.attr_group_type = '|| '''' || 'BOM_COMPONENT_BASE'||'''' );
2673: l_attr_sql := l_attr_sql || ' UNION ALL SELECT Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_IMPORT_REF_DESGS'||'''),null,null, ' || p_batch_id || ' batch_identifier '
2674: ||',bom_import_pub.get_ref_desgs(:1,:2,:3,1,:5,:6,:7,:8),bom_import_pub.get_ref_desgs(:1,:2,:3,null,:5,:6,:7,:8) from dual' ;
2675:
2676: /*dinu_log_message(' UNION ALL SELECT Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_IMPORT_REF_DESGS'||'''),null,' || p_batch_id || ' batch_identifier ,';
2677: ||'bom_import_pub.get_ref_desgs(:1,:2,:3,1,:5,:6,:7,:8),');*/
2678: --dinu_log_message(' bom_import_pub.get_ref_desgs(:1,:2,:3,null,:5,:6,:7,:8) from dual' );
2673: l_attr_sql := l_attr_sql || ' UNION ALL SELECT Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_IMPORT_REF_DESGS'||'''),null,null, ' || p_batch_id || ' batch_identifier '
2674: ||',bom_import_pub.get_ref_desgs(:1,:2,:3,1,:5,:6,:7,:8),bom_import_pub.get_ref_desgs(:1,:2,:3,null,:5,:6,:7,:8) from dual' ;
2675:
2676: /*dinu_log_message(' UNION ALL SELECT Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_IMPORT_REF_DESGS'||'''),null,' || p_batch_id || ' batch_identifier ,';
2677: ||'bom_import_pub.get_ref_desgs(:1,:2,:3,1,:5,:6,:7,:8),');*/
2678: --dinu_log_message(' bom_import_pub.get_ref_desgs(:1,:2,:3,null,:5,:6,:7,:8) from dual' );
2679:
2680:
2681: l_dummy := NULL;
2674: ||',bom_import_pub.get_ref_desgs(:1,:2,:3,1,:5,:6,:7,:8),bom_import_pub.get_ref_desgs(:1,:2,:3,null,:5,:6,:7,:8) from dual' ;
2675:
2676: /*dinu_log_message(' UNION ALL SELECT Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_IMPORT_REF_DESGS'||'''),null,' || p_batch_id || ' batch_identifier ,';
2677: ||'bom_import_pub.get_ref_desgs(:1,:2,:3,1,:5,:6,:7,:8),');*/
2678: --dinu_log_message(' bom_import_pub.get_ref_desgs(:1,:2,:3,null,:5,:6,:7,:8) from dual' );
2679:
2680:
2681: l_dummy := NULL;
2682:
2742: IS
2743:
2744: BEGIN
2745:
2746: BOM_IMPORT_PUB.Matching_Complete
2747: (
2748: p_batch_id => p_batch_id
2749: , x_return_status => x_return_status
2750: , x_Error_Mesg => x_Error_Mesg
3472: , p_add_errors_to_fnd_stack => 'T'
3473: , p_commit => 'T'
3474: , p_default_view_privilege => 'EGO_VIEW_ITEM'
3475: , p_default_edit_privilege => l_edit_prvlg
3476: , p_privilege_predicate_api_name => 'Bom_Import_Pub.Get_Item_Security_Predicate'
3477: , p_validate => true
3478: , p_do_dml => true
3479: , x_return_status => l_return_status
3480: , x_errorcode => l_err_code
3532: , x_return_code OUT NOCOPY VARCHAR2
3533: )
3534: IS
3535: BEGIN
3536: BOM_IMPORT_PUB.DATA_UPLOAD_COMPLETE
3537: (
3538: p_batch_id => p_batch_id,
3539: x_Error_Mesg => x_error_message,
3540: p_init_msg_list => 'N',
4292:
4293: IF pG_batch_options.STRUCTURE_CONTENT <> 'A' THEN
4294:
4295:
4296: BOM_IMPORT_PUB.UPDATE_BILL_INFO
4297: (
4298: p_batch_id => p_batch_id
4299: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4300: , x_Return_Status => l_Return_Status
5983:
5984: END Get_Item_Matches;
5985:
5986:
5987: END Bom_Import_Pub;