eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.DPP_BPEL_GETOUTBOUNDPL dependencies on DPP_PRICING_PVT

Line 3: FUNCTION PL_TO_SQL7(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE)

1: PACKAGE BODY DPP_BPEL_GETOUTBOUNDPL AS
2: /* $Header: dppvbonb.pls 120.3 2011/07/14 09:50:13 rvkondur ship $ */
3: FUNCTION PL_TO_SQL7(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE)
4: RETURN DPP_PRICING_PVT_DPP_PL_NOTIF6 IS
5: aSqlItem DPP_PRICING_PVT_DPP_PL_NOTIF6;
6: BEGIN
7: -- initialize the object

Line 4: RETURN DPP_PRICING_PVT_DPP_PL_NOTIF6 IS

1: PACKAGE BODY DPP_BPEL_GETOUTBOUNDPL AS
2: /* $Header: dppvbonb.pls 120.3 2011/07/14 09:50:13 rvkondur ship $ */
3: FUNCTION PL_TO_SQL7(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE)
4: RETURN DPP_PRICING_PVT_DPP_PL_NOTIF6 IS
5: aSqlItem DPP_PRICING_PVT_DPP_PL_NOTIF6;
6: BEGIN
7: -- initialize the object
8: aSqlItem := DPP_PRICING_PVT_DPP_PL_NOTIF6(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

Line 5: aSqlItem DPP_PRICING_PVT_DPP_PL_NOTIF6;

1: PACKAGE BODY DPP_BPEL_GETOUTBOUNDPL AS
2: /* $Header: dppvbonb.pls 120.3 2011/07/14 09:50:13 rvkondur ship $ */
3: FUNCTION PL_TO_SQL7(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE)
4: RETURN DPP_PRICING_PVT_DPP_PL_NOTIF6 IS
5: aSqlItem DPP_PRICING_PVT_DPP_PL_NOTIF6;
6: BEGIN
7: -- initialize the object
8: aSqlItem := DPP_PRICING_PVT_DPP_PL_NOTIF6(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_NOTIF6(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

4: RETURN DPP_PRICING_PVT_DPP_PL_NOTIF6 IS
5: aSqlItem DPP_PRICING_PVT_DPP_PL_NOTIF6;
6: BEGIN
7: -- initialize the object
8: aSqlItem := DPP_PRICING_PVT_DPP_PL_NOTIF6(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_PL7(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTIF6)

16: aSqlItem.VENDOR_SITE_CODE := aPlsqlItem.VENDOR_SITE_CODE;
17: aSqlItem.OPERATING_UNIT := aPlsqlItem.OPERATING_UNIT;
18: RETURN aSqlItem;
19: END PL_TO_SQL7;
20: FUNCTION SQL_TO_PL7(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTIF6)
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 21: RETURN DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE IS

17: aSqlItem.OPERATING_UNIT := aPlsqlItem.OPERATING_UNIT;
18: RETURN aSqlItem;
19: END PL_TO_SQL7;
20: FUNCTION SQL_TO_PL7(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTIF6)
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;
25: aPlsqlItem.EFFECTIVITY_DATE := aSqlItem.EFFECTIVITY_DATE;

Line 22: aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE;

18: RETURN aSqlItem;
19: END PL_TO_SQL7;
20: FUNCTION SQL_TO_PL7(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTIF6)
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;
25: aPlsqlItem.EFFECTIVITY_DATE := aSqlItem.EFFECTIVITY_DATE;
26: aPlsqlItem.ORG_ID := aSqlItem.ORG_ID;

Line 35: FUNCTION PL_TO_SQL9(aPlsqlItem DPP_PRICING_PVT.DPP_OBJECT_NAME_TBL_TYPE)

31: aPlsqlItem.VENDOR_SITE_CODE := aSqlItem.VENDOR_SITE_CODE;
32: aPlsqlItem.OPERATING_UNIT := aSqlItem.OPERATING_UNIT;
33: RETURN aPlsqlItem;
34: END SQL_TO_PL7;
35: FUNCTION PL_TO_SQL9(aPlsqlItem DPP_PRICING_PVT.DPP_OBJECT_NAME_TBL_TYPE)
36: RETURN DPPPRICINGPVTDPPPLNOTIF8_DPP_ IS
37: aSqlItem DPPPRICINGPVTDPPPLNOTIF8_DPP_;
38: BEGIN
39: -- initialize the table

Line 48: RETURN DPP_PRICING_PVT.DPP_OBJECT_NAME_TBL_TYPE IS

44: END LOOP;
45: RETURN aSqlItem;
46: END PL_TO_SQL9;
47: FUNCTION SQL_TO_PL9(aSqlItem DPPPRICINGPVTDPPPLNOTIF8_DPP_)
48: RETURN DPP_PRICING_PVT.DPP_OBJECT_NAME_TBL_TYPE IS
49: aPlsqlItem DPP_PRICING_PVT.DPP_OBJECT_NAME_TBL_TYPE;
50: BEGIN
51: FOR I IN 1..aSqlItem.COUNT LOOP
52: aPlsqlItem(I) := aSqlItem(I);

Line 49: aPlsqlItem DPP_PRICING_PVT.DPP_OBJECT_NAME_TBL_TYPE;

45: RETURN aSqlItem;
46: END PL_TO_SQL9;
47: FUNCTION SQL_TO_PL9(aSqlItem DPPPRICINGPVTDPPPLNOTIF8_DPP_)
48: RETURN DPP_PRICING_PVT.DPP_OBJECT_NAME_TBL_TYPE IS
49: aPlsqlItem DPP_PRICING_PVT.DPP_OBJECT_NAME_TBL_TYPE;
50: BEGIN
51: FOR I IN 1..aSqlItem.COUNT LOOP
52: aPlsqlItem(I) := aSqlItem(I);
53: END LOOP;

Line 56: FUNCTION PL_TO_SQL10(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE)

52: aPlsqlItem(I) := aSqlItem(I);
53: END LOOP;
54: RETURN aPlsqlItem;
55: END SQL_TO_PL9;
56: FUNCTION PL_TO_SQL10(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE)
57: RETURN DPP_PRICING_PVT_DPP_PL_NOTIF8 IS
58: aSqlItem DPP_PRICING_PVT_DPP_PL_NOTIF8;
59: BEGIN
60: -- initialize the object

Line 57: RETURN DPP_PRICING_PVT_DPP_PL_NOTIF8 IS

53: END LOOP;
54: RETURN aPlsqlItem;
55: END SQL_TO_PL9;
56: FUNCTION PL_TO_SQL10(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE)
57: RETURN DPP_PRICING_PVT_DPP_PL_NOTIF8 IS
58: aSqlItem DPP_PRICING_PVT_DPP_PL_NOTIF8;
59: BEGIN
60: -- initialize the object
61: aSqlItem := DPP_PRICING_PVT_DPP_PL_NOTIF8(NULL, NULL, NULL, NULL, NULL);

Line 58: aSqlItem DPP_PRICING_PVT_DPP_PL_NOTIF8;

54: RETURN aPlsqlItem;
55: END SQL_TO_PL9;
56: FUNCTION PL_TO_SQL10(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE)
57: RETURN DPP_PRICING_PVT_DPP_PL_NOTIF8 IS
58: aSqlItem DPP_PRICING_PVT_DPP_PL_NOTIF8;
59: BEGIN
60: -- initialize the object
61: aSqlItem := DPP_PRICING_PVT_DPP_PL_NOTIF8(NULL, NULL, NULL, NULL, NULL);
62: aSqlItem.INVENTORY_ITEM_ID := aPlsqlItem.INVENTORY_ITEM_ID;

Line 61: aSqlItem := DPP_PRICING_PVT_DPP_PL_NOTIF8(NULL, NULL, NULL, NULL, NULL);

57: RETURN DPP_PRICING_PVT_DPP_PL_NOTIF8 IS
58: aSqlItem DPP_PRICING_PVT_DPP_PL_NOTIF8;
59: BEGIN
60: -- initialize the object
61: aSqlItem := DPP_PRICING_PVT_DPP_PL_NOTIF8(NULL, NULL, NULL, NULL, NULL);
62: aSqlItem.INVENTORY_ITEM_ID := aPlsqlItem.INVENTORY_ITEM_ID;
63: aSqlItem.ITEM_NUMBER := aPlsqlItem.ITEM_NUMBER;
64: aSqlItem.OBJECT_NAME_TBL := PL_TO_SQL9(aPlsqlItem.OBJECT_NAME_TBL);
65: aSqlItem.NEW_PRICE := aPlsqlItem.NEW_PRICE;

Line 69: FUNCTION SQL_TO_PL10(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTIF8)

65: aSqlItem.NEW_PRICE := aPlsqlItem.NEW_PRICE;
66: aSqlItem.CURRENCY_CODE := aPlsqlItem.CURRENCY_CODE;
67: RETURN aSqlItem;
68: END PL_TO_SQL10;
69: FUNCTION SQL_TO_PL10(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTIF8)
70: RETURN DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE IS
71: aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE;
72: BEGIN
73: aPlsqlItem.INVENTORY_ITEM_ID := aSqlItem.INVENTORY_ITEM_ID;

Line 70: RETURN DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE IS

66: aSqlItem.CURRENCY_CODE := aPlsqlItem.CURRENCY_CODE;
67: RETURN aSqlItem;
68: END PL_TO_SQL10;
69: FUNCTION SQL_TO_PL10(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTIF8)
70: RETURN DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE IS
71: aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE;
72: BEGIN
73: aPlsqlItem.INVENTORY_ITEM_ID := aSqlItem.INVENTORY_ITEM_ID;
74: aPlsqlItem.ITEM_NUMBER := aSqlItem.ITEM_NUMBER;

Line 71: aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE;

67: RETURN aSqlItem;
68: END PL_TO_SQL10;
69: FUNCTION SQL_TO_PL10(aSqlItem DPP_PRICING_PVT_DPP_PL_NOTIF8)
70: RETURN DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE IS
71: aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_REC_TYPE;
72: BEGIN
73: aPlsqlItem.INVENTORY_ITEM_ID := aSqlItem.INVENTORY_ITEM_ID;
74: aPlsqlItem.ITEM_NUMBER := aSqlItem.ITEM_NUMBER;
75: aPlsqlItem.OBJECT_NAME_TBL := SQL_TO_PL9(aSqlItem.OBJECT_NAME_TBL);

Line 80: FUNCTION PL_TO_SQL8(aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE)

76: aPlsqlItem.NEW_PRICE := aSqlItem.NEW_PRICE;
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

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 93: RETURN DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE IS

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
97: aPlsqlItem(I) := SQL_TO_PL10(aSqlItem(I));

Line 94: aPlsqlItem DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE;

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
97: aPlsqlItem(I) := SQL_TO_PL10(aSqlItem(I));
98: END LOOP;

Line 102: PROCEDURE DPP_PRICING_PVT$NOTIFY_OUTBOU (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,P_VALIDATION_LEVEL NUMBER,

98: END LOOP;
99: RETURN aPlsqlItem;
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_ DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE;
106: P_PL_NOTIFY_LINE_TBL_ DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE;

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_ DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE;
106: P_PL_NOTIFY_LINE_TBL_ 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);

Line 105: P_PL_NOTIFY_HDR_REC_ DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE;

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_ DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE;
106: P_PL_NOTIFY_LINE_TBL_ 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);
109: P_PL_NOTIFY_LINE_TBL_ := DPP_BPEL_GETOUTBOUNDPL.SQL_TO_PL8(P_PL_NOTIFY_LINE_TBL);

Line 106: P_PL_NOTIFY_LINE_TBL_ DPP_PRICING_PVT.DPP_PL_NOTIFY_LINE_TBL_TYPE;

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_ DPP_PRICING_PVT.DPP_PL_NOTIFY_REC_TYPE;
106: P_PL_NOTIFY_LINE_TBL_ 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);
109: P_PL_NOTIFY_LINE_TBL_ := DPP_BPEL_GETOUTBOUNDPL.SQL_TO_PL8(P_PL_NOTIFY_LINE_TBL);
110: DPP_PRICING_PVT.NOTIFY_OUTBOUNDPRICELISTS(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA,P_PL_NOTIFY_HDR_REC_,P_PL_NOTIFY_LINE_TBL_);

Line 110: DPP_PRICING_PVT.NOTIFY_OUTBOUNDPRICELISTS(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA,P_PL_NOTIFY_HDR_REC_,P_PL_NOTIFY_LINE_TBL_);

106: P_PL_NOTIFY_LINE_TBL_ 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);
109: P_PL_NOTIFY_LINE_TBL_ := DPP_BPEL_GETOUTBOUNDPL.SQL_TO_PL8(P_PL_NOTIFY_LINE_TBL);
110: DPP_PRICING_PVT.NOTIFY_OUTBOUNDPRICELISTS(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA,P_PL_NOTIFY_HDR_REC_,P_PL_NOTIFY_LINE_TBL_);
111: P_PL_NOTIFY_HDR_REC := DPP_BPEL_GETOUTBOUNDPL.PL_TO_SQL7(P_PL_NOTIFY_HDR_REC_);
112: P_PL_NOTIFY_LINE_TBL := DPP_BPEL_GETOUTBOUNDPL.PL_TO_SQL8(P_PL_NOTIFY_LINE_TBL_);
113: END DPP_PRICING_PVT$NOTIFY_OUTBOU;
114:

Line 113: END DPP_PRICING_PVT$NOTIFY_OUTBOU;

109: P_PL_NOTIFY_LINE_TBL_ := DPP_BPEL_GETOUTBOUNDPL.SQL_TO_PL8(P_PL_NOTIFY_LINE_TBL);
110: DPP_PRICING_PVT.NOTIFY_OUTBOUNDPRICELISTS(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA,P_PL_NOTIFY_HDR_REC_,P_PL_NOTIFY_LINE_TBL_);
111: P_PL_NOTIFY_HDR_REC := DPP_BPEL_GETOUTBOUNDPL.PL_TO_SQL7(P_PL_NOTIFY_HDR_REC_);
112: P_PL_NOTIFY_LINE_TBL := DPP_BPEL_GETOUTBOUNDPL.PL_TO_SQL8(P_PL_NOTIFY_LINE_TBL_);
113: END DPP_PRICING_PVT$NOTIFY_OUTBOU;
114:
115: END DPP_BPEL_GETOUTBOUNDPL;