DBA Data[Home] [Help]

APPS.PO_ATTR_VALUES_TLP_DRAFT_PVT dependencies on PO_LOG

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

1: PACKAGE BODY PO_ATTR_VALUES_TLP_DRAFT_PVT AS
2: /* $Header: PO_ATTR_VALUES_TLP_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_TLP_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 164: IF (PO_LOG.d_proc) THEN

160:
161: l_exists_tbl PO_TBL_VARCHAR1;
162: BEGIN
163: d_position := 0;
164: IF (PO_LOG.d_proc) THEN
165: PO_LOG.proc_begin(d_module);
166: END IF;
167:
168: l_exists_tbl :=

Line 165: PO_LOG.proc_begin(d_module);

161: l_exists_tbl PO_TBL_VARCHAR1;
162: BEGIN
163: d_position := 0;
164: IF (PO_LOG.d_proc) THEN
165: PO_LOG.proc_begin(d_module);
166: END IF;
167:
168: l_exists_tbl :=
169: draft_changes_exist

Line 174: IF (PO_LOG.d_stmt) THEN

170: ( p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),
171: p_attribute_values_tlp_id_tbl => PO_TBL_NUMBER(p_attribute_values_tlp_id)
172: );
173:
174: IF (PO_LOG.d_stmt) THEN
175: PO_LOG.stmt(d_module, d_position, 'exists', l_exists_tbl(1));
176: END IF;
177:
178: RETURN l_exists_tbl(1);

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

171: p_attribute_values_tlp_id_tbl => PO_TBL_NUMBER(p_attribute_values_tlp_id)
172: );
173:
174: IF (PO_LOG.d_stmt) THEN
175: PO_LOG.stmt(d_module, d_position, 'exists', l_exists_tbl(1));
176: END IF;
177:
178: RETURN l_exists_tbl(1);
179:

Line 221: IF (PO_LOG.d_proc) THEN

217: d_position NUMBER;
218:
219: BEGIN
220: d_position := 0;
221: IF (PO_LOG.d_proc) THEN
222: PO_LOG.proc_begin(d_module);
223: END IF;
224:
225: IF (p_draft_info.attr_values_tlp_changed = FND_API.G_FALSE) THEN

Line 222: PO_LOG.proc_begin(d_module);

218:
219: BEGIN
220: d_position := 0;
221: IF (PO_LOG.d_proc) THEN
222: PO_LOG.proc_begin(d_module);
223: END IF;
224:
225: IF (p_draft_info.attr_values_tlp_changed = FND_API.G_FALSE) THEN
226: IF (PO_LOG.d_stmt) THEN

Line 226: IF (PO_LOG.d_stmt) THEN

222: PO_LOG.proc_begin(d_module);
223: END IF;
224:
225: IF (p_draft_info.attr_values_tlp_changed = FND_API.G_FALSE) THEN
226: IF (PO_LOG.d_stmt) THEN
227: PO_LOG.stmt(d_module, d_position, 'no change-no need to apply');
228: END IF;
229:
230: RETURN;

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

223: END IF;
224:
225: IF (p_draft_info.attr_values_tlp_changed = FND_API.G_FALSE) THEN
226: IF (PO_LOG.d_stmt) THEN
227: PO_LOG.stmt(d_module, d_position, 'no change-no need to apply');
228: END IF;
229:
230: RETURN;
231: END IF;