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.PAY_AU_REC_DET_ARCHIVE dependencies on PAY_ACTION_INFORMATION

Line 306: -- in pay_Action_information with context 'AU_ARCHIVE_ASG_DETAILS'

302: -- This procedure gets the parameters given by user and restricts
303: -- the assignments to be archived.
304: -- it then calls hr_nonrun.insact to create an assignment action id
305: -- it then archives Payroll Run assignment action id details
306: -- in pay_Action_information with context 'AU_ARCHIVE_ASG_DETAILS'
307: -- for each assignment.
308: -- There are 10 different cursors for choosing the assignment ids.
309: -- Depending on the parameters passed,the appropriate cursor is used.
310: --------------------------------------------------------------------+

Line 946: insert into pay_action_information(

942: -- Create the archive assignment actions
943: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
944:
945:
946: insert into pay_action_information(
947: action_information_id,
948: action_context_id,
949: action_context_type,
950: effective_date,

Line 960: pay_action_information_s.nextval,

956: action_information3,
957: assignment_id
958: )
959: values(
960: pay_action_information_s.nextval,
961: l_next_assignment_action_id,
962: 'AAP',
963: null,
964: null,

Line 1003: insert into pay_action_information(

999:
1000: -- Create the archive assignment actions
1001: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1002:
1003: insert into pay_action_information(
1004: action_information_id,
1005: action_context_id,
1006: action_context_type,
1007: effective_date,

Line 1017: pay_action_information_s.nextval,

1013: action_information3,
1014: assignment_id
1015: )
1016: values(
1017: pay_action_information_s.nextval,
1018: l_next_assignment_action_id,
1019: 'AAP',
1020: null,
1021: null,

Line 1064: insert into pay_action_information(

1060:
1061: -- Create the archive assignment actions
1062: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1063:
1064: insert into pay_action_information(
1065: action_information_id,
1066: action_context_id,
1067: action_context_type,
1068: effective_date,

Line 1078: pay_action_information_s.nextval,

1074: action_information3,
1075: assignment_id
1076: )
1077: values(
1078: pay_action_information_s.nextval,
1079: l_next_assignment_action_id,
1080: 'AAP',
1081: null,
1082: null,

Line 1121: insert into pay_action_information(

1117:
1118: -- Create the archive assignment actions
1119: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1120:
1121: insert into pay_action_information(
1122: action_information_id,
1123: action_context_id,
1124: action_context_type,
1125: effective_date,

Line 1135: pay_action_information_s.nextval,

1131: action_information3,
1132: assignment_id
1133: )
1134: values(
1135: pay_action_information_s.nextval,
1136: l_next_assignment_action_id,
1137: 'AAP',
1138: null,
1139: null,

Line 1183: insert into pay_action_information(

1179:
1180: -- Create the archive assignment actions
1181: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1182:
1183: insert into pay_action_information(
1184: action_information_id,
1185: action_context_id,
1186: action_context_type,
1187: effective_date,

Line 1197: pay_action_information_s.nextval,

1193: action_information3,
1194: assignment_id
1195: )
1196: values(
1197: pay_action_information_s.nextval,
1198: l_next_assignment_action_id,
1199: 'AAP',
1200: null,
1201: null,

Line 1241: insert into pay_action_information(

1237:
1238: -- Create the archive assignment actions
1239: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1240:
1241: insert into pay_action_information(
1242: action_information_id,
1243: action_context_id,
1244: action_context_type,
1245: effective_date,

Line 1255: pay_action_information_s.nextval,

1251: action_information3,
1252: assignment_id
1253: )
1254: values(
1255: pay_action_information_s.nextval,
1256: l_next_assignment_action_id,
1257: 'AAP',
1258: null,
1259: null,

Line 1303: insert into pay_action_information(

1299:
1300: -- Create the archive assignment actions
1301: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1302:
1303: insert into pay_action_information(
1304: action_information_id,
1305: action_context_id,
1306: action_context_type,
1307: effective_date,

Line 1317: pay_action_information_s.nextval,

1313: action_information3,
1314: assignment_id
1315: )
1316: values(
1317: pay_action_information_s.nextval,
1318: l_next_assignment_action_id,
1319: 'AAP',
1320: null,
1321: null,

Line 1360: insert into pay_action_information(

1356:
1357: -- Create the archive assignment actions
1358: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1359:
1360: insert into pay_action_information(
1361: action_information_id,
1362: action_context_id,
1363: action_context_type,
1364: effective_date,

Line 1374: pay_action_information_s.nextval,

1370: action_information3,
1371: assignment_id
1372: )
1373: values(
1374: pay_action_information_s.nextval,
1375: l_next_assignment_action_id,
1376: 'AAP',
1377: null,
1378: null,

Line 1422: insert into pay_action_information(

1418:
1419: -- Create the archive assignment actions
1420: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1421:
1422: insert into pay_action_information(
1423: action_information_id,
1424: action_context_id,
1425: action_context_type,
1426: effective_date,

Line 1436: pay_action_information_s.nextval,

1432: action_information3,
1433: assignment_id
1434: )
1435: values(
1436: pay_action_information_s.nextval,
1437: l_next_assignment_action_id,
1438: 'AAP',
1439: null,
1440: null,

Line 1478: insert into pay_action_information(

1474:
1475: -- Create the archive assignment actions
1476: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1477:
1478: insert into pay_action_information(
1479: action_information_id,
1480: action_context_id,
1481: action_context_type,
1482: effective_date,

Line 1492: pay_action_information_s.nextval,

1488: action_information3,
1489: assignment_id
1490: )
1491: values(
1492: pay_action_information_s.nextval,
1493: l_next_assignment_action_id,
1494: 'AAP',
1495: null,
1496: null,

Line 1530: -- Checks pay_Action_information context ='AU_ARCHIVE_ASG_DETAILS'

1526: -- Type : Procedure
1527: -- Access: Public
1528: -- This procedure archives details for assignment.
1529: -- Employee details
1530: -- Checks pay_Action_information context ='AU_ARCHIVE_ASG_DETAILS'
1531: -- If employee details not previously archived,proc archives
1532: -- employee details in pay_Action_information with context
1533: -- 'AU_EMPLOYEE_RECON_DETAILS'.
1534: -- Element details.

Line 1532: -- employee details in pay_Action_information with context

1528: -- This procedure archives details for assignment.
1529: -- Employee details
1530: -- Checks pay_Action_information context ='AU_ARCHIVE_ASG_DETAILS'
1531: -- If employee details not previously archived,proc archives
1532: -- employee details in pay_Action_information with context
1533: -- 'AU_EMPLOYEE_RECON_DETAILS'.
1534: -- Element details.
1535: -- For each assignment run,proc archives element processed in
1536: -- pay_Action_information with context 'AU_ELEMENT_RECON_DETAILS'

Line 1536: -- pay_Action_information with context 'AU_ELEMENT_RECON_DETAILS'

1532: -- employee details in pay_Action_information with context
1533: -- 'AU_EMPLOYEE_RECON_DETAILS'.
1534: -- Element details.
1535: -- For each assignment run,proc archives element processed in
1536: -- pay_Action_information with context 'AU_ELEMENT_RECON_DETAILS'
1537: -- Balance Details.
1538: -- For each assignment run,proc archives balance details in
1539: -- pay_Action_information with context 'AU_BALANCE_RECON_DETAILS'
1540: -- Uses package pay_au_reconciliation_pkg to fetch balances.

Line 1539: -- pay_Action_information with context 'AU_BALANCE_RECON_DETAILS'

1535: -- For each assignment run,proc archives element processed in
1536: -- pay_Action_information with context 'AU_ELEMENT_RECON_DETAILS'
1537: -- Balance Details.
1538: -- For each assignment run,proc archives balance details in
1539: -- pay_Action_information with context 'AU_BALANCE_RECON_DETAILS'
1540: -- Uses package pay_au_reconciliation_pkg to fetch balances.
1541:
1542: --------------------------------------------------------------------+
1543:

Line 1718: from pay_action_information pai

1714:
1715: cursor csr_get_data (c_arc_ass_act_id number)
1716: is
1717: select pai.action_information1, pai.tax_unit_id, pai.assignment_id,pai.action_information3
1718: from pay_action_information pai
1719: where action_information_category = 'AU_ARCHIVE_ASG_DETAILS'
1720: and pai.action_context_id = c_arc_ass_act_id;
1721:
1722: /*Bug 4040688 - Two new cursors added to get the maximum assignment action id*/

Line 1912: insert into pay_action_information (

1908: P_YTD_NET_PAYMENT => l_YTD_NET_PAYMENT ,
1909: P_YTD_EMPLOYER_CHARGES => l_YTD_EMPLOYER_CHARGES);
1910: END IF ;
1911:
1912: insert into pay_action_information (
1913: action_information_id,
1914: action_context_id,
1915: action_context_type,
1916: effective_date,

Line 1932: pay_action_information_s.nextval,

1928: action_information8,
1929: action_information9,
1930: action_information10)
1931: values (
1932: pay_action_information_s.nextval,
1933: p_assignment_action_id,
1934: 'AAP',
1935: p_effective_date,
1936: null,

Line 1960: /* Bug 3953702 - Archived the Grade Name details into pay_action_information */

1956: hr_utility.set_location('l_max_asg_action_id......= '|| l_max_asg_action_id,20);
1957: end if;
1958:
1959: -- Archive employee details
1960: /* Bug 3953702 - Archived the Grade Name details into pay_action_information */
1961:
1962: /*Bug 4688872*/
1963: OPEN c_get_payroll_name(l_assignment_id,g_start_date,g_end_date);
1964: FETCH c_get_payroll_name INTO l_payroll_id, l_payroll_name;

Line 1968: insert into pay_action_information(

1964: FETCH c_get_payroll_name INTO l_payroll_id, l_payroll_name;
1965: CLOSE c_get_payroll_name;
1966:
1967:
1968: insert into pay_action_information(
1969: action_information_id,
1970: action_context_id,
1971: action_context_type,
1972: effective_date,

Line 1989: pay_action_information_s.nextval,

1985: action_information10,
1986: action_information11,
1987: assignment_id)
1988: values(
1989: pay_action_information_s.nextval,
1990: g_arc_payroll_action_id,
1991: 'PA',
1992: p_effective_date,
1993: null,

Line 2033: -- Insert the element data into pay_action_information table

2029: END IF;
2030: end if;
2031:
2032: --
2033: -- Insert the element data into pay_action_information table
2034: -- This Direct Insert statement is for Performance Reasons.
2035: --
2036:
2037: insert into pay_action_information (

Line 2037: insert into pay_action_information (

2033: -- Insert the element data into pay_action_information table
2034: -- This Direct Insert statement is for Performance Reasons.
2035: --
2036:
2037: insert into pay_action_information (
2038: action_information_id,
2039: action_context_id,
2040: action_context_type,
2041: effective_date,

Line 2053: pay_action_information_s.nextval,

2049: action_information5,
2050: action_information6,
2051: assignment_id)
2052: values (
2053: pay_action_information_s.nextval,
2054: p_assignment_action_id,
2055: 'AAP',
2056: p_effective_date,
2057: null,

Line 2099: -- Insert the balance data into pay_action_information table

2095: P_EMPLOYER_CHARGES => l_EMPLOYER_CHARGES);
2096:
2097:
2098: --
2099: -- Insert the balance data into pay_action_information table
2100: -- This Direct Insert statement is for Performance Reasons.
2101: --
2102: /*Bug 4040688 - Modified insert statement to store run balance details.*/
2103: insert into pay_action_information (

Line 2103: insert into pay_action_information (

2099: -- Insert the balance data into pay_action_information table
2100: -- This Direct Insert statement is for Performance Reasons.
2101: --
2102: /*Bug 4040688 - Modified insert statement to store run balance details.*/
2103: insert into pay_action_information (
2104: action_information_id,
2105: action_context_id,
2106: action_context_type,
2107: effective_date,

Line 2123: pay_action_information_s.nextval,

2119: action_information8,
2120: action_information9,
2121: action_information10)
2122: values (
2123: pay_action_information_s.nextval,
2124: p_assignment_action_id,
2125: 'AAP',
2126: p_effective_date,
2127: null,