DBA Data[Home] [Help]

APPS.PO_GA_ORG_ASSIGN_DRAFT_PVT dependencies on PO_LOG

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

1: PACKAGE BODY PO_GA_ORG_ASSIGN_DRAFT_PVT AS
2: /* $Header: PO_GA_ORG_ASSIGN_DRAFT_PVT.plb 120.2 2005/07/26 16:21 bao noship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) :=
5: PO_LOG.get_package_base('PO_GA_ORG_ASSIGN_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 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_org_assignment_id_tbl => PO_TBL_NUMBER(p_org_assignment_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_org_assignment_id_tbl => PO_TBL_NUMBER(p_org_assignment_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 216: IF (PO_LOG.d_proc) THEN

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

Line 217: PO_LOG.proc_begin(d_module);

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

Line 221: IF (PO_LOG.d_stmt) THEN

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

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

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