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

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

1: PACKAGE BODY PO_DISTRIBUTIONS_DRAFT_PKG AS
2: /* $Header: PO_DISTRIBUTIONS_DRAFT_PKG.plb 120.8 2006/09/28 23:02:15 bao noship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) :=
5: PO_LOG.get_package_base('PO_DISTRIBUTIONS_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_distributions_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_distributions_draft_all
48: WHERE draft_id = p_draft_id

Line 105: IF (PO_LOG.d_proc) THEN

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

Line 106: PO_LOG.proc_begin(d_module);

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

Line 142: IF (PO_LOG.d_stmt) THEN

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

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

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

Line 383: IF (PO_LOG.d_stmt) THEN

379: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
380: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
381:
382: d_position := 20;
383: IF (PO_LOG.d_stmt) THEN
384: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
385: END IF;
386:
387: FORALL i IN 1..p_po_distribution_id_tbl.COUNT

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

380: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
381:
382: d_position := 20;
383: IF (PO_LOG.d_stmt) THEN
384: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
385: END IF;
386:
387: FORALL i IN 1..p_po_distribution_id_tbl.COUNT
388: UPDATE po_distributions_draft_all

Line 397: IF (PO_LOG.d_stmt) THEN

393: AND x_record_already_exist_tbl(i) = FND_API.G_TRUE;
394:
395: d_position := 30;
396:
397: IF (PO_LOG.d_stmt) THEN
398: PO_LOG.stmt(d_module, d_position, 'update draft records that are already' ||
399: ' in draft table. Count = ' || SQL%ROWCOUNT);
400: END IF;
401:

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

394:
395: d_position := 30;
396:
397: IF (PO_LOG.d_stmt) THEN
398: PO_LOG.stmt(d_module, d_position, 'update draft records that are already' ||
399: ' in draft table. Count = ' || SQL%ROWCOUNT);
400: END IF;
401:
402: d_position := 40;

Line 404: IF (PO_LOG.d_proc) THEN

400: END IF;
401:
402: d_position := 40;
403:
404: IF (PO_LOG.d_proc) THEN
405: PO_LOG.proc_end(d_module);
406: END IF;
407:
408: EXCEPTION

Line 405: PO_LOG.proc_end(d_module);

401:
402: d_position := 40;
403:
404: IF (PO_LOG.d_proc) THEN
405: PO_LOG.proc_end(d_module);
406: END IF;
407:
408: EXCEPTION
409: WHEN OTHERS THEN

Line 459: IF (PO_LOG.d_proc) THEN

455: l_record_already_exist_tbl PO_TBL_VARCHAR1;
456:
457: BEGIN
458: d_position := 0;
459: IF (PO_LOG.d_proc) THEN
460: PO_LOG.proc_begin(d_module);
461: PO_LOG.proc_begin(d_module, 'p_po_distribution_id', p_po_distribution_id);
462: END IF;
463:

Line 460: PO_LOG.proc_begin(d_module);

456:
457: BEGIN
458: d_position := 0;
459: IF (PO_LOG.d_proc) THEN
460: PO_LOG.proc_begin(d_module);
461: PO_LOG.proc_begin(d_module, 'p_po_distribution_id', p_po_distribution_id);
462: END IF;
463:
464: sync_draft_from_txn

Line 461: PO_LOG.proc_begin(d_module, 'p_po_distribution_id', p_po_distribution_id);

457: BEGIN
458: d_position := 0;
459: IF (PO_LOG.d_proc) THEN
460: PO_LOG.proc_begin(d_module);
461: PO_LOG.proc_begin(d_module, 'p_po_distribution_id', p_po_distribution_id);
462: END IF;
463:
464: sync_draft_from_txn
465: ( p_po_distribution_id_tbl => PO_TBL_NUMBER(p_po_distribution_id),

Line 474: IF (PO_LOG.d_proc) THEN

470:
471: x_record_already_exist := l_record_already_exist_tbl(1);
472:
473: d_position := 10;
474: IF (PO_LOG.d_proc) THEN
475: PO_LOG.proc_end(d_module);
476: PO_LOG.proc_end(d_module, 'x_record_already_exist', x_record_already_exist);
477: END IF;
478:

Line 475: PO_LOG.proc_end(d_module);

471: x_record_already_exist := l_record_already_exist_tbl(1);
472:
473: d_position := 10;
474: IF (PO_LOG.d_proc) THEN
475: PO_LOG.proc_end(d_module);
476: PO_LOG.proc_end(d_module, 'x_record_already_exist', x_record_already_exist);
477: END IF;
478:
479: EXCEPTION

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

472:
473: d_position := 10;
474: IF (PO_LOG.d_proc) THEN
475: PO_LOG.proc_end(d_module);
476: PO_LOG.proc_end(d_module, 'x_record_already_exist', x_record_already_exist);
477: END IF;
478:
479: EXCEPTION
480: WHEN OTHERS THEN

Line 522: IF (PO_LOG.d_proc) THEN

518: d_position NUMBER;
519:
520: BEGIN
521: d_position := 0;
522: IF (PO_LOG.d_proc) THEN
523: PO_LOG.proc_begin(d_module);
524: END IF;
525:
526: -- Since putting DELETE within MERGE statement is causing database

Line 523: PO_LOG.proc_begin(d_module);

519:
520: BEGIN
521: d_position := 0;
522: IF (PO_LOG.d_proc) THEN
523: PO_LOG.proc_begin(d_module);
524: END IF;
525:
526: -- Since putting DELETE within MERGE statement is causing database
527: -- to thrown internal error, for now we just separate the DELETE statement.

Line 1044: IF (PO_LOG.d_proc) THEN

1040: l_dummy NUMBER;
1041:
1042: BEGIN
1043: d_position := 0;
1044: IF (PO_LOG.d_proc) THEN
1045: PO_LOG.proc_begin(d_module);
1046: END IF;
1047:
1048: SELECT 1

Line 1045: PO_LOG.proc_begin(d_module);

1041:
1042: BEGIN
1043: d_position := 0;
1044: IF (PO_LOG.d_proc) THEN
1045: PO_LOG.proc_begin(d_module);
1046: END IF;
1047:
1048: SELECT 1
1049: INTO l_dummy

Line 1055: IF (PO_LOG.d_proc) THEN

1051: WHERE po_distribution_id = p_po_distribution_id
1052: AND draft_id = p_draft_id
1053: FOR UPDATE NOWAIT;
1054:
1055: IF (PO_LOG.d_proc) THEN
1056: PO_LOG.proc_end(d_module);
1057: END IF;
1058:
1059: EXCEPTION

Line 1056: PO_LOG.proc_end(d_module);

1052: AND draft_id = p_draft_id
1053: FOR UPDATE NOWAIT;
1054:
1055: IF (PO_LOG.d_proc) THEN
1056: PO_LOG.proc_end(d_module);
1057: END IF;
1058:
1059: EXCEPTION
1060: WHEN NO_DATA_FOUND THEN

Line 1088: IF (PO_LOG.d_proc) THEN

1084: l_dummy NUMBER;
1085:
1086: BEGIN
1087: d_position := 0;
1088: IF (PO_LOG.d_proc) THEN
1089: PO_LOG.proc_begin(d_module);
1090: END IF;
1091:
1092: SELECT 1

Line 1089: PO_LOG.proc_begin(d_module);

1085:
1086: BEGIN
1087: d_position := 0;
1088: IF (PO_LOG.d_proc) THEN
1089: PO_LOG.proc_begin(d_module);
1090: END IF;
1091:
1092: SELECT 1
1093: INTO l_dummy

Line 1098: IF (PO_LOG.d_proc) THEN

1094: FROM po_distributions_all
1095: WHERE po_distribution_id = p_po_distribution_id
1096: FOR UPDATE NOWAIT;
1097:
1098: IF (PO_LOG.d_proc) THEN
1099: PO_LOG.proc_end(d_module);
1100: END IF;
1101:
1102: EXCEPTION

Line 1099: PO_LOG.proc_end(d_module);

1095: WHERE po_distribution_id = p_po_distribution_id
1096: FOR UPDATE NOWAIT;
1097:
1098: IF (PO_LOG.d_proc) THEN
1099: PO_LOG.proc_end(d_module);
1100: END IF;
1101:
1102: EXCEPTION
1103: WHEN NO_DATA_FOUND THEN