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 65: from pay_batch_headers bah

61: for update;
62: --
63: cursor csr_header (l_batch_id in number) is
64: select *
65: from pay_batch_headers bah
66: where bah.batch_id = l_batch_id
67: for update;
68: --
69: -- This was introduced to overcome the performace within the

Line 74: from pay_batch_headers bah

70: -- validate_lines procedure.
71: --
72: cursor csr_bl_header (l_batch_id in number) is
73: select *
74: from pay_batch_headers bah
75: where bah.batch_id = l_batch_id;
76: --
77: cursor csr_status_chk (l_user_status in varchar2) is
78: select 'x'

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

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

Line 591: -- update pay_batch_headers bah

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

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

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

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

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

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

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

Line 1028: from pay_batch_headers pbh

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

Line 1035: from pay_batch_headers pbh

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

Line 1105: update pay_batch_headers

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

Line 1141: update pay_batch_headers

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

Line 1347: update pay_batch_headers

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

Line 1441: from pay_batch_headers pbh

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

Line 1445: update pay_batch_headers

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

Line 1495: from pay_batch_headers pbh

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

Line 1541: delete from pay_batch_headers

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

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

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

Line 1631: from pay_batch_headers bah

1627: into l_transfer_recs
1628: from sys.dual
1629: where exists
1630: (select null
1631: from pay_batch_headers bah
1632: , pay_batch_lines bal
1633: , pay_batch_control_totals bac
1634: where bah.batch_id = bal.batch_id(+)
1635: and bah.batch_id = bac.batch_id(+)

Line 1686: from pay_batch_headers

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

Line 1721: update pay_batch_headers bah

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

Line 1726: -- update pay_batch_headers bah

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

Line 1808: -- update pay_batch_headers bah

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

Line 1840: -- update pay_batch_headers bah

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

Line 1894: -- update pay_batch_headers bah

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

Line 1924: -- update pay_batch_headers bah

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

Line 1960: -- update pay_batch_headers bah

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

Line 1997: -- update pay_batch_headers bah

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

Line 2032: -- update pay_batch_headers bah

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

Line 2076: -- update pay_batch_headers bah

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

Line 2130: -- update pay_batch_headers bah

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

Line 2165: -- update pay_batch_headers bah

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

Line 2896: from pay_batch_headers pbh

2892: l_err_exists varchar2(1) := null;
2893: --
2894: cursor csr_error_header is
2895: select 'Y'
2896: from pay_batch_headers pbh
2897: where pbh.batch_status = 'E'
2898: and pbh.batch_id = p_batch_id;
2899: --
2900: --