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_HEADERS

Line 18: g_user_status pay_batch_headers.batch_status%TYPE;

14: g_control_error boolean;
15: g_line_error boolean;
16: g_header_processing boolean := FALSE;
17: g_process_mode varchar2(50);
18: g_user_status pay_batch_headers.batch_status%TYPE;
19: g_count binary_integer := 0;
20: --
21: g_line_id_tbl hr_entry.number_table;
22: g_status_tbl hr_entry.varchar2_table;

Line 60: from pay_batch_headers bah

56: for update;
57: --
58: cursor csr_header (l_batch_id in number) is
59: select *
60: from pay_batch_headers bah
61: where bah.batch_id = l_batch_id
62: for update;
63: --
64: -- This was introduced to overcome the performace within the

Line 69: from pay_batch_headers bah

65: -- validate_lines procedure.
66: --
67: cursor csr_bl_header (l_batch_id in number) is
68: select *
69: from pay_batch_headers bah
70: where bah.batch_id = l_batch_id;
71: --
72: cursor csr_status_chk (l_user_status in varchar2) is
73: select 'x'

Line 516: -- Validates the batch header details held in pay_batch_headers.

512: -- end if;
513: -- --
514: -- end;
515: --
516: -- Validates the batch header details held in pay_batch_headers.
517: --
518: validate_header (
519: p_batch_id,
520: p_business_group_id,

Line 593: -- update pay_batch_headers bah

589: -- --
590: -- elsif (p_batch_operation = 'TRANSFER') and (g_line_error = true) then
591: -- rollback;
592: -- -- Safe now to reset the batch status from 'P' to original.
593: -- update pay_batch_headers bah
594: -- set bah.batch_status = decode(upper(g_user_status),
595: -- 'W','V',
596: -- upper(g_user_status))
597: -- where bah.batch_id = p_batch_id;

Line 1012: l_batch_status pay_batch_headers.batch_status%TYPE := null;

1008: p_batch_id in number
1009: ) is
1010: --
1011: l_errors_exists varchar2(1) := null;
1012: l_batch_status pay_batch_headers.batch_status%TYPE := null;
1013: l_status pay_batch_headers.batch_status%TYPE := null;
1014: l_purge_after_transfer pay_batch_headers.purge_after_transfer%TYPE := null;
1015: --
1016: cursor csr_error_lines is

Line 1013: l_status pay_batch_headers.batch_status%TYPE := null;

1009: ) is
1010: --
1011: l_errors_exists varchar2(1) := null;
1012: l_batch_status pay_batch_headers.batch_status%TYPE := null;
1013: l_status pay_batch_headers.batch_status%TYPE := null;
1014: l_purge_after_transfer pay_batch_headers.purge_after_transfer%TYPE := null;
1015: --
1016: cursor csr_error_lines is
1017: select 'Y'

Line 1014: l_purge_after_transfer pay_batch_headers.purge_after_transfer%TYPE := null;

1010: --
1011: l_errors_exists varchar2(1) := null;
1012: l_batch_status pay_batch_headers.batch_status%TYPE := null;
1013: l_status pay_batch_headers.batch_status%TYPE := null;
1014: l_purge_after_transfer pay_batch_headers.purge_after_transfer%TYPE := null;
1015: --
1016: cursor csr_error_lines is
1017: select 'Y'
1018: from pay_batch_lines pbl

Line 1030: from pay_batch_headers pbh

1026: and pct.batch_id = p_batch_id;
1027: --
1028: cursor csr_error_header is
1029: select 'Y'
1030: from pay_batch_headers pbh
1031: where pbh.batch_status = 'E'
1032: and pbh.batch_id = p_batch_id;
1033: --
1034: cursor csr_header_status is

Line 1037: from pay_batch_headers pbh

1033: --
1034: cursor csr_header_status is
1035: select pbh.batch_status,
1036: pbh.purge_after_transfer
1037: from pay_batch_headers pbh
1038: where pbh.batch_id = p_batch_id;
1039: --
1040: begin
1041: --

Line 1107: update pay_batch_headers

1103: end if;
1104: --
1105: if (p_batch_operation = 'VALIDATE' and g_header_error = false) then
1106: --
1107: update pay_batch_headers
1108: set batch_status = l_status
1109: where batch_id = p_batch_id;
1110: else
1111: --

Line 1143: update pay_batch_headers

1139: end if;
1140: --
1141: hr_utility.set_location('payplnk.set_status',20);
1142: --
1143: update pay_batch_headers
1144: set batch_status = l_status
1145: where batch_id = p_batch_id;
1146: --
1147: hr_utility.set_location('payplnk.set_status',25);

Line 1349: update pay_batch_headers

1345: 'H',
1346: g_head_err_msg);
1347:
1348: if g_head_err_stat = 'F' then
1349: update pay_batch_headers
1350: set batch_status = 'E'
1351: where batch_id = p_batch_id;
1352: end if;
1353: end if;

Line 1443: from pay_batch_headers pbh

1439: where batch_id = p_batch_id
1440: and control_status = 'V'
1441: and exists
1442: ( select null
1443: from pay_batch_headers pbh
1444: where pbh.batch_id = p_batch_id
1445: and pbh.batch_status = 'P');
1446: --
1447: update pay_batch_headers

Line 1447: update pay_batch_headers

1443: from pay_batch_headers pbh
1444: where pbh.batch_id = p_batch_id
1445: and pbh.batch_status = 'P');
1446: --
1447: update pay_batch_headers
1448: set batch_status = decode(p_batch_operation,'TRANSFER','T','VALIDATE','V','P')
1449: where batch_id = p_batch_id
1450: and batch_status = 'P';
1451: --

Line 1497: from pay_batch_headers pbh

1493: l_ovn number;
1494: --
1495: cursor csr_ovn is
1496: select pbh.object_version_number
1497: from pay_batch_headers pbh
1498: where pbh.batch_id = p_batch_id;
1499: --
1500: begin
1501: --

Line 1543: delete from pay_batch_headers

1539: where batch_id = p_batch_id;
1540: --
1541: hr_utility.set_location('payplnk.purge',20);
1542: --
1543: delete from pay_batch_headers
1544: where batch_id = p_batch_id;
1545: --
1546: hr_utility.set_location('payplnk.purge',25);
1547: --

Line 1583: l_user_status pay_batch_headers.batch_status%TYPE := null;

1579: l_process_recs varchar2(1) := null;
1580: l_column_name1 varchar2(30):= null;
1581: l_usr_status_chk varchar2(1) := null;
1582: l_error_text pay_message_lines.line_text%TYPE := null;
1583: l_user_status pay_batch_headers.batch_status%TYPE := null;
1584: l_user_message pay_message_lines.line_text%TYPE := null;
1585: sql_curs number;
1586: rows_processed integer;
1587: statem varchar2(256);

Line 1633: from pay_batch_headers bah

1629: into l_transfer_recs
1630: from sys.dual
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(+)

Line 1688: from pay_batch_headers

1684: -- Check the batch status is not already PROCESSING.
1685: --
1686: savepoint A;
1687: select batch_status into l_process_recs
1688: from pay_batch_headers
1689: where batch_id = p_batch_id
1690: for update;
1691: hr_utility.trace('batch_status ='||l_process_recs);
1692: hr_utility.trace('processing mode = '||g_process_mode);

Line 1723: update pay_batch_headers bah

1719: g_head_err_stat := 'F';
1720: --
1721: raise core_error;
1722: end if;
1723: update pay_batch_headers bah
1724: set bah.batch_status = 'P'
1725: where bah.batch_id = p_batch_id;
1726: -- commit;
1727: -- else

Line 1728: -- update pay_batch_headers bah

1724: set bah.batch_status = 'P'
1725: where bah.batch_id = p_batch_id;
1726: -- commit;
1727: -- else
1728: -- update pay_batch_headers bah
1729: -- set bah.batch_status = 'U'
1730: -- where bah.batch_id = p_batch_id;
1731: -- commit;
1732: -- end if;

Line 1810: -- update pay_batch_headers bah

1806: if dbms_sql.is_open(sql_curs) then
1807: dbms_sql.close_cursor(sql_curs);
1808: end if;
1809: --
1810: -- update pay_batch_headers bah
1811: -- set bah.batch_status = 'E'
1812: -- where current of csr_header;
1813: --
1814: hr_utility.set_message(801,'HR_7481_PLK_USR_CHECK_ERROR');

Line 1842: -- update pay_batch_headers bah

1838: raise user_error;
1839: end;
1840: --
1841: if l_valid = 0 then
1842: -- update pay_batch_headers bah
1843: -- set bah.batch_status = 'E'
1844: -- where current of csr_header;
1845: --
1846: hr_utility.set_message(801,'HR_7469_PLK_USR_STATUS_INVLD');

Line 1896: -- update pay_batch_headers bah

1892: -- The user defined checks could not be found.
1893: --
1894: g_header_error := true;
1895: --
1896: -- update pay_batch_headers bah
1897: -- set bah.batch_status = 'E'
1898: -- where current of csr_header;
1899: --
1900: hr_utility.set_message(801,'HR_7450_PLK_PACK_BODY_NOT_EXST');

Line 1926: -- update pay_batch_headers bah

1922: --
1923: --
1924: when others then
1925: --
1926: -- update pay_batch_headers bah
1927: -- set bah.batch_status = 'E'
1928: -- where current of csr_header;
1929: --
1930: hr_utility.set_message(801,'HR_7481_PLK_USR_CHECK_ERROR');

Line 1962: -- update pay_batch_headers bah

1958: -- If a status has not been returned raise an error.
1959: --
1960: if l_user_status is null then
1961: --
1962: -- update pay_batch_headers bah
1963: -- set bah.batch_status = 'E'
1964: -- where current of csr_header;
1965: --
1966: hr_utility.set_message(801,'HR_7468_PLK_USR_STATUS_NULL');

Line 1999: -- update pay_batch_headers bah

1995: if csr_status_chk%NOTFOUND then
1996: --
1997: -- An invalid status has been returned, raise an error.
1998: --
1999: -- update pay_batch_headers bah
2000: -- set bah.batch_status = 'E'
2001: -- where current of csr_header;
2002: hr_utility.set_message(801,'HR_7469_PLK_USR_STATUS_INVLD');
2003: hr_utility.set_message_token('USER_PROCEDURE',

Line 2034: -- update pay_batch_headers bah

2030: --
2031: -- A status has been returned that is not valid in this context, raise
2032: -- an error.
2033: --
2034: -- update pay_batch_headers bah
2035: -- set bah.batch_status = 'E'
2036: -- where current of csr_header;
2037: --
2038: hr_utility.set_message(801,'HR_7470_PLK_USR_STATUS_INVLD_C');

Line 2078: -- update pay_batch_headers bah

2074: -- If the process is in transfer mode, we really want to
2075: -- retain the batch status for now to 'P' to lock another
2076: -- submission of the batch submission inadvertantly.
2077: -- if(g_process_mode = 'VALIDATE') then
2078: -- update pay_batch_headers bah
2079: -- set bah.batch_status = decode(upper(l_user_status),
2080: -- 'W','V',
2081: -- upper(l_user_status))
2082: -- where current of csr_header;

Line 2132: -- update pay_batch_headers bah

2128: -- A value was required.
2129: --
2130: g_header_error := true;
2131: --
2132: -- update pay_batch_headers bah
2133: -- set bah.batch_status = 'E'
2134: -- where current of csr_header;
2135: --
2136: hr_utility.set_message(801,'HR_7449_PLK_COLUMN_NULL');

Line 2167: -- update pay_batch_headers bah

2163: -- An invalid value was entered.
2164: --
2165: g_header_error := true;
2166: --
2167: -- update pay_batch_headers bah
2168: -- set bah.batch_status = 'E'
2169: -- where current of csr_header;
2170: --
2171: hr_utility.set_message(801,'HR_7462_PLK_INVLD_VALUE');

Line 2900: from pay_batch_headers pbh

2896: l_err_exists varchar2(1) := null;
2897: --
2898: cursor csr_error_header is
2899: select 'Y'
2900: from pay_batch_headers pbh
2901: where pbh.batch_status = 'E'
2902: and pbh.batch_id = p_batch_id;
2903: --
2904: --