DBA Data[Home] [Help]

APPS.DPP_BPEL_GETPODATA dependencies on DPP_PURCHASEPRICE_PVT_DPP_PO10

Line 99: RETURN DPP_PURCHASEPRICE_PVT_DPP_PO10 IS

95: aPlsqlItem.PO_DETAILS_TBL := SQL_TO_PL14(aSqlItem.PO_DETAILS_TBL);
96: RETURN aPlsqlItem;
97: END SQL_TO_PL15;
98: FUNCTION PL_TO_SQL12(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_TBL_TYPE)
99: RETURN DPP_PURCHASEPRICE_PVT_DPP_PO10 IS
100: aSqlItem DPP_PURCHASEPRICE_PVT_DPP_PO10;
101: BEGIN
102: -- initialize the table
103: aSqlItem := DPP_PURCHASEPRICE_PVT_DPP_PO10();

Line 100: aSqlItem DPP_PURCHASEPRICE_PVT_DPP_PO10;

96: RETURN aPlsqlItem;
97: END SQL_TO_PL15;
98: FUNCTION PL_TO_SQL12(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_TBL_TYPE)
99: RETURN DPP_PURCHASEPRICE_PVT_DPP_PO10 IS
100: aSqlItem DPP_PURCHASEPRICE_PVT_DPP_PO10;
101: BEGIN
102: -- initialize the table
103: aSqlItem := DPP_PURCHASEPRICE_PVT_DPP_PO10();
104: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 103: aSqlItem := DPP_PURCHASEPRICE_PVT_DPP_PO10();

99: RETURN DPP_PURCHASEPRICE_PVT_DPP_PO10 IS
100: aSqlItem DPP_PURCHASEPRICE_PVT_DPP_PO10;
101: BEGIN
102: -- initialize the table
103: aSqlItem := DPP_PURCHASEPRICE_PVT_DPP_PO10();
104: aSqlItem.EXTEND(aPlsqlItem.COUNT);
105: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
106: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL15(aPlsqlItem(I));
107: END LOOP;

Line 110: FUNCTION SQL_TO_PL12(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_PO10)

106: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL15(aPlsqlItem(I));
107: END LOOP;
108: RETURN aSqlItem;
109: END PL_TO_SQL12;
110: FUNCTION SQL_TO_PL12(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_PO10)
111: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_TBL_TYPE IS
112: aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_TBL_TYPE;
113: BEGIN
114: FOR I IN 1..aSqlItem.COUNT LOOP

Line 123: P_PO_NOTIFY_ITEM_TBL IN OUT NOCOPY DPP_PURCHASEPRICE_PVT_DPP_PO10) IS

119:
120: PROCEDURE DPP_PURCHASEPRICE_PVT$NOTIFY_ (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,
121: P_VALIDATION_LEVEL NUMBER,X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,
122: X_MSG_DATA OUT NOCOPY VARCHAR2,P_PO_NOTIFY_HDR_REC IN OUT NOCOPY DPP_PURCHASEPRICE_PVT_DPP_PO_,
123: P_PO_NOTIFY_ITEM_TBL IN OUT NOCOPY DPP_PURCHASEPRICE_PVT_DPP_PO10) IS
124: P_PO_NOTIFY_HDR_REC_ APPS.DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_REC_TYPE;
125: P_PO_NOTIFY_ITEM_TBL_ APPS.DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_TBL_TYPE;
126: BEGIN
127: P_PO_NOTIFY_HDR_REC_ := DPP_BPEL_GETPODATA.SQL_TO_PL11(P_PO_NOTIFY_HDR_REC);