eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_RTI_FPS_ARCHIVE dependencies on HR_NONRUN_ASACT

Line 7557: hr_nonrun_asact.insact ( lockingactid, asg_record.assignment_id, pactid, chunk, NULL );

7553:
7554: if l_flag = 'Y' and l_first_fps_prepay_asg = 'N' Then
7555: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
7556: -- Insert assignment into pay_assignment_actions
7557: hr_nonrun_asact.insact ( lockingactid, asg_record.assignment_id, pactid, chunk, NULL );
7558: End if;
7559:
7560: END LOOP;
7561: end if; -- First FPS logic ends

Line 7614: hr_nonrun_asact.insact ( lockingactid, asg_rec.assignment_id, pactid, chunk, NULL );

7610: if ((asg_rec.asg_act_id = l_aggr_min_act_id) and (l_earlier_processed = 0)) then
7611: hr_utility.set_location('Creating Assignment Action for assignment_id '||asg_rec.assignment_id, 50);
7612:
7613: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
7614: hr_nonrun_asact.insact ( lockingactid, asg_rec.assignment_id, pactid, chunk, NULL );
7615: -- get the assigment action id of the prepayment payroll action id for the current assignment.
7616: OPEN csr_prepay_asg_act_details(asg_rec.assignment_id, l_pre_pact_id);
7617: FETCH csr_prepay_asg_act_details
7618: INTO l_prepay_asg_action_id,

Line 7624: hr_nonrun_asact.insint(lockingactid, l_prepay_asg_action_id);

7620: l_prepay_effective_date;
7621: CLOSE csr_prepay_asg_act_details;
7622:
7623: -- apply lock
7624: hr_nonrun_asact.insint(lockingactid, l_prepay_asg_action_id);
7625:
7626: hr_utility.set_location('Creating other Assignment Action ids for assignment_id '||asg_rec.assignment_id, 50);
7627:
7628: /*for c_asg in csr_get_other_asg(asg_rec.assignment_id)

Line 7632: hr_nonrun_asact.insact(lockingactid, c_asg.asg_id, pactid, chunk, NULL );

7628: /*for c_asg in csr_get_other_asg(asg_rec.assignment_id)
7629: loop*/
7630: /* SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
7631: hr_utility.set_location('Creating action for asg '||c_asg.asg_id, 50);
7632: hr_nonrun_asact.insact(lockingactid, c_asg.asg_id, pactid, chunk, NULL );
7633: hr_utility.set_location('Created action for asg '||c_asg.asg_id, 50);*/
7634:
7635: hr_utility.set_location('l_person_id:'||l_person_id || ' asg_rec.assignment_id:' ||
7636: asg_rec.assignment_id || ' g_start_year: ' || g_start_year ,50);

Line 7648: hr_nonrun_asact.insact(lockingactid, l_asg_id, pactid, chunk, NULL );

7644:
7645: EXIT WHEN csr_agg_all_asg_act_creat%NOTFOUND;
7646: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
7647: hr_utility.set_location('Creating action for asg '||l_asg_id, 50);
7648: hr_nonrun_asact.insact(lockingactid, l_asg_id, pactid, chunk, NULL );
7649: hr_utility.set_location('Created action for asg '||l_asg_id, 50);
7650:
7651: -- new changes
7652: open csr_agg_all_actions_lock(l_person_id, l_asg_id, g_start_year, g_end_year);

Line 7666: hr_nonrun_asact.insint(lockingactid, l_pre_pay_asg_action_id);

7662: -- Apply lock
7663:
7664: hr_utility.set_location('lockingactid '||lockingactid, 50);
7665: hr_utility.set_location('l_pre_pay_asg_action_id '||l_pre_pay_asg_action_id, 50);
7666: hr_nonrun_asact.insint(lockingactid, l_pre_pay_asg_action_id);
7667:
7668: end loop;
7669: close csr_agg_all_actions_lock;
7670: end loop;

Line 7677: -- hr_nonrun_asact.insint(lockingactid, l_cur_asg_pre_pay_act_id);

7673: /*open chk_processed_in_prepay(l_cur_asg_action_id);
7674: fetch chk_processed_in_prepay into l_cur_asg_pre_pay_act_id;
7675: close chk_processed_in_prepay;*/
7676: -- lock
7677: -- hr_nonrun_asact.insint(lockingactid, l_cur_asg_pre_pay_act_id);
7678:
7679: /*end loop;*/
7680:
7681: -- end get the other assigment ids for this person.

Line 7694: hr_nonrun_asact.insact ( lockingactid, asg_rec.assignment_id, pactid, chunk, NULL );

7690: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);
7691: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
7692:
7693: -- Insert assignment into pay_assignment_actions
7694: hr_nonrun_asact.insact ( lockingactid, asg_rec.assignment_id, pactid, chunk, NULL );
7695: -- get the assigment action id of the prepayment payroll action id for the current assignment.
7696: OPEN csr_prepay_asg_act_details(asg_rec.assignment_id, l_pre_pact_id);
7697: FETCH csr_prepay_asg_act_details
7698: INTO l_prepay_asg_action_id,

Line 7702: hr_nonrun_asact.insint(lockingactid, l_prepay_asg_action_id);

7698: INTO l_prepay_asg_action_id,
7699: l_prepay_payroll_action_id,
7700: l_prepay_effective_date;
7701: --apply the lock
7702: hr_nonrun_asact.insint(lockingactid, l_prepay_asg_action_id);
7703: CLOSE csr_prepay_asg_act_details;
7704: if l_ni_agg_flag = 'Y' then
7705: hr_utility.set_location('This is NI aggregation case ', 50);
7706: -- Get the RTI NI Reporting asg and effective date.

Line 7737: hr_nonrun_asact.insact ( lockingactid, l_ni_rpt_asg_id, pactid, chunk, NULL );

7733:
7734: if nvl(l_rti_ni_proc_flag,'N') <> 'Y' and asg_rec.asg_act_id = l_ni_aggr_max_act_id then
7735: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
7736: -- Insert assignment into pay_assignment_actions
7737: hr_nonrun_asact.insact ( lockingactid, l_ni_rpt_asg_id, pactid, chunk, NULL );
7738: /* -- get the assigment action id of the prepayment payroll action id for the current assignment.
7739: OPEN csr_ni_prepay_asg_act_details(asg_rec.asg_act_id);
7740: FETCH csr_ni_prepay_asg_act_details
7741: INTO l_ni_prepay_asg_action_id;

Line 7748: hr_nonrun_asact.insint(lockingactid, l_ni_prepay_asg_action_id);

7744: --apply the lock
7745: if l_ni_prepay_asg_action_id is not null then
7746: hr_utility.trace('lockingactid: '||lockingactid);
7747: hr_utility.trace('l_ni_prepay_asg_action_id: '|| l_ni_prepay_asg_action_id);
7748: hr_nonrun_asact.insint(lockingactid, l_ni_prepay_asg_action_id);
7749: else
7750: hr_utility.trace('No prepayment for asg_id : '|| );
7751: */
7752: end if;

Line 10831: hr_nonrun_asact.insint(p_assactid, l_prepay_asg_action_id);

10827:
10828: /* Moved this code to Action creation
10829: -- lock the pre payments action id with current fps assignment action id
10830: begin
10831: hr_nonrun_asact.insint(p_assactid, l_prepay_asg_action_id);
10832: exception
10833: when dup_val_on_index then
10834: hr_utility.set_location(sqlcode || '-' || sqlerrm,60);
10835: hr_utility.set_location('Skip locking for retry.Locking action id-'||p_assactid || ' Locked action id-' || l_prepay_asg_action_id,60);

Line 11281: hr_nonrun_asact.insint(p_assactid, l_cur_asg_pre_pay_act_id);

11277: l_archive_tab_det2(l_archive_det2_counter).act_info30 := l_report_det1_det2_flag;
11278:
11279: /* -- lock the pre payments action id with current fps assignment action id
11280: begin
11281: hr_nonrun_asact.insint(p_assactid, l_cur_asg_pre_pay_act_id);
11282: exception
11283: when dup_val_on_index then
11284: hr_utility.set_location(sqlcode || '-' || sqlerrm,60);
11285: hr_utility.set_location('Skip locking for retry.Locking action id-'||p_assactid || ' Locked action id-' || l_cur_asg_pre_pay_act_id,60);

Line 11711: hr_nonrun_asact.insint(p_assactid, l_cur_asg_pre_pay_act_id);

11707: l_archive_tab_det2(l_archive_det2_counter).act_info30 := l_report_det1_det2_flag;
11708:
11709: /* -- lock the pre payments action id with current fps assignment action id
11710: begin
11711: hr_nonrun_asact.insint(p_assactid, l_cur_asg_pre_pay_act_id);
11712: exception
11713: when dup_val_on_index then
11714: hr_utility.set_location(sqlcode || '-' || sqlerrm,60);
11715: hr_utility.set_location('Skip locking for retry.Locking action id-'||p_assactid || ' Locked action id-' || l_cur_asg_pre_pay_act_id,60);

Line 12136: hr_nonrun_asact.insint(p_assactid, l_prepay_asg_action_id);

12132: insert_archive_row_agg(p_assactid, p_effective_date,l_archive_tab_ni_det);
12133: insert_archive_row_agg(p_assactid, p_effective_date,l_archive_tab_ni_det_1);
12134: /* -- lock the pre payments action id with current fps assignment action id
12135: begin
12136: hr_nonrun_asact.insint(p_assactid, l_prepay_asg_action_id);
12137: exception
12138: when dup_val_on_index then
12139: hr_utility.set_location(sqlcode || '-' || sqlerrm,60);
12140: hr_utility.set_location('Skip locking for retry.Locking action id-'||p_assactid || ' Locked action id-' || l_prepay_asg_action_id,60);

Line 12744: hr_nonrun_asact.insint(p_assactid, l_prepay_asg_action_id);

12740: insert_archive_row_agg(p_assactid, p_effective_date,l_archive_tab_det3);
12741: /* moved this code to action creation
12742: -- lock the pre payments action id with current fps assignment action id
12743: begin
12744: hr_nonrun_asact.insint(p_assactid, l_prepay_asg_action_id);
12745: exception
12746: when dup_val_on_index then
12747: hr_utility.set_location(sqlcode || '-' || sqlerrm,60);
12748: hr_utility.set_location('Skip locking for retry.Locking action id-'||p_assactid || ' Locked action id-' || l_prepay_asg_action_id,60);