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_DPP_ITE

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