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
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);
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);
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:
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;
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 :=
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
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);
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:
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
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
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;
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;