DBA Data[Home] [Help]

APPS.PER_TAX_ADDRESS_PKG dependencies on PER_TAX_ADDRESS_PKG

Line 1: PACKAGE BODY per_tax_address_pkg AS

1: PACKAGE BODY per_tax_address_pkg AS
2: /* $Header: peaddovr.pkb 120.2 2006/04/13 11:27:04 saikrish noship $ */
3:
4: PROCEDURE address_overide(p_person_id IN NUMBER,
5: p_date_from IN DATE,

Line 19: hr_utility.set_location(' per_tax_address_pkg.address_overide',10);

15: l_state VARCHAR2(30);
16: l_zip VARCHAR2(30);
17: --
18: BEGIN
19: hr_utility.set_location(' per_tax_address_pkg.address_overide',10);
20: -- Get overide date and last input date.
21: ----------------------------------------
22: l_date := TO_DATE('01/01/' || (TO_CHAR(p_date_from, 'YYYY')),'DD/MM/YYYY');
23: SELECT MAX(date_from) INTO l_last_date

Line 116: hr_utility.set_location('per_tax_address_pkg.overide_tax_state',10);

112: AND p_date BETWEEN date_from
113: AND NVL(date_to, TO_DATE('31/12/4712', 'DD/MM/YYYY'));
114:
115: BEGIN
116: hr_utility.set_location('per_tax_address_pkg.overide_tax_state',10);
117: hr_utility.set_location('per_tax_address_pkg,p_date_from ->'|| p_date_from,11);
118: -- Check if the entry is new
119: -------------------------
120: OPEN c_new_entry;

Line 117: hr_utility.set_location('per_tax_address_pkg,p_date_from ->'|| p_date_from,11);

113: AND NVL(date_to, TO_DATE('31/12/4712', 'DD/MM/YYYY'));
114:
115: BEGIN
116: hr_utility.set_location('per_tax_address_pkg.overide_tax_state',10);
117: hr_utility.set_location('per_tax_address_pkg,p_date_from ->'|| p_date_from,11);
118: -- Check if the entry is new
119: -------------------------
120: OPEN c_new_entry;
121: FETCH c_new_entry INTO l_chk_date;

Line 152: hr_utility.set_location('per_tax_address_pkg.overide_tax_state,l_date ->'||l_date,20);

148: primary_flag = 'Y');
149:
150: END IF;
151: CLOSE c_state;
152: hr_utility.set_location('per_tax_address_pkg.overide_tax_state,l_date ->'||l_date,20);
153: hr_utility.set_location('per_tax_address_pkg.overide_tax_stat,l_state -> '||l_state,30);
154: END IF;
155: hr_utility.set_location('per_tax_address_pkg.overide_tax_stat,l_state -> '||l_state,35);
156: RETURN l_state;

Line 153: hr_utility.set_location('per_tax_address_pkg.overide_tax_stat,l_state -> '||l_state,30);

149:
150: END IF;
151: CLOSE c_state;
152: hr_utility.set_location('per_tax_address_pkg.overide_tax_state,l_date ->'||l_date,20);
153: hr_utility.set_location('per_tax_address_pkg.overide_tax_stat,l_state -> '||l_state,30);
154: END IF;
155: hr_utility.set_location('per_tax_address_pkg.overide_tax_stat,l_state -> '||l_state,35);
156: RETURN l_state;
157: EXCEPTION

Line 155: hr_utility.set_location('per_tax_address_pkg.overide_tax_stat,l_state -> '||l_state,35);

151: CLOSE c_state;
152: hr_utility.set_location('per_tax_address_pkg.overide_tax_state,l_date ->'||l_date,20);
153: hr_utility.set_location('per_tax_address_pkg.overide_tax_stat,l_state -> '||l_state,30);
154: END IF;
155: hr_utility.set_location('per_tax_address_pkg.overide_tax_stat,l_state -> '||l_state,35);
156: RETURN l_state;
157: EXCEPTION
158: WHEN NO_DATA_FOUND THEN
159: hr_utility.set_location('per_tax_address_pkg.overide_tax_stat,l_state -> '||l_state,40);

Line 159: hr_utility.set_location('per_tax_address_pkg.overide_tax_stat,l_state -> '||l_state,40);

155: hr_utility.set_location('per_tax_address_pkg.overide_tax_stat,l_state -> '||l_state,35);
156: RETURN l_state;
157: EXCEPTION
158: WHEN NO_DATA_FOUND THEN
159: hr_utility.set_location('per_tax_address_pkg.overide_tax_stat,l_state -> '||l_state,40);
160: RETURN ('NO DATA');
161: END overide_tax_state;
162: END per_tax_address_pkg;

Line 162: END per_tax_address_pkg;

158: WHEN NO_DATA_FOUND THEN
159: hr_utility.set_location('per_tax_address_pkg.overide_tax_stat,l_state -> '||l_state,40);
160: RETURN ('NO DATA');
161: END overide_tax_state;
162: END per_tax_address_pkg;