[Home] [Help]
371: END IF;
372: EXCEPTION
373: WHEN OTHERS THEN
374: -- Return cursor that selects no rows
375: p_sql := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
376: END RANGE_CODE;
377: /* ASSIGNMENT ACTION CODE */
378: PROCEDURE ASSIGNMENT_ACTION_CODE
379: (p_payroll_action_id IN NUMBER
488: ,l_canonical_end_date) LOOP
489: IF l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id THEN
490: SELECT pay_assignment_actions_s.NEXTVAL
491: INTO l_actid
492: FROM dual;
493: --
494: g_index_assact := g_index_assact + 1;
495: g_lock_table(g_index_assact).archive_assact_id := l_actid; /* For Element archival */
496: -- Create the archive assignment action
1905: -- Case for Group by or NOT
1906: -- Segemnt 6 is allowed here, as it makes sense.
1907: IF ( rec_group_by.ORG_INFORMATION6 = 'N' or (rec_group_by.ORG_INFORMATION3 IS NULL) )
1908: THEN
1909: -- This csae iis for individual representation of each element.
1910: -- unit and unit price should be absent.
1911: FOR csr_result_rec IN csr_result_value(g_element_table(l_index).input_value_id
1912: ,g_element_table(l_index).element_type_id
1913: ,p_assignment_action_id)
3095: -- Case for Group by or NOT
3096: -- Segemnt 6 is allowed here, as it makes sense.
3097: IF ( rec_group_by.ORG_INFORMATION6 = 'N' or (rec_group_by.ORG_INFORMATION3 IS NULL) )
3098: THEN
3099: -- This csae iis for individual representation of each element.
3100: -- unit and unit price should be absent.
3101: FOR csr_result_rec IN csr_result_value(csr_rec.input_value_id ,csr_rec.element_type_id ,p_assignment_action_id)
3102: LOOP
3103: IF csr_result_rec.result_value is not null THEN
3454: -- Segemnt 6 is allowed here, as it makes sense.
3455: --fnd_file.put_line(fnd_file.log,'Vetri 2: ' || 'In ARCHIVE_MAIN_ELEMENTS'||rec_group_by.ORG_INFORMATION3);
3456: IF ( rec_group_by.ORG_INFORMATION6 = 'N' or (rec_group_by.ORG_INFORMATION3 IS NULL) )
3457: THEN
3458: -- This csae iis for individual representation of each element.
3459: -- unit and unit price should be absent.
3460: --fnd_file.put_line(fnd_file.log,'Vetri 3: ' || 'In ARCHIVE_MAIN_ELEMENTS'||rec_group_by.ORG_INFORMATION3);
3461: FOR csr_result_rec IN csr_result_value(csr_rec.input_value_id ,csr_rec.element_type_id ,p_assignment_action_id)
3462: LOOP