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

Line 1: PACKAGE BODY PAY_GB_EPS as

1: PACKAGE BODY PAY_GB_EPS as
2: /* $Header: pygbeps.pkb 120.12.12020000.1 2013/02/14 06:36:02 rajganga noship $ *
3: /*===========================================================================+
4: | Copyright (c) 1993 Oracle Corporation |
5: | Redwood Shores, California, USA |

Line 43: g_package varchar2(15):='pay_gb_eps.';

39: 08-Oct-2012 krreddy 120.25 14704814 Added new column to insert - EPS_RECORD_ID.
40: 26-Nov-2012 rajganga 120.26 14704814 Added code to update Who columns.
41: =============================================================================*/
42:
43: g_package varchar2(15):='pay_gb_eps.';
44:
45: PROCEDURE Check_constraints
46: (
47: p_tax_free_pymt IN VARCHAR2,

Line 154: insert into PAY_GB_EPS_DETAILS

150: if l_profile = 'N' then
151: l_approver_id := NULL;
152: end if;
153:
154: insert into PAY_GB_EPS_DETAILS
155: ( EPS_RECORD_ID,
156: EMP_PAYE_REFERENCE,
157: ACCOUNT_OFFICE_NUMBER,
158: BUSINESS_GROUP_ID,

Line 200: pay_gb_eps_details_s.nextval,

196: PROGRAM_UPDATE_DATE
197: )
198: VALUES
199: (
200: pay_gb_eps_details_s.nextval,
201: p_emp_paye_reference,
202: p_account_office_number,
203: p_business_group_id,
204: p_employer_name,

Line 256: --pay_gb_eps.delete_eps_record

252: p_emp_paye_reference IN VARCHAR2,
253: p_business_group_id IN VARCHAR2,
254: p_return_status OUT NOCOPY VARCHAR2
255: )
256: --pay_gb_eps.delete_eps_record
257: IS
258:
259: l_proc varchar2(72) := g_package||'delete_eps_record';
260:

Line 267: FROM pay_gb_eps_details

263:
264: hr_utility.set_location(' Entering :' || l_proc,160);
265:
266: DELETE
267: FROM pay_gb_eps_details
268: WHERE EMP_PAYE_REFERENCE = p_emp_paye_reference
269: AND EFFECTIVE_DATE = p_effective_date
270: and business_group_id = p_business_group_id;
271:

Line 298: from pay_gb_eps_details

294: l_proc varchar2(72) := g_package||' check_sequence';
295:
296: cursor csr_check_seq is
297: select emp_paye_reference
298: from pay_gb_eps_details
299: where emp_paye_reference = p_emp_paye_reference
300: and business_group_id = p_business_group_id
301: and effective_date > p_effective_date
302: and status <> 'Saved';

Line 377: from per_all_people_f papf ,pay_gb_eps_details pged

373:
374:
375: cursor c_get_approver is
376: select papf.email_address email_address
377: from per_all_people_f papf ,pay_gb_eps_details pged
378: where pged.effective_date = p_effective_date
379: and pged.emp_paye_reference = p_emp_paye_reference
380: and papf.person_id = pged.approver_id
381: order by papf.effective_start_date desc;

Line 385: from per_all_people_f papf ,pay_gb_eps_details pged

381: order by papf.effective_start_date desc;
382:
383: cursor c_get_user is
384: select papf.email_address email_address
385: from per_all_people_f papf ,pay_gb_eps_details pged
386: where pged.effective_date = p_effective_date
387: and pged.emp_paye_reference = p_emp_paye_reference
388: and papf.person_id = pged.user_id
389: order by papf.effective_start_date desc;

Line 397: from pay_gb_eps_details

393: where employee_id = personid;
394:
395: cursor csr_get_ovn is
396: select object_version_number
397: from pay_gb_eps_details
398: where emp_paye_reference = p_emp_paye_reference
399: and effective_date = p_effective_date
400: and business_group_id = p_business_group_id;
401:

Line 404: from pay_gb_eps_details

400: and business_group_id = p_business_group_id;
401:
402: cursor csr_get_ids is
403: select user_id , approver_id
404: from pay_gb_eps_details
405: where emp_paye_reference = p_emp_paye_reference
406: and effective_date = p_effective_date
407: and business_group_id = p_business_group_id;
408:

Line 457: PAY_GB_EPS_DETAILS

453: l_status := 'Verified';
454: end if;
455: hr_utility.set_location('Status : '||l_status,40);
456: UPDATE
457: PAY_GB_EPS_DETAILS
458: SET STATUS = l_status,
459: REQUEST_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, request_id, FND_GLOBAL.CONC_REQUEST_ID),
460: PROGRAM_APPLICATION_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_application_id, FND_GLOBAL.PROG_APPL_ID),
461: PROGRAM_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_id, FND_GLOBAL.CONC_PROGRAM_ID),

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

499: hr_utility.set_location('Status : '||p_status,40);
500: hr_utility.set_location('email_address : '||email_address,40);
501:
502: -- Calling Workflow to send Notification
503: pay_gb_eps.start_eps_wf(eps_id => l_eps_id,status => p_status,email_address => email_address,user_name => l_user_name );
504: end if;
505:
506: p_return_status := 'S';
507: hr_utility.set_location('Updated the status of the EPS record',100);

Line 556: from pay_gb_eps_details

552: l_proc varchar2(72) := g_package||'update_eps_record';
553:
554: cursor csr_get_ovn is
555: select object_version_number
556: from pay_gb_eps_details
557: where emp_paye_reference = p_emp_paye_reference
558: and effective_date = p_effective_date
559: and business_group_id = p_business_group_id;
560:

Line 588: UPDATE PAY_GB_EPS_DETAILS

584: l_approver_id := NULL;
585: else l_approver_id := p_approver_id;
586: end if;
587:
588: UPDATE PAY_GB_EPS_DETAILS
589: SET
590: TAX_FREE_PYMT = p_tax_free_pymt,
591: EMP_THIRD_PARTY = p_emp_third_party,
592: EXP_BEN_OTHERS = p_exp_ben_othrs,

Line 649: PAY_GB_EPS_DETAILS

645: begin
646: hr_utility.set_location(' Entering :' || l_proc,160);
647:
648: UPDATE
649: PAY_GB_EPS_DETAILS
650: SET FINAL_SUBMISSION_CEASED = p_final_submission_ceased,
651: FINAL_SUBMISSION_YEAR = p_final_submission_year
652: WHERE EMP_PAYE_REFERENCE = p_emp_paye_reference
653: AND EFFECTIVE_DATE = p_effective_date

Line 774: pay_gb_eps_details

770: is
771:
772: cursor csr_eps is
773: select emp_paye_reference,object_version_number ovn,account_office_number,employer_name,econ_number,related_tax_year from
774: pay_gb_eps_details
775: where emp_paye_reference = p_emp_paye_reference
776: and effective_date = to_date(substr(p_effective_date,0,10),'YYYY-MM-DD')
777: and business_group_id = p_business_group_id
778: and status = 'Verified';

Line 783: pay_gb_eps_details

779:
780:
781: cursor csr_eps_all_paye is
782: select emp_paye_reference,object_version_number ovn,account_office_number,employer_name,econ_number,related_tax_year from
783: pay_gb_eps_details
784: where effective_date = to_date(substr(p_effective_date,0,10),'YYYY-MM-DD')
785: and business_group_id = p_business_group_id
786: and status = 'Verified';
787:

Line 982: pay_gb_eps_details

978: is
979:
980: cursor csr_eps is
981: select emp_paye_reference,object_version_number ovn from
982: pay_gb_eps_details
983: where emp_paye_reference = p_emp_paye_reference
984: and effective_date = to_date(substr(p_effective_date,0,10),'YYYY-MM-DD')
985: and business_group_id = p_business_group_id
986: and status = 'Sent';

Line 1046: from pay_gb_eps_details

1042: nic_comp_ssp_calc,
1043: cis_deductions_stuff,
1044: nic_holiday_val,
1045: adv_from_hmrc
1046: from pay_gb_eps_details
1047: where emp_paye_reference = p_emp_paye_reference
1048: and effective_date = to_date(substr(p_effective_date,0,10),'YYYY-MM-DD')
1049: and business_group_id = p_business_group_id
1050: and status = 'Verified';

Line 1422: END pay_gb_eps;

1418: end if;
1419: return tax_year;
1420: end;
1421:
1422: END pay_gb_eps;