DBA Data[Home] [Help]

APPS.BOM_BPEL_SYNCBILLOFMATERIALSLI dependencies on BOM_BO_PUB

Line 24: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_HEAD_REC_TYPE

20: -- 02-OCT-2008 Kashif Suleman Initial Creation
21: --
22: ****************************************************************************/
23:
24: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_HEAD_REC_TYPE
25: FUNCTION PL_TO_SQL_HEAD_REC
26: (
27: aPlsqlItem BOM_BO_PUB.BOM_HEAD_REC_TYPE)
28: RETURN BOM_BO_PUB_BOM_HEAD_REC_TYPE;

Line 27: aPlsqlItem BOM_BO_PUB.BOM_HEAD_REC_TYPE)

23:
24: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_HEAD_REC_TYPE
25: FUNCTION PL_TO_SQL_HEAD_REC
26: (
27: aPlsqlItem BOM_BO_PUB.BOM_HEAD_REC_TYPE)
28: RETURN BOM_BO_PUB_BOM_HEAD_REC_TYPE;
29: FUNCTION SQL_TO_PL_HEAD_REC
30: (
31: aSqlItem BOM_BO_PUB_BOM_HEAD_REC_TYPE)

Line 28: RETURN BOM_BO_PUB_BOM_HEAD_REC_TYPE;

24: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_HEAD_REC_TYPE
25: FUNCTION PL_TO_SQL_HEAD_REC
26: (
27: aPlsqlItem BOM_BO_PUB.BOM_HEAD_REC_TYPE)
28: RETURN BOM_BO_PUB_BOM_HEAD_REC_TYPE;
29: FUNCTION SQL_TO_PL_HEAD_REC
30: (
31: aSqlItem BOM_BO_PUB_BOM_HEAD_REC_TYPE)
32: RETURN BOM_BO_PUB.BOM_HEAD_REC_TYPE;

Line 31: aSqlItem BOM_BO_PUB_BOM_HEAD_REC_TYPE)

27: aPlsqlItem BOM_BO_PUB.BOM_HEAD_REC_TYPE)
28: RETURN BOM_BO_PUB_BOM_HEAD_REC_TYPE;
29: FUNCTION SQL_TO_PL_HEAD_REC
30: (
31: aSqlItem BOM_BO_PUB_BOM_HEAD_REC_TYPE)
32: RETURN BOM_BO_PUB.BOM_HEAD_REC_TYPE;
33: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REVISION_REC_TYPE
34: FUNCTION PL_TO_SQL_REV_REC
35: (

Line 32: RETURN BOM_BO_PUB.BOM_HEAD_REC_TYPE;

28: RETURN BOM_BO_PUB_BOM_HEAD_REC_TYPE;
29: FUNCTION SQL_TO_PL_HEAD_REC
30: (
31: aSqlItem BOM_BO_PUB_BOM_HEAD_REC_TYPE)
32: RETURN BOM_BO_PUB.BOM_HEAD_REC_TYPE;
33: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REVISION_REC_TYPE
34: FUNCTION PL_TO_SQL_REV_REC
35: (
36: aPlsqlItem BOM_BO_PUB.BOM_REVISION_REC_TYPE)

Line 33: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REVISION_REC_TYPE

29: FUNCTION SQL_TO_PL_HEAD_REC
30: (
31: aSqlItem BOM_BO_PUB_BOM_HEAD_REC_TYPE)
32: RETURN BOM_BO_PUB.BOM_HEAD_REC_TYPE;
33: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REVISION_REC_TYPE
34: FUNCTION PL_TO_SQL_REV_REC
35: (
36: aPlsqlItem BOM_BO_PUB.BOM_REVISION_REC_TYPE)
37: RETURN BOM_BO_PUB_BOM_REV_REC_TYPE;

Line 36: aPlsqlItem BOM_BO_PUB.BOM_REVISION_REC_TYPE)

32: RETURN BOM_BO_PUB.BOM_HEAD_REC_TYPE;
33: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REVISION_REC_TYPE
34: FUNCTION PL_TO_SQL_REV_REC
35: (
36: aPlsqlItem BOM_BO_PUB.BOM_REVISION_REC_TYPE)
37: RETURN BOM_BO_PUB_BOM_REV_REC_TYPE;
38: FUNCTION SQL_TO_PL_REV_REC
39: (
40: aSqlItem BOM_BO_PUB_BOM_REV_REC_TYPE)

Line 37: RETURN BOM_BO_PUB_BOM_REV_REC_TYPE;

33: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REVISION_REC_TYPE
34: FUNCTION PL_TO_SQL_REV_REC
35: (
36: aPlsqlItem BOM_BO_PUB.BOM_REVISION_REC_TYPE)
37: RETURN BOM_BO_PUB_BOM_REV_REC_TYPE;
38: FUNCTION SQL_TO_PL_REV_REC
39: (
40: aSqlItem BOM_BO_PUB_BOM_REV_REC_TYPE)
41: RETURN BOM_BO_PUB.BOM_REVISION_REC_TYPE;

Line 40: aSqlItem BOM_BO_PUB_BOM_REV_REC_TYPE)

36: aPlsqlItem BOM_BO_PUB.BOM_REVISION_REC_TYPE)
37: RETURN BOM_BO_PUB_BOM_REV_REC_TYPE;
38: FUNCTION SQL_TO_PL_REV_REC
39: (
40: aSqlItem BOM_BO_PUB_BOM_REV_REC_TYPE)
41: RETURN BOM_BO_PUB.BOM_REVISION_REC_TYPE;
42: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REVISION_TBL_TYPE
43: FUNCTION PL_TO_SQL_REV_TBL
44: (

Line 41: RETURN BOM_BO_PUB.BOM_REVISION_REC_TYPE;

37: RETURN BOM_BO_PUB_BOM_REV_REC_TYPE;
38: FUNCTION SQL_TO_PL_REV_REC
39: (
40: aSqlItem BOM_BO_PUB_BOM_REV_REC_TYPE)
41: RETURN BOM_BO_PUB.BOM_REVISION_REC_TYPE;
42: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REVISION_TBL_TYPE
43: FUNCTION PL_TO_SQL_REV_TBL
44: (
45: aPlsqlItem BOM_BO_PUB.BOM_REVISION_TBL_TYPE)

Line 42: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REVISION_TBL_TYPE

38: FUNCTION SQL_TO_PL_REV_REC
39: (
40: aSqlItem BOM_BO_PUB_BOM_REV_REC_TYPE)
41: RETURN BOM_BO_PUB.BOM_REVISION_REC_TYPE;
42: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REVISION_TBL_TYPE
43: FUNCTION PL_TO_SQL_REV_TBL
44: (
45: aPlsqlItem BOM_BO_PUB.BOM_REVISION_TBL_TYPE)
46: RETURN BOM_BO_PUB_BOM_REV_TBL_TYPE;

Line 45: aPlsqlItem BOM_BO_PUB.BOM_REVISION_TBL_TYPE)

41: RETURN BOM_BO_PUB.BOM_REVISION_REC_TYPE;
42: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REVISION_TBL_TYPE
43: FUNCTION PL_TO_SQL_REV_TBL
44: (
45: aPlsqlItem BOM_BO_PUB.BOM_REVISION_TBL_TYPE)
46: RETURN BOM_BO_PUB_BOM_REV_TBL_TYPE;
47: FUNCTION SQL_TO_PL_REV_TBL
48: (
49: aSqlItem BOM_BO_PUB_BOM_REV_TBL_TYPE)

Line 46: RETURN BOM_BO_PUB_BOM_REV_TBL_TYPE;

42: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REVISION_TBL_TYPE
43: FUNCTION PL_TO_SQL_REV_TBL
44: (
45: aPlsqlItem BOM_BO_PUB.BOM_REVISION_TBL_TYPE)
46: RETURN BOM_BO_PUB_BOM_REV_TBL_TYPE;
47: FUNCTION SQL_TO_PL_REV_TBL
48: (
49: aSqlItem BOM_BO_PUB_BOM_REV_TBL_TYPE)
50: RETURN BOM_BO_PUB.BOM_REVISION_TBL_TYPE;

Line 49: aSqlItem BOM_BO_PUB_BOM_REV_TBL_TYPE)

45: aPlsqlItem BOM_BO_PUB.BOM_REVISION_TBL_TYPE)
46: RETURN BOM_BO_PUB_BOM_REV_TBL_TYPE;
47: FUNCTION SQL_TO_PL_REV_TBL
48: (
49: aSqlItem BOM_BO_PUB_BOM_REV_TBL_TYPE)
50: RETURN BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
51: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMPS_REC_TYPE
52: FUNCTION PL_TO_SQL_COMPS_REC
53: (

Line 50: RETURN BOM_BO_PUB.BOM_REVISION_TBL_TYPE;

46: RETURN BOM_BO_PUB_BOM_REV_TBL_TYPE;
47: FUNCTION SQL_TO_PL_REV_TBL
48: (
49: aSqlItem BOM_BO_PUB_BOM_REV_TBL_TYPE)
50: RETURN BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
51: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMPS_REC_TYPE
52: FUNCTION PL_TO_SQL_COMPS_REC
53: (
54: aPlsqlItem BOM_BO_PUB.BOM_COMPS_REC_TYPE)

Line 51: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMPS_REC_TYPE

47: FUNCTION SQL_TO_PL_REV_TBL
48: (
49: aSqlItem BOM_BO_PUB_BOM_REV_TBL_TYPE)
50: RETURN BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
51: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMPS_REC_TYPE
52: FUNCTION PL_TO_SQL_COMPS_REC
53: (
54: aPlsqlItem BOM_BO_PUB.BOM_COMPS_REC_TYPE)
55: RETURN BOM_BO_PUB_BOM_COMPS_REC_TYPE;

Line 54: aPlsqlItem BOM_BO_PUB.BOM_COMPS_REC_TYPE)

50: RETURN BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
51: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMPS_REC_TYPE
52: FUNCTION PL_TO_SQL_COMPS_REC
53: (
54: aPlsqlItem BOM_BO_PUB.BOM_COMPS_REC_TYPE)
55: RETURN BOM_BO_PUB_BOM_COMPS_REC_TYPE;
56: FUNCTION SQL_TO_PL_COMPS_REC
57: (
58: aSqlItem BOM_BO_PUB_BOM_COMPS_REC_TYPE)

Line 55: RETURN BOM_BO_PUB_BOM_COMPS_REC_TYPE;

51: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMPS_REC_TYPE
52: FUNCTION PL_TO_SQL_COMPS_REC
53: (
54: aPlsqlItem BOM_BO_PUB.BOM_COMPS_REC_TYPE)
55: RETURN BOM_BO_PUB_BOM_COMPS_REC_TYPE;
56: FUNCTION SQL_TO_PL_COMPS_REC
57: (
58: aSqlItem BOM_BO_PUB_BOM_COMPS_REC_TYPE)
59: RETURN BOM_BO_PUB.BOM_COMPS_REC_TYPE;

Line 58: aSqlItem BOM_BO_PUB_BOM_COMPS_REC_TYPE)

54: aPlsqlItem BOM_BO_PUB.BOM_COMPS_REC_TYPE)
55: RETURN BOM_BO_PUB_BOM_COMPS_REC_TYPE;
56: FUNCTION SQL_TO_PL_COMPS_REC
57: (
58: aSqlItem BOM_BO_PUB_BOM_COMPS_REC_TYPE)
59: RETURN BOM_BO_PUB.BOM_COMPS_REC_TYPE;
60: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMPS_TBL_TYPE
61: FUNCTION PL_TO_SQL_COMPS_TBL
62: (

Line 59: RETURN BOM_BO_PUB.BOM_COMPS_REC_TYPE;

55: RETURN BOM_BO_PUB_BOM_COMPS_REC_TYPE;
56: FUNCTION SQL_TO_PL_COMPS_REC
57: (
58: aSqlItem BOM_BO_PUB_BOM_COMPS_REC_TYPE)
59: RETURN BOM_BO_PUB.BOM_COMPS_REC_TYPE;
60: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMPS_TBL_TYPE
61: FUNCTION PL_TO_SQL_COMPS_TBL
62: (
63: aPlsqlItem BOM_BO_PUB.BOM_COMPS_TBL_TYPE)

Line 60: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMPS_TBL_TYPE

56: FUNCTION SQL_TO_PL_COMPS_REC
57: (
58: aSqlItem BOM_BO_PUB_BOM_COMPS_REC_TYPE)
59: RETURN BOM_BO_PUB.BOM_COMPS_REC_TYPE;
60: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMPS_TBL_TYPE
61: FUNCTION PL_TO_SQL_COMPS_TBL
62: (
63: aPlsqlItem BOM_BO_PUB.BOM_COMPS_TBL_TYPE)
64: RETURN BOM_BO_PUB_BOM_COMPS_TBL_TYPE;

Line 63: aPlsqlItem BOM_BO_PUB.BOM_COMPS_TBL_TYPE)

59: RETURN BOM_BO_PUB.BOM_COMPS_REC_TYPE;
60: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMPS_TBL_TYPE
61: FUNCTION PL_TO_SQL_COMPS_TBL
62: (
63: aPlsqlItem BOM_BO_PUB.BOM_COMPS_TBL_TYPE)
64: RETURN BOM_BO_PUB_BOM_COMPS_TBL_TYPE;
65: FUNCTION SQL_TO_PL_COMPS_TBL
66: (
67: aSqlItem BOM_BO_PUB_BOM_COMPS_TBL_TYPE)

Line 64: RETURN BOM_BO_PUB_BOM_COMPS_TBL_TYPE;

60: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMPS_TBL_TYPE
61: FUNCTION PL_TO_SQL_COMPS_TBL
62: (
63: aPlsqlItem BOM_BO_PUB.BOM_COMPS_TBL_TYPE)
64: RETURN BOM_BO_PUB_BOM_COMPS_TBL_TYPE;
65: FUNCTION SQL_TO_PL_COMPS_TBL
66: (
67: aSqlItem BOM_BO_PUB_BOM_COMPS_TBL_TYPE)
68: RETURN BOM_BO_PUB.BOM_COMPS_TBL_TYPE;

Line 67: aSqlItem BOM_BO_PUB_BOM_COMPS_TBL_TYPE)

63: aPlsqlItem BOM_BO_PUB.BOM_COMPS_TBL_TYPE)
64: RETURN BOM_BO_PUB_BOM_COMPS_TBL_TYPE;
65: FUNCTION SQL_TO_PL_COMPS_TBL
66: (
67: aSqlItem BOM_BO_PUB_BOM_COMPS_TBL_TYPE)
68: RETURN BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
69: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE
70: FUNCTION PL_TO_SQL_RF_DES_REC
71: (

Line 68: RETURN BOM_BO_PUB.BOM_COMPS_TBL_TYPE;

64: RETURN BOM_BO_PUB_BOM_COMPS_TBL_TYPE;
65: FUNCTION SQL_TO_PL_COMPS_TBL
66: (
67: aSqlItem BOM_BO_PUB_BOM_COMPS_TBL_TYPE)
68: RETURN BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
69: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE
70: FUNCTION PL_TO_SQL_RF_DES_REC
71: (
72: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE)

Line 69: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE

65: FUNCTION SQL_TO_PL_COMPS_TBL
66: (
67: aSqlItem BOM_BO_PUB_BOM_COMPS_TBL_TYPE)
68: RETURN BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
69: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE
70: FUNCTION PL_TO_SQL_RF_DES_REC
71: (
72: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE)
73: RETURN BOM_BO_PUB_BOM_RF_DES_REC_TYPE;

Line 72: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE)

68: RETURN BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
69: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE
70: FUNCTION PL_TO_SQL_RF_DES_REC
71: (
72: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE)
73: RETURN BOM_BO_PUB_BOM_RF_DES_REC_TYPE;
74: FUNCTION SQL_TO_PL_RF_DES_REC
75: (
76: aSqlItem BOM_BO_PUB_BOM_RF_DES_REC_TYPE)

Line 73: RETURN BOM_BO_PUB_BOM_RF_DES_REC_TYPE;

69: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE
70: FUNCTION PL_TO_SQL_RF_DES_REC
71: (
72: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE)
73: RETURN BOM_BO_PUB_BOM_RF_DES_REC_TYPE;
74: FUNCTION SQL_TO_PL_RF_DES_REC
75: (
76: aSqlItem BOM_BO_PUB_BOM_RF_DES_REC_TYPE)
77: RETURN BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE;

Line 76: aSqlItem BOM_BO_PUB_BOM_RF_DES_REC_TYPE)

72: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE)
73: RETURN BOM_BO_PUB_BOM_RF_DES_REC_TYPE;
74: FUNCTION SQL_TO_PL_RF_DES_REC
75: (
76: aSqlItem BOM_BO_PUB_BOM_RF_DES_REC_TYPE)
77: RETURN BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE;
78: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE
79: FUNCTION PL_TO_SQL_RF_DES_TBL
80: (

Line 77: RETURN BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE;

73: RETURN BOM_BO_PUB_BOM_RF_DES_REC_TYPE;
74: FUNCTION SQL_TO_PL_RF_DES_REC
75: (
76: aSqlItem BOM_BO_PUB_BOM_RF_DES_REC_TYPE)
77: RETURN BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE;
78: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE
79: FUNCTION PL_TO_SQL_RF_DES_TBL
80: (
81: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE)

Line 78: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE

74: FUNCTION SQL_TO_PL_RF_DES_REC
75: (
76: aSqlItem BOM_BO_PUB_BOM_RF_DES_REC_TYPE)
77: RETURN BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE;
78: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE
79: FUNCTION PL_TO_SQL_RF_DES_TBL
80: (
81: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE)
82: RETURN BOM_BO_PUB_BOM_RF_DES_TBL_TYPE;

Line 81: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE)

77: RETURN BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE;
78: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE
79: FUNCTION PL_TO_SQL_RF_DES_TBL
80: (
81: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE)
82: RETURN BOM_BO_PUB_BOM_RF_DES_TBL_TYPE;
83: FUNCTION SQL_TO_PL_RF_DES_TBL
84: (
85: aSqlItem BOM_BO_PUB_BOM_RF_DES_TBL_TYPE)

Line 82: RETURN BOM_BO_PUB_BOM_RF_DES_TBL_TYPE;

78: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE
79: FUNCTION PL_TO_SQL_RF_DES_TBL
80: (
81: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE)
82: RETURN BOM_BO_PUB_BOM_RF_DES_TBL_TYPE;
83: FUNCTION SQL_TO_PL_RF_DES_TBL
84: (
85: aSqlItem BOM_BO_PUB_BOM_RF_DES_TBL_TYPE)
86: RETURN BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;

Line 85: aSqlItem BOM_BO_PUB_BOM_RF_DES_TBL_TYPE)

81: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE)
82: RETURN BOM_BO_PUB_BOM_RF_DES_TBL_TYPE;
83: FUNCTION SQL_TO_PL_RF_DES_TBL
84: (
85: aSqlItem BOM_BO_PUB_BOM_RF_DES_TBL_TYPE)
86: RETURN BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
87: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE
88: FUNCTION PL_TO_SQL_SUB_COMP_REC
89: (

Line 86: RETURN BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;

82: RETURN BOM_BO_PUB_BOM_RF_DES_TBL_TYPE;
83: FUNCTION SQL_TO_PL_RF_DES_TBL
84: (
85: aSqlItem BOM_BO_PUB_BOM_RF_DES_TBL_TYPE)
86: RETURN BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
87: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE
88: FUNCTION PL_TO_SQL_SUB_COMP_REC
89: (
90: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE)

Line 87: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE

83: FUNCTION SQL_TO_PL_RF_DES_TBL
84: (
85: aSqlItem BOM_BO_PUB_BOM_RF_DES_TBL_TYPE)
86: RETURN BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
87: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE
88: FUNCTION PL_TO_SQL_SUB_COMP_REC
89: (
90: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE)
91: RETURN BOM_BO_PUB_BOM_SUBCMP_REC_TYPE;

Line 90: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE)

86: RETURN BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
87: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE
88: FUNCTION PL_TO_SQL_SUB_COMP_REC
89: (
90: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE)
91: RETURN BOM_BO_PUB_BOM_SUBCMP_REC_TYPE;
92: FUNCTION SQL_TO_PL_SUB_COMP_REC
93: (
94: aSqlItem BOM_BO_PUB_BOM_SUBCMP_REC_TYPE)

Line 91: RETURN BOM_BO_PUB_BOM_SUBCMP_REC_TYPE;

87: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE
88: FUNCTION PL_TO_SQL_SUB_COMP_REC
89: (
90: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE)
91: RETURN BOM_BO_PUB_BOM_SUBCMP_REC_TYPE;
92: FUNCTION SQL_TO_PL_SUB_COMP_REC
93: (
94: aSqlItem BOM_BO_PUB_BOM_SUBCMP_REC_TYPE)
95: RETURN BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE;

Line 94: aSqlItem BOM_BO_PUB_BOM_SUBCMP_REC_TYPE)

90: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE)
91: RETURN BOM_BO_PUB_BOM_SUBCMP_REC_TYPE;
92: FUNCTION SQL_TO_PL_SUB_COMP_REC
93: (
94: aSqlItem BOM_BO_PUB_BOM_SUBCMP_REC_TYPE)
95: RETURN BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE;
96: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE
97: FUNCTION PL_TO_SQL_SUB_COMP_TBL
98: (

Line 95: RETURN BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE;

91: RETURN BOM_BO_PUB_BOM_SUBCMP_REC_TYPE;
92: FUNCTION SQL_TO_PL_SUB_COMP_REC
93: (
94: aSqlItem BOM_BO_PUB_BOM_SUBCMP_REC_TYPE)
95: RETURN BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE;
96: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE
97: FUNCTION PL_TO_SQL_SUB_COMP_TBL
98: (
99: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE)

Line 96: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE

92: FUNCTION SQL_TO_PL_SUB_COMP_REC
93: (
94: aSqlItem BOM_BO_PUB_BOM_SUBCMP_REC_TYPE)
95: RETURN BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE;
96: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE
97: FUNCTION PL_TO_SQL_SUB_COMP_TBL
98: (
99: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE)
100: RETURN BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE;

Line 99: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE)

95: RETURN BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE;
96: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE
97: FUNCTION PL_TO_SQL_SUB_COMP_TBL
98: (
99: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE)
100: RETURN BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE;
101: FUNCTION SQL_TO_PL_SUB_COMP_TBL
102: (
103: aSqlItem BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE)

Line 100: RETURN BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE;

96: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE
97: FUNCTION PL_TO_SQL_SUB_COMP_TBL
98: (
99: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE)
100: RETURN BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE;
101: FUNCTION SQL_TO_PL_SUB_COMP_TBL
102: (
103: aSqlItem BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE)
104: RETURN BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;

Line 103: aSqlItem BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE)

99: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE)
100: RETURN BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE;
101: FUNCTION SQL_TO_PL_SUB_COMP_TBL
102: (
103: aSqlItem BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE)
104: RETURN BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
105: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE
106: FUNCTION PL_TO_SQL_COMP_OPS_REC
107: (

Line 104: RETURN BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;

100: RETURN BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE;
101: FUNCTION SQL_TO_PL_SUB_COMP_TBL
102: (
103: aSqlItem BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE)
104: RETURN BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
105: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE
106: FUNCTION PL_TO_SQL_COMP_OPS_REC
107: (
108: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE)

Line 105: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE

101: FUNCTION SQL_TO_PL_SUB_COMP_TBL
102: (
103: aSqlItem BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE)
104: RETURN BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
105: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE
106: FUNCTION PL_TO_SQL_COMP_OPS_REC
107: (
108: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE)
109: RETURN BOM_BO_PUB_BOM_COMPOP_REC_TYPE;

Line 108: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE)

104: RETURN BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
105: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE
106: FUNCTION PL_TO_SQL_COMP_OPS_REC
107: (
108: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE)
109: RETURN BOM_BO_PUB_BOM_COMPOP_REC_TYPE;
110: FUNCTION SQL_TO_PL_COMP_OPS_REC
111: (
112: aSqlItem BOM_BO_PUB_BOM_COMPOP_REC_TYPE)

Line 109: RETURN BOM_BO_PUB_BOM_COMPOP_REC_TYPE;

105: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE
106: FUNCTION PL_TO_SQL_COMP_OPS_REC
107: (
108: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE)
109: RETURN BOM_BO_PUB_BOM_COMPOP_REC_TYPE;
110: FUNCTION SQL_TO_PL_COMP_OPS_REC
111: (
112: aSqlItem BOM_BO_PUB_BOM_COMPOP_REC_TYPE)
113: RETURN BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE;

Line 112: aSqlItem BOM_BO_PUB_BOM_COMPOP_REC_TYPE)

108: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE)
109: RETURN BOM_BO_PUB_BOM_COMPOP_REC_TYPE;
110: FUNCTION SQL_TO_PL_COMP_OPS_REC
111: (
112: aSqlItem BOM_BO_PUB_BOM_COMPOP_REC_TYPE)
113: RETURN BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE;
114: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE
115: FUNCTION PL_TO_SQL_COMP_OPS_TBL
116: (

Line 113: RETURN BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE;

109: RETURN BOM_BO_PUB_BOM_COMPOP_REC_TYPE;
110: FUNCTION SQL_TO_PL_COMP_OPS_REC
111: (
112: aSqlItem BOM_BO_PUB_BOM_COMPOP_REC_TYPE)
113: RETURN BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE;
114: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE
115: FUNCTION PL_TO_SQL_COMP_OPS_TBL
116: (
117: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE)

Line 114: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE

110: FUNCTION SQL_TO_PL_COMP_OPS_REC
111: (
112: aSqlItem BOM_BO_PUB_BOM_COMPOP_REC_TYPE)
113: RETURN BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE;
114: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE
115: FUNCTION PL_TO_SQL_COMP_OPS_TBL
116: (
117: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE)
118: RETURN BOM_BO_PUB_BOM_COMPOP_TBL_TYPE;

Line 117: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE)

113: RETURN BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE;
114: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE
115: FUNCTION PL_TO_SQL_COMP_OPS_TBL
116: (
117: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE)
118: RETURN BOM_BO_PUB_BOM_COMPOP_TBL_TYPE;
119: FUNCTION SQL_TO_PL_COMP_OPS_TBL
120: (
121: aSqlItem BOM_BO_PUB_BOM_COMPOP_TBL_TYPE)

Line 118: RETURN BOM_BO_PUB_BOM_COMPOP_TBL_TYPE;

114: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE
115: FUNCTION PL_TO_SQL_COMP_OPS_TBL
116: (
117: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE)
118: RETURN BOM_BO_PUB_BOM_COMPOP_TBL_TYPE;
119: FUNCTION SQL_TO_PL_COMP_OPS_TBL
120: (
121: aSqlItem BOM_BO_PUB_BOM_COMPOP_TBL_TYPE)
122: RETURN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;

Line 121: aSqlItem BOM_BO_PUB_BOM_COMPOP_TBL_TYPE)

117: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE)
118: RETURN BOM_BO_PUB_BOM_COMPOP_TBL_TYPE;
119: FUNCTION SQL_TO_PL_COMP_OPS_TBL
120: (
121: aSqlItem BOM_BO_PUB_BOM_COMPOP_TBL_TYPE)
122: RETURN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;
123: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_PRODUCT_REC_TYPE
124: FUNCTION PL_TO_SQL_PROD_REC
125: (

Line 122: RETURN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;

118: RETURN BOM_BO_PUB_BOM_COMPOP_TBL_TYPE;
119: FUNCTION SQL_TO_PL_COMP_OPS_TBL
120: (
121: aSqlItem BOM_BO_PUB_BOM_COMPOP_TBL_TYPE)
122: RETURN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;
123: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_PRODUCT_REC_TYPE
124: FUNCTION PL_TO_SQL_PROD_REC
125: (
126: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_REC_TYPE)

Line 123: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_PRODUCT_REC_TYPE

119: FUNCTION SQL_TO_PL_COMP_OPS_TBL
120: (
121: aSqlItem BOM_BO_PUB_BOM_COMPOP_TBL_TYPE)
122: RETURN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;
123: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_PRODUCT_REC_TYPE
124: FUNCTION PL_TO_SQL_PROD_REC
125: (
126: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_REC_TYPE)
127: RETURN BOM_BO_PUB_BOM_PROD_REC_TYPE;

Line 126: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_REC_TYPE)

122: RETURN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;
123: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_PRODUCT_REC_TYPE
124: FUNCTION PL_TO_SQL_PROD_REC
125: (
126: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_REC_TYPE)
127: RETURN BOM_BO_PUB_BOM_PROD_REC_TYPE;
128: FUNCTION SQL_TO_PL_PROD_REC
129: (
130: aSqlItem BOM_BO_PUB_BOM_PROD_REC_TYPE)

Line 127: RETURN BOM_BO_PUB_BOM_PROD_REC_TYPE;

123: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_PRODUCT_REC_TYPE
124: FUNCTION PL_TO_SQL_PROD_REC
125: (
126: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_REC_TYPE)
127: RETURN BOM_BO_PUB_BOM_PROD_REC_TYPE;
128: FUNCTION SQL_TO_PL_PROD_REC
129: (
130: aSqlItem BOM_BO_PUB_BOM_PROD_REC_TYPE)
131: RETURN BOM_BO_PUB.BOM_PRODUCT_REC_TYPE;

Line 130: aSqlItem BOM_BO_PUB_BOM_PROD_REC_TYPE)

126: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_REC_TYPE)
127: RETURN BOM_BO_PUB_BOM_PROD_REC_TYPE;
128: FUNCTION SQL_TO_PL_PROD_REC
129: (
130: aSqlItem BOM_BO_PUB_BOM_PROD_REC_TYPE)
131: RETURN BOM_BO_PUB.BOM_PRODUCT_REC_TYPE;
132: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE
133: FUNCTION PL_TO_SQL_PROD_MEM_REC
134: (

Line 131: RETURN BOM_BO_PUB.BOM_PRODUCT_REC_TYPE;

127: RETURN BOM_BO_PUB_BOM_PROD_REC_TYPE;
128: FUNCTION SQL_TO_PL_PROD_REC
129: (
130: aSqlItem BOM_BO_PUB_BOM_PROD_REC_TYPE)
131: RETURN BOM_BO_PUB.BOM_PRODUCT_REC_TYPE;
132: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE
133: FUNCTION PL_TO_SQL_PROD_MEM_REC
134: (
135: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE)

Line 132: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE

128: FUNCTION SQL_TO_PL_PROD_REC
129: (
130: aSqlItem BOM_BO_PUB_BOM_PROD_REC_TYPE)
131: RETURN BOM_BO_PUB.BOM_PRODUCT_REC_TYPE;
132: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE
133: FUNCTION PL_TO_SQL_PROD_MEM_REC
134: (
135: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE)
136: RETURN BOM_BO_PUB_BOM_PRDMEM_REC_TYPE;

Line 135: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE)

131: RETURN BOM_BO_PUB.BOM_PRODUCT_REC_TYPE;
132: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE
133: FUNCTION PL_TO_SQL_PROD_MEM_REC
134: (
135: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE)
136: RETURN BOM_BO_PUB_BOM_PRDMEM_REC_TYPE;
137: FUNCTION SQL_TO_PL_PROD_MEM_REC
138: (
139: aSqlItem BOM_BO_PUB_BOM_PRDMEM_REC_TYPE)

Line 136: RETURN BOM_BO_PUB_BOM_PRDMEM_REC_TYPE;

132: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE
133: FUNCTION PL_TO_SQL_PROD_MEM_REC
134: (
135: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE)
136: RETURN BOM_BO_PUB_BOM_PRDMEM_REC_TYPE;
137: FUNCTION SQL_TO_PL_PROD_MEM_REC
138: (
139: aSqlItem BOM_BO_PUB_BOM_PRDMEM_REC_TYPE)
140: RETURN BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE;

Line 139: aSqlItem BOM_BO_PUB_BOM_PRDMEM_REC_TYPE)

135: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE)
136: RETURN BOM_BO_PUB_BOM_PRDMEM_REC_TYPE;
137: FUNCTION SQL_TO_PL_PROD_MEM_REC
138: (
139: aSqlItem BOM_BO_PUB_BOM_PRDMEM_REC_TYPE)
140: RETURN BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE;
141: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE
142: FUNCTION PL_TO_SQL_PROD_MEM_TBL
143: (

Line 140: RETURN BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE;

136: RETURN BOM_BO_PUB_BOM_PRDMEM_REC_TYPE;
137: FUNCTION SQL_TO_PL_PROD_MEM_REC
138: (
139: aSqlItem BOM_BO_PUB_BOM_PRDMEM_REC_TYPE)
140: RETURN BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE;
141: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE
142: FUNCTION PL_TO_SQL_PROD_MEM_TBL
143: (
144: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE)

Line 141: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE

137: FUNCTION SQL_TO_PL_PROD_MEM_REC
138: (
139: aSqlItem BOM_BO_PUB_BOM_PRDMEM_REC_TYPE)
140: RETURN BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE;
141: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE
142: FUNCTION PL_TO_SQL_PROD_MEM_TBL
143: (
144: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE)
145: RETURN BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE;

Line 144: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE)

140: RETURN BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE;
141: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE
142: FUNCTION PL_TO_SQL_PROD_MEM_TBL
143: (
144: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE)
145: RETURN BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE;
146: FUNCTION SQL_TO_PL_PROD_MEM_TBL
147: (
148: aSqlItem BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE)

Line 145: RETURN BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE;

141: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE
142: FUNCTION PL_TO_SQL_PROD_MEM_TBL
143: (
144: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE)
145: RETURN BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE;
146: FUNCTION SQL_TO_PL_PROD_MEM_TBL
147: (
148: aSqlItem BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE)
149: RETURN BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE;

Line 148: aSqlItem BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE)

144: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE)
145: RETURN BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE;
146: FUNCTION SQL_TO_PL_PROD_MEM_TBL
147: (
148: aSqlItem BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE)
149: RETURN BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE;
150: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_HEADER_TBL_TYPE
151: FUNCTION PL_TO_SQL_HEADER_TBL
152: (

Line 149: RETURN BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE;

145: RETURN BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE;
146: FUNCTION SQL_TO_PL_PROD_MEM_TBL
147: (
148: aSqlItem BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE)
149: RETURN BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE;
150: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_HEADER_TBL_TYPE
151: FUNCTION PL_TO_SQL_HEADER_TBL
152: (
153: aPlsqlItem BOM_BO_PUB.BOM_HEADER_TBL_TYPE)

Line 150: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_HEADER_TBL_TYPE

146: FUNCTION SQL_TO_PL_PROD_MEM_TBL
147: (
148: aSqlItem BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE)
149: RETURN BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE;
150: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_HEADER_TBL_TYPE
151: FUNCTION PL_TO_SQL_HEADER_TBL
152: (
153: aPlsqlItem BOM_BO_PUB.BOM_HEADER_TBL_TYPE)
154: RETURN BOM_BO_PUB_BOM_HEADER_TBL_TYPE;

Line 153: aPlsqlItem BOM_BO_PUB.BOM_HEADER_TBL_TYPE)

149: RETURN BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE;
150: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_HEADER_TBL_TYPE
151: FUNCTION PL_TO_SQL_HEADER_TBL
152: (
153: aPlsqlItem BOM_BO_PUB.BOM_HEADER_TBL_TYPE)
154: RETURN BOM_BO_PUB_BOM_HEADER_TBL_TYPE;
155: FUNCTION SQL_TO_PL_HEADER_TBL
156: (
157: aSqlItem BOM_BO_PUB_BOM_HEADER_TBL_TYPE)

Line 154: RETURN BOM_BO_PUB_BOM_HEADER_TBL_TYPE;

150: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_HEADER_TBL_TYPE
151: FUNCTION PL_TO_SQL_HEADER_TBL
152: (
153: aPlsqlItem BOM_BO_PUB.BOM_HEADER_TBL_TYPE)
154: RETURN BOM_BO_PUB_BOM_HEADER_TBL_TYPE;
155: FUNCTION SQL_TO_PL_HEADER_TBL
156: (
157: aSqlItem BOM_BO_PUB_BOM_HEADER_TBL_TYPE)
158: RETURN BOM_BO_PUB.BOM_HEADER_TBL_TYPE;

Line 157: aSqlItem BOM_BO_PUB_BOM_HEADER_TBL_TYPE)

153: aPlsqlItem BOM_BO_PUB.BOM_HEADER_TBL_TYPE)
154: RETURN BOM_BO_PUB_BOM_HEADER_TBL_TYPE;
155: FUNCTION SQL_TO_PL_HEADER_TBL
156: (
157: aSqlItem BOM_BO_PUB_BOM_HEADER_TBL_TYPE)
158: RETURN BOM_BO_PUB.BOM_HEADER_TBL_TYPE;
159: PROCEDURE BOM_BO_PUB$PROCESS_BOM
160: (
161: P_BO_IDENTIFIER VARCHAR2,

Line 158: RETURN BOM_BO_PUB.BOM_HEADER_TBL_TYPE;

154: RETURN BOM_BO_PUB_BOM_HEADER_TBL_TYPE;
155: FUNCTION SQL_TO_PL_HEADER_TBL
156: (
157: aSqlItem BOM_BO_PUB_BOM_HEADER_TBL_TYPE)
158: RETURN BOM_BO_PUB.BOM_HEADER_TBL_TYPE;
159: PROCEDURE BOM_BO_PUB$PROCESS_BOM
160: (
161: P_BO_IDENTIFIER VARCHAR2,
162: P_API_VERSION_NUMBER NUMBER,

Line 159: PROCEDURE BOM_BO_PUB$PROCESS_BOM

155: FUNCTION SQL_TO_PL_HEADER_TBL
156: (
157: aSqlItem BOM_BO_PUB_BOM_HEADER_TBL_TYPE)
158: RETURN BOM_BO_PUB.BOM_HEADER_TBL_TYPE;
159: PROCEDURE BOM_BO_PUB$PROCESS_BOM
160: (
161: P_BO_IDENTIFIER VARCHAR2,
162: P_API_VERSION_NUMBER NUMBER,
163: P_INIT_MSG_LIST INTEGER,

Line 164: P_BOM_HEADER_TBL BOM_BO_PUB_BOM_HEADER_TBL_TYPE,

160: (
161: P_BO_IDENTIFIER VARCHAR2,
162: P_API_VERSION_NUMBER NUMBER,
163: P_INIT_MSG_LIST INTEGER,
164: P_BOM_HEADER_TBL BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
165: P_BOM_REVISION_TBL BOM_BO_PUB_BOM_REV_TBL_TYPE,
166: P_BOM_COMPONENT_TBL BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
167: P_BOM_REF_DESIGNATOR_TBL BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
168: P_BOM_SUB_COMPONENT_TBL BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,

Line 165: P_BOM_REVISION_TBL BOM_BO_PUB_BOM_REV_TBL_TYPE,

161: P_BO_IDENTIFIER VARCHAR2,
162: P_API_VERSION_NUMBER NUMBER,
163: P_INIT_MSG_LIST INTEGER,
164: P_BOM_HEADER_TBL BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
165: P_BOM_REVISION_TBL BOM_BO_PUB_BOM_REV_TBL_TYPE,
166: P_BOM_COMPONENT_TBL BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
167: P_BOM_REF_DESIGNATOR_TBL BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
168: P_BOM_SUB_COMPONENT_TBL BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
169: P_BOM_COMP_OPS_TBL BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,

Line 166: P_BOM_COMPONENT_TBL BOM_BO_PUB_BOM_COMPS_TBL_TYPE,

162: P_API_VERSION_NUMBER NUMBER,
163: P_INIT_MSG_LIST INTEGER,
164: P_BOM_HEADER_TBL BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
165: P_BOM_REVISION_TBL BOM_BO_PUB_BOM_REV_TBL_TYPE,
166: P_BOM_COMPONENT_TBL BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
167: P_BOM_REF_DESIGNATOR_TBL BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
168: P_BOM_SUB_COMPONENT_TBL BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
169: P_BOM_COMP_OPS_TBL BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
170: X_BOM_HEADER_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_HEADER_TBL_TYPE,

Line 167: P_BOM_REF_DESIGNATOR_TBL BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,

163: P_INIT_MSG_LIST INTEGER,
164: P_BOM_HEADER_TBL BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
165: P_BOM_REVISION_TBL BOM_BO_PUB_BOM_REV_TBL_TYPE,
166: P_BOM_COMPONENT_TBL BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
167: P_BOM_REF_DESIGNATOR_TBL BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
168: P_BOM_SUB_COMPONENT_TBL BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
169: P_BOM_COMP_OPS_TBL BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
170: X_BOM_HEADER_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
171: X_BOM_REVISION_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_REV_TBL_TYPE,

Line 168: P_BOM_SUB_COMPONENT_TBL BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,

164: P_BOM_HEADER_TBL BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
165: P_BOM_REVISION_TBL BOM_BO_PUB_BOM_REV_TBL_TYPE,
166: P_BOM_COMPONENT_TBL BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
167: P_BOM_REF_DESIGNATOR_TBL BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
168: P_BOM_SUB_COMPONENT_TBL BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
169: P_BOM_COMP_OPS_TBL BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
170: X_BOM_HEADER_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
171: X_BOM_REVISION_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_REV_TBL_TYPE,
172: X_BOM_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPS_TBL_TYPE,

Line 169: P_BOM_COMP_OPS_TBL BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,

165: P_BOM_REVISION_TBL BOM_BO_PUB_BOM_REV_TBL_TYPE,
166: P_BOM_COMPONENT_TBL BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
167: P_BOM_REF_DESIGNATOR_TBL BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
168: P_BOM_SUB_COMPONENT_TBL BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
169: P_BOM_COMP_OPS_TBL BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
170: X_BOM_HEADER_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
171: X_BOM_REVISION_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_REV_TBL_TYPE,
172: X_BOM_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
173: X_BOM_REF_DESIGNATOR_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,

Line 170: X_BOM_HEADER_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_HEADER_TBL_TYPE,

166: P_BOM_COMPONENT_TBL BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
167: P_BOM_REF_DESIGNATOR_TBL BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
168: P_BOM_SUB_COMPONENT_TBL BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
169: P_BOM_COMP_OPS_TBL BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
170: X_BOM_HEADER_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
171: X_BOM_REVISION_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_REV_TBL_TYPE,
172: X_BOM_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
173: X_BOM_REF_DESIGNATOR_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
174: X_BOM_SUB_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,

Line 171: X_BOM_REVISION_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_REV_TBL_TYPE,

167: P_BOM_REF_DESIGNATOR_TBL BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
168: P_BOM_SUB_COMPONENT_TBL BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
169: P_BOM_COMP_OPS_TBL BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
170: X_BOM_HEADER_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
171: X_BOM_REVISION_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_REV_TBL_TYPE,
172: X_BOM_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
173: X_BOM_REF_DESIGNATOR_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
174: X_BOM_SUB_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
175: X_BOM_COMP_OPS_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,

Line 172: X_BOM_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPS_TBL_TYPE,

168: P_BOM_SUB_COMPONENT_TBL BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
169: P_BOM_COMP_OPS_TBL BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
170: X_BOM_HEADER_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
171: X_BOM_REVISION_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_REV_TBL_TYPE,
172: X_BOM_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
173: X_BOM_REF_DESIGNATOR_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
174: X_BOM_SUB_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
175: X_BOM_COMP_OPS_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
176: X_RETURN_STATUS IN OUT NOCOPY VARCHAR2,

Line 173: X_BOM_REF_DESIGNATOR_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,

169: P_BOM_COMP_OPS_TBL BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
170: X_BOM_HEADER_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
171: X_BOM_REVISION_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_REV_TBL_TYPE,
172: X_BOM_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
173: X_BOM_REF_DESIGNATOR_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
174: X_BOM_SUB_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
175: X_BOM_COMP_OPS_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
176: X_RETURN_STATUS IN OUT NOCOPY VARCHAR2,
177: X_MSG_COUNT IN OUT NOCOPY NUMBER,

Line 174: X_BOM_SUB_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,

170: X_BOM_HEADER_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
171: X_BOM_REVISION_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_REV_TBL_TYPE,
172: X_BOM_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
173: X_BOM_REF_DESIGNATOR_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
174: X_BOM_SUB_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
175: X_BOM_COMP_OPS_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
176: X_RETURN_STATUS IN OUT NOCOPY VARCHAR2,
177: X_MSG_COUNT IN OUT NOCOPY NUMBER,
178: X_ERROR_MESSAGE IN OUT NOCOPY VARCHAR2,

Line 175: X_BOM_COMP_OPS_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,

171: X_BOM_REVISION_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_REV_TBL_TYPE,
172: X_BOM_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
173: X_BOM_REF_DESIGNATOR_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
174: X_BOM_SUB_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
175: X_BOM_COMP_OPS_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
176: X_RETURN_STATUS IN OUT NOCOPY VARCHAR2,
177: X_MSG_COUNT IN OUT NOCOPY NUMBER,
178: X_ERROR_MESSAGE IN OUT NOCOPY VARCHAR2,
179: P_DEBUG VARCHAR2,