DBA Data[Home] [Help]

APPS.PAY_AC_TAXABILITY_CHK_ROW dependencies on HR_UTILITY

Line 63: hr_utility.trace('Before ltt_state_abbrev Loop');

59:
60: l_state_abbrev varchar2(2) := '';
61:
62: Begin
63: hr_utility.trace('Before ltt_state_abbrev Loop');
64: for i in 1..ltt_state_abbrev.COUNT
65: Loop
66: if substr(p_jurisdiction_code,1,2) = ltt_state_code(i) then
67: hr_utility.trace('state_abbrev = '||ltt_state_abbrev(i));

Line 67: hr_utility.trace('state_abbrev = '||ltt_state_abbrev(i));

63: hr_utility.trace('Before ltt_state_abbrev Loop');
64: for i in 1..ltt_state_abbrev.COUNT
65: Loop
66: if substr(p_jurisdiction_code,1,2) = ltt_state_code(i) then
67: hr_utility.trace('state_abbrev = '||ltt_state_abbrev(i));
68: return ltt_state_abbrev(i);
69:
70: end if;
71:

Line 73: hr_utility.trace('After ltt_state_abbrev Loop');

69:
70: end if;
71:
72: end loop;
73: hr_utility.trace('After ltt_state_abbrev Loop');
74:
75: for strec in get_state_names
76: Loop
77: ltt_state_abbrev(strec.state_code) := strec.state_abbrev;

Line 79: hr_utility.trace('state_abbrev = '||ltt_state_abbrev(strec.state_code));

75: for strec in get_state_names
76: Loop
77: ltt_state_abbrev(strec.state_code) := strec.state_abbrev;
78: ltt_state_code(strec.state_code) := strec.state_code;
79: hr_utility.trace('state_abbrev = '||ltt_state_abbrev(strec.state_code));
80: if substr(p_jurisdiction_code,1,2) = strec.state_code then
81: hr_utility.trace('In strec Loop');
82: l_state_abbrev := strec.state_abbrev;
83: end if;

Line 81: hr_utility.trace('In strec Loop');

77: ltt_state_abbrev(strec.state_code) := strec.state_abbrev;
78: ltt_state_code(strec.state_code) := strec.state_code;
79: hr_utility.trace('state_abbrev = '||ltt_state_abbrev(strec.state_code));
80: if substr(p_jurisdiction_code,1,2) = strec.state_code then
81: hr_utility.trace('In strec Loop');
82: l_state_abbrev := strec.state_abbrev;
83: end if;
84:
85: end loop;

Line 232: -- hr_utility.trace_on(null,'tax_api');

228:
229:
230: BEGIN
231: g_package := 'pay_ac_taxability_chk_row.';
232: -- hr_utility.trace_on(null,'tax_api');
233: end pay_ac_taxability_chk_row;