eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.SSP_SMP_PKG dependencies on SSP_TEMP_AFFECTED_ROWS

Line 172: 09-DEC-2006 kthampan 115.33 5706912 Amend procedure ins_ssp_temp_affected_rows_mat

168: 19-OCT-2006 kthampan 115.32 5604330 Amend check_death to create the stoppage based
169: on the '7 day rolling weeks', currently it
170: will always created using the next Sunday after
171: the date of death.
172: 09-DEC-2006 kthampan 115.33 5706912 Amend procedure ins_ssp_temp_affected_rows_mat
173: and person_control
174: 06-JAN-2009 npannamp 115.34 7680593 In csr_existing_entries cursor, trimmed
175: the Group seperator before calling to_number.
176: 'HR: Number Separator' profile causing issue.

Line 2272: procedure ins_ssp_temp_affected_rows_mat(p_maternity_id in number,

2268: --
2269: end SMP_control;
2270: --
2271: --------------------------------------------------------------------------------
2272: procedure ins_ssp_temp_affected_rows_mat(p_maternity_id in number,
2273: p_deleting in boolean ) is
2274: --
2275: -- Inserts a row in ssp_temp_affected_rows for the maternity, if not there
2276: --

Line 2275: -- Inserts a row in ssp_temp_affected_rows for the maternity, if not there

2271: --------------------------------------------------------------------------------
2272: procedure ins_ssp_temp_affected_rows_mat(p_maternity_id in number,
2273: p_deleting in boolean ) is
2274: --
2275: -- Inserts a row in ssp_temp_affected_rows for the maternity, if not there
2276: --
2277: l_proc varchar2 (72) := g_package||'ins_ssp_temp_affected_rows_mat';
2278: l_deleting_ch varchar2(1);
2279: --

Line 2277: l_proc varchar2 (72) := g_package||'ins_ssp_temp_affected_rows_mat';

2273: p_deleting in boolean ) is
2274: --
2275: -- Inserts a row in ssp_temp_affected_rows for the maternity, if not there
2276: --
2277: l_proc varchar2 (72) := g_package||'ins_ssp_temp_affected_rows_mat';
2278: l_deleting_ch varchar2(1);
2279: --
2280: begin
2281: --

Line 2293: insert into ssp_temp_affected_rows (MATERNITY_ID, p_deleting, locked)

2289: if p_maternity_id is not null then
2290: hr_utility.trace (l_proc||' Saving maternity_id #' || p_maternity_id ||
2291: ' for recalculation (p_del = '||l_deleting_ch||').');
2292: --
2293: insert into ssp_temp_affected_rows (MATERNITY_ID, p_deleting, locked)
2294: select p_maternity_id, l_deleting_ch, userenv('sessionid')
2295: from sys.dual
2296: where not exists
2297: (select null

Line 2298: from ssp_temp_affected_rows t2

2294: select p_maternity_id, l_deleting_ch, userenv('sessionid')
2295: from sys.dual
2296: where not exists
2297: (select null
2298: from ssp_temp_affected_rows t2
2299: where t2.maternity_id = p_maternity_id);
2300: end if;
2301: --
2302: hr_utility.set_location('Leaving :'||l_proc,100);

Line 2304: end ins_ssp_temp_affected_rows_mat;

2300: end if;
2301: --
2302: hr_utility.set_location('Leaving :'||l_proc,100);
2303: --
2304: end ins_ssp_temp_affected_rows_mat;
2305: --
2306: --------------------------------------------------------------------------------
2307: procedure absence_control (p_maternity_id in number,
2308: p_deleting in boolean ) is

Line 2321: ins_ssp_temp_affected_rows_mat(p_maternity_id, p_deleting);

2317: --
2318: g_smp_update := 'N';
2319: --
2320: if p_maternity_id is not null then
2321: ins_ssp_temp_affected_rows_mat(p_maternity_id, p_deleting);
2322: end if;
2323: --
2324: hr_utility.set_location (l_proc,100);
2325: --

Line 2338: ins_ssp_temp_affected_rows_mat(p_maternity_id, p_deleting => FALSE);

2334: hr_utility.set_location (l_proc,1);
2335: --
2336: g_smp_update := 'Y';
2337: --
2338: ins_ssp_temp_affected_rows_mat(p_maternity_id, p_deleting => FALSE);
2339: --
2340: hr_utility.set_location (l_proc,100);
2341: --
2342: end maternity_control;

Line 2354: ins_ssp_temp_affected_rows_mat(p_maternity_id, p_deleting => FALSE);

2350: hr_utility.set_location (l_proc,1);
2351: --
2352: if p_maternity_id is not null -- the medical is for a maternity
2353: then
2354: ins_ssp_temp_affected_rows_mat(p_maternity_id, p_deleting => FALSE);
2355: end if;
2356: --
2357: hr_utility.set_location (l_proc,100);
2358: --

Line 2398: ins_ssp_temp_affected_rows_mat(l_maternity_id, p_deleting => FALSE);

2394: fetch csr_maternity into l_maternity_id;
2395: --
2396: if csr_maternity%found
2397: then
2398: ins_ssp_temp_affected_rows_mat(l_maternity_id, p_deleting => FALSE);
2399: else
2400: hr_utility.trace(l_proc||' No maternities affected by change in earnings');
2401: end if;
2402: --

Line 2447: ins_ssp_temp_affected_rows_mat(l_maternity_id, p_deleting => FALSE);

2443: fetch csr_maternity into l_maternity_id;
2444: --
2445: if csr_maternity%found
2446: then
2447: ins_ssp_temp_affected_rows_mat(l_maternity_id, p_deleting => FALSE);
2448: end if;
2449: --
2450: close csr_maternity;
2451: --

Line 2474: ins_ssp_temp_affected_rows_mat(p_maternity_id, p_deleting => FALSE);

2470: hr_utility.set_location (l_proc,1);
2471: --
2472: if p_maternity_id is not null
2473: then
2474: ins_ssp_temp_affected_rows_mat(p_maternity_id, p_deleting => FALSE);
2475: end if;
2476: --
2477: hr_utility.set_location (l_proc,100);
2478: --