DBA Data[Home] [Help]

APPS.DPP_BPEL_UPDATECOST dependencies on DPP_ITEMCOST_PVT_DPP_TXN_LINE

Line 105: FUNCTION PL_TO_SQL12(aPlsqlItem DPP_ITEMCOST_PVT.DPP_TXN_LINE_REC_TYPE)

101: aPlsqlItem(I) := SQL_TO_PL11(aSqlItem(I));
102: END LOOP;
103: RETURN aPlsqlItem;
104: END SQL_TO_PL12;
105: FUNCTION PL_TO_SQL12(aPlsqlItem DPP_ITEMCOST_PVT.DPP_TXN_LINE_REC_TYPE)
106: RETURN DPP_ITEMCOST_PVT_DPP_TXN_LIN7 IS
107: aSqlItem DPP_ITEMCOST_PVT_DPP_TXN_LIN7;
108: BEGIN
109: -- initialize the object

Line 141: RETURN DPP_ITEMCOST_PVT.DPP_TXN_LINE_REC_TYPE IS

137: aSqlItem.INV_ORG_DETAILS_TBL := PL_TO_SQL11(aPlsqlItem.INV_ORG_DETAILS_TBL);
138: RETURN aSqlItem;
139: END PL_TO_SQL12;
140: FUNCTION SQL_TO_PL13(aSqlItem DPP_ITEMCOST_PVT_DPP_TXN_LIN7)
141: RETURN DPP_ITEMCOST_PVT.DPP_TXN_LINE_REC_TYPE IS
142: aPlsqlItem DPP_ITEMCOST_PVT.DPP_TXN_LINE_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_ITEMCOST_PVT.DPP_TXN_LINE_REC_TYPE;

138: RETURN aSqlItem;
139: END PL_TO_SQL12;
140: FUNCTION SQL_TO_PL13(aSqlItem DPP_ITEMCOST_PVT_DPP_TXN_LIN7)
141: RETURN DPP_ITEMCOST_PVT.DPP_TXN_LINE_REC_TYPE IS
142: aPlsqlItem DPP_ITEMCOST_PVT.DPP_TXN_LINE_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 172: FUNCTION PL_TO_SQL13(aPlsqlItem DPP_ITEMCOST_PVT.DPP_TXN_LINE_TBL_TYPE)

168: aPlsqlItem.REASON_FOR_FAILURE := aSqlItem.REASON_FOR_FAILURE;
169: aPlsqlItem.INV_ORG_DETAILS_TBL := SQL_TO_PL12(aSqlItem.INV_ORG_DETAILS_TBL);
170: RETURN aPlsqlItem;
171: END SQL_TO_PL13;
172: FUNCTION PL_TO_SQL13(aPlsqlItem DPP_ITEMCOST_PVT.DPP_TXN_LINE_TBL_TYPE)
173: RETURN DPP_ITEMCOST_PVT_DPP_TXN_LINE IS
174: aSqlItem DPP_ITEMCOST_PVT_DPP_TXN_LINE;
175: BEGIN
176: -- initialize the table

Line 173: RETURN DPP_ITEMCOST_PVT_DPP_TXN_LINE IS

169: aPlsqlItem.INV_ORG_DETAILS_TBL := SQL_TO_PL12(aSqlItem.INV_ORG_DETAILS_TBL);
170: RETURN aPlsqlItem;
171: END SQL_TO_PL13;
172: FUNCTION PL_TO_SQL13(aPlsqlItem DPP_ITEMCOST_PVT.DPP_TXN_LINE_TBL_TYPE)
173: RETURN DPP_ITEMCOST_PVT_DPP_TXN_LINE IS
174: aSqlItem DPP_ITEMCOST_PVT_DPP_TXN_LINE;
175: BEGIN
176: -- initialize the table
177: aSqlItem := DPP_ITEMCOST_PVT_DPP_TXN_LINE();

Line 174: aSqlItem DPP_ITEMCOST_PVT_DPP_TXN_LINE;

170: RETURN aPlsqlItem;
171: END SQL_TO_PL13;
172: FUNCTION PL_TO_SQL13(aPlsqlItem DPP_ITEMCOST_PVT.DPP_TXN_LINE_TBL_TYPE)
173: RETURN DPP_ITEMCOST_PVT_DPP_TXN_LINE IS
174: aSqlItem DPP_ITEMCOST_PVT_DPP_TXN_LINE;
175: BEGIN
176: -- initialize the table
177: aSqlItem := DPP_ITEMCOST_PVT_DPP_TXN_LINE();
178: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 177: aSqlItem := DPP_ITEMCOST_PVT_DPP_TXN_LINE();

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

Line 184: FUNCTION SQL_TO_PL10(aSqlItem DPP_ITEMCOST_PVT_DPP_TXN_LINE)

180: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL12(aPlsqlItem(I));
181: END LOOP;
182: RETURN aSqlItem;
183: END PL_TO_SQL13;
184: FUNCTION SQL_TO_PL10(aSqlItem DPP_ITEMCOST_PVT_DPP_TXN_LINE)
185: RETURN DPP_ITEMCOST_PVT.DPP_TXN_LINE_TBL_TYPE IS
186: aPlsqlItem DPP_ITEMCOST_PVT.DPP_TXN_LINE_TBL_TYPE;
187: BEGIN
188: FOR I IN 1..aSqlItem.COUNT LOOP

Line 185: RETURN DPP_ITEMCOST_PVT.DPP_TXN_LINE_TBL_TYPE IS

181: END LOOP;
182: RETURN aSqlItem;
183: END PL_TO_SQL13;
184: FUNCTION SQL_TO_PL10(aSqlItem DPP_ITEMCOST_PVT_DPP_TXN_LINE)
185: RETURN DPP_ITEMCOST_PVT.DPP_TXN_LINE_TBL_TYPE IS
186: aPlsqlItem DPP_ITEMCOST_PVT.DPP_TXN_LINE_TBL_TYPE;
187: BEGIN
188: FOR I IN 1..aSqlItem.COUNT LOOP
189: aPlsqlItem(I) := SQL_TO_PL13(aSqlItem(I));

Line 186: aPlsqlItem DPP_ITEMCOST_PVT.DPP_TXN_LINE_TBL_TYPE;

182: RETURN aSqlItem;
183: END PL_TO_SQL13;
184: FUNCTION SQL_TO_PL10(aSqlItem DPP_ITEMCOST_PVT_DPP_TXN_LINE)
185: RETURN DPP_ITEMCOST_PVT.DPP_TXN_LINE_TBL_TYPE IS
186: aPlsqlItem DPP_ITEMCOST_PVT.DPP_TXN_LINE_TBL_TYPE;
187: BEGIN
188: FOR I IN 1..aSqlItem.COUNT LOOP
189: aPlsqlItem(I) := SQL_TO_PL13(aSqlItem(I));
190: END LOOP;

Line 196: P_ITEM_COST_TBL DPP_ITEMCOST_PVT_DPP_TXN_LINE) IS

192: END SQL_TO_PL10;
193:
194: PROCEDURE DPP_ITEMCOST_PVT$UPDATE_ITEMC (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,P_VALIDATION_LEVEL NUMBER,
195: X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,X_MSG_DATA OUT NOCOPY VARCHAR2,P_TXN_HDR_REC DPP_ITEMCOST_PVT_DPP_CST_HDR_,
196: P_ITEM_COST_TBL DPP_ITEMCOST_PVT_DPP_TXN_LINE) IS
197: P_TXN_HDR_REC_ APPS.DPP_ITEMCOST_PVT.DPP_CST_HDR_REC_TYPE;
198: P_ITEM_COST_TBL_ APPS.DPP_ITEMCOST_PVT.DPP_TXN_LINE_TBL_TYPE;
199: BEGIN
200: P_TXN_HDR_REC_ := DPP_BPEL_UPDATECOST.SQL_TO_PL9(P_TXN_HDR_REC);

Line 198: P_ITEM_COST_TBL_ APPS.DPP_ITEMCOST_PVT.DPP_TXN_LINE_TBL_TYPE;

194: PROCEDURE DPP_ITEMCOST_PVT$UPDATE_ITEMC (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,P_VALIDATION_LEVEL NUMBER,
195: X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,X_MSG_DATA OUT NOCOPY VARCHAR2,P_TXN_HDR_REC DPP_ITEMCOST_PVT_DPP_CST_HDR_,
196: P_ITEM_COST_TBL DPP_ITEMCOST_PVT_DPP_TXN_LINE) IS
197: P_TXN_HDR_REC_ APPS.DPP_ITEMCOST_PVT.DPP_CST_HDR_REC_TYPE;
198: P_ITEM_COST_TBL_ APPS.DPP_ITEMCOST_PVT.DPP_TXN_LINE_TBL_TYPE;
199: BEGIN
200: P_TXN_HDR_REC_ := DPP_BPEL_UPDATECOST.SQL_TO_PL9(P_TXN_HDR_REC);
201: P_ITEM_COST_TBL_ := DPP_BPEL_UPDATECOST.SQL_TO_PL10(P_ITEM_COST_TBL);
202: APPS.DPP_ITEMCOST_PVT.UPDATE_ITEMCOST(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA,P_TXN_HDR_REC_,P_ITEM_COST_TBL_);