1: PACKAGE BODY XX_BPEL_CALLPROCESSORDEREBS11I AS
2: /* $Header: OEXCGNIB.pls 120.3 2008/03/20 07:54:34 sahvivek noship $ */
3:
4: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE)
5: RETURN OE_ORDER_PUB_HEADER_REC_TYPE IS
6: aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE;
7: BEGIN
8: aSqlItem := oe_inbound_int.PL_TO_SQL1(aPlsqlItem);
1: PACKAGE BODY XX_BPEL_CALLPROCESSORDEREBS11I AS
2: /* $Header: OEXCGNIB.pls 120.3 2008/03/20 07:54:34 sahvivek noship $ */
3:
4: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE)
5: RETURN OE_ORDER_PUB_HEADER_REC_TYPE IS
6: aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE;
7: BEGIN
8: aSqlItem := oe_inbound_int.PL_TO_SQL1(aPlsqlItem);
9: RETURN aSqlItem;
2: /* $Header: OEXCGNIB.pls 120.3 2008/03/20 07:54:34 sahvivek noship $ */
3:
4: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE)
5: RETURN OE_ORDER_PUB_HEADER_REC_TYPE IS
6: aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE;
7: BEGIN
8: aSqlItem := oe_inbound_int.PL_TO_SQL1(aPlsqlItem);
9: RETURN aSqlItem;
10: END PL_TO_SQL1;
8: aSqlItem := oe_inbound_int.PL_TO_SQL1(aPlsqlItem);
9: RETURN aSqlItem;
10: END PL_TO_SQL1;
11:
12: FUNCTION SQL_TO_PL1(aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE)
13: RETURN OE_ORDER_PUB.HEADER_REC_TYPE IS
14: aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE;
15: BEGIN
16: aPlsqlItem := oe_inbound_int.SQL_TO_PL1(aSqlItem);
9: RETURN aSqlItem;
10: END PL_TO_SQL1;
11:
12: FUNCTION SQL_TO_PL1(aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE)
13: RETURN OE_ORDER_PUB.HEADER_REC_TYPE IS
14: aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE;
15: BEGIN
16: aPlsqlItem := oe_inbound_int.SQL_TO_PL1(aSqlItem);
17: RETURN aPlsqlItem;
10: END PL_TO_SQL1;
11:
12: FUNCTION SQL_TO_PL1(aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE)
13: RETURN OE_ORDER_PUB.HEADER_REC_TYPE IS
14: aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE;
15: BEGIN
16: aPlsqlItem := oe_inbound_int.SQL_TO_PL1(aSqlItem);
17: RETURN aPlsqlItem;
18: END SQL_TO_PL1;
16: aPlsqlItem := oe_inbound_int.SQL_TO_PL1(aSqlItem);
17: RETURN aPlsqlItem;
18: END SQL_TO_PL1;
19:
20: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE)
21: RETURN OE_ORDER_PUB_HEADER_VAL_REC_T IS
22: aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T;
23: BEGIN
24: aSqlItem := oe_inbound_int.PL_TO_SQL2(aPlsqlItem);
17: RETURN aPlsqlItem;
18: END SQL_TO_PL1;
19:
20: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE)
21: RETURN OE_ORDER_PUB_HEADER_VAL_REC_T IS
22: aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T;
23: BEGIN
24: aSqlItem := oe_inbound_int.PL_TO_SQL2(aPlsqlItem);
25: RETURN aSqlItem;
18: END SQL_TO_PL1;
19:
20: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE)
21: RETURN OE_ORDER_PUB_HEADER_VAL_REC_T IS
22: aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T;
23: BEGIN
24: aSqlItem := oe_inbound_int.PL_TO_SQL2(aPlsqlItem);
25: RETURN aSqlItem;
26: END PL_TO_SQL2;
24: aSqlItem := oe_inbound_int.PL_TO_SQL2(aPlsqlItem);
25: RETURN aSqlItem;
26: END PL_TO_SQL2;
27:
28: FUNCTION SQL_TO_PL2(aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T)
29: RETURN OE_ORDER_PUB.HEADER_VAL_REC_TYPE IS
30: aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
31: BEGIN
32: aPlsqlItem := oe_inbound_int.SQL_TO_PL2(aSqlItem);
25: RETURN aSqlItem;
26: END PL_TO_SQL2;
27:
28: FUNCTION SQL_TO_PL2(aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T)
29: RETURN OE_ORDER_PUB.HEADER_VAL_REC_TYPE IS
30: aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
31: BEGIN
32: aPlsqlItem := oe_inbound_int.SQL_TO_PL2(aSqlItem);
33: RETURN aPlsqlItem;
26: END PL_TO_SQL2;
27:
28: FUNCTION SQL_TO_PL2(aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T)
29: RETURN OE_ORDER_PUB.HEADER_VAL_REC_TYPE IS
30: aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
31: BEGIN
32: aPlsqlItem := oe_inbound_int.SQL_TO_PL2(aSqlItem);
33: RETURN aPlsqlItem;
34: END SQL_TO_PL2;
32: aPlsqlItem := oe_inbound_int.SQL_TO_PL2(aSqlItem);
33: RETURN aPlsqlItem;
34: END SQL_TO_PL2;
35:
36: FUNCTION PL_TO_SQL26(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_REC_TYPE)
37: RETURN OE_ORDER_PUB_HEADER_ADJ_REC_T IS
38: aSqlItem OE_ORDER_PUB_HEADER_ADJ_REC_T;
39: BEGIN
40: aSqlItem := oe_inbound_int.PL_TO_SQL26(aPlsqlItem);
33: RETURN aPlsqlItem;
34: END SQL_TO_PL2;
35:
36: FUNCTION PL_TO_SQL26(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_REC_TYPE)
37: RETURN OE_ORDER_PUB_HEADER_ADJ_REC_T IS
38: aSqlItem OE_ORDER_PUB_HEADER_ADJ_REC_T;
39: BEGIN
40: aSqlItem := oe_inbound_int.PL_TO_SQL26(aPlsqlItem);
41: RETURN aSqlItem;
34: END SQL_TO_PL2;
35:
36: FUNCTION PL_TO_SQL26(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_REC_TYPE)
37: RETURN OE_ORDER_PUB_HEADER_ADJ_REC_T IS
38: aSqlItem OE_ORDER_PUB_HEADER_ADJ_REC_T;
39: BEGIN
40: aSqlItem := oe_inbound_int.PL_TO_SQL26(aPlsqlItem);
41: RETURN aSqlItem;
42: END PL_TO_SQL26;
40: aSqlItem := oe_inbound_int.PL_TO_SQL26(aPlsqlItem);
41: RETURN aSqlItem;
42: END PL_TO_SQL26;
43:
44: FUNCTION SQL_TO_PL26(aSqlItem OE_ORDER_PUB_HEADER_ADJ_REC_T)
45: RETURN OE_ORDER_PUB.HEADER_ADJ_REC_TYPE IS
46: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_REC_TYPE;
47: BEGIN
48: aPlsqlItem := oe_inbound_int.SQL_TO_PL26(aSqlItem);
41: RETURN aSqlItem;
42: END PL_TO_SQL26;
43:
44: FUNCTION SQL_TO_PL26(aSqlItem OE_ORDER_PUB_HEADER_ADJ_REC_T)
45: RETURN OE_ORDER_PUB.HEADER_ADJ_REC_TYPE IS
46: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_REC_TYPE;
47: BEGIN
48: aPlsqlItem := oe_inbound_int.SQL_TO_PL26(aSqlItem);
49: RETURN aPlsqlItem;
42: END PL_TO_SQL26;
43:
44: FUNCTION SQL_TO_PL26(aSqlItem OE_ORDER_PUB_HEADER_ADJ_REC_T)
45: RETURN OE_ORDER_PUB.HEADER_ADJ_REC_TYPE IS
46: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_REC_TYPE;
47: BEGIN
48: aPlsqlItem := oe_inbound_int.SQL_TO_PL26(aSqlItem);
49: RETURN aPlsqlItem;
50: END SQL_TO_PL26;
48: aPlsqlItem := oe_inbound_int.SQL_TO_PL26(aSqlItem);
49: RETURN aPlsqlItem;
50: END SQL_TO_PL26;
51:
52: FUNCTION PL_TO_SQL3(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE)
53: RETURN OE_ORDER_PUB_HEADER_ADJ_TBL_T IS
54: aSqlItem OE_ORDER_PUB_HEADER_ADJ_TBL_T;
55: BEGIN
56: aSqlItem := oe_inbound_int.PL_TO_SQL3(aPlsqlItem);
49: RETURN aPlsqlItem;
50: END SQL_TO_PL26;
51:
52: FUNCTION PL_TO_SQL3(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE)
53: RETURN OE_ORDER_PUB_HEADER_ADJ_TBL_T IS
54: aSqlItem OE_ORDER_PUB_HEADER_ADJ_TBL_T;
55: BEGIN
56: aSqlItem := oe_inbound_int.PL_TO_SQL3(aPlsqlItem);
57: RETURN aSqlItem;
50: END SQL_TO_PL26;
51:
52: FUNCTION PL_TO_SQL3(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE)
53: RETURN OE_ORDER_PUB_HEADER_ADJ_TBL_T IS
54: aSqlItem OE_ORDER_PUB_HEADER_ADJ_TBL_T;
55: BEGIN
56: aSqlItem := oe_inbound_int.PL_TO_SQL3(aPlsqlItem);
57: RETURN aSqlItem;
58: END PL_TO_SQL3;
56: aSqlItem := oe_inbound_int.PL_TO_SQL3(aPlsqlItem);
57: RETURN aSqlItem;
58: END PL_TO_SQL3;
59:
60: FUNCTION SQL_TO_PL3(aSqlItem OE_ORDER_PUB_HEADER_ADJ_TBL_T)
61: RETURN OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE IS
62: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;
63: BEGIN
64: aPlsqlItem := oe_inbound_int.SQL_TO_PL3(aSqlItem);
57: RETURN aSqlItem;
58: END PL_TO_SQL3;
59:
60: FUNCTION SQL_TO_PL3(aSqlItem OE_ORDER_PUB_HEADER_ADJ_TBL_T)
61: RETURN OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE IS
62: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;
63: BEGIN
64: aPlsqlItem := oe_inbound_int.SQL_TO_PL3(aSqlItem);
65: RETURN aPlsqlItem;
58: END PL_TO_SQL3;
59:
60: FUNCTION SQL_TO_PL3(aSqlItem OE_ORDER_PUB_HEADER_ADJ_TBL_T)
61: RETURN OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE IS
62: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;
63: BEGIN
64: aPlsqlItem := oe_inbound_int.SQL_TO_PL3(aSqlItem);
65: RETURN aPlsqlItem;
66: END SQL_TO_PL3;
64: aPlsqlItem := oe_inbound_int.SQL_TO_PL3(aSqlItem);
65: RETURN aPlsqlItem;
66: END SQL_TO_PL3;
67:
68: FUNCTION PL_TO_SQL27(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_REC_TYPE)
69: RETURN OE_ORDER_PUB_HEADER_ADJ_VAL_R IS
70: aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_R;
71: BEGIN
72: aSqlItem := oe_inbound_int.PL_TO_SQL27(aPlsqlItem);
65: RETURN aPlsqlItem;
66: END SQL_TO_PL3;
67:
68: FUNCTION PL_TO_SQL27(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_REC_TYPE)
69: RETURN OE_ORDER_PUB_HEADER_ADJ_VAL_R IS
70: aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_R;
71: BEGIN
72: aSqlItem := oe_inbound_int.PL_TO_SQL27(aPlsqlItem);
73: RETURN aSqlItem;
66: END SQL_TO_PL3;
67:
68: FUNCTION PL_TO_SQL27(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_REC_TYPE)
69: RETURN OE_ORDER_PUB_HEADER_ADJ_VAL_R IS
70: aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_R;
71: BEGIN
72: aSqlItem := oe_inbound_int.PL_TO_SQL27(aPlsqlItem);
73: RETURN aSqlItem;
74: END PL_TO_SQL27;
72: aSqlItem := oe_inbound_int.PL_TO_SQL27(aPlsqlItem);
73: RETURN aSqlItem;
74: END PL_TO_SQL27;
75:
76: FUNCTION SQL_TO_PL27(aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_R)
77: RETURN OE_ORDER_PUB.HEADER_ADJ_VAL_REC_TYPE IS
78: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_REC_TYPE;
79: BEGIN
80: aPlsqlItem := oe_inbound_int.SQL_TO_PL27(aSqlItem);
73: RETURN aSqlItem;
74: END PL_TO_SQL27;
75:
76: FUNCTION SQL_TO_PL27(aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_R)
77: RETURN OE_ORDER_PUB.HEADER_ADJ_VAL_REC_TYPE IS
78: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_REC_TYPE;
79: BEGIN
80: aPlsqlItem := oe_inbound_int.SQL_TO_PL27(aSqlItem);
81: RETURN aPlsqlItem;
74: END PL_TO_SQL27;
75:
76: FUNCTION SQL_TO_PL27(aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_R)
77: RETURN OE_ORDER_PUB.HEADER_ADJ_VAL_REC_TYPE IS
78: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_REC_TYPE;
79: BEGIN
80: aPlsqlItem := oe_inbound_int.SQL_TO_PL27(aSqlItem);
81: RETURN aPlsqlItem;
82: END SQL_TO_PL27;
80: aPlsqlItem := oe_inbound_int.SQL_TO_PL27(aSqlItem);
81: RETURN aPlsqlItem;
82: END SQL_TO_PL27;
83:
84: FUNCTION PL_TO_SQL4(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE)
85: RETURN OE_ORDER_PUB_HEADER_ADJ_VAL_T IS
86: aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_T;
87: BEGIN
88: aSqlItem := oe_inbound_int.PL_TO_SQL4(aPlsqlItem);
81: RETURN aPlsqlItem;
82: END SQL_TO_PL27;
83:
84: FUNCTION PL_TO_SQL4(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE)
85: RETURN OE_ORDER_PUB_HEADER_ADJ_VAL_T IS
86: aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_T;
87: BEGIN
88: aSqlItem := oe_inbound_int.PL_TO_SQL4(aPlsqlItem);
89: RETURN aSqlItem;
82: END SQL_TO_PL27;
83:
84: FUNCTION PL_TO_SQL4(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE)
85: RETURN OE_ORDER_PUB_HEADER_ADJ_VAL_T IS
86: aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_T;
87: BEGIN
88: aSqlItem := oe_inbound_int.PL_TO_SQL4(aPlsqlItem);
89: RETURN aSqlItem;
90: END PL_TO_SQL4;
88: aSqlItem := oe_inbound_int.PL_TO_SQL4(aPlsqlItem);
89: RETURN aSqlItem;
90: END PL_TO_SQL4;
91:
92: FUNCTION SQL_TO_PL4(aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_T)
93: RETURN OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE IS
94: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;
95: BEGIN
96: aPlsqlItem := oe_inbound_int.SQL_TO_PL4(aSqlItem);
89: RETURN aSqlItem;
90: END PL_TO_SQL4;
91:
92: FUNCTION SQL_TO_PL4(aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_T)
93: RETURN OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE IS
94: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;
95: BEGIN
96: aPlsqlItem := oe_inbound_int.SQL_TO_PL4(aSqlItem);
97: RETURN aPlsqlItem;
90: END PL_TO_SQL4;
91:
92: FUNCTION SQL_TO_PL4(aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_T)
93: RETURN OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE IS
94: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;
95: BEGIN
96: aPlsqlItem := oe_inbound_int.SQL_TO_PL4(aSqlItem);
97: RETURN aPlsqlItem;
98: END SQL_TO_PL4;
96: aPlsqlItem := oe_inbound_int.SQL_TO_PL4(aSqlItem);
97: RETURN aPlsqlItem;
98: END SQL_TO_PL4;
99:
100: FUNCTION PL_TO_SQL28(aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_REC_TYPE)
101: RETURN OE_ORDER_PUB_HEADER_PRICE_AT6 IS
102: aSqlItem OE_ORDER_PUB_HEADER_PRICE_AT6;
103: BEGIN
104: aSqlItem := oe_inbound_int.PL_TO_SQL28(aPlsqlItem);
97: RETURN aPlsqlItem;
98: END SQL_TO_PL4;
99:
100: FUNCTION PL_TO_SQL28(aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_REC_TYPE)
101: RETURN OE_ORDER_PUB_HEADER_PRICE_AT6 IS
102: aSqlItem OE_ORDER_PUB_HEADER_PRICE_AT6;
103: BEGIN
104: aSqlItem := oe_inbound_int.PL_TO_SQL28(aPlsqlItem);
105: RETURN aSqlItem;
98: END SQL_TO_PL4;
99:
100: FUNCTION PL_TO_SQL28(aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_REC_TYPE)
101: RETURN OE_ORDER_PUB_HEADER_PRICE_AT6 IS
102: aSqlItem OE_ORDER_PUB_HEADER_PRICE_AT6;
103: BEGIN
104: aSqlItem := oe_inbound_int.PL_TO_SQL28(aPlsqlItem);
105: RETURN aSqlItem;
106: END PL_TO_SQL28;
104: aSqlItem := oe_inbound_int.PL_TO_SQL28(aPlsqlItem);
105: RETURN aSqlItem;
106: END PL_TO_SQL28;
107:
108: FUNCTION SQL_TO_PL28(aSqlItem OE_ORDER_PUB_HEADER_PRICE_AT6)
109: RETURN OE_ORDER_PUB.HEADER_PRICE_ATT_REC_TYPE IS
110: aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_REC_TYPE;
111: BEGIN
112: aPlsqlItem := oe_inbound_int.SQL_TO_PL28(aSqlItem);
105: RETURN aSqlItem;
106: END PL_TO_SQL28;
107:
108: FUNCTION SQL_TO_PL28(aSqlItem OE_ORDER_PUB_HEADER_PRICE_AT6)
109: RETURN OE_ORDER_PUB.HEADER_PRICE_ATT_REC_TYPE IS
110: aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_REC_TYPE;
111: BEGIN
112: aPlsqlItem := oe_inbound_int.SQL_TO_PL28(aSqlItem);
113: RETURN aPlsqlItem;
106: END PL_TO_SQL28;
107:
108: FUNCTION SQL_TO_PL28(aSqlItem OE_ORDER_PUB_HEADER_PRICE_AT6)
109: RETURN OE_ORDER_PUB.HEADER_PRICE_ATT_REC_TYPE IS
110: aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_REC_TYPE;
111: BEGIN
112: aPlsqlItem := oe_inbound_int.SQL_TO_PL28(aSqlItem);
113: RETURN aPlsqlItem;
114: END SQL_TO_PL28;
112: aPlsqlItem := oe_inbound_int.SQL_TO_PL28(aSqlItem);
113: RETURN aPlsqlItem;
114: END SQL_TO_PL28;
115:
116: FUNCTION PL_TO_SQL5(aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE)
117: RETURN OE_ORDER_PUB_HEADER_PRICE_ATT IS
118: aSqlItem OE_ORDER_PUB_HEADER_PRICE_ATT;
119: BEGIN
120: aSqlItem := oe_inbound_int.PL_TO_SQL5(aPlsqlItem);
113: RETURN aPlsqlItem;
114: END SQL_TO_PL28;
115:
116: FUNCTION PL_TO_SQL5(aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE)
117: RETURN OE_ORDER_PUB_HEADER_PRICE_ATT IS
118: aSqlItem OE_ORDER_PUB_HEADER_PRICE_ATT;
119: BEGIN
120: aSqlItem := oe_inbound_int.PL_TO_SQL5(aPlsqlItem);
121: RETURN aSqlItem;
114: END SQL_TO_PL28;
115:
116: FUNCTION PL_TO_SQL5(aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE)
117: RETURN OE_ORDER_PUB_HEADER_PRICE_ATT IS
118: aSqlItem OE_ORDER_PUB_HEADER_PRICE_ATT;
119: BEGIN
120: aSqlItem := oe_inbound_int.PL_TO_SQL5(aPlsqlItem);
121: RETURN aSqlItem;
122: END PL_TO_SQL5;
120: aSqlItem := oe_inbound_int.PL_TO_SQL5(aPlsqlItem);
121: RETURN aSqlItem;
122: END PL_TO_SQL5;
123:
124: FUNCTION SQL_TO_PL5(aSqlItem OE_ORDER_PUB_HEADER_PRICE_ATT)
125: RETURN OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE IS
126: aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE;
127: BEGIN
128: aPlsqlItem := oe_inbound_int.SQL_TO_PL5(aSqlItem);
121: RETURN aSqlItem;
122: END PL_TO_SQL5;
123:
124: FUNCTION SQL_TO_PL5(aSqlItem OE_ORDER_PUB_HEADER_PRICE_ATT)
125: RETURN OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE IS
126: aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE;
127: BEGIN
128: aPlsqlItem := oe_inbound_int.SQL_TO_PL5(aSqlItem);
129: RETURN aPlsqlItem;
122: END PL_TO_SQL5;
123:
124: FUNCTION SQL_TO_PL5(aSqlItem OE_ORDER_PUB_HEADER_PRICE_ATT)
125: RETURN OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE IS
126: aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE;
127: BEGIN
128: aPlsqlItem := oe_inbound_int.SQL_TO_PL5(aSqlItem);
129: RETURN aPlsqlItem;
130: END SQL_TO_PL5;
128: aPlsqlItem := oe_inbound_int.SQL_TO_PL5(aSqlItem);
129: RETURN aPlsqlItem;
130: END SQL_TO_PL5;
131:
132: FUNCTION PL_TO_SQL29(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ATT_REC_TYPE)
133: RETURN OE_ORDER_PUB_HEADER_ADJ_ATT_R IS
134: aSqlItem OE_ORDER_PUB_HEADER_ADJ_ATT_R;
135: BEGIN
136: aSqlItem := oe_inbound_int.PL_TO_SQL29(aPlsqlItem);
129: RETURN aPlsqlItem;
130: END SQL_TO_PL5;
131:
132: FUNCTION PL_TO_SQL29(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ATT_REC_TYPE)
133: RETURN OE_ORDER_PUB_HEADER_ADJ_ATT_R IS
134: aSqlItem OE_ORDER_PUB_HEADER_ADJ_ATT_R;
135: BEGIN
136: aSqlItem := oe_inbound_int.PL_TO_SQL29(aPlsqlItem);
137: RETURN aSqlItem;
130: END SQL_TO_PL5;
131:
132: FUNCTION PL_TO_SQL29(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ATT_REC_TYPE)
133: RETURN OE_ORDER_PUB_HEADER_ADJ_ATT_R IS
134: aSqlItem OE_ORDER_PUB_HEADER_ADJ_ATT_R;
135: BEGIN
136: aSqlItem := oe_inbound_int.PL_TO_SQL29(aPlsqlItem);
137: RETURN aSqlItem;
138: END PL_TO_SQL29;
136: aSqlItem := oe_inbound_int.PL_TO_SQL29(aPlsqlItem);
137: RETURN aSqlItem;
138: END PL_TO_SQL29;
139:
140: FUNCTION SQL_TO_PL29(aSqlItem OE_ORDER_PUB_HEADER_ADJ_ATT_R)
141: RETURN OE_ORDER_PUB.HEADER_ADJ_ATT_REC_TYPE IS
142: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ATT_REC_TYPE;
143: BEGIN
144: aPlsqlItem := oe_inbound_int.SQL_TO_PL29(aSqlItem);
137: RETURN aSqlItem;
138: END PL_TO_SQL29;
139:
140: FUNCTION SQL_TO_PL29(aSqlItem OE_ORDER_PUB_HEADER_ADJ_ATT_R)
141: RETURN OE_ORDER_PUB.HEADER_ADJ_ATT_REC_TYPE IS
142: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ATT_REC_TYPE;
143: BEGIN
144: aPlsqlItem := oe_inbound_int.SQL_TO_PL29(aSqlItem);
145: RETURN aPlsqlItem;
138: END PL_TO_SQL29;
139:
140: FUNCTION SQL_TO_PL29(aSqlItem OE_ORDER_PUB_HEADER_ADJ_ATT_R)
141: RETURN OE_ORDER_PUB.HEADER_ADJ_ATT_REC_TYPE IS
142: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ATT_REC_TYPE;
143: BEGIN
144: aPlsqlItem := oe_inbound_int.SQL_TO_PL29(aSqlItem);
145: RETURN aPlsqlItem;
146: END SQL_TO_PL29;
144: aPlsqlItem := oe_inbound_int.SQL_TO_PL29(aSqlItem);
145: RETURN aPlsqlItem;
146: END SQL_TO_PL29;
147:
148: FUNCTION PL_TO_SQL6(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE)
149: RETURN OE_ORDER_PUB_HEADER_ADJ_ATT_T IS
150: aSqlItem OE_ORDER_PUB_HEADER_ADJ_ATT_T;
151: BEGIN
152: aSqlItem := oe_inbound_int.PL_TO_SQL6(aPlsqlItem);
145: RETURN aPlsqlItem;
146: END SQL_TO_PL29;
147:
148: FUNCTION PL_TO_SQL6(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE)
149: RETURN OE_ORDER_PUB_HEADER_ADJ_ATT_T IS
150: aSqlItem OE_ORDER_PUB_HEADER_ADJ_ATT_T;
151: BEGIN
152: aSqlItem := oe_inbound_int.PL_TO_SQL6(aPlsqlItem);
153: RETURN aSqlItem;
146: END SQL_TO_PL29;
147:
148: FUNCTION PL_TO_SQL6(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE)
149: RETURN OE_ORDER_PUB_HEADER_ADJ_ATT_T IS
150: aSqlItem OE_ORDER_PUB_HEADER_ADJ_ATT_T;
151: BEGIN
152: aSqlItem := oe_inbound_int.PL_TO_SQL6(aPlsqlItem);
153: RETURN aSqlItem;
154: END PL_TO_SQL6;
152: aSqlItem := oe_inbound_int.PL_TO_SQL6(aPlsqlItem);
153: RETURN aSqlItem;
154: END PL_TO_SQL6;
155:
156: FUNCTION SQL_TO_PL6(aSqlItem OE_ORDER_PUB_HEADER_ADJ_ATT_T)
157: RETURN OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE IS
158: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE;
159: BEGIN
160: aPlsqlItem := oe_inbound_int.SQL_TO_PL6(aSqlItem);
153: RETURN aSqlItem;
154: END PL_TO_SQL6;
155:
156: FUNCTION SQL_TO_PL6(aSqlItem OE_ORDER_PUB_HEADER_ADJ_ATT_T)
157: RETURN OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE IS
158: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE;
159: BEGIN
160: aPlsqlItem := oe_inbound_int.SQL_TO_PL6(aSqlItem);
161: RETURN aPlsqlItem;
154: END PL_TO_SQL6;
155:
156: FUNCTION SQL_TO_PL6(aSqlItem OE_ORDER_PUB_HEADER_ADJ_ATT_T)
157: RETURN OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE IS
158: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE;
159: BEGIN
160: aPlsqlItem := oe_inbound_int.SQL_TO_PL6(aSqlItem);
161: RETURN aPlsqlItem;
162: END SQL_TO_PL6;
160: aPlsqlItem := oe_inbound_int.SQL_TO_PL6(aSqlItem);
161: RETURN aPlsqlItem;
162: END SQL_TO_PL6;
163:
164: FUNCTION PL_TO_SQL30(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ASSOC_REC_TYPE)
165: RETURN OE_ORDER_PUB_HEADER_ADJ_ASSO6 IS
166: aSqlItem OE_ORDER_PUB_HEADER_ADJ_ASSO6;
167: BEGIN
168: aSqlItem := oe_inbound_int.PL_TO_SQL30(aPlsqlItem);
161: RETURN aPlsqlItem;
162: END SQL_TO_PL6;
163:
164: FUNCTION PL_TO_SQL30(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ASSOC_REC_TYPE)
165: RETURN OE_ORDER_PUB_HEADER_ADJ_ASSO6 IS
166: aSqlItem OE_ORDER_PUB_HEADER_ADJ_ASSO6;
167: BEGIN
168: aSqlItem := oe_inbound_int.PL_TO_SQL30(aPlsqlItem);
169: RETURN aSqlItem;
162: END SQL_TO_PL6;
163:
164: FUNCTION PL_TO_SQL30(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ASSOC_REC_TYPE)
165: RETURN OE_ORDER_PUB_HEADER_ADJ_ASSO6 IS
166: aSqlItem OE_ORDER_PUB_HEADER_ADJ_ASSO6;
167: BEGIN
168: aSqlItem := oe_inbound_int.PL_TO_SQL30(aPlsqlItem);
169: RETURN aSqlItem;
170: END PL_TO_SQL30;
168: aSqlItem := oe_inbound_int.PL_TO_SQL30(aPlsqlItem);
169: RETURN aSqlItem;
170: END PL_TO_SQL30;
171:
172: FUNCTION SQL_TO_PL30(aSqlItem OE_ORDER_PUB_HEADER_ADJ_ASSO6)
173: RETURN OE_ORDER_PUB.HEADER_ADJ_ASSOC_REC_TYPE IS
174: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ASSOC_REC_TYPE;
175: BEGIN
176: aPlsqlItem := oe_inbound_int.SQL_TO_PL30(aSqlItem);
169: RETURN aSqlItem;
170: END PL_TO_SQL30;
171:
172: FUNCTION SQL_TO_PL30(aSqlItem OE_ORDER_PUB_HEADER_ADJ_ASSO6)
173: RETURN OE_ORDER_PUB.HEADER_ADJ_ASSOC_REC_TYPE IS
174: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ASSOC_REC_TYPE;
175: BEGIN
176: aPlsqlItem := oe_inbound_int.SQL_TO_PL30(aSqlItem);
177: RETURN aPlsqlItem;
170: END PL_TO_SQL30;
171:
172: FUNCTION SQL_TO_PL30(aSqlItem OE_ORDER_PUB_HEADER_ADJ_ASSO6)
173: RETURN OE_ORDER_PUB.HEADER_ADJ_ASSOC_REC_TYPE IS
174: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ASSOC_REC_TYPE;
175: BEGIN
176: aPlsqlItem := oe_inbound_int.SQL_TO_PL30(aSqlItem);
177: RETURN aPlsqlItem;
178: END SQL_TO_PL30;
176: aPlsqlItem := oe_inbound_int.SQL_TO_PL30(aSqlItem);
177: RETURN aPlsqlItem;
178: END SQL_TO_PL30;
179:
180: FUNCTION PL_TO_SQL7(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE)
181: RETURN OE_ORDER_PUB_HEADER_ADJ_ASSOC IS
182: aSqlItem OE_ORDER_PUB_HEADER_ADJ_ASSOC;
183: BEGIN
184: aSqlItem := oe_inbound_int.PL_TO_SQL7(aPlsqlItem);
177: RETURN aPlsqlItem;
178: END SQL_TO_PL30;
179:
180: FUNCTION PL_TO_SQL7(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE)
181: RETURN OE_ORDER_PUB_HEADER_ADJ_ASSOC IS
182: aSqlItem OE_ORDER_PUB_HEADER_ADJ_ASSOC;
183: BEGIN
184: aSqlItem := oe_inbound_int.PL_TO_SQL7(aPlsqlItem);
185: RETURN aSqlItem;
178: END SQL_TO_PL30;
179:
180: FUNCTION PL_TO_SQL7(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE)
181: RETURN OE_ORDER_PUB_HEADER_ADJ_ASSOC IS
182: aSqlItem OE_ORDER_PUB_HEADER_ADJ_ASSOC;
183: BEGIN
184: aSqlItem := oe_inbound_int.PL_TO_SQL7(aPlsqlItem);
185: RETURN aSqlItem;
186: END PL_TO_SQL7;
184: aSqlItem := oe_inbound_int.PL_TO_SQL7(aPlsqlItem);
185: RETURN aSqlItem;
186: END PL_TO_SQL7;
187:
188: FUNCTION SQL_TO_PL7(aSqlItem OE_ORDER_PUB_HEADER_ADJ_ASSOC)
189: RETURN OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE IS
190: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE;
191: BEGIN
192: aPlsqlItem := oe_inbound_int. SQL_TO_PL7(aSqlItem);
185: RETURN aSqlItem;
186: END PL_TO_SQL7;
187:
188: FUNCTION SQL_TO_PL7(aSqlItem OE_ORDER_PUB_HEADER_ADJ_ASSOC)
189: RETURN OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE IS
190: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE;
191: BEGIN
192: aPlsqlItem := oe_inbound_int. SQL_TO_PL7(aSqlItem);
193: RETURN aPlsqlItem;
186: END PL_TO_SQL7;
187:
188: FUNCTION SQL_TO_PL7(aSqlItem OE_ORDER_PUB_HEADER_ADJ_ASSOC)
189: RETURN OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE IS
190: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE;
191: BEGIN
192: aPlsqlItem := oe_inbound_int. SQL_TO_PL7(aSqlItem);
193: RETURN aPlsqlItem;
194: END SQL_TO_PL7;
192: aPlsqlItem := oe_inbound_int. SQL_TO_PL7(aSqlItem);
193: RETURN aPlsqlItem;
194: END SQL_TO_PL7;
195:
196: FUNCTION PL_TO_SQL31(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_REC_TYPE)
197: RETURN OE_ORDER_PUB_HEADER_SCREDIT_R IS
198: aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_R;
199: BEGIN
200: aSqlItem := oe_inbound_int.PL_TO_SQL31(aPlsqlItem);
193: RETURN aPlsqlItem;
194: END SQL_TO_PL7;
195:
196: FUNCTION PL_TO_SQL31(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_REC_TYPE)
197: RETURN OE_ORDER_PUB_HEADER_SCREDIT_R IS
198: aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_R;
199: BEGIN
200: aSqlItem := oe_inbound_int.PL_TO_SQL31(aPlsqlItem);
201: RETURN aSqlItem;
194: END SQL_TO_PL7;
195:
196: FUNCTION PL_TO_SQL31(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_REC_TYPE)
197: RETURN OE_ORDER_PUB_HEADER_SCREDIT_R IS
198: aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_R;
199: BEGIN
200: aSqlItem := oe_inbound_int.PL_TO_SQL31(aPlsqlItem);
201: RETURN aSqlItem;
202: END PL_TO_SQL31;
200: aSqlItem := oe_inbound_int.PL_TO_SQL31(aPlsqlItem);
201: RETURN aSqlItem;
202: END PL_TO_SQL31;
203:
204: FUNCTION SQL_TO_PL31(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_R)
205: RETURN OE_ORDER_PUB.HEADER_SCREDIT_REC_TYPE IS
206: aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_REC_TYPE;
207: BEGIN
208: aPlsqlItem := oe_inbound_int.SQL_TO_PL31(aSqlItem);
201: RETURN aSqlItem;
202: END PL_TO_SQL31;
203:
204: FUNCTION SQL_TO_PL31(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_R)
205: RETURN OE_ORDER_PUB.HEADER_SCREDIT_REC_TYPE IS
206: aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_REC_TYPE;
207: BEGIN
208: aPlsqlItem := oe_inbound_int.SQL_TO_PL31(aSqlItem);
209: RETURN aPlsqlItem;
202: END PL_TO_SQL31;
203:
204: FUNCTION SQL_TO_PL31(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_R)
205: RETURN OE_ORDER_PUB.HEADER_SCREDIT_REC_TYPE IS
206: aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_REC_TYPE;
207: BEGIN
208: aPlsqlItem := oe_inbound_int.SQL_TO_PL31(aSqlItem);
209: RETURN aPlsqlItem;
210: END SQL_TO_PL31;
208: aPlsqlItem := oe_inbound_int.SQL_TO_PL31(aSqlItem);
209: RETURN aPlsqlItem;
210: END SQL_TO_PL31;
211:
212: FUNCTION PL_TO_SQL8(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE)
213: RETURN OE_ORDER_PUB_HEADER_SCREDIT_T IS
214: aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_T;
215: BEGIN
216: aSqlItem := oe_inbound_int.PL_TO_SQL8(aPlsqlItem);
209: RETURN aPlsqlItem;
210: END SQL_TO_PL31;
211:
212: FUNCTION PL_TO_SQL8(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE)
213: RETURN OE_ORDER_PUB_HEADER_SCREDIT_T IS
214: aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_T;
215: BEGIN
216: aSqlItem := oe_inbound_int.PL_TO_SQL8(aPlsqlItem);
217: RETURN aSqlItem;
210: END SQL_TO_PL31;
211:
212: FUNCTION PL_TO_SQL8(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE)
213: RETURN OE_ORDER_PUB_HEADER_SCREDIT_T IS
214: aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_T;
215: BEGIN
216: aSqlItem := oe_inbound_int.PL_TO_SQL8(aPlsqlItem);
217: RETURN aSqlItem;
218: END PL_TO_SQL8;
216: aSqlItem := oe_inbound_int.PL_TO_SQL8(aPlsqlItem);
217: RETURN aSqlItem;
218: END PL_TO_SQL8;
219:
220: FUNCTION SQL_TO_PL8(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_T)
221: RETURN OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE IS
222: aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE;
223: BEGIN
224: aPlsqlItem := oe_inbound_int.SQL_TO_PL8(aSqlItem);
217: RETURN aSqlItem;
218: END PL_TO_SQL8;
219:
220: FUNCTION SQL_TO_PL8(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_T)
221: RETURN OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE IS
222: aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE;
223: BEGIN
224: aPlsqlItem := oe_inbound_int.SQL_TO_PL8(aSqlItem);
225: RETURN aPlsqlItem;
218: END PL_TO_SQL8;
219:
220: FUNCTION SQL_TO_PL8(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_T)
221: RETURN OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE IS
222: aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE;
223: BEGIN
224: aPlsqlItem := oe_inbound_int.SQL_TO_PL8(aSqlItem);
225: RETURN aPlsqlItem;
226: END SQL_TO_PL8;
224: aPlsqlItem := oe_inbound_int.SQL_TO_PL8(aSqlItem);
225: RETURN aPlsqlItem;
226: END SQL_TO_PL8;
227:
228: FUNCTION PL_TO_SQL32(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE)
229: RETURN OE_ORDER_PUB_HEADER_SCREDIT11 IS
230: aSqlItem OE_ORDER_PUB_HEADER_SCREDIT11;
231: BEGIN
232: aSqlItem := oe_inbound_int.PL_TO_SQL32(aPlsqlItem);
225: RETURN aPlsqlItem;
226: END SQL_TO_PL8;
227:
228: FUNCTION PL_TO_SQL32(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE)
229: RETURN OE_ORDER_PUB_HEADER_SCREDIT11 IS
230: aSqlItem OE_ORDER_PUB_HEADER_SCREDIT11;
231: BEGIN
232: aSqlItem := oe_inbound_int.PL_TO_SQL32(aPlsqlItem);
233: RETURN aSqlItem;
226: END SQL_TO_PL8;
227:
228: FUNCTION PL_TO_SQL32(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE)
229: RETURN OE_ORDER_PUB_HEADER_SCREDIT11 IS
230: aSqlItem OE_ORDER_PUB_HEADER_SCREDIT11;
231: BEGIN
232: aSqlItem := oe_inbound_int.PL_TO_SQL32(aPlsqlItem);
233: RETURN aSqlItem;
234: END PL_TO_SQL32;
232: aSqlItem := oe_inbound_int.PL_TO_SQL32(aPlsqlItem);
233: RETURN aSqlItem;
234: END PL_TO_SQL32;
235:
236: FUNCTION SQL_TO_PL32(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT11)
237: RETURN OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE IS
238: aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE;
239: BEGIN
240: aPlsqlItem := oe_inbound_int.SQL_TO_PL32(aSqlItem);
233: RETURN aSqlItem;
234: END PL_TO_SQL32;
235:
236: FUNCTION SQL_TO_PL32(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT11)
237: RETURN OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE IS
238: aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE;
239: BEGIN
240: aPlsqlItem := oe_inbound_int.SQL_TO_PL32(aSqlItem);
241: RETURN aPlsqlItem;
234: END PL_TO_SQL32;
235:
236: FUNCTION SQL_TO_PL32(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT11)
237: RETURN OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE IS
238: aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE;
239: BEGIN
240: aPlsqlItem := oe_inbound_int.SQL_TO_PL32(aSqlItem);
241: RETURN aPlsqlItem;
242: END SQL_TO_PL32;
240: aPlsqlItem := oe_inbound_int.SQL_TO_PL32(aSqlItem);
241: RETURN aPlsqlItem;
242: END SQL_TO_PL32;
243:
244: FUNCTION PL_TO_SQL9(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE)
245: RETURN OE_ORDER_PUB_HEADER_SCREDIT_V IS
246: aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_V;
247: BEGIN
248: aSqlItem := oe_inbound_int.PL_TO_SQL9(aPlsqlItem);
241: RETURN aPlsqlItem;
242: END SQL_TO_PL32;
243:
244: FUNCTION PL_TO_SQL9(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE)
245: RETURN OE_ORDER_PUB_HEADER_SCREDIT_V IS
246: aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_V;
247: BEGIN
248: aSqlItem := oe_inbound_int.PL_TO_SQL9(aPlsqlItem);
249: RETURN aSqlItem;
242: END SQL_TO_PL32;
243:
244: FUNCTION PL_TO_SQL9(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE)
245: RETURN OE_ORDER_PUB_HEADER_SCREDIT_V IS
246: aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_V;
247: BEGIN
248: aSqlItem := oe_inbound_int.PL_TO_SQL9(aPlsqlItem);
249: RETURN aSqlItem;
250: END PL_TO_SQL9;
248: aSqlItem := oe_inbound_int.PL_TO_SQL9(aPlsqlItem);
249: RETURN aSqlItem;
250: END PL_TO_SQL9;
251:
252: FUNCTION SQL_TO_PL9(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_V)
253: RETURN OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE IS
254: aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE;
255: BEGIN
256: aPlsqlItem := oe_inbound_int.SQL_TO_PL9(aSqlItem);
249: RETURN aSqlItem;
250: END PL_TO_SQL9;
251:
252: FUNCTION SQL_TO_PL9(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_V)
253: RETURN OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE IS
254: aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE;
255: BEGIN
256: aPlsqlItem := oe_inbound_int.SQL_TO_PL9(aSqlItem);
257: RETURN aPlsqlItem;
250: END PL_TO_SQL9;
251:
252: FUNCTION SQL_TO_PL9(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_V)
253: RETURN OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE IS
254: aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE;
255: BEGIN
256: aPlsqlItem := oe_inbound_int.SQL_TO_PL9(aSqlItem);
257: RETURN aPlsqlItem;
258: END SQL_TO_PL9;
256: aPlsqlItem := oe_inbound_int.SQL_TO_PL9(aSqlItem);
257: RETURN aPlsqlItem;
258: END SQL_TO_PL9;
259:
260: FUNCTION PL_TO_SQL33(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_REC_TYPE)
261: RETURN OE_ORDER_PUB_HEADER_PAYMENT_R IS
262: aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_R;
263: BEGIN
264: aSqlItem := oe_inbound_int.PL_TO_SQL33(aPlsqlItem);
257: RETURN aPlsqlItem;
258: END SQL_TO_PL9;
259:
260: FUNCTION PL_TO_SQL33(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_REC_TYPE)
261: RETURN OE_ORDER_PUB_HEADER_PAYMENT_R IS
262: aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_R;
263: BEGIN
264: aSqlItem := oe_inbound_int.PL_TO_SQL33(aPlsqlItem);
265: RETURN aSqlItem;
258: END SQL_TO_PL9;
259:
260: FUNCTION PL_TO_SQL33(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_REC_TYPE)
261: RETURN OE_ORDER_PUB_HEADER_PAYMENT_R IS
262: aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_R;
263: BEGIN
264: aSqlItem := oe_inbound_int.PL_TO_SQL33(aPlsqlItem);
265: RETURN aSqlItem;
266: END PL_TO_SQL33;
264: aSqlItem := oe_inbound_int.PL_TO_SQL33(aPlsqlItem);
265: RETURN aSqlItem;
266: END PL_TO_SQL33;
267:
268: FUNCTION SQL_TO_PL33(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_R)
269: RETURN OE_ORDER_PUB.HEADER_PAYMENT_REC_TYPE IS
270: aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_REC_TYPE;
271: BEGIN
272: aPlsqlItem := oe_inbound_int.SQL_TO_PL33(aSqlItem);
265: RETURN aSqlItem;
266: END PL_TO_SQL33;
267:
268: FUNCTION SQL_TO_PL33(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_R)
269: RETURN OE_ORDER_PUB.HEADER_PAYMENT_REC_TYPE IS
270: aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_REC_TYPE;
271: BEGIN
272: aPlsqlItem := oe_inbound_int.SQL_TO_PL33(aSqlItem);
273: RETURN aPlsqlItem;
266: END PL_TO_SQL33;
267:
268: FUNCTION SQL_TO_PL33(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_R)
269: RETURN OE_ORDER_PUB.HEADER_PAYMENT_REC_TYPE IS
270: aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_REC_TYPE;
271: BEGIN
272: aPlsqlItem := oe_inbound_int.SQL_TO_PL33(aSqlItem);
273: RETURN aPlsqlItem;
274: END SQL_TO_PL33;
272: aPlsqlItem := oe_inbound_int.SQL_TO_PL33(aSqlItem);
273: RETURN aPlsqlItem;
274: END SQL_TO_PL33;
275:
276: FUNCTION PL_TO_SQL10(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE)
277: RETURN OE_ORDER_PUB_HEADER_PAYMENT_T IS
278: aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_T;
279: BEGIN
280: aSqlItem := oe_inbound_int.PL_TO_SQL10(aPlsqlItem);
273: RETURN aPlsqlItem;
274: END SQL_TO_PL33;
275:
276: FUNCTION PL_TO_SQL10(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE)
277: RETURN OE_ORDER_PUB_HEADER_PAYMENT_T IS
278: aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_T;
279: BEGIN
280: aSqlItem := oe_inbound_int.PL_TO_SQL10(aPlsqlItem);
281: RETURN aSqlItem;
274: END SQL_TO_PL33;
275:
276: FUNCTION PL_TO_SQL10(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE)
277: RETURN OE_ORDER_PUB_HEADER_PAYMENT_T IS
278: aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_T;
279: BEGIN
280: aSqlItem := oe_inbound_int.PL_TO_SQL10(aPlsqlItem);
281: RETURN aSqlItem;
282: END PL_TO_SQL10;
280: aSqlItem := oe_inbound_int.PL_TO_SQL10(aPlsqlItem);
281: RETURN aSqlItem;
282: END PL_TO_SQL10;
283:
284: FUNCTION SQL_TO_PL10(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_T)
285: RETURN OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE IS
286: aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE;
287: BEGIN
288: aPlsqlItem := oe_inbound_int.SQL_TO_PL10(aSqlItem);
281: RETURN aSqlItem;
282: END PL_TO_SQL10;
283:
284: FUNCTION SQL_TO_PL10(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_T)
285: RETURN OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE IS
286: aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE;
287: BEGIN
288: aPlsqlItem := oe_inbound_int.SQL_TO_PL10(aSqlItem);
289: RETURN aPlsqlItem;
282: END PL_TO_SQL10;
283:
284: FUNCTION SQL_TO_PL10(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_T)
285: RETURN OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE IS
286: aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE;
287: BEGIN
288: aPlsqlItem := oe_inbound_int.SQL_TO_PL10(aSqlItem);
289: RETURN aPlsqlItem;
290: END SQL_TO_PL10;
288: aPlsqlItem := oe_inbound_int.SQL_TO_PL10(aSqlItem);
289: RETURN aPlsqlItem;
290: END SQL_TO_PL10;
291:
292: FUNCTION PL_TO_SQL34(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_REC_TYPE)
293: RETURN OE_ORDER_PUB_HEADER_PAYMENT_5 IS
294: aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_5;
295: BEGIN
296: aSqlItem := oe_inbound_int.PL_TO_SQL34(aPlsqlItem);
289: RETURN aPlsqlItem;
290: END SQL_TO_PL10;
291:
292: FUNCTION PL_TO_SQL34(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_REC_TYPE)
293: RETURN OE_ORDER_PUB_HEADER_PAYMENT_5 IS
294: aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_5;
295: BEGIN
296: aSqlItem := oe_inbound_int.PL_TO_SQL34(aPlsqlItem);
297: RETURN aSqlItem;
290: END SQL_TO_PL10;
291:
292: FUNCTION PL_TO_SQL34(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_REC_TYPE)
293: RETURN OE_ORDER_PUB_HEADER_PAYMENT_5 IS
294: aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_5;
295: BEGIN
296: aSqlItem := oe_inbound_int.PL_TO_SQL34(aPlsqlItem);
297: RETURN aSqlItem;
298: END PL_TO_SQL34;
296: aSqlItem := oe_inbound_int.PL_TO_SQL34(aPlsqlItem);
297: RETURN aSqlItem;
298: END PL_TO_SQL34;
299:
300: FUNCTION SQL_TO_PL34(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_5)
301: RETURN OE_ORDER_PUB.HEADER_PAYMENT_VAL_REC_TYPE IS
302: aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_REC_TYPE;
303: BEGIN
304: aPlsqlItem := oe_inbound_int.SQL_TO_PL34(aSqlItem);
297: RETURN aSqlItem;
298: END PL_TO_SQL34;
299:
300: FUNCTION SQL_TO_PL34(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_5)
301: RETURN OE_ORDER_PUB.HEADER_PAYMENT_VAL_REC_TYPE IS
302: aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_REC_TYPE;
303: BEGIN
304: aPlsqlItem := oe_inbound_int.SQL_TO_PL34(aSqlItem);
305: RETURN aPlsqlItem;
298: END PL_TO_SQL34;
299:
300: FUNCTION SQL_TO_PL34(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_5)
301: RETURN OE_ORDER_PUB.HEADER_PAYMENT_VAL_REC_TYPE IS
302: aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_REC_TYPE;
303: BEGIN
304: aPlsqlItem := oe_inbound_int.SQL_TO_PL34(aSqlItem);
305: RETURN aPlsqlItem;
306: END SQL_TO_PL34;
304: aPlsqlItem := oe_inbound_int.SQL_TO_PL34(aSqlItem);
305: RETURN aPlsqlItem;
306: END SQL_TO_PL34;
307:
308: FUNCTION PL_TO_SQL11(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE)
309: RETURN OE_ORDER_PUB_HEADER_PAYMENT_V IS
310: aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_V;
311: BEGIN
312: aSqlItem := oe_inbound_int.PL_TO_SQL11(aPlsqlItem);
305: RETURN aPlsqlItem;
306: END SQL_TO_PL34;
307:
308: FUNCTION PL_TO_SQL11(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE)
309: RETURN OE_ORDER_PUB_HEADER_PAYMENT_V IS
310: aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_V;
311: BEGIN
312: aSqlItem := oe_inbound_int.PL_TO_SQL11(aPlsqlItem);
313: RETURN aSqlItem;
306: END SQL_TO_PL34;
307:
308: FUNCTION PL_TO_SQL11(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE)
309: RETURN OE_ORDER_PUB_HEADER_PAYMENT_V IS
310: aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_V;
311: BEGIN
312: aSqlItem := oe_inbound_int.PL_TO_SQL11(aPlsqlItem);
313: RETURN aSqlItem;
314: END PL_TO_SQL11;
312: aSqlItem := oe_inbound_int.PL_TO_SQL11(aPlsqlItem);
313: RETURN aSqlItem;
314: END PL_TO_SQL11;
315:
316: FUNCTION SQL_TO_PL11(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_V)
317: RETURN OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE IS
318: aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE;
319: BEGIN
320: aPlsqlItem := oe_inbound_int.SQL_TO_PL11(aSqlItem);
313: RETURN aSqlItem;
314: END PL_TO_SQL11;
315:
316: FUNCTION SQL_TO_PL11(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_V)
317: RETURN OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE IS
318: aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE;
319: BEGIN
320: aPlsqlItem := oe_inbound_int.SQL_TO_PL11(aSqlItem);
321: RETURN aPlsqlItem;
314: END PL_TO_SQL11;
315:
316: FUNCTION SQL_TO_PL11(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_V)
317: RETURN OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE IS
318: aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE;
319: BEGIN
320: aPlsqlItem := oe_inbound_int.SQL_TO_PL11(aSqlItem);
321: RETURN aPlsqlItem;
322: END SQL_TO_PL11;
320: aPlsqlItem := oe_inbound_int.SQL_TO_PL11(aSqlItem);
321: RETURN aPlsqlItem;
322: END SQL_TO_PL11;
323:
324: FUNCTION PL_TO_SQL35(aPlsqlItem OE_ORDER_PUB.LINE_REC_TYPE)
325: RETURN OE_ORDER_PUB_LINE_REC_TYPE IS
326: aSqlItem OE_ORDER_PUB_LINE_REC_TYPE;
327: BEGIN
328: aSqlItem := oe_inbound_int.PL_TO_SQL35(aPlsqlItem);
321: RETURN aPlsqlItem;
322: END SQL_TO_PL11;
323:
324: FUNCTION PL_TO_SQL35(aPlsqlItem OE_ORDER_PUB.LINE_REC_TYPE)
325: RETURN OE_ORDER_PUB_LINE_REC_TYPE IS
326: aSqlItem OE_ORDER_PUB_LINE_REC_TYPE;
327: BEGIN
328: aSqlItem := oe_inbound_int.PL_TO_SQL35(aPlsqlItem);
329: RETURN aSqlItem;
322: END SQL_TO_PL11;
323:
324: FUNCTION PL_TO_SQL35(aPlsqlItem OE_ORDER_PUB.LINE_REC_TYPE)
325: RETURN OE_ORDER_PUB_LINE_REC_TYPE IS
326: aSqlItem OE_ORDER_PUB_LINE_REC_TYPE;
327: BEGIN
328: aSqlItem := oe_inbound_int.PL_TO_SQL35(aPlsqlItem);
329: RETURN aSqlItem;
330: END PL_TO_SQL35;
328: aSqlItem := oe_inbound_int.PL_TO_SQL35(aPlsqlItem);
329: RETURN aSqlItem;
330: END PL_TO_SQL35;
331:
332: FUNCTION SQL_TO_PL35(aSqlItem OE_ORDER_PUB_LINE_REC_TYPE)
333: RETURN OE_ORDER_PUB.LINE_REC_TYPE IS
334: aPlsqlItem OE_ORDER_PUB.LINE_REC_TYPE;
335: BEGIN
336: aPlsqlItem := oe_inbound_int.SQL_TO_PL35(aSqlItem);
329: RETURN aSqlItem;
330: END PL_TO_SQL35;
331:
332: FUNCTION SQL_TO_PL35(aSqlItem OE_ORDER_PUB_LINE_REC_TYPE)
333: RETURN OE_ORDER_PUB.LINE_REC_TYPE IS
334: aPlsqlItem OE_ORDER_PUB.LINE_REC_TYPE;
335: BEGIN
336: aPlsqlItem := oe_inbound_int.SQL_TO_PL35(aSqlItem);
337: RETURN aPlsqlItem;
330: END PL_TO_SQL35;
331:
332: FUNCTION SQL_TO_PL35(aSqlItem OE_ORDER_PUB_LINE_REC_TYPE)
333: RETURN OE_ORDER_PUB.LINE_REC_TYPE IS
334: aPlsqlItem OE_ORDER_PUB.LINE_REC_TYPE;
335: BEGIN
336: aPlsqlItem := oe_inbound_int.SQL_TO_PL35(aSqlItem);
337: RETURN aPlsqlItem;
338: END SQL_TO_PL35;
336: aPlsqlItem := oe_inbound_int.SQL_TO_PL35(aSqlItem);
337: RETURN aPlsqlItem;
338: END SQL_TO_PL35;
339:
340: FUNCTION PL_TO_SQL12(aPlsqlItem OE_ORDER_PUB.LINE_TBL_TYPE)
341: RETURN OE_ORDER_PUB_LINE_TBL_TYPE IS
342: aSqlItem OE_ORDER_PUB_LINE_TBL_TYPE;
343: BEGIN
344: aSqlItem := oe_inbound_int.PL_TO_SQL12(aPlsqlItem);
337: RETURN aPlsqlItem;
338: END SQL_TO_PL35;
339:
340: FUNCTION PL_TO_SQL12(aPlsqlItem OE_ORDER_PUB.LINE_TBL_TYPE)
341: RETURN OE_ORDER_PUB_LINE_TBL_TYPE IS
342: aSqlItem OE_ORDER_PUB_LINE_TBL_TYPE;
343: BEGIN
344: aSqlItem := oe_inbound_int.PL_TO_SQL12(aPlsqlItem);
345: RETURN aSqlItem;
338: END SQL_TO_PL35;
339:
340: FUNCTION PL_TO_SQL12(aPlsqlItem OE_ORDER_PUB.LINE_TBL_TYPE)
341: RETURN OE_ORDER_PUB_LINE_TBL_TYPE IS
342: aSqlItem OE_ORDER_PUB_LINE_TBL_TYPE;
343: BEGIN
344: aSqlItem := oe_inbound_int.PL_TO_SQL12(aPlsqlItem);
345: RETURN aSqlItem;
346: END PL_TO_SQL12;
344: aSqlItem := oe_inbound_int.PL_TO_SQL12(aPlsqlItem);
345: RETURN aSqlItem;
346: END PL_TO_SQL12;
347:
348: FUNCTION SQL_TO_PL12(aSqlItem OE_ORDER_PUB_LINE_TBL_TYPE)
349: RETURN OE_ORDER_PUB.LINE_TBL_TYPE IS
350: aPlsqlItem OE_ORDER_PUB.LINE_TBL_TYPE;
351: BEGIN
352: aPlsqlItem := oe_inbound_int.SQL_TO_PL12(aSqlItem);
345: RETURN aSqlItem;
346: END PL_TO_SQL12;
347:
348: FUNCTION SQL_TO_PL12(aSqlItem OE_ORDER_PUB_LINE_TBL_TYPE)
349: RETURN OE_ORDER_PUB.LINE_TBL_TYPE IS
350: aPlsqlItem OE_ORDER_PUB.LINE_TBL_TYPE;
351: BEGIN
352: aPlsqlItem := oe_inbound_int.SQL_TO_PL12(aSqlItem);
353: RETURN aPlsqlItem;
346: END PL_TO_SQL12;
347:
348: FUNCTION SQL_TO_PL12(aSqlItem OE_ORDER_PUB_LINE_TBL_TYPE)
349: RETURN OE_ORDER_PUB.LINE_TBL_TYPE IS
350: aPlsqlItem OE_ORDER_PUB.LINE_TBL_TYPE;
351: BEGIN
352: aPlsqlItem := oe_inbound_int.SQL_TO_PL12(aSqlItem);
353: RETURN aPlsqlItem;
354: END SQL_TO_PL12;
352: aPlsqlItem := oe_inbound_int.SQL_TO_PL12(aSqlItem);
353: RETURN aPlsqlItem;
354: END SQL_TO_PL12;
355:
356: FUNCTION PL_TO_SQL36(aPlsqlItem OE_ORDER_PUB.LINE_VAL_REC_TYPE)
357: RETURN OE_ORDER_PUB_LINE_VAL_REC_TYP IS
358: aSqlItem OE_ORDER_PUB_LINE_VAL_REC_TYP;
359: BEGIN
360: aSqlItem := oe_inbound_int.PL_TO_SQL36(aPlsqlItem);
353: RETURN aPlsqlItem;
354: END SQL_TO_PL12;
355:
356: FUNCTION PL_TO_SQL36(aPlsqlItem OE_ORDER_PUB.LINE_VAL_REC_TYPE)
357: RETURN OE_ORDER_PUB_LINE_VAL_REC_TYP IS
358: aSqlItem OE_ORDER_PUB_LINE_VAL_REC_TYP;
359: BEGIN
360: aSqlItem := oe_inbound_int.PL_TO_SQL36(aPlsqlItem);
361: RETURN aSqlItem;
354: END SQL_TO_PL12;
355:
356: FUNCTION PL_TO_SQL36(aPlsqlItem OE_ORDER_PUB.LINE_VAL_REC_TYPE)
357: RETURN OE_ORDER_PUB_LINE_VAL_REC_TYP IS
358: aSqlItem OE_ORDER_PUB_LINE_VAL_REC_TYP;
359: BEGIN
360: aSqlItem := oe_inbound_int.PL_TO_SQL36(aPlsqlItem);
361: RETURN aSqlItem;
362: END PL_TO_SQL36;
360: aSqlItem := oe_inbound_int.PL_TO_SQL36(aPlsqlItem);
361: RETURN aSqlItem;
362: END PL_TO_SQL36;
363:
364: FUNCTION SQL_TO_PL36(aSqlItem OE_ORDER_PUB_LINE_VAL_REC_TYP)
365: RETURN OE_ORDER_PUB.LINE_VAL_REC_TYPE IS
366: aPlsqlItem OE_ORDER_PUB.LINE_VAL_REC_TYPE;
367: BEGIN
368: aPlsqlItem := oe_inbound_int.SQL_TO_PL36(aSqlItem);
361: RETURN aSqlItem;
362: END PL_TO_SQL36;
363:
364: FUNCTION SQL_TO_PL36(aSqlItem OE_ORDER_PUB_LINE_VAL_REC_TYP)
365: RETURN OE_ORDER_PUB.LINE_VAL_REC_TYPE IS
366: aPlsqlItem OE_ORDER_PUB.LINE_VAL_REC_TYPE;
367: BEGIN
368: aPlsqlItem := oe_inbound_int.SQL_TO_PL36(aSqlItem);
369: RETURN aPlsqlItem;
362: END PL_TO_SQL36;
363:
364: FUNCTION SQL_TO_PL36(aSqlItem OE_ORDER_PUB_LINE_VAL_REC_TYP)
365: RETURN OE_ORDER_PUB.LINE_VAL_REC_TYPE IS
366: aPlsqlItem OE_ORDER_PUB.LINE_VAL_REC_TYPE;
367: BEGIN
368: aPlsqlItem := oe_inbound_int.SQL_TO_PL36(aSqlItem);
369: RETURN aPlsqlItem;
370: END SQL_TO_PL36;
368: aPlsqlItem := oe_inbound_int.SQL_TO_PL36(aSqlItem);
369: RETURN aPlsqlItem;
370: END SQL_TO_PL36;
371:
372: FUNCTION PL_TO_SQL13(aPlsqlItem OE_ORDER_PUB.LINE_VAL_TBL_TYPE)
373: RETURN OE_ORDER_PUB_LINE_VAL_TBL_TYP IS
374: aSqlItem OE_ORDER_PUB_LINE_VAL_TBL_TYP;
375: BEGIN
376: aSqlItem := oe_inbound_int.PL_TO_SQL13(aPlsqlItem);
369: RETURN aPlsqlItem;
370: END SQL_TO_PL36;
371:
372: FUNCTION PL_TO_SQL13(aPlsqlItem OE_ORDER_PUB.LINE_VAL_TBL_TYPE)
373: RETURN OE_ORDER_PUB_LINE_VAL_TBL_TYP IS
374: aSqlItem OE_ORDER_PUB_LINE_VAL_TBL_TYP;
375: BEGIN
376: aSqlItem := oe_inbound_int.PL_TO_SQL13(aPlsqlItem);
377: RETURN aSqlItem;
370: END SQL_TO_PL36;
371:
372: FUNCTION PL_TO_SQL13(aPlsqlItem OE_ORDER_PUB.LINE_VAL_TBL_TYPE)
373: RETURN OE_ORDER_PUB_LINE_VAL_TBL_TYP IS
374: aSqlItem OE_ORDER_PUB_LINE_VAL_TBL_TYP;
375: BEGIN
376: aSqlItem := oe_inbound_int.PL_TO_SQL13(aPlsqlItem);
377: RETURN aSqlItem;
378: END PL_TO_SQL13;
376: aSqlItem := oe_inbound_int.PL_TO_SQL13(aPlsqlItem);
377: RETURN aSqlItem;
378: END PL_TO_SQL13;
379:
380: FUNCTION SQL_TO_PL13(aSqlItem OE_ORDER_PUB_LINE_VAL_TBL_TYP)
381: RETURN OE_ORDER_PUB.LINE_VAL_TBL_TYPE IS
382: aPlsqlItem OE_ORDER_PUB.LINE_VAL_TBL_TYPE;
383: BEGIN
384: aPlsqlItem := oe_inbound_int.SQL_TO_PL13(aSqlItem);
377: RETURN aSqlItem;
378: END PL_TO_SQL13;
379:
380: FUNCTION SQL_TO_PL13(aSqlItem OE_ORDER_PUB_LINE_VAL_TBL_TYP)
381: RETURN OE_ORDER_PUB.LINE_VAL_TBL_TYPE IS
382: aPlsqlItem OE_ORDER_PUB.LINE_VAL_TBL_TYPE;
383: BEGIN
384: aPlsqlItem := oe_inbound_int.SQL_TO_PL13(aSqlItem);
385: RETURN aPlsqlItem;
378: END PL_TO_SQL13;
379:
380: FUNCTION SQL_TO_PL13(aSqlItem OE_ORDER_PUB_LINE_VAL_TBL_TYP)
381: RETURN OE_ORDER_PUB.LINE_VAL_TBL_TYPE IS
382: aPlsqlItem OE_ORDER_PUB.LINE_VAL_TBL_TYPE;
383: BEGIN
384: aPlsqlItem := oe_inbound_int.SQL_TO_PL13(aSqlItem);
385: RETURN aPlsqlItem;
386: END SQL_TO_PL13;
384: aPlsqlItem := oe_inbound_int.SQL_TO_PL13(aSqlItem);
385: RETURN aPlsqlItem;
386: END SQL_TO_PL13;
387:
388: FUNCTION PL_TO_SQL37(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_REC_TYPE)
389: RETURN OE_ORDER_PUB_LINE_ADJ_REC_TYP IS
390: aSqlItem OE_ORDER_PUB_LINE_ADJ_REC_TYP;
391: BEGIN
392: aSqlItem := oe_inbound_int.PL_TO_SQL37(aPlsqlItem);
385: RETURN aPlsqlItem;
386: END SQL_TO_PL13;
387:
388: FUNCTION PL_TO_SQL37(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_REC_TYPE)
389: RETURN OE_ORDER_PUB_LINE_ADJ_REC_TYP IS
390: aSqlItem OE_ORDER_PUB_LINE_ADJ_REC_TYP;
391: BEGIN
392: aSqlItem := oe_inbound_int.PL_TO_SQL37(aPlsqlItem);
393: RETURN aSqlItem;
386: END SQL_TO_PL13;
387:
388: FUNCTION PL_TO_SQL37(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_REC_TYPE)
389: RETURN OE_ORDER_PUB_LINE_ADJ_REC_TYP IS
390: aSqlItem OE_ORDER_PUB_LINE_ADJ_REC_TYP;
391: BEGIN
392: aSqlItem := oe_inbound_int.PL_TO_SQL37(aPlsqlItem);
393: RETURN aSqlItem;
394: END PL_TO_SQL37;
392: aSqlItem := oe_inbound_int.PL_TO_SQL37(aPlsqlItem);
393: RETURN aSqlItem;
394: END PL_TO_SQL37;
395:
396: FUNCTION SQL_TO_PL37(aSqlItem OE_ORDER_PUB_LINE_ADJ_REC_TYP)
397: RETURN OE_ORDER_PUB.LINE_ADJ_REC_TYPE IS
398: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_REC_TYPE;
399: BEGIN
400: aPlsqlItem := oe_inbound_int.SQL_TO_PL37(aSqlItem);
393: RETURN aSqlItem;
394: END PL_TO_SQL37;
395:
396: FUNCTION SQL_TO_PL37(aSqlItem OE_ORDER_PUB_LINE_ADJ_REC_TYP)
397: RETURN OE_ORDER_PUB.LINE_ADJ_REC_TYPE IS
398: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_REC_TYPE;
399: BEGIN
400: aPlsqlItem := oe_inbound_int.SQL_TO_PL37(aSqlItem);
401: RETURN aPlsqlItem;
394: END PL_TO_SQL37;
395:
396: FUNCTION SQL_TO_PL37(aSqlItem OE_ORDER_PUB_LINE_ADJ_REC_TYP)
397: RETURN OE_ORDER_PUB.LINE_ADJ_REC_TYPE IS
398: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_REC_TYPE;
399: BEGIN
400: aPlsqlItem := oe_inbound_int.SQL_TO_PL37(aSqlItem);
401: RETURN aPlsqlItem;
402: END SQL_TO_PL37;
400: aPlsqlItem := oe_inbound_int.SQL_TO_PL37(aSqlItem);
401: RETURN aPlsqlItem;
402: END SQL_TO_PL37;
403:
404: FUNCTION PL_TO_SQL14(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_TBL_TYPE)
405: RETURN OE_ORDER_PUB_LINE_ADJ_TBL_TYP IS
406: aSqlItem OE_ORDER_PUB_LINE_ADJ_TBL_TYP;
407: BEGIN
408: aSqlItem := oe_inbound_int.PL_TO_SQL14(aPlsqlItem);
401: RETURN aPlsqlItem;
402: END SQL_TO_PL37;
403:
404: FUNCTION PL_TO_SQL14(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_TBL_TYPE)
405: RETURN OE_ORDER_PUB_LINE_ADJ_TBL_TYP IS
406: aSqlItem OE_ORDER_PUB_LINE_ADJ_TBL_TYP;
407: BEGIN
408: aSqlItem := oe_inbound_int.PL_TO_SQL14(aPlsqlItem);
409: RETURN aSqlItem;
402: END SQL_TO_PL37;
403:
404: FUNCTION PL_TO_SQL14(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_TBL_TYPE)
405: RETURN OE_ORDER_PUB_LINE_ADJ_TBL_TYP IS
406: aSqlItem OE_ORDER_PUB_LINE_ADJ_TBL_TYP;
407: BEGIN
408: aSqlItem := oe_inbound_int.PL_TO_SQL14(aPlsqlItem);
409: RETURN aSqlItem;
410: END PL_TO_SQL14;
408: aSqlItem := oe_inbound_int.PL_TO_SQL14(aPlsqlItem);
409: RETURN aSqlItem;
410: END PL_TO_SQL14;
411:
412: FUNCTION SQL_TO_PL14(aSqlItem OE_ORDER_PUB_LINE_ADJ_TBL_TYP)
413: RETURN OE_ORDER_PUB.LINE_ADJ_TBL_TYPE IS
414: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
415: BEGIN
416: aPlsqlItem := oe_inbound_int.SQL_TO_PL14(aSqlItem);
409: RETURN aSqlItem;
410: END PL_TO_SQL14;
411:
412: FUNCTION SQL_TO_PL14(aSqlItem OE_ORDER_PUB_LINE_ADJ_TBL_TYP)
413: RETURN OE_ORDER_PUB.LINE_ADJ_TBL_TYPE IS
414: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
415: BEGIN
416: aPlsqlItem := oe_inbound_int.SQL_TO_PL14(aSqlItem);
417: RETURN aPlsqlItem;
410: END PL_TO_SQL14;
411:
412: FUNCTION SQL_TO_PL14(aSqlItem OE_ORDER_PUB_LINE_ADJ_TBL_TYP)
413: RETURN OE_ORDER_PUB.LINE_ADJ_TBL_TYPE IS
414: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
415: BEGIN
416: aPlsqlItem := oe_inbound_int.SQL_TO_PL14(aSqlItem);
417: RETURN aPlsqlItem;
418: END SQL_TO_PL14;
416: aPlsqlItem := oe_inbound_int.SQL_TO_PL14(aSqlItem);
417: RETURN aPlsqlItem;
418: END SQL_TO_PL14;
419:
420: FUNCTION PL_TO_SQL38(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_REC_TYPE)
421: RETURN OE_ORDER_PUB_LINE_ADJ_VAL_REC IS
422: aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_REC;
423: BEGIN
424: aSqlItem := oe_inbound_int.PL_TO_SQL38(aPlsqlItem);
417: RETURN aPlsqlItem;
418: END SQL_TO_PL14;
419:
420: FUNCTION PL_TO_SQL38(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_REC_TYPE)
421: RETURN OE_ORDER_PUB_LINE_ADJ_VAL_REC IS
422: aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_REC;
423: BEGIN
424: aSqlItem := oe_inbound_int.PL_TO_SQL38(aPlsqlItem);
425: RETURN aSqlItem;
418: END SQL_TO_PL14;
419:
420: FUNCTION PL_TO_SQL38(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_REC_TYPE)
421: RETURN OE_ORDER_PUB_LINE_ADJ_VAL_REC IS
422: aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_REC;
423: BEGIN
424: aSqlItem := oe_inbound_int.PL_TO_SQL38(aPlsqlItem);
425: RETURN aSqlItem;
426: END PL_TO_SQL38;
424: aSqlItem := oe_inbound_int.PL_TO_SQL38(aPlsqlItem);
425: RETURN aSqlItem;
426: END PL_TO_SQL38;
427:
428: FUNCTION SQL_TO_PL38(aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_REC)
429: RETURN OE_ORDER_PUB.LINE_ADJ_VAL_REC_TYPE IS
430: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_REC_TYPE;
431: BEGIN
432: aPlsqlItem := oe_inbound_int.SQL_TO_PL38(aSqlItem);
425: RETURN aSqlItem;
426: END PL_TO_SQL38;
427:
428: FUNCTION SQL_TO_PL38(aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_REC)
429: RETURN OE_ORDER_PUB.LINE_ADJ_VAL_REC_TYPE IS
430: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_REC_TYPE;
431: BEGIN
432: aPlsqlItem := oe_inbound_int.SQL_TO_PL38(aSqlItem);
433: RETURN aPlsqlItem;
426: END PL_TO_SQL38;
427:
428: FUNCTION SQL_TO_PL38(aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_REC)
429: RETURN OE_ORDER_PUB.LINE_ADJ_VAL_REC_TYPE IS
430: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_REC_TYPE;
431: BEGIN
432: aPlsqlItem := oe_inbound_int.SQL_TO_PL38(aSqlItem);
433: RETURN aPlsqlItem;
434: END SQL_TO_PL38;
432: aPlsqlItem := oe_inbound_int.SQL_TO_PL38(aSqlItem);
433: RETURN aPlsqlItem;
434: END SQL_TO_PL38;
435:
436: FUNCTION PL_TO_SQL15(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE)
437: RETURN OE_ORDER_PUB_LINE_ADJ_VAL_TBL IS
438: aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_TBL;
439: BEGIN
440: aSqlItem := oe_inbound_int.PL_TO_SQL15(aPlsqlItem);
433: RETURN aPlsqlItem;
434: END SQL_TO_PL38;
435:
436: FUNCTION PL_TO_SQL15(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE)
437: RETURN OE_ORDER_PUB_LINE_ADJ_VAL_TBL IS
438: aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_TBL;
439: BEGIN
440: aSqlItem := oe_inbound_int.PL_TO_SQL15(aPlsqlItem);
441: RETURN aSqlItem;
434: END SQL_TO_PL38;
435:
436: FUNCTION PL_TO_SQL15(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE)
437: RETURN OE_ORDER_PUB_LINE_ADJ_VAL_TBL IS
438: aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_TBL;
439: BEGIN
440: aSqlItem := oe_inbound_int.PL_TO_SQL15(aPlsqlItem);
441: RETURN aSqlItem;
442: END PL_TO_SQL15;
440: aSqlItem := oe_inbound_int.PL_TO_SQL15(aPlsqlItem);
441: RETURN aSqlItem;
442: END PL_TO_SQL15;
443:
444: FUNCTION SQL_TO_PL15(aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_TBL)
445: RETURN OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE IS
446: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE;
447: BEGIN
448: aPlsqlItem := oe_inbound_int.SQL_TO_PL15(aSqlItem);
441: RETURN aSqlItem;
442: END PL_TO_SQL15;
443:
444: FUNCTION SQL_TO_PL15(aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_TBL)
445: RETURN OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE IS
446: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE;
447: BEGIN
448: aPlsqlItem := oe_inbound_int.SQL_TO_PL15(aSqlItem);
449: RETURN aPlsqlItem;
442: END PL_TO_SQL15;
443:
444: FUNCTION SQL_TO_PL15(aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_TBL)
445: RETURN OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE IS
446: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE;
447: BEGIN
448: aPlsqlItem := oe_inbound_int.SQL_TO_PL15(aSqlItem);
449: RETURN aPlsqlItem;
450: END SQL_TO_PL15;
448: aPlsqlItem := oe_inbound_int.SQL_TO_PL15(aSqlItem);
449: RETURN aPlsqlItem;
450: END SQL_TO_PL15;
451:
452: FUNCTION PL_TO_SQL39(aPlsqlItem OE_ORDER_PUB.LINE_PRICE_ATT_REC_TYPE)
453: RETURN OE_ORDER_PUB_LINE_PRICE_ATT_R IS
454: aSqlItem OE_ORDER_PUB_LINE_PRICE_ATT_R;
455: BEGIN
456: aSqlItem := oe_inbound_int.PL_TO_SQL39(aPlsqlItem);
449: RETURN aPlsqlItem;
450: END SQL_TO_PL15;
451:
452: FUNCTION PL_TO_SQL39(aPlsqlItem OE_ORDER_PUB.LINE_PRICE_ATT_REC_TYPE)
453: RETURN OE_ORDER_PUB_LINE_PRICE_ATT_R IS
454: aSqlItem OE_ORDER_PUB_LINE_PRICE_ATT_R;
455: BEGIN
456: aSqlItem := oe_inbound_int.PL_TO_SQL39(aPlsqlItem);
457: RETURN aSqlItem;
450: END SQL_TO_PL15;
451:
452: FUNCTION PL_TO_SQL39(aPlsqlItem OE_ORDER_PUB.LINE_PRICE_ATT_REC_TYPE)
453: RETURN OE_ORDER_PUB_LINE_PRICE_ATT_R IS
454: aSqlItem OE_ORDER_PUB_LINE_PRICE_ATT_R;
455: BEGIN
456: aSqlItem := oe_inbound_int.PL_TO_SQL39(aPlsqlItem);
457: RETURN aSqlItem;
458: END PL_TO_SQL39;
456: aSqlItem := oe_inbound_int.PL_TO_SQL39(aPlsqlItem);
457: RETURN aSqlItem;
458: END PL_TO_SQL39;
459:
460: FUNCTION SQL_TO_PL39(aSqlItem OE_ORDER_PUB_LINE_PRICE_ATT_R)
461: RETURN OE_ORDER_PUB.LINE_PRICE_ATT_REC_TYPE IS
462: aPlsqlItem OE_ORDER_PUB.LINE_PRICE_ATT_REC_TYPE;
463: BEGIN
464: aPlsqlItem := oe_inbound_int.SQL_TO_PL39(aSqlItem);
457: RETURN aSqlItem;
458: END PL_TO_SQL39;
459:
460: FUNCTION SQL_TO_PL39(aSqlItem OE_ORDER_PUB_LINE_PRICE_ATT_R)
461: RETURN OE_ORDER_PUB.LINE_PRICE_ATT_REC_TYPE IS
462: aPlsqlItem OE_ORDER_PUB.LINE_PRICE_ATT_REC_TYPE;
463: BEGIN
464: aPlsqlItem := oe_inbound_int.SQL_TO_PL39(aSqlItem);
465: RETURN aPlsqlItem;
458: END PL_TO_SQL39;
459:
460: FUNCTION SQL_TO_PL39(aSqlItem OE_ORDER_PUB_LINE_PRICE_ATT_R)
461: RETURN OE_ORDER_PUB.LINE_PRICE_ATT_REC_TYPE IS
462: aPlsqlItem OE_ORDER_PUB.LINE_PRICE_ATT_REC_TYPE;
463: BEGIN
464: aPlsqlItem := oe_inbound_int.SQL_TO_PL39(aSqlItem);
465: RETURN aPlsqlItem;
466: END SQL_TO_PL39;
464: aPlsqlItem := oe_inbound_int.SQL_TO_PL39(aSqlItem);
465: RETURN aPlsqlItem;
466: END SQL_TO_PL39;
467:
468: FUNCTION PL_TO_SQL16(aPlsqlItem OE_ORDER_PUB.LINE_PRICE_ATT_TBL_TYPE)
469: RETURN OE_ORDER_PUB_LINE_PRICE_ATT_T IS
470: aSqlItem OE_ORDER_PUB_LINE_PRICE_ATT_T;
471: BEGIN
472: aSqlItem := oe_inbound_int.PL_TO_SQL16(aPlsqlItem);
465: RETURN aPlsqlItem;
466: END SQL_TO_PL39;
467:
468: FUNCTION PL_TO_SQL16(aPlsqlItem OE_ORDER_PUB.LINE_PRICE_ATT_TBL_TYPE)
469: RETURN OE_ORDER_PUB_LINE_PRICE_ATT_T IS
470: aSqlItem OE_ORDER_PUB_LINE_PRICE_ATT_T;
471: BEGIN
472: aSqlItem := oe_inbound_int.PL_TO_SQL16(aPlsqlItem);
473: RETURN aSqlItem;
466: END SQL_TO_PL39;
467:
468: FUNCTION PL_TO_SQL16(aPlsqlItem OE_ORDER_PUB.LINE_PRICE_ATT_TBL_TYPE)
469: RETURN OE_ORDER_PUB_LINE_PRICE_ATT_T IS
470: aSqlItem OE_ORDER_PUB_LINE_PRICE_ATT_T;
471: BEGIN
472: aSqlItem := oe_inbound_int.PL_TO_SQL16(aPlsqlItem);
473: RETURN aSqlItem;
474: END PL_TO_SQL16;
472: aSqlItem := oe_inbound_int.PL_TO_SQL16(aPlsqlItem);
473: RETURN aSqlItem;
474: END PL_TO_SQL16;
475:
476: FUNCTION SQL_TO_PL16(aSqlItem OE_ORDER_PUB_LINE_PRICE_ATT_T)
477: RETURN OE_ORDER_PUB.LINE_PRICE_ATT_TBL_TYPE IS
478: aPlsqlItem OE_ORDER_PUB.LINE_PRICE_ATT_TBL_TYPE;
479: BEGIN
480: aPlsqlItem := oe_inbound_int.SQL_TO_PL16(aSqlItem);
473: RETURN aSqlItem;
474: END PL_TO_SQL16;
475:
476: FUNCTION SQL_TO_PL16(aSqlItem OE_ORDER_PUB_LINE_PRICE_ATT_T)
477: RETURN OE_ORDER_PUB.LINE_PRICE_ATT_TBL_TYPE IS
478: aPlsqlItem OE_ORDER_PUB.LINE_PRICE_ATT_TBL_TYPE;
479: BEGIN
480: aPlsqlItem := oe_inbound_int.SQL_TO_PL16(aSqlItem);
481: RETURN aPlsqlItem;
474: END PL_TO_SQL16;
475:
476: FUNCTION SQL_TO_PL16(aSqlItem OE_ORDER_PUB_LINE_PRICE_ATT_T)
477: RETURN OE_ORDER_PUB.LINE_PRICE_ATT_TBL_TYPE IS
478: aPlsqlItem OE_ORDER_PUB.LINE_PRICE_ATT_TBL_TYPE;
479: BEGIN
480: aPlsqlItem := oe_inbound_int.SQL_TO_PL16(aSqlItem);
481: RETURN aPlsqlItem;
482: END SQL_TO_PL16;
480: aPlsqlItem := oe_inbound_int.SQL_TO_PL16(aSqlItem);
481: RETURN aPlsqlItem;
482: END SQL_TO_PL16;
483:
484: FUNCTION PL_TO_SQL40(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ATT_REC_TYPE)
485: RETURN OE_ORDER_PUB_LINE_ADJ_ATT_REC IS
486: aSqlItem OE_ORDER_PUB_LINE_ADJ_ATT_REC;
487: BEGIN
488: aSqlItem := oe_inbound_int.PL_TO_SQL40(aPlsqlItem);
481: RETURN aPlsqlItem;
482: END SQL_TO_PL16;
483:
484: FUNCTION PL_TO_SQL40(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ATT_REC_TYPE)
485: RETURN OE_ORDER_PUB_LINE_ADJ_ATT_REC IS
486: aSqlItem OE_ORDER_PUB_LINE_ADJ_ATT_REC;
487: BEGIN
488: aSqlItem := oe_inbound_int.PL_TO_SQL40(aPlsqlItem);
489: RETURN aSqlItem;
482: END SQL_TO_PL16;
483:
484: FUNCTION PL_TO_SQL40(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ATT_REC_TYPE)
485: RETURN OE_ORDER_PUB_LINE_ADJ_ATT_REC IS
486: aSqlItem OE_ORDER_PUB_LINE_ADJ_ATT_REC;
487: BEGIN
488: aSqlItem := oe_inbound_int.PL_TO_SQL40(aPlsqlItem);
489: RETURN aSqlItem;
490: END PL_TO_SQL40;
488: aSqlItem := oe_inbound_int.PL_TO_SQL40(aPlsqlItem);
489: RETURN aSqlItem;
490: END PL_TO_SQL40;
491:
492: FUNCTION SQL_TO_PL40(aSqlItem OE_ORDER_PUB_LINE_ADJ_ATT_REC)
493: RETURN OE_ORDER_PUB.LINE_ADJ_ATT_REC_TYPE IS
494: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ATT_REC_TYPE;
495: BEGIN
496: aPlsqlItem := oe_inbound_int.SQL_TO_PL40(aSqlItem);
489: RETURN aSqlItem;
490: END PL_TO_SQL40;
491:
492: FUNCTION SQL_TO_PL40(aSqlItem OE_ORDER_PUB_LINE_ADJ_ATT_REC)
493: RETURN OE_ORDER_PUB.LINE_ADJ_ATT_REC_TYPE IS
494: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ATT_REC_TYPE;
495: BEGIN
496: aPlsqlItem := oe_inbound_int.SQL_TO_PL40(aSqlItem);
497: RETURN aPlsqlItem;
490: END PL_TO_SQL40;
491:
492: FUNCTION SQL_TO_PL40(aSqlItem OE_ORDER_PUB_LINE_ADJ_ATT_REC)
493: RETURN OE_ORDER_PUB.LINE_ADJ_ATT_REC_TYPE IS
494: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ATT_REC_TYPE;
495: BEGIN
496: aPlsqlItem := oe_inbound_int.SQL_TO_PL40(aSqlItem);
497: RETURN aPlsqlItem;
498: END SQL_TO_PL40;
496: aPlsqlItem := oe_inbound_int.SQL_TO_PL40(aSqlItem);
497: RETURN aPlsqlItem;
498: END SQL_TO_PL40;
499:
500: FUNCTION PL_TO_SQL17(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ATT_TBL_TYPE)
501: RETURN OE_ORDER_PUB_LINE_ADJ_ATT_TBL IS
502: aSqlItem OE_ORDER_PUB_LINE_ADJ_ATT_TBL;
503: BEGIN
504: aSqlItem := oe_inbound_int.PL_TO_SQL17(aPlsqlItem);
497: RETURN aPlsqlItem;
498: END SQL_TO_PL40;
499:
500: FUNCTION PL_TO_SQL17(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ATT_TBL_TYPE)
501: RETURN OE_ORDER_PUB_LINE_ADJ_ATT_TBL IS
502: aSqlItem OE_ORDER_PUB_LINE_ADJ_ATT_TBL;
503: BEGIN
504: aSqlItem := oe_inbound_int.PL_TO_SQL17(aPlsqlItem);
505: RETURN aSqlItem;
498: END SQL_TO_PL40;
499:
500: FUNCTION PL_TO_SQL17(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ATT_TBL_TYPE)
501: RETURN OE_ORDER_PUB_LINE_ADJ_ATT_TBL IS
502: aSqlItem OE_ORDER_PUB_LINE_ADJ_ATT_TBL;
503: BEGIN
504: aSqlItem := oe_inbound_int.PL_TO_SQL17(aPlsqlItem);
505: RETURN aSqlItem;
506: END PL_TO_SQL17;
504: aSqlItem := oe_inbound_int.PL_TO_SQL17(aPlsqlItem);
505: RETURN aSqlItem;
506: END PL_TO_SQL17;
507:
508: FUNCTION SQL_TO_PL17(aSqlItem OE_ORDER_PUB_LINE_ADJ_ATT_TBL)
509: RETURN OE_ORDER_PUB.LINE_ADJ_ATT_TBL_TYPE IS
510: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ATT_TBL_TYPE;
511: BEGIN
512: aPlsqlItem := oe_inbound_int.SQL_TO_PL17(aSqlItem);
505: RETURN aSqlItem;
506: END PL_TO_SQL17;
507:
508: FUNCTION SQL_TO_PL17(aSqlItem OE_ORDER_PUB_LINE_ADJ_ATT_TBL)
509: RETURN OE_ORDER_PUB.LINE_ADJ_ATT_TBL_TYPE IS
510: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ATT_TBL_TYPE;
511: BEGIN
512: aPlsqlItem := oe_inbound_int.SQL_TO_PL17(aSqlItem);
513: RETURN aPlsqlItem;
506: END PL_TO_SQL17;
507:
508: FUNCTION SQL_TO_PL17(aSqlItem OE_ORDER_PUB_LINE_ADJ_ATT_TBL)
509: RETURN OE_ORDER_PUB.LINE_ADJ_ATT_TBL_TYPE IS
510: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ATT_TBL_TYPE;
511: BEGIN
512: aPlsqlItem := oe_inbound_int.SQL_TO_PL17(aSqlItem);
513: RETURN aPlsqlItem;
514: END SQL_TO_PL17;
512: aPlsqlItem := oe_inbound_int.SQL_TO_PL17(aSqlItem);
513: RETURN aPlsqlItem;
514: END SQL_TO_PL17;
515:
516: FUNCTION PL_TO_SQL41(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_REC_TYPE)
517: RETURN OE_ORDER_PUB_LINE_ADJ_ASSOC_R IS
518: aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_R;
519: BEGIN
520: aSqlItem := oe_inbound_int.PL_TO_SQL41(aPlsqlItem);
513: RETURN aPlsqlItem;
514: END SQL_TO_PL17;
515:
516: FUNCTION PL_TO_SQL41(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_REC_TYPE)
517: RETURN OE_ORDER_PUB_LINE_ADJ_ASSOC_R IS
518: aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_R;
519: BEGIN
520: aSqlItem := oe_inbound_int.PL_TO_SQL41(aPlsqlItem);
521: RETURN aSqlItem;
514: END SQL_TO_PL17;
515:
516: FUNCTION PL_TO_SQL41(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_REC_TYPE)
517: RETURN OE_ORDER_PUB_LINE_ADJ_ASSOC_R IS
518: aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_R;
519: BEGIN
520: aSqlItem := oe_inbound_int.PL_TO_SQL41(aPlsqlItem);
521: RETURN aSqlItem;
522: END PL_TO_SQL41;
520: aSqlItem := oe_inbound_int.PL_TO_SQL41(aPlsqlItem);
521: RETURN aSqlItem;
522: END PL_TO_SQL41;
523:
524: FUNCTION SQL_TO_PL41(aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_R)
525: RETURN OE_ORDER_PUB.LINE_ADJ_ASSOC_REC_TYPE IS
526: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_REC_TYPE;
527: BEGIN
528: aPlsqlItem := oe_inbound_int.SQL_TO_PL41(aSqlItem);
521: RETURN aSqlItem;
522: END PL_TO_SQL41;
523:
524: FUNCTION SQL_TO_PL41(aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_R)
525: RETURN OE_ORDER_PUB.LINE_ADJ_ASSOC_REC_TYPE IS
526: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_REC_TYPE;
527: BEGIN
528: aPlsqlItem := oe_inbound_int.SQL_TO_PL41(aSqlItem);
529: RETURN aPlsqlItem;
522: END PL_TO_SQL41;
523:
524: FUNCTION SQL_TO_PL41(aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_R)
525: RETURN OE_ORDER_PUB.LINE_ADJ_ASSOC_REC_TYPE IS
526: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_REC_TYPE;
527: BEGIN
528: aPlsqlItem := oe_inbound_int.SQL_TO_PL41(aSqlItem);
529: RETURN aPlsqlItem;
530: END SQL_TO_PL41;
528: aPlsqlItem := oe_inbound_int.SQL_TO_PL41(aSqlItem);
529: RETURN aPlsqlItem;
530: END SQL_TO_PL41;
531:
532: FUNCTION PL_TO_SQL18(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE)
533: RETURN OE_ORDER_PUB_LINE_ADJ_ASSOC_T IS
534: aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_T;
535: BEGIN
536: aSqlItem := oe_inbound_int.PL_TO_SQL18(aPlsqlItem);
529: RETURN aPlsqlItem;
530: END SQL_TO_PL41;
531:
532: FUNCTION PL_TO_SQL18(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE)
533: RETURN OE_ORDER_PUB_LINE_ADJ_ASSOC_T IS
534: aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_T;
535: BEGIN
536: aSqlItem := oe_inbound_int.PL_TO_SQL18(aPlsqlItem);
537: RETURN aSqlItem;
530: END SQL_TO_PL41;
531:
532: FUNCTION PL_TO_SQL18(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE)
533: RETURN OE_ORDER_PUB_LINE_ADJ_ASSOC_T IS
534: aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_T;
535: BEGIN
536: aSqlItem := oe_inbound_int.PL_TO_SQL18(aPlsqlItem);
537: RETURN aSqlItem;
538: END PL_TO_SQL18;
536: aSqlItem := oe_inbound_int.PL_TO_SQL18(aPlsqlItem);
537: RETURN aSqlItem;
538: END PL_TO_SQL18;
539:
540: FUNCTION SQL_TO_PL18(aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_T)
541: RETURN OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE IS
542: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE;
543: BEGIN
544: aPlsqlItem := oe_inbound_int.SQL_TO_PL18(aSqlItem);
537: RETURN aSqlItem;
538: END PL_TO_SQL18;
539:
540: FUNCTION SQL_TO_PL18(aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_T)
541: RETURN OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE IS
542: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE;
543: BEGIN
544: aPlsqlItem := oe_inbound_int.SQL_TO_PL18(aSqlItem);
545: RETURN aPlsqlItem;
538: END PL_TO_SQL18;
539:
540: FUNCTION SQL_TO_PL18(aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_T)
541: RETURN OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE IS
542: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE;
543: BEGIN
544: aPlsqlItem := oe_inbound_int.SQL_TO_PL18(aSqlItem);
545: RETURN aPlsqlItem;
546: END SQL_TO_PL18;
544: aPlsqlItem := oe_inbound_int.SQL_TO_PL18(aSqlItem);
545: RETURN aPlsqlItem;
546: END SQL_TO_PL18;
547:
548: FUNCTION PL_TO_SQL42(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_REC_TYPE)
549: RETURN OE_ORDER_PUB_LINE_SCREDIT_REC IS
550: aSqlItem OE_ORDER_PUB_LINE_SCREDIT_REC;
551: BEGIN
552: aSqlItem := oe_inbound_int.PL_TO_SQL42(aPlsqlItem);
545: RETURN aPlsqlItem;
546: END SQL_TO_PL18;
547:
548: FUNCTION PL_TO_SQL42(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_REC_TYPE)
549: RETURN OE_ORDER_PUB_LINE_SCREDIT_REC IS
550: aSqlItem OE_ORDER_PUB_LINE_SCREDIT_REC;
551: BEGIN
552: aSqlItem := oe_inbound_int.PL_TO_SQL42(aPlsqlItem);
553: RETURN aSqlItem;
546: END SQL_TO_PL18;
547:
548: FUNCTION PL_TO_SQL42(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_REC_TYPE)
549: RETURN OE_ORDER_PUB_LINE_SCREDIT_REC IS
550: aSqlItem OE_ORDER_PUB_LINE_SCREDIT_REC;
551: BEGIN
552: aSqlItem := oe_inbound_int.PL_TO_SQL42(aPlsqlItem);
553: RETURN aSqlItem;
554: END PL_TO_SQL42;
552: aSqlItem := oe_inbound_int.PL_TO_SQL42(aPlsqlItem);
553: RETURN aSqlItem;
554: END PL_TO_SQL42;
555:
556: FUNCTION SQL_TO_PL42(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_REC)
557: RETURN OE_ORDER_PUB.LINE_SCREDIT_REC_TYPE IS
558: aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_REC_TYPE;
559: BEGIN
560: aPlsqlItem := oe_inbound_int.SQL_TO_PL42(aSqlItem);
553: RETURN aSqlItem;
554: END PL_TO_SQL42;
555:
556: FUNCTION SQL_TO_PL42(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_REC)
557: RETURN OE_ORDER_PUB.LINE_SCREDIT_REC_TYPE IS
558: aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_REC_TYPE;
559: BEGIN
560: aPlsqlItem := oe_inbound_int.SQL_TO_PL42(aSqlItem);
561: RETURN aPlsqlItem;
554: END PL_TO_SQL42;
555:
556: FUNCTION SQL_TO_PL42(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_REC)
557: RETURN OE_ORDER_PUB.LINE_SCREDIT_REC_TYPE IS
558: aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_REC_TYPE;
559: BEGIN
560: aPlsqlItem := oe_inbound_int.SQL_TO_PL42(aSqlItem);
561: RETURN aPlsqlItem;
562: END SQL_TO_PL42;
560: aPlsqlItem := oe_inbound_int.SQL_TO_PL42(aSqlItem);
561: RETURN aPlsqlItem;
562: END SQL_TO_PL42;
563:
564: FUNCTION PL_TO_SQL19(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE)
565: RETURN OE_ORDER_PUB_LINE_SCREDIT_TBL IS
566: aSqlItem OE_ORDER_PUB_LINE_SCREDIT_TBL;
567: BEGIN
568: aSqlItem := oe_inbound_int.PL_TO_SQL19(aPlsqlItem);
561: RETURN aPlsqlItem;
562: END SQL_TO_PL42;
563:
564: FUNCTION PL_TO_SQL19(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE)
565: RETURN OE_ORDER_PUB_LINE_SCREDIT_TBL IS
566: aSqlItem OE_ORDER_PUB_LINE_SCREDIT_TBL;
567: BEGIN
568: aSqlItem := oe_inbound_int.PL_TO_SQL19(aPlsqlItem);
569: RETURN aSqlItem;
562: END SQL_TO_PL42;
563:
564: FUNCTION PL_TO_SQL19(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE)
565: RETURN OE_ORDER_PUB_LINE_SCREDIT_TBL IS
566: aSqlItem OE_ORDER_PUB_LINE_SCREDIT_TBL;
567: BEGIN
568: aSqlItem := oe_inbound_int.PL_TO_SQL19(aPlsqlItem);
569: RETURN aSqlItem;
570: END PL_TO_SQL19;
568: aSqlItem := oe_inbound_int.PL_TO_SQL19(aPlsqlItem);
569: RETURN aSqlItem;
570: END PL_TO_SQL19;
571:
572: FUNCTION SQL_TO_PL19(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_TBL)
573: RETURN OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE IS
574: aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE;
575: BEGIN
576: aPlsqlItem := oe_inbound_int.SQL_TO_PL19(aSqlItem);
569: RETURN aSqlItem;
570: END PL_TO_SQL19;
571:
572: FUNCTION SQL_TO_PL19(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_TBL)
573: RETURN OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE IS
574: aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE;
575: BEGIN
576: aPlsqlItem := oe_inbound_int.SQL_TO_PL19(aSqlItem);
577: RETURN aPlsqlItem;
570: END PL_TO_SQL19;
571:
572: FUNCTION SQL_TO_PL19(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_TBL)
573: RETURN OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE IS
574: aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE;
575: BEGIN
576: aPlsqlItem := oe_inbound_int.SQL_TO_PL19(aSqlItem);
577: RETURN aPlsqlItem;
578: END SQL_TO_PL19;
576: aPlsqlItem := oe_inbound_int.SQL_TO_PL19(aSqlItem);
577: RETURN aPlsqlItem;
578: END SQL_TO_PL19;
579:
580: FUNCTION PL_TO_SQL43(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE)
581: RETURN OE_ORDER_PUB_LINE_SCREDIT_VA6 IS
582: aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VA6;
583: BEGIN
584: aSqlItem := oe_inbound_int.PL_TO_SQL43(aPlsqlItem);
577: RETURN aPlsqlItem;
578: END SQL_TO_PL19;
579:
580: FUNCTION PL_TO_SQL43(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE)
581: RETURN OE_ORDER_PUB_LINE_SCREDIT_VA6 IS
582: aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VA6;
583: BEGIN
584: aSqlItem := oe_inbound_int.PL_TO_SQL43(aPlsqlItem);
585: RETURN aSqlItem;
578: END SQL_TO_PL19;
579:
580: FUNCTION PL_TO_SQL43(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE)
581: RETURN OE_ORDER_PUB_LINE_SCREDIT_VA6 IS
582: aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VA6;
583: BEGIN
584: aSqlItem := oe_inbound_int.PL_TO_SQL43(aPlsqlItem);
585: RETURN aSqlItem;
586: END PL_TO_SQL43;
584: aSqlItem := oe_inbound_int.PL_TO_SQL43(aPlsqlItem);
585: RETURN aSqlItem;
586: END PL_TO_SQL43;
587:
588: FUNCTION SQL_TO_PL43(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VA6)
589: RETURN OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE IS
590: aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE;
591: BEGIN
592: aPlsqlItem := oe_inbound_int.SQL_TO_PL43(aSqlItem);
585: RETURN aSqlItem;
586: END PL_TO_SQL43;
587:
588: FUNCTION SQL_TO_PL43(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VA6)
589: RETURN OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE IS
590: aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE;
591: BEGIN
592: aPlsqlItem := oe_inbound_int.SQL_TO_PL43(aSqlItem);
593: RETURN aPlsqlItem;
586: END PL_TO_SQL43;
587:
588: FUNCTION SQL_TO_PL43(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VA6)
589: RETURN OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE IS
590: aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE;
591: BEGIN
592: aPlsqlItem := oe_inbound_int.SQL_TO_PL43(aSqlItem);
593: RETURN aPlsqlItem;
594: END SQL_TO_PL43;
592: aPlsqlItem := oe_inbound_int.SQL_TO_PL43(aSqlItem);
593: RETURN aPlsqlItem;
594: END SQL_TO_PL43;
595:
596: FUNCTION PL_TO_SQL20(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE)
597: RETURN OE_ORDER_PUB_LINE_SCREDIT_VAL IS
598: aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VAL;
599: BEGIN
600: aSqlItem := oe_inbound_int.PL_TO_SQL20(aPlsqlItem);
593: RETURN aPlsqlItem;
594: END SQL_TO_PL43;
595:
596: FUNCTION PL_TO_SQL20(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE)
597: RETURN OE_ORDER_PUB_LINE_SCREDIT_VAL IS
598: aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VAL;
599: BEGIN
600: aSqlItem := oe_inbound_int.PL_TO_SQL20(aPlsqlItem);
601: RETURN aSqlItem;
594: END SQL_TO_PL43;
595:
596: FUNCTION PL_TO_SQL20(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE)
597: RETURN OE_ORDER_PUB_LINE_SCREDIT_VAL IS
598: aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VAL;
599: BEGIN
600: aSqlItem := oe_inbound_int.PL_TO_SQL20(aPlsqlItem);
601: RETURN aSqlItem;
602: END PL_TO_SQL20;
600: aSqlItem := oe_inbound_int.PL_TO_SQL20(aPlsqlItem);
601: RETURN aSqlItem;
602: END PL_TO_SQL20;
603:
604: FUNCTION SQL_TO_PL20(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VAL)
605: RETURN OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE IS
606: aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;
607: BEGIN
608: aPlsqlItem := oe_inbound_int.SQL_TO_PL20(aSqlItem);
601: RETURN aSqlItem;
602: END PL_TO_SQL20;
603:
604: FUNCTION SQL_TO_PL20(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VAL)
605: RETURN OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE IS
606: aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;
607: BEGIN
608: aPlsqlItem := oe_inbound_int.SQL_TO_PL20(aSqlItem);
609: RETURN aPlsqlItem;
602: END PL_TO_SQL20;
603:
604: FUNCTION SQL_TO_PL20(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VAL)
605: RETURN OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE IS
606: aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;
607: BEGIN
608: aPlsqlItem := oe_inbound_int.SQL_TO_PL20(aSqlItem);
609: RETURN aPlsqlItem;
610: END SQL_TO_PL20;
608: aPlsqlItem := oe_inbound_int.SQL_TO_PL20(aSqlItem);
609: RETURN aPlsqlItem;
610: END SQL_TO_PL20;
611:
612: FUNCTION PL_TO_SQL44(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_REC_TYPE)
613: RETURN OE_ORDER_PUB_LINE_PAYMENT_REC IS
614: aSqlItem OE_ORDER_PUB_LINE_PAYMENT_REC;
615: BEGIN
616: aSqlItem := oe_inbound_int.PL_TO_SQL44(aPlsqlItem);
609: RETURN aPlsqlItem;
610: END SQL_TO_PL20;
611:
612: FUNCTION PL_TO_SQL44(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_REC_TYPE)
613: RETURN OE_ORDER_PUB_LINE_PAYMENT_REC IS
614: aSqlItem OE_ORDER_PUB_LINE_PAYMENT_REC;
615: BEGIN
616: aSqlItem := oe_inbound_int.PL_TO_SQL44(aPlsqlItem);
617: RETURN aSqlItem;
610: END SQL_TO_PL20;
611:
612: FUNCTION PL_TO_SQL44(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_REC_TYPE)
613: RETURN OE_ORDER_PUB_LINE_PAYMENT_REC IS
614: aSqlItem OE_ORDER_PUB_LINE_PAYMENT_REC;
615: BEGIN
616: aSqlItem := oe_inbound_int.PL_TO_SQL44(aPlsqlItem);
617: RETURN aSqlItem;
618: END PL_TO_SQL44;
616: aSqlItem := oe_inbound_int.PL_TO_SQL44(aPlsqlItem);
617: RETURN aSqlItem;
618: END PL_TO_SQL44;
619:
620: FUNCTION SQL_TO_PL44(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_REC)
621: RETURN OE_ORDER_PUB.LINE_PAYMENT_REC_TYPE IS
622: aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_REC_TYPE;
623: BEGIN
624: aPlsqlItem := oe_inbound_int.SQL_TO_PL44(aSqlItem);
617: RETURN aSqlItem;
618: END PL_TO_SQL44;
619:
620: FUNCTION SQL_TO_PL44(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_REC)
621: RETURN OE_ORDER_PUB.LINE_PAYMENT_REC_TYPE IS
622: aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_REC_TYPE;
623: BEGIN
624: aPlsqlItem := oe_inbound_int.SQL_TO_PL44(aSqlItem);
625: RETURN aPlsqlItem;
618: END PL_TO_SQL44;
619:
620: FUNCTION SQL_TO_PL44(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_REC)
621: RETURN OE_ORDER_PUB.LINE_PAYMENT_REC_TYPE IS
622: aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_REC_TYPE;
623: BEGIN
624: aPlsqlItem := oe_inbound_int.SQL_TO_PL44(aSqlItem);
625: RETURN aPlsqlItem;
626: END SQL_TO_PL44;
625: RETURN aPlsqlItem;
626: END SQL_TO_PL44;
627:
628:
629: FUNCTION PL_TO_SQL21(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE)
630: RETURN OE_ORDER_PUB_LINE_PAYMENT_TBL IS
631: aSqlItem OE_ORDER_PUB_LINE_PAYMENT_TBL;
632: BEGIN
633: aSqlItem := oe_inbound_int.PL_TO_SQL21(aPlsqlItem);
626: END SQL_TO_PL44;
627:
628:
629: FUNCTION PL_TO_SQL21(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE)
630: RETURN OE_ORDER_PUB_LINE_PAYMENT_TBL IS
631: aSqlItem OE_ORDER_PUB_LINE_PAYMENT_TBL;
632: BEGIN
633: aSqlItem := oe_inbound_int.PL_TO_SQL21(aPlsqlItem);
634: RETURN aSqlItem;
627:
628:
629: FUNCTION PL_TO_SQL21(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE)
630: RETURN OE_ORDER_PUB_LINE_PAYMENT_TBL IS
631: aSqlItem OE_ORDER_PUB_LINE_PAYMENT_TBL;
632: BEGIN
633: aSqlItem := oe_inbound_int.PL_TO_SQL21(aPlsqlItem);
634: RETURN aSqlItem;
635: END PL_TO_SQL21;
633: aSqlItem := oe_inbound_int.PL_TO_SQL21(aPlsqlItem);
634: RETURN aSqlItem;
635: END PL_TO_SQL21;
636:
637: FUNCTION SQL_TO_PL21(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_TBL)
638: RETURN OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE IS
639: aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE;
640: BEGIN
641: aPlsqlItem := oe_inbound_int.SQL_TO_PL21(aSqlItem);
634: RETURN aSqlItem;
635: END PL_TO_SQL21;
636:
637: FUNCTION SQL_TO_PL21(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_TBL)
638: RETURN OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE IS
639: aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE;
640: BEGIN
641: aPlsqlItem := oe_inbound_int.SQL_TO_PL21(aSqlItem);
642: RETURN aPlsqlItem;
635: END PL_TO_SQL21;
636:
637: FUNCTION SQL_TO_PL21(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_TBL)
638: RETURN OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE IS
639: aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE;
640: BEGIN
641: aPlsqlItem := oe_inbound_int.SQL_TO_PL21(aSqlItem);
642: RETURN aPlsqlItem;
643: END SQL_TO_PL21;
641: aPlsqlItem := oe_inbound_int.SQL_TO_PL21(aSqlItem);
642: RETURN aPlsqlItem;
643: END SQL_TO_PL21;
644:
645: FUNCTION PL_TO_SQL45(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE)
646: RETURN OE_ORDER_PUB_LINE_PAYMENT_VA3 IS
647: aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VA3;
648: BEGIN
649: aSqlItem := oe_inbound_int.PL_TO_SQL45(aPlsqlItem);
642: RETURN aPlsqlItem;
643: END SQL_TO_PL21;
644:
645: FUNCTION PL_TO_SQL45(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE)
646: RETURN OE_ORDER_PUB_LINE_PAYMENT_VA3 IS
647: aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VA3;
648: BEGIN
649: aSqlItem := oe_inbound_int.PL_TO_SQL45(aPlsqlItem);
650: RETURN aSqlItem;
643: END SQL_TO_PL21;
644:
645: FUNCTION PL_TO_SQL45(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE)
646: RETURN OE_ORDER_PUB_LINE_PAYMENT_VA3 IS
647: aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VA3;
648: BEGIN
649: aSqlItem := oe_inbound_int.PL_TO_SQL45(aPlsqlItem);
650: RETURN aSqlItem;
651: END PL_TO_SQL45;
649: aSqlItem := oe_inbound_int.PL_TO_SQL45(aPlsqlItem);
650: RETURN aSqlItem;
651: END PL_TO_SQL45;
652:
653: FUNCTION SQL_TO_PL45(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VA3)
654: RETURN OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE IS
655: aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE;
656: BEGIN
657: aPlsqlItem := oe_inbound_int.SQL_TO_PL45(aSqlItem);
650: RETURN aSqlItem;
651: END PL_TO_SQL45;
652:
653: FUNCTION SQL_TO_PL45(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VA3)
654: RETURN OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE IS
655: aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE;
656: BEGIN
657: aPlsqlItem := oe_inbound_int.SQL_TO_PL45(aSqlItem);
658: RETURN aPlsqlItem;
651: END PL_TO_SQL45;
652:
653: FUNCTION SQL_TO_PL45(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VA3)
654: RETURN OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE IS
655: aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE;
656: BEGIN
657: aPlsqlItem := oe_inbound_int.SQL_TO_PL45(aSqlItem);
658: RETURN aPlsqlItem;
659: END SQL_TO_PL45;
657: aPlsqlItem := oe_inbound_int.SQL_TO_PL45(aSqlItem);
658: RETURN aPlsqlItem;
659: END SQL_TO_PL45;
660:
661: FUNCTION PL_TO_SQL22(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE)
662: RETURN OE_ORDER_PUB_LINE_PAYMENT_VAL IS
663: aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VAL;
664: BEGIN
665: aSqlItem := oe_inbound_int.PL_TO_SQL22(aPlsqlItem);
658: RETURN aPlsqlItem;
659: END SQL_TO_PL45;
660:
661: FUNCTION PL_TO_SQL22(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE)
662: RETURN OE_ORDER_PUB_LINE_PAYMENT_VAL IS
663: aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VAL;
664: BEGIN
665: aSqlItem := oe_inbound_int.PL_TO_SQL22(aPlsqlItem);
666: RETURN aSqlItem;
659: END SQL_TO_PL45;
660:
661: FUNCTION PL_TO_SQL22(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE)
662: RETURN OE_ORDER_PUB_LINE_PAYMENT_VAL IS
663: aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VAL;
664: BEGIN
665: aSqlItem := oe_inbound_int.PL_TO_SQL22(aPlsqlItem);
666: RETURN aSqlItem;
667: END PL_TO_SQL22;
666: RETURN aSqlItem;
667: END PL_TO_SQL22;
668:
669:
670: FUNCTION SQL_TO_PL22(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VAL)
671: RETURN OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE IS
672: aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;
673: BEGIN
674: aPlsqlItem := oe_inbound_int.SQL_TO_PL22(aSqlItem);
667: END PL_TO_SQL22;
668:
669:
670: FUNCTION SQL_TO_PL22(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VAL)
671: RETURN OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE IS
672: aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;
673: BEGIN
674: aPlsqlItem := oe_inbound_int.SQL_TO_PL22(aSqlItem);
675: RETURN aPlsqlItem;
668:
669:
670: FUNCTION SQL_TO_PL22(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VAL)
671: RETURN OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE IS
672: aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;
673: BEGIN
674: aPlsqlItem := oe_inbound_int.SQL_TO_PL22(aSqlItem);
675: RETURN aPlsqlItem;
676: END SQL_TO_PL22;
674: aPlsqlItem := oe_inbound_int.SQL_TO_PL22(aSqlItem);
675: RETURN aPlsqlItem;
676: END SQL_TO_PL22;
677:
678: FUNCTION PL_TO_SQL46(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_REC_TYPE)
679: RETURN OE_ORDER_PUB_LOT_SERIAL_REC_T IS
680: aSqlItem OE_ORDER_PUB_LOT_SERIAL_REC_T;
681: BEGIN
682: aSqlItem := oe_inbound_int.PL_TO_SQL46(aPlsqlItem);
675: RETURN aPlsqlItem;
676: END SQL_TO_PL22;
677:
678: FUNCTION PL_TO_SQL46(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_REC_TYPE)
679: RETURN OE_ORDER_PUB_LOT_SERIAL_REC_T IS
680: aSqlItem OE_ORDER_PUB_LOT_SERIAL_REC_T;
681: BEGIN
682: aSqlItem := oe_inbound_int.PL_TO_SQL46(aPlsqlItem);
683: RETURN aSqlItem;
676: END SQL_TO_PL22;
677:
678: FUNCTION PL_TO_SQL46(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_REC_TYPE)
679: RETURN OE_ORDER_PUB_LOT_SERIAL_REC_T IS
680: aSqlItem OE_ORDER_PUB_LOT_SERIAL_REC_T;
681: BEGIN
682: aSqlItem := oe_inbound_int.PL_TO_SQL46(aPlsqlItem);
683: RETURN aSqlItem;
684: END PL_TO_SQL46;
682: aSqlItem := oe_inbound_int.PL_TO_SQL46(aPlsqlItem);
683: RETURN aSqlItem;
684: END PL_TO_SQL46;
685:
686: FUNCTION SQL_TO_PL46(aSqlItem OE_ORDER_PUB_LOT_SERIAL_REC_T)
687: RETURN OE_ORDER_PUB.LOT_SERIAL_REC_TYPE IS
688: aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_REC_TYPE;
689: BEGIN
690: aPlsqlItem := oe_inbound_int.SQL_TO_PL46(aSqlItem);
683: RETURN aSqlItem;
684: END PL_TO_SQL46;
685:
686: FUNCTION SQL_TO_PL46(aSqlItem OE_ORDER_PUB_LOT_SERIAL_REC_T)
687: RETURN OE_ORDER_PUB.LOT_SERIAL_REC_TYPE IS
688: aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_REC_TYPE;
689: BEGIN
690: aPlsqlItem := oe_inbound_int.SQL_TO_PL46(aSqlItem);
691: RETURN aPlsqlItem;
684: END PL_TO_SQL46;
685:
686: FUNCTION SQL_TO_PL46(aSqlItem OE_ORDER_PUB_LOT_SERIAL_REC_T)
687: RETURN OE_ORDER_PUB.LOT_SERIAL_REC_TYPE IS
688: aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_REC_TYPE;
689: BEGIN
690: aPlsqlItem := oe_inbound_int.SQL_TO_PL46(aSqlItem);
691: RETURN aPlsqlItem;
692: END SQL_TO_PL46;
690: aPlsqlItem := oe_inbound_int.SQL_TO_PL46(aSqlItem);
691: RETURN aPlsqlItem;
692: END SQL_TO_PL46;
693:
694: FUNCTION PL_TO_SQL23(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE)
695: RETURN OE_ORDER_PUB_LOT_SERIAL_TBL_T IS
696: aSqlItem OE_ORDER_PUB_LOT_SERIAL_TBL_T;
697: BEGIN
698: aSqlItem := oe_inbound_int.PL_TO_SQL23(aPlsqlItem);
691: RETURN aPlsqlItem;
692: END SQL_TO_PL46;
693:
694: FUNCTION PL_TO_SQL23(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE)
695: RETURN OE_ORDER_PUB_LOT_SERIAL_TBL_T IS
696: aSqlItem OE_ORDER_PUB_LOT_SERIAL_TBL_T;
697: BEGIN
698: aSqlItem := oe_inbound_int.PL_TO_SQL23(aPlsqlItem);
699: RETURN aSqlItem;
692: END SQL_TO_PL46;
693:
694: FUNCTION PL_TO_SQL23(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE)
695: RETURN OE_ORDER_PUB_LOT_SERIAL_TBL_T IS
696: aSqlItem OE_ORDER_PUB_LOT_SERIAL_TBL_T;
697: BEGIN
698: aSqlItem := oe_inbound_int.PL_TO_SQL23(aPlsqlItem);
699: RETURN aSqlItem;
700: END PL_TO_SQL23;
698: aSqlItem := oe_inbound_int.PL_TO_SQL23(aPlsqlItem);
699: RETURN aSqlItem;
700: END PL_TO_SQL23;
701:
702: FUNCTION SQL_TO_PL23(aSqlItem OE_ORDER_PUB_LOT_SERIAL_TBL_T)
703: RETURN OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE IS
704: aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;
705: BEGIN
706: aPlsqlItem := oe_inbound_int.SQL_TO_PL23(aSqlItem);
699: RETURN aSqlItem;
700: END PL_TO_SQL23;
701:
702: FUNCTION SQL_TO_PL23(aSqlItem OE_ORDER_PUB_LOT_SERIAL_TBL_T)
703: RETURN OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE IS
704: aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;
705: BEGIN
706: aPlsqlItem := oe_inbound_int.SQL_TO_PL23(aSqlItem);
707: RETURN aPlsqlItem;
700: END PL_TO_SQL23;
701:
702: FUNCTION SQL_TO_PL23(aSqlItem OE_ORDER_PUB_LOT_SERIAL_TBL_T)
703: RETURN OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE IS
704: aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;
705: BEGIN
706: aPlsqlItem := oe_inbound_int.SQL_TO_PL23(aSqlItem);
707: RETURN aPlsqlItem;
708: END SQL_TO_PL23;
706: aPlsqlItem := oe_inbound_int.SQL_TO_PL23(aSqlItem);
707: RETURN aPlsqlItem;
708: END SQL_TO_PL23;
709:
710: FUNCTION PL_TO_SQL47(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_REC_TYPE)
711: RETURN OE_ORDER_PUB_LOT_SERIAL_VAL_R IS
712: aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_R;
713: BEGIN
714: aSqlItem := oe_inbound_int.PL_TO_SQL47(aPlsqlItem);
707: RETURN aPlsqlItem;
708: END SQL_TO_PL23;
709:
710: FUNCTION PL_TO_SQL47(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_REC_TYPE)
711: RETURN OE_ORDER_PUB_LOT_SERIAL_VAL_R IS
712: aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_R;
713: BEGIN
714: aSqlItem := oe_inbound_int.PL_TO_SQL47(aPlsqlItem);
715: RETURN aSqlItem;
708: END SQL_TO_PL23;
709:
710: FUNCTION PL_TO_SQL47(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_REC_TYPE)
711: RETURN OE_ORDER_PUB_LOT_SERIAL_VAL_R IS
712: aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_R;
713: BEGIN
714: aSqlItem := oe_inbound_int.PL_TO_SQL47(aPlsqlItem);
715: RETURN aSqlItem;
716: END PL_TO_SQL47;
714: aSqlItem := oe_inbound_int.PL_TO_SQL47(aPlsqlItem);
715: RETURN aSqlItem;
716: END PL_TO_SQL47;
717:
718: FUNCTION SQL_TO_PL47(aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_R)
719: RETURN OE_ORDER_PUB.LOT_SERIAL_VAL_REC_TYPE IS
720: aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_REC_TYPE;
721: BEGIN
722: aPlsqlItem := oe_inbound_int.SQL_TO_PL47(aSqlItem);
715: RETURN aSqlItem;
716: END PL_TO_SQL47;
717:
718: FUNCTION SQL_TO_PL47(aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_R)
719: RETURN OE_ORDER_PUB.LOT_SERIAL_VAL_REC_TYPE IS
720: aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_REC_TYPE;
721: BEGIN
722: aPlsqlItem := oe_inbound_int.SQL_TO_PL47(aSqlItem);
723: RETURN aPlsqlItem;
716: END PL_TO_SQL47;
717:
718: FUNCTION SQL_TO_PL47(aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_R)
719: RETURN OE_ORDER_PUB.LOT_SERIAL_VAL_REC_TYPE IS
720: aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_REC_TYPE;
721: BEGIN
722: aPlsqlItem := oe_inbound_int.SQL_TO_PL47(aSqlItem);
723: RETURN aPlsqlItem;
724: END SQL_TO_PL47;
722: aPlsqlItem := oe_inbound_int.SQL_TO_PL47(aSqlItem);
723: RETURN aPlsqlItem;
724: END SQL_TO_PL47;
725:
726: FUNCTION PL_TO_SQL24(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE)
727: RETURN OE_ORDER_PUB_LOT_SERIAL_VAL_T IS
728: aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_T;
729: BEGIN
730: aSqlItem := oe_inbound_int.PL_TO_SQL24(aPlsqlItem);
723: RETURN aPlsqlItem;
724: END SQL_TO_PL47;
725:
726: FUNCTION PL_TO_SQL24(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE)
727: RETURN OE_ORDER_PUB_LOT_SERIAL_VAL_T IS
728: aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_T;
729: BEGIN
730: aSqlItem := oe_inbound_int.PL_TO_SQL24(aPlsqlItem);
731: RETURN aSqlItem;
724: END SQL_TO_PL47;
725:
726: FUNCTION PL_TO_SQL24(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE)
727: RETURN OE_ORDER_PUB_LOT_SERIAL_VAL_T IS
728: aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_T;
729: BEGIN
730: aSqlItem := oe_inbound_int.PL_TO_SQL24(aPlsqlItem);
731: RETURN aSqlItem;
732: END PL_TO_SQL24;
730: aSqlItem := oe_inbound_int.PL_TO_SQL24(aPlsqlItem);
731: RETURN aSqlItem;
732: END PL_TO_SQL24;
733:
734: FUNCTION SQL_TO_PL24(aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_T)
735: RETURN OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE IS
736: aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;
737: BEGIN
738: aPlsqlItem := oe_inbound_int.SQL_TO_PL24(aSqlItem);
731: RETURN aSqlItem;
732: END PL_TO_SQL24;
733:
734: FUNCTION SQL_TO_PL24(aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_T)
735: RETURN OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE IS
736: aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;
737: BEGIN
738: aPlsqlItem := oe_inbound_int.SQL_TO_PL24(aSqlItem);
739: RETURN aPlsqlItem;
732: END PL_TO_SQL24;
733:
734: FUNCTION SQL_TO_PL24(aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_T)
735: RETURN OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE IS
736: aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;
737: BEGIN
738: aPlsqlItem := oe_inbound_int.SQL_TO_PL24(aSqlItem);
739: RETURN aPlsqlItem;
740: END SQL_TO_PL24;
738: aPlsqlItem := oe_inbound_int.SQL_TO_PL24(aSqlItem);
739: RETURN aPlsqlItem;
740: END SQL_TO_PL24;
741:
742: FUNCTION PL_TO_SQL48(aPlsqlItem OE_ORDER_PUB.REQUEST_REC_TYPE)
743: RETURN OE_ORDER_PUB_REQUEST_REC_TYPE IS
744: aSqlItem OE_ORDER_PUB_REQUEST_REC_TYPE;
745: BEGIN
746: aSqlItem := oe_inbound_int.PL_TO_SQL48(aPlsqlItem);
739: RETURN aPlsqlItem;
740: END SQL_TO_PL24;
741:
742: FUNCTION PL_TO_SQL48(aPlsqlItem OE_ORDER_PUB.REQUEST_REC_TYPE)
743: RETURN OE_ORDER_PUB_REQUEST_REC_TYPE IS
744: aSqlItem OE_ORDER_PUB_REQUEST_REC_TYPE;
745: BEGIN
746: aSqlItem := oe_inbound_int.PL_TO_SQL48(aPlsqlItem);
747: RETURN aSqlItem;
740: END SQL_TO_PL24;
741:
742: FUNCTION PL_TO_SQL48(aPlsqlItem OE_ORDER_PUB.REQUEST_REC_TYPE)
743: RETURN OE_ORDER_PUB_REQUEST_REC_TYPE IS
744: aSqlItem OE_ORDER_PUB_REQUEST_REC_TYPE;
745: BEGIN
746: aSqlItem := oe_inbound_int.PL_TO_SQL48(aPlsqlItem);
747: RETURN aSqlItem;
748: END PL_TO_SQL48;
746: aSqlItem := oe_inbound_int.PL_TO_SQL48(aPlsqlItem);
747: RETURN aSqlItem;
748: END PL_TO_SQL48;
749:
750: FUNCTION SQL_TO_PL48(aSqlItem OE_ORDER_PUB_REQUEST_REC_TYPE)
751: RETURN OE_ORDER_PUB.REQUEST_REC_TYPE IS
752: aPlsqlItem OE_ORDER_PUB.REQUEST_REC_TYPE;
753: BEGIN
754: aPlsqlItem := oe_inbound_int.SQL_TO_PL48(aSqlItem);
747: RETURN aSqlItem;
748: END PL_TO_SQL48;
749:
750: FUNCTION SQL_TO_PL48(aSqlItem OE_ORDER_PUB_REQUEST_REC_TYPE)
751: RETURN OE_ORDER_PUB.REQUEST_REC_TYPE IS
752: aPlsqlItem OE_ORDER_PUB.REQUEST_REC_TYPE;
753: BEGIN
754: aPlsqlItem := oe_inbound_int.SQL_TO_PL48(aSqlItem);
755: RETURN aPlsqlItem;
748: END PL_TO_SQL48;
749:
750: FUNCTION SQL_TO_PL48(aSqlItem OE_ORDER_PUB_REQUEST_REC_TYPE)
751: RETURN OE_ORDER_PUB.REQUEST_REC_TYPE IS
752: aPlsqlItem OE_ORDER_PUB.REQUEST_REC_TYPE;
753: BEGIN
754: aPlsqlItem := oe_inbound_int.SQL_TO_PL48(aSqlItem);
755: RETURN aPlsqlItem;
756: END SQL_TO_PL48;
754: aPlsqlItem := oe_inbound_int.SQL_TO_PL48(aSqlItem);
755: RETURN aPlsqlItem;
756: END SQL_TO_PL48;
757:
758: FUNCTION PL_TO_SQL25(aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE)
759: RETURN OE_ORDER_PUB_REQUEST_TBL_TYPE IS
760: aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE;
761: BEGIN
762: aSqlItem := oe_inbound_int.PL_TO_SQL25(aPlsqlItem);
755: RETURN aPlsqlItem;
756: END SQL_TO_PL48;
757:
758: FUNCTION PL_TO_SQL25(aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE)
759: RETURN OE_ORDER_PUB_REQUEST_TBL_TYPE IS
760: aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE;
761: BEGIN
762: aSqlItem := oe_inbound_int.PL_TO_SQL25(aPlsqlItem);
763: RETURN aSqlItem;
756: END SQL_TO_PL48;
757:
758: FUNCTION PL_TO_SQL25(aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE)
759: RETURN OE_ORDER_PUB_REQUEST_TBL_TYPE IS
760: aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE;
761: BEGIN
762: aSqlItem := oe_inbound_int.PL_TO_SQL25(aPlsqlItem);
763: RETURN aSqlItem;
764: END PL_TO_SQL25;
762: aSqlItem := oe_inbound_int.PL_TO_SQL25(aPlsqlItem);
763: RETURN aSqlItem;
764: END PL_TO_SQL25;
765:
766: FUNCTION SQL_TO_PL25(aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE)
767: RETURN OE_ORDER_PUB.REQUEST_TBL_TYPE IS
768: aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE;
769: BEGIN
770: aPlsqlItem := oe_inbound_int.SQL_TO_PL25(aSqlItem);
763: RETURN aSqlItem;
764: END PL_TO_SQL25;
765:
766: FUNCTION SQL_TO_PL25(aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE)
767: RETURN OE_ORDER_PUB.REQUEST_TBL_TYPE IS
768: aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE;
769: BEGIN
770: aPlsqlItem := oe_inbound_int.SQL_TO_PL25(aSqlItem);
771: RETURN aPlsqlItem;
764: END PL_TO_SQL25;
765:
766: FUNCTION SQL_TO_PL25(aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE)
767: RETURN OE_ORDER_PUB.REQUEST_TBL_TYPE IS
768: aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE;
769: BEGIN
770: aPlsqlItem := oe_inbound_int.SQL_TO_PL25(aSqlItem);
771: RETURN aPlsqlItem;
772: END SQL_TO_PL25;
771: RETURN aPlsqlItem;
772: END SQL_TO_PL25;
773:
774:
775: PROCEDURE OE_ORDER_PUB$PROCESS_ORDER (
776: P_API_VERSION_NUMBER NUMBER,P_INIT_MSG_LIST VARCHAR2,
777: P_RETURN_VALUES VARCHAR2, P_ACTION_COMMIT VARCHAR2,
778: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
779: X_MSG_COUNT OUT NOCOPY NUMBER,
777: P_RETURN_VALUES VARCHAR2, P_ACTION_COMMIT VARCHAR2,
778: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
779: X_MSG_COUNT OUT NOCOPY NUMBER,
780: X_MSG_DATA OUT NOCOPY VARCHAR2,
781: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
782: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
783: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
784: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
785: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
778: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
779: X_MSG_COUNT OUT NOCOPY NUMBER,
780: X_MSG_DATA OUT NOCOPY VARCHAR2,
781: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
782: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
783: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
784: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
785: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
786: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
779: X_MSG_COUNT OUT NOCOPY NUMBER,
780: X_MSG_DATA OUT NOCOPY VARCHAR2,
781: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
782: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
783: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
784: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
785: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
786: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
787: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
780: X_MSG_DATA OUT NOCOPY VARCHAR2,
781: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
782: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
783: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
784: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
785: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
786: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
787: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
788: P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
781: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
782: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
783: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
784: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
785: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
786: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
787: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
788: P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
789: P_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
782: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
783: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
784: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
785: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
786: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
787: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
788: P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
789: P_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
790: P_OLD_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
783: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
784: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
785: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
786: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
787: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
788: P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
789: P_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
790: P_OLD_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
791: P_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
784: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
785: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
786: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
787: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
788: P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
789: P_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
790: P_OLD_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
791: P_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
792: P_OLD_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
785: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
786: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
787: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
788: P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
789: P_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
790: P_OLD_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
791: P_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
792: P_OLD_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
793: P_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
786: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
787: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
788: P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
789: P_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
790: P_OLD_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
791: P_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
792: P_OLD_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
793: P_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
794: P_OLD_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
787: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
788: P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
789: P_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
790: P_OLD_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
791: P_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
792: P_OLD_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
793: P_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
794: P_OLD_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
795: P_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
788: P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
789: P_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
790: P_OLD_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
791: P_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
792: P_OLD_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
793: P_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
794: P_OLD_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
795: P_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
796: P_OLD_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
789: P_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
790: P_OLD_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
791: P_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
792: P_OLD_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
793: P_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
794: P_OLD_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
795: P_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
796: P_OLD_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
797: P_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
790: P_OLD_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
791: P_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
792: P_OLD_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
793: P_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
794: P_OLD_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
795: P_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
796: P_OLD_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
797: P_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
798: P_OLD_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
791: P_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
792: P_OLD_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
793: P_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
794: P_OLD_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
795: P_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
796: P_OLD_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
797: P_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
798: P_OLD_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
799: P_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
792: P_OLD_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
793: P_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
794: P_OLD_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
795: P_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
796: P_OLD_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
797: P_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
798: P_OLD_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
799: P_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
800: P_OLD_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
793: P_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
794: P_OLD_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
795: P_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
796: P_OLD_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
797: P_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
798: P_OLD_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
799: P_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
800: P_OLD_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
801: P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
794: P_OLD_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
795: P_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
796: P_OLD_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
797: P_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
798: P_OLD_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
799: P_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
800: P_OLD_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
801: P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
802: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
795: P_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
796: P_OLD_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
797: P_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
798: P_OLD_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
799: P_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
800: P_OLD_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
801: P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
802: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
803: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
796: P_OLD_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
797: P_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
798: P_OLD_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
799: P_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
800: P_OLD_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
801: P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
802: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
803: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
804: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
797: P_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
798: P_OLD_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
799: P_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
800: P_OLD_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
801: P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
802: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
803: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
804: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
805: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
798: P_OLD_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
799: P_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
800: P_OLD_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
801: P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
802: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
803: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
804: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
805: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
806: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
799: P_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
800: P_OLD_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
801: P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
802: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
803: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
804: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
805: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
806: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
807: P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
800: P_OLD_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
801: P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
802: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
803: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
804: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
805: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
806: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
807: P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
808: P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
801: P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
802: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
803: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
804: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
805: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
806: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
807: P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
808: P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
809: P_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
802: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
803: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
804: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
805: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
806: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
807: P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
808: P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
809: P_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
810: P_OLD_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
803: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
804: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
805: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
806: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
807: P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
808: P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
809: P_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
810: P_OLD_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
811: P_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
804: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
805: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
806: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
807: P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
808: P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
809: P_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
810: P_OLD_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
811: P_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
812: P_OLD_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
805: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
806: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
807: P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
808: P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
809: P_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
810: P_OLD_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
811: P_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
812: P_OLD_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
813: P_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
806: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
807: P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
808: P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
809: P_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
810: P_OLD_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
811: P_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
812: P_OLD_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
813: P_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
814: P_OLD_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
807: P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
808: P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
809: P_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
810: P_OLD_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
811: P_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
812: P_OLD_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
813: P_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
814: P_OLD_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
815: P_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
808: P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
809: P_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
810: P_OLD_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
811: P_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
812: P_OLD_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
813: P_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
814: P_OLD_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
815: P_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
816: P_OLD_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
809: P_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
810: P_OLD_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
811: P_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
812: P_OLD_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
813: P_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
814: P_OLD_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
815: P_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
816: P_OLD_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
817: P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
810: P_OLD_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
811: P_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
812: P_OLD_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
813: P_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
814: P_OLD_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
815: P_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
816: P_OLD_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
817: P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
818: P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
811: P_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
812: P_OLD_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
813: P_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
814: P_OLD_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
815: P_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
816: P_OLD_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
817: P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
818: P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
819: P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
812: P_OLD_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
813: P_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
814: P_OLD_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
815: P_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
816: P_OLD_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
817: P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
818: P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
819: P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
820: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
813: P_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
814: P_OLD_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
815: P_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
816: P_OLD_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
817: P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
818: P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
819: P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
820: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
821: P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
814: P_OLD_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
815: P_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
816: P_OLD_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
817: P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
818: P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
819: P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
820: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
821: P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
822: P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
815: P_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
816: P_OLD_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
817: P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
818: P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
819: P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
820: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
821: P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
822: P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
823: P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
816: P_OLD_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
817: P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
818: P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
819: P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
820: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
821: P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
822: P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
823: P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
824: P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
817: P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
818: P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
819: P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
820: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
821: P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
822: P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
823: P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
824: P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
825: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
818: P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
819: P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
820: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
821: P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
822: P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
823: P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
824: P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
825: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
826: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
819: P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
820: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
821: P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
822: P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
823: P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
824: P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
825: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
826: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
827: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
820: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
821: P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
822: P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
823: P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
824: P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
825: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
826: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
827: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
828: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
821: P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
822: P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
823: P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
824: P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
825: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
826: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
827: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
828: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
829: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
822: P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
823: P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
824: P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
825: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
826: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
827: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
828: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
829: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
830: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE,
823: P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
824: P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
825: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
826: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
827: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
828: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
829: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
830: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE,
831: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T,
824: P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
825: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
826: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
827: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
828: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
829: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
830: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE,
831: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T,
832: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T,
825: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
826: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
827: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
828: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
829: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
830: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE,
831: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T,
832: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T,
833: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T,
826: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
827: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
828: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
829: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
830: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE,
831: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T,
832: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T,
833: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T,
834: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT,
827: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
828: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
829: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
830: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE,
831: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T,
832: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T,
833: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T,
834: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT,
835: X_HEADER_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ATT_T,
828: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
829: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
830: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE,
831: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T,
832: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T,
833: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T,
834: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT,
835: X_HEADER_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ATT_T,
836: X_HEADER_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ASSOC,
829: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
830: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE,
831: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T,
832: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T,
833: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T,
834: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT,
835: X_HEADER_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ATT_T,
836: X_HEADER_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ASSOC,
837: X_HEADER_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_T,
830: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE,
831: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T,
832: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T,
833: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T,
834: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT,
835: X_HEADER_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ATT_T,
836: X_HEADER_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ASSOC,
837: X_HEADER_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_T,
838: X_HEADER_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_V,
831: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T,
832: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T,
833: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T,
834: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT,
835: X_HEADER_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ATT_T,
836: X_HEADER_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ASSOC,
837: X_HEADER_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_T,
838: X_HEADER_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_V,
839: X_HEADER_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_T,
832: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T,
833: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T,
834: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT,
835: X_HEADER_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ATT_T,
836: X_HEADER_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ASSOC,
837: X_HEADER_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_T,
838: X_HEADER_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_V,
839: X_HEADER_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_T,
840: X_HEADER_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_V,
833: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T,
834: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT,
835: X_HEADER_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ATT_T,
836: X_HEADER_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ASSOC,
837: X_HEADER_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_T,
838: X_HEADER_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_V,
839: X_HEADER_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_T,
840: X_HEADER_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_V,
841: X_LINE_TBL OUT NOCOPY OE_ORDER_PUB_LINE_TBL_TYPE,
834: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT,
835: X_HEADER_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ATT_T,
836: X_HEADER_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ASSOC,
837: X_HEADER_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_T,
838: X_HEADER_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_V,
839: X_HEADER_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_T,
840: X_HEADER_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_V,
841: X_LINE_TBL OUT NOCOPY OE_ORDER_PUB_LINE_TBL_TYPE,
842: X_LINE_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_VAL_TBL_TYP,
835: X_HEADER_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ATT_T,
836: X_HEADER_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ASSOC,
837: X_HEADER_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_T,
838: X_HEADER_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_V,
839: X_HEADER_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_T,
840: X_HEADER_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_V,
841: X_LINE_TBL OUT NOCOPY OE_ORDER_PUB_LINE_TBL_TYPE,
842: X_LINE_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_VAL_TBL_TYP,
843: X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
836: X_HEADER_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ASSOC,
837: X_HEADER_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_T,
838: X_HEADER_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_V,
839: X_HEADER_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_T,
840: X_HEADER_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_V,
841: X_LINE_TBL OUT NOCOPY OE_ORDER_PUB_LINE_TBL_TYPE,
842: X_LINE_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_VAL_TBL_TYP,
843: X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
844: X_LINE_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
837: X_HEADER_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_T,
838: X_HEADER_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_V,
839: X_HEADER_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_T,
840: X_HEADER_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_V,
841: X_LINE_TBL OUT NOCOPY OE_ORDER_PUB_LINE_TBL_TYPE,
842: X_LINE_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_VAL_TBL_TYP,
843: X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
844: X_LINE_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
845: X_LINE_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PRICE_ATT_T,
838: X_HEADER_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_V,
839: X_HEADER_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_T,
840: X_HEADER_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_V,
841: X_LINE_TBL OUT NOCOPY OE_ORDER_PUB_LINE_TBL_TYPE,
842: X_LINE_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_VAL_TBL_TYP,
843: X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
844: X_LINE_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
845: X_LINE_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PRICE_ATT_T,
846: X_LINE_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
839: X_HEADER_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_T,
840: X_HEADER_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_V,
841: X_LINE_TBL OUT NOCOPY OE_ORDER_PUB_LINE_TBL_TYPE,
842: X_LINE_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_VAL_TBL_TYP,
843: X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
844: X_LINE_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
845: X_LINE_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PRICE_ATT_T,
846: X_LINE_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
847: X_LINE_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
840: X_HEADER_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_V,
841: X_LINE_TBL OUT NOCOPY OE_ORDER_PUB_LINE_TBL_TYPE,
842: X_LINE_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_VAL_TBL_TYP,
843: X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
844: X_LINE_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
845: X_LINE_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PRICE_ATT_T,
846: X_LINE_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
847: X_LINE_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
848: X_LINE_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_TBL,
841: X_LINE_TBL OUT NOCOPY OE_ORDER_PUB_LINE_TBL_TYPE,
842: X_LINE_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_VAL_TBL_TYP,
843: X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
844: X_LINE_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
845: X_LINE_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PRICE_ATT_T,
846: X_LINE_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
847: X_LINE_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
848: X_LINE_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_TBL,
849: X_LINE_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_VAL,
842: X_LINE_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_VAL_TBL_TYP,
843: X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
844: X_LINE_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
845: X_LINE_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PRICE_ATT_T,
846: X_LINE_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
847: X_LINE_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
848: X_LINE_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_TBL,
849: X_LINE_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_VAL,
850: X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL,
843: X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
844: X_LINE_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
845: X_LINE_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PRICE_ATT_T,
846: X_LINE_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
847: X_LINE_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
848: X_LINE_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_TBL,
849: X_LINE_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_VAL,
850: X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL,
851: X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL,
844: X_LINE_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
845: X_LINE_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PRICE_ATT_T,
846: X_LINE_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
847: X_LINE_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
848: X_LINE_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_TBL,
849: X_LINE_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_VAL,
850: X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL,
851: X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL,
852: X_LOT_SERIAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_TBL_T,
845: X_LINE_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PRICE_ATT_T,
846: X_LINE_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
847: X_LINE_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
848: X_LINE_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_TBL,
849: X_LINE_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_VAL,
850: X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL,
851: X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL,
852: X_LOT_SERIAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_TBL_T,
853: X_LOT_SERIAL_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_VAL_T,
846: X_LINE_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
847: X_LINE_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
848: X_LINE_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_TBL,
849: X_LINE_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_VAL,
850: X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL,
851: X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL,
852: X_LOT_SERIAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_TBL_T,
853: X_LOT_SERIAL_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_VAL_T,
854: X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE,
847: X_LINE_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
848: X_LINE_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_TBL,
849: X_LINE_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_VAL,
850: X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL,
851: X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL,
852: X_LOT_SERIAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_TBL_T,
853: X_LOT_SERIAL_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_VAL_T,
854: X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE,
855: P_RTRIM_DATA VARCHAR2
848: X_LINE_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_TBL,
849: X_LINE_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_VAL,
850: X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL,
851: X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL,
852: X_LOT_SERIAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_TBL_T,
853: X_LOT_SERIAL_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_VAL_T,
854: X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE,
855: P_RTRIM_DATA VARCHAR2
856: )
849: X_LINE_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_VAL,
850: X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL,
851: X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL,
852: X_LOT_SERIAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_TBL_T,
853: X_LOT_SERIAL_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_VAL_T,
854: X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE,
855: P_RTRIM_DATA VARCHAR2
856: )
857: IS
850: X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL,
851: X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL,
852: X_LOT_SERIAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_TBL_T,
853: X_LOT_SERIAL_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_VAL_T,
854: X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE,
855: P_RTRIM_DATA VARCHAR2
856: )
857: IS
858: BEGIN
940: X_LOT_SERIAL_VAL_TBL,
941: X_ACTION_REQUEST_TBL ,
942: P_RTRIM_DATA
943: );
944: END OE_ORDER_PUB$PROCESS_ORDER;
945:
946:
947: PROCEDURE Convert_line_null_to_miss
948: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type)
944: END OE_ORDER_PUB$PROCESS_ORDER;
945:
946:
947: PROCEDURE Convert_line_null_to_miss
948: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type)
949: IS
950: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
951: BEGIN
952: oe_debug_pub.add('Entering Convert_line_null_to_miss', 1);
959: END Convert_Line_null_to_miss;
960:
961:
962: PROCEDURE Convert_hdr_null_to_miss
963: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type)
964: IS
965: BEGIN
966: oe_debug_pub.add('Entering CONVERT_HDR_NULL_TO_MISS', 1);
967: oe_inbound_int.Convert_hdr_null_to_miss(p_x_header_rec);