APPS.DPP_BPEL_UPDATELISTPRICE dependencies on DPP_LISTPRICE_PVT_DPP_TXN_L13

Line 130: RETURN DPP_LISTPRICE_PVT_DPP_TXN_L13 IS

126: aPlsqlItem.REASON_FOR_FAILURE := aSqlItem.REASON_FOR_FAILURE;
127: RETURN aPlsqlItem;
128: END SQL_TO_PL24;
129: FUNCTION PL_TO_SQL24(aPlsqlItem DPP_LISTPRICE_PVT.DPP_TXN_LINE_TBL_TYPE)
130: RETURN DPP_LISTPRICE_PVT_DPP_TXN_L13 IS
131: aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_L13;
132: BEGIN
133: -- initialize the table
134: aSqlItem := DPP_LISTPRICE_PVT_DPP_TXN_L13();

Line 131: aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_L13;

127: RETURN aPlsqlItem;
128: END SQL_TO_PL24;
129: FUNCTION PL_TO_SQL24(aPlsqlItem DPP_LISTPRICE_PVT.DPP_TXN_LINE_TBL_TYPE)
130: RETURN DPP_LISTPRICE_PVT_DPP_TXN_L13 IS
131: aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_L13;
132: BEGIN
133: -- initialize the table
134: aSqlItem := DPP_LISTPRICE_PVT_DPP_TXN_L13();
135: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 134: aSqlItem := DPP_LISTPRICE_PVT_DPP_TXN_L13();

130: RETURN DPP_LISTPRICE_PVT_DPP_TXN_L13 IS
131: aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_L13;
132: BEGIN
133: -- initialize the table
134: aSqlItem := DPP_LISTPRICE_PVT_DPP_TXN_L13();
135: aSqlItem.EXTEND(aPlsqlItem.COUNT);
136: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
137: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL23(aPlsqlItem(I));
138: END LOOP;

Line 141: FUNCTION SQL_TO_PL23(aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_L13)

137: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL23(aPlsqlItem(I));
138: END LOOP;
139: RETURN aSqlItem;
140: END PL_TO_SQL24;
141: FUNCTION SQL_TO_PL23(aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_L13)
142: RETURN DPP_LISTPRICE_PVT.DPP_TXN_LINE_TBL_TYPE IS
143: aPlsqlItem DPP_LISTPRICE_PVT.DPP_TXN_LINE_TBL_TYPE;
144: BEGIN
145: FOR I IN 1..aSqlItem.COUNT LOOP

Line 153: P_TXN_HDR_REC DPP_LISTPRICE_PVT_DPP_TXN_H12,P_ITEM_COST_TBL DPP_LISTPRICE_PVT_DPP_TXN_L13) IS

149: END SQL_TO_PL23;
150:
151: PROCEDURE DPP_LISTPRICE_PVT$UPDATE_LIST (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,P_VALIDATION_LEVEL NUMBER,
152: X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,X_MSG_DATA OUT NOCOPY VARCHAR2,
153: P_TXN_HDR_REC DPP_LISTPRICE_PVT_DPP_TXN_H12,P_ITEM_COST_TBL DPP_LISTPRICE_PVT_DPP_TXN_L13) IS
154: P_TXN_HDR_REC_ APPS.DPP_LISTPRICE_PVT.DPP_TXN_HDR_REC_TYPE;
155: P_ITEM_COST_TBL_ APPS.DPP_LISTPRICE_PVT.DPP_TXN_LINE_TBL_TYPE;
156: BEGIN
157: P_TXN_HDR_REC_ := DPP_BPEL_UPDATELISTPRICE.SQL_TO_PL22(P_TXN_HDR_REC);