[Home] [Help]
549: -- This procedure gets the parameters given by user and restricts
550: -- the assignments to be archived.
551: -- it then calls hr_nonrun.insact to create an assignment action id
552: -- it then archives Payroll Run assignment action id details
553: -- in pay_Action_information with context 'AU_ARCHIVE_ASG_DETAILS'
554: -- for each assignment.
555: -- There are 10 different cursors for choosing the assignment ids.
556: -- Depending on the parameters passed,the appropriate cursor is used.
557: --------------------------------------------------------------------+
724:
725: -- Create the archive assignment actions
726: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
727:
728: insert into pay_action_information(
729: action_information_id,
730: action_context_id,
731: action_context_type,
732: effective_date,
738: action_information3,
739: assignment_id
740: )
741: values(
742: pay_action_information_s.nextval,
743: l_next_assignment_action_id,
744: 'AAP',
745: null,
746: null,
865:
866: cursor csr_get_data (c_arc_ass_act_id number)
867: is
868: select pai.action_information1, pai.action_information2, pai.tax_unit_id, pai.assignment_id,pai.action_information3
869: from pay_action_information pai
870: where action_information_category = 'AU_ARCHIVE_ASG_DETAILS'
871: and pai.action_context_id = c_arc_ass_act_id;
872:
873:
1023: P_OTHER_TAXABLE_INCOME => l_OTHER_TAXABLE_INCOME,
1024: P_TAXABLE_INCOME => l_TAXABLE_INCOME);
1025:
1026: hr_utility.set_location('in BBR loop', 300);
1027: insert into pay_action_information(
1028: action_information_id,
1029: action_context_id,
1030: action_context_type,
1031: effective_date,
1042: action_information7,
1043: action_information8,
1044: action_information9)
1045: values(
1046: pay_action_information_s.nextval,
1047: g_arc_payroll_action_id,
1048: 'PA',
1049: p_effective_date,
1050: null,
1064:
1065:
1066:
1067: --
1068: -- Insert the balance data into pay_action_information table
1069: -- This Direct Insert statement is for Performance Reasons.
1070: --
1071: insert into pay_action_information (
1072: action_information_id,
1067: --
1068: -- Insert the balance data into pay_action_information table
1069: -- This Direct Insert statement is for Performance Reasons.
1070: --
1071: insert into pay_action_information (
1072: action_information_id,
1073: action_context_id,
1074: action_context_type,
1075: effective_date,
1092: action_information13,
1093: action_information14,
1094: action_information15) /* 4731692 */
1095: values (
1096: pay_action_information_s.nextval,
1097: p_assignment_action_id,
1098: 'AAP',
1099: p_effective_date,
1100: null,