DBA Data[Home] [Help]

APPS.DPP_BPEL_UPDATELISTPRICE dependencies on DPP_LISTPRICE_PVT

Line 3: FUNCTION PL_TO_SQL22(aPlsqlItem DPP_LISTPRICE_PVT.DPP_TXN_HDR_REC_TYPE)

1: PACKAGE BODY DPP_BPEL_UPDATELISTPRICE AS
2: /* $Header: dppvbulb.pls 120.1 2007/12/12 05:57:15 sdasan noship $ */
3: FUNCTION PL_TO_SQL22(aPlsqlItem DPP_LISTPRICE_PVT.DPP_TXN_HDR_REC_TYPE)
4: RETURN DPP_LISTPRICE_PVT_DPP_TXN_H12 IS
5: aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_H12;
6: BEGIN
7: -- initialize the object

Line 4: RETURN DPP_LISTPRICE_PVT_DPP_TXN_H12 IS

1: PACKAGE BODY DPP_BPEL_UPDATELISTPRICE AS
2: /* $Header: dppvbulb.pls 120.1 2007/12/12 05:57:15 sdasan noship $ */
3: FUNCTION PL_TO_SQL22(aPlsqlItem DPP_LISTPRICE_PVT.DPP_TXN_HDR_REC_TYPE)
4: RETURN DPP_LISTPRICE_PVT_DPP_TXN_H12 IS
5: aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_H12;
6: BEGIN
7: -- initialize the object
8: aSqlItem := DPP_LISTPRICE_PVT_DPP_TXN_H12(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 5: aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_H12;

1: PACKAGE BODY DPP_BPEL_UPDATELISTPRICE AS
2: /* $Header: dppvbulb.pls 120.1 2007/12/12 05:57:15 sdasan noship $ */
3: FUNCTION PL_TO_SQL22(aPlsqlItem DPP_LISTPRICE_PVT.DPP_TXN_HDR_REC_TYPE)
4: RETURN DPP_LISTPRICE_PVT_DPP_TXN_H12 IS
5: aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_H12;
6: BEGIN
7: -- initialize the object
8: aSqlItem := DPP_LISTPRICE_PVT_DPP_TXN_H12(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
9: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

Line 8: aSqlItem := DPP_LISTPRICE_PVT_DPP_TXN_H12(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

4: RETURN DPP_LISTPRICE_PVT_DPP_TXN_H12 IS
5: aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_H12;
6: BEGIN
7: -- initialize the object
8: aSqlItem := DPP_LISTPRICE_PVT_DPP_TXN_H12(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
9: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
10: aSqlItem.TRANSACTION_HEADER_ID := aPlsqlItem.TRANSACTION_HEADER_ID;
11: aSqlItem.TRANSACTION_NUMBER := aPlsqlItem.TRANSACTION_NUMBER;
12: aSqlItem.ORG_ID := aPlsqlItem.ORG_ID;

Line 36: FUNCTION SQL_TO_PL22(aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_H12)

32: aSqlItem.ATTRIBUTE14 := aPlsqlItem.ATTRIBUTE14;
33: aSqlItem.ATTRIBUTE15 := aPlsqlItem.ATTRIBUTE15;
34: RETURN aSqlItem;
35: END PL_TO_SQL22;
36: FUNCTION SQL_TO_PL22(aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_H12)
37: RETURN DPP_LISTPRICE_PVT.DPP_TXN_HDR_REC_TYPE IS
38: aPlsqlItem DPP_LISTPRICE_PVT.DPP_TXN_HDR_REC_TYPE;
39: BEGIN
40: aPlsqlItem.TRANSACTION_HEADER_ID := aSqlItem.TRANSACTION_HEADER_ID;

Line 37: RETURN DPP_LISTPRICE_PVT.DPP_TXN_HDR_REC_TYPE IS

33: aSqlItem.ATTRIBUTE15 := aPlsqlItem.ATTRIBUTE15;
34: RETURN aSqlItem;
35: END PL_TO_SQL22;
36: FUNCTION SQL_TO_PL22(aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_H12)
37: RETURN DPP_LISTPRICE_PVT.DPP_TXN_HDR_REC_TYPE IS
38: aPlsqlItem DPP_LISTPRICE_PVT.DPP_TXN_HDR_REC_TYPE;
39: BEGIN
40: aPlsqlItem.TRANSACTION_HEADER_ID := aSqlItem.TRANSACTION_HEADER_ID;
41: aPlsqlItem.TRANSACTION_NUMBER := aSqlItem.TRANSACTION_NUMBER;

Line 38: aPlsqlItem DPP_LISTPRICE_PVT.DPP_TXN_HDR_REC_TYPE;

34: RETURN aSqlItem;
35: END PL_TO_SQL22;
36: FUNCTION SQL_TO_PL22(aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_H12)
37: RETURN DPP_LISTPRICE_PVT.DPP_TXN_HDR_REC_TYPE IS
38: aPlsqlItem DPP_LISTPRICE_PVT.DPP_TXN_HDR_REC_TYPE;
39: BEGIN
40: aPlsqlItem.TRANSACTION_HEADER_ID := aSqlItem.TRANSACTION_HEADER_ID;
41: aPlsqlItem.TRANSACTION_NUMBER := aSqlItem.TRANSACTION_NUMBER;
42: aPlsqlItem.ORG_ID := aSqlItem.ORG_ID;

Line 66: FUNCTION PL_TO_SQL23(aPlsqlItem DPP_LISTPRICE_PVT.DPP_TXN_LINE_REC_TYPE)

62: aPlsqlItem.ATTRIBUTE14 := aSqlItem.ATTRIBUTE14;
63: aPlsqlItem.ATTRIBUTE15 := aSqlItem.ATTRIBUTE15;
64: RETURN aPlsqlItem;
65: END SQL_TO_PL22;
66: FUNCTION PL_TO_SQL23(aPlsqlItem DPP_LISTPRICE_PVT.DPP_TXN_LINE_REC_TYPE)
67: RETURN DPP_LISTPRICE_PVT_DPP_TXN_L14 IS
68: aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_L14;
69: BEGIN
70: -- initialize the object

Line 67: RETURN DPP_LISTPRICE_PVT_DPP_TXN_L14 IS

63: aPlsqlItem.ATTRIBUTE15 := aSqlItem.ATTRIBUTE15;
64: RETURN aPlsqlItem;
65: END SQL_TO_PL22;
66: FUNCTION PL_TO_SQL23(aPlsqlItem DPP_LISTPRICE_PVT.DPP_TXN_LINE_REC_TYPE)
67: RETURN DPP_LISTPRICE_PVT_DPP_TXN_L14 IS
68: aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_L14;
69: BEGIN
70: -- initialize the object
71: aSqlItem := DPP_LISTPRICE_PVT_DPP_TXN_L14(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 68: aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_L14;

64: RETURN aPlsqlItem;
65: END SQL_TO_PL22;
66: FUNCTION PL_TO_SQL23(aPlsqlItem DPP_LISTPRICE_PVT.DPP_TXN_LINE_REC_TYPE)
67: RETURN DPP_LISTPRICE_PVT_DPP_TXN_L14 IS
68: aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_L14;
69: BEGIN
70: -- initialize the object
71: aSqlItem := DPP_LISTPRICE_PVT_DPP_TXN_L14(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
72: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

Line 71: aSqlItem := DPP_LISTPRICE_PVT_DPP_TXN_L14(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

67: RETURN DPP_LISTPRICE_PVT_DPP_TXN_L14 IS
68: aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_L14;
69: BEGIN
70: -- initialize the object
71: aSqlItem := DPP_LISTPRICE_PVT_DPP_TXN_L14(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
72: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
73: aSqlItem.TRANSACTION_LINE_ID := aPlsqlItem.TRANSACTION_LINE_ID;
74: aSqlItem.INVENTORY_ITEM_ID := aPlsqlItem.INVENTORY_ITEM_ID;
75: aSqlItem.ITEM_NUMBER := aPlsqlItem.ITEM_NUMBER;

Line 99: FUNCTION SQL_TO_PL24(aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_L14)

95: aSqlItem.UPDATE_STATUS := aPlsqlItem.UPDATE_STATUS;
96: aSqlItem.REASON_FOR_FAILURE := aPlsqlItem.REASON_FOR_FAILURE;
97: RETURN aSqlItem;
98: END PL_TO_SQL23;
99: FUNCTION SQL_TO_PL24(aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_L14)
100: RETURN DPP_LISTPRICE_PVT.DPP_TXN_LINE_REC_TYPE IS
101: aPlsqlItem DPP_LISTPRICE_PVT.DPP_TXN_LINE_REC_TYPE;
102: BEGIN
103: aPlsqlItem.TRANSACTION_LINE_ID := aSqlItem.TRANSACTION_LINE_ID;

Line 100: RETURN DPP_LISTPRICE_PVT.DPP_TXN_LINE_REC_TYPE IS

96: aSqlItem.REASON_FOR_FAILURE := aPlsqlItem.REASON_FOR_FAILURE;
97: RETURN aSqlItem;
98: END PL_TO_SQL23;
99: FUNCTION SQL_TO_PL24(aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_L14)
100: RETURN DPP_LISTPRICE_PVT.DPP_TXN_LINE_REC_TYPE IS
101: aPlsqlItem DPP_LISTPRICE_PVT.DPP_TXN_LINE_REC_TYPE;
102: BEGIN
103: aPlsqlItem.TRANSACTION_LINE_ID := aSqlItem.TRANSACTION_LINE_ID;
104: aPlsqlItem.INVENTORY_ITEM_ID := aSqlItem.INVENTORY_ITEM_ID;

Line 101: aPlsqlItem DPP_LISTPRICE_PVT.DPP_TXN_LINE_REC_TYPE;

97: RETURN aSqlItem;
98: END PL_TO_SQL23;
99: FUNCTION SQL_TO_PL24(aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_L14)
100: RETURN DPP_LISTPRICE_PVT.DPP_TXN_LINE_REC_TYPE IS
101: aPlsqlItem DPP_LISTPRICE_PVT.DPP_TXN_LINE_REC_TYPE;
102: BEGIN
103: aPlsqlItem.TRANSACTION_LINE_ID := aSqlItem.TRANSACTION_LINE_ID;
104: aPlsqlItem.INVENTORY_ITEM_ID := aSqlItem.INVENTORY_ITEM_ID;
105: aPlsqlItem.ITEM_NUMBER := aSqlItem.ITEM_NUMBER;

Line 129: FUNCTION PL_TO_SQL24(aPlsqlItem DPP_LISTPRICE_PVT.DPP_TXN_LINE_TBL_TYPE)

125: aPlsqlItem.UPDATE_STATUS := aSqlItem.UPDATE_STATUS;
126: aPlsqlItem.REASON_FOR_FAILURE := aSqlItem.REASON_FOR_FAILURE;
127: RETURN aPlsqlItem;
128: END SQL_TO_PL24;
129: FUNCTION PL_TO_SQL24(aPlsqlItem DPP_LISTPRICE_PVT.DPP_TXN_LINE_TBL_TYPE)
130: RETURN DPP_LISTPRICE_PVT_DPP_TXN_L13 IS
131: aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_L13;
132: BEGIN
133: -- initialize the table

Line 130: RETURN DPP_LISTPRICE_PVT_DPP_TXN_L13 IS

126: aPlsqlItem.REASON_FOR_FAILURE := aSqlItem.REASON_FOR_FAILURE;
127: RETURN aPlsqlItem;
128: END SQL_TO_PL24;
129: FUNCTION PL_TO_SQL24(aPlsqlItem DPP_LISTPRICE_PVT.DPP_TXN_LINE_TBL_TYPE)
130: RETURN DPP_LISTPRICE_PVT_DPP_TXN_L13 IS
131: aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_L13;
132: BEGIN
133: -- initialize the table
134: aSqlItem := DPP_LISTPRICE_PVT_DPP_TXN_L13();

Line 131: aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_L13;

127: RETURN aPlsqlItem;
128: END SQL_TO_PL24;
129: FUNCTION PL_TO_SQL24(aPlsqlItem DPP_LISTPRICE_PVT.DPP_TXN_LINE_TBL_TYPE)
130: RETURN DPP_LISTPRICE_PVT_DPP_TXN_L13 IS
131: aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_L13;
132: BEGIN
133: -- initialize the table
134: aSqlItem := DPP_LISTPRICE_PVT_DPP_TXN_L13();
135: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 134: aSqlItem := DPP_LISTPRICE_PVT_DPP_TXN_L13();

130: RETURN DPP_LISTPRICE_PVT_DPP_TXN_L13 IS
131: aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_L13;
132: BEGIN
133: -- initialize the table
134: aSqlItem := DPP_LISTPRICE_PVT_DPP_TXN_L13();
135: aSqlItem.EXTEND(aPlsqlItem.COUNT);
136: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
137: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL23(aPlsqlItem(I));
138: END LOOP;

Line 141: FUNCTION SQL_TO_PL23(aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_L13)

137: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL23(aPlsqlItem(I));
138: END LOOP;
139: RETURN aSqlItem;
140: END PL_TO_SQL24;
141: FUNCTION SQL_TO_PL23(aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_L13)
142: RETURN DPP_LISTPRICE_PVT.DPP_TXN_LINE_TBL_TYPE IS
143: aPlsqlItem DPP_LISTPRICE_PVT.DPP_TXN_LINE_TBL_TYPE;
144: BEGIN
145: FOR I IN 1..aSqlItem.COUNT LOOP

Line 142: RETURN DPP_LISTPRICE_PVT.DPP_TXN_LINE_TBL_TYPE IS

138: END LOOP;
139: RETURN aSqlItem;
140: END PL_TO_SQL24;
141: FUNCTION SQL_TO_PL23(aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_L13)
142: RETURN DPP_LISTPRICE_PVT.DPP_TXN_LINE_TBL_TYPE IS
143: aPlsqlItem DPP_LISTPRICE_PVT.DPP_TXN_LINE_TBL_TYPE;
144: BEGIN
145: FOR I IN 1..aSqlItem.COUNT LOOP
146: aPlsqlItem(I) := SQL_TO_PL24(aSqlItem(I));

Line 143: aPlsqlItem DPP_LISTPRICE_PVT.DPP_TXN_LINE_TBL_TYPE;

139: RETURN aSqlItem;
140: END PL_TO_SQL24;
141: FUNCTION SQL_TO_PL23(aSqlItem DPP_LISTPRICE_PVT_DPP_TXN_L13)
142: RETURN DPP_LISTPRICE_PVT.DPP_TXN_LINE_TBL_TYPE IS
143: aPlsqlItem DPP_LISTPRICE_PVT.DPP_TXN_LINE_TBL_TYPE;
144: BEGIN
145: FOR I IN 1..aSqlItem.COUNT LOOP
146: aPlsqlItem(I) := SQL_TO_PL24(aSqlItem(I));
147: END LOOP;

Line 151: PROCEDURE DPP_LISTPRICE_PVT$UPDATE_LIST (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,P_VALIDATION_LEVEL NUMBER,

147: END LOOP;
148: RETURN aPlsqlItem;
149: END SQL_TO_PL23;
150:
151: PROCEDURE DPP_LISTPRICE_PVT$UPDATE_LIST (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,P_VALIDATION_LEVEL NUMBER,
152: X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,X_MSG_DATA OUT NOCOPY VARCHAR2,
153: P_TXN_HDR_REC DPP_LISTPRICE_PVT_DPP_TXN_H12,P_ITEM_COST_TBL DPP_LISTPRICE_PVT_DPP_TXN_L13) IS
154: P_TXN_HDR_REC_ APPS.DPP_LISTPRICE_PVT.DPP_TXN_HDR_REC_TYPE;
155: P_ITEM_COST_TBL_ APPS.DPP_LISTPRICE_PVT.DPP_TXN_LINE_TBL_TYPE;

Line 153: P_TXN_HDR_REC DPP_LISTPRICE_PVT_DPP_TXN_H12,P_ITEM_COST_TBL DPP_LISTPRICE_PVT_DPP_TXN_L13) IS

149: END SQL_TO_PL23;
150:
151: PROCEDURE DPP_LISTPRICE_PVT$UPDATE_LIST (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,P_VALIDATION_LEVEL NUMBER,
152: X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,X_MSG_DATA OUT NOCOPY VARCHAR2,
153: P_TXN_HDR_REC DPP_LISTPRICE_PVT_DPP_TXN_H12,P_ITEM_COST_TBL DPP_LISTPRICE_PVT_DPP_TXN_L13) IS
154: P_TXN_HDR_REC_ APPS.DPP_LISTPRICE_PVT.DPP_TXN_HDR_REC_TYPE;
155: P_ITEM_COST_TBL_ APPS.DPP_LISTPRICE_PVT.DPP_TXN_LINE_TBL_TYPE;
156: BEGIN
157: P_TXN_HDR_REC_ := DPP_BPEL_UPDATELISTPRICE.SQL_TO_PL22(P_TXN_HDR_REC);

Line 154: P_TXN_HDR_REC_ APPS.DPP_LISTPRICE_PVT.DPP_TXN_HDR_REC_TYPE;

150:
151: PROCEDURE DPP_LISTPRICE_PVT$UPDATE_LIST (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,P_VALIDATION_LEVEL NUMBER,
152: X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,X_MSG_DATA OUT NOCOPY VARCHAR2,
153: P_TXN_HDR_REC DPP_LISTPRICE_PVT_DPP_TXN_H12,P_ITEM_COST_TBL DPP_LISTPRICE_PVT_DPP_TXN_L13) IS
154: P_TXN_HDR_REC_ APPS.DPP_LISTPRICE_PVT.DPP_TXN_HDR_REC_TYPE;
155: P_ITEM_COST_TBL_ APPS.DPP_LISTPRICE_PVT.DPP_TXN_LINE_TBL_TYPE;
156: BEGIN
157: P_TXN_HDR_REC_ := DPP_BPEL_UPDATELISTPRICE.SQL_TO_PL22(P_TXN_HDR_REC);
158: P_ITEM_COST_TBL_ := DPP_BPEL_UPDATELISTPRICE.SQL_TO_PL23(P_ITEM_COST_TBL);

Line 155: P_ITEM_COST_TBL_ APPS.DPP_LISTPRICE_PVT.DPP_TXN_LINE_TBL_TYPE;

151: PROCEDURE DPP_LISTPRICE_PVT$UPDATE_LIST (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,P_VALIDATION_LEVEL NUMBER,
152: X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,X_MSG_DATA OUT NOCOPY VARCHAR2,
153: P_TXN_HDR_REC DPP_LISTPRICE_PVT_DPP_TXN_H12,P_ITEM_COST_TBL DPP_LISTPRICE_PVT_DPP_TXN_L13) IS
154: P_TXN_HDR_REC_ APPS.DPP_LISTPRICE_PVT.DPP_TXN_HDR_REC_TYPE;
155: P_ITEM_COST_TBL_ APPS.DPP_LISTPRICE_PVT.DPP_TXN_LINE_TBL_TYPE;
156: BEGIN
157: P_TXN_HDR_REC_ := DPP_BPEL_UPDATELISTPRICE.SQL_TO_PL22(P_TXN_HDR_REC);
158: P_ITEM_COST_TBL_ := DPP_BPEL_UPDATELISTPRICE.SQL_TO_PL23(P_ITEM_COST_TBL);
159: APPS.DPP_LISTPRICE_PVT.UPDATE_LISTPRICE(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA,P_TXN_HDR_REC_,P_ITEM_COST_TBL_);

Line 159: APPS.DPP_LISTPRICE_PVT.UPDATE_LISTPRICE(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA,P_TXN_HDR_REC_,P_ITEM_COST_TBL_);

155: P_ITEM_COST_TBL_ APPS.DPP_LISTPRICE_PVT.DPP_TXN_LINE_TBL_TYPE;
156: BEGIN
157: P_TXN_HDR_REC_ := DPP_BPEL_UPDATELISTPRICE.SQL_TO_PL22(P_TXN_HDR_REC);
158: P_ITEM_COST_TBL_ := DPP_BPEL_UPDATELISTPRICE.SQL_TO_PL23(P_ITEM_COST_TBL);
159: APPS.DPP_LISTPRICE_PVT.UPDATE_LISTPRICE(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA,P_TXN_HDR_REC_,P_ITEM_COST_TBL_);
160: END DPP_LISTPRICE_PVT$UPDATE_LIST;
161:
162: END DPP_BPEL_UPDATELISTPRICE;

Line 160: END DPP_LISTPRICE_PVT$UPDATE_LIST;

156: BEGIN
157: P_TXN_HDR_REC_ := DPP_BPEL_UPDATELISTPRICE.SQL_TO_PL22(P_TXN_HDR_REC);
158: P_ITEM_COST_TBL_ := DPP_BPEL_UPDATELISTPRICE.SQL_TO_PL23(P_ITEM_COST_TBL);
159: APPS.DPP_LISTPRICE_PVT.UPDATE_LISTPRICE(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA,P_TXN_HDR_REC_,P_ITEM_COST_TBL_);
160: END DPP_LISTPRICE_PVT$UPDATE_LIST;
161:
162: END DPP_BPEL_UPDATELISTPRICE;