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_EPS_13 dependencies on PAY_GB_EPS

Line 1: PACKAGE BODY PAY_GB_EPS_13 as

1: PACKAGE BODY PAY_GB_EPS_13 as
2: /* $Header: pygbeps13.pkb 120.5.12020000.2 2013/03/09 06:05:22 ssanjays noship $ *
3: /*===========================================================================+
4: | Copyright (c) 1993 Oracle Corporation |
5: | Redwood Shores, California, USA |

Line 9: PAY_GB_EPS_13

5: | Redwood Shores, California, USA |
6: | All rights reserved. |
7: +============================================================================
8: Name:
9: PAY_GB_EPS_13
10: Purpose:
11: It fetches the live data and generates RTI EPS Records.
12: This is a UK Specific payroll package.
13:

Line 19: g_package varchar2(15):='pay_gb_eps_13.';

15: 12-Dec-2012 sampmand 115.0 15890006 Created
16: 18-Dec-2012 sampmand 115.1 15890006 Fixed GSCC errors
17: =============================================================================*/
18:
19: g_package varchar2(15):='pay_gb_eps_13.';
20:
21: PROCEDURE Check_constraints
22: (
23: p_tax_free_pymt IN VARCHAR2,

Line 132: insert into PAY_GB_EPS_DETAILS

128: if l_profile = 'N' then
129: l_approver_id := NULL;
130: end if;
131:
132: insert into PAY_GB_EPS_DETAILS
133: ( EPS_RECORD_ID,
134: EMP_PAYE_REFERENCE,
135: ACCOUNT_OFFICE_NUMBER,
136: BUSINESS_GROUP_ID,

Line 180: pay_gb_eps_details_s.nextval,

176: PROGRAM_UPDATE_DATE
177: )
178: VALUES
179: (
180: pay_gb_eps_details_s.nextval,
181: p_emp_paye_reference,
182: p_account_office_number,
183: p_business_group_id,
184: p_employer_name,

Line 238: --pay_gb_eps.delete_eps_record

234: p_emp_paye_reference IN VARCHAR2,
235: p_business_group_id IN VARCHAR2,
236: p_return_status OUT NOCOPY VARCHAR2
237: )
238: --pay_gb_eps.delete_eps_record
239: IS
240:
241: l_proc varchar2(72) := g_package||'delete_eps_record';
242:

Line 249: FROM pay_gb_eps_details

245:
246: hr_utility.set_location(' Entering :' || l_proc,160);
247:
248: DELETE
249: FROM pay_gb_eps_details
250: WHERE EMP_PAYE_REFERENCE = p_emp_paye_reference
251: AND EFFECTIVE_DATE = p_effective_date
252: and business_group_id = p_business_group_id;
253:

Line 280: from pay_gb_eps_details

276: l_proc varchar2(72) := g_package||' check_sequence';
277:
278: cursor csr_check_seq is
279: select emp_paye_reference
280: from pay_gb_eps_details
281: where emp_paye_reference = p_emp_paye_reference
282: and business_group_id = p_business_group_id
283: and effective_date > p_effective_date
284: and status <> 'Saved';

Line 359: from per_all_people_f papf ,pay_gb_eps_details pged

355:
356:
357: cursor c_get_approver is
358: select papf.email_address email_address
359: from per_all_people_f papf ,pay_gb_eps_details pged
360: where pged.effective_date = p_effective_date
361: and pged.emp_paye_reference = p_emp_paye_reference
362: and papf.person_id = pged.approver_id
363: order by papf.effective_start_date desc;

Line 367: from per_all_people_f papf ,pay_gb_eps_details pged

363: order by papf.effective_start_date desc;
364:
365: cursor c_get_user is
366: select papf.email_address email_address
367: from per_all_people_f papf ,pay_gb_eps_details pged
368: where pged.effective_date = p_effective_date
369: and pged.emp_paye_reference = p_emp_paye_reference
370: and papf.person_id = pged.user_id
371: order by papf.effective_start_date desc;

Line 379: from pay_gb_eps_details

375: where employee_id = personid;
376:
377: cursor csr_get_ovn is
378: select object_version_number
379: from pay_gb_eps_details
380: where emp_paye_reference = p_emp_paye_reference
381: and effective_date = p_effective_date
382: and business_group_id = p_business_group_id;
383:

Line 386: from pay_gb_eps_details

382: and business_group_id = p_business_group_id;
383:
384: cursor csr_get_ids is
385: select user_id , approver_id
386: from pay_gb_eps_details
387: where emp_paye_reference = p_emp_paye_reference
388: and effective_date = p_effective_date
389: and business_group_id = p_business_group_id;
390:

Line 439: PAY_GB_EPS_DETAILS

435: l_status := 'Verified';
436: end if;
437: hr_utility.set_location('Status : '||l_status,40);
438: UPDATE
439: PAY_GB_EPS_DETAILS
440: SET STATUS = l_status,
441: REQUEST_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, request_id, FND_GLOBAL.CONC_REQUEST_ID),
442: PROGRAM_APPLICATION_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_application_id, FND_GLOBAL.PROG_APPL_ID),
443: PROGRAM_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_id, FND_GLOBAL.CONC_PROGRAM_ID),

Line 485: pay_gb_eps.start_eps_wf(eps_id => l_eps_id,status => p_status,email_address => email_address,user_name => l_user_name );

481: hr_utility.set_location('Status : '||p_status,40);
482: hr_utility.set_location('email_address : '||email_address,40);
483:
484: -- Calling Workflow to send Notification
485: pay_gb_eps.start_eps_wf(eps_id => l_eps_id,status => p_status,email_address => email_address,user_name => l_user_name );
486: end if;
487:
488: p_return_status := 'S';
489: hr_utility.set_location('Updated the status of the EPS record',100);

Line 546: from pay_gb_eps_details

542: l_proc varchar2(72) := g_package||'update_eps_record';
543:
544: cursor csr_get_ovn is
545: select object_version_number,related_tax_year
546: from pay_gb_eps_details
547: where emp_paye_reference = p_emp_paye_reference
548: and effective_date = p_effective_date
549: and business_group_id = p_business_group_id;
550:

Line 721: UPDATE PAY_GB_EPS_DETAILS

717: l_approver_id := NULL;
718: else l_approver_id := p_approver_id;
719: end if;
720:
721: UPDATE PAY_GB_EPS_DETAILS
722: SET
723: TAX_FREE_PYMT = p_tax_free_pymt,
724: EMP_THIRD_PARTY = p_emp_third_party,
725: EXP_BEN_OTHERS = p_exp_ben_othrs,

Line 788: PAY_GB_EPS_DETAILS

784: begin
785: hr_utility.set_location(' Entering :' || l_proc,160);
786:
787: UPDATE
788: PAY_GB_EPS_DETAILS
789: SET FINAL_SUBMISSION_CEASED = p_final_submission_ceased,
790: FINAL_SUBMISSION_YEAR = p_final_submission_year
791: WHERE EMP_PAYE_REFERENCE = p_emp_paye_reference
792: AND EFFECTIVE_DATE = p_effective_date

Line 912: pay_gb_eps_details

908: is
909:
910: cursor csr_eps is
911: select emp_paye_reference,object_version_number ovn,account_office_number,employer_name,econ_number,related_tax_year,final_submission_ceased,final_submission_year from
912: pay_gb_eps_details
913: where emp_paye_reference = p_emp_paye_reference
914: and effective_date = to_date(substr(p_effective_date,0,10),'YYYY-MM-DD')
915: and business_group_id = p_business_group_id
916: and status = 'Verified';

Line 921: pay_gb_eps_details

917:
918:
919: cursor csr_eps_all_paye is
920: select emp_paye_reference,object_version_number ovn,account_office_number,employer_name,econ_number,related_tax_year,final_submission_ceased,final_submission_year from
921: pay_gb_eps_details
922: where effective_date = to_date(substr(p_effective_date,0,10),'YYYY-MM-DD')
923: and business_group_id = p_business_group_id
924: and status = 'Verified';
925:

Line 1122: pay_gb_eps_details

1118: is
1119:
1120: cursor csr_eps is
1121: select emp_paye_reference,object_version_number ovn from
1122: pay_gb_eps_details
1123: where emp_paye_reference = p_emp_paye_reference
1124: and effective_date = to_date(substr(p_effective_date,0,10),'YYYY-MM-DD')
1125: and business_group_id = p_business_group_id
1126: and status = 'Sent';

Line 1185: from pay_gb_eps_details

1181: nic_comp_aspp_calc,
1182: nic_comp_ssp_calc,
1183: cis_deductions_stuff,
1184: nic_holiday_val
1185: from pay_gb_eps_details
1186: where emp_paye_reference = p_emp_paye_reference
1187: and effective_date = to_date(substr(p_effective_date,0,10),'YYYY-MM-DD')
1188: and business_group_id = p_business_group_id
1189: and status = 'Verified';

Line 1557: END pay_gb_eps_13;

1553: end if;
1554: return tax_year;
1555: end;
1556:
1557: END pay_gb_eps_13;