[Home] [Help]
547: hr_utility.trace('Before inserting the action record');
548:
549: select pay_assignment_actions_s.nextval
550: into lockingactid
551: from dual;
552:
553: -- insert the action record.
554: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
555:
669: hr_utility.trace('Before inserting the action record');
670:
671: select pay_assignment_actions_s.nextval
672: into lockingactid
673: from dual;
674:
675: -- insert the action record.
676: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
677:
794: hr_utility.trace('Before inserting the action record');
795:
796: select pay_assignment_actions_s.nextval
797: into lockingactid
798: from dual;
799:
800: -- insert the action record.
801: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
802:
877: hr_utility.trace('Before inserting the action record');
878:
879: select pay_assignment_actions_s.nextval
880: into lockingactid
881: from dual;
882:
883: -- insert the action record.
884: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
885:
978: close c_state_ueid;
979:
980: hr_utility.set_location(l_procedure_name, 170);
981: c_actions_with_state_sql := c_actions_with_state_sql ||
982: ' AND exists ( select 1 from dual
983: where 1 =
984: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
985: from ff_archive_items fai,
986: ff_archive_item_contexts fic1,
1010: fetch c_state_ueid into l_county_wheld;
1011: close c_state_ueid;
1012:
1013: c_actions_with_state_sql := c_actions_with_state_sql ||
1014: ' AND exists ( select 1 from dual
1015: where 1 =
1016: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1017: from ff_archive_items fai,
1018: ff_archive_item_contexts fic1,
1034: fetch c_state_ueid into l_subj_nwhable;
1035: close c_state_ueid;
1036:
1037: c_actions_with_state_sql := c_actions_with_state_sql ||
1038: ' AND exists ( select 1 from dual
1039: where 1 =
1040: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1041: from ff_archive_items fai,
1042: ff_archive_item_contexts fic1,
1069: close c_state_ueid;
1070:
1071: hr_utility.set_location(l_procedure_name, 170);
1072: c_actions_with_state_sql := c_actions_with_state_sql ||
1073: ' AND exists ( select 1 from dual
1074: where 1 =
1075: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1076: from ff_archive_items fai,
1077: ff_archive_item_contexts fic1,
1093: fetch c_state_ueid into l_subj_nwhable;
1094: close c_state_ueid;
1095:
1096: c_actions_with_state_sql := c_actions_with_state_sql ||
1097: ' AND exists ( select 1 from dual
1098: where 1 =
1099: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1100: from ff_archive_items fai,
1101: ff_archive_item_contexts fic1,
1124: fetch c_state_ueid into l_school_wheld;
1125: close c_state_ueid;
1126:
1127: c_actions_with_state_sql := c_actions_with_state_sql ||
1128: ' AND exists ( select 1 from dual
1129: where 1 =
1130: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1131: from ff_archive_items fai,
1132: ff_archive_item_contexts fic1,
1148: fetch c_state_ueid into l_subj_nwhable;
1149: close c_state_ueid;
1150:
1151: c_actions_with_state_sql := c_actions_with_state_sql ||
1152: ' AND exists ( select 1 from dual
1153: where 1 =
1154: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1155: from ff_archive_items fai,
1156: ff_archive_item_contexts fic1,
1194: hr_utility.trace('Before inserting the action record');
1195:
1196: select pay_assignment_actions_s.nextval
1197: into lockingactid
1198: from dual;
1199:
1200: -- insert the action record.
1201: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
1202:
1311: hr_utility.set_location('procpyr',3);
1312:
1313: select pay_assignment_actions_s.nextval
1314: into lockingactid
1315: from dual;
1316:
1317: -- insert the action record.
1318: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
1319:
1404: and paf2.effective_start_date <= p_session_date)
1405: AND paf.effective_end_date >= p_eoy_start_date
1406: AND paf.assignment_type = 'E'
1407: AND paf.person_id between stperson and endperson
1408: AND exists ( select 1 from dual
1409: where 1 =
1410: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1411: from ff_archive_items fai,
1412: ff_archive_item_contexts fic1,
1523: and paf.person_id = to_number(paa_arch.serial_number)
1524: AND ppr.payroll_action_id = ' || pactid || '
1525: AND ppr.chunk_number = ' || chunk || '
1526: AND paf.person_id = ppr.person_id
1527: AND exists ( select 1 from dual
1528: where 1 =
1529: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1530: from ff_archive_items fai,
1531: ff_archive_item_contexts fic1,
1560: AND paf.assignment_type = ''E''
1561: and paf.primary_flag = ''Y''
1562: AND paf.person_id between ' || stperson || ' and ' || endperson || '
1563: and paf.person_id = to_number(paa_arch.serial_number)
1564: AND exists ( select 1 from dual
1565: where 1 =
1566: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1567: from ff_archive_items fai,
1568: ff_archive_item_contexts fic1,
1602: hr_utility.set_location('procpyr',3);
1603:
1604: select pay_assignment_actions_s.nextval
1605: into lockingactid
1606: from dual;
1607:
1608: -- insert the action record.
1609: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
1610:
1651: --AND paf.person_id between stperson and endperson
1652: AND ppr.payroll_action_id = ' || pactid || '
1653: AND ppr.chunk_number = ' || chunk || '
1654: AND paf.person_id = ppr.person_id
1655: AND exists ( select 1 from dual
1656: where 1 =
1657: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1658: from ff_archive_items fai,
1659: ff_archive_item_contexts fic1,
1693: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
1694: AND paf.assignment_type = ''E''
1695: AND pps.period_of_service_id = paf.period_of_service_id
1696: AND paf.person_id between ' || stperson || ' and ' || endperson || '
1697: AND exists ( select 1 from dual
1698: where 1 =
1699: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1700: from ff_archive_items fai,
1701: ff_archive_item_contexts fic1,
1737: hr_utility.set_location('procpyr',3);
1738:
1739: select pay_assignment_actions_s.nextval
1740: into lockingactid
1741: from dual;
1742:
1743: -- insert the action record.
1744: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
1745:
1787: --AND paf.person_id between stperson and endperson
1788: AND ppr.payroll_action_id = ' || pactid || '
1789: AND ppr.chunk_number = ' || chunk || '
1790: AND paf.person_id = ppr.person_id
1791: AND exists ( select 1 from dual
1792: where 1 =
1793: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1794: from ff_archive_items fai,
1795: ff_archive_item_contexts fic1,
1829: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
1830: AND paf.assignment_type = ''E''
1831: AND pps.period_of_service_id = paf.period_of_service_id
1832: AND paf.person_id between ' || stperson || ' and ' || endperson || '
1833: AND exists ( select 1 from dual
1834: where 1 =
1835: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1836: from ff_archive_items fai,
1837: ff_archive_item_contexts fic1,
1873: hr_utility.set_location('procpyr',3);
1874:
1875: select pay_assignment_actions_s.nextval
1876: into lockingactid
1877: from dual;
1878:
1879: -- insert the action record.
1880: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
1881:
1916: hr_utility.set_location('procpyr',3);
1917:
1918: select pay_assignment_actions_s.nextval
1919: into lockingactid
1920: from dual;
1921:
1922: -- insert the action record.
1923: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
1924:
1963: from hr_assignment_set_amendments hasa
1964: where hasa.assignment_set_id = ' || p_asg_set_id || '
1965: and hasa.assignment_id = paa_arch.assignment_id
1966: and upper(hasa.include_or_exclude) = ''I'')
1967: AND exists ( select 1 from dual
1968: where 1 =
1969: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1970: from ff_archive_items fai,
1971: ff_archive_item_contexts fic1,
2003: from hr_assignment_set_amendments hasa
2004: where hasa.assignment_set_id = ' || p_asg_set_id || '
2005: and hasa.assignment_id = paa_arch.assignment_id
2006: and upper(hasa.include_or_exclude) = ''I'')
2007: AND exists ( select 1 from dual
2008: where 1 =
2009: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
2010: from ff_archive_items fai,
2011: ff_archive_item_contexts fic1,
2046: hr_utility.set_location('procpyr',3);
2047:
2048: select pay_assignment_actions_s.nextval
2049: into lockingactid
2050: from dual;
2051:
2052: -- insert the action record.
2053: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
2054:
2260: /* changed this with the if statement below
2261: begin
2262: select to_date('31-DEC-'||to_char(l_year),'DD/MM/YYYY')
2263: into l_dt
2264: from dual
2265: where to_date('31-DEC-'||to_char(l_year),'DD/MM/YYYY') > l_dt;
2266: exception
2267: when others then null;
2268: end;