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_HEADERS_DRAFT_PKG dependencies on PO_LOG

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

1: PACKAGE BODY PO_HEADERS_DRAFT_PKG AS
2: /* $Header: PO_HEADERS_DRAFT_PKG.plb 120.8.12010000.3 2008/11/20 10:02:11 vdurbhak ship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) :=
5: PO_LOG.get_package_base('PO_HEADERS_DRAFT_PKG');
6:
7: -----------------------------------------------------------------------
8: --Start of Comments
9: --Name: delete_rows

Line 43: IF (PO_LOG.d_proc) THEN

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

Line 44: PO_LOG.proc_begin(d_module);

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

Line 107: IF (PO_LOG.d_proc) THEN

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

Line 108: PO_LOG.proc_begin(d_module);

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

Line 143: IF (PO_LOG.d_stmt) THEN

139: END IF;
140: END LOOP;
141:
142: d_position := 10;
143: IF (PO_LOG.d_stmt) THEN
144: PO_LOG.stmt(d_module, d_position, 'transfer records from txn to dft');
145: END IF;
146:
147: FORALL i IN 1..p_po_header_id_tbl.COUNT

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

140: END LOOP;
141:
142: d_position := 10;
143: IF (PO_LOG.d_stmt) THEN
144: PO_LOG.stmt(d_module, d_position, 'transfer records from txn to dft');
145: END IF;
146:
147: FORALL i IN 1..p_po_header_id_tbl.COUNT
148: INSERT INTO po_headers_draft_all

Line 477: IF (PO_LOG.d_stmt) THEN

473: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
474: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
475:
476: d_position := 20;
477: IF (PO_LOG.d_stmt) THEN
478: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
479: END IF;
480:
481: FORALL i IN 1..p_po_header_id_tbl.COUNT

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

474: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
475:
476: d_position := 20;
477: IF (PO_LOG.d_stmt) THEN
478: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
479: END IF;
480:
481: FORALL i IN 1..p_po_header_id_tbl.COUNT
482: UPDATE po_headers_draft_all

Line 491: IF (PO_LOG.d_stmt) THEN

487: AND x_record_already_exist_tbl(i) = FND_API.G_TRUE;
488:
489: d_position := 30;
490:
491: IF (PO_LOG.d_stmt) THEN
492: PO_LOG.stmt(d_module, d_position, 'update draft records that are already' ||
493: ' in draft table. Count = ' || SQL%ROWCOUNT);
494: END IF;
495:

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

488:
489: d_position := 30;
490:
491: IF (PO_LOG.d_stmt) THEN
492: PO_LOG.stmt(d_module, d_position, 'update draft records that are already' ||
493: ' in draft table. Count = ' || SQL%ROWCOUNT);
494: END IF;
495:
496: d_position := 40;

Line 498: IF (PO_LOG.d_proc) THEN

494: END IF;
495:
496: d_position := 40;
497:
498: IF (PO_LOG.d_proc) THEN
499: PO_LOG.proc_end(d_module);
500: END IF;
501:
502: EXCEPTION

Line 499: PO_LOG.proc_end(d_module);

495:
496: d_position := 40;
497:
498: IF (PO_LOG.d_proc) THEN
499: PO_LOG.proc_end(d_module);
500: END IF;
501:
502: EXCEPTION
503: WHEN OTHERS THEN

Line 553: IF (PO_LOG.d_proc) THEN

549: l_record_already_exist_tbl PO_TBL_VARCHAR1;
550:
551: BEGIN
552: d_position := 0;
553: IF (PO_LOG.d_proc) THEN
554: PO_LOG.proc_begin(d_module);
555: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
556: END IF;
557:

Line 554: PO_LOG.proc_begin(d_module);

550:
551: BEGIN
552: d_position := 0;
553: IF (PO_LOG.d_proc) THEN
554: PO_LOG.proc_begin(d_module);
555: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
556: END IF;
557:
558: sync_draft_from_txn

Line 555: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);

551: BEGIN
552: d_position := 0;
553: IF (PO_LOG.d_proc) THEN
554: PO_LOG.proc_begin(d_module);
555: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
556: END IF;
557:
558: sync_draft_from_txn
559: ( p_po_header_id_tbl => PO_TBL_NUMBER(p_po_header_id),

Line 568: IF (PO_LOG.d_proc) THEN

564:
565: x_record_already_exist := l_record_already_exist_tbl(1);
566:
567: d_position := 10;
568: IF (PO_LOG.d_proc) THEN
569: PO_LOG.proc_end(d_module);
570: PO_LOG.proc_end(d_module, 'x_record_already_exist', x_record_already_exist);
571: END IF;
572:

Line 569: PO_LOG.proc_end(d_module);

565: x_record_already_exist := l_record_already_exist_tbl(1);
566:
567: d_position := 10;
568: IF (PO_LOG.d_proc) THEN
569: PO_LOG.proc_end(d_module);
570: PO_LOG.proc_end(d_module, 'x_record_already_exist', x_record_already_exist);
571: END IF;
572:
573: EXCEPTION

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

566:
567: d_position := 10;
568: IF (PO_LOG.d_proc) THEN
569: PO_LOG.proc_end(d_module);
570: PO_LOG.proc_end(d_module, 'x_record_already_exist', x_record_already_exist);
571: END IF;
572:
573: EXCEPTION
574: WHEN OTHERS THEN

Line 616: IF (PO_LOG.d_proc) THEN

612: d_position NUMBER;
613:
614: BEGIN
615: d_position := 0;
616: IF (PO_LOG.d_proc) THEN
617: PO_LOG.proc_begin(d_module);
618: END IF;
619:
620: -- Since putting DELETE within MERGE statement is causing database

Line 617: PO_LOG.proc_begin(d_module);

613:
614: BEGIN
615: d_position := 0;
616: IF (PO_LOG.d_proc) THEN
617: PO_LOG.proc_begin(d_module);
618: END IF;
619:
620: -- Since putting DELETE within MERGE statement is causing database
621: -- to thrown internal error, for now we just separate the DELETE statement.

Line 1320: IF (PO_LOG.d_proc) THEN

1316: l_dummy NUMBER;
1317:
1318: BEGIN
1319: d_position := 0;
1320: IF (PO_LOG.d_proc) THEN
1321: PO_LOG.proc_begin(d_module);
1322: END IF;
1323:
1324: SELECT 1

Line 1321: PO_LOG.proc_begin(d_module);

1317:
1318: BEGIN
1319: d_position := 0;
1320: IF (PO_LOG.d_proc) THEN
1321: PO_LOG.proc_begin(d_module);
1322: END IF;
1323:
1324: SELECT 1
1325: INTO l_dummy

Line 1331: IF (PO_LOG.d_proc) THEN

1327: WHERE po_header_id = p_po_header_id
1328: AND draft_id = p_draft_id
1329: FOR UPDATE NOWAIT;
1330:
1331: IF (PO_LOG.d_proc) THEN
1332: PO_LOG.proc_end(d_module);
1333: END IF;
1334:
1335: EXCEPTION

Line 1332: PO_LOG.proc_end(d_module);

1328: AND draft_id = p_draft_id
1329: FOR UPDATE NOWAIT;
1330:
1331: IF (PO_LOG.d_proc) THEN
1332: PO_LOG.proc_end(d_module);
1333: END IF;
1334:
1335: EXCEPTION
1336: WHEN NO_DATA_FOUND THEN

Line 1364: IF (PO_LOG.d_proc) THEN

1360: l_dummy NUMBER;
1361:
1362: BEGIN
1363: d_position := 0;
1364: IF (PO_LOG.d_proc) THEN
1365: PO_LOG.proc_begin(d_module);
1366: END IF;
1367:
1368: SELECT 1

Line 1365: PO_LOG.proc_begin(d_module);

1361:
1362: BEGIN
1363: d_position := 0;
1364: IF (PO_LOG.d_proc) THEN
1365: PO_LOG.proc_begin(d_module);
1366: END IF;
1367:
1368: SELECT 1
1369: INTO l_dummy

Line 1374: IF (PO_LOG.d_proc) THEN

1370: FROM po_headers_all
1371: WHERE po_header_id = p_po_header_id
1372: FOR UPDATE NOWAIT;
1373:
1374: IF (PO_LOG.d_proc) THEN
1375: PO_LOG.proc_end(d_module);
1376: END IF;
1377:
1378: EXCEPTION

Line 1375: PO_LOG.proc_end(d_module);

1371: WHERE po_header_id = p_po_header_id
1372: FOR UPDATE NOWAIT;
1373:
1374: IF (PO_LOG.d_proc) THEN
1375: PO_LOG.proc_end(d_module);
1376: END IF;
1377:
1378: EXCEPTION
1379: WHEN NO_DATA_FOUND THEN