[Home] [Help]
556: hr_utility.trace('Before inserting the action record');
557:
558: select pay_assignment_actions_s.nextval
559: into lockingactid
560: from dual;
561:
562: -- insert the action record.
563: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
564:
670: hr_utility.trace('Before inserting the action record');
671:
672: select pay_assignment_actions_s.nextval
673: into lockingactid
674: from dual;
675:
676: -- insert the action record.
677: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
678:
787: hr_utility.trace('Before inserting the action record');
788:
789: select pay_assignment_actions_s.nextval
790: into lockingactid
791: from dual;
792:
793: -- insert the action record.
794: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
795:
870: hr_utility.trace('Before inserting the action record');
871:
872: select pay_assignment_actions_s.nextval
873: into lockingactid
874: from dual;
875:
876: -- insert the action record.
877: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
878:
971: close c_state_ueid;
972:
973: hr_utility.set_location(l_procedure_name, 170);
974: c_actions_with_state_sql := c_actions_with_state_sql ||
975: ' AND exists ( select 1 from dual
976: where 1 =
977: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
978: from ff_archive_items fai,
979: ff_archive_item_contexts fic1,
1003: fetch c_state_ueid into l_county_wheld;
1004: close c_state_ueid;
1005:
1006: c_actions_with_state_sql := c_actions_with_state_sql ||
1007: ' AND exists ( select 1 from dual
1008: where 1 =
1009: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1010: from ff_archive_items fai,
1011: ff_archive_item_contexts fic1,
1027: fetch c_state_ueid into l_subj_nwhable;
1028: close c_state_ueid;
1029:
1030: c_actions_with_state_sql := c_actions_with_state_sql ||
1031: ' AND exists ( select 1 from dual
1032: where 1 =
1033: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1034: from ff_archive_items fai,
1035: ff_archive_item_contexts fic1,
1062: close c_state_ueid;
1063:
1064: hr_utility.set_location(l_procedure_name, 170);
1065: c_actions_with_state_sql := c_actions_with_state_sql ||
1066: ' AND exists ( select 1 from dual
1067: where 1 =
1068: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1069: from ff_archive_items fai,
1070: ff_archive_item_contexts fic1,
1086: fetch c_state_ueid into l_subj_nwhable;
1087: close c_state_ueid;
1088:
1089: c_actions_with_state_sql := c_actions_with_state_sql ||
1090: ' AND exists ( select 1 from dual
1091: where 1 =
1092: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1093: from ff_archive_items fai,
1094: ff_archive_item_contexts fic1,
1117: fetch c_state_ueid into l_school_wheld;
1118: close c_state_ueid;
1119:
1120: c_actions_with_state_sql := c_actions_with_state_sql ||
1121: ' AND exists ( select 1 from dual
1122: where 1 =
1123: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1124: from ff_archive_items fai,
1125: ff_archive_item_contexts fic1,
1141: fetch c_state_ueid into l_subj_nwhable;
1142: close c_state_ueid;
1143:
1144: c_actions_with_state_sql := c_actions_with_state_sql ||
1145: ' AND exists ( select 1 from dual
1146: where 1 =
1147: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1148: from ff_archive_items fai,
1149: ff_archive_item_contexts fic1,
1187: hr_utility.trace('Before inserting the action record');
1188:
1189: select pay_assignment_actions_s.nextval
1190: into lockingactid
1191: from dual;
1192:
1193: -- insert the action record.
1194: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
1195:
1304: hr_utility.set_location('procpyr',3);
1305:
1306: select pay_assignment_actions_s.nextval
1307: into lockingactid
1308: from dual;
1309:
1310: -- insert the action record.
1311: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
1312:
1398: and paf2.effective_start_date <= p_session_date)
1399: AND paf.effective_end_date >= p_eoy_start_date
1400: AND paf.assignment_type = 'E'
1401: AND paf.person_id between stperson and endperson
1402: AND exists ( select 1 from dual
1403: where 1 =
1404: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1405: from ff_archive_items fai,
1406: ff_archive_item_contexts fic1,
1521: and paf.person_id = to_number(paa_arch.serial_number)
1522: AND ppr.payroll_action_id = ' || pactid || '
1523: AND ppr.chunk_number = ' || chunk || '
1524: AND paf.person_id = ppr.person_id
1525: AND exists ( select 1 from dual
1526: where 1 =
1527: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1528: from ff_archive_items fai,
1529: ff_archive_item_contexts fic1,
1576: AND paf.assignment_type = ''E''
1577: /* and paf.primary_flag = ''Y'' */
1578: AND paf.person_id between ' || stperson || ' and ' || endperson || '
1579: and paf.person_id = to_number(paa_arch.serial_number)
1580: AND exists ( select 1 from dual
1581: where 1 =
1582: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1583: from ff_archive_items fai,
1584: ff_archive_item_contexts fic1,
1630: hr_utility.set_location('procpyr',3);
1631:
1632: select pay_assignment_actions_s.nextval
1633: into lockingactid
1634: from dual;
1635:
1636: -- insert the action record.
1637: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
1638:
1676: --AND paf.person_id between stperson and endperson
1677: AND ppr.payroll_action_id = ' || pactid || '
1678: AND ppr.chunk_number = ' || chunk || '
1679: AND paf.person_id = ppr.person_id
1680: AND exists ( select 1 from dual
1681: where 1 =
1682: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1683: from ff_archive_items fai,
1684: ff_archive_item_contexts fic1,
1715: and paf2.effective_start_date <= ''' || p_session_date || ''')
1716: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
1717: AND paf.assignment_type = ''E''
1718: AND paf.person_id between ' || stperson || ' and ' || endperson || '
1719: AND exists ( select 1 from dual
1720: where 1 =
1721: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1722: from ff_archive_items fai,
1723: ff_archive_item_contexts fic1,
1771: hr_utility.set_location('procpyr',3);
1772:
1773: select pay_assignment_actions_s.nextval
1774: into lockingactid
1775: from dual;
1776:
1777: -- insert the action record.
1778: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
1779:
1818: --AND paf.person_id between stperson and endperson
1819: AND ppr.payroll_action_id = ' || pactid || '
1820: AND ppr.chunk_number = ' || chunk || '
1821: AND paf.person_id = ppr.person_id
1822: AND exists ( select 1 from dual
1823: where 1 =
1824: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1825: from ff_archive_items fai,
1826: ff_archive_item_contexts fic1,
1857: and paf2.effective_start_date <= ''' || p_session_date || ''')
1858: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
1859: AND paf.assignment_type = ''E''
1860: AND paf.person_id between ' || stperson || ' and ' || endperson || '
1861: AND exists ( select 1 from dual
1862: where 1 =
1863: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1864: from ff_archive_items fai,
1865: ff_archive_item_contexts fic1,
1911: hr_utility.set_location('procpyr',3);
1912:
1913: select pay_assignment_actions_s.nextval
1914: into lockingactid
1915: from dual;
1916:
1917: -- insert the action record.
1918: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
1919:
1951: and paf2.effective_start_date <= ''' || p_session_date || ''')
1952: AND paf.effective_end_date >= ''' || p_eoy_start_date || '''
1953: AND paf.assignment_type = ''E''
1954: AND paf.person_id between ' || stperson || ' and ' || endperson ||'
1955: AND exists ( select 1 from dual
1956: where 1 =
1957: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
1958: from ff_archive_items fai,
1959: ff_archive_item_contexts fic1,
2005: hr_utility.set_location('procpyr',3);
2006:
2007: select pay_assignment_actions_s.nextval
2008: into lockingactid
2009: from dual;
2010:
2011: -- insert the action record.
2012: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
2013:
2053: from hr_assignment_set_amendments hasa
2054: where hasa.assignment_set_id = ' || p_asg_set_id || '
2055: and hasa.assignment_id = paa_arch.assignment_id
2056: and upper(hasa.include_or_exclude) = ''I'')
2057: AND exists ( select 1 from dual
2058: where 1 =
2059: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
2060: from ff_archive_items fai,
2061: ff_archive_item_contexts fic1,
2094: from hr_assignment_set_amendments hasa
2095: where hasa.assignment_set_id = ' || p_asg_set_id || '
2096: and hasa.assignment_id = paa_arch.assignment_id
2097: and upper(hasa.include_or_exclude) = ''I'')
2098: AND exists ( select 1 from dual
2099: where 1 =
2100: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
2101: from ff_archive_items fai,
2102: ff_archive_item_contexts fic1,
2147: hr_utility.set_location('procpyr',3);
2148:
2149: select pay_assignment_actions_s.nextval
2150: into lockingactid
2151: from dual;
2152:
2153: -- insert the action record.
2154: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
2155:
2361: /* changed this with the if statement below
2362: begin
2363: select to_date('31-DEC-'||to_char(l_year),'DD/MM/YYYY')
2364: into l_dt
2365: from dual
2366: where to_date('31-DEC-'||to_char(l_year),'DD/MM/YYYY') > l_dt;
2367: exception
2368: when others then null;
2369: end;