1: PACKAGE DPP_BPEL_GETPODATA AS
2: /* $Header: dppvbufs.pls 120.2 2007/12/17 06:54:25 sdasan noship $ */
3: -- Declare the conversion functions the PL/SQL type DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_REC_TYPE
4: FUNCTION PL_TO_SQL11(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_REC_TYPE)
5: RETURN DPP_PURCHASEPRICE_PVT_DPP_PO_;
6: FUNCTION SQL_TO_PL11(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_PO_)
7: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_REC_TYPE;
1: PACKAGE DPP_BPEL_GETPODATA AS
2: /* $Header: dppvbufs.pls 120.2 2007/12/17 06:54:25 sdasan noship $ */
3: -- Declare the conversion functions the PL/SQL type DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_REC_TYPE
4: FUNCTION PL_TO_SQL11(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_REC_TYPE)
5: RETURN DPP_PURCHASEPRICE_PVT_DPP_PO_;
6: FUNCTION SQL_TO_PL11(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_PO_)
7: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_REC_TYPE
1: PACKAGE DPP_BPEL_GETPODATA AS
2: /* $Header: dppvbufs.pls 120.2 2007/12/17 06:54:25 sdasan noship $ */
3: -- Declare the conversion functions the PL/SQL type DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_REC_TYPE
4: FUNCTION PL_TO_SQL11(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_REC_TYPE)
5: RETURN DPP_PURCHASEPRICE_PVT_DPP_PO_;
6: FUNCTION SQL_TO_PL11(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_PO_)
7: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_REC_TYPE
9: FUNCTION PL_TO_SQL13(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_REC_TYPE)
2: /* $Header: dppvbufs.pls 120.2 2007/12/17 06:54:25 sdasan noship $ */
3: -- Declare the conversion functions the PL/SQL type DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_REC_TYPE
4: FUNCTION PL_TO_SQL11(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_REC_TYPE)
5: RETURN DPP_PURCHASEPRICE_PVT_DPP_PO_;
6: FUNCTION SQL_TO_PL11(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_PO_)
7: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_REC_TYPE
9: FUNCTION PL_TO_SQL13(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_REC_TYPE)
10: RETURN DPP_PURCHASEPRICE_PVT_DPP_P13;
3: -- Declare the conversion functions the PL/SQL type DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_REC_TYPE
4: FUNCTION PL_TO_SQL11(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_REC_TYPE)
5: RETURN DPP_PURCHASEPRICE_PVT_DPP_PO_;
6: FUNCTION SQL_TO_PL11(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_PO_)
7: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_REC_TYPE
9: FUNCTION PL_TO_SQL13(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_REC_TYPE)
10: RETURN DPP_PURCHASEPRICE_PVT_DPP_P13;
11: FUNCTION SQL_TO_PL13(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_P13)
4: FUNCTION PL_TO_SQL11(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_REC_TYPE)
5: RETURN DPP_PURCHASEPRICE_PVT_DPP_PO_;
6: FUNCTION SQL_TO_PL11(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_PO_)
7: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_REC_TYPE
9: FUNCTION PL_TO_SQL13(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_REC_TYPE)
10: RETURN DPP_PURCHASEPRICE_PVT_DPP_P13;
11: FUNCTION SQL_TO_PL13(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_P13)
12: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_REC_TYPE;
5: RETURN DPP_PURCHASEPRICE_PVT_DPP_PO_;
6: FUNCTION SQL_TO_PL11(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_PO_)
7: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_REC_TYPE;
8: -- Declare the conversion functions the PL/SQL type DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_REC_TYPE
9: FUNCTION PL_TO_SQL13(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_REC_TYPE)
10: RETURN DPP_PURCHASEPRICE_PVT_DPP_P13;
11: FUNCTION SQL_TO_PL13(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_P13)
12: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_REC_TYPE;
13: -- Declare the conversion functions the PL/SQL type DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_TBL_TYPE
8: -- Declare the conversion functions the PL/SQL type DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_REC_TYPE
9: FUNCTION PL_TO_SQL13(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_REC_TYPE)
10: RETURN DPP_PURCHASEPRICE_PVT_DPP_P13;
11: FUNCTION SQL_TO_PL13(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_P13)
12: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_REC_TYPE;
13: -- Declare the conversion functions the PL/SQL type DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_TBL_TYPE
14: FUNCTION PL_TO_SQL14(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_TBL_TYPE)
15: RETURN DPPPURCHASEPRICEPVTDPPP11_DPP;
16: FUNCTION SQL_TO_PL14(aSqlItem DPPPURCHASEPRICEPVTDPPP11_DPP)
9: FUNCTION PL_TO_SQL13(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_REC_TYPE)
10: RETURN DPP_PURCHASEPRICE_PVT_DPP_P13;
11: FUNCTION SQL_TO_PL13(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_P13)
12: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_REC_TYPE;
13: -- Declare the conversion functions the PL/SQL type DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_TBL_TYPE
14: FUNCTION PL_TO_SQL14(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_TBL_TYPE)
15: RETURN DPPPURCHASEPRICEPVTDPPP11_DPP;
16: FUNCTION SQL_TO_PL14(aSqlItem DPPPURCHASEPRICEPVTDPPP11_DPP)
17: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_TBL_TYPE;
10: RETURN DPP_PURCHASEPRICE_PVT_DPP_P13;
11: FUNCTION SQL_TO_PL13(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_P13)
12: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_REC_TYPE;
13: -- Declare the conversion functions the PL/SQL type DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_TBL_TYPE
14: FUNCTION PL_TO_SQL14(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_TBL_TYPE)
15: RETURN DPPPURCHASEPRICEPVTDPPP11_DPP;
16: FUNCTION SQL_TO_PL14(aSqlItem DPPPURCHASEPRICEPVTDPPP11_DPP)
17: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_TBL_TYPE;
18: -- Declare the conversion functions the PL/SQL type DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_REC_TYPE
13: -- Declare the conversion functions the PL/SQL type DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_TBL_TYPE
14: FUNCTION PL_TO_SQL14(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_TBL_TYPE)
15: RETURN DPPPURCHASEPRICEPVTDPPP11_DPP;
16: FUNCTION SQL_TO_PL14(aSqlItem DPPPURCHASEPRICEPVTDPPP11_DPP)
17: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_TBL_TYPE;
18: -- Declare the conversion functions the PL/SQL type DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_REC_TYPE
19: FUNCTION PL_TO_SQL15(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_REC_TYPE)
20: RETURN DPP_PURCHASEPRICE_PVT_DPP_P11;
21: FUNCTION SQL_TO_PL15(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_P11)
14: FUNCTION PL_TO_SQL14(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_TBL_TYPE)
15: RETURN DPPPURCHASEPRICEPVTDPPP11_DPP;
16: FUNCTION SQL_TO_PL14(aSqlItem DPPPURCHASEPRICEPVTDPPP11_DPP)
17: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_TBL_TYPE;
18: -- Declare the conversion functions the PL/SQL type DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_REC_TYPE
19: FUNCTION PL_TO_SQL15(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_REC_TYPE)
20: RETURN DPP_PURCHASEPRICE_PVT_DPP_P11;
21: FUNCTION SQL_TO_PL15(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_P11)
22: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_REC_TYPE;
15: RETURN DPPPURCHASEPRICEPVTDPPP11_DPP;
16: FUNCTION SQL_TO_PL14(aSqlItem DPPPURCHASEPRICEPVTDPPP11_DPP)
17: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_DETAILS_TBL_TYPE;
18: -- Declare the conversion functions the PL/SQL type DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_REC_TYPE
19: FUNCTION PL_TO_SQL15(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_REC_TYPE)
20: RETURN DPP_PURCHASEPRICE_PVT_DPP_P11;
21: FUNCTION SQL_TO_PL15(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_P11)
22: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_REC_TYPE;
23: -- Declare the conversion functions the PL/SQL type DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_TBL_TYPE
18: -- Declare the conversion functions the PL/SQL type DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_REC_TYPE
19: FUNCTION PL_TO_SQL15(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_REC_TYPE)
20: RETURN DPP_PURCHASEPRICE_PVT_DPP_P11;
21: FUNCTION SQL_TO_PL15(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_P11)
22: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_REC_TYPE;
23: -- Declare the conversion functions the PL/SQL type DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_TBL_TYPE
24: FUNCTION PL_TO_SQL12(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_TBL_TYPE)
25: RETURN DPP_PURCHASEPRICE_PVT_DPP_PO10;
26: FUNCTION SQL_TO_PL12(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_PO10)
19: FUNCTION PL_TO_SQL15(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_REC_TYPE)
20: RETURN DPP_PURCHASEPRICE_PVT_DPP_P11;
21: FUNCTION SQL_TO_PL15(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_P11)
22: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_REC_TYPE;
23: -- Declare the conversion functions the PL/SQL type DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_TBL_TYPE
24: FUNCTION PL_TO_SQL12(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_TBL_TYPE)
25: RETURN DPP_PURCHASEPRICE_PVT_DPP_PO10;
26: FUNCTION SQL_TO_PL12(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_PO10)
27: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_TBL_TYPE;
20: RETURN DPP_PURCHASEPRICE_PVT_DPP_P11;
21: FUNCTION SQL_TO_PL15(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_P11)
22: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_REC_TYPE;
23: -- Declare the conversion functions the PL/SQL type DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_TBL_TYPE
24: FUNCTION PL_TO_SQL12(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_TBL_TYPE)
25: RETURN DPP_PURCHASEPRICE_PVT_DPP_PO10;
26: FUNCTION SQL_TO_PL12(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_PO10)
27: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_TBL_TYPE;
28: PROCEDURE DPP_PURCHASEPRICE_PVT$NOTIFY_ (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,
21: FUNCTION SQL_TO_PL15(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_P11)
22: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_REC_TYPE;
23: -- Declare the conversion functions the PL/SQL type DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_TBL_TYPE
24: FUNCTION PL_TO_SQL12(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_TBL_TYPE)
25: RETURN DPP_PURCHASEPRICE_PVT_DPP_PO10;
26: FUNCTION SQL_TO_PL12(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_PO10)
27: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_TBL_TYPE;
28: PROCEDURE DPP_PURCHASEPRICE_PVT$NOTIFY_ (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,
29: P_VALIDATION_LEVEL NUMBER,X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,
22: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_REC_TYPE;
23: -- Declare the conversion functions the PL/SQL type DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_TBL_TYPE
24: FUNCTION PL_TO_SQL12(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_TBL_TYPE)
25: RETURN DPP_PURCHASEPRICE_PVT_DPP_PO10;
26: FUNCTION SQL_TO_PL12(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_PO10)
27: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_TBL_TYPE;
28: PROCEDURE DPP_PURCHASEPRICE_PVT$NOTIFY_ (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,
29: P_VALIDATION_LEVEL NUMBER,X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,
30: X_MSG_DATA OUT NOCOPY VARCHAR2,P_PO_NOTIFY_HDR_REC IN OUT NOCOPY DPP_PURCHASEPRICE_PVT_DPP_PO_,
23: -- Declare the conversion functions the PL/SQL type DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_TBL_TYPE
24: FUNCTION PL_TO_SQL12(aPlsqlItem DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_TBL_TYPE)
25: RETURN DPP_PURCHASEPRICE_PVT_DPP_PO10;
26: FUNCTION SQL_TO_PL12(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_PO10)
27: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_TBL_TYPE;
28: PROCEDURE DPP_PURCHASEPRICE_PVT$NOTIFY_ (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,
29: P_VALIDATION_LEVEL NUMBER,X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,
30: X_MSG_DATA OUT NOCOPY VARCHAR2,P_PO_NOTIFY_HDR_REC IN OUT NOCOPY DPP_PURCHASEPRICE_PVT_DPP_PO_,
31: P_PO_NOTIFY_ITEM_TBL IN OUT NOCOPY DPP_PURCHASEPRICE_PVT_DPP_PO10);
26: FUNCTION SQL_TO_PL12(aSqlItem DPP_PURCHASEPRICE_PVT_DPP_PO10)
27: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_TBL_TYPE;
28: PROCEDURE DPP_PURCHASEPRICE_PVT$NOTIFY_ (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,
29: P_VALIDATION_LEVEL NUMBER,X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,
30: X_MSG_DATA OUT NOCOPY VARCHAR2,P_PO_NOTIFY_HDR_REC IN OUT NOCOPY DPP_PURCHASEPRICE_PVT_DPP_PO_,
31: P_PO_NOTIFY_ITEM_TBL IN OUT NOCOPY DPP_PURCHASEPRICE_PVT_DPP_PO10);
32: END DPP_BPEL_GETPODATA;
27: RETURN DPP_PURCHASEPRICE_PVT.DPP_PO_NOTIFY_ITEM_TBL_TYPE;
28: PROCEDURE DPP_PURCHASEPRICE_PVT$NOTIFY_ (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,
29: P_VALIDATION_LEVEL NUMBER,X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,
30: X_MSG_DATA OUT NOCOPY VARCHAR2,P_PO_NOTIFY_HDR_REC IN OUT NOCOPY DPP_PURCHASEPRICE_PVT_DPP_PO_,
31: P_PO_NOTIFY_ITEM_TBL IN OUT NOCOPY DPP_PURCHASEPRICE_PVT_DPP_PO10);
32: END DPP_BPEL_GETPODATA;