DBA Data[Home] [Help]

APPS.PO_DISTRIBUTIONS_DRAFT_PVT dependencies on PO_LOG

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

1: PACKAGE BODY PO_DISTRIBUTIONS_DRAFT_PVT AS
2: /* $Header: PO_DISTRIBUTIONS_DRAFT_PVT.plb 120.3.12020000.2 2013/02/11 01:13:35 vegajula ship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) :=
5: PO_LOG.get_package_base('PO_DISTRIBUTIONS_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 121: IF (PO_LOG.d_stmt) THEN

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

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

118: l_dft_exists_tbl(l_dft_exists_index_tbl(i)) := FND_API.G_TRUE;
119: END LOOP;
120:
121: IF (PO_LOG.d_stmt) THEN
122: PO_LOG.stmt(d_module, d_position, '# of records that have dft changes',
123: l_dft_exists_index_tbl.COUNT);
124: END IF;
125:
126: 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_distribution_id_tbl => PO_TBL_NUMBER(p_po_distribution_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_distribution_id_tbl => PO_TBL_NUMBER(p_po_distribution_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 236: IF (PO_LOG.d_proc) THEN

232: l_clm_document VARCHAR2(1);
233:
234: BEGIN
235: d_position := 0;
236: IF (PO_LOG.d_proc) THEN
237: PO_LOG.proc_begin(d_module);
238: END IF;
239:
240: IF (p_draft_info.distributions_changed = FND_API.G_FALSE) THEN

Line 237: PO_LOG.proc_begin(d_module);

233:
234: BEGIN
235: d_position := 0;
236: IF (PO_LOG.d_proc) THEN
237: PO_LOG.proc_begin(d_module);
238: END IF;
239:
240: IF (p_draft_info.distributions_changed = FND_API.G_FALSE) THEN
241: IF (PO_LOG.d_stmt) THEN

Line 241: IF (PO_LOG.d_stmt) THEN

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

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

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

Line 352: IF (PO_LOG.d_proc) THEN

348: l_txn_exists_list PO_TBL_VARCHAR1;
349:
350: BEGIN
351: d_position := 0;
352: IF (PO_LOG.d_proc) THEN
353: PO_LOG.proc_begin(d_module);
354: END IF;
355:
356: x_delete_list := PO_TBL_NUMBER();

Line 353: PO_LOG.proc_begin(d_module);

349:
350: BEGIN
351: d_position := 0;
352: IF (PO_LOG.d_proc) THEN
353: PO_LOG.proc_begin(d_module);
354: END IF;
355:
356: x_delete_list := PO_TBL_NUMBER();
357: x_insert_list := PO_TBL_NUMBER();