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

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

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

Line 44: IF (PO_LOG.d_proc) THEN

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

Line 45: PO_LOG.proc_begin(d_module);

41:
42: BEGIN
43: d_position := 0;
44: IF (PO_LOG.d_proc) THEN
45: PO_LOG.proc_begin(d_module);
46: END IF;
47:
48: DELETE FROM po_attribute_values_draft
49: 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_ATTR_VALUES_DRAFT_PVT.draft_changes_exist

Line 144: IF (PO_LOG.d_stmt) THEN

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

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

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

Line 814: IF (PO_LOG.d_stmt) THEN

810: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
811: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
812:
813: d_position := 20;
814: IF (PO_LOG.d_stmt) THEN
815: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
816: END IF;
817:
818: FORALL i IN 1..p_attribute_values_id_tbl.COUNT

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

811: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
812:
813: d_position := 20;
814: IF (PO_LOG.d_stmt) THEN
815: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
816: END IF;
817:
818: FORALL i IN 1..p_attribute_values_id_tbl.COUNT
819: UPDATE po_attribute_values_draft

Line 828: IF (PO_LOG.d_stmt) THEN

824: AND x_record_already_exist_tbl(i) = FND_API.G_TRUE;
825:
826: d_position := 30;
827:
828: IF (PO_LOG.d_stmt) THEN
829: PO_LOG.stmt(d_module, d_position, 'update draft records that are already' ||
830: ' in draft table. Count = ' || SQL%ROWCOUNT);
831: END IF;
832:

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

825:
826: d_position := 30;
827:
828: IF (PO_LOG.d_stmt) THEN
829: PO_LOG.stmt(d_module, d_position, 'update draft records that are already' ||
830: ' in draft table. Count = ' || SQL%ROWCOUNT);
831: END IF;
832:
833: d_position := 40;

Line 835: IF (PO_LOG.d_proc) THEN

831: END IF;
832:
833: d_position := 40;
834:
835: IF (PO_LOG.d_proc) THEN
836: PO_LOG.proc_end(d_module);
837: END IF;
838:
839: EXCEPTION

Line 836: PO_LOG.proc_end(d_module);

832:
833: d_position := 40;
834:
835: IF (PO_LOG.d_proc) THEN
836: PO_LOG.proc_end(d_module);
837: END IF;
838:
839: EXCEPTION
840: WHEN OTHERS THEN

Line 890: IF (PO_LOG.d_proc) THEN

886: l_record_already_exist_tbl PO_TBL_VARCHAR1;
887:
888: BEGIN
889: d_position := 0;
890: IF (PO_LOG.d_proc) THEN
891: PO_LOG.proc_begin(d_module);
892: PO_LOG.proc_begin(d_module, 'p_attribute_values_id', p_attribute_values_id);
893: END IF;
894:

Line 891: PO_LOG.proc_begin(d_module);

887:
888: BEGIN
889: d_position := 0;
890: IF (PO_LOG.d_proc) THEN
891: PO_LOG.proc_begin(d_module);
892: PO_LOG.proc_begin(d_module, 'p_attribute_values_id', p_attribute_values_id);
893: END IF;
894:
895: sync_draft_from_txn

Line 892: PO_LOG.proc_begin(d_module, 'p_attribute_values_id', p_attribute_values_id);

888: BEGIN
889: d_position := 0;
890: IF (PO_LOG.d_proc) THEN
891: PO_LOG.proc_begin(d_module);
892: PO_LOG.proc_begin(d_module, 'p_attribute_values_id', p_attribute_values_id);
893: END IF;
894:
895: sync_draft_from_txn
896: ( p_attribute_values_id_tbl => PO_TBL_NUMBER(p_attribute_values_id),

Line 905: IF (PO_LOG.d_proc) THEN

901:
902: x_record_already_exist := l_record_already_exist_tbl(1);
903:
904: d_position := 10;
905: IF (PO_LOG.d_proc) THEN
906: PO_LOG.proc_end(d_module);
907: PO_LOG.proc_end(d_module, 'x_record_already_exist', x_record_already_exist);
908: END IF;
909:

Line 906: PO_LOG.proc_end(d_module);

902: x_record_already_exist := l_record_already_exist_tbl(1);
903:
904: d_position := 10;
905: IF (PO_LOG.d_proc) THEN
906: PO_LOG.proc_end(d_module);
907: PO_LOG.proc_end(d_module, 'x_record_already_exist', x_record_already_exist);
908: END IF;
909:
910: EXCEPTION

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

903:
904: d_position := 10;
905: IF (PO_LOG.d_proc) THEN
906: PO_LOG.proc_end(d_module);
907: PO_LOG.proc_end(d_module, 'x_record_already_exist', x_record_already_exist);
908: END IF;
909:
910: EXCEPTION
911: WHEN OTHERS THEN

Line 954: IF (PO_LOG.d_proc) THEN

950:
951: BEGIN
952:
953: d_position := 0;
954: IF (PO_LOG.d_proc) THEN
955: PO_LOG.proc_begin(d_module);
956: END IF;
957:
958: -- Since putting DELETE within MERGE statement is causing database

Line 955: PO_LOG.proc_begin(d_module);

951: BEGIN
952:
953: d_position := 0;
954: IF (PO_LOG.d_proc) THEN
955: PO_LOG.proc_begin(d_module);
956: END IF;
957:
958: -- Since putting DELETE within MERGE statement is causing database
959: -- to thrown internal error, for now we just separate the DELETE statement.

Line 2338: IF (PO_LOG.d_proc) THEN

2334: l_dummy NUMBER;
2335:
2336: BEGIN
2337: d_position := 0;
2338: IF (PO_LOG.d_proc) THEN
2339: PO_LOG.proc_begin(d_module);
2340: END IF;
2341:
2342: SELECT 1

Line 2339: PO_LOG.proc_begin(d_module);

2335:
2336: BEGIN
2337: d_position := 0;
2338: IF (PO_LOG.d_proc) THEN
2339: PO_LOG.proc_begin(d_module);
2340: END IF;
2341:
2342: SELECT 1
2343: INTO l_dummy

Line 2349: IF (PO_LOG.d_proc) THEN

2345: WHERE attribute_values_id = p_attribute_values_id
2346: AND draft_id = p_draft_id
2347: FOR UPDATE NOWAIT;
2348:
2349: IF (PO_LOG.d_proc) THEN
2350: PO_LOG.proc_end(d_module);
2351: END IF;
2352:
2353: EXCEPTION

Line 2350: PO_LOG.proc_end(d_module);

2346: AND draft_id = p_draft_id
2347: FOR UPDATE NOWAIT;
2348:
2349: IF (PO_LOG.d_proc) THEN
2350: PO_LOG.proc_end(d_module);
2351: END IF;
2352:
2353: EXCEPTION
2354: WHEN NO_DATA_FOUND THEN

Line 2382: IF (PO_LOG.d_proc) THEN

2378: l_dummy NUMBER;
2379:
2380: BEGIN
2381: d_position := 0;
2382: IF (PO_LOG.d_proc) THEN
2383: PO_LOG.proc_begin(d_module);
2384: END IF;
2385:
2386: SELECT 1

Line 2383: PO_LOG.proc_begin(d_module);

2379:
2380: BEGIN
2381: d_position := 0;
2382: IF (PO_LOG.d_proc) THEN
2383: PO_LOG.proc_begin(d_module);
2384: END IF;
2385:
2386: SELECT 1
2387: INTO l_dummy

Line 2392: IF (PO_LOG.d_proc) THEN

2388: FROM po_attribute_values
2389: WHERE attribute_values_id = p_attribute_values_id
2390: FOR UPDATE NOWAIT;
2391:
2392: IF (PO_LOG.d_proc) THEN
2393: PO_LOG.proc_end(d_module);
2394: END IF;
2395:
2396: EXCEPTION

Line 2393: PO_LOG.proc_end(d_module);

2389: WHERE attribute_values_id = p_attribute_values_id
2390: FOR UPDATE NOWAIT;
2391:
2392: IF (PO_LOG.d_proc) THEN
2393: PO_LOG.proc_end(d_module);
2394: END IF;
2395:
2396: EXCEPTION
2397: WHEN NO_DATA_FOUND THEN