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 3176: ,t_proration_dates OUT NOCOPY pay_interpreter_pkg.t_proration_dates_table_type

3172: ,p_element_entry_id IN NUMBER -- DEFAULT NULL
3173: ,p_business_group_id IN NUMBER -- DEFAULT NULL
3174: ,p_start_date IN DATE
3175: ,p_end_date IN DATE
3176: ,t_proration_dates OUT NOCOPY pay_interpreter_pkg.t_proration_dates_table_type
3177: ,t_proration_changes OUT NOCOPY pay_interpreter_pkg.t_proration_type_table_type
3178: ) RETURN NUMBER
3179: IS
3180:

Line 3177: ,t_proration_changes OUT NOCOPY pay_interpreter_pkg.t_proration_type_table_type

3173: ,p_business_group_id IN NUMBER -- DEFAULT NULL
3174: ,p_start_date IN DATE
3175: ,p_end_date IN DATE
3176: ,t_proration_dates OUT NOCOPY pay_interpreter_pkg.t_proration_dates_table_type
3177: ,t_proration_changes OUT NOCOPY pay_interpreter_pkg.t_proration_type_table_type
3178: ) RETURN NUMBER
3179: IS
3180:
3181: -- Variable Declaration

Line 3578: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;

3574: l_new_event_itr NUMBER(5);
3575:
3576: -- Rowtype Variable Declaration
3577: l_event_group_details pqp_gb_tp_pension_extracts.csr_event_group_details%ROWTYPE;
3578: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
3579: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
3580: l_asg_details csr_asg_details_up%ROWTYPE;
3581: l_prev_asg_details csr_asg_details_up%ROWTYPE;
3582: l_next_asg_details csr_asg_details_up%ROWTYPE;

Line 3579: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;

3575:
3576: -- Rowtype Variable Declaration
3577: l_event_group_details pqp_gb_tp_pension_extracts.csr_event_group_details%ROWTYPE;
3578: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
3579: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
3580: l_asg_details csr_asg_details_up%ROWTYPE;
3581: l_prev_asg_details csr_asg_details_up%ROWTYPE;
3582: l_next_asg_details csr_asg_details_up%ROWTYPE;
3583: l_pqp_asg_attributes pqp_gb_tp_pension_extracts.csr_pqp_asg_attributes_dn%ROWTYPE;

Line 4157: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;

4153: l_inclusion_flag VARCHAR2(1) := 'N';
4154:
4155: -- Rowtype Variable Declaration
4156: l_event_group_details pqp_gb_tp_pension_extracts.csr_event_group_details%ROWTYPE;
4157: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
4158: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
4159: l_asg_details csr_asg_details_up%ROWTYPE;
4160: l_prev_asg_details csr_asg_details_up%ROWTYPE;
4161: l_pqp_asg_attributes pqp_gb_tp_pension_extracts.csr_pqp_asg_attributes_dn%ROWTYPE;

Line 4158: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;

4154:
4155: -- Rowtype Variable Declaration
4156: l_event_group_details pqp_gb_tp_pension_extracts.csr_event_group_details%ROWTYPE;
4157: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
4158: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
4159: l_asg_details csr_asg_details_up%ROWTYPE;
4160: l_prev_asg_details csr_asg_details_up%ROWTYPE;
4161: l_pqp_asg_attributes pqp_gb_tp_pension_extracts.csr_pqp_asg_attributes_dn%ROWTYPE;
4162: l_last_pqp_asg_attributes pqp_gb_tp_pension_extracts.csr_pqp_asg_attributes_dn%ROWTYPE;

Line 13061: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;

13057:
13058: l_event_group pay_event_groups.event_group_name%TYPE := 'PQP_GB_TP_ASG_EMP_CAT';
13059:
13060: -- Rowtype Variable Declaration
13061: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
13062: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
13063:
13064: l_asg_details csr_asg_details_dn%ROWTYPE;
13065: l_prev_asg_details csr_asg_details_dn%ROWTYPE;

Line 13062: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;

13058: l_event_group pay_event_groups.event_group_name%TYPE := 'PQP_GB_TP_ASG_EMP_CAT';
13059:
13060: -- Rowtype Variable Declaration
13061: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
13062: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
13063:
13064: l_asg_details csr_asg_details_dn%ROWTYPE;
13065: l_prev_asg_details csr_asg_details_dn%ROWTYPE;
13066:

Line 13209: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;

13205: l_itr NUMBER(5);
13206: l_new_event_itr NUMBER(5);
13207:
13208: -- Rowtype Variable Declaration
13209: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
13210: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
13211:
13212: l_proc_name VARCHAR2(61):=
13213: g_proc_name||'store_event_grp_changes';

Line 13210: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;

13206: l_new_event_itr NUMBER(5);
13207:
13208: -- Rowtype Variable Declaration
13209: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
13210: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
13211:
13212: l_proc_name VARCHAR2(61):=
13213: g_proc_name||'store_event_grp_changes';
13214:

Line 13296: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;

13292:
13293: l_event_group pay_event_groups.event_group_name%TYPE;
13294:
13295: -- Rowtype Variable Declaration
13296: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
13297: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
13298:
13299: l_rate_types t_rate_types;
13300: l_element_set csr_element_set%ROWTYPE;

Line 13297: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;

13293: l_event_group pay_event_groups.event_group_name%TYPE;
13294:
13295: -- Rowtype Variable Declaration
13296: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
13297: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
13298:
13299: l_rate_types t_rate_types;
13300: l_element_set csr_element_set%ROWTYPE;
13301: l_element_entries csr_element_entries%ROWTYPE;