1: PACKAGE DPP_BPEL_GETPROMOS AUTHID CURRENT_USER AS
2: /* $Header: dppvbuns.pls 120.1 2007/12/12 06:04:29 sdasan noship $ */
3: -- Declare the conversion functions the PL/SQL type DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE
4: FUNCTION PL_TO_SQL16(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE)
5: RETURN DPP_PRICING_PVT_DPP_PL_NOTI14;
6: FUNCTION SQL_TO_PL16(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTI14)
7: RETURN DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE;
1: PACKAGE DPP_BPEL_GETPROMOS AUTHID CURRENT_USER AS
2: /* $Header: dppvbuns.pls 120.1 2007/12/12 06:04:29 sdasan noship $ */
3: -- Declare the conversion functions the PL/SQL type DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE
4: FUNCTION PL_TO_SQL16(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE)
5: RETURN DPP_PRICING_PVT_DPP_PL_NOTI14;
6: FUNCTION SQL_TO_PL16(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTI14)
7: RETURN DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_PRICING_PVT.DPP_OBJECT_NAME_TBL_TYPE
1: PACKAGE DPP_BPEL_GETPROMOS AUTHID CURRENT_USER AS
2: /* $Header: dppvbuns.pls 120.1 2007/12/12 06:04:29 sdasan noship $ */
3: -- Declare the conversion functions the PL/SQL type DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE
4: FUNCTION PL_TO_SQL16(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE)
5: RETURN DPP_PRICING_PVT_DPP_PL_NOTI14;
6: FUNCTION SQL_TO_PL16(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTI14)
7: RETURN DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_PRICING_PVT.DPP_OBJECT_NAME_TBL_TYPE
9: FUNCTION PL_TO_SQL18(aPlsqlItem DPP_PRICING_PVT.DPP_OBJECT_NAME_TBL_TYPE)
2: /* $Header: dppvbuns.pls 120.1 2007/12/12 06:04:29 sdasan noship $ */
3: -- Declare the conversion functions the PL/SQL type DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE
4: FUNCTION PL_TO_SQL16(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE)
5: RETURN DPP_PRICING_PVT_DPP_PL_NOTI14;
6: FUNCTION SQL_TO_PL16(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTI14)
7: RETURN DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_PRICING_PVT.DPP_OBJECT_NAME_TBL_TYPE
9: FUNCTION PL_TO_SQL18(aPlsqlItem DPP_PRICING_PVT.DPP_OBJECT_NAME_TBL_TYPE)
10: RETURN DPPPRICINGPVTDPPPLNOTI16_DPP_;
3: -- Declare the conversion functions the PL/SQL type DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE
4: FUNCTION PL_TO_SQL16(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE)
5: RETURN DPP_PRICING_PVT_DPP_PL_NOTI14;
6: FUNCTION SQL_TO_PL16(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTI14)
7: RETURN DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_PRICING_PVT.DPP_OBJECT_NAME_TBL_TYPE
9: FUNCTION PL_TO_SQL18(aPlsqlItem DPP_PRICING_PVT.DPP_OBJECT_NAME_TBL_TYPE)
10: RETURN DPPPRICINGPVTDPPPLNOTI16_DPP_;
11: FUNCTION SQL_TO_PL18(aSqlItem DPPPRICINGPVTDPPPLNOTI16_DPP_)
4: FUNCTION PL_TO_SQL16(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE)
5: RETURN DPP_PRICING_PVT_DPP_PL_NOTI14;
6: FUNCTION SQL_TO_PL16(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTI14)
7: RETURN DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_PRICING_PVT.DPP_OBJECT_NAME_TBL_TYPE
9: FUNCTION PL_TO_SQL18(aPlsqlItem DPP_PRICING_PVT.DPP_OBJECT_NAME_TBL_TYPE)
10: RETURN DPPPRICINGPVTDPPPLNOTI16_DPP_;
11: FUNCTION SQL_TO_PL18(aSqlItem DPPPRICINGPVTDPPPLNOTI16_DPP_)
12: RETURN DPP_PRICING_PVT.DPP_OBJECT_NAME_TBL_TYPE;
5: RETURN DPP_PRICING_PVT_DPP_PL_NOTI14;
6: FUNCTION SQL_TO_PL16(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTI14)
7: RETURN DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_PRICING_PVT.DPP_OBJECT_NAME_TBL_TYPE
9: FUNCTION PL_TO_SQL18(aPlsqlItem DPP_PRICING_PVT.DPP_OBJECT_NAME_TBL_TYPE)
10: RETURN DPPPRICINGPVTDPPPLNOTI16_DPP_;
11: FUNCTION SQL_TO_PL18(aSqlItem DPPPRICINGPVTDPPPLNOTI16_DPP_)
12: RETURN DPP_PRICING_PVT.DPP_OBJECT_NAME_TBL_TYPE;
13: -- Declare the conversion functions the PL/SQL type DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE
8: -- Declare the conversion functions the PL/SQL type DPP_PRICING_PVT.DPP_OBJECT_NAME_TBL_TYPE
9: FUNCTION PL_TO_SQL18(aPlsqlItem DPP_PRICING_PVT.DPP_OBJECT_NAME_TBL_TYPE)
10: RETURN DPPPRICINGPVTDPPPLNOTI16_DPP_;
11: FUNCTION SQL_TO_PL18(aSqlItem DPPPRICINGPVTDPPPLNOTI16_DPP_)
12: RETURN DPP_PRICING_PVT.DPP_OBJECT_NAME_TBL_TYPE;
13: -- Declare the conversion functions the PL/SQL type DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE
14: FUNCTION PL_TO_SQL19(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE)
15: RETURN DPP_PRICING_PVT_DPP_PL_NOTI16;
16: FUNCTION SQL_TO_PL19(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTI16)
9: FUNCTION PL_TO_SQL18(aPlsqlItem DPP_PRICING_PVT.DPP_OBJECT_NAME_TBL_TYPE)
10: RETURN DPPPRICINGPVTDPPPLNOTI16_DPP_;
11: FUNCTION SQL_TO_PL18(aSqlItem DPPPRICINGPVTDPPPLNOTI16_DPP_)
12: RETURN DPP_PRICING_PVT.DPP_OBJECT_NAME_TBL_TYPE;
13: -- Declare the conversion functions the PL/SQL type DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE
14: FUNCTION PL_TO_SQL19(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE)
15: RETURN DPP_PRICING_PVT_DPP_PL_NOTI16;
16: FUNCTION SQL_TO_PL19(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTI16)
17: RETURN DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE;
10: RETURN DPPPRICINGPVTDPPPLNOTI16_DPP_;
11: FUNCTION SQL_TO_PL18(aSqlItem DPPPRICINGPVTDPPPLNOTI16_DPP_)
12: RETURN DPP_PRICING_PVT.DPP_OBJECT_NAME_TBL_TYPE;
13: -- Declare the conversion functions the PL/SQL type DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE
14: FUNCTION PL_TO_SQL19(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE)
15: RETURN DPP_PRICING_PVT_DPP_PL_NOTI16;
16: FUNCTION SQL_TO_PL19(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTI16)
17: RETURN DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE;
18: -- Declare the conversion functions the PL/SQL type DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE
11: FUNCTION SQL_TO_PL18(aSqlItem DPPPRICINGPVTDPPPLNOTI16_DPP_)
12: RETURN DPP_PRICING_PVT.DPP_OBJECT_NAME_TBL_TYPE;
13: -- Declare the conversion functions the PL/SQL type DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE
14: FUNCTION PL_TO_SQL19(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE)
15: RETURN DPP_PRICING_PVT_DPP_PL_NOTI16;
16: FUNCTION SQL_TO_PL19(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTI16)
17: RETURN DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE;
18: -- Declare the conversion functions the PL/SQL type DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE
19: FUNCTION PL_TO_SQL17(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE)
12: RETURN DPP_PRICING_PVT.DPP_OBJECT_NAME_TBL_TYPE;
13: -- Declare the conversion functions the PL/SQL type DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE
14: FUNCTION PL_TO_SQL19(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE)
15: RETURN DPP_PRICING_PVT_DPP_PL_NOTI16;
16: FUNCTION SQL_TO_PL19(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTI16)
17: RETURN DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE;
18: -- Declare the conversion functions the PL/SQL type DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE
19: FUNCTION PL_TO_SQL17(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE)
20: RETURN DPP_PRICING_PVT_DPP_PL_NOTI15;
13: -- Declare the conversion functions the PL/SQL type DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE
14: FUNCTION PL_TO_SQL19(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE)
15: RETURN DPP_PRICING_PVT_DPP_PL_NOTI16;
16: FUNCTION SQL_TO_PL19(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTI16)
17: RETURN DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE;
18: -- Declare the conversion functions the PL/SQL type DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE
19: FUNCTION PL_TO_SQL17(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE)
20: RETURN DPP_PRICING_PVT_DPP_PL_NOTI15;
21: FUNCTION SQL_TO_PL17(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTI15)
14: FUNCTION PL_TO_SQL19(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE)
15: RETURN DPP_PRICING_PVT_DPP_PL_NOTI16;
16: FUNCTION SQL_TO_PL19(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTI16)
17: RETURN DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE;
18: -- Declare the conversion functions the PL/SQL type DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE
19: FUNCTION PL_TO_SQL17(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE)
20: RETURN DPP_PRICING_PVT_DPP_PL_NOTI15;
21: FUNCTION SQL_TO_PL17(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTI15)
22: RETURN DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE;
15: RETURN DPP_PRICING_PVT_DPP_PL_NOTI16;
16: FUNCTION SQL_TO_PL19(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTI16)
17: RETURN DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE;
18: -- Declare the conversion functions the PL/SQL type DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE
19: FUNCTION PL_TO_SQL17(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE)
20: RETURN DPP_PRICING_PVT_DPP_PL_NOTI15;
21: FUNCTION SQL_TO_PL17(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTI15)
22: RETURN DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE;
23: PROCEDURE DPP_PRICING_PVT$NOTIFY_PROMOT (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,P_VALIDATION_LEVEL NUMBER,
16: FUNCTION SQL_TO_PL19(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTI16)
17: RETURN DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE;
18: -- Declare the conversion functions the PL/SQL type DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE
19: FUNCTION PL_TO_SQL17(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE)
20: RETURN DPP_PRICING_PVT_DPP_PL_NOTI15;
21: FUNCTION SQL_TO_PL17(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTI15)
22: RETURN DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE;
23: PROCEDURE DPP_PRICING_PVT$NOTIFY_PROMOT (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,P_VALIDATION_LEVEL NUMBER,
24: X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,X_MSG_DATA OUT NOCOPY VARCHAR2,
17: RETURN DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE;
18: -- Declare the conversion functions the PL/SQL type DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE
19: FUNCTION PL_TO_SQL17(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE)
20: RETURN DPP_PRICING_PVT_DPP_PL_NOTI15;
21: FUNCTION SQL_TO_PL17(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTI15)
22: RETURN DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE;
23: PROCEDURE DPP_PRICING_PVT$NOTIFY_PROMOT (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,P_VALIDATION_LEVEL NUMBER,
24: X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,X_MSG_DATA OUT NOCOPY VARCHAR2,
25: 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);
18: -- Declare the conversion functions the PL/SQL type DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE
19: FUNCTION PL_TO_SQL17(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE)
20: RETURN DPP_PRICING_PVT_DPP_PL_NOTI15;
21: FUNCTION SQL_TO_PL17(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTI15)
22: RETURN DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE;
23: PROCEDURE DPP_PRICING_PVT$NOTIFY_PROMOT (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,P_VALIDATION_LEVEL NUMBER,
24: X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,X_MSG_DATA OUT NOCOPY VARCHAR2,
25: 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);
26: END DPP_BPEL_GETPROMOS;
19: FUNCTION PL_TO_SQL17(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE)
20: RETURN DPP_PRICING_PVT_DPP_PL_NOTI15;
21: FUNCTION SQL_TO_PL17(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTI15)
22: RETURN DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE;
23: PROCEDURE DPP_PRICING_PVT$NOTIFY_PROMOT (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,P_VALIDATION_LEVEL NUMBER,
24: X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,X_MSG_DATA OUT NOCOPY VARCHAR2,
25: 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);
26: END DPP_BPEL_GETPROMOS;
21: FUNCTION SQL_TO_PL17(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTI15)
22: RETURN DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE;
23: PROCEDURE DPP_PRICING_PVT$NOTIFY_PROMOT (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,P_VALIDATION_LEVEL NUMBER,
24: X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,X_MSG_DATA OUT NOCOPY VARCHAR2,
25: 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);
26: END DPP_BPEL_GETPROMOS;