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.PER_PTU_DFF_MIG dependencies on PER_PTU_DFF_MIG

Line 1: package body PER_PTU_DFF_MIG AS

1: package body PER_PTU_DFF_MIG AS
2: /* $Header: peptumig.pkb 120.0 2005/05/31 15:56:30 appldev noship $ */
3: --
4: -- Declare the TABLE TYPEs.
5: --

Line 57: from PER_PTU_DFF_MIG_FAILED_PEOPLE

53: l_prev_mig_successful varchar2(1) := 'N';
54: --
55: cursor csr_is_alrady_run_for_bg(p_business_group_id number) IS
56: select ERROR_DESCRIPTION
57: from PER_PTU_DFF_MIG_FAILED_PEOPLE
58: where nvl(business_group_id,-1) = nvl(p_business_group_id,-1)
59: and person_id = hr_api.g_number;
60: --
61: cursor csr_prev_run_all_bgs IS

Line 63: from PER_PTU_DFF_MIG_FAILED_PEOPLE

59: and person_id = hr_api.g_number;
60: --
61: cursor csr_prev_run_all_bgs IS
62: select ERROR_DESCRIPTION
63: from PER_PTU_DFF_MIG_FAILED_PEOPLE
64: where person_id = hr_api.g_number
65: and business_group_id is null;
66: --
67: BEGIN

Line 104: -- table PER_PTU_DFF_MIG_FAILED_PEOPLE.

100: -- l_report_mode := p_report_mode;
101: l_effective_date := trunc(sysdate);
102: --
103: -- Set the report mode by checking the data in
104: -- table PER_PTU_DFF_MIG_FAILED_PEOPLE.
105: --
106: open csr_is_alrady_run_for_bg(l_business_group_id);
107: fetch csr_is_alrady_run_for_bg into l_error_desc;
108: if csr_is_alrady_run_for_bg%found then

Line 226: program => 'PER_PTU_DFF_MIG',

222: */
223: ELSE
224: --
225: l_request_id := fnd_request.submit_request(application => 'PER',
226: program => 'PER_PTU_DFF_MIG',
227: sub_request => TRUE,
228: argument1 => 'ARCHIVE',
229: argument2 => 'PEPTUDFFMIG',
230: argument3 => 'HR_PROCESS',

Line 295: FROM PER_PTU_DFF_MIG_FAILED_PEOPLE PPF

291: --
292: -- Run for failed records
293: --
294: sqlstr := 'SELECT DISTINCT PERSON_ID
295: FROM PER_PTU_DFF_MIG_FAILED_PEOPLE PPF
296: ,pay_payroll_actions ppa
297: WHERE ppa.payroll_action_id = :payroll_action_id
298: AND PPF.ERROR_DESCRIPTION <> ''SUCCESS''
299: AND PPF.BUSINESS_GROUP_ID

Line 332: from PER_PTU_DFF_MIG_FAILED_PEOPLE

328: AND ppa.payroll_action_id = pactid
329: AND ppf.business_group_id = nvl(p_business_group_id,ppf.business_group_id)
330: AND ppf.business_group_id not in
331: (select nvl(business_group_id,-1)
332: from PER_PTU_DFF_MIG_FAILED_PEOPLE
333: where ERROR_DESCRIPTION = 'SUCCESS'
334: AND PERSON_ID = hr_api.g_number)
335: AND (PPF.ATTRIBUTE1 IS NOT NULL OR
336: PPF.ATTRIBUTE2 IS NOT NULL OR

Line 369: FROM PER_PTU_DFF_MIG_FAILED_PEOPLE PPF

365: ORDER BY PPF.PERSON_ID;
366: --
367: CURSOR csr_process_failed(p_business_group_id number) IS
368: SELECT DISTINCT PPF.PERSON_ID PERSON_ID
369: FROM PER_PTU_DFF_MIG_FAILED_PEOPLE PPF
370: WHERE PPF.BUSINESS_GROUP_ID = NVL(p_business_group_id, PPF.BUSINESS_GROUP_ID)
371: AND PPF.ERROR_DESCRIPTION <> 'SUCCESS'
372: ORDER BY PPF.PERSON_ID;
373: --

Line 1589: UPDATE PER_PTU_DFF_MIG_FAILED_PEOPLE

1585: PRAGMA AUTONOMOUS_TRANSACTION;
1586: --
1587: BEGIN
1588: --
1589: UPDATE PER_PTU_DFF_MIG_FAILED_PEOPLE
1590: SET ERROR_DESCRIPTION = p_error_desc,
1591: REQUEST_ID = p_request_id
1592: WHERE PERSON_ID = p_person_id;
1593: --

Line 1596: INSERT INTO PER_PTU_DFF_MIG_FAILED_PEOPLE

1592: WHERE PERSON_ID = p_person_id;
1593: --
1594: IF SQL%rowcount = 0 THEN
1595: --
1596: INSERT INTO PER_PTU_DFF_MIG_FAILED_PEOPLE
1597: (PERSON_ID,
1598: BUSINESS_GROUP_ID,
1599: REQUEST_ID,
1600: ERROR_DESCRIPTION,

Line 2188: UPDATE PER_PTU_DFF_MIG_FAILED_PEOPLE

2184: END IF;
2185: --
2186: -- Insert/Update table for re-processing person_ids.
2187: --
2188: UPDATE PER_PTU_DFF_MIG_FAILED_PEOPLE
2189: SET ERROR_DESCRIPTION = 'SUCCESS',
2190: REQUEST_ID = g_request_id
2191: WHERE PERSON_ID = l_mig_rec.person_id;
2192: --

Line 2226: UPDATE PER_PTU_DFF_MIG_FAILED_PEOPLE

2222: ,p_attr_category => l_mig_rec.ATTRIBUTE_CATEGORY
2223: );
2224: --
2225: /*
2226: UPDATE PER_PTU_DFF_MIG_FAILED_PEOPLE
2227: SET ERROR_DESCRIPTION = substr(l_error_code||l_error_desc,1,990),
2228: REQUEST_ID = g_request_id
2229: WHERE PERSON_ID = l_mig_rec.person_id;
2230: --

Line 2233: INSERT INTO PER_PTU_DFF_MIG_FAILED_PEOPLE

2229: WHERE PERSON_ID = l_mig_rec.person_id;
2230: --
2231: IF SQL%rowcount = 0 THEN
2232: --
2233: INSERT INTO PER_PTU_DFF_MIG_FAILED_PEOPLE
2234: (PERSON_ID,
2235: BUSINESS_GROUP_ID,
2236: REQUEST_ID,
2237: ERROR_DESCRIPTION,

Line 2273: from PER_PTU_DFF_MIG_FAILED_PEOPLE

2269: l_person_id number;
2270: --
2271: cursor csr_failed_people(p_bg_id number) IS
2272: select person_id
2273: from PER_PTU_DFF_MIG_FAILED_PEOPLE
2274: where business_group_id = nvl(p_bg_id,business_group_id)
2275: and ERROR_DESCRIPTION <> 'SUCCESS'
2276: and PERSON_ID <> hr_api.g_number;
2277: --

Line 2286: -- Check the table PER_PTU_DFF_MIG_FAILED_PEOPLE for failed people for the given BG.

2282: -- then updating header table will result in no run for another BG in next request.
2283: -- Therefore use person_id and business_group_id combination to check whether the process
2284: -- for a perticular Bg was successful or not.
2285: --
2286: -- Check the table PER_PTU_DFF_MIG_FAILED_PEOPLE for failed people for the given BG.
2287: -- If any person record is found as failed then insert a record with person_id as
2288: -- hr_api.g_number and business_group_id as current business_group_id and
2289: -- error_description as FAILED. If no person record is failed then insert the above
2290: -- record with error_description as SUCCESS. This error_description is used in

Line 2303: UPDATE PER_PTU_DFF_MIG_FAILED_PEOPLE

2299: open csr_failed_people(l_business_group_id);
2300: fetch csr_failed_people into l_person_id;
2301: IF csr_failed_people%found THEN
2302: --
2303: UPDATE PER_PTU_DFF_MIG_FAILED_PEOPLE
2304: SET ERROR_DESCRIPTION = 'FAILED',
2305: REQUEST_ID = g_request_id
2306: WHERE PERSON_ID = hr_api.g_number
2307: and nvl(business_group_id,-1) = nvl(l_business_group_id,-1);

Line 2311: INSERT INTO PER_PTU_DFF_MIG_FAILED_PEOPLE

2307: and nvl(business_group_id,-1) = nvl(l_business_group_id,-1);
2308: --
2309: IF SQL%rowcount = 0 THEN
2310: --
2311: INSERT INTO PER_PTU_DFF_MIG_FAILED_PEOPLE
2312: (PERSON_ID,
2313: BUSINESS_GROUP_ID,
2314: REQUEST_ID,
2315: ERROR_DESCRIPTION,

Line 2333: UPDATE PER_PTU_DFF_MIG_FAILED_PEOPLE

2329: END IF;
2330: --
2331: ELSE
2332: --
2333: UPDATE PER_PTU_DFF_MIG_FAILED_PEOPLE
2334: SET ERROR_DESCRIPTION = 'SUCCESS',
2335: REQUEST_ID = g_request_id
2336: WHERE PERSON_ID = hr_api.g_number
2337: and nvl(business_group_id,-1) = nvl(l_business_group_id,-1);

Line 2340: INSERT INTO PER_PTU_DFF_MIG_FAILED_PEOPLE

2336: WHERE PERSON_ID = hr_api.g_number
2337: and nvl(business_group_id,-1) = nvl(l_business_group_id,-1);
2338: --
2339: IF SQL%rowcount = 0 THEN
2340: INSERT INTO PER_PTU_DFF_MIG_FAILED_PEOPLE
2341: (PERSON_ID,
2342: BUSINESS_GROUP_ID,
2343: REQUEST_ID,
2344: ERROR_DESCRIPTION,

Line 2372: FROM PER_PTU_DFF_MIG_FAILED_PEOPLE FAILED

2368: ,HEADER.REQUEST_ID = g_request_id
2369: WHERE HEADER.DATA_MAPPING_COMPLETE = 'Y'
2370: AND NOT EXISTS
2371: (SELECT NULL
2372: FROM PER_PTU_DFF_MIG_FAILED_PEOPLE FAILED
2373: WHERE FAILED.ATTRIBUTE_CATEGORY = HEADER.PER_DFF_CONTEXT_FIELD_CODE
2374: AND FAILED.ERROR_DESCRIPTION <> 'SUCCESS');
2375: */
2376: --

Line 2459: from PER_PTU_DFF_MIG_FAILED_PEOPLE failed

2455: ,papf.ATTRIBUTE30 = DECODE (INSTR (l_dff_attr_str , 'ATTRIBUTE30,'), 0, papf.ATTRIBUTE30, '')
2456: WHERE papf.ATTRIBUTE_CATEGORY = l_context_rec.PER_DFF_CONTEXT_FIELD_CODE
2457: and not exists
2458: (select failed.person_id
2459: from PER_PTU_DFF_MIG_FAILED_PEOPLE failed
2460: where failed.person_id = papf.person_id
2461: and failed.error_description <> 'SUCCESS');
2462: --
2463: -- Summary Report in LOG file.