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

APPS.XX_BPEL_CALLPROCESSORDEREBS11I dependencies on OE_ORDER_PUB

Line 4: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE)

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);

Line 5: RETURN OE_ORDER_PUB_HEADER_REC_TYPE IS

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;

Line 6: aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE;

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;

Line 12: FUNCTION SQL_TO_PL1(aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE)

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);

Line 13: RETURN OE_ORDER_PUB.HEADER_REC_TYPE IS

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;

Line 14: aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE;

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;

Line 20: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE)

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);

Line 21: RETURN OE_ORDER_PUB_HEADER_VAL_REC_T IS

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;

Line 22: aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T;

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;

Line 28: FUNCTION SQL_TO_PL2(aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T)

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);

Line 29: RETURN OE_ORDER_PUB.HEADER_VAL_REC_TYPE IS

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;

Line 30: aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE;

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;

Line 36: FUNCTION PL_TO_SQL26(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_REC_TYPE)

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);

Line 37: RETURN OE_ORDER_PUB_HEADER_ADJ_REC_T IS

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;

Line 38: aSqlItem OE_ORDER_PUB_HEADER_ADJ_REC_T;

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;

Line 44: FUNCTION SQL_TO_PL26(aSqlItem OE_ORDER_PUB_HEADER_ADJ_REC_T)

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);

Line 45: RETURN OE_ORDER_PUB.HEADER_ADJ_REC_TYPE IS

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;

Line 46: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_REC_TYPE;

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;

Line 52: FUNCTION PL_TO_SQL3(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE)

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);

Line 53: RETURN OE_ORDER_PUB_HEADER_ADJ_TBL_T IS

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;

Line 54: aSqlItem OE_ORDER_PUB_HEADER_ADJ_TBL_T;

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;

Line 60: FUNCTION SQL_TO_PL3(aSqlItem OE_ORDER_PUB_HEADER_ADJ_TBL_T)

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);

Line 61: RETURN OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE IS

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;

Line 62: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;

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;

Line 68: FUNCTION PL_TO_SQL27(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_REC_TYPE)

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);

Line 69: RETURN OE_ORDER_PUB_HEADER_ADJ_VAL_R IS

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;

Line 70: aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_R;

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;

Line 76: FUNCTION SQL_TO_PL27(aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_R)

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);

Line 77: RETURN OE_ORDER_PUB.HEADER_ADJ_VAL_REC_TYPE IS

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;

Line 78: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_REC_TYPE;

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;

Line 84: FUNCTION PL_TO_SQL4(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE)

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);

Line 85: RETURN OE_ORDER_PUB_HEADER_ADJ_VAL_T IS

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;

Line 86: aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_T;

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;

Line 92: FUNCTION SQL_TO_PL4(aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_T)

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);

Line 93: RETURN OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE IS

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;

Line 94: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;

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;

Line 100: FUNCTION PL_TO_SQL28(aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_REC_TYPE)

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);

Line 101: RETURN OE_ORDER_PUB_HEADER_PRICE_AT6 IS

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;

Line 102: aSqlItem OE_ORDER_PUB_HEADER_PRICE_AT6;

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;

Line 108: FUNCTION SQL_TO_PL28(aSqlItem OE_ORDER_PUB_HEADER_PRICE_AT6)

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);

Line 109: RETURN OE_ORDER_PUB.HEADER_PRICE_ATT_REC_TYPE IS

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;

Line 110: aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_REC_TYPE;

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;

Line 116: FUNCTION PL_TO_SQL5(aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE)

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);

Line 117: RETURN OE_ORDER_PUB_HEADER_PRICE_ATT IS

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;

Line 118: aSqlItem OE_ORDER_PUB_HEADER_PRICE_ATT;

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;

Line 124: FUNCTION SQL_TO_PL5(aSqlItem OE_ORDER_PUB_HEADER_PRICE_ATT)

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);

Line 125: RETURN OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE IS

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;

Line 126: aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE;

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;

Line 132: FUNCTION PL_TO_SQL29(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ATT_REC_TYPE)

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);

Line 133: RETURN OE_ORDER_PUB_HEADER_ADJ_ATT_R IS

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;

Line 134: aSqlItem OE_ORDER_PUB_HEADER_ADJ_ATT_R;

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;

Line 140: FUNCTION SQL_TO_PL29(aSqlItem OE_ORDER_PUB_HEADER_ADJ_ATT_R)

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);

Line 141: RETURN OE_ORDER_PUB.HEADER_ADJ_ATT_REC_TYPE IS

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;

Line 142: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ATT_REC_TYPE;

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;

Line 148: FUNCTION PL_TO_SQL6(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE)

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);

Line 149: RETURN OE_ORDER_PUB_HEADER_ADJ_ATT_T IS

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;

Line 150: aSqlItem OE_ORDER_PUB_HEADER_ADJ_ATT_T;

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;

Line 156: FUNCTION SQL_TO_PL6(aSqlItem OE_ORDER_PUB_HEADER_ADJ_ATT_T)

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);

Line 157: RETURN OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE IS

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;

Line 158: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE;

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;

Line 164: FUNCTION PL_TO_SQL30(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ASSOC_REC_TYPE)

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);

Line 165: RETURN OE_ORDER_PUB_HEADER_ADJ_ASSO6 IS

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;

Line 166: aSqlItem OE_ORDER_PUB_HEADER_ADJ_ASSO6;

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;

Line 172: FUNCTION SQL_TO_PL30(aSqlItem OE_ORDER_PUB_HEADER_ADJ_ASSO6)

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);

Line 173: RETURN OE_ORDER_PUB.HEADER_ADJ_ASSOC_REC_TYPE IS

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;

Line 174: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ASSOC_REC_TYPE;

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;

Line 180: FUNCTION PL_TO_SQL7(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE)

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);

Line 181: RETURN OE_ORDER_PUB_HEADER_ADJ_ASSOC IS

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;

Line 182: aSqlItem OE_ORDER_PUB_HEADER_ADJ_ASSOC;

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;

Line 188: FUNCTION SQL_TO_PL7(aSqlItem OE_ORDER_PUB_HEADER_ADJ_ASSOC)

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);

Line 189: RETURN OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE IS

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;

Line 190: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE;

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;

Line 196: FUNCTION PL_TO_SQL31(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_REC_TYPE)

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);

Line 197: RETURN OE_ORDER_PUB_HEADER_SCREDIT_R IS

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;

Line 198: aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_R;

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;

Line 204: FUNCTION SQL_TO_PL31(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_R)

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);

Line 205: RETURN OE_ORDER_PUB.HEADER_SCREDIT_REC_TYPE IS

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;

Line 206: aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_REC_TYPE;

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;

Line 212: FUNCTION PL_TO_SQL8(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE)

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);

Line 213: RETURN OE_ORDER_PUB_HEADER_SCREDIT_T IS

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;

Line 214: aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_T;

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;

Line 220: FUNCTION SQL_TO_PL8(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_T)

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);

Line 221: RETURN OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE IS

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;

Line 222: aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE;

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;

Line 228: FUNCTION PL_TO_SQL32(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE)

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);

Line 229: RETURN OE_ORDER_PUB_HEADER_SCREDIT11 IS

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;

Line 230: aSqlItem OE_ORDER_PUB_HEADER_SCREDIT11;

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;

Line 236: FUNCTION SQL_TO_PL32(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT11)

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);

Line 237: RETURN OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE IS

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;

Line 238: aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE;

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;

Line 244: FUNCTION PL_TO_SQL9(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE)

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);

Line 245: RETURN OE_ORDER_PUB_HEADER_SCREDIT_V IS

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;

Line 246: aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_V;

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;

Line 252: FUNCTION SQL_TO_PL9(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_V)

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);

Line 253: RETURN OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE IS

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;

Line 254: aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE;

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;

Line 260: FUNCTION PL_TO_SQL33(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_REC_TYPE)

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);

Line 261: RETURN OE_ORDER_PUB_HEADER_PAYMENT_R IS

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;

Line 262: aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_R;

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;

Line 268: FUNCTION SQL_TO_PL33(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_R)

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);

Line 269: RETURN OE_ORDER_PUB.HEADER_PAYMENT_REC_TYPE IS

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;

Line 270: aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_REC_TYPE;

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;

Line 276: FUNCTION PL_TO_SQL10(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE)

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);

Line 277: RETURN OE_ORDER_PUB_HEADER_PAYMENT_T IS

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;

Line 278: aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_T;

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;

Line 284: FUNCTION SQL_TO_PL10(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_T)

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);

Line 285: RETURN OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE IS

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;

Line 286: aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE;

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;

Line 292: FUNCTION PL_TO_SQL34(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_REC_TYPE)

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);

Line 293: RETURN OE_ORDER_PUB_HEADER_PAYMENT_5 IS

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;

Line 294: aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_5;

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;

Line 300: FUNCTION SQL_TO_PL34(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_5)

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);

Line 301: RETURN OE_ORDER_PUB.HEADER_PAYMENT_VAL_REC_TYPE IS

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;

Line 302: aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_REC_TYPE;

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;

Line 308: FUNCTION PL_TO_SQL11(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE)

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);

Line 309: RETURN OE_ORDER_PUB_HEADER_PAYMENT_V IS

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;

Line 310: aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_V;

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;

Line 316: FUNCTION SQL_TO_PL11(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_V)

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);

Line 317: RETURN OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE IS

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;

Line 318: aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE;

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;

Line 324: FUNCTION PL_TO_SQL35(aPlsqlItem OE_ORDER_PUB.LINE_REC_TYPE)

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);

Line 325: RETURN OE_ORDER_PUB_LINE_REC_TYPE IS

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;

Line 326: aSqlItem OE_ORDER_PUB_LINE_REC_TYPE;

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;

Line 332: FUNCTION SQL_TO_PL35(aSqlItem OE_ORDER_PUB_LINE_REC_TYPE)

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);

Line 333: RETURN OE_ORDER_PUB.LINE_REC_TYPE IS

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;

Line 334: aPlsqlItem OE_ORDER_PUB.LINE_REC_TYPE;

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;

Line 340: FUNCTION PL_TO_SQL12(aPlsqlItem OE_ORDER_PUB.LINE_TBL_TYPE)

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);

Line 341: RETURN OE_ORDER_PUB_LINE_TBL_TYPE IS

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;

Line 342: aSqlItem OE_ORDER_PUB_LINE_TBL_TYPE;

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;

Line 348: FUNCTION SQL_TO_PL12(aSqlItem OE_ORDER_PUB_LINE_TBL_TYPE)

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);

Line 349: RETURN OE_ORDER_PUB.LINE_TBL_TYPE IS

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;

Line 350: aPlsqlItem OE_ORDER_PUB.LINE_TBL_TYPE;

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;

Line 356: FUNCTION PL_TO_SQL36(aPlsqlItem OE_ORDER_PUB.LINE_VAL_REC_TYPE)

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);

Line 357: RETURN OE_ORDER_PUB_LINE_VAL_REC_TYP IS

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;

Line 358: aSqlItem OE_ORDER_PUB_LINE_VAL_REC_TYP;

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;

Line 364: FUNCTION SQL_TO_PL36(aSqlItem OE_ORDER_PUB_LINE_VAL_REC_TYP)

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);

Line 365: RETURN OE_ORDER_PUB.LINE_VAL_REC_TYPE IS

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;

Line 366: aPlsqlItem OE_ORDER_PUB.LINE_VAL_REC_TYPE;

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;

Line 372: FUNCTION PL_TO_SQL13(aPlsqlItem OE_ORDER_PUB.LINE_VAL_TBL_TYPE)

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);

Line 373: RETURN OE_ORDER_PUB_LINE_VAL_TBL_TYP IS

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;

Line 374: aSqlItem OE_ORDER_PUB_LINE_VAL_TBL_TYP;

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;

Line 380: FUNCTION SQL_TO_PL13(aSqlItem OE_ORDER_PUB_LINE_VAL_TBL_TYP)

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);

Line 381: RETURN OE_ORDER_PUB.LINE_VAL_TBL_TYPE IS

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;

Line 382: aPlsqlItem OE_ORDER_PUB.LINE_VAL_TBL_TYPE;

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;

Line 388: FUNCTION PL_TO_SQL37(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_REC_TYPE)

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);

Line 389: RETURN OE_ORDER_PUB_LINE_ADJ_REC_TYP IS

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;

Line 390: aSqlItem OE_ORDER_PUB_LINE_ADJ_REC_TYP;

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;

Line 396: FUNCTION SQL_TO_PL37(aSqlItem OE_ORDER_PUB_LINE_ADJ_REC_TYP)

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);

Line 397: RETURN OE_ORDER_PUB.LINE_ADJ_REC_TYPE IS

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;

Line 398: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_REC_TYPE;

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;

Line 404: FUNCTION PL_TO_SQL14(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_TBL_TYPE)

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);

Line 405: RETURN OE_ORDER_PUB_LINE_ADJ_TBL_TYP IS

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;

Line 406: aSqlItem OE_ORDER_PUB_LINE_ADJ_TBL_TYP;

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;

Line 412: FUNCTION SQL_TO_PL14(aSqlItem OE_ORDER_PUB_LINE_ADJ_TBL_TYP)

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);

Line 413: RETURN OE_ORDER_PUB.LINE_ADJ_TBL_TYPE IS

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;

Line 414: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;

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;

Line 420: FUNCTION PL_TO_SQL38(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_REC_TYPE)

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);

Line 421: RETURN OE_ORDER_PUB_LINE_ADJ_VAL_REC IS

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;

Line 422: aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_REC;

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;

Line 428: FUNCTION SQL_TO_PL38(aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_REC)

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);

Line 429: RETURN OE_ORDER_PUB.LINE_ADJ_VAL_REC_TYPE IS

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;

Line 430: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_REC_TYPE;

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;

Line 436: FUNCTION PL_TO_SQL15(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE)

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);

Line 437: RETURN OE_ORDER_PUB_LINE_ADJ_VAL_TBL IS

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;

Line 438: aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_TBL;

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;

Line 444: FUNCTION SQL_TO_PL15(aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_TBL)

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);

Line 445: RETURN OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE IS

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;

Line 446: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE;

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;

Line 452: FUNCTION PL_TO_SQL39(aPlsqlItem OE_ORDER_PUB.LINE_PRICE_ATT_REC_TYPE)

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);

Line 453: RETURN OE_ORDER_PUB_LINE_PRICE_ATT_R IS

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;

Line 454: aSqlItem OE_ORDER_PUB_LINE_PRICE_ATT_R;

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;

Line 460: FUNCTION SQL_TO_PL39(aSqlItem OE_ORDER_PUB_LINE_PRICE_ATT_R)

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);

Line 461: RETURN OE_ORDER_PUB.LINE_PRICE_ATT_REC_TYPE IS

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;

Line 462: aPlsqlItem OE_ORDER_PUB.LINE_PRICE_ATT_REC_TYPE;

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;

Line 468: FUNCTION PL_TO_SQL16(aPlsqlItem OE_ORDER_PUB.LINE_PRICE_ATT_TBL_TYPE)

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);

Line 469: RETURN OE_ORDER_PUB_LINE_PRICE_ATT_T IS

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;

Line 470: aSqlItem OE_ORDER_PUB_LINE_PRICE_ATT_T;

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;

Line 476: FUNCTION SQL_TO_PL16(aSqlItem OE_ORDER_PUB_LINE_PRICE_ATT_T)

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);

Line 477: RETURN OE_ORDER_PUB.LINE_PRICE_ATT_TBL_TYPE IS

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;

Line 478: aPlsqlItem OE_ORDER_PUB.LINE_PRICE_ATT_TBL_TYPE;

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;

Line 484: FUNCTION PL_TO_SQL40(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ATT_REC_TYPE)

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);

Line 485: RETURN OE_ORDER_PUB_LINE_ADJ_ATT_REC IS

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;

Line 486: aSqlItem OE_ORDER_PUB_LINE_ADJ_ATT_REC;

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;

Line 492: FUNCTION SQL_TO_PL40(aSqlItem OE_ORDER_PUB_LINE_ADJ_ATT_REC)

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);

Line 493: RETURN OE_ORDER_PUB.LINE_ADJ_ATT_REC_TYPE IS

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;

Line 494: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ATT_REC_TYPE;

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;

Line 500: FUNCTION PL_TO_SQL17(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ATT_TBL_TYPE)

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);

Line 501: RETURN OE_ORDER_PUB_LINE_ADJ_ATT_TBL IS

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;

Line 502: aSqlItem OE_ORDER_PUB_LINE_ADJ_ATT_TBL;

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;

Line 508: FUNCTION SQL_TO_PL17(aSqlItem OE_ORDER_PUB_LINE_ADJ_ATT_TBL)

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);

Line 509: RETURN OE_ORDER_PUB.LINE_ADJ_ATT_TBL_TYPE IS

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;

Line 510: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ATT_TBL_TYPE;

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;

Line 516: FUNCTION PL_TO_SQL41(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_REC_TYPE)

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);

Line 517: RETURN OE_ORDER_PUB_LINE_ADJ_ASSOC_R IS

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;

Line 518: aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_R;

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;

Line 524: FUNCTION SQL_TO_PL41(aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_R)

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);

Line 525: RETURN OE_ORDER_PUB.LINE_ADJ_ASSOC_REC_TYPE IS

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;

Line 526: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_REC_TYPE;

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;

Line 532: FUNCTION PL_TO_SQL18(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE)

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);

Line 533: RETURN OE_ORDER_PUB_LINE_ADJ_ASSOC_T IS

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;

Line 534: aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_T;

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;

Line 540: FUNCTION SQL_TO_PL18(aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_T)

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);

Line 541: RETURN OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE IS

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;

Line 542: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE;

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;

Line 548: FUNCTION PL_TO_SQL42(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_REC_TYPE)

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);

Line 549: RETURN OE_ORDER_PUB_LINE_SCREDIT_REC IS

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;

Line 550: aSqlItem OE_ORDER_PUB_LINE_SCREDIT_REC;

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;

Line 556: FUNCTION SQL_TO_PL42(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_REC)

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);

Line 557: RETURN OE_ORDER_PUB.LINE_SCREDIT_REC_TYPE IS

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;

Line 558: aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_REC_TYPE;

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;

Line 564: FUNCTION PL_TO_SQL19(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE)

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);

Line 565: RETURN OE_ORDER_PUB_LINE_SCREDIT_TBL IS

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;

Line 566: aSqlItem OE_ORDER_PUB_LINE_SCREDIT_TBL;

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;

Line 572: FUNCTION SQL_TO_PL19(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_TBL)

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);

Line 573: RETURN OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE IS

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;

Line 574: aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE;

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;

Line 580: FUNCTION PL_TO_SQL43(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE)

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);

Line 581: RETURN OE_ORDER_PUB_LINE_SCREDIT_VA6 IS

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;

Line 582: aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VA6;

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;

Line 588: FUNCTION SQL_TO_PL43(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VA6)

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);

Line 589: RETURN OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE IS

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;

Line 590: aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE;

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;

Line 596: FUNCTION PL_TO_SQL20(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE)

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);

Line 597: RETURN OE_ORDER_PUB_LINE_SCREDIT_VAL IS

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;

Line 598: aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VAL;

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;

Line 604: FUNCTION SQL_TO_PL20(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VAL)

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);

Line 605: RETURN OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE IS

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;

Line 606: aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;

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;

Line 612: FUNCTION PL_TO_SQL44(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_REC_TYPE)

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);

Line 613: RETURN OE_ORDER_PUB_LINE_PAYMENT_REC IS

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;

Line 614: aSqlItem OE_ORDER_PUB_LINE_PAYMENT_REC;

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;

Line 620: FUNCTION SQL_TO_PL44(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_REC)

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);

Line 621: RETURN OE_ORDER_PUB.LINE_PAYMENT_REC_TYPE IS

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;

Line 622: aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_REC_TYPE;

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;

Line 629: FUNCTION PL_TO_SQL21(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE)

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);

Line 630: RETURN OE_ORDER_PUB_LINE_PAYMENT_TBL IS

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;

Line 631: aSqlItem OE_ORDER_PUB_LINE_PAYMENT_TBL;

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;

Line 637: FUNCTION SQL_TO_PL21(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_TBL)

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);

Line 638: RETURN OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE IS

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;

Line 639: aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE;

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;

Line 645: FUNCTION PL_TO_SQL45(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE)

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);

Line 646: RETURN OE_ORDER_PUB_LINE_PAYMENT_VA3 IS

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;

Line 647: aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VA3;

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;

Line 653: FUNCTION SQL_TO_PL45(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VA3)

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);

Line 654: RETURN OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE IS

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;

Line 655: aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE;

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;

Line 661: FUNCTION PL_TO_SQL22(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE)

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);

Line 662: RETURN OE_ORDER_PUB_LINE_PAYMENT_VAL IS

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;

Line 663: aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VAL;

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;

Line 670: FUNCTION SQL_TO_PL22(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VAL)

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);

Line 671: RETURN OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE IS

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;

Line 672: aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;

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;

Line 678: FUNCTION PL_TO_SQL46(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_REC_TYPE)

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);

Line 679: RETURN OE_ORDER_PUB_LOT_SERIAL_REC_T IS

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;

Line 680: aSqlItem OE_ORDER_PUB_LOT_SERIAL_REC_T;

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;

Line 686: FUNCTION SQL_TO_PL46(aSqlItem OE_ORDER_PUB_LOT_SERIAL_REC_T)

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);

Line 687: RETURN OE_ORDER_PUB.LOT_SERIAL_REC_TYPE IS

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;

Line 688: aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_REC_TYPE;

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;

Line 694: FUNCTION PL_TO_SQL23(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE)

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);

Line 695: RETURN OE_ORDER_PUB_LOT_SERIAL_TBL_T IS

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;

Line 696: aSqlItem OE_ORDER_PUB_LOT_SERIAL_TBL_T;

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;

Line 702: FUNCTION SQL_TO_PL23(aSqlItem OE_ORDER_PUB_LOT_SERIAL_TBL_T)

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);

Line 703: RETURN OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE IS

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;

Line 704: aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;

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;

Line 710: FUNCTION PL_TO_SQL47(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_REC_TYPE)

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);

Line 711: RETURN OE_ORDER_PUB_LOT_SERIAL_VAL_R IS

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;

Line 712: aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_R;

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;

Line 718: FUNCTION SQL_TO_PL47(aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_R)

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);

Line 719: RETURN OE_ORDER_PUB.LOT_SERIAL_VAL_REC_TYPE IS

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;

Line 720: aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_REC_TYPE;

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;

Line 726: FUNCTION PL_TO_SQL24(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE)

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);

Line 727: RETURN OE_ORDER_PUB_LOT_SERIAL_VAL_T IS

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;

Line 728: aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_T;

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;

Line 734: FUNCTION SQL_TO_PL24(aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_T)

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);

Line 735: RETURN OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE IS

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;

Line 736: aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;

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;

Line 742: FUNCTION PL_TO_SQL48(aPlsqlItem OE_ORDER_PUB.REQUEST_REC_TYPE)

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);

Line 743: RETURN OE_ORDER_PUB_REQUEST_REC_TYPE IS

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;

Line 744: aSqlItem OE_ORDER_PUB_REQUEST_REC_TYPE;

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;

Line 750: FUNCTION SQL_TO_PL48(aSqlItem OE_ORDER_PUB_REQUEST_REC_TYPE)

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);

Line 751: RETURN OE_ORDER_PUB.REQUEST_REC_TYPE IS

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;

Line 752: aPlsqlItem OE_ORDER_PUB.REQUEST_REC_TYPE;

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;

Line 758: FUNCTION PL_TO_SQL25(aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE)

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);

Line 759: RETURN OE_ORDER_PUB_REQUEST_TBL_TYPE IS

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;

Line 760: aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE;

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;

Line 766: FUNCTION SQL_TO_PL25(aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE)

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);

Line 767: RETURN OE_ORDER_PUB.REQUEST_TBL_TYPE IS

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;

Line 768: aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE;

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;

Line 775: PROCEDURE OE_ORDER_PUB$PROCESS_ORDER (

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,

Line 781: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,

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,

Line 782: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,

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,

Line 783: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_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,

Line 784: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_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,

Line 785: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_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,

Line 786: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,

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,

Line 787: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,

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,

Line 788: P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_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,

Line 789: P_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,

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,

Line 790: P_OLD_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,

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,

Line 791: P_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_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,
795: P_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,

Line 792: P_OLD_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_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,

Line 793: P_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,

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,

Line 794: P_OLD_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,

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,

Line 795: P_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,

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,

Line 796: P_OLD_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_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,

Line 797: P_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,

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,

Line 798: P_OLD_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_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,

Line 799: P_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,

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,

Line 800: P_OLD_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_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,
804: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,

Line 801: P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,

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,

Line 802: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_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,
806: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,

Line 803: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,

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,

Line 804: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,

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,

Line 805: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_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,

Line 806: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,

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,

Line 807: P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,

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,

Line 808: P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,

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,

Line 809: P_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,

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,

Line 810: P_OLD_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_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,

Line 811: P_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,

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,

Line 812: P_OLD_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_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,

Line 813: P_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,

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,

Line 814: P_OLD_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_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,

Line 815: P_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,

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,

Line 816: P_OLD_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_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,
820: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,

Line 817: P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,

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,

Line 818: P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_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,

Line 819: P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,

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,

Line 820: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_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,

Line 821: P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,

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,

Line 822: P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_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,
826: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,

Line 823: P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,

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,

Line 824: P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_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,
828: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,

Line 825: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_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,

Line 826: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,

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,

Line 827: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,

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,

Line 828: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_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,

Line 829: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,

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,

Line 830: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE,

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,

Line 831: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_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,
835: X_HEADER_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ATT_T,

Line 832: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_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,

Line 833: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_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,
837: X_HEADER_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_T,

Line 834: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT,

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,

Line 835: X_HEADER_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ATT_T,

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,

Line 836: X_HEADER_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ASSOC,

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,

Line 837: X_HEADER_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_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,
841: X_LINE_TBL OUT NOCOPY OE_ORDER_PUB_LINE_TBL_TYPE,

Line 838: X_HEADER_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_V,

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,

Line 839: X_HEADER_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_T,

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,

Line 840: X_HEADER_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_V,

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,

Line 841: X_LINE_TBL OUT NOCOPY OE_ORDER_PUB_LINE_TBL_TYPE,

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,

Line 842: X_LINE_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_VAL_TBL_TYP,

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,

Line 843: X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP,

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,

Line 844: X_LINE_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_VAL_TBL,

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,

Line 845: X_LINE_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PRICE_ATT_T,

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,

Line 846: X_LINE_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ATT_TBL,

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,

Line 847: X_LINE_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ASSOC_T,

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,

Line 848: X_LINE_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_TBL,

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,

Line 849: X_LINE_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_VAL,

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,

Line 850: X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL,

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,

Line 851: X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL,

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

Line 852: X_LOT_SERIAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_TBL_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
856: )

Line 853: X_LOT_SERIAL_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_VAL_T,

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

Line 854: X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE,

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

Line 944: END OE_ORDER_PUB$PROCESS_ORDER;

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)

Line 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);

Line 963: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type)

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);