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_GB_T1_PENSION_EXTRACTS dependencies on PAY_INTERPRETER_PKG

Line 3148: ,t_proration_dates OUT NOCOPY pay_interpreter_pkg.t_proration_dates_table_type

3144: ,p_element_entry_id IN NUMBER -- DEFAULT NULL
3145: ,p_business_group_id IN NUMBER -- DEFAULT NULL
3146: ,p_start_date IN DATE
3147: ,p_end_date IN DATE
3148: ,t_proration_dates OUT NOCOPY pay_interpreter_pkg.t_proration_dates_table_type
3149: ,t_proration_changes OUT NOCOPY pay_interpreter_pkg.t_proration_type_table_type
3150: ) RETURN NUMBER
3151: IS
3152:

Line 3149: ,t_proration_changes OUT NOCOPY pay_interpreter_pkg.t_proration_type_table_type

3145: ,p_business_group_id IN NUMBER -- DEFAULT NULL
3146: ,p_start_date IN DATE
3147: ,p_end_date IN DATE
3148: ,t_proration_dates OUT NOCOPY pay_interpreter_pkg.t_proration_dates_table_type
3149: ,t_proration_changes OUT NOCOPY pay_interpreter_pkg.t_proration_type_table_type
3150: ) RETURN NUMBER
3151: IS
3152:
3153: -- Variable Declaration

Line 3550: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;

3546: l_new_event_itr NUMBER(5);
3547:
3548: -- Rowtype Variable Declaration
3549: l_event_group_details pqp_gb_tp_pension_extracts.csr_event_group_details%ROWTYPE;
3550: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
3551: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
3552: l_asg_details csr_asg_details_up%ROWTYPE;
3553: l_prev_asg_details csr_asg_details_up%ROWTYPE;
3554: l_next_asg_details csr_asg_details_up%ROWTYPE;

Line 3551: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;

3547:
3548: -- Rowtype Variable Declaration
3549: l_event_group_details pqp_gb_tp_pension_extracts.csr_event_group_details%ROWTYPE;
3550: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
3551: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
3552: l_asg_details csr_asg_details_up%ROWTYPE;
3553: l_prev_asg_details csr_asg_details_up%ROWTYPE;
3554: l_next_asg_details csr_asg_details_up%ROWTYPE;
3555: l_pqp_asg_attributes pqp_gb_tp_pension_extracts.csr_pqp_asg_attributes_dn%ROWTYPE;

Line 4129: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;

4125: l_inclusion_flag VARCHAR2(1) := 'N';
4126:
4127: -- Rowtype Variable Declaration
4128: l_event_group_details pqp_gb_tp_pension_extracts.csr_event_group_details%ROWTYPE;
4129: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
4130: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
4131: l_asg_details csr_asg_details_up%ROWTYPE;
4132: l_prev_asg_details csr_asg_details_up%ROWTYPE;
4133: l_pqp_asg_attributes pqp_gb_tp_pension_extracts.csr_pqp_asg_attributes_dn%ROWTYPE;

Line 4130: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;

4126:
4127: -- Rowtype Variable Declaration
4128: l_event_group_details pqp_gb_tp_pension_extracts.csr_event_group_details%ROWTYPE;
4129: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
4130: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
4131: l_asg_details csr_asg_details_up%ROWTYPE;
4132: l_prev_asg_details csr_asg_details_up%ROWTYPE;
4133: l_pqp_asg_attributes pqp_gb_tp_pension_extracts.csr_pqp_asg_attributes_dn%ROWTYPE;
4134: l_last_pqp_asg_attributes pqp_gb_tp_pension_extracts.csr_pqp_asg_attributes_dn%ROWTYPE;

Line 12862: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;

12858:
12859: l_event_group pay_event_groups.event_group_name%TYPE := 'PQP_GB_TP_ASG_EMP_CAT';
12860:
12861: -- Rowtype Variable Declaration
12862: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
12863: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
12864:
12865: l_asg_details csr_asg_details_dn%ROWTYPE;
12866: l_prev_asg_details csr_asg_details_dn%ROWTYPE;

Line 12863: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;

12859: l_event_group pay_event_groups.event_group_name%TYPE := 'PQP_GB_TP_ASG_EMP_CAT';
12860:
12861: -- Rowtype Variable Declaration
12862: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
12863: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
12864:
12865: l_asg_details csr_asg_details_dn%ROWTYPE;
12866: l_prev_asg_details csr_asg_details_dn%ROWTYPE;
12867:

Line 13010: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;

13006: l_itr NUMBER(5);
13007: l_new_event_itr NUMBER(5);
13008:
13009: -- Rowtype Variable Declaration
13010: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
13011: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
13012:
13013: l_proc_name VARCHAR2(61):=
13014: g_proc_name||'store_event_grp_changes';

Line 13011: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;

13007: l_new_event_itr NUMBER(5);
13008:
13009: -- Rowtype Variable Declaration
13010: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
13011: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
13012:
13013: l_proc_name VARCHAR2(61):=
13014: g_proc_name||'store_event_grp_changes';
13015:

Line 13097: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;

13093:
13094: l_event_group pay_event_groups.event_group_name%TYPE;
13095:
13096: -- Rowtype Variable Declaration
13097: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
13098: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
13099:
13100: l_rate_types t_rate_types;
13101: l_element_set csr_element_set%ROWTYPE;

Line 13098: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;

13094: l_event_group pay_event_groups.event_group_name%TYPE;
13095:
13096: -- Rowtype Variable Declaration
13097: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
13098: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
13099:
13100: l_rate_types t_rate_types;
13101: l_element_set csr_element_set%ROWTYPE;
13102: l_element_entries csr_element_entries%ROWTYPE;