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.FF_DATABASE_ITEMS_PKG dependencies on FF_DATABASE_ITEMS_PKG

Line 1: package body FF_DATABASE_ITEMS_PKG as

1: package body FF_DATABASE_ITEMS_PKG as
2: /* $Header: ffdbi01t.pkb 120.14 2012/04/18 11:29:35 vmaripal ship $ */
3:
4: procedure insert_tl_rows
5: (x_user_name in varchar2

Line 16: l_disable_triggers := ff_database_items_pkg.g_disable_triggers;

12: begin
13: --
14: -- Disable trigger validation.
15: --
16: l_disable_triggers := ff_database_items_pkg.g_disable_triggers;
17: ff_database_items_pkg.g_disable_triggers := 'Y';
18:
19: insert into ff_database_items_tl (
20: user_name,

Line 17: ff_database_items_pkg.g_disable_triggers := 'Y';

13: --
14: -- Disable trigger validation.
15: --
16: l_disable_triggers := ff_database_items_pkg.g_disable_triggers;
17: ff_database_items_pkg.g_disable_triggers := 'Y';
18:
19: insert into ff_database_items_tl (
20: user_name,
21: user_entity_id,

Line 45: ff_database_items_pkg.g_disable_triggers := l_disable_triggers;

41:
42: --
43: -- Reset the trigger code.
44: --
45: ff_database_items_pkg.g_disable_triggers := l_disable_triggers;
46:
47: exception
48: when others then
49: --

Line 53: ff_database_items_pkg.g_disable_triggers := l_disable_triggers;

49: --
50: -- Reset the trigger code.
51: --
52: if l_disable_triggers is not null then
53: ff_database_items_pkg.g_disable_triggers := l_disable_triggers;
54: end if;
55:
56: raise;
57: end insert_tl_rows;

Line 95: l_disable_triggers := ff_database_items_pkg.g_disable_triggers;

91:
92: --
93: -- Disable trigger validation.
94: --
95: l_disable_triggers := ff_database_items_pkg.g_disable_triggers;
96: ff_database_items_pkg.g_disable_triggers := 'Y';
97:
98: insert into ff_database_items (
99: user_name,

Line 96: ff_database_items_pkg.g_disable_triggers := 'Y';

92: --
93: -- Disable trigger validation.
94: --
95: l_disable_triggers := ff_database_items_pkg.g_disable_triggers;
96: ff_database_items_pkg.g_disable_triggers := 'Y';
97:
98: insert into ff_database_items (
99: user_name,
100: user_entity_id,

Line 125: ff_database_items_pkg.g_disable_triggers := l_disable_triggers;

121:
122: --
123: -- Reset the trigger code.
124: --
125: ff_database_items_pkg.g_disable_triggers := l_disable_triggers;
126:
127: exception
128: when others then
129: --

Line 133: ff_database_items_pkg.g_disable_triggers := l_disable_triggers;

129: --
130: -- Reset the trigger code.
131: --
132: if l_disable_triggers is not null then
133: ff_database_items_pkg.g_disable_triggers := l_disable_triggers;
134: end if;
135:
136: raise;
137:

Line 722: l_disable_triggers := ff_database_items_pkg.g_disable_triggers;

718:
719: --
720: -- Disable trigger validation.
721: --
722: l_disable_triggers := ff_database_items_pkg.g_disable_triggers;
723: ff_database_items_pkg.g_disable_triggers := 'Y';
724:
725: update ff_database_items_tl set
726: translated_user_name = l_tl_user_name,

Line 723: ff_database_items_pkg.g_disable_triggers := 'Y';

719: --
720: -- Disable trigger validation.
721: --
722: l_disable_triggers := ff_database_items_pkg.g_disable_triggers;
723: ff_database_items_pkg.g_disable_triggers := 'Y';
724:
725: update ff_database_items_tl set
726: translated_user_name = l_tl_user_name,
727: description = x_description,

Line 739: ff_database_items_pkg.g_disable_triggers := l_disable_triggers;

735:
736: --
737: -- Reset the trigger code.
738: --
739: ff_database_items_pkg.g_disable_triggers := l_disable_triggers;
740:
741: if l_debug then
742: hr_utility.set_location('ffdict.core_update_tl_rows',200);
743: end if;

Line 756: ff_database_items_pkg.g_disable_triggers := l_disable_triggers;

752: --
753: -- Reset the trigger code.
754: --
755: if l_disable_triggers is not null then
756: ff_database_items_pkg.g_disable_triggers := l_disable_triggers;
757: end if;
758:
759: raise;
760: end core_update_tl_rows;

Line 873: l_disable_triggers := ff_database_items_pkg.g_disable_triggers;

869: --
870: -- Disable trigger validation. In the future, the triggers may
871: -- disappear altogether.
872: --
873: l_disable_triggers := ff_database_items_pkg.g_disable_triggers;
874: ff_database_items_pkg.g_disable_triggers := 'Y';
875: l_user_name := upper(x_user_name);
876:
877: --

Line 874: ff_database_items_pkg.g_disable_triggers := 'Y';

870: -- Disable trigger validation. In the future, the triggers may
871: -- disappear altogether.
872: --
873: l_disable_triggers := ff_database_items_pkg.g_disable_triggers;
874: ff_database_items_pkg.g_disable_triggers := 'Y';
875: l_user_name := upper(x_user_name);
876:
877: --
878: -- Verify that the new name isn't going to clash with anything.

Line 938: ff_database_items_pkg.g_disable_triggers := l_disable_triggers;

934:
935: --
936: -- Reset the trigger code.
937: --
938: ff_database_items_pkg.g_disable_triggers := l_disable_triggers;
939:
940: exception
941: when others then
942: --

Line 946: ff_database_items_pkg.g_disable_triggers := l_disable_triggers;

942: --
943: -- Reset the trigger code.
944: --
945: if l_disable_triggers is not null then
946: ff_database_items_pkg.g_disable_triggers := l_disable_triggers;
947: end if;
948:
949: raise;
950: end update_tl_row;

Line 989: l_disable_triggers := ff_database_items_pkg.g_disable_triggers;

985: --
986: -- Disable trigger validation. In the future, the triggers may
987: -- disappear altogether.
988: --
989: l_disable_triggers := ff_database_items_pkg.g_disable_triggers;
990: ff_database_items_pkg.g_disable_triggers := 'Y';
991:
992: --
993: -- If anything is changed on the base table then it is necessary

Line 990: ff_database_items_pkg.g_disable_triggers := 'Y';

986: -- Disable trigger validation. In the future, the triggers may
987: -- disappear altogether.
988: --
989: l_disable_triggers := ff_database_items_pkg.g_disable_triggers;
990: ff_database_items_pkg.g_disable_triggers := 'Y';
991:
992: --
993: -- If anything is changed on the base table then it is necessary
994: -- to check whether or not this database item is referenced by

Line 1038: ff_database_items_pkg.g_disable_triggers := l_disable_triggers;

1034:
1035: --
1036: -- Reset the trigger code.
1037: --
1038: ff_database_items_pkg.g_disable_triggers := l_disable_triggers;
1039:
1040: exception
1041: when others then
1042: --

Line 1046: ff_database_items_pkg.g_disable_triggers := l_disable_triggers;

1042: --
1043: -- Reset the trigger code.
1044: --
1045: if l_disable_triggers is not null then
1046: ff_database_items_pkg.g_disable_triggers := l_disable_triggers;
1047: end if;
1048:
1049: if csr_update_base%isopen then
1050: close csr_update_base;

Line 1116: l_disable_triggers := ff_database_items_pkg.g_disable_triggers;

1112: --
1113: -- Disable trigger validation. In the future, the triggers may
1114: -- disappear altogether.
1115: --
1116: l_disable_triggers := ff_database_items_pkg.g_disable_triggers;
1117: ff_database_items_pkg.g_disable_triggers := 'Y';
1118:
1119: ff_database_items_pkg.delete_tl_rows
1120: (x_user_name => l_user_name

Line 1117: ff_database_items_pkg.g_disable_triggers := 'Y';

1113: -- Disable trigger validation. In the future, the triggers may
1114: -- disappear altogether.
1115: --
1116: l_disable_triggers := ff_database_items_pkg.g_disable_triggers;
1117: ff_database_items_pkg.g_disable_triggers := 'Y';
1118:
1119: ff_database_items_pkg.delete_tl_rows
1120: (x_user_name => l_user_name
1121: ,x_user_entity_id => x_user_entity_id

Line 1119: ff_database_items_pkg.delete_tl_rows

1115: --
1116: l_disable_triggers := ff_database_items_pkg.g_disable_triggers;
1117: ff_database_items_pkg.g_disable_triggers := 'Y';
1118:
1119: ff_database_items_pkg.delete_tl_rows
1120: (x_user_name => l_user_name
1121: ,x_user_entity_id => x_user_entity_id
1122: );
1123:

Line 1131: ff_database_items_pkg.g_disable_triggers := l_disable_triggers;

1127:
1128: --
1129: -- Reset the trigger code.
1130: --
1131: ff_database_items_pkg.g_disable_triggers := l_disable_triggers;
1132:
1133: exception
1134: when others then
1135: --

Line 1139: ff_database_items_pkg.g_disable_triggers := l_disable_triggers;

1135: --
1136: -- Reset the trigger code.
1137: --
1138: if l_disable_triggers is not null then
1139: ff_database_items_pkg.g_disable_triggers := l_disable_triggers;
1140: end if;
1141:
1142: raise;
1143:

Line 1179: -- Disable trigger code by setting ff_database_items_pkg.g_disable_triggers.

1175:
1176: l_debug := hr_utility.debug_enabled;
1177:
1178: --
1179: -- Disable trigger code by setting ff_database_items_pkg.g_disable_triggers.
1180: --
1181: l_disable_triggers := ff_database_items_pkg.g_disable_triggers;
1182: ff_database_items_pkg.g_disable_triggers := 'Y';
1183:

Line 1181: l_disable_triggers := ff_database_items_pkg.g_disable_triggers;

1177:
1178: --
1179: -- Disable trigger code by setting ff_database_items_pkg.g_disable_triggers.
1180: --
1181: l_disable_triggers := ff_database_items_pkg.g_disable_triggers;
1182: ff_database_items_pkg.g_disable_triggers := 'Y';
1183:
1184: if l_debug then
1185: hr_utility.trace('add_language:delete');

Line 1182: ff_database_items_pkg.g_disable_triggers := 'Y';

1178: --
1179: -- Disable trigger code by setting ff_database_items_pkg.g_disable_triggers.
1180: --
1181: l_disable_triggers := ff_database_items_pkg.g_disable_triggers;
1182: ff_database_items_pkg.g_disable_triggers := 'Y';
1183:
1184: if l_debug then
1185: hr_utility.trace('add_language:delete');
1186: end if;

Line 1295: ff_database_items_pkg.g_disable_triggers := l_disable_triggers;

1291:
1292: --
1293: -- Reset triggers.
1294: --
1295: ff_database_items_pkg.g_disable_triggers := l_disable_triggers;
1296:
1297: close csr_user_entity_ids;
1298:
1299: return;

Line 1307: ff_database_items_pkg.g_disable_triggers := l_disable_triggers;

1303: --
1304: -- Reset triggers.
1305: --
1306: if l_disable_triggers is not null then
1307: ff_database_items_pkg.g_disable_triggers := l_disable_triggers;
1308: end if;
1309:
1310: if csr_user_entity_ids%isopen then
1311: close csr_user_entity_ids;

Line 1435: end ff_database_items_pkg;

1431: raise;
1432:
1433: end translate_row;
1434:
1435: end ff_database_items_pkg;