[Home] [Help]
1734: hr_utility.set_location(' Leaving: '||l_proc,50);
1735: fnd_file.put_line(fnd_file.log,
1736: substr('Error in rangecode '||sqlerrm(sqlcode),1,80));
1737: -- Return cursor that selects no rows
1738: sqlstr := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
1739: END range_cursor;
1740: --
1741: --
1742: PROCEDURE action_creation(pactid IN NUMBER,
2180: hr_utility.set_location(l_proc,20);
2181: -- insert an action
2182: SELECT pay_assignment_actions_s.nextval
2183: INTO l_actid
2184: FROM dual;
2185: --
2186: hr_nonrun_asact.insact(l_actid,rec_assignment.assignment_id,
2187: pactid,chunk,NULL);
2188: -- archive the effective end date
3455: AND per.effective_end_date;
3456: --
3457: cursor csr_director(p_person_id NUMBER) IS
3458: SELECT 'D'
3459: FROM dual
3460: WHERE EXISTS (SELECT '1'
3461: FROM per_all_people_f per
3462: WHERE p_person_id = per.person_id
3463: AND per.effective_start_date <= g_end_year
3950: p_reportable NUMBER,
3951: p_ni_cat VARCHAR2,
3952: p_scon VARCHAR2 DEFAULT NULL,
3953: p_actid NUMBER DEFAULT NULL) IS
3954: -- Procedure used to archive an individual NI balance value for a given
3955: -- NI Category and (where necessary) SCON.
3956: --
3957: -- The p_reportable parameter indicates that the value is reportable ie.
3958: -- to be included in the P35 tape submission. This is necessary for
4143: p_ees_rebate NUMBER DEFAULT NULL,
4144: p_scon VARCHAR2 DEFAULT NULL) IS
4145: -- Procedure used to archive a 'row' of balance values for a given
4146: -- NI Category and (where necessary) SCON.
4147: -- It archives the values individually by calling archive_ni_value.
4148: --
4149: -- This procedure performs NI Multiple Assignment Logic (Pt. II)
4150: -- which will archive a reportable set of values if the asg is a single asg.
4151: -- If the the asg is a multi-asg, a non-reportable set of values will be
6383: to_date('31/12/4712','DD/MM/YYYY'),
6384: p_archive_type,
6385: 'N',
6386: NULL
6387: FROM sys.dual WHERE NOT EXISTS
6388: (SELECT 1 FROM pay_report_format_items_f
6389: WHERE report_type = 'EOY'
6390: AND report_qualifier = 'GB'
6391: AND user_entity_id = l_user_entity_id
6412: to_date('31/12/4712','DD/MM/YYYY'),
6413: p_archive_type,
6414: 'N',
6415: NULL
6416: FROM sys.dual WHERE NOT EXISTS
6417: (SELECT 1 FROM pay_report_format_items_f
6418: WHERE report_type = 'EOY'
6419: AND report_qualifier = 'GB'
6420: AND user_entity_id = l_user_entity_id