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_WRAPPER_SUP_PKG dependencies on HR_UTILITY

Line 120: -- L_DEBUG BOOLEAN:=HR_UTILITY.DEBUG_ENABLED;

116: -- ,P_FFERLN IN OUT NOCOPY NUMBER
117: -- ,P_FFERCD IN OUT NOCOPY NUMBER
118: -- ,P_FFERMT OUT NOCOPY VARCHAR2
119: -- ) IS
120: -- L_DEBUG BOOLEAN:=HR_UTILITY.DEBUG_ENABLED;
121: -- BEGIN
122: ------------------------------------------------------------------------------
123: c_wrapper_body1 varchar2(256) :=
124: ' BAD_PLSQL EXCEPTION;' || c_newline ||

Line 130: ' L_DEBUG BOOLEAN:=HR_UTILITY.DEBUG_ENABLED;' || c_newline ||

126: ' CANNOT_FIND_PROG_UNIT EXCEPTION;' || c_newline ||
127: ' PRAGMA EXCEPTION_INIT(CANNOT_FIND_PROG_UNIT, -6508);' || c_newline;
128: c_wrapper_body2 varchar2(256) :=
129: ' IS' || c_newline ||
130: ' L_DEBUG BOOLEAN:=HR_UTILITY.DEBUG_ENABLED;' || c_newline ||
131: ' BEGIN' || c_newline
132: ;
133: ------------------------------------------------------------------------------
134: -- No call if-block.

Line 158: -- HR_UTILITY.TRACE

154: -- FF_WRAPPER_PKG.G_N:=P_N;
155: -- FF_WRAPPER_PKG.G_T:=P_T;
156: -- FF_WRAPPER_PKG.G_I:=P_I;
157: -- IF L_DEBUG THEN
158: -- HR_UTILITY.TRACE
159: -- (' DYNAMIC SQL FOR '||P_FF_PACKAGE_NAME);
160: -- END IF;
161: -- EXECUTE IMMEDIATE 'BEGIN ' || P_FF_PACKAGE_NAME || '.FORMULA;END;';
162: -- P_D:=FF_WRAPPER_PKG.G_D;

Line 171: -- HR_UTILITY.SET_MESSAGE(801,'FFX22J_FORMULA_NOT_FOUND');

167: -- P_FFERLN:=FF_WRAPPER_PKG.G_FFERLN;
168: -- P_FFERMT:=FF_WRAPPER_PKG.G_FFERMT;
169: -- EXCEPTION
170: -- WHEN BAD_PLSQL THEN
171: -- HR_UTILITY.SET_MESSAGE(801,'FFX22J_FORMULA_NOT_FOUND');
172: -- HR_UTILITY.SET_MESSAGE_TOKEN('1',P_FORMULA_NAME);
173: -- HR_UTILITY.RAISE_ERROR;
174: -- WHEN CANNOT_FIND_PROG_UNIT THEN
175: -- HR_UTILITY.SET_MESSAGE(802, 'FF_33186_GENERATE_WRAPPER');

Line 172: -- HR_UTILITY.SET_MESSAGE_TOKEN('1',P_FORMULA_NAME);

168: -- P_FFERMT:=FF_WRAPPER_PKG.G_FFERMT;
169: -- EXCEPTION
170: -- WHEN BAD_PLSQL THEN
171: -- HR_UTILITY.SET_MESSAGE(801,'FFX22J_FORMULA_NOT_FOUND');
172: -- HR_UTILITY.SET_MESSAGE_TOKEN('1',P_FORMULA_NAME);
173: -- HR_UTILITY.RAISE_ERROR;
174: -- WHEN CANNOT_FIND_PROG_UNIT THEN
175: -- HR_UTILITY.SET_MESSAGE(802, 'FF_33186_GENERATE_WRAPPER');
176: -- HR_UTILITY.SET_MESSAGE_TOKEN('1',P_FORMULA_NAME);

Line 173: -- HR_UTILITY.RAISE_ERROR;

169: -- EXCEPTION
170: -- WHEN BAD_PLSQL THEN
171: -- HR_UTILITY.SET_MESSAGE(801,'FFX22J_FORMULA_NOT_FOUND');
172: -- HR_UTILITY.SET_MESSAGE_TOKEN('1',P_FORMULA_NAME);
173: -- HR_UTILITY.RAISE_ERROR;
174: -- WHEN CANNOT_FIND_PROG_UNIT THEN
175: -- HR_UTILITY.SET_MESSAGE(802, 'FF_33186_GENERATE_WRAPPER');
176: -- HR_UTILITY.SET_MESSAGE_TOKEN('1',P_FORMULA_NAME);
177: -- HR_UTILITY.RAISE_ERROR;

Line 175: -- HR_UTILITY.SET_MESSAGE(802, 'FF_33186_GENERATE_WRAPPER');

171: -- HR_UTILITY.SET_MESSAGE(801,'FFX22J_FORMULA_NOT_FOUND');
172: -- HR_UTILITY.SET_MESSAGE_TOKEN('1',P_FORMULA_NAME);
173: -- HR_UTILITY.RAISE_ERROR;
174: -- WHEN CANNOT_FIND_PROG_UNIT THEN
175: -- HR_UTILITY.SET_MESSAGE(802, 'FF_33186_GENERATE_WRAPPER');
176: -- HR_UTILITY.SET_MESSAGE_TOKEN('1',P_FORMULA_NAME);
177: -- HR_UTILITY.RAISE_ERROR;
178: -- END FORMULA;
179: -- END ;

Line 176: -- HR_UTILITY.SET_MESSAGE_TOKEN('1',P_FORMULA_NAME);

172: -- HR_UTILITY.SET_MESSAGE_TOKEN('1',P_FORMULA_NAME);
173: -- HR_UTILITY.RAISE_ERROR;
174: -- WHEN CANNOT_FIND_PROG_UNIT THEN
175: -- HR_UTILITY.SET_MESSAGE(802, 'FF_33186_GENERATE_WRAPPER');
176: -- HR_UTILITY.SET_MESSAGE_TOKEN('1',P_FORMULA_NAME);
177: -- HR_UTILITY.RAISE_ERROR;
178: -- END FORMULA;
179: -- END ;
180: ------------------------------------------------------------------------------

Line 177: -- HR_UTILITY.RAISE_ERROR;

173: -- HR_UTILITY.RAISE_ERROR;
174: -- WHEN CANNOT_FIND_PROG_UNIT THEN
175: -- HR_UTILITY.SET_MESSAGE(802, 'FF_33186_GENERATE_WRAPPER');
176: -- HR_UTILITY.SET_MESSAGE_TOKEN('1',P_FORMULA_NAME);
177: -- HR_UTILITY.RAISE_ERROR;
178: -- END FORMULA;
179: -- END ;
180: ------------------------------------------------------------------------------
181: c_end1 varchar2(256) :=

Line 184: ' HR_UTILITY.TRACE(''ELSE:END'');' || c_newline ||

180: ------------------------------------------------------------------------------
181: c_end1 varchar2(256) :=
182: ' ELSE' || c_newline ||
183: ' IF L_DEBUG THEN' || c_newline ||
184: ' HR_UTILITY.TRACE(''ELSE:END'');' || c_newline ||
185: ' END IF;' || c_newline ||
186: ' GOTO FF_DYNAMIC_SQL;' || c_newline ||
187: ' END IF;' || c_newline ||
188: ' RETURN;' || c_newline ||

Line 197: ' HR_UTILITY.TRACE' ||

193: ' FF_WRAPPER_PKG.G_T:=P_T;' || c_newline ||
194: ' FF_WRAPPER_PKG.G_I:=P_I;' || c_newline;
195: c_end3 varchar2(256) :=
196: ' IF L_DEBUG THEN' || c_newline ||
197: ' HR_UTILITY.TRACE' ||
198: '('' DYNAMIC SQL FOR ''||P_FF_PACKAGE_NAME);' ||
199: c_newline || ' END IF;' || c_newline;
200: c_end4 varchar2(256) :=
201: ' EXECUTE IMMEDIATE ''BEGIN '' || P_FF_PACKAGE_NAME || ''.FORMULA;END;'';' ||

Line 215: ' HR_UTILITY.SET_MESSAGE(801,''FFX22J_FORMULA_NOT_FOUND'');'||c_newline||

211: ' P_FFERMT:=FF_WRAPPER_PKG.G_FFERMT;' || c_newline ||
212: ' EXCEPTION' || c_newline;
213: c_end7 varchar2(256) :=
214: ' WHEN BAD_PLSQL THEN' || c_newline ||
215: ' HR_UTILITY.SET_MESSAGE(801,''FFX22J_FORMULA_NOT_FOUND'');'||c_newline||
216: ' HR_UTILITY.SET_MESSAGE_TOKEN(''1'',P_FORMULA_NAME);' ||c_newline;
217: c_end8 varchar2(256) :=
218: ' HR_UTILITY.RAISE_ERROR;' || c_newline ||
219: ' WHEN CANNOT_FIND_PROG_UNIT THEN' || c_newline ||

Line 216: ' HR_UTILITY.SET_MESSAGE_TOKEN(''1'',P_FORMULA_NAME);' ||c_newline;

212: ' EXCEPTION' || c_newline;
213: c_end7 varchar2(256) :=
214: ' WHEN BAD_PLSQL THEN' || c_newline ||
215: ' HR_UTILITY.SET_MESSAGE(801,''FFX22J_FORMULA_NOT_FOUND'');'||c_newline||
216: ' HR_UTILITY.SET_MESSAGE_TOKEN(''1'',P_FORMULA_NAME);' ||c_newline;
217: c_end8 varchar2(256) :=
218: ' HR_UTILITY.RAISE_ERROR;' || c_newline ||
219: ' WHEN CANNOT_FIND_PROG_UNIT THEN' || c_newline ||
220: ' HR_UTILITY.SET_MESSAGE(802,''FF_33186_GENERATE_WRAPPER'');'||c_newline;

Line 218: ' HR_UTILITY.RAISE_ERROR;' || c_newline ||

214: ' WHEN BAD_PLSQL THEN' || c_newline ||
215: ' HR_UTILITY.SET_MESSAGE(801,''FFX22J_FORMULA_NOT_FOUND'');'||c_newline||
216: ' HR_UTILITY.SET_MESSAGE_TOKEN(''1'',P_FORMULA_NAME);' ||c_newline;
217: c_end8 varchar2(256) :=
218: ' HR_UTILITY.RAISE_ERROR;' || c_newline ||
219: ' WHEN CANNOT_FIND_PROG_UNIT THEN' || c_newline ||
220: ' HR_UTILITY.SET_MESSAGE(802,''FF_33186_GENERATE_WRAPPER'');'||c_newline;
221: c_end9 varchar2(256) :=
222: ' HR_UTILITY.SET_MESSAGE_TOKEN(''1'',P_FORMULA_NAME);' || c_newline ||

Line 220: ' HR_UTILITY.SET_MESSAGE(802,''FF_33186_GENERATE_WRAPPER'');'||c_newline;

216: ' HR_UTILITY.SET_MESSAGE_TOKEN(''1'',P_FORMULA_NAME);' ||c_newline;
217: c_end8 varchar2(256) :=
218: ' HR_UTILITY.RAISE_ERROR;' || c_newline ||
219: ' WHEN CANNOT_FIND_PROG_UNIT THEN' || c_newline ||
220: ' HR_UTILITY.SET_MESSAGE(802,''FF_33186_GENERATE_WRAPPER'');'||c_newline;
221: c_end9 varchar2(256) :=
222: ' HR_UTILITY.SET_MESSAGE_TOKEN(''1'',P_FORMULA_NAME);' || c_newline ||
223: ' HR_UTILITY.RAISE_ERROR;' || c_newline ||
224: ' END FORMULA;' || c_newline;

Line 222: ' HR_UTILITY.SET_MESSAGE_TOKEN(''1'',P_FORMULA_NAME);' || c_newline ||

218: ' HR_UTILITY.RAISE_ERROR;' || c_newline ||
219: ' WHEN CANNOT_FIND_PROG_UNIT THEN' || c_newline ||
220: ' HR_UTILITY.SET_MESSAGE(802,''FF_33186_GENERATE_WRAPPER'');'||c_newline;
221: c_end9 varchar2(256) :=
222: ' HR_UTILITY.SET_MESSAGE_TOKEN(''1'',P_FORMULA_NAME);' || c_newline ||
223: ' HR_UTILITY.RAISE_ERROR;' || c_newline ||
224: ' END FORMULA;' || c_newline;
225: ------------------------------------------------------------------------------
226: -- FFW package header.

Line 223: ' HR_UTILITY.RAISE_ERROR;' || c_newline ||

219: ' WHEN CANNOT_FIND_PROG_UNIT THEN' || c_newline ||
220: ' HR_UTILITY.SET_MESSAGE(802,''FF_33186_GENERATE_WRAPPER'');'||c_newline;
221: c_end9 varchar2(256) :=
222: ' HR_UTILITY.SET_MESSAGE_TOKEN(''1'',P_FORMULA_NAME);' || c_newline ||
223: ' HR_UTILITY.RAISE_ERROR;' || c_newline ||
224: ' END FORMULA;' || c_newline;
225: ------------------------------------------------------------------------------
226: -- FFW package header.
227: -- CREATE OR REPLACE PACKAGE AS

Line 450: hr_utility.set_message(800, 'FF_34999_WRAPPER_GEN_ERROR');

446: --
447: if l_header then
448: drop_package(p_package_name => p_wrapper_pkg_name);
449: end if;
450: hr_utility.set_message(800, 'FF_34999_WRAPPER_GEN_ERROR');
451: hr_utility.set_message_token('PACKAGE', p_wrapper_pkg_name);
452: hr_utility.raise_error;
453: end create_specific_wrapper;
454: --------------------------- create_ffw_body ----------------------------------

Line 451: hr_utility.set_message_token('PACKAGE', p_wrapper_pkg_name);

447: if l_header then
448: drop_package(p_package_name => p_wrapper_pkg_name);
449: end if;
450: hr_utility.set_message(800, 'FF_34999_WRAPPER_GEN_ERROR');
451: hr_utility.set_message_token('PACKAGE', p_wrapper_pkg_name);
452: hr_utility.raise_error;
453: end create_specific_wrapper;
454: --------------------------- create_ffw_body ----------------------------------
455: procedure create_ffw_body

Line 452: hr_utility.raise_error;

448: drop_package(p_package_name => p_wrapper_pkg_name);
449: end if;
450: hr_utility.set_message(800, 'FF_34999_WRAPPER_GEN_ERROR');
451: hr_utility.set_message_token('PACKAGE', p_wrapper_pkg_name);
452: hr_utility.raise_error;
453: end create_specific_wrapper;
454: --------------------------- create_ffw_body ----------------------------------
455: procedure create_ffw_body
456: (p_wrapper_pkg_name in varchar2

Line 551: l_prefix || ' HR_UTILITY.TRACE(''CALL INTO ' || p_package_name || ''');'

547: l_prefix := ' ';
548: --
549: p_chunk1 :=
550: l_prefix || 'IF L_DEBUG THEN' || c_newline ||
551: l_prefix || ' HR_UTILITY.TRACE(''CALL INTO ' || p_package_name || ''');'
552: || c_newline ||
553: l_prefix || 'END IF;' || c_newline;
554: p_chunk2 :=
555: l_prefix || p_package_name || '.FORMULA' || c_newline ||

Line 602: ' HR_UTILITY.TRACE(''ELSE:' || p_where || ''');' || c_newline ||

598: begin
599: p_chunk :=
600: ' ELSE' || c_newline ||
601: ' IF L_DEBUG THEN' || c_newline ||
602: ' HR_UTILITY.TRACE(''ELSE:' || p_where || ''');' || c_newline ||
603: ' END IF;' || c_newline ||
604: ' GOTO FF_DYNAMIC_SQL;' || c_newline ||
605: ' END IF;' || c_newline;
606: end gencallend;

Line 676: hr_utility.set_message(800, 'FF_34999_WRAPPER_GEN_ERROR');

672: open csr_check_compile(p_package_name);
673: fetch csr_check_compile into l_status;
674: close csr_check_compile;
675: if upper(l_status) <> c_object_valid then
676: hr_utility.set_message(800, 'FF_34999_WRAPPER_GEN_ERROR');
677: hr_utility.set_message_token('PACKAGE', p_package_name);
678: hr_utility.raise_error;
679: end if;
680: exception

Line 677: hr_utility.set_message_token('PACKAGE', p_package_name);

673: fetch csr_check_compile into l_status;
674: close csr_check_compile;
675: if upper(l_status) <> c_object_valid then
676: hr_utility.set_message(800, 'FF_34999_WRAPPER_GEN_ERROR');
677: hr_utility.set_message_token('PACKAGE', p_package_name);
678: hr_utility.raise_error;
679: end if;
680: exception
681: when others then

Line 678: hr_utility.raise_error;

674: close csr_check_compile;
675: if upper(l_status) <> c_object_valid then
676: hr_utility.set_message(800, 'FF_34999_WRAPPER_GEN_ERROR');
677: hr_utility.set_message_token('PACKAGE', p_package_name);
678: hr_utility.raise_error;
679: end if;
680: exception
681: when others then
682: if csr_check_compile%isopen then

Line 699: l_debug boolean := hr_utility.debug_enabled;

695: ,p_wrap_info in t_range_tbl
696: ,p_wrapper_num in varchar2
697: ,p_intermediates in boolean
698: ) is
699: l_debug boolean := hr_utility.debug_enabled;
700: l_chunks dbms_sql.varchar2s;
701: l_chunk_index binary_integer := 1;
702: l_range_start boolean;
703: l_range_size number;

Line 715: hr_utility.trace('Enter:generate_body:'||p_wrapper_name);

711: l_rows number;
712: l_generated boolean := false;
713: begin
714: if l_debug then
715: hr_utility.trace('Enter:generate_body:'||p_wrapper_name);
716: end if;
717:
718: --------------------------------
719: -- A. Start the wrapper body. --

Line 733: hr_utility.trace

729: -----------------------------------------
730: l_chunk_index := l_chunks.count + 1;
731: if p_intermediates then
732: if l_debug then
733: hr_utility.trace
734: ('Generating calls to intermediate wrapper packages.');
735: end if;
736:
737: for i in 1 .. p_wrap_info.count loop

Line 742: hr_utility.trace

738: --
739: -- 1. Generate the range IF-statement.
740: --
741: if l_debug then
742: hr_utility.trace
743: ('Range:'||p_wrap_info(i).start_index||'-'||p_wrap_info(i).end_index);
744: end if;
745:
746: genrangeif

Line 760: hr_utility.trace('Call:'||c_wrapper_name||to_char(i));

756: --
757: -- 2. Generate the intermediate package call.
758: --
759: if l_debug then
760: hr_utility.trace('Call:'||c_wrapper_name||to_char(i));
761: end if;
762:
763: genintercall
764: (p_package_name => c_wrapper_name || to_char(i)

Line 779: hr_utility.trace('Generating direct calls to formula packages.');

775: -------------------------------------------------
776: -- 1. Work out the range size for indirection. --
777: -------------------------------------------------
778: if l_debug then
779: hr_utility.trace('Generating direct calls to formula packages.');
780: end if;
781:
782: l_start_index := p_wrap_info(p_wrapper_num).start_index;
783: l_end_index := p_wrap_info(p_wrapper_num).end_index;

Line 801: hr_utility.trace

797: end if;
798: end if;
799:
800: if l_debug then
801: hr_utility.trace
802: ('Branches:'||l_branches||' Range Size:'||l_range_size);
803: hr_utility.trace
804: ('Generating for formulas:'||l_start_index||'-'||l_end_index);
805: end if;

Line 803: hr_utility.trace

799:
800: if l_debug then
801: hr_utility.trace
802: ('Branches:'||l_branches||' Range Size:'||l_range_size);
803: hr_utility.trace
804: ('Generating for formulas:'||l_start_index||'-'||l_end_index);
805: end if;
806:
807: -----------------------------------------------------------------

Line 831: hr_utility.trace('Outer IF-range:'||i||'-'||l_end_range);

827: l_end_range := l_end_index;
828: end if;
829:
830: if l_debug then
831: hr_utility.trace('Outer IF-range:'||i||'-'||l_end_range);
832: end if;
833:
834: --
835: -- Generate the IF-statement.

Line 902: hr_utility.trace('Text complete, create package body...');

898: -----------------------------------------------------------
899: -- E. Execute the generated SQL. Don't insert linefeeds. --
900: -----------------------------------------------------------
901: if l_debug then
902: hr_utility.trace('Text complete, create package body...');
903: end if;
904:
905: begin
906: l_csr_sql := dbms_sql.open_cursor;

Line 926: hr_utility.trace('Leaving:generate_body');

922: ------------------------------------
923: check_compile(p_package_name => p_wrapper_name);
924:
925: if l_debug then
926: hr_utility.trace('Leaving:generate_body');
927: end if;
928:
929: exception
930: when others then

Line 932: hr_utility.trace

928:
929: exception
930: when others then
931: if l_debug then
932: hr_utility.trace
933: ('Leaving generate_body with error:' || sqlcode || ':' || sqlerrm);
934: end if;
935:
936: if l_generated then

Line 955: l_debug boolean := hr_utility.debug_enabled;

951: procedure process_compiled
952: (p_range_tbl in out nocopy t_range_tbl
953: ,p_ff_info_tbl in out nocopy t_ff_info_tbl
954: ) is
955: l_debug boolean := hr_utility.debug_enabled;
956: l_info_index number := 1;
957: l_add_to_tbl boolean;
958: l_wrap_info t_range_tbl;
959: l_wrapper_num number := 0;

Line 1004: hr_utility.trace('Entering:process_compiled');

1000: and uo.object_type = c_package
1001: ;
1002: begin
1003: if l_debug then
1004: hr_utility.trace('Entering:process_compiled');
1005: end if;
1006: --------------------------------------------------
1007: -- A. Read in the compiled formula information. --
1008: --------------------------------------------------

Line 1010: hr_utility.trace('Set-up formula information tables...');

1006: --------------------------------------------------
1007: -- A. Read in the compiled formula information. --
1008: --------------------------------------------------
1009: if l_debug then
1010: hr_utility.trace('Set-up formula information tables...');
1011: end if;
1012:
1013: for crec in csr_get_ff_info loop
1014: l_add_to_tbl := true;

Line 1057: hr_utility.trace('Formula information tables set-up complete.');

1053: end if;
1054: end loop;
1055:
1056: if l_debug then
1057: hr_utility.trace('Formula information tables set-up complete.');
1058: end if;
1059:
1060: ---------------------------------------------------------------
1061: -- B. Generate the main wrapper body, and, if necessary, the --

Line 1070: hr_utility.trace('Intermediate wrappers need to be generated.');

1066: -- main wrapper body.
1067: --
1068: if l_wrap_info.count > 1 then
1069: if l_debug then
1070: hr_utility.trace('Intermediate wrappers need to be generated.');
1071: end if;
1072:
1073: for i in 1 .. l_wrap_info.count loop
1074: l_header_done := false;

Line 1078: hr_utility.trace('Generating intermediate wrapper:' || l_wrap_name);

1074: l_header_done := false;
1075: l_wrap_name := c_wrapper_name || to_char(i);
1076:
1077: if l_debug then
1078: hr_utility.trace('Generating intermediate wrapper:' || l_wrap_name);
1079: end if;
1080:
1081: --
1082: -- Generate the package headers.

Line 1089: hr_utility.trace('Generate header:' || l_wrap_name);

1085: fetch csr_package_exists into l_dummy;
1086:
1087: if csr_package_exists%notfound then
1088: if l_debug then
1089: hr_utility.trace('Generate header:' || l_wrap_name);
1090: end if;
1091:
1092: l_text :=
1093: replace(c_package_head_start, c_name_replace, l_wrap_name) ||

Line 1103: hr_utility.trace('Did not generate header:' || l_wrap_name);

1099: execute immediate l_text;
1100: l_header_done := true;
1101: else
1102: if l_debug then
1103: hr_utility.trace('Did not generate header:' || l_wrap_name);
1104: end if;
1105: end if;
1106:
1107: close csr_package_exists;

Line 1127: hr_utility.trace

1123: --
1124: -- Generate the main package body with intermediates.
1125: --
1126: if l_debug then
1127: hr_utility.trace
1128: ('Generate main wrapper body with intermediate wrapper calls.');
1129: end if;
1130:
1131: generate_body

Line 1143: hr_utility.trace('Generate main wrapper body with direct formula calls.');

1139: --
1140: -- Generate the main package body without intermediates.
1141: --
1142: if l_debug then
1143: hr_utility.trace('Generate main wrapper body with direct formula calls.');
1144: end if;
1145:
1146: generate_body
1147: (p_wrapper_name => c_wrapper_main

Line 1166: hr_utility.trace

1162: l_wrapper_num :=
1163: to_number(replace(crec.object_name,c_wrapper_name,null));
1164: if l_wrapper_num >= l_wrap_delno then
1165: if l_debug then
1166: hr_utility.trace
1167: ('Dropping unused wrapper package:' || crec.object_name);
1168: end if;
1169: drop_package(p_package_name => crec.object_name);
1170: end if;

Line 1181: hr_utility.trace('Leaving:process_compiled');

1177: end;
1178: end loop;
1179:
1180: if l_debug then
1181: hr_utility.trace('Leaving:process_compiled');
1182: end if;
1183: exception
1184: when others then
1185: if l_debug then

Line 1186: hr_utility.trace

1182: end if;
1183: exception
1184: when others then
1185: if l_debug then
1186: hr_utility.trace
1187: ('Leaving process_compiled with error:' || sqlcode || ':' || sqlerrm);
1188: end if;
1189:
1190: if l_header_done then

Line 1308: l_debug boolean := hr_utility.debug_enabled;

1304: ,p_ff_info_tbl in t_ff_info_tbl
1305: ) is
1306: c_wrap_package constant number := 1;
1307: c_std_package constant number := 2;
1308: l_debug boolean := hr_utility.debug_enabled;
1309: l_prefix varchar2(16);
1310: l_formula_id number;
1311: l_is_ff_name boolean;
1312: l_start_date date;

Line 1322: hr_utility.trace('Entering:process_orphans');

1318: and uo.object_type = c_package
1319: order by uo.object_name;
1320: begin
1321: if l_debug then
1322: hr_utility.trace('Entering:process_orphans');
1323: end if;
1324:
1325: for package_type in c_wrap_package .. c_std_package loop
1326: --

Line 1361: hr_utility.trace

1357: --
1358: -- 3. Drop orphaned package.
1359: --
1360: if l_debug then
1361: hr_utility.trace
1362: ('Deleting orphaned FF package:' || crec.object_name);
1363: end if;
1364:
1365: drop_package(p_package_name => crec.object_name);

Line 1372: hr_utility.trace('Leaving:process_orphans');

1368: end loop;
1369: end loop;
1370:
1371: if l_debug then
1372: hr_utility.trace('Leaving:process_orphans');
1373: end if;
1374: end process_orphans;
1375: ----------------------------- create_wrapper ---------------------------------
1376: procedure create_wrapper is

Line 1377: l_debug boolean := hr_utility.debug_enabled;

1373: end if;
1374: end process_orphans;
1375: ----------------------------- create_wrapper ---------------------------------
1376: procedure create_wrapper is
1377: l_debug boolean := hr_utility.debug_enabled;
1378: l_range_tbl t_range_tbl;
1379: l_ff_info_tbl t_ff_info_tbl;
1380: l_chunks dbms_sql.varchar2s;
1381: l_csr_sql integer;

Line 1385: hr_utility.trace('Entering:create_wrapper');

1381: l_csr_sql integer;
1382: l_rows number;
1383: begin
1384: if l_debug then
1385: hr_utility.trace('Entering:create_wrapper');
1386: end if;
1387:
1388: --
1389: -- 1. Process the compiled formulas.

Line 1404: hr_utility.trace('Leaving:create_wrapper');

1400: ,p_ff_info_tbl => l_ff_info_tbl
1401: );
1402:
1403: if l_debug then
1404: hr_utility.trace('Leaving:create_wrapper');
1405: end if;
1406: end create_wrapper;
1407: ----------------------------- create_wrapper ---------------------------------
1408: procedure create_wrapper