DBA Data[Home] [Help]

APPS.DPP_BPEL_GETPROMOS dependencies on DPP_PRICING_PVT_DPP_PL_NOTI14

Line 4: RETURN DPP_PRICING_PVT_DPP_PL_NOTI14 IS

1: PACKAGE BODY DPP_BPEL_GETPROMOS AS
2: /* $Header: dppvbunb.pls 120.1 2007/12/12 06:04:19 sdasan noship $ */
3: FUNCTION PL_TO_SQL16(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE)
4: RETURN DPP_PRICING_PVT_DPP_PL_NOTI14 IS
5: aSqlItem DPP_PRICING_PVT_DPP_PL_NOTI14;
6: BEGIN
7: -- initialize the object
8: aSqlItem := DPP_PRICING_PVT_DPP_PL_NOTI14(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

Line 5: aSqlItem DPP_PRICING_PVT_DPP_PL_NOTI14;

1: PACKAGE BODY DPP_BPEL_GETPROMOS AS
2: /* $Header: dppvbunb.pls 120.1 2007/12/12 06:04:19 sdasan noship $ */
3: FUNCTION PL_TO_SQL16(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE)
4: RETURN DPP_PRICING_PVT_DPP_PL_NOTI14 IS
5: aSqlItem DPP_PRICING_PVT_DPP_PL_NOTI14;
6: BEGIN
7: -- initialize the object
8: aSqlItem := DPP_PRICING_PVT_DPP_PL_NOTI14(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
9: aSqlItem.PP_TRANSACTION_NO := aPlsqlItem.PP_TRANSACTION_NO;

Line 8: aSqlItem := DPP_PRICING_PVT_DPP_PL_NOTI14(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

4: RETURN DPP_PRICING_PVT_DPP_PL_NOTI14 IS
5: aSqlItem DPP_PRICING_PVT_DPP_PL_NOTI14;
6: BEGIN
7: -- initialize the object
8: aSqlItem := DPP_PRICING_PVT_DPP_PL_NOTI14(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
9: aSqlItem.PP_TRANSACTION_NO := aPlsqlItem.PP_TRANSACTION_NO;
10: aSqlItem.EFFECTIVITY_DATE := aPlsqlItem.EFFECTIVITY_DATE;
11: aSqlItem.ORG_ID := aPlsqlItem.ORG_ID;
12: aSqlItem.VENDOR_ID := aPlsqlItem.VENDOR_ID;

Line 20: FUNCTION SQL_TO_PL16(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTI14)

16: aSqlItem.VENDOR_SITE_CODE := aPlsqlItem.VENDOR_SITE_CODE;
17: aSqlItem.OPERATING_UNIT := aPlsqlItem.OPERATING_UNIT;
18: RETURN aSqlItem;
19: END PL_TO_SQL16;
20: FUNCTION SQL_TO_PL16(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTI14)
21: RETURN DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE IS
22: aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE;
23: BEGIN
24: aPlsqlItem.PP_TRANSACTION_NO := aSqlItem.PP_TRANSACTION_NO;

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);