DBA Data[Home] [Help]

APPS.PO_ATTR_VALUES_DRAFT_PVT dependencies on PO_LOG

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

1: PACKAGE BODY PO_ATTR_VALUES_DRAFT_PVT AS
2: /* $Header: PO_ATTR_VALUES_DRAFT_PVT.plb 120.2 2005/07/26 16:22 bao noship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) :=
5: PO_LOG.get_package_base('PO_ATTR_VALUES_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 105: IF (PO_LOG.d_stmt) THEN

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

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

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

Line 157: IF (PO_LOG.d_proc) THEN

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

Line 158: PO_LOG.proc_begin(d_module);

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

Line 167: IF (PO_LOG.d_stmt) THEN

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

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

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

Line 214: IF (PO_LOG.d_proc) THEN

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

Line 215: PO_LOG.proc_begin(d_module);

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

Line 219: IF (PO_LOG.d_stmt) THEN

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

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

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