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.PO_PRICE_DIFFERENTIALS_PKG dependencies on PO_PRICE_DIFFERENTIALS

Line 1: PACKAGE BODY PO_PRICE_DIFFERENTIALS_PKG AS

1: PACKAGE BODY PO_PRICE_DIFFERENTIALS_PKG AS
2: /* $Header: POXVPDTB.pls 120.1 2005/08/31 07:13:45 arudas noship $*/
3:
4: -------------------------------------------------------------------------------
5: -------------------------------------------------------------------------------

Line 24: ( p_price_differential_rec IN PO_PRICE_DIFFERENTIALS%ROWTYPE

20: --End of Comments
21: -------------------------------------------------------------------------------
22: -------------------------------------------------------------------------------
23: PROCEDURE insert_row
24: ( p_price_differential_rec IN PO_PRICE_DIFFERENTIALS%ROWTYPE
25: , x_row_id OUT NOCOPY ROWID
26: )
27: IS
28: BEGIN

Line 30: -- Insert record into PO_PRICE_DIFFERENTIALS base table

26: )
27: IS
28: BEGIN
29:
30: -- Insert record into PO_PRICE_DIFFERENTIALS base table
31: --
32: INSERT INTO po_price_differentials
33: ( price_differential_id
34: , price_differential_num

Line 32: INSERT INTO po_price_differentials

28: BEGIN
29:
30: -- Insert record into PO_PRICE_DIFFERENTIALS base table
31: --
32: INSERT INTO po_price_differentials
33: ( price_differential_id
34: , price_differential_num
35: , entity_type
36: , entity_id

Line 70: PO_MESSAGE_S.sql_error('PO_PRICE_DIFFERENTIALS_PKG.insert_row','000',sqlcode);

66:
67: EXCEPTION
68:
69: WHEN OTHERS THEN
70: PO_MESSAGE_S.sql_error('PO_PRICE_DIFFERENTIALS_PKG.insert_row','000',sqlcode);
71: raise;
72:
73: END insert_row;
74:

Line 95: ( p_price_differential_rec IN PO_PRICE_DIFFERENTIALS%ROWTYPE

91: --End of Comments
92: -------------------------------------------------------------------------------
93: -------------------------------------------------------------------------------
94: PROCEDURE update_row
95: ( p_price_differential_rec IN PO_PRICE_DIFFERENTIALS%ROWTYPE
96: , p_row_id IN ROWID
97: )
98: IS
99: BEGIN

Line 101: -- Update record in PO_PRICE_DIFFERENTIALS base table

97: )
98: IS
99: BEGIN
100:
101: -- Update record in PO_PRICE_DIFFERENTIALS base table
102: --
103: UPDATE po_price_differentials
104: SET price_differential_num = p_price_differential_rec.price_differential_num
105: , price_type = p_price_differential_rec.price_type

Line 103: UPDATE po_price_differentials

99: BEGIN
100:
101: -- Update record in PO_PRICE_DIFFERENTIALS base table
102: --
103: UPDATE po_price_differentials
104: SET price_differential_num = p_price_differential_rec.price_differential_num
105: , price_type = p_price_differential_rec.price_type
106: , multiplier = p_price_differential_rec.multiplier
107: , min_multiplier = p_price_differential_rec.min_multiplier

Line 118: PO_MESSAGE_S.sql_error('PO_PRICE_DIFFERENTIALS_PKG.lock_row','000',sqlcode);

114:
115: EXCEPTION
116:
117: WHEN OTHERS THEN
118: PO_MESSAGE_S.sql_error('PO_PRICE_DIFFERENTIALS_PKG.lock_row','000',sqlcode);
119: raise;
120:
121: END update_row;
122:

Line 144: ( p_form_rec IN PO_PRICE_DIFFERENTIALS%ROWTYPE

140: --End of Comments
141: -------------------------------------------------------------------------------
142: -------------------------------------------------------------------------------
143: PROCEDURE lock_row
144: ( p_form_rec IN PO_PRICE_DIFFERENTIALS%ROWTYPE
145: , p_row_id IN ROWID
146: )
147: IS
148: l_db_rec PO_PRICE_DIFFERENTIALS%ROWTYPE;

Line 148: l_db_rec PO_PRICE_DIFFERENTIALS%ROWTYPE;

144: ( p_form_rec IN PO_PRICE_DIFFERENTIALS%ROWTYPE
145: , p_row_id IN ROWID
146: )
147: IS
148: l_db_rec PO_PRICE_DIFFERENTIALS%ROWTYPE;
149:
150: CURSOR price_diff_csr IS
151: SELECT *
152: FROM po_price_differentials

Line 152: FROM po_price_differentials

148: l_db_rec PO_PRICE_DIFFERENTIALS%ROWTYPE;
149:
150: CURSOR price_diff_csr IS
151: SELECT *
152: FROM po_price_differentials
153: WHERE rowid = p_row_id
154: FOR UPDATE NOWAIT;
155:
156: BEGIN

Line 208: PO_MESSAGE_S.sql_error('PO_PRICE_DIFFERENTIALS_PKG.lock_row','000',sqlcode);

204:
205: EXCEPTION
206:
207: WHEN OTHERS THEN
208: PO_MESSAGE_S.sql_error('PO_PRICE_DIFFERENTIALS_PKG.lock_row','000',sqlcode);
209: RAISE;
210:
211: END lock_row;
212:

Line 240: DELETE FROM PO_PRICE_DIFFERENTIALS

236: )
237: IS
238: BEGIN
239:
240: DELETE FROM PO_PRICE_DIFFERENTIALS
241: WHERE rowid = p_row_id;
242:
243: EXCEPTION
244:

Line 246: PO_MESSAGE_S.sql_error('PO_PRICE_DIFFERENTIALS_PKG.delete_row','000',sqlcode);

242:
243: EXCEPTION
244:
245: WHEN OTHERS THEN
246: PO_MESSAGE_S.sql_error('PO_PRICE_DIFFERENTIALS_PKG.delete_row','000',sqlcode);
247: RAISE;
248:
249: END delete_row;
250:

Line 258: -- PO_PRICE_DIFFERENTIALS.

254: --Name: del_level_specific_price_diff
255: --Pre-reqs:
256: -- None.
257: --Modifies:
258: -- PO_PRICE_DIFFERENTIALS.
259: --Locks:
260: -- None.
261: --Function:
262: -- Deletes all the price differentials for a given document level and document

Line 278: l_entity_type PO_PRICE_DIFFERENTIALS.entity_type%type := NULL;

274:
275: PROCEDURE del_level_specific_price_diff( p_doc_level IN VARCHAR2
276: ,p_doc_level_id IN NUMBER)
277: IS
278: l_entity_type PO_PRICE_DIFFERENTIALS.entity_type%type := NULL;
279:
280: d_module_name CONSTANT VARCHAR2(100) := 'DEL_LEVEL_SPECIFIC_PRICE_DIFF';
281: d_module_base CONSTANT VARCHAR2(70) := 'po.plsql.PO_PRICE_DIFFERENTIALS_PKG.del_level_specific_price_diff';
282: d_pos NUMBER := 0;

Line 281: d_module_base CONSTANT VARCHAR2(70) := 'po.plsql.PO_PRICE_DIFFERENTIALS_PKG.del_level_specific_price_diff';

277: IS
278: l_entity_type PO_PRICE_DIFFERENTIALS.entity_type%type := NULL;
279:
280: d_module_name CONSTANT VARCHAR2(100) := 'DEL_LEVEL_SPECIFIC_PRICE_DIFF';
281: d_module_base CONSTANT VARCHAR2(70) := 'po.plsql.PO_PRICE_DIFFERENTIALS_PKG.del_level_specific_price_diff';
282: d_pos NUMBER := 0;
283: BEGIN
284: IF (PO_LOG.d_proc) THEN
285: PO_LOG.proc_begin(d_module_base, 'p_doc_level', p_doc_level); PO_LOG.proc_begin(d_module_base, 'p_doc_level_id', p_doc_level_id);

Line 289: l_entity_type := PO_PRICE_DIFFERENTIALS_PVT.get_entity_type(

285: PO_LOG.proc_begin(d_module_base, 'p_doc_level', p_doc_level); PO_LOG.proc_begin(d_module_base, 'p_doc_level_id', p_doc_level_id);
286: END IF;
287:
288: --Get Price differentials entity type for the given Line
289: l_entity_type := PO_PRICE_DIFFERENTIALS_PVT.get_entity_type(
290: p_doc_level => p_doc_level
291: ,p_doc_level_id => p_doc_level_id);
292:
293: IF(PO_LOG.d_stmt) THEN

Line 303: PO_PRICE_DIFFERENTIALS_PVT.delete_price_differentials(

299: RAISE PO_CORE_S.g_early_return_exc ;
300: END IF;
301:
302: d_pos :=20;
303: PO_PRICE_DIFFERENTIALS_PVT.delete_price_differentials(
304: p_entity_type => l_entity_type
305: ,p_entity_id => p_doc_level_id);
306:
307: d_pos :=30;

Line 328: END PO_PRICE_DIFFERENTIALS_PKG;

324: RAISE;
325: END del_level_specific_price_diff;
326: --
327:
328: END PO_PRICE_DIFFERENTIALS_PKG;