[Home] [Help]
343: FOR i IN c_assact(l_old_pact_id,l_prn_app_opt) LOOP
344: -- Added NVL to overcome NULL issue.
345: IF (NVL(l_ass_set_id,0) = 0) THEN
346: -- NO assignment set passed as parameter
347: SELECT pay_assignment_actions_s.nextval INTO l_assact FROM dual;
348: hr_nonrun_asact.insact(l_assact,
349: i.assignment_id ,
350: p_payroll_action_id,
351: p_chunk,
361: IF (g_all_exclusions_flag = 0) THEN
362: -- assignment set by ammmendment passed is not all exclusions.
363: l_result1 := get_amendment_flag(i.assignment_id, l_ass_set_id);
364: IF (l_result1 = 'I') THEN
365: SELECT pay_assignment_actions_s.nextval INTO l_assact FROM dual;
366: hr_nonrun_asact.insact(l_assact,
367: i.assignment_id ,
368: p_payroll_action_id,
369: p_chunk,
373: ELSE
374: -- assignment set by ammmendment passed is all exclusions.
375: l_result1 := get_amendment_flag(i.assignment_id, l_ass_set_id);
376: IF (l_result1 <> 'E') THEN
377: SELECT pay_assignment_actions_s.nextval INTO l_assact FROM dual;
378: hr_nonrun_asact.insact(l_assact,
379: i.assignment_id ,
380: p_payroll_action_id,
381: p_chunk,
387: ELSE
388: -- assignment set by criteria passed
389: l_result2 := chk_ass_set(i.assignment_id, l_ass_set_id, l_formula_id, i.effective_date, g_dummy);
390: IF (l_result2 = TRUE) THEN
391: SELECT pay_assignment_actions_s.nextval into l_assact from dual;
392: hr_nonrun_asact.insact(l_assact,
393: i.assignment_id ,
394: p_payroll_action_id,
395: p_chunk,
1070: IF (ins_company_name_lp.count >= d) THEN
1071: --
1072: select to_char(ins_period_start_date_lp(d),'EEYYMMDD"','NLS_CALENDAR=''Japanese Imperial''')
1073: into ps_date
1074: from dual;
1075: --
1076: -- ps_date_length := length(ins_period_start_date_lp(d));
1077: ps_date_length := length(ps_date);
1078: --
1105: IF (ins_company_name_lp.count >= e) THEN
1106: --
1107: select to_char(ins_period_start_date_lp(e),'EEYYMMDD"','NLS_CALENDAR=''Japanese Imperial''')
1108: into ps_date
1109: from dual;
1110: --
1111: ps_date_length := length(ps_date);
1112: --
1113: l_xml := l_xml||'