168: := g_package
169: || ' GET_ALL_PARAMETERS ';
170: --
171: BEGIN
172: fnd_file.put_line (
173: fnd_file.LOG,
174: 'Entering Procedure GET_ALL_PARAMETER '
175: );
176: fnd_file.put_line (
169: || ' GET_ALL_PARAMETERS ';
170: --
171: BEGIN
172: fnd_file.put_line (
173: fnd_file.LOG,
174: 'Entering Procedure GET_ALL_PARAMETER '
175: );
176: fnd_file.put_line (
177: fnd_file.LOG,
172: fnd_file.put_line (
173: fnd_file.LOG,
174: 'Entering Procedure GET_ALL_PARAMETER '
175: );
176: fnd_file.put_line (
177: fnd_file.LOG,
178: 'Payroill Action iD '
179: || p_RUN_payroll_action_id
180: );
173: fnd_file.LOG,
174: 'Entering Procedure GET_ALL_PARAMETER '
175: );
176: fnd_file.put_line (
177: fnd_file.LOG,
178: 'Payroill Action iD '
179: || p_RUN_payroll_action_id
180: );
181: OPEN csr_parameter_info (p_payroll_action_id);
186: p_start_date,
187: p_effective_date,
188: p_business_group_id;
189: CLOSE csr_parameter_info;
190: fnd_file.put_line (fnd_file.LOG, 'After csr_parameter_info in ');
191: fnd_file.put_line (fnd_file.LOG, 'archive='
192: || p_archive);
193:
194: IF g_debug
187: p_effective_date,
188: p_business_group_id;
189: CLOSE csr_parameter_info;
190: fnd_file.put_line (fnd_file.LOG, 'After csr_parameter_info in ');
191: fnd_file.put_line (fnd_file.LOG, 'archive='
192: || p_archive);
193:
194: IF g_debug
195: THEN
262: THEN
263: hr_utility.set_location (' Entering Procedure RANGE_CODE', 40);
264: END IF;
265:
266: fnd_file.put_line (fnd_file.LOG, 'Entering Procedure RANGE_CODE 7');
267: p_sql :=
268: 'SELECT DISTINCT person_id
269: FROM per_people_f ppf
270: ,pay_payroll_actions ppa
439: g_run_payroll_action_id,
440: g_archive
441: );
442:
443: fnd_file.put_line (fnd_file.LOG, ' ');
444: fnd_file.put_line (
445: fnd_file.LOG,
446: 'Parameter P_Start_person '
447: || p_start_person
440: g_archive
441: );
442:
443: fnd_file.put_line (fnd_file.LOG, ' ');
444: fnd_file.put_line (
445: fnd_file.LOG,
446: 'Parameter P_Start_person '
447: || p_start_person
448: );
441: );
442:
443: fnd_file.put_line (fnd_file.LOG, ' ');
444: fnd_file.put_line (
445: fnd_file.LOG,
446: 'Parameter P_Start_person '
447: || p_start_person
448: );
449: fnd_file.put_line (
445: fnd_file.LOG,
446: 'Parameter P_Start_person '
447: || p_start_person
448: );
449: fnd_file.put_line (
450: fnd_file.LOG,
451: 'Paramter P_end_personn '
452: || p_end_person
453: );
446: 'Parameter P_Start_person '
447: || p_start_person
448: );
449: fnd_file.put_line (
450: fnd_file.LOG,
451: 'Paramter P_end_personn '
452: || p_end_person
453: );
454: fnd_file.put_line (
450: fnd_file.LOG,
451: 'Paramter P_end_personn '
452: || p_end_person
453: );
454: fnd_file.put_line (
455: fnd_file.LOG,
456: 'Paramter P_end_personn '
457: || p_end_person
458: );
451: 'Paramter P_end_personn '
452: || p_end_person
453: );
454: fnd_file.put_line (
455: fnd_file.LOG,
456: 'Paramter P_end_personn '
457: || p_end_person
458: );
459: fnd_file.put_line (
455: fnd_file.LOG,
456: 'Paramter P_end_personn '
457: || p_end_person
458: );
459: fnd_file.put_line (
460: fnd_file.LOG,
461: 'Paramter P_end_personn '
462: || p_end_person
463: );
456: 'Paramter P_end_personn '
457: || p_end_person
458: );
459: fnd_file.put_line (
460: fnd_file.LOG,
461: 'Paramter P_end_personn '
462: || p_end_person
463: );
464: fnd_file.put_line (
460: fnd_file.LOG,
461: 'Paramter P_end_personn '
462: || p_end_person
463: );
464: fnd_file.put_line (
465: fnd_file.LOG,
466: 'g_run_payroll_action_id'
467: || g_run_payroll_action_id
468: );
461: 'Paramter P_end_personn '
462: || p_end_person
463: );
464: fnd_file.put_line (
465: fnd_file.LOG,
466: 'g_run_payroll_action_id'
467: || g_run_payroll_action_id
468: );
469:
471: THEN
472: l_prepay_action_id := 0;
473:
474: l_assignment := 0;
475: fnd_file.put_line (fnd_file.LOG, ' Before the Locking Cursor ');
476:
477: -- this is for all the person's assignment actionid under the selected legal employer
478: FOR rec_prepaid_assignments IN
479: csr_prepaid_assignments (
483: g_run_payroll_action_id,
484: g_business_group_id
485: )
486: LOOP
487: fnd_file.put_line (
488: fnd_file.LOG,
489: ' Inside the Csr Prepaid Cursor '
490: );
491:
484: g_business_group_id
485: )
486: LOOP
487: fnd_file.put_line (
488: fnd_file.LOG,
489: ' Inside the Csr Prepaid Cursor '
490: );
491:
492:
504: + 1;
505: g_lock_table (g_index_assact).archive_assact_id := l_actid;
506: /* For Element archival */
507: -- Create the archive assignment action
508: fnd_file.put_line (
509: fnd_file.LOG,
510: 'l_actid'
511: || l_actid
512: || ' rec_prepaid_assignments.assignment_id'
505: g_lock_table (g_index_assact).archive_assact_id := l_actid;
506: /* For Element archival */
507: -- Create the archive assignment action
508: fnd_file.put_line (
509: fnd_file.LOG,
510: 'l_actid'
511: || l_actid
512: || ' rec_prepaid_assignments.assignment_id'
513: || rec_prepaid_assignments.assignment_id
533: l_assignment := rec_prepaid_assignments.assignment_id;
534: END LOOP;
535: END IF; --ARCHIVE
536:
537: fnd_file.put_line (
538: fnd_file.LOG,
539: ' After Ending Assignment Act Code the Locking Cursor '
540: );
541:
534: END LOOP;
535: END IF; --ARCHIVE
536:
537: fnd_file.put_line (
538: fnd_file.LOG,
539: ' After Ending Assignment Act Code the Locking Cursor '
540: );
541:
542: IF g_debug
559: 80
560: );
561: END IF;
562:
563: fnd_file.put_line (fnd_file.LOG, 'In INIT_CODE 0');
564:
565: IF g_debug
566: THEN
567: hr_utility.set_location (
684:
685: --
686: --
687: --
688: fnd_file.put_line (fnd_file.LOG, 'Entering ARCHIVE_CODE ');
689: OPEN csr_person_details (g_business_group_id);
690: FETCH csr_person_details INTO lr_person_details;
691: CLOSE csr_person_details;
692: -- l_employee_pin := lr_person_details.national_identifier;
706: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
707: CLOSE csr_Get_Defined_Balance_Id;
708:
709: l_benefits :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>lr_person_details.assignment_id , P_VIRTUAL_DATE => g_pay_period_end_date );
710: fnd_file.put_line (
711: fnd_file.LOG,
712: ' l_benefits'||l_benefits
713:
714: );
707: CLOSE csr_Get_Defined_Balance_Id;
708:
709: l_benefits :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>lr_person_details.assignment_id , P_VIRTUAL_DATE => g_pay_period_end_date );
710: fnd_file.put_line (
711: fnd_file.LOG,
712: ' l_benefits'||l_benefits
713:
714: );
715:
872: OPEN csr_get_run_ass_action_id (p_assignment_action_id);
873: FETCH csr_get_run_ass_action_id INTO lr_get_run_ass_action_id ;
874: CLOSE csr_get_run_ass_action_id ;
875:
876: fnd_file.put_line ( fnd_file.LOG,
877: 'p_balance_name'
878: || p_balance_name
879: );
880: fnd_file.put_line ( fnd_file.LOG,
876: fnd_file.put_line ( fnd_file.LOG,
877: 'p_balance_name'
878: || p_balance_name
879: );
880: fnd_file.put_line ( fnd_file.LOG,
881: 'lr_get_defined_balance_id '
882: || lr_get_defined_balance_id
883: );
884: fnd_file.put_line ( fnd_file.LOG,
880: fnd_file.put_line ( fnd_file.LOG,
881: 'lr_get_defined_balance_id '
882: || lr_get_defined_balance_id
883: );
884: fnd_file.put_line ( fnd_file.LOG,
885: 'p_assignment_action_id '
886: || p_assignment_action_id
887: );
888: fnd_file.put_line ( fnd_file.LOG,
884: fnd_file.put_line ( fnd_file.LOG,
885: 'p_assignment_action_id '
886: || p_assignment_action_id
887: );
888: fnd_file.put_line ( fnd_file.LOG,
889: 'lr_get_run_ass_action_id'
890: || lr_get_run_ass_action_id
891: );
892: