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.16.12020000.4 2013/03/05 00:57:59 pla ship $ */
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 417: IF (PO_LOG.d_stmt) THEN

413: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
414: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
415:
416: d_position := 20;
417: IF (PO_LOG.d_stmt) THEN
418: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
419: END IF;
420:
421: FORALL i IN 1..p_po_distribution_id_tbl.COUNT

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

414: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
415:
416: d_position := 20;
417: IF (PO_LOG.d_stmt) THEN
418: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
419: END IF;
420:
421: FORALL i IN 1..p_po_distribution_id_tbl.COUNT
422: UPDATE po_distributions_draft_all

Line 431: IF (PO_LOG.d_stmt) THEN

427: AND x_record_already_exist_tbl(i) = FND_API.G_TRUE;
428:
429: d_position := 30;
430:
431: IF (PO_LOG.d_stmt) THEN
432: PO_LOG.stmt(d_module, d_position, 'update draft records that are already' ||
433: ' in draft table. Count = ' || SQL%ROWCOUNT);
434: END IF;
435:

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

428:
429: d_position := 30;
430:
431: IF (PO_LOG.d_stmt) THEN
432: PO_LOG.stmt(d_module, d_position, 'update draft records that are already' ||
433: ' in draft table. Count = ' || SQL%ROWCOUNT);
434: END IF;
435:
436: d_position := 40;

Line 438: IF (PO_LOG.d_proc) THEN

434: END IF;
435:
436: d_position := 40;
437:
438: IF (PO_LOG.d_proc) THEN
439: PO_LOG.proc_end(d_module);
440: END IF;
441:
442: EXCEPTION

Line 439: PO_LOG.proc_end(d_module);

435:
436: d_position := 40;
437:
438: IF (PO_LOG.d_proc) THEN
439: PO_LOG.proc_end(d_module);
440: END IF;
441:
442: EXCEPTION
443: WHEN OTHERS THEN

Line 493: IF (PO_LOG.d_proc) THEN

489: l_record_already_exist_tbl PO_TBL_VARCHAR1;
490:
491: BEGIN
492: d_position := 0;
493: IF (PO_LOG.d_proc) THEN
494: PO_LOG.proc_begin(d_module);
495: PO_LOG.proc_begin(d_module, 'p_po_distribution_id', p_po_distribution_id);
496: END IF;
497:

Line 494: PO_LOG.proc_begin(d_module);

490:
491: BEGIN
492: d_position := 0;
493: IF (PO_LOG.d_proc) THEN
494: PO_LOG.proc_begin(d_module);
495: PO_LOG.proc_begin(d_module, 'p_po_distribution_id', p_po_distribution_id);
496: END IF;
497:
498: sync_draft_from_txn

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

491: BEGIN
492: d_position := 0;
493: IF (PO_LOG.d_proc) THEN
494: PO_LOG.proc_begin(d_module);
495: PO_LOG.proc_begin(d_module, 'p_po_distribution_id', p_po_distribution_id);
496: END IF;
497:
498: sync_draft_from_txn
499: ( p_po_distribution_id_tbl => PO_TBL_NUMBER(p_po_distribution_id),

Line 508: IF (PO_LOG.d_proc) THEN

504:
505: x_record_already_exist := l_record_already_exist_tbl(1);
506:
507: d_position := 10;
508: IF (PO_LOG.d_proc) THEN
509: PO_LOG.proc_end(d_module);
510: PO_LOG.proc_end(d_module, 'x_record_already_exist', x_record_already_exist);
511: END IF;
512:

Line 509: PO_LOG.proc_end(d_module);

505: x_record_already_exist := l_record_already_exist_tbl(1);
506:
507: d_position := 10;
508: IF (PO_LOG.d_proc) THEN
509: PO_LOG.proc_end(d_module);
510: PO_LOG.proc_end(d_module, 'x_record_already_exist', x_record_already_exist);
511: END IF;
512:
513: EXCEPTION

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

506:
507: d_position := 10;
508: IF (PO_LOG.d_proc) THEN
509: PO_LOG.proc_end(d_module);
510: PO_LOG.proc_end(d_module, 'x_record_already_exist', x_record_already_exist);
511: END IF;
512:
513: EXCEPTION
514: WHEN OTHERS THEN

Line 556: IF (PO_LOG.d_proc) THEN

552: d_position NUMBER;
553:
554: BEGIN
555: d_position := 0;
556: IF (PO_LOG.d_proc) THEN
557: PO_LOG.proc_begin(d_module);
558: END IF;
559:
560: -- Since putting DELETE within MERGE statement is causing database

Line 557: PO_LOG.proc_begin(d_module);

553:
554: BEGIN
555: d_position := 0;
556: IF (PO_LOG.d_proc) THEN
557: PO_LOG.proc_begin(d_module);
558: END IF;
559:
560: -- Since putting DELETE within MERGE statement is causing database
561: -- to thrown internal error, for now we just separate the DELETE statement.

Line 1134: IF (PO_LOG.d_proc) THEN

1130: l_dummy NUMBER;
1131:
1132: BEGIN
1133: d_position := 0;
1134: IF (PO_LOG.d_proc) THEN
1135: PO_LOG.proc_begin(d_module);
1136: END IF;
1137:
1138: SELECT 1

Line 1135: PO_LOG.proc_begin(d_module);

1131:
1132: BEGIN
1133: d_position := 0;
1134: IF (PO_LOG.d_proc) THEN
1135: PO_LOG.proc_begin(d_module);
1136: END IF;
1137:
1138: SELECT 1
1139: INTO l_dummy

Line 1145: IF (PO_LOG.d_proc) THEN

1141: WHERE po_distribution_id = p_po_distribution_id
1142: AND draft_id = p_draft_id
1143: FOR UPDATE NOWAIT;
1144:
1145: IF (PO_LOG.d_proc) THEN
1146: PO_LOG.proc_end(d_module);
1147: END IF;
1148:
1149: EXCEPTION

Line 1146: PO_LOG.proc_end(d_module);

1142: AND draft_id = p_draft_id
1143: FOR UPDATE NOWAIT;
1144:
1145: IF (PO_LOG.d_proc) THEN
1146: PO_LOG.proc_end(d_module);
1147: END IF;
1148:
1149: EXCEPTION
1150: WHEN NO_DATA_FOUND THEN

Line 1178: IF (PO_LOG.d_proc) THEN

1174: l_dummy NUMBER;
1175:
1176: BEGIN
1177: d_position := 0;
1178: IF (PO_LOG.d_proc) THEN
1179: PO_LOG.proc_begin(d_module);
1180: END IF;
1181:
1182: SELECT 1

Line 1179: PO_LOG.proc_begin(d_module);

1175:
1176: BEGIN
1177: d_position := 0;
1178: IF (PO_LOG.d_proc) THEN
1179: PO_LOG.proc_begin(d_module);
1180: END IF;
1181:
1182: SELECT 1
1183: INTO l_dummy

Line 1188: IF (PO_LOG.d_proc) THEN

1184: FROM po_distributions_all
1185: WHERE po_distribution_id = p_po_distribution_id
1186: FOR UPDATE NOWAIT;
1187:
1188: IF (PO_LOG.d_proc) THEN
1189: PO_LOG.proc_end(d_module);
1190: END IF;
1191:
1192: EXCEPTION

Line 1189: PO_LOG.proc_end(d_module);

1185: WHERE po_distribution_id = p_po_distribution_id
1186: FOR UPDATE NOWAIT;
1187:
1188: IF (PO_LOG.d_proc) THEN
1189: PO_LOG.proc_end(d_module);
1190: END IF;
1191:
1192: EXCEPTION
1193: WHEN NO_DATA_FOUND THEN

Line 1216: IF (PO_LOG.d_proc) THEN

1212: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
1213: d_position NUMBER;
1214: BEGIN
1215: d_position := 0;
1216: IF (PO_LOG.d_proc) THEN
1217: PO_LOG.proc_begin(d_module);
1218: END IF;
1219:
1220: UPDATE po_requisition_lines_all

Line 1217: PO_LOG.proc_begin(d_module);

1213: d_position NUMBER;
1214: BEGIN
1215: d_position := 0;
1216: IF (PO_LOG.d_proc) THEN
1217: PO_LOG.proc_begin(d_module);
1218: END IF;
1219:
1220: UPDATE po_requisition_lines_all
1221: SET line_location_id = NULL,

Line 1231: IF (PO_LOG.d_proc) THEN

1227: last_updated_by = FND_GLOBAL.USER_ID,
1228: last_update_login = FND_GLOBAL.LOGIN_ID
1229: WHERE requisition_line_id = p_req_line_id;
1230:
1231: IF (PO_LOG.d_proc) THEN
1232: PO_LOG.proc_end(d_module);
1233: END IF;
1234: END update_req_line_link;
1235:

Line 1232: PO_LOG.proc_end(d_module);

1228: last_update_login = FND_GLOBAL.LOGIN_ID
1229: WHERE requisition_line_id = p_req_line_id;
1230:
1231: IF (PO_LOG.d_proc) THEN
1232: PO_LOG.proc_end(d_module);
1233: END IF;
1234: END update_req_line_link;
1235:
1236: END PO_DISTRIBUTIONS_DRAFT_PKG;