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.PAYPLNK dependencies on PAY_BATCH_CONTROL_TOTALS

Line 53: from pay_batch_control_totals bac

49: for update;
50: --
51: cursor csr_all_controls (l_batch_id in number) is
52: select *
53: from pay_batch_control_totals bac
54: where bac.batch_id = l_batch_id
55: and bac.control_status <> 'T'
56: for update;
57: --

Line 1024: from pay_batch_control_totals pct

1020: and pbl.batch_id = p_batch_id;
1021: --
1022: cursor csr_error_totals is
1023: select 'Y'
1024: from pay_batch_control_totals pct
1025: where pct.control_status = 'E'
1026: and pct.batch_id = p_batch_id;
1027: --
1028: cursor csr_error_header is

Line 1134: update pay_batch_control_totals

1130: hr_utility.set_location('payplnk.set_status',15);
1131: --
1132: if g_control_error = false then
1133: for g_control_record in csr_all_controls(p_batch_id) loop
1134: update pay_batch_control_totals
1135: set control_status = l_status
1136: where current of csr_all_controls;
1137: --
1138: end loop;

Line 1400: update pay_batch_control_totals ctl

1396: begin
1397: for l_error_count in 1..g_control_count loop
1398: if (g_control_record.batch_control_id = g_ctl_id_tbl(l_error_count)) then
1399: --
1400: update pay_batch_control_totals ctl
1401: set ctl.control_status =
1402: decode(g_ctl_stat_tbl(l_error_count),'F','E','V')
1403: where current of csr_all_controls;
1404: --

Line 1421: update pay_batch_control_totals ctl

1417: hr_utility.set_location('payplnk.set_header_status',30);
1418: --
1419: if l_line_match = false then
1420: --
1421: update pay_batch_control_totals ctl
1422: set ctl.control_status = 'V'
1423: where current of csr_all_controls;
1424: else
1425: l_line_match := false;

Line 1437: update pay_batch_control_totals

1433: -- This will be called if the payroll action status being set. This will be
1434: -- either at the end or when there are too many errors while
1435: -- validating lines.
1436: --
1437: update pay_batch_control_totals
1438: set control_status = decode(p_batch_operation,'TRANSFER','T','VALIDATE','V','P')
1439: where batch_id = p_batch_id
1440: and control_status = 'V'
1441: and exists

Line 1533: delete from pay_batch_control_totals

1529: purge_messages(p_batch_id,'Y');
1530: --
1531: hr_utility.set_location('payplnk.purge',10);
1532: --
1533: delete from pay_batch_control_totals
1534: where batch_id = p_batch_id;
1535: --
1536: hr_utility.set_location('payplnk.purge',15);
1537: --

Line 1635: , pay_batch_control_totals bac

1631: where exists
1632: (select null
1633: from pay_batch_headers bah
1634: , pay_batch_lines bal
1635: , pay_batch_control_totals bac
1636: where bah.batch_id = bal.batch_id(+)
1637: and bah.batch_id = bac.batch_id(+)
1638: and bah.batch_id = p_batch_id
1639: and ((bah.batch_status not in ('T','P')

Line 1736: update pay_batch_control_totals bac

1732: -- end if;
1733: --
1734: hr_utility.set_location('payplnk.validate_header',25);
1735: --
1736: update pay_batch_control_totals bac
1737: set bac.control_status = 'U'
1738: where bac.batch_id = p_batch_id
1739: and bac.control_status <> 'T';
1740: --

Line 2238: l_user_status pay_batch_control_totals.control_status%TYPE :=null;

2234: l_exists varchar2(1) :=null;
2235: l_usr_status_chk varchar2(1) :=null;
2236: l_column_name1 varchar2(30) :=null;
2237: l_error_text pay_message_lines.line_text%TYPE := null;
2238: l_user_status pay_batch_control_totals.control_status%TYPE :=null;
2239: l_user_message pay_message_lines.line_text%TYPE :=null;
2240: -- Additions for standard totalling functionality
2241: l_std_status pay_batch_control_totals.control_status%TYPE :=null;
2242: l_std_message pay_message_lines.line_text%TYPE :=null;

Line 2241: l_std_status pay_batch_control_totals.control_status%TYPE :=null;

2237: l_error_text pay_message_lines.line_text%TYPE := null;
2238: l_user_status pay_batch_control_totals.control_status%TYPE :=null;
2239: l_user_message pay_message_lines.line_text%TYPE :=null;
2240: -- Additions for standard totalling functionality
2241: l_std_status pay_batch_control_totals.control_status%TYPE :=null;
2242: l_std_message pay_message_lines.line_text%TYPE :=null;
2243: --
2244: column_is_null exception;
2245: invalid_value exception;

Line 2338: -- update pay_batch_control_totals bac

2334:
2335:
2336: exception
2337: when others then
2338: -- update pay_batch_control_totals bac
2339: -- set bac.control_status = 'E'
2340: -- where current of csr_all_controls;
2341:
2342: select hlk.meaning into l_std_message -- we already checked to see if this

Line 2378: -- update control status. Both V and W -> V in pay_batch_control_totals

2374:
2375: if(l_std_status <> 'C') then --control was a standard one and has been
2376: -- processed by the above routine
2377:
2378: -- update control status. Both V and W -> V in pay_batch_control_totals
2379:
2380: -- update pay_batch_control_totals bac
2381: -- set bac.control_status = decode(l_std_status,'W','V',l_std_status)
2382: -- where current of csr_all_controls;

Line 2380: -- update pay_batch_control_totals bac

2376: -- processed by the above routine
2377:
2378: -- update control status. Both V and W -> V in pay_batch_control_totals
2379:
2380: -- update pay_batch_control_totals bac
2381: -- set bac.control_status = decode(l_std_status,'W','V',l_std_status)
2382: -- where current of csr_all_controls;
2383:
2384: if(l_std_status <> 'V') then -- control not valid. Could be 'E' or 'W'

Line 2441: -- update pay_batch_control_totals bac

2437: --
2438:
2439: when others then
2440: --
2441: -- update pay_batch_control_totals bac
2442: -- set bac.control_status = 'E'
2443: -- where current of csr_all_controls;
2444: --
2445: hr_utility.set_message(801,'HR_7481_PLK_USR_CHECK_ERROR');

Line 2478: -- update pay_batch_control_totals bac

2474: -- If a status has not been returned raise an error.
2475: --
2476: if l_user_status is null then
2477: --
2478: -- update pay_batch_control_totals bac
2479: -- set bac.control_status = 'E'
2480: -- where current of csr_all_controls;
2481: --
2482: hr_utility.set_message(801,'HR_7468_PLK_USR_STATUS_NULL');

Line 2515: -- update pay_batch_control_totals bac

2511: --
2512: if csr_status_chk%NOTFOUND then
2513: -- An invalid status has been returned, raise an error.
2514: --
2515: -- update pay_batch_control_totals bac
2516: -- set bac.control_status = 'E'
2517: -- where current of csr_all_controls;
2518: --
2519: hr_utility.set_message(801,'HR_7469_PLK_USR_STATUS_INVLD');

Line 2552: -- update pay_batch_control_totals bac

2548: --
2549: -- A status has been returned that is not valid in this context, raise
2550: -- an error.
2551: --
2552: -- update pay_batch_control_totals bac
2553: -- set bac.control_status = 'E'
2554: -- where current of csr_all_controls;
2555: --
2556: hr_utility.set_message(801,'HR_7470_PLK_USR_STATUS_INVLD_C');

Line 2591: -- update pay_batch_control_totals bac

2587: -- a message into the PAY_MESSAGE_LINES table if one has been returned.
2588: --
2589: close csr_status_chk;
2590: --
2591: -- update pay_batch_control_totals bac
2592: -- set bac.control_status = decode(upper(l_user_status),
2593: -- 'W','V',
2594: -- upper(l_user_status))
2595: -- where current of csr_all_controls;

Line 2646: -- update pay_batch_control_totals bac

2642: -- A value was required.
2643: --
2644: g_control_error := true;
2645: --
2646: -- update pay_batch_control_totals bac
2647: -- set bac.control_status = 'E'
2648: -- where current of csr_all_controls;
2649: --
2650: hr_utility.set_message(801,'HR_7449_PLK_COLUMN_NULL');

Line 2679: -- update pay_batch_control_totals bac

2675: -- An invalid value was entered.
2676: --
2677: g_control_error := true;
2678: --
2679: -- update pay_batch_control_totals bac
2680: -- set bac.control_status = 'E'
2681: -- where current of csr_all_controls;
2682: --
2683: hr_utility.set_message(801,'HR_7462_PLK_INVLD_VALUE');

Line 2723: -- update pay_batch_control_totals bac

2719: g_control_error := true;
2720: --
2721: for g_control_record in csr_all_controls(p_batch_id) loop
2722: --
2723: -- update pay_batch_control_totals bac
2724: -- set bac.control_status = 'E'
2725: -- where current of csr_all_controls;
2726: --
2727: hr_utility.set_message(801,'HR_7477_PLK_NO_CONTROL_TYPES');

Line 2917: from pay_batch_control_totals pct

2913: --
2914: --
2915: cursor csr_error_totals is
2916: select 'Y'
2917: from pay_batch_control_totals pct
2918: where pct.control_status = 'E'
2919: and pct.batch_id = p_batch_id;
2920: --
2921: cursor cur_max is

Line 4836: from pay_batch_control_totals

4832: ) is
4833: --
4834: cursor pcl (p_batch_id number) is
4835: select batch_control_id
4836: from pay_batch_control_totals
4837: where batch_id = p_batch_id
4838: and (control_status <> 'T' or p_mode='Y');
4839: --
4840: cursor pbl (p_batch_id number) is