DBA Data[Home] [Help]

APPS.DPP_BPEL_GETOUTBOUNDPL dependencies on DPP_PRICING_PVT_DPP_PL_NOTIF7

Line 81: RETURN DPP_PRICING_PVT_DPP_PL_NOTIF7 IS

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

Line 82: aSqlItem DPP_PRICING_PVT_DPP_PL_NOTIF7;

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

Line 85: aSqlItem := DPP_PRICING_PVT_DPP_PL_NOTIF7();

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

Line 92: FUNCTION SQL_TO_PL8(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTIF7)

88: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL10(aPlsqlItem(I));
89: END LOOP;
90: RETURN aSqlItem;
91: END PL_TO_SQL8;
92: FUNCTION SQL_TO_PL8(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTIF7)
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_NOTIF6,P_PL_NOTIFY_LINE_TBL IN OUT NOCOPY DPP_PRICING_PVT_DPP_PL_NOTIF7) IS

100: END SQL_TO_PL8;
101:
102: PROCEDURE DPP_PRICING_PVT$NOTIFY_OUTBOU (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_NOTIF6,P_PL_NOTIFY_LINE_TBL IN OUT NOCOPY DPP_PRICING_PVT_DPP_PL_NOTIF7) 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_GETOUTBOUNDPL.SQL_TO_PL7(P_PL_NOTIFY_HDR_REC);