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.PQP_USTIAA_PKG dependencies on PQP_USTIAA_PKG

Line 1: package body pqp_ustiaa_pkg AS

1: package body pqp_ustiaa_pkg AS
2: /* $Header: pqustiaa.pkb 120.8.12000000.1 2007/01/16 04:38:42 appldev noship $ */
3:
4: g_proc_name VARCHAR2(50) := 'pqp_ustiaa_pkg.';
5:

Line 4: g_proc_name VARCHAR2(50) := 'pqp_ustiaa_pkg.';

1: package body pqp_ustiaa_pkg AS
2: /* $Header: pqustiaa.pkb 120.8.12000000.1 2007/01/16 04:38:42 appldev noship $ */
3:
4: g_proc_name VARCHAR2(50) := 'pqp_ustiaa_pkg.';
5:
6: -- ---------------------------------------------------------------------
7: -- |------------------------< range_cursor >----------------------------|
8: -- ---------------------------------------------------------------------

Line 24: pqp_ustiaa_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),

20:
21: BEGIN
22: hr_utility.set_location('Entering : '||l_proc_name, 10);
23: SELECT ppa.legislative_parameters,
24: pqp_ustiaa_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
25: pqp_ustiaa_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
26: pqp_ustiaa_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
27: INTO leg_param,
28: l_consolidation_set_id,

Line 25: pqp_ustiaa_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),

21: BEGIN
22: hr_utility.set_location('Entering : '||l_proc_name, 10);
23: SELECT ppa.legislative_parameters,
24: pqp_ustiaa_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
25: pqp_ustiaa_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
26: pqp_ustiaa_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
27: INTO leg_param,
28: l_consolidation_set_id,
29: l_payroll_id,

Line 26: pqp_ustiaa_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)

22: hr_utility.set_location('Entering : '||l_proc_name, 10);
23: SELECT ppa.legislative_parameters,
24: pqp_ustiaa_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
25: pqp_ustiaa_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
26: pqp_ustiaa_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
27: INTO leg_param,
28: l_consolidation_set_id,
29: l_payroll_id,
30: l_tax_unit_id

Line 100: pqp_ustiaa_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),

96: l_proc_name VARCHAR2(150) := g_proc_name ||'action_creation';
97:
98: CURSOR c_parameters (pactid NUMBER) IS
99: SELECT ppa.legislative_parameters,
100: pqp_ustiaa_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
101: pqp_ustiaa_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
102: pqp_ustiaa_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
103: FROM pay_payroll_actions ppa
104: WHERE ppa.payroll_action_id = pactid;

Line 101: pqp_ustiaa_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),

97:
98: CURSOR c_parameters (pactid NUMBER) IS
99: SELECT ppa.legislative_parameters,
100: pqp_ustiaa_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
101: pqp_ustiaa_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
102: pqp_ustiaa_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
103: FROM pay_payroll_actions ppa
104: WHERE ppa.payroll_action_id = pactid;
105:

Line 102: pqp_ustiaa_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)

98: CURSOR c_parameters (pactid NUMBER) IS
99: SELECT ppa.legislative_parameters,
100: pqp_ustiaa_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
101: pqp_ustiaa_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
102: pqp_ustiaa_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
103: FROM pay_payroll_actions ppa
104: WHERE ppa.payroll_action_id = pactid;
105:
106: CURSOR c_actions (pactid NUMBER,

Line 317: pqp_ustiaa_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),

313: l_proc_name VARCHAR2(150) := g_proc_name ||'action_creation_ops';
314:
315: CURSOR c_parameters (pactid NUMBER) IS
316: SELECT ppa.legislative_parameters,
317: pqp_ustiaa_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
318: pqp_ustiaa_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
319: pqp_ustiaa_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
320: FROM pay_payroll_actions ppa
321: WHERE ppa.payroll_action_id = pactid;

Line 318: pqp_ustiaa_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),

314:
315: CURSOR c_parameters (pactid NUMBER) IS
316: SELECT ppa.legislative_parameters,
317: pqp_ustiaa_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
318: pqp_ustiaa_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
319: pqp_ustiaa_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
320: FROM pay_payroll_actions ppa
321: WHERE ppa.payroll_action_id = pactid;
322:

Line 319: pqp_ustiaa_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)

315: CURSOR c_parameters (pactid NUMBER) IS
316: SELECT ppa.legislative_parameters,
317: pqp_ustiaa_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
318: pqp_ustiaa_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
319: pqp_ustiaa_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
320: FROM pay_payroll_actions ppa
321: WHERE ppa.payroll_action_id = pactid;
322:
323: CURSOR c_actions_ops (pactid NUMBER,

Line 468: l_proc_name varchar2(50) := 'pqp_ustiaa_pkg.get_amount';

464: AND db.balance_type_id = p_bal_type_id;
465:
466: l_def_bal_id number;
467: l_value number;
468: l_proc_name varchar2(50) := 'pqp_ustiaa_pkg.get_amount';
469:
470: BEGIN
471:
472: hr_utility.set_location('Entering : '||l_proc_name, 10);

Line 573: l_proc_name varchar2(50) := 'pqp_ustiaa_pkg.chk_cont_type_override';

569: where pei.assignment_id = p_asg_id
570: and pei.aei_information_category = 'PAY_US_TIAA_CREF_CONT_TYPE'
571: and pei.aei_information3 = p_ele_entry_id;
572:
573: l_proc_name varchar2(50) := 'pqp_ustiaa_pkg.chk_cont_type_override';
574: l_sub_plan varchar2(5);
575: l_source varchar2(2);
576: BEGIN
577: hr_utility.set_location('Entering : '||l_proc_name, 10);

Line 649: l_proc_name varchar2(100) := 'pqp_ustiaa_pkg.load_xml';

645: P_NODE varchar2,
646: P_DATA varchar2
647: ) AS
648:
649: l_proc_name varchar2(100) := 'pqp_ustiaa_pkg.load_xml';
650: l_data varchar2(500);
651: BEGIN
652:
653: hr_utility.set_location('Entering : '||l_proc_name, 10);

Line 677: l_proc_name varchar2(50) := 'pqp_ustiaa_pkg.generate_header_xml';

673: -- ---------------------------------------------------------------------
674: -- |-----------------------< generate_header >--------------------------|
675: -- --------------------------------------------------------------------
676: PROCEDURE generate_header_xml is
677: l_proc_name varchar2(50) := 'pqp_ustiaa_pkg.generate_header_xml';
678:
679: CURSOR csr_rpt_data(pactid number) IS
680: select ppa.start_date,
681: ppa.effective_date,

Line 725: l_proc_name varchar2(50) := 'pqp_ustiaa_pkg.generate_footer_xml';

721: -- ---------------------------------------------------------------------
722: -- |-----------------------< generate_footer >--------------------------|
723: -- --------------------------------------------------------------------
724: PROCEDURE generate_footer_xml is
725: l_proc_name varchar2(50) := 'pqp_ustiaa_pkg.generate_footer_xml';
726: BEGIN
727:
728: hr_utility.set_location('Entering : '||l_proc_name, 10);
729:

Line 740: l_proc_name VARCHAR2 (100) := 'pqp_ustiaa_pkg.generate_record';

736: -- ---------------------------------------------------------------------
737: -- |------------------------< generate_record >-------------------------|
738: -- ---------------------------------------------------------------------
739: PROCEDURE generate_record IS
740: l_proc_name VARCHAR2 (100) := 'pqp_ustiaa_pkg.generate_record';
741: l_last_name per_all_people_f.last_name%TYPE;
742: l_first_name per_all_people_f.first_name%TYPE;
743: l_middle_name per_all_people_f.middle_names%TYPE;
744: l_ssn per_all_people_f.national_identifier%TYPE;

Line 876: pqp_ustiaa_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),

872: AND prl.effective_end_date;
873:
874: CURSOR c_parameters (asg_actid NUMBER) IS
875: SELECT ppa.legislative_parameters,
876: pqp_ustiaa_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
877: pqp_ustiaa_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
878: pqp_ustiaa_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
879: FROM pay_payroll_actions ppa,
880: pay_temp_object_actions poa

Line 877: pqp_ustiaa_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),

873:
874: CURSOR c_parameters (asg_actid NUMBER) IS
875: SELECT ppa.legislative_parameters,
876: pqp_ustiaa_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
877: pqp_ustiaa_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
878: pqp_ustiaa_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
879: FROM pay_payroll_actions ppa,
880: pay_temp_object_actions poa
881: WHERE poa.object_action_id = asg_actid

Line 878: pqp_ustiaa_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)

874: CURSOR c_parameters (asg_actid NUMBER) IS
875: SELECT ppa.legislative_parameters,
876: pqp_ustiaa_pkg.get_parameter('TRANSFER_CONC_SET',ppa.legislative_parameters),
877: pqp_ustiaa_pkg.get_parameter('TRANSFER_PAYROLL',ppa.legislative_parameters),
878: pqp_ustiaa_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters)
879: FROM pay_payroll_actions ppa,
880: pay_temp_object_actions poa
881: WHERE poa.object_action_id = asg_actid
882: and ppa.payroll_action_id = poa.payroll_action_id;

Line 1092: END PQP_UStiaa_pkg;

1088: END IF;
1089:
1090: END generate_record;
1091:
1092: END PQP_UStiaa_pkg;