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 dependencies on HR_NONRUN_ASACT

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

6886:
6887: if l_flag = 'Y' and l_first_fps_prepay_asg = 'N' Then
6888: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
6889: -- Insert assignment into pay_assignment_actions
6890: hr_nonrun_asact.insact ( lockingactid, asg_record.assignment_id, pactid, chunk, NULL );
6891: End if;
6892:
6893: END LOOP;
6894: end if; -- First FPS logic ends

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

6978: if ((asg_rec.asg_act_id = l_aggr_min_act_id) and (l_earlier_processed = 0)) then
6979: hr_utility.set_location('Creating Assignment Action for assignment_id '||asg_rec.assignment_id, 50);
6980:
6981: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
6982: hr_nonrun_asact.insact ( lockingactid, asg_rec.assignment_id, pactid, chunk, NULL );
6983: -- get the assigment action id of the prepayment payroll action id for the current assignment.
6984: OPEN csr_prepay_asg_act_details(asg_rec.assignment_id, l_pre_pact_id);
6985: FETCH csr_prepay_asg_act_details
6986: INTO l_prepay_asg_action_id,

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

6988: l_prepay_effective_date;
6989: CLOSE csr_prepay_asg_act_details;
6990:
6991: -- apply lock
6992: hr_nonrun_asact.insint(lockingactid, l_prepay_asg_action_id);
6993:
6994: hr_utility.set_location('Creating other Assignment Action ids for assignment_id '||asg_rec.assignment_id, 50);
6995:
6996: /*for c_asg in csr_get_other_asg(asg_rec.assignment_id)

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

6996: /*for c_asg in csr_get_other_asg(asg_rec.assignment_id)
6997: loop*/
6998: /* SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
6999: hr_utility.set_location('Creating action for asg '||c_asg.asg_id, 50);
7000: hr_nonrun_asact.insact(lockingactid, c_asg.asg_id, pactid, chunk, NULL );
7001: hr_utility.set_location('Created action for asg '||c_asg.asg_id, 50);*/
7002:
7003: hr_utility.set_location('l_person_id:'||l_person_id || ' asg_rec.assignment_id:' ||
7004: asg_rec.assignment_id || ' g_start_year: ' || g_start_year ,50);

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

7012:
7013: EXIT WHEN csr_agg_all_asg_act_creat%NOTFOUND;
7014: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
7015: hr_utility.set_location('Creating action for asg '||l_asg_id, 50);
7016: hr_nonrun_asact.insact(lockingactid, l_asg_id, pactid, chunk, NULL );
7017: hr_utility.set_location('Created action for asg '||l_asg_id, 50);
7018:
7019: -- new changes
7020: open csr_agg_all_actions_lock(l_person_id, l_asg_id, g_start_year, g_end_year);

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

7030: -- Apply lock
7031:
7032: hr_utility.set_location('lockingactid '||lockingactid, 50);
7033: hr_utility.set_location('l_pre_pay_asg_action_id '||l_pre_pay_asg_action_id, 50);
7034: hr_nonrun_asact.insint(lockingactid, l_pre_pay_asg_action_id);
7035:
7036: end loop;
7037: close csr_agg_all_actions_lock;
7038: end loop;

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

7041: /*open chk_processed_in_prepay(l_cur_asg_action_id);
7042: fetch chk_processed_in_prepay into l_cur_asg_pre_pay_act_id;
7043: close chk_processed_in_prepay;*/
7044: -- lock
7045: -- hr_nonrun_asact.insint(lockingactid, l_cur_asg_pre_pay_act_id);
7046:
7047: /*end loop;*/
7048:
7049: -- end get the other assigment ids for this person.

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

7058: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);
7059: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
7060:
7061: -- Insert assignment into pay_assignment_actions
7062: hr_nonrun_asact.insact ( lockingactid, asg_rec.assignment_id, pactid, chunk, NULL );
7063: -- get the assigment action id of the prepayment payroll action id for the current assignment.
7064: OPEN csr_prepay_asg_act_details(asg_rec.assignment_id, l_pre_pact_id);
7065: FETCH csr_prepay_asg_act_details
7066: INTO l_prepay_asg_action_id,

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

7066: INTO l_prepay_asg_action_id,
7067: l_prepay_payroll_action_id,
7068: l_prepay_effective_date;
7069: --apply the lock
7070: hr_nonrun_asact.insint(lockingactid, l_prepay_asg_action_id);
7071: CLOSE csr_prepay_asg_act_details;
7072: if l_ni_agg_flag = 'Y' then
7073: hr_utility.set_location('This is NI aggregation case ', 50);
7074: -- Get the RTI NI Reporting asg and effective date.

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

7104: if nvl(l_rti_ni_proc_flag,'N') <> 'Y' and asg_rec.asg_act_id = l_ni_aggr_max_act_id then
7105: hr_utility.set_location('Creating action for rti rpt asg:'|| l_ni_rpt_asg_id, 50);
7106: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
7107: -- Insert assignment into pay_assignment_actions
7108: hr_nonrun_asact.insact ( lockingactid, l_ni_rpt_asg_id, pactid, chunk, NULL );
7109: /* -- get the assigment action id of the prepayment payroll action id for the current assignment.
7110: OPEN csr_ni_prepay_asg_act_details(asg_rec.asg_act_id);
7111: FETCH csr_ni_prepay_asg_act_details
7112: INTO l_ni_prepay_asg_action_id;

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

7115: --apply the lock
7116: if l_ni_prepay_asg_action_id is not null then
7117: hr_utility.trace('lockingactid: '||lockingactid);
7118: hr_utility.trace('l_ni_prepay_asg_action_id: '|| l_ni_prepay_asg_action_id);
7119: hr_nonrun_asact.insint(lockingactid, l_ni_prepay_asg_action_id);
7120: else
7121: hr_utility.trace('No prepayment for asg_id : '|| );
7122: */
7123: end if;

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

10149:
10150: /* Moved this code to Action creation
10151: -- lock the pre payments action id with current fps assignment action id
10152: begin
10153: hr_nonrun_asact.insint(p_assactid, l_prepay_asg_action_id);
10154: exception
10155: when dup_val_on_index then
10156: hr_utility.set_location(sqlcode || '-' || sqlerrm,60);
10157: hr_utility.set_location('Skip locking for retry.Locking action id-'||p_assactid || ' Locked action id-' || l_prepay_asg_action_id,60);

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

10586: l_archive_tab_det2(l_archive_det2_counter).act_info30 := l_report_det1_det2_flag;
10587:
10588: /* -- lock the pre payments action id with current fps assignment action id
10589: begin
10590: hr_nonrun_asact.insint(p_assactid, l_cur_asg_pre_pay_act_id);
10591: exception
10592: when dup_val_on_index then
10593: hr_utility.set_location(sqlcode || '-' || sqlerrm,60);
10594: 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 11004: hr_nonrun_asact.insint(p_assactid, l_cur_asg_pre_pay_act_id);

11000: l_archive_tab_det2(l_archive_det2_counter).act_info30 := l_report_det1_det2_flag;
11001:
11002: /* -- lock the pre payments action id with current fps assignment action id
11003: begin
11004: hr_nonrun_asact.insint(p_assactid, l_cur_asg_pre_pay_act_id);
11005: exception
11006: when dup_val_on_index then
11007: hr_utility.set_location(sqlcode || '-' || sqlerrm,60);
11008: 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 11420: hr_nonrun_asact.insint(p_assactid, l_prepay_asg_action_id);

11416: insert_archive_row_agg(p_assactid, p_effective_date,l_archive_tab_ni_det);
11417: insert_archive_row_agg(p_assactid, p_effective_date,l_archive_tab_ni_det_1);
11418: /* -- lock the pre payments action id with current fps assignment action id
11419: begin
11420: hr_nonrun_asact.insint(p_assactid, l_prepay_asg_action_id);
11421: exception
11422: when dup_val_on_index then
11423: hr_utility.set_location(sqlcode || '-' || sqlerrm,60);
11424: hr_utility.set_location('Skip locking for retry.Locking action id-'||p_assactid || ' Locked action id-' || l_prepay_asg_action_id,60);

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

12009: insert_archive_row(p_assactid, p_effective_date,l_archive_tab);
12010: /* moved this code to action creation
12011: -- lock the pre payments action id with current fps assignment action id
12012: begin
12013: hr_nonrun_asact.insint(p_assactid, l_prepay_asg_action_id);
12014: exception
12015: when dup_val_on_index then
12016: hr_utility.set_location(sqlcode || '-' || sqlerrm,60);
12017: hr_utility.set_location('Skip locking for retry.Locking action id-'||p_assactid || ' Locked action id-' || l_prepay_asg_action_id,60);