eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_BPEL_SYNCBILLOFMATERIALSLI dependencies on BOM_BPEL_SYNCBILLOFMATERIALSLI

Line 1: PACKAGE BODY BOM_BPEL_SYNCBILLOFMATERIALSLI AS

1: PACKAGE BODY BOM_BPEL_SYNCBILLOFMATERIALSLI AS
2: /* $Header: BOMAIASB.pls 120.1 2011/12/07 09:13:10 jawan noship $ */
3: /****************************************************************************
4: --
5: -- Copyright (c) 2008 Oracle Corporation, Redwood Shores, CA, USA

Line 14: -- Body of package BOM_BPEL_SYNCBILLOFMATERIALSLI

10: -- BOMAIASB.pls
11: --
12: -- DESCRIPTION
13: --
14: -- Body of package BOM_BPEL_SYNCBILLOFMATERIALSLI
15: --
16: -- NOTES
17: --
18: -- HISTORY

Line 1032: P_BOM_HEADER_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_HEADER_TBL(P_BOM_HEADER_TBL);

1028: BEGIN
1029: Error_Handler.Initialize;
1030:
1031: P_INIT_MSG_LIST_ := SYS.SQLJUTL.INT2BOOL(P_INIT_MSG_LIST);
1032: P_BOM_HEADER_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_HEADER_TBL(P_BOM_HEADER_TBL);
1033: P_BOM_REVISION_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_REV_TBL(P_BOM_REVISION_TBL);
1034: P_BOM_COMPONENT_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_COMPS_TBL(P_BOM_COMPONENT_TBL);
1035: P_BOM_REF_DESIGNATOR_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_RF_DES_TBL(P_BOM_REF_DESIGNATOR_TBL);
1036: P_BOM_SUB_COMPONENT_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_SUB_COMP_TBL(P_BOM_SUB_COMPONENT_TBL);

Line 1033: P_BOM_REVISION_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_REV_TBL(P_BOM_REVISION_TBL);

1029: Error_Handler.Initialize;
1030:
1031: P_INIT_MSG_LIST_ := SYS.SQLJUTL.INT2BOOL(P_INIT_MSG_LIST);
1032: P_BOM_HEADER_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_HEADER_TBL(P_BOM_HEADER_TBL);
1033: P_BOM_REVISION_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_REV_TBL(P_BOM_REVISION_TBL);
1034: P_BOM_COMPONENT_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_COMPS_TBL(P_BOM_COMPONENT_TBL);
1035: P_BOM_REF_DESIGNATOR_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_RF_DES_TBL(P_BOM_REF_DESIGNATOR_TBL);
1036: P_BOM_SUB_COMPONENT_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_SUB_COMP_TBL(P_BOM_SUB_COMPONENT_TBL);
1037: P_BOM_COMP_OPS_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_COMP_OPS_TBL(P_BOM_COMP_OPS_TBL);

Line 1034: P_BOM_COMPONENT_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_COMPS_TBL(P_BOM_COMPONENT_TBL);

1030:
1031: P_INIT_MSG_LIST_ := SYS.SQLJUTL.INT2BOOL(P_INIT_MSG_LIST);
1032: P_BOM_HEADER_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_HEADER_TBL(P_BOM_HEADER_TBL);
1033: P_BOM_REVISION_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_REV_TBL(P_BOM_REVISION_TBL);
1034: P_BOM_COMPONENT_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_COMPS_TBL(P_BOM_COMPONENT_TBL);
1035: P_BOM_REF_DESIGNATOR_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_RF_DES_TBL(P_BOM_REF_DESIGNATOR_TBL);
1036: P_BOM_SUB_COMPONENT_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_SUB_COMP_TBL(P_BOM_SUB_COMPONENT_TBL);
1037: P_BOM_COMP_OPS_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_COMP_OPS_TBL(P_BOM_COMP_OPS_TBL);
1038: BOM_BO_PUB.PROCESS_BOM(P_BO_IDENTIFIER, P_API_VERSION_NUMBER, P_INIT_MSG_LIST_,

Line 1035: P_BOM_REF_DESIGNATOR_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_RF_DES_TBL(P_BOM_REF_DESIGNATOR_TBL);

1031: P_INIT_MSG_LIST_ := SYS.SQLJUTL.INT2BOOL(P_INIT_MSG_LIST);
1032: P_BOM_HEADER_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_HEADER_TBL(P_BOM_HEADER_TBL);
1033: P_BOM_REVISION_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_REV_TBL(P_BOM_REVISION_TBL);
1034: P_BOM_COMPONENT_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_COMPS_TBL(P_BOM_COMPONENT_TBL);
1035: P_BOM_REF_DESIGNATOR_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_RF_DES_TBL(P_BOM_REF_DESIGNATOR_TBL);
1036: P_BOM_SUB_COMPONENT_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_SUB_COMP_TBL(P_BOM_SUB_COMPONENT_TBL);
1037: P_BOM_COMP_OPS_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_COMP_OPS_TBL(P_BOM_COMP_OPS_TBL);
1038: BOM_BO_PUB.PROCESS_BOM(P_BO_IDENTIFIER, P_API_VERSION_NUMBER, P_INIT_MSG_LIST_,
1039: P_BOM_HEADER_TBL_, P_BOM_REVISION_TBL_, P_BOM_COMPONENT_TBL_,

Line 1036: P_BOM_SUB_COMPONENT_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_SUB_COMP_TBL(P_BOM_SUB_COMPONENT_TBL);

1032: P_BOM_HEADER_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_HEADER_TBL(P_BOM_HEADER_TBL);
1033: P_BOM_REVISION_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_REV_TBL(P_BOM_REVISION_TBL);
1034: P_BOM_COMPONENT_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_COMPS_TBL(P_BOM_COMPONENT_TBL);
1035: P_BOM_REF_DESIGNATOR_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_RF_DES_TBL(P_BOM_REF_DESIGNATOR_TBL);
1036: P_BOM_SUB_COMPONENT_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_SUB_COMP_TBL(P_BOM_SUB_COMPONENT_TBL);
1037: P_BOM_COMP_OPS_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_COMP_OPS_TBL(P_BOM_COMP_OPS_TBL);
1038: BOM_BO_PUB.PROCESS_BOM(P_BO_IDENTIFIER, P_API_VERSION_NUMBER, P_INIT_MSG_LIST_,
1039: P_BOM_HEADER_TBL_, P_BOM_REVISION_TBL_, P_BOM_COMPONENT_TBL_,
1040: P_BOM_REF_DESIGNATOR_TBL_, P_BOM_SUB_COMPONENT_TBL_, P_BOM_COMP_OPS_TBL_,

Line 1037: P_BOM_COMP_OPS_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_COMP_OPS_TBL(P_BOM_COMP_OPS_TBL);

1033: P_BOM_REVISION_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_REV_TBL(P_BOM_REVISION_TBL);
1034: P_BOM_COMPONENT_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_COMPS_TBL(P_BOM_COMPONENT_TBL);
1035: P_BOM_REF_DESIGNATOR_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_RF_DES_TBL(P_BOM_REF_DESIGNATOR_TBL);
1036: P_BOM_SUB_COMPONENT_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_SUB_COMP_TBL(P_BOM_SUB_COMPONENT_TBL);
1037: P_BOM_COMP_OPS_TBL_ := BOM_BPEL_SYNCBILLOFMATERIALSLI.SQL_TO_PL_COMP_OPS_TBL(P_BOM_COMP_OPS_TBL);
1038: BOM_BO_PUB.PROCESS_BOM(P_BO_IDENTIFIER, P_API_VERSION_NUMBER, P_INIT_MSG_LIST_,
1039: P_BOM_HEADER_TBL_, P_BOM_REVISION_TBL_, P_BOM_COMPONENT_TBL_,
1040: P_BOM_REF_DESIGNATOR_TBL_, P_BOM_SUB_COMPONENT_TBL_, P_BOM_COMP_OPS_TBL_,
1041: X_BOM_HEADER_TBL_, X_BOM_REVISION_TBL_, X_BOM_COMPONENT_TBL_,

Line 1061: X_BOM_HEADER_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_HEADER_TBL(X_BOM_HEADER_TBL_);

1057: X_BOM_COMPONENT_TBL := BOM_BO_PUB_BOM_COMPS_TBL_TYPE();
1058: X_BOM_REF_DESIGNATOR_TBL := BOM_BO_PUB_BOM_RF_DES_TBL_TYPE();
1059: X_BOM_SUB_COMPONENT_TBL := BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE();
1060: X_BOM_COMP_OPS_TBL := BOM_BO_PUB_BOM_COMPOP_TBL_TYPE();
1061: X_BOM_HEADER_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_HEADER_TBL(X_BOM_HEADER_TBL_);
1062: X_BOM_REVISION_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_REV_TBL(X_BOM_REVISION_TBL_);
1063: X_BOM_COMPONENT_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_COMPS_TBL(X_BOM_COMPONENT_TBL_);
1064: X_BOM_REF_DESIGNATOR_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_RF_DES_TBL(X_BOM_REF_DESIGNATOR_TBL_);
1065: X_BOM_SUB_COMPONENT_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_SUB_COMP_TBL(X_BOM_SUB_COMPONENT_TBL_);

Line 1062: X_BOM_REVISION_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_REV_TBL(X_BOM_REVISION_TBL_);

1058: X_BOM_REF_DESIGNATOR_TBL := BOM_BO_PUB_BOM_RF_DES_TBL_TYPE();
1059: X_BOM_SUB_COMPONENT_TBL := BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE();
1060: X_BOM_COMP_OPS_TBL := BOM_BO_PUB_BOM_COMPOP_TBL_TYPE();
1061: X_BOM_HEADER_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_HEADER_TBL(X_BOM_HEADER_TBL_);
1062: X_BOM_REVISION_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_REV_TBL(X_BOM_REVISION_TBL_);
1063: X_BOM_COMPONENT_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_COMPS_TBL(X_BOM_COMPONENT_TBL_);
1064: X_BOM_REF_DESIGNATOR_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_RF_DES_TBL(X_BOM_REF_DESIGNATOR_TBL_);
1065: X_BOM_SUB_COMPONENT_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_SUB_COMP_TBL(X_BOM_SUB_COMPONENT_TBL_);
1066: X_BOM_COMP_OPS_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_COMP_OPS_TBL(X_BOM_COMP_OPS_TBL_);

Line 1063: X_BOM_COMPONENT_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_COMPS_TBL(X_BOM_COMPONENT_TBL_);

1059: X_BOM_SUB_COMPONENT_TBL := BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE();
1060: X_BOM_COMP_OPS_TBL := BOM_BO_PUB_BOM_COMPOP_TBL_TYPE();
1061: X_BOM_HEADER_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_HEADER_TBL(X_BOM_HEADER_TBL_);
1062: X_BOM_REVISION_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_REV_TBL(X_BOM_REVISION_TBL_);
1063: X_BOM_COMPONENT_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_COMPS_TBL(X_BOM_COMPONENT_TBL_);
1064: X_BOM_REF_DESIGNATOR_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_RF_DES_TBL(X_BOM_REF_DESIGNATOR_TBL_);
1065: X_BOM_SUB_COMPONENT_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_SUB_COMP_TBL(X_BOM_SUB_COMPONENT_TBL_);
1066: X_BOM_COMP_OPS_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_COMP_OPS_TBL(X_BOM_COMP_OPS_TBL_);
1067: END BOM_BO_PUB$PROCESS_BOM;

Line 1064: X_BOM_REF_DESIGNATOR_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_RF_DES_TBL(X_BOM_REF_DESIGNATOR_TBL_);

1060: X_BOM_COMP_OPS_TBL := BOM_BO_PUB_BOM_COMPOP_TBL_TYPE();
1061: X_BOM_HEADER_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_HEADER_TBL(X_BOM_HEADER_TBL_);
1062: X_BOM_REVISION_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_REV_TBL(X_BOM_REVISION_TBL_);
1063: X_BOM_COMPONENT_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_COMPS_TBL(X_BOM_COMPONENT_TBL_);
1064: X_BOM_REF_DESIGNATOR_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_RF_DES_TBL(X_BOM_REF_DESIGNATOR_TBL_);
1065: X_BOM_SUB_COMPONENT_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_SUB_COMP_TBL(X_BOM_SUB_COMPONENT_TBL_);
1066: X_BOM_COMP_OPS_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_COMP_OPS_TBL(X_BOM_COMP_OPS_TBL_);
1067: END BOM_BO_PUB$PROCESS_BOM;
1068:

Line 1065: X_BOM_SUB_COMPONENT_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_SUB_COMP_TBL(X_BOM_SUB_COMPONENT_TBL_);

1061: X_BOM_HEADER_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_HEADER_TBL(X_BOM_HEADER_TBL_);
1062: X_BOM_REVISION_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_REV_TBL(X_BOM_REVISION_TBL_);
1063: X_BOM_COMPONENT_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_COMPS_TBL(X_BOM_COMPONENT_TBL_);
1064: X_BOM_REF_DESIGNATOR_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_RF_DES_TBL(X_BOM_REF_DESIGNATOR_TBL_);
1065: X_BOM_SUB_COMPONENT_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_SUB_COMP_TBL(X_BOM_SUB_COMPONENT_TBL_);
1066: X_BOM_COMP_OPS_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_COMP_OPS_TBL(X_BOM_COMP_OPS_TBL_);
1067: END BOM_BO_PUB$PROCESS_BOM;
1068:
1069:

Line 1066: X_BOM_COMP_OPS_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_COMP_OPS_TBL(X_BOM_COMP_OPS_TBL_);

1062: X_BOM_REVISION_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_REV_TBL(X_BOM_REVISION_TBL_);
1063: X_BOM_COMPONENT_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_COMPS_TBL(X_BOM_COMPONENT_TBL_);
1064: X_BOM_REF_DESIGNATOR_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_RF_DES_TBL(X_BOM_REF_DESIGNATOR_TBL_);
1065: X_BOM_SUB_COMPONENT_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_SUB_COMP_TBL(X_BOM_SUB_COMPONENT_TBL_);
1066: X_BOM_COMP_OPS_TBL := BOM_BPEL_SYNCBILLOFMATERIALSLI.PL_TO_SQL_COMP_OPS_TBL(X_BOM_COMP_OPS_TBL_);
1067: END BOM_BO_PUB$PROCESS_BOM;
1068:
1069:
1070:

Line 1072: END BOM_BPEL_SYNCBILLOFMATERIALSLI;

1068:
1069:
1070:
1071:
1072: END BOM_BPEL_SYNCBILLOFMATERIALSLI;