APPS.FF_ARCHIVE_UTILS dependencies on HR_UTILITY

Line 64: --hr_utility.trace_on(1,'ORACLE');

60: l_return_value varchar2(100);
61:
62: BEGIN
63:
64: --hr_utility.trace_on(1,'ORACLE');
65:
66: --statem := 'BEGIN ' || 'ff_archive_utils.' || p_legislation_code || '_'|| p_context_name || '(:p_context_value,:return_value); END;';
67:
68: statem := 'select ff_archive_utils.'||p_legislation_code || '_' || p_context_name || '('''|| p_context_value||''') from dual';

Line 70: hr_utility.trace('statem = ' || statem);

66: --statem := 'BEGIN ' || 'ff_archive_utils.' || p_legislation_code || '_'|| p_context_name || '(:p_context_value,:return_value); END;';
67:
68: statem := 'select ff_archive_utils.'||p_legislation_code || '_' || p_context_name || '('''|| p_context_value||''') from dual';
69:
70: hr_utility.trace('statem = ' || statem);
71: hr_utility.trace('length = ' || length(statem));
72:
73: sql_curs := dbms_sql.open_cursor;
74:

Line 71: hr_utility.trace('length = ' || length(statem));

67:
68: statem := 'select ff_archive_utils.'||p_legislation_code || '_' || p_context_name || '('''|| p_context_value||''') from dual';
69:
70: hr_utility.trace('statem = ' || statem);
71: hr_utility.trace('length = ' || length(statem));
72:
73: sql_curs := dbms_sql.open_cursor;
74:
75: hr_utility.trace('sql_curs = ' || to_char(sql_curs));

Line 75: hr_utility.trace('sql_curs = ' || to_char(sql_curs));

71: hr_utility.trace('length = ' || length(statem));
72:
73: sql_curs := dbms_sql.open_cursor;
74:
75: hr_utility.trace('sql_curs = ' || to_char(sql_curs));
76:
77: dbms_sql.parse(sql_curs,
78: statem,
79: dbms_sql.v7);

Line 84: hr_utility.trace('p_context_value = ' || p_context_value);

80:
81:
82: dbms_sql.define_column(sql_curs, 1, l_return_value, 50);
83:
84: hr_utility.trace('p_context_value = ' || p_context_value);
85: hr_utility.trace('l_return_value = ' || l_return_value);
86:
87: rows_processed := dbms_sql.execute_and_fetch(sql_curs);
88:

Line 85: hr_utility.trace('l_return_value = ' || l_return_value);

81:
82: dbms_sql.define_column(sql_curs, 1, l_return_value, 50);
83:
84: hr_utility.trace('p_context_value = ' || p_context_value);
85: hr_utility.trace('l_return_value = ' || l_return_value);
86:
87: rows_processed := dbms_sql.execute_and_fetch(sql_curs);
88:
89: dbms_sql.column_value(sql_curs,1, l_return_value);

Line 91: hr_utility.trace('rows_processed = ' || to_char(rows_processed));

87: rows_processed := dbms_sql.execute_and_fetch(sql_curs);
88:
89: dbms_sql.column_value(sql_curs,1, l_return_value);
90:
91: hr_utility.trace('rows_processed = ' || to_char(rows_processed));
92: hr_utility.trace('l_return_value = ' || l_return_value);
93:
94: dbms_sql.close_cursor(sql_curs);
95:

Line 92: hr_utility.trace('l_return_value = ' || l_return_value);

88:
89: dbms_sql.column_value(sql_curs,1, l_return_value);
90:
91: hr_utility.trace('rows_processed = ' || to_char(rows_processed));
92: hr_utility.trace('l_return_value = ' || l_return_value);
93:
94: dbms_sql.close_cursor(sql_curs);
95:
96: hr_utility.trace('l_return_value = ' || l_return_value);

Line 96: hr_utility.trace('l_return_value = ' || l_return_value);

92: hr_utility.trace('l_return_value = ' || l_return_value);
93:
94: dbms_sql.close_cursor(sql_curs);
95:
96: hr_utility.trace('l_return_value = ' || l_return_value);
97: return l_return_value;
98:
99: EXCEPTION WHEN OTHERS THEN
100:

Line 130: hr_utility.trace('ff_archive_utils.us_jurisdiction_code');

126: l_jurisdiction_name varchar2(100);
127: l_ret_val varchar2(32000);
128: begin
129:
130: hr_utility.trace('ff_archive_utils.us_jurisdiction_code');
131:
132: l_jurisdiction_name := pay_us_employee_payslip_web.get_jurisdiction_name(
133: p_context_value);
134: hr_utility.trace('l_jurisdiction_name = ' || l_jurisdiction_name);

Line 134: hr_utility.trace('l_jurisdiction_name = ' || l_jurisdiction_name);

130: hr_utility.trace('ff_archive_utils.us_jurisdiction_code');
131:
132: l_jurisdiction_name := pay_us_employee_payslip_web.get_jurisdiction_name(
133: p_context_value);
134: hr_utility.trace('l_jurisdiction_name = ' || l_jurisdiction_name);
135: l_ret_val := (ltrim(rtrim(l_jurisdiction_name)) || '(' ||
136: ltrim(rtrim(p_context_value)) || ')');
137: hr_utility.trace('l_ret_val : '||l_ret_val);
138: return l_ret_val;

Line 137: hr_utility.trace('l_ret_val : '||l_ret_val);

133: p_context_value);
134: hr_utility.trace('l_jurisdiction_name = ' || l_jurisdiction_name);
135: l_ret_val := (ltrim(rtrim(l_jurisdiction_name)) || '(' ||
136: ltrim(rtrim(p_context_value)) || ')');
137: hr_utility.trace('l_ret_val : '||l_ret_val);
138: return l_ret_val;
139: end;
140:
141: end us_jurisdiction_code;