APPS.DPP_BPEL_GETPROMOS dependencies on DPP_PRICING_PVT_DPP_PL_NOTI15

Line 81: RETURN DPP_PRICING_PVT_DPP_PL_NOTI15 IS

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

Line 82: aSqlItem DPP_PRICING_PVT_DPP_PL_NOTI15;

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

Line 85: aSqlItem := DPP_PRICING_PVT_DPP_PL_NOTI15();

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

Line 92: FUNCTION SQL_TO_PL17(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTI15)

88: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL19(aPlsqlItem(I));
89: END LOOP;
90: RETURN aSqlItem;
91: END PL_TO_SQL17;
92: FUNCTION SQL_TO_PL17(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTI15)
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_NOTI14,P_PL_NOTIFY_LINE_TBL IN OUT NOCOPY DPP_PRICING_PVT_DPP_PL_NOTI15) IS

100: END SQL_TO_PL17;
101:
102: PROCEDURE DPP_PRICING_PVT$NOTIFY_PROMOT (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_NOTI14,P_PL_NOTIFY_LINE_TBL IN OUT NOCOPY DPP_PRICING_PVT_DPP_PL_NOTI15) 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_GETPROMOS.SQL_TO_PL16(P_PL_NOTIFY_HDR_REC);