eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_GA_ORG_ASSIGN_DRAFT_PKG dependencies on PO_LOG

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

1: PACKAGE BODY PO_GA_ORG_ASSIGN_DRAFT_PKG AS
2: /* $Header: PO_GA_ORG_ASSIGN_DRAFT_PKG.plb 120.6 2006/09/28 23:02:36 bao noship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) :=
5: PO_LOG.get_package_base('PO_GA_ORG_ASSIGN_DRAFT_PKG');
6:
7: -----------------------------------------------------------------------
8: --Start of Comments
9: --Name: delete_rows

Line 45: IF (PO_LOG.d_proc) THEN

41: d_position NUMBER;
42:
43: BEGIN
44: d_position := 0;
45: IF (PO_LOG.d_proc) THEN
46: PO_LOG.proc_begin(d_module);
47: END IF;
48:
49: DELETE FROM po_ga_org_assign_draft

Line 46: PO_LOG.proc_begin(d_module);

42:
43: BEGIN
44: d_position := 0;
45: IF (PO_LOG.d_proc) THEN
46: PO_LOG.proc_begin(d_module);
47: END IF;
48:
49: DELETE FROM po_ga_org_assign_draft
50: WHERE draft_id = p_draft_id

Line 109: IF (PO_LOG.d_proc) THEN

105: l_duplicate_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
106:
107: BEGIN
108: d_position := 0;
109: IF (PO_LOG.d_proc) THEN
110: PO_LOG.proc_begin(d_module);
111: END IF;
112:
113: x_record_already_exist_tbl :=

Line 110: PO_LOG.proc_begin(d_module);

106:
107: BEGIN
108: d_position := 0;
109: IF (PO_LOG.d_proc) THEN
110: PO_LOG.proc_begin(d_module);
111: END IF;
112:
113: x_record_already_exist_tbl :=
114: PO_GA_ORG_ASSIGN_DRAFT_PVT.draft_changes_exist

Line 146: IF (PO_LOG.d_stmt) THEN

142: END LOOP;
143: -- bug5471513 END
144:
145: d_position := 10;
146: IF (PO_LOG.d_stmt) THEN
147: PO_LOG.stmt(d_module, d_position, 'transfer records from txn to dft');
148: END IF;
149:
150: FORALL i IN 1..p_org_assignment_id_tbl.COUNT

Line 147: PO_LOG.stmt(d_module, d_position, 'transfer records from txn to dft');

143: -- bug5471513 END
144:
145: d_position := 10;
146: IF (PO_LOG.d_stmt) THEN
147: PO_LOG.stmt(d_module, d_position, 'transfer records from txn to dft');
148: END IF;
149:
150: FORALL i IN 1..p_org_assignment_id_tbl.COUNT
151: INSERT INTO po_ga_org_assign_draft

Line 189: IF (PO_LOG.d_stmt) THEN

185: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
186: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
187:
188: d_position := 20;
189: IF (PO_LOG.d_stmt) THEN
190: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
191: END IF;
192:
193: FORALL i IN 1..p_org_assignment_id_tbl.COUNT

Line 190: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);

186: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
187:
188: d_position := 20;
189: IF (PO_LOG.d_stmt) THEN
190: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
191: END IF;
192:
193: FORALL i IN 1..p_org_assignment_id_tbl.COUNT
194: UPDATE po_ga_org_assign_draft

Line 203: IF (PO_LOG.d_stmt) THEN

199: AND x_record_already_exist_tbl(i) = FND_API.G_TRUE;
200:
201: d_position := 30;
202:
203: IF (PO_LOG.d_stmt) THEN
204: PO_LOG.stmt(d_module, d_position, 'update draft records that are already' ||
205: ' in draft table. Count = ' || SQL%ROWCOUNT);
206: END IF;
207:

Line 204: PO_LOG.stmt(d_module, d_position, 'update draft records that are already' ||

200:
201: d_position := 30;
202:
203: IF (PO_LOG.d_stmt) THEN
204: PO_LOG.stmt(d_module, d_position, 'update draft records that are already' ||
205: ' in draft table. Count = ' || SQL%ROWCOUNT);
206: END IF;
207:
208: d_position := 40;

Line 210: IF (PO_LOG.d_proc) THEN

206: END IF;
207:
208: d_position := 40;
209:
210: IF (PO_LOG.d_proc) THEN
211: PO_LOG.proc_end(d_module);
212: END IF;
213:
214: EXCEPTION

Line 211: PO_LOG.proc_end(d_module);

207:
208: d_position := 40;
209:
210: IF (PO_LOG.d_proc) THEN
211: PO_LOG.proc_end(d_module);
212: END IF;
213:
214: EXCEPTION
215: WHEN OTHERS THEN

Line 265: IF (PO_LOG.d_proc) THEN

261: l_record_already_exist_tbl PO_TBL_VARCHAR1;
262:
263: BEGIN
264: d_position := 0;
265: IF (PO_LOG.d_proc) THEN
266: PO_LOG.proc_begin(d_module);
267: PO_LOG.proc_begin(d_module, 'p_org_assignment_id', p_org_assignment_id);
268: END IF;
269:

Line 266: PO_LOG.proc_begin(d_module);

262:
263: BEGIN
264: d_position := 0;
265: IF (PO_LOG.d_proc) THEN
266: PO_LOG.proc_begin(d_module);
267: PO_LOG.proc_begin(d_module, 'p_org_assignment_id', p_org_assignment_id);
268: END IF;
269:
270: sync_draft_from_txn

Line 267: PO_LOG.proc_begin(d_module, 'p_org_assignment_id', p_org_assignment_id);

263: BEGIN
264: d_position := 0;
265: IF (PO_LOG.d_proc) THEN
266: PO_LOG.proc_begin(d_module);
267: PO_LOG.proc_begin(d_module, 'p_org_assignment_id', p_org_assignment_id);
268: END IF;
269:
270: sync_draft_from_txn
271: ( p_org_assignment_id_tbl => PO_TBL_NUMBER(p_org_assignment_id),

Line 280: IF (PO_LOG.d_proc) THEN

276:
277: x_record_already_exist := l_record_already_exist_tbl(1);
278:
279: d_position := 10;
280: IF (PO_LOG.d_proc) THEN
281: PO_LOG.proc_end(d_module);
282: PO_LOG.proc_end(d_module, 'x_record_already_exist', x_record_already_exist);
283: END IF;
284:

Line 281: PO_LOG.proc_end(d_module);

277: x_record_already_exist := l_record_already_exist_tbl(1);
278:
279: d_position := 10;
280: IF (PO_LOG.d_proc) THEN
281: PO_LOG.proc_end(d_module);
282: PO_LOG.proc_end(d_module, 'x_record_already_exist', x_record_already_exist);
283: END IF;
284:
285: EXCEPTION

Line 282: PO_LOG.proc_end(d_module, 'x_record_already_exist', x_record_already_exist);

278:
279: d_position := 10;
280: IF (PO_LOG.d_proc) THEN
281: PO_LOG.proc_end(d_module);
282: PO_LOG.proc_end(d_module, 'x_record_already_exist', x_record_already_exist);
283: END IF;
284:
285: EXCEPTION
286: WHEN OTHERS THEN

Line 329: IF (PO_LOG.d_proc) THEN

325:
326: BEGIN
327:
328: d_position := 0;
329: IF (PO_LOG.d_proc) THEN
330: PO_LOG.proc_begin(d_module);
331: END IF;
332:
333: -- Since putting DELETE within MERGE statement is causing database

Line 330: PO_LOG.proc_begin(d_module);

326: BEGIN
327:
328: d_position := 0;
329: IF (PO_LOG.d_proc) THEN
330: PO_LOG.proc_begin(d_module);
331: END IF;
332:
333: -- Since putting DELETE within MERGE statement is causing database
334: -- to thrown internal error, for now we just separate the DELETE statement.

Line 455: IF (PO_LOG.d_proc) THEN

451: l_dummy NUMBER;
452:
453: BEGIN
454: d_position := 0;
455: IF (PO_LOG.d_proc) THEN
456: PO_LOG.proc_begin(d_module);
457: END IF;
458:
459: SELECT 1

Line 456: PO_LOG.proc_begin(d_module);

452:
453: BEGIN
454: d_position := 0;
455: IF (PO_LOG.d_proc) THEN
456: PO_LOG.proc_begin(d_module);
457: END IF;
458:
459: SELECT 1
460: INTO l_dummy

Line 466: IF (PO_LOG.d_proc) THEN

462: WHERE org_assignment_id = p_org_assignment_id
463: AND draft_id = p_draft_id
464: FOR UPDATE NOWAIT;
465:
466: IF (PO_LOG.d_proc) THEN
467: PO_LOG.proc_end(d_module);
468: END IF;
469:
470: EXCEPTION

Line 467: PO_LOG.proc_end(d_module);

463: AND draft_id = p_draft_id
464: FOR UPDATE NOWAIT;
465:
466: IF (PO_LOG.d_proc) THEN
467: PO_LOG.proc_end(d_module);
468: END IF;
469:
470: EXCEPTION
471: WHEN NO_DATA_FOUND THEN

Line 499: IF (PO_LOG.d_proc) THEN

495: l_dummy NUMBER;
496:
497: BEGIN
498: d_position := 0;
499: IF (PO_LOG.d_proc) THEN
500: PO_LOG.proc_begin(d_module);
501: END IF;
502:
503: SELECT 1

Line 500: PO_LOG.proc_begin(d_module);

496:
497: BEGIN
498: d_position := 0;
499: IF (PO_LOG.d_proc) THEN
500: PO_LOG.proc_begin(d_module);
501: END IF;
502:
503: SELECT 1
504: INTO l_dummy

Line 509: IF (PO_LOG.d_proc) THEN

505: FROM po_ga_org_assignments
506: WHERE org_assignment_id = p_org_assignment_id
507: FOR UPDATE NOWAIT;
508:
509: IF (PO_LOG.d_proc) THEN
510: PO_LOG.proc_end(d_module);
511: END IF;
512:
513: EXCEPTION

Line 510: PO_LOG.proc_end(d_module);

506: WHERE org_assignment_id = p_org_assignment_id
507: FOR UPDATE NOWAIT;
508:
509: IF (PO_LOG.d_proc) THEN
510: PO_LOG.proc_end(d_module);
511: END IF;
512:
513: EXCEPTION
514: WHEN NO_DATA_FOUND THEN