DBA Data[Home] [Help]

APPS.PO_PRICE_ADJ_DRAFT_PVT dependencies on PO_LOG

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

1: PACKAGE BODY PO_PRICE_ADJ_DRAFT_PVT AS
2: /* $Header: PO_PRICE_ADJ_DRAFT_PVT.plb 120.0.12010000.1 2009/06/01 23:33:50 ababujan noship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) :=
5: PO_LOG.get_package_base('PO_PRICE_ADJ_DRAFT_PVT');
6:
7: -----------------------------------------------------------------------
8: --Start of Comments
9: --Name: draft_changes_exist

Line 55: IF (PO_LOG.d_proc) THEN

51: l_dft_exists_index_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
52:
53: BEGIN
54: d_position := 0;
55: IF (PO_LOG.d_proc) THEN
56: PO_LOG.proc_begin(d_module);
57: END IF;
58:
59: l_index_tbl.extend(p_draft_id_tbl.COUNT);

Line 56: PO_LOG.proc_begin(d_module);

52:
53: BEGIN
54: d_position := 0;
55: IF (PO_LOG.d_proc) THEN
56: PO_LOG.proc_begin(d_module);
57: END IF;
58:
59: l_index_tbl.extend(p_draft_id_tbl.COUNT);
60: l_dft_exists_tbl.extend(p_draft_id_tbl.COUNT);

Line 106: IF (PO_LOG.d_stmt) THEN

102: FOR i IN 1..l_dft_exists_index_tbl.COUNT LOOP
103: l_dft_exists_tbl(l_dft_exists_index_tbl(i)) := FND_API.G_TRUE;
104: END LOOP;
105:
106: IF (PO_LOG.d_stmt) THEN
107: PO_LOG.stmt(d_module, d_position, '# of records that have dft changes',
108: l_dft_exists_index_tbl.COUNT);
109: END IF;
110:

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

103: l_dft_exists_tbl(l_dft_exists_index_tbl(i)) := FND_API.G_TRUE;
104: END LOOP;
105:
106: IF (PO_LOG.d_stmt) THEN
107: PO_LOG.stmt(d_module, d_position, '# of records that have dft changes',
108: l_dft_exists_index_tbl.COUNT);
109: END IF;
110:
111: RETURN l_dft_exists_tbl;

Line 158: IF (PO_LOG.d_proc) THEN

154:
155: l_exists_tbl PO_TBL_VARCHAR1;
156: BEGIN
157: d_position := 0;
158: IF (PO_LOG.d_proc) THEN
159: PO_LOG.proc_begin(d_module);
160: END IF;
161:
162: l_exists_tbl :=

Line 159: PO_LOG.proc_begin(d_module);

155: l_exists_tbl PO_TBL_VARCHAR1;
156: BEGIN
157: d_position := 0;
158: IF (PO_LOG.d_proc) THEN
159: PO_LOG.proc_begin(d_module);
160: END IF;
161:
162: l_exists_tbl :=
163: draft_changes_exist

Line 168: IF (PO_LOG.d_stmt) THEN

164: ( p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),
165: p_price_adjustment_id_tbl => PO_TBL_NUMBER(p_price_adjustment_id)
166: );
167:
168: IF (PO_LOG.d_stmt) THEN
169: PO_LOG.stmt(d_module, d_position, 'exists', l_exists_tbl(1));
170: END IF;
171:
172: RETURN l_exists_tbl(1);

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

165: p_price_adjustment_id_tbl => PO_TBL_NUMBER(p_price_adjustment_id)
166: );
167:
168: IF (PO_LOG.d_stmt) THEN
169: PO_LOG.stmt(d_module, d_position, 'exists', l_exists_tbl(1));
170: END IF;
171:
172: RETURN l_exists_tbl(1);
173:

Line 215: IF (PO_LOG.d_proc) THEN

211: d_position NUMBER;
212:
213: BEGIN
214: d_position := 0;
215: IF (PO_LOG.d_proc) THEN
216: PO_LOG.proc_begin(d_module);
217: END IF;
218:
219: IF (p_draft_info.price_adj_changed = FND_API.G_FALSE) THEN

Line 216: PO_LOG.proc_begin(d_module);

212:
213: BEGIN
214: d_position := 0;
215: IF (PO_LOG.d_proc) THEN
216: PO_LOG.proc_begin(d_module);
217: END IF;
218:
219: IF (p_draft_info.price_adj_changed = FND_API.G_FALSE) THEN
220: IF (PO_LOG.d_stmt) THEN

Line 220: IF (PO_LOG.d_stmt) THEN

216: PO_LOG.proc_begin(d_module);
217: END IF;
218:
219: IF (p_draft_info.price_adj_changed = FND_API.G_FALSE) THEN
220: IF (PO_LOG.d_stmt) THEN
221: PO_LOG.stmt(d_module, d_position, 'no change-no need to apply');
222: END IF;
223:
224: RETURN;

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

217: END IF;
218:
219: IF (p_draft_info.price_adj_changed = FND_API.G_FALSE) THEN
220: IF (PO_LOG.d_stmt) THEN
221: PO_LOG.stmt(d_module, d_position, 'no change-no need to apply');
222: END IF;
223:
224: RETURN;
225: END IF;