DBA Data[Home] [Help]

APPS.DPP_BPEL_GETIPL dependencies on DPP_PRICING_PVT_DPP_PL_NOTIF1

Line 81: RETURN DPP_PRICING_PVT_DPP_PL_NOTIF1 IS

77: aPlsqlItem.CURRENCY_CODE := aSqlItem.CURRENCY_CODE;
78: RETURN aPlsqlItem;
79: END SQL_TO_PL3;
80: FUNCTION PL_TO_SQL1(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE)
81: RETURN DPP_PRICING_PVT_DPP_PL_NOTIF1 IS
82: aSqlItem DPP_PRICING_PVT_DPP_PL_NOTIF1;
83: BEGIN
84: -- initialize the table
85: aSqlItem := DPP_PRICING_PVT_DPP_PL_NOTIF1();

Line 82: aSqlItem DPP_PRICING_PVT_DPP_PL_NOTIF1;

78: RETURN aPlsqlItem;
79: END SQL_TO_PL3;
80: FUNCTION PL_TO_SQL1(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE)
81: RETURN DPP_PRICING_PVT_DPP_PL_NOTIF1 IS
82: aSqlItem DPP_PRICING_PVT_DPP_PL_NOTIF1;
83: BEGIN
84: -- initialize the table
85: aSqlItem := DPP_PRICING_PVT_DPP_PL_NOTIF1();
86: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 85: aSqlItem := DPP_PRICING_PVT_DPP_PL_NOTIF1();

81: RETURN DPP_PRICING_PVT_DPP_PL_NOTIF1 IS
82: aSqlItem DPP_PRICING_PVT_DPP_PL_NOTIF1;
83: BEGIN
84: -- initialize the table
85: aSqlItem := DPP_PRICING_PVT_DPP_PL_NOTIF1();
86: aSqlItem.EXTEND(aPlsqlItem.COUNT);
87: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
88: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL3(aPlsqlItem(I));
89: END LOOP;

Line 92: FUNCTION SQL_TO_PL1(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTIF1)

88: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL3(aPlsqlItem(I));
89: END LOOP;
90: RETURN aSqlItem;
91: END PL_TO_SQL1;
92: FUNCTION SQL_TO_PL1(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTIF1)
93: RETURN DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE IS
94: aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE;
95: BEGIN
96: FOR I IN 1..aSqlItem.COUNT LOOP

Line 104: P_PL_NOTIFY_HDR_REC IN OUT NOCOPY DPP_PRICING_PVT_DPP_PL_NOTIFY,P_PL_NOTIFY_LINE_TBL IN OUT NOCOPY DPP_PRICING_PVT_DPP_PL_NOTIF1) IS

100: END SQL_TO_PL1;
101:
102: PROCEDURE DPP_PRICING_PVT$NOTIFY_INBOUN (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,P_VALIDATION_LEVEL NUMBER,
103: X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,X_MSG_DATA OUT NOCOPY VARCHAR2,
104: P_PL_NOTIFY_HDR_REC IN OUT NOCOPY DPP_PRICING_PVT_DPP_PL_NOTIFY,P_PL_NOTIFY_LINE_TBL IN OUT NOCOPY DPP_PRICING_PVT_DPP_PL_NOTIF1) IS
105: P_PL_NOTIFY_HDR_REC_ APPS.DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE;
106: P_PL_NOTIFY_LINE_TBL_ APPS.DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE;
107: BEGIN
108: P_PL_NOTIFY_HDR_REC_ := DPP_BPEL_GETIPL.SQL_TO_PL0(P_PL_NOTIFY_HDR_REC);