52: l_proc varchar2(72) := g_package||'.transfer_data';
53: --
54: begin
55: --
56: hr_utility.set_location('Entered '||l_proc,5);
57:
58: OPEN csr_pds(p_business_group_id);
59: FETCH csr_pds INTO l_pds;
60:
76: end if;
77: else
78:
79: BEGIN -- Update termination record
80: hr_utility.set_location(l_proc,10);
81: hr_utility.trace(l_pds.period_of_service_id);
82:
83: SAVEPOINT start_insert;
84:
77: else
78:
79: BEGIN -- Update termination record
80: hr_utility.set_location(l_proc,10);
81: hr_utility.trace(l_pds.period_of_service_id);
82:
83: SAVEPOINT start_insert;
84:
85: update per_periods_of_service
134: l_proc varchar2(72) := g_package||'.run_upgrade';
135: --
136: begin
137: --
138: hr_utility.set_location('Entered '||l_proc,5);
139: l_status := transfer_data(p_business_group_id => p_business_group_id);
140: return l_status;
141: /* Allow exceptions to be handled by calling unit do not trap here. */
142: end run_upgrade;