DBA Data[Home] [Help]

APPS.PO_LINES_DRAFT_PVT dependencies on PO_LOG

Line 5: PO_LOG.get_package_base('PO_LINES_DRAFT_PVT');

1: PACKAGE BODY PO_LINES_DRAFT_PVT AS
2: /* $Header: PO_LINES_DRAFT_PVT.plb 120.3 2006/09/14 01:29:22 bao noship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) :=
5: PO_LOG.get_package_base('PO_LINES_DRAFT_PVT');
6:
7: -------------------------------------------------------
8: ----------- PRIVATE PROCEDURES PROTOTYPE --------------
9: -------------------------------------------------------

Line 71: IF (PO_LOG.d_proc) THEN

67: l_dft_exists_index_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
68:
69: BEGIN
70: d_position := 0;
71: IF (PO_LOG.d_proc) THEN
72: PO_LOG.proc_begin(d_module);
73: END IF;
74:
75: l_index_tbl.extend(p_draft_id_tbl.COUNT);

Line 72: PO_LOG.proc_begin(d_module);

68:
69: BEGIN
70: d_position := 0;
71: IF (PO_LOG.d_proc) THEN
72: PO_LOG.proc_begin(d_module);
73: END IF;
74:
75: l_index_tbl.extend(p_draft_id_tbl.COUNT);
76: l_dft_exists_tbl.extend(p_draft_id_tbl.COUNT);

Line 120: IF (PO_LOG.d_stmt) THEN

116: FOR i IN 1..l_dft_exists_index_tbl.COUNT LOOP
117: l_dft_exists_tbl(l_dft_exists_index_tbl(i)) := FND_API.G_TRUE;
118: END LOOP;
119:
120: IF (PO_LOG.d_stmt) THEN
121: PO_LOG.stmt(d_module, d_position, '# of records that have dft changes',
122: l_dft_exists_index_tbl.COUNT);
123: END IF;
124:

Line 121: PO_LOG.stmt(d_module, d_position, '# of records that have dft changes',

117: l_dft_exists_tbl(l_dft_exists_index_tbl(i)) := FND_API.G_TRUE;
118: END LOOP;
119:
120: IF (PO_LOG.d_stmt) THEN
121: PO_LOG.stmt(d_module, d_position, '# of records that have dft changes',
122: l_dft_exists_index_tbl.COUNT);
123: END IF;
124:
125: RETURN l_dft_exists_tbl;

Line 173: IF (PO_LOG.d_proc) THEN

169:
170: l_exists_tbl PO_TBL_VARCHAR1;
171: BEGIN
172: d_position := 0;
173: IF (PO_LOG.d_proc) THEN
174: PO_LOG.proc_begin(d_module);
175: END IF;
176:
177: l_exists_tbl :=

Line 174: PO_LOG.proc_begin(d_module);

170: l_exists_tbl PO_TBL_VARCHAR1;
171: BEGIN
172: d_position := 0;
173: IF (PO_LOG.d_proc) THEN
174: PO_LOG.proc_begin(d_module);
175: END IF;
176:
177: l_exists_tbl :=
178: draft_changes_exist

Line 183: IF (PO_LOG.d_stmt) THEN

179: ( p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),
180: p_po_line_id_tbl => PO_TBL_NUMBER(p_po_line_id)
181: );
182:
183: IF (PO_LOG.d_stmt) THEN
184: PO_LOG.stmt(d_module, d_position, 'exists', l_exists_tbl(1));
185: END IF;
186:
187: RETURN l_exists_tbl(1);

Line 184: PO_LOG.stmt(d_module, d_position, 'exists', l_exists_tbl(1));

180: p_po_line_id_tbl => PO_TBL_NUMBER(p_po_line_id)
181: );
182:
183: IF (PO_LOG.d_stmt) THEN
184: PO_LOG.stmt(d_module, d_position, 'exists', l_exists_tbl(1));
185: END IF;
186:
187: RETURN l_exists_tbl(1);
188:

Line 233: IF (PO_LOG.d_proc) THEN

229: l_insert_list PO_TBL_NUMBER;
230: l_update_list PO_TBL_NUMBER;
231: BEGIN
232: d_position := 0;
233: IF (PO_LOG.d_proc) THEN
234: PO_LOG.proc_begin(d_module);
235: END IF;
236:
237: IF (p_draft_info.lines_changed = FND_API.G_FALSE) THEN

Line 234: PO_LOG.proc_begin(d_module);

230: l_update_list PO_TBL_NUMBER;
231: BEGIN
232: d_position := 0;
233: IF (PO_LOG.d_proc) THEN
234: PO_LOG.proc_begin(d_module);
235: END IF;
236:
237: IF (p_draft_info.lines_changed = FND_API.G_FALSE) THEN
238: IF (PO_LOG.d_stmt) THEN

Line 238: IF (PO_LOG.d_stmt) THEN

234: PO_LOG.proc_begin(d_module);
235: END IF;
236:
237: IF (p_draft_info.lines_changed = FND_API.G_FALSE) THEN
238: IF (PO_LOG.d_stmt) THEN
239: PO_LOG.stmt(d_module, d_position, 'no change-no need to apply');
240: END IF;
241:
242: RETURN;

Line 239: PO_LOG.stmt(d_module, d_position, 'no change-no need to apply');

235: END IF;
236:
237: IF (p_draft_info.lines_changed = FND_API.G_FALSE) THEN
238: IF (PO_LOG.d_stmt) THEN
239: PO_LOG.stmt(d_module, d_position, 'no change-no need to apply');
240: END IF;
241:
242: RETURN;
243: END IF;

Line 317: IF (PO_LOG.d_proc) THEN

313: l_update_retro_date_flag_tbl PO_TBL_VARCHAR1;
314:
315: BEGIN
316: d_position := 0;
317: IF (PO_LOG.d_proc) THEN
318: PO_LOG.proc_begin(d_module);
319: END IF;
320:
321: IF ((NOT (p_draft_info.doc_type = 'PO' AND

Line 318: PO_LOG.proc_begin(d_module);

314:
315: BEGIN
316: d_position := 0;
317: IF (PO_LOG.d_proc) THEN
318: PO_LOG.proc_begin(d_module);
319: END IF;
320:
321: IF ((NOT (p_draft_info.doc_type = 'PO' AND
322: p_draft_info.doc_subtype = 'STANDARD') AND

Line 362: IF (PO_LOG.d_proc) THEN

358: AND po_line_id = l_po_line_id_tbl(i)
359: AND l_update_retro_date_flag_tbl(i) = 'Y';
360:
361:
362: IF (PO_LOG.d_proc) THEN
363: PO_LOG.proc_end(d_module);
364: END IF;
365:
366: EXCEPTION

Line 363: PO_LOG.proc_end(d_module);

359: AND l_update_retro_date_flag_tbl(i) = 'Y';
360:
361:
362: IF (PO_LOG.d_proc) THEN
363: PO_LOG.proc_end(d_module);
364: END IF;
365:
366: EXCEPTION
367: WHEN OTHERS THEN

Line 424: IF (PO_LOG.d_proc) THEN

420: l_txn_exists_list PO_TBL_VARCHAR1;
421:
422: BEGIN
423: d_position := 0;
424: IF (PO_LOG.d_proc) THEN
425: PO_LOG.proc_begin(d_module);
426: END IF;
427:
428: x_delete_list := PO_TBL_NUMBER();

Line 425: PO_LOG.proc_begin(d_module);

421:
422: BEGIN
423: d_position := 0;
424: IF (PO_LOG.d_proc) THEN
425: PO_LOG.proc_begin(d_module);
426: END IF;
427:
428: x_delete_list := PO_TBL_NUMBER();
429: x_insert_list := PO_TBL_NUMBER();