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_CA_EOY_RL1_AMEND_REG dependencies on PAY_CA_EOY_RL1_AMEND_REG

Line 1: PACKAGE BODY pay_ca_eoy_rl1_amend_reg AS

1: PACKAGE BODY pay_ca_eoy_rl1_amend_reg AS
2: /* $Header: pycarl1cr.pkb 120.4 2006/10/17 00:09:35 meshah noship $ */
3: /*
4: ******************************************************************
5: * *

Line 20: Name : pay_ca_eoy_rl1_amend_reg

16: * 500 Oracle Parkway, Redwood City, CA, 94065. *
17: * *
18: ******************************************************************
19:
20: Name : pay_ca_eoy_rl1_amend_reg
21:
22: Description : This Package is used by RL1 Amendment Register
23: and RL1 Amendment Paper Reports.
24:

Line 48: gv_package VARCHAR2(100) := 'pay_ca_eoy_rl1_amend_reg';

44: 16-OCT-2006 meshah 115.10 5528944 Added order by clause in the range
45: cursor queries.
46: *****************************************************************************/
47:
48: gv_package VARCHAR2(100) := 'pay_ca_eoy_rl1_amend_reg';
49: gv_procedure_name VARCHAR2(100);
50:
51: /*****************************************************************************
52: Name : get_payroll_action_info

Line 72: select to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(

68: ,p_report_type out nocopy varchar2
69: )
70: IS
71: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
72: select to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
73: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
74: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
75: 'PER_ID',ppa.legislative_parameters)),
76: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(

Line 74: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(

70: IS
71: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
72: select to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
73: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
74: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
75: 'PER_ID',ppa.legislative_parameters)),
76: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
77: 'ASG_SET_ID',ppa.legislative_parameters)),
78: pay_ca_eoy_rl1_amend_reg.get_parameter(

Line 76: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(

72: select to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
73: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
74: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
75: 'PER_ID',ppa.legislative_parameters)),
76: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
77: 'ASG_SET_ID',ppa.legislative_parameters)),
78: pay_ca_eoy_rl1_amend_reg.get_parameter(
79: 'MODE',ppa.legislative_parameters),
80: effective_date,

Line 78: pay_ca_eoy_rl1_amend_reg.get_parameter(

74: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
75: 'PER_ID',ppa.legislative_parameters)),
76: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
77: 'ASG_SET_ID',ppa.legislative_parameters)),
78: pay_ca_eoy_rl1_amend_reg.get_parameter(
79: 'MODE',ppa.legislative_parameters),
80: effective_date,
81: start_date,
82: business_group_id,

Line 309: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

305: and cp_end_person
306: and ppa_arch.business_group_id = ln_business_group_id
307: and ppa_arch.report_type = 'CAEOY_RL1_AMEND_PP'
308: and ppa_arch.payroll_action_id = paa_arch.payroll_action_id
309: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
310: ppa_arch.legislative_parameters) =
311: nvl(ln_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
312: ppa_arch.legislative_parameters))
313: and paa_arch.action_status = 'C'

Line 311: nvl(ln_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

307: and ppa_arch.report_type = 'CAEOY_RL1_AMEND_PP'
308: and ppa_arch.payroll_action_id = paa_arch.payroll_action_id
309: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
310: ppa_arch.legislative_parameters) =
311: nvl(ln_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
312: ppa_arch.legislative_parameters))
313: and paa_arch.action_status = 'C'
314: and ppa_arch.effective_date = cp_effective_date
315: and paf.person_id = to_number(paa_arch.serial_number);

Line 374: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

370: ,cp_business_group_id in number) is
371: select ppa.report_type,
372: paa.assignment_id,
373: paa.assignment_action_id,
374: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
375: ppa.legislative_parameters)
376: from pay_payroll_actions ppa,
377: pay_assignment_actions paa
378: where paa.serial_number = to_char(cp_person_id)

Line 379: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

375: ppa.legislative_parameters)
376: from pay_payroll_actions ppa,
377: pay_assignment_actions paa
378: where paa.serial_number = to_char(cp_person_id)
379: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
380: ppa.legislative_parameters) =
381: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
382: ppa.legislative_parameters))
383: and paa.action_status = 'C'

Line 381: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

377: pay_assignment_actions paa
378: where paa.serial_number = to_char(cp_person_id)
379: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
380: ppa.legislative_parameters) =
381: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
382: ppa.legislative_parameters))
383: and paa.action_status = 'C'
384: and ppa.payroll_action_id = paa.payroll_action_id
385: and ppa.effective_date = cp_effective_date

Line 405: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

401: ,cp_business_group_id in number) is
402: select ppa.report_type,
403: paa.assignment_id,
404: paa.assignment_action_id,
405: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
406: ppa.legislative_parameters)
407: from pay_payroll_actions ppa,
408: pay_assignment_actions paa
409: where paa.serial_number = to_char(cp_person_id)

Line 410: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

406: ppa.legislative_parameters)
407: from pay_payroll_actions ppa,
408: pay_assignment_actions paa
409: where paa.serial_number = to_char(cp_person_id)
410: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
411: ppa.legislative_parameters) =
412: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
413: ppa.legislative_parameters))
414: and paa.action_status = 'C'

Line 412: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

408: pay_assignment_actions paa
409: where paa.serial_number = to_char(cp_person_id)
410: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
411: ppa.legislative_parameters) =
412: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
413: ppa.legislative_parameters))
414: and paa.action_status = 'C'
415: and ppa.business_group_id = cp_business_group_id
416: and ppa.payroll_action_id = paa.payroll_action_id

Line 438: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

434: and report_qualifier = 'CAEOYRL1'
435: and action_type = 'X'
436: and action_status = 'C'
437: and effective_date = cp_year
438: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
439: legislative_parameters)
440: = to_char(cp_pre);
441:
442:

Line 940: end pay_ca_eoy_rl1_amend_reg;

936: /* hr_utility.trace_on(null,'RL1AMEND_REG'); */
937: null;
938:
939:
940: end pay_ca_eoy_rl1_amend_reg;