DBA Data[Home] [Help]

APPS.PAY_ZA_BUS_ADD_ENDDATE dependencies on HR_UTILITY

Line 22: hr_utility.set_location('Entering qualify_person',10);

18:
19: l_exists number;
20:
21: BEGIN
22: hr_utility.set_location('Entering qualify_person',10);
23:
24: p_qualifier :='N';
25: open csr_person;
26: fetch csr_person into l_exists;

Line 32: hr_utility.set_location('Exiting qualify_person',20);

28: p_qualifier := 'Y';
29: end if;
30: close csr_person;
31:
32: hr_utility.set_location('Exiting qualify_person',20);
33: END qualify_person;
34:
35: PROCEDURE enddate_bus_add(p_person_id number) AS
36: BEGIN

Line 38: hr_utility.set_location('Entering enddate_bus_add',50);

34:
35: PROCEDURE enddate_bus_add(p_person_id number) AS
36: BEGIN
37:
38: hr_utility.set_location('Entering enddate_bus_add',50);
39: hr_utility.set_location('p_person_id = ' || p_person_id,60);
40:
41: update per_addresses
42: set date_to = date_from - 1

Line 39: hr_utility.set_location('p_person_id = ' || p_person_id,60);

35: PROCEDURE enddate_bus_add(p_person_id number) AS
36: BEGIN
37:
38: hr_utility.set_location('Entering enddate_bus_add',50);
39: hr_utility.set_location('p_person_id = ' || p_person_id,60);
40:
41: update per_addresses
42: set date_to = date_from - 1
43: where person_id = p_person_id

Line 48: hr_utility.set_location('Exiting enddate_bus_add',70);

44: and style = 'ZA_SARS'
45: and primary_flag = 'N'
46: and address_type = 'ZA_BUS';
47:
48: hr_utility.set_location('Exiting enddate_bus_add',70);
49:
50: END enddate_bus_add;
51:
52: END PAY_ZA_BUS_ADD_ENDDATE;