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.DPP_BPEL_UPDATEPO dependencies on DPP_PURCHASEPRICE_PVT

Line 3: FUNCTION PL_TO_SQL14(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_TXN_HDR_REC_TYPE)

1: PACKAGE BODY DPP_BPEL_UPDATEPO AS
2: /* $Header: dppvbudb.pls 120.3 2007/12/18 13:18:00 assoni noship $ */
3: FUNCTION PL_TO_SQL14(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_TXN_HDR_REC_TYPE)
4: RETURN DPP_PURCHASEPRICE_PVT_DPP_TXN IS
5: aSqlItem DPP_PURCHASEPRICE_PVT_DPP_TXN;
6: BEGIN
7: -- initialize the object

Line 4: RETURN DPP_PURCHASEPRICE_PVT_DPP_TXN IS

1: PACKAGE BODY DPP_BPEL_UPDATEPO AS
2: /* $Header: dppvbudb.pls 120.3 2007/12/18 13:18:00 assoni noship $ */
3: FUNCTION PL_TO_SQL14(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_TXN_HDR_REC_TYPE)
4: RETURN DPP_PURCHASEPRICE_PVT_DPP_TXN IS
5: aSqlItem DPP_PURCHASEPRICE_PVT_DPP_TXN;
6: BEGIN
7: -- initialize the object
8: aSqlItem := DPP_PURCHASEPRICE_PVT_DPP_TXN(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

Line 5: aSqlItem DPP_PURCHASEPRICE_PVT_DPP_TXN;

1: PACKAGE BODY DPP_BPEL_UPDATEPO AS
2: /* $Header: dppvbudb.pls 120.3 2007/12/18 13:18:00 assoni noship $ */
3: FUNCTION PL_TO_SQL14(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_TXN_HDR_REC_TYPE)
4: RETURN DPP_PURCHASEPRICE_PVT_DPP_TXN IS
5: aSqlItem DPP_PURCHASEPRICE_PVT_DPP_TXN;
6: BEGIN
7: -- initialize the object
8: aSqlItem := DPP_PURCHASEPRICE_PVT_DPP_TXN(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
9: aSqlItem.TRANSACTION_HEADER_ID := aPlsqlItem.TRANSACTION_HEADER_ID;

Line 8: aSqlItem := DPP_PURCHASEPRICE_PVT_DPP_TXN(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

4: RETURN DPP_PURCHASEPRICE_PVT_DPP_TXN IS
5: aSqlItem DPP_PURCHASEPRICE_PVT_DPP_TXN;
6: BEGIN
7: -- initialize the object
8: aSqlItem := DPP_PURCHASEPRICE_PVT_DPP_TXN(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
9: aSqlItem.TRANSACTION_HEADER_ID := aPlsqlItem.TRANSACTION_HEADER_ID;
10: aSqlItem.TRANSACTION_NUMBER := aPlsqlItem.TRANSACTION_NUMBER;
11: aSqlItem.ORG_ID := aPlsqlItem.ORG_ID;
12: aSqlItem.VENDOR_ID := aPlsqlItem.VENDOR_ID;

Line 35: FUNCTION SQL_TO_PL14(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_TXN)

31: aSqlItem.ATTRIBUTE14 := aPlsqlItem.ATTRIBUTE14;
32: aSqlItem.ATTRIBUTE15 := aPlsqlItem.ATTRIBUTE15;
33: RETURN aSqlItem;
34: END PL_TO_SQL14;
35: FUNCTION SQL_TO_PL14(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_TXN)
36: RETURN DPP_PURCHASEPRICE_PVT.DPP_TXN_HDR_REC_TYPE IS
37: aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_TXN_HDR_REC_TYPE;
38: BEGIN
39: aPlsqlItem.TRANSACTION_HEADER_ID := aSqlItem.TRANSACTION_HEADER_ID;

Line 36: RETURN DPP_PURCHASEPRICE_PVT.DPP_TXN_HDR_REC_TYPE IS

32: aSqlItem.ATTRIBUTE15 := aPlsqlItem.ATTRIBUTE15;
33: RETURN aSqlItem;
34: END PL_TO_SQL14;
35: FUNCTION SQL_TO_PL14(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_TXN)
36: RETURN DPP_PURCHASEPRICE_PVT.DPP_TXN_HDR_REC_TYPE IS
37: aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_TXN_HDR_REC_TYPE;
38: BEGIN
39: aPlsqlItem.TRANSACTION_HEADER_ID := aSqlItem.TRANSACTION_HEADER_ID;
40: aPlsqlItem.TRANSACTION_NUMBER := aSqlItem.TRANSACTION_NUMBER;

Line 37: aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_TXN_HDR_REC_TYPE;

33: RETURN aSqlItem;
34: END PL_TO_SQL14;
35: FUNCTION SQL_TO_PL14(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_TXN)
36: RETURN DPP_PURCHASEPRICE_PVT.DPP_TXN_HDR_REC_TYPE IS
37: aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_TXN_HDR_REC_TYPE;
38: BEGIN
39: aPlsqlItem.TRANSACTION_HEADER_ID := aSqlItem.TRANSACTION_HEADER_ID;
40: aPlsqlItem.TRANSACTION_NUMBER := aSqlItem.TRANSACTION_NUMBER;
41: aPlsqlItem.ORG_ID := aSqlItem.ORG_ID;

Line 65: FUNCTION PL_TO_SQL15(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_LINE_REC_TYPE)

61: aPlsqlItem.ATTRIBUTE14 := aSqlItem.ATTRIBUTE14;
62: aPlsqlItem.ATTRIBUTE15 := aSqlItem.ATTRIBUTE15;
63: RETURN aPlsqlItem;
64: END SQL_TO_PL14;
65: FUNCTION PL_TO_SQL15(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_LINE_REC_TYPE)
66: RETURN DPP_PURCHASEPRICE_PVT_DPP_P20 IS
67: aSqlItem DPP_PURCHASEPRICE_PVT_DPP_P20;
68: BEGIN
69: -- initialize the object

Line 66: RETURN DPP_PURCHASEPRICE_PVT_DPP_P20 IS

62: aPlsqlItem.ATTRIBUTE15 := aSqlItem.ATTRIBUTE15;
63: RETURN aPlsqlItem;
64: END SQL_TO_PL14;
65: FUNCTION PL_TO_SQL15(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_LINE_REC_TYPE)
66: RETURN DPP_PURCHASEPRICE_PVT_DPP_P20 IS
67: aSqlItem DPP_PURCHASEPRICE_PVT_DPP_P20;
68: BEGIN
69: -- initialize the object
70: aSqlItem := DPP_PURCHASEPRICE_PVT_DPP_P20(NULL, NULL, NULL, NULL);

Line 67: aSqlItem DPP_PURCHASEPRICE_PVT_DPP_P20;

63: RETURN aPlsqlItem;
64: END SQL_TO_PL14;
65: FUNCTION PL_TO_SQL15(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_LINE_REC_TYPE)
66: RETURN DPP_PURCHASEPRICE_PVT_DPP_P20 IS
67: aSqlItem DPP_PURCHASEPRICE_PVT_DPP_P20;
68: BEGIN
69: -- initialize the object
70: aSqlItem := DPP_PURCHASEPRICE_PVT_DPP_P20(NULL, NULL, NULL, NULL);
71: aSqlItem.DOCUMENT_NUMBER := aPlsqlItem.DOCUMENT_NUMBER;

Line 70: aSqlItem := DPP_PURCHASEPRICE_PVT_DPP_P20(NULL, NULL, NULL, NULL);

66: RETURN DPP_PURCHASEPRICE_PVT_DPP_P20 IS
67: aSqlItem DPP_PURCHASEPRICE_PVT_DPP_P20;
68: BEGIN
69: -- initialize the object
70: aSqlItem := DPP_PURCHASEPRICE_PVT_DPP_P20(NULL, NULL, NULL, NULL);
71: aSqlItem.DOCUMENT_NUMBER := aPlsqlItem.DOCUMENT_NUMBER;
72: aSqlItem.DOCUMENT_TYPE := aPlsqlItem.DOCUMENT_TYPE;
73: aSqlItem.LINE_NUMBER := aPlsqlItem.LINE_NUMBER;
74: aSqlItem.REASON_FOR_FAILURE := aPlsqlItem.REASON_FOR_FAILURE;

Line 77: FUNCTION SQL_TO_PL16(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_P20)

73: aSqlItem.LINE_NUMBER := aPlsqlItem.LINE_NUMBER;
74: aSqlItem.REASON_FOR_FAILURE := aPlsqlItem.REASON_FOR_FAILURE;
75: RETURN aSqlItem;
76: END PL_TO_SQL15;
77: FUNCTION SQL_TO_PL16(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_P20)
78: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_LINE_REC_TYPE IS
79: aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_LINE_REC_TYPE;
80: BEGIN
81: aPlsqlItem.DOCUMENT_NUMBER := aSqlItem.DOCUMENT_NUMBER;

Line 78: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_LINE_REC_TYPE IS

74: aSqlItem.REASON_FOR_FAILURE := aPlsqlItem.REASON_FOR_FAILURE;
75: RETURN aSqlItem;
76: END PL_TO_SQL15;
77: FUNCTION SQL_TO_PL16(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_P20)
78: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_LINE_REC_TYPE IS
79: aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_LINE_REC_TYPE;
80: BEGIN
81: aPlsqlItem.DOCUMENT_NUMBER := aSqlItem.DOCUMENT_NUMBER;
82: aPlsqlItem.DOCUMENT_TYPE := aSqlItem.DOCUMENT_TYPE;

Line 79: aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_LINE_REC_TYPE;

75: RETURN aSqlItem;
76: END PL_TO_SQL15;
77: FUNCTION SQL_TO_PL16(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_P20)
78: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_LINE_REC_TYPE IS
79: aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_LINE_REC_TYPE;
80: BEGIN
81: aPlsqlItem.DOCUMENT_NUMBER := aSqlItem.DOCUMENT_NUMBER;
82: aPlsqlItem.DOCUMENT_TYPE := aSqlItem.DOCUMENT_TYPE;
83: aPlsqlItem.LINE_NUMBER := aSqlItem.LINE_NUMBER;

Line 87: FUNCTION PL_TO_SQL16(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_LINE_TBL_TYPE)

83: aPlsqlItem.LINE_NUMBER := aSqlItem.LINE_NUMBER;
84: aPlsqlItem.REASON_FOR_FAILURE := aSqlItem.REASON_FOR_FAILURE;
85: RETURN aPlsqlItem;
86: END SQL_TO_PL16;
87: FUNCTION PL_TO_SQL16(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_LINE_TBL_TYPE)
88: RETURN DPPPURCHASEPRICEPVTDPPIT9_DPP IS
89: aSqlItem DPPPURCHASEPRICEPVTDPPIT9_DPP;
90: BEGIN
91: -- initialize the table

Line 100: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_LINE_TBL_TYPE IS

96: END LOOP;
97: RETURN aSqlItem;
98: END PL_TO_SQL16;
99: FUNCTION SQL_TO_PL17(aSqlItem DPPPURCHASEPRICEPVTDPPIT9_DPP)
100: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_LINE_TBL_TYPE IS
101: aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_LINE_TBL_TYPE;
102: BEGIN
103: FOR I IN 1..aSqlItem.COUNT LOOP
104: aPlsqlItem(I) := SQL_TO_PL16(aSqlItem(I));

Line 101: aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_LINE_TBL_TYPE;

97: RETURN aSqlItem;
98: END PL_TO_SQL16;
99: FUNCTION SQL_TO_PL17(aSqlItem DPPPURCHASEPRICEPVTDPPIT9_DPP)
100: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_LINE_TBL_TYPE IS
101: aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_LINE_TBL_TYPE;
102: BEGIN
103: FOR I IN 1..aSqlItem.COUNT LOOP
104: aPlsqlItem(I) := SQL_TO_PL16(aSqlItem(I));
105: END LOOP;

Line 108: FUNCTION PL_TO_SQL17(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_ITEM_COST_REC_TYPE)

104: aPlsqlItem(I) := SQL_TO_PL16(aSqlItem(I));
105: END LOOP;
106: RETURN aPlsqlItem;
107: END SQL_TO_PL17;
108: FUNCTION PL_TO_SQL17(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_ITEM_COST_REC_TYPE)
109: RETURN DPP_PURCHASEPRICE_PVT_DPP_IT9 IS
110: aSqlItem DPP_PURCHASEPRICE_PVT_DPP_IT9;
111: BEGIN
112: -- initialize the object

Line 109: RETURN DPP_PURCHASEPRICE_PVT_DPP_IT9 IS

105: END LOOP;
106: RETURN aPlsqlItem;
107: END SQL_TO_PL17;
108: FUNCTION PL_TO_SQL17(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_ITEM_COST_REC_TYPE)
109: RETURN DPP_PURCHASEPRICE_PVT_DPP_IT9 IS
110: aSqlItem DPP_PURCHASEPRICE_PVT_DPP_IT9;
111: BEGIN
112: -- initialize the object
113: aSqlItem := DPP_PURCHASEPRICE_PVT_DPP_IT9(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

Line 110: aSqlItem DPP_PURCHASEPRICE_PVT_DPP_IT9;

106: RETURN aPlsqlItem;
107: END SQL_TO_PL17;
108: FUNCTION PL_TO_SQL17(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_ITEM_COST_REC_TYPE)
109: RETURN DPP_PURCHASEPRICE_PVT_DPP_IT9 IS
110: aSqlItem DPP_PURCHASEPRICE_PVT_DPP_IT9;
111: BEGIN
112: -- initialize the object
113: aSqlItem := DPP_PURCHASEPRICE_PVT_DPP_IT9(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
114: aSqlItem.TRANSACTION_LINE_ID := aPlsqlItem.TRANSACTION_LINE_ID;

Line 113: aSqlItem := DPP_PURCHASEPRICE_PVT_DPP_IT9(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

109: RETURN DPP_PURCHASEPRICE_PVT_DPP_IT9 IS
110: aSqlItem DPP_PURCHASEPRICE_PVT_DPP_IT9;
111: BEGIN
112: -- initialize the object
113: aSqlItem := DPP_PURCHASEPRICE_PVT_DPP_IT9(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
114: aSqlItem.TRANSACTION_LINE_ID := aPlsqlItem.TRANSACTION_LINE_ID;
115: aSqlItem.INVENTORY_ITEM_ID := aPlsqlItem.INVENTORY_ITEM_ID;
116: aSqlItem.ITEM_NUMBER := aPlsqlItem.ITEM_NUMBER;
117: aSqlItem.NEW_PRICE := aPlsqlItem.NEW_PRICE;

Line 140: FUNCTION SQL_TO_PL18(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_IT9)

136: aSqlItem.ATTRIBUTE15 := aPlsqlItem.ATTRIBUTE15;
137: aSqlItem.UPDATE_STATUS := aPlsqlItem.UPDATE_STATUS;
138: RETURN aSqlItem;
139: END PL_TO_SQL17;
140: FUNCTION SQL_TO_PL18(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_IT9)
141: RETURN DPP_PURCHASEPRICE_PVT.DPP_ITEM_COST_REC_TYPE IS
142: aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_ITEM_COST_REC_TYPE;
143: BEGIN
144: aPlsqlItem.TRANSACTION_LINE_ID := aSqlItem.TRANSACTION_LINE_ID;

Line 141: RETURN DPP_PURCHASEPRICE_PVT.DPP_ITEM_COST_REC_TYPE IS

137: aSqlItem.UPDATE_STATUS := aPlsqlItem.UPDATE_STATUS;
138: RETURN aSqlItem;
139: END PL_TO_SQL17;
140: FUNCTION SQL_TO_PL18(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_IT9)
141: RETURN DPP_PURCHASEPRICE_PVT.DPP_ITEM_COST_REC_TYPE IS
142: aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_ITEM_COST_REC_TYPE;
143: BEGIN
144: aPlsqlItem.TRANSACTION_LINE_ID := aSqlItem.TRANSACTION_LINE_ID;
145: aPlsqlItem.INVENTORY_ITEM_ID := aSqlItem.INVENTORY_ITEM_ID;

Line 142: aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_ITEM_COST_REC_TYPE;

138: RETURN aSqlItem;
139: END PL_TO_SQL17;
140: FUNCTION SQL_TO_PL18(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_IT9)
141: RETURN DPP_PURCHASEPRICE_PVT.DPP_ITEM_COST_REC_TYPE IS
142: aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_ITEM_COST_REC_TYPE;
143: BEGIN
144: aPlsqlItem.TRANSACTION_LINE_ID := aSqlItem.TRANSACTION_LINE_ID;
145: aPlsqlItem.INVENTORY_ITEM_ID := aSqlItem.INVENTORY_ITEM_ID;
146: aPlsqlItem.ITEM_NUMBER := aSqlItem.ITEM_NUMBER;

Line 170: FUNCTION PL_TO_SQL18(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_ITEM_COST_TBL_TYPE)

166: aPlsqlItem.ATTRIBUTE15 := aSqlItem.ATTRIBUTE15;
167: aPlsqlItem.UPDATE_STATUS := aSqlItem.UPDATE_STATUS;
168: RETURN aPlsqlItem;
169: END SQL_TO_PL18;
170: FUNCTION PL_TO_SQL18(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_ITEM_COST_TBL_TYPE)
171: RETURN DPP_PURCHASEPRICE_PVT_DPP_ITE IS
172: aSqlItem DPP_PURCHASEPRICE_PVT_DPP_ITE;
173: BEGIN
174: -- initialize the table

Line 171: RETURN DPP_PURCHASEPRICE_PVT_DPP_ITE IS

167: aPlsqlItem.UPDATE_STATUS := aSqlItem.UPDATE_STATUS;
168: RETURN aPlsqlItem;
169: END SQL_TO_PL18;
170: FUNCTION PL_TO_SQL18(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_ITEM_COST_TBL_TYPE)
171: RETURN DPP_PURCHASEPRICE_PVT_DPP_ITE IS
172: aSqlItem DPP_PURCHASEPRICE_PVT_DPP_ITE;
173: BEGIN
174: -- initialize the table
175: aSqlItem := DPP_PURCHASEPRICE_PVT_DPP_ITE();

Line 172: aSqlItem DPP_PURCHASEPRICE_PVT_DPP_ITE;

168: RETURN aPlsqlItem;
169: END SQL_TO_PL18;
170: FUNCTION PL_TO_SQL18(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_ITEM_COST_TBL_TYPE)
171: RETURN DPP_PURCHASEPRICE_PVT_DPP_ITE IS
172: aSqlItem DPP_PURCHASEPRICE_PVT_DPP_ITE;
173: BEGIN
174: -- initialize the table
175: aSqlItem := DPP_PURCHASEPRICE_PVT_DPP_ITE();
176: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 175: aSqlItem := DPP_PURCHASEPRICE_PVT_DPP_ITE();

171: RETURN DPP_PURCHASEPRICE_PVT_DPP_ITE IS
172: aSqlItem DPP_PURCHASEPRICE_PVT_DPP_ITE;
173: BEGIN
174: -- initialize the table
175: aSqlItem := DPP_PURCHASEPRICE_PVT_DPP_ITE();
176: aSqlItem.EXTEND(aPlsqlItem.COUNT);
177: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
178: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL17(aPlsqlItem(I));
179: END LOOP;

Line 182: FUNCTION SQL_TO_PL15(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_ITE)

178: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL17(aPlsqlItem(I));
179: END LOOP;
180: RETURN aSqlItem;
181: END PL_TO_SQL18;
182: FUNCTION SQL_TO_PL15(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_ITE)
183: RETURN DPP_PURCHASEPRICE_PVT.DPP_ITEM_COST_TBL_TYPE IS
184: aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_ITEM_COST_TBL_TYPE;
185: BEGIN
186: FOR I IN 1..aSqlItem.COUNT LOOP

Line 183: RETURN DPP_PURCHASEPRICE_PVT.DPP_ITEM_COST_TBL_TYPE IS

179: END LOOP;
180: RETURN aSqlItem;
181: END PL_TO_SQL18;
182: FUNCTION SQL_TO_PL15(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_ITE)
183: RETURN DPP_PURCHASEPRICE_PVT.DPP_ITEM_COST_TBL_TYPE IS
184: aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_ITEM_COST_TBL_TYPE;
185: BEGIN
186: FOR I IN 1..aSqlItem.COUNT LOOP
187: aPlsqlItem(I) := SQL_TO_PL18(aSqlItem(I));

Line 184: aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_ITEM_COST_TBL_TYPE;

180: RETURN aSqlItem;
181: END PL_TO_SQL18;
182: FUNCTION SQL_TO_PL15(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_ITE)
183: RETURN DPP_PURCHASEPRICE_PVT.DPP_ITEM_COST_TBL_TYPE IS
184: aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_ITEM_COST_TBL_TYPE;
185: BEGIN
186: FOR I IN 1..aSqlItem.COUNT LOOP
187: aPlsqlItem(I) := SQL_TO_PL18(aSqlItem(I));
188: END LOOP;

Line 192: PROCEDURE DPP_PURCHASEPRICE_PVT$UPDATE_ (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,

188: END LOOP;
189: RETURN aPlsqlItem;
190: END SQL_TO_PL15;
191:
192: PROCEDURE DPP_PURCHASEPRICE_PVT$UPDATE_ (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,
193: P_VALIDATION_LEVEL NUMBER,X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,
194: X_MSG_DATA OUT NOCOPY VARCHAR2,P_ITEM_PRICE_REC DPP_PURCHASEPRICE_PVT_DPP_TXN,P_ITEM_COST_TBL DPP_PURCHASEPRICE_PVT_DPP_ITE) IS
195: P_ITEM_PRICE_REC_ DPP_PURCHASEPRICE_PVT.DPP_TXN_HDR_REC_TYPE;
196: P_ITEM_COST_TBL_ DPP_PURCHASEPRICE_PVT.DPP_ITEM_COST_TBL_TYPE;

Line 194: X_MSG_DATA OUT NOCOPY VARCHAR2,P_ITEM_PRICE_REC DPP_PURCHASEPRICE_PVT_DPP_TXN,P_ITEM_COST_TBL DPP_PURCHASEPRICE_PVT_DPP_ITE) IS

190: END SQL_TO_PL15;
191:
192: PROCEDURE DPP_PURCHASEPRICE_PVT$UPDATE_ (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,
193: P_VALIDATION_LEVEL NUMBER,X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,
194: X_MSG_DATA OUT NOCOPY VARCHAR2,P_ITEM_PRICE_REC DPP_PURCHASEPRICE_PVT_DPP_TXN,P_ITEM_COST_TBL DPP_PURCHASEPRICE_PVT_DPP_ITE) IS
195: P_ITEM_PRICE_REC_ DPP_PURCHASEPRICE_PVT.DPP_TXN_HDR_REC_TYPE;
196: P_ITEM_COST_TBL_ DPP_PURCHASEPRICE_PVT.DPP_ITEM_COST_TBL_TYPE;
197: BEGIN
198: P_ITEM_PRICE_REC_ := DPP_BPEL_UPDATEPO.SQL_TO_PL14(P_ITEM_PRICE_REC);

Line 195: P_ITEM_PRICE_REC_ DPP_PURCHASEPRICE_PVT.DPP_TXN_HDR_REC_TYPE;

191:
192: PROCEDURE DPP_PURCHASEPRICE_PVT$UPDATE_ (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,
193: P_VALIDATION_LEVEL NUMBER,X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,
194: X_MSG_DATA OUT NOCOPY VARCHAR2,P_ITEM_PRICE_REC DPP_PURCHASEPRICE_PVT_DPP_TXN,P_ITEM_COST_TBL DPP_PURCHASEPRICE_PVT_DPP_ITE) IS
195: P_ITEM_PRICE_REC_ DPP_PURCHASEPRICE_PVT.DPP_TXN_HDR_REC_TYPE;
196: P_ITEM_COST_TBL_ DPP_PURCHASEPRICE_PVT.DPP_ITEM_COST_TBL_TYPE;
197: BEGIN
198: P_ITEM_PRICE_REC_ := DPP_BPEL_UPDATEPO.SQL_TO_PL14(P_ITEM_PRICE_REC);
199: P_ITEM_COST_TBL_ := DPP_BPEL_UPDATEPO.SQL_TO_PL15(P_ITEM_COST_TBL);

Line 196: P_ITEM_COST_TBL_ DPP_PURCHASEPRICE_PVT.DPP_ITEM_COST_TBL_TYPE;

192: PROCEDURE DPP_PURCHASEPRICE_PVT$UPDATE_ (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,
193: P_VALIDATION_LEVEL NUMBER,X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,
194: X_MSG_DATA OUT NOCOPY VARCHAR2,P_ITEM_PRICE_REC DPP_PURCHASEPRICE_PVT_DPP_TXN,P_ITEM_COST_TBL DPP_PURCHASEPRICE_PVT_DPP_ITE) IS
195: P_ITEM_PRICE_REC_ DPP_PURCHASEPRICE_PVT.DPP_TXN_HDR_REC_TYPE;
196: P_ITEM_COST_TBL_ DPP_PURCHASEPRICE_PVT.DPP_ITEM_COST_TBL_TYPE;
197: BEGIN
198: P_ITEM_PRICE_REC_ := DPP_BPEL_UPDATEPO.SQL_TO_PL14(P_ITEM_PRICE_REC);
199: P_ITEM_COST_TBL_ := DPP_BPEL_UPDATEPO.SQL_TO_PL15(P_ITEM_COST_TBL);
200: DPP_PURCHASEPRICE_PVT.UPDATE_PURCHASEPRICE(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA,P_ITEM_PRICE_REC_,P_ITEM_COST_TBL_);

Line 200: DPP_PURCHASEPRICE_PVT.UPDATE_PURCHASEPRICE(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA,P_ITEM_PRICE_REC_,P_ITEM_COST_TBL_);

196: P_ITEM_COST_TBL_ DPP_PURCHASEPRICE_PVT.DPP_ITEM_COST_TBL_TYPE;
197: BEGIN
198: P_ITEM_PRICE_REC_ := DPP_BPEL_UPDATEPO.SQL_TO_PL14(P_ITEM_PRICE_REC);
199: P_ITEM_COST_TBL_ := DPP_BPEL_UPDATEPO.SQL_TO_PL15(P_ITEM_COST_TBL);
200: DPP_PURCHASEPRICE_PVT.UPDATE_PURCHASEPRICE(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA,P_ITEM_PRICE_REC_,P_ITEM_COST_TBL_);
201: END DPP_PURCHASEPRICE_PVT$UPDATE_;
202:
203: END DPP_BPEL_UPDATEPO;

Line 201: END DPP_PURCHASEPRICE_PVT$UPDATE_;

197: BEGIN
198: P_ITEM_PRICE_REC_ := DPP_BPEL_UPDATEPO.SQL_TO_PL14(P_ITEM_PRICE_REC);
199: P_ITEM_COST_TBL_ := DPP_BPEL_UPDATEPO.SQL_TO_PL15(P_ITEM_COST_TBL);
200: DPP_PURCHASEPRICE_PVT.UPDATE_PURCHASEPRICE(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA,P_ITEM_PRICE_REC_,P_ITEM_COST_TBL_);
201: END DPP_PURCHASEPRICE_PVT$UPDATE_;
202:
203: END DPP_BPEL_UPDATEPO;