DBA Data[Home] [Help]

APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on PAY_INTERPRETER_PKG

Line 1109: p_per_events IN pay_interpreter_pkg.t_detailed_output_table_type

1105:
1106: END arch_pay_action_level_data;
1107:
1108: PROCEDURE chk_person_rec_chng (
1109: p_per_events IN pay_interpreter_pkg.t_detailed_output_table_type
1110: ) IS
1111:
1112: lv_old_value VARCHAR2(150);
1113: lv_new_value VARCHAR2(150);

Line 2464: pay_interpreter_pkg.t_detailed_output_table_type

2460: ,p_gre_id IN NUMBER
2461: ,p_eff_start_date IN DATE
2462: ,p_eff_end_date IN DATE
2463: ,p_asg_events IN
2464: pay_interpreter_pkg.t_detailed_output_table_type
2465: ,p_exc_start_date IN VARCHAR2
2466: ,p_exc_end_date IN VARCHAR2
2467: ) IS
2468:

Line 3511: int_pkg_events pay_interpreter_pkg.t_detailed_output_table_type;

3507:
3508: ln_gre_id NUMBER;
3509: ln_event_group_id NUMBER;
3510:
3511: int_pkg_events pay_interpreter_pkg.t_detailed_output_table_type;
3512: --asg_events_table t_int_asg_event_table;
3513: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
3514: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
3515: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;

Line 3513: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;

3509: ln_event_group_id NUMBER;
3510:
3511: int_pkg_events pay_interpreter_pkg.t_detailed_output_table_type;
3512: --asg_events_table t_int_asg_event_table;
3513: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
3514: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
3515: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
3516: l_global_env pay_interpreter_pkg.t_global_env_rec;
3517: l_dynamic_sql pay_interpreter_pkg.t_dynamic_sql_tab;

Line 3514: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;

3510:
3511: int_pkg_events pay_interpreter_pkg.t_detailed_output_table_type;
3512: --asg_events_table t_int_asg_event_table;
3513: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
3514: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
3515: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
3516: l_global_env pay_interpreter_pkg.t_global_env_rec;
3517: l_dynamic_sql pay_interpreter_pkg.t_dynamic_sql_tab;
3518:

Line 3515: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;

3511: int_pkg_events pay_interpreter_pkg.t_detailed_output_table_type;
3512: --asg_events_table t_int_asg_event_table;
3513: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
3514: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
3515: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
3516: l_global_env pay_interpreter_pkg.t_global_env_rec;
3517: l_dynamic_sql pay_interpreter_pkg.t_dynamic_sql_tab;
3518:
3519:

Line 3516: l_global_env pay_interpreter_pkg.t_global_env_rec;

3512: --asg_events_table t_int_asg_event_table;
3513: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
3514: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
3515: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
3516: l_global_env pay_interpreter_pkg.t_global_env_rec;
3517: l_dynamic_sql pay_interpreter_pkg.t_dynamic_sql_tab;
3518:
3519:
3520: asg_events pay_interpreter_pkg.t_detailed_output_table_type;

Line 3517: l_dynamic_sql pay_interpreter_pkg.t_dynamic_sql_tab;

3513: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
3514: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
3515: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
3516: l_global_env pay_interpreter_pkg.t_global_env_rec;
3517: l_dynamic_sql pay_interpreter_pkg.t_dynamic_sql_tab;
3518:
3519:
3520: asg_events pay_interpreter_pkg.t_detailed_output_table_type;
3521: per_events pay_interpreter_pkg.t_detailed_output_table_type;

Line 3520: asg_events pay_interpreter_pkg.t_detailed_output_table_type;

3516: l_global_env pay_interpreter_pkg.t_global_env_rec;
3517: l_dynamic_sql pay_interpreter_pkg.t_dynamic_sql_tab;
3518:
3519:
3520: asg_events pay_interpreter_pkg.t_detailed_output_table_type;
3521: per_events pay_interpreter_pkg.t_detailed_output_table_type;
3522: ele_events pay_interpreter_pkg.t_detailed_output_table_type;
3523: eev_events pay_interpreter_pkg.t_detailed_output_table_type;
3524: asg_count NUMBER;

Line 3521: per_events pay_interpreter_pkg.t_detailed_output_table_type;

3517: l_dynamic_sql pay_interpreter_pkg.t_dynamic_sql_tab;
3518:
3519:
3520: asg_events pay_interpreter_pkg.t_detailed_output_table_type;
3521: per_events pay_interpreter_pkg.t_detailed_output_table_type;
3522: ele_events pay_interpreter_pkg.t_detailed_output_table_type;
3523: eev_events pay_interpreter_pkg.t_detailed_output_table_type;
3524: asg_count NUMBER;
3525: per_count NUMBER;

Line 3522: ele_events pay_interpreter_pkg.t_detailed_output_table_type;

3518:
3519:
3520: asg_events pay_interpreter_pkg.t_detailed_output_table_type;
3521: per_events pay_interpreter_pkg.t_detailed_output_table_type;
3522: ele_events pay_interpreter_pkg.t_detailed_output_table_type;
3523: eev_events pay_interpreter_pkg.t_detailed_output_table_type;
3524: asg_count NUMBER;
3525: per_count NUMBER;
3526: ele_count NUMBER;

Line 3523: eev_events pay_interpreter_pkg.t_detailed_output_table_type;

3519:
3520: asg_events pay_interpreter_pkg.t_detailed_output_table_type;
3521: per_events pay_interpreter_pkg.t_detailed_output_table_type;
3522: ele_events pay_interpreter_pkg.t_detailed_output_table_type;
3523: eev_events pay_interpreter_pkg.t_detailed_output_table_type;
3524: asg_count NUMBER;
3525: per_count NUMBER;
3526: ele_count NUMBER;
3527: eev_count NUMBER;

Line 3586: pay_interpreter_pkg.entry_affected(

3582:
3583: hr_utility.set_location(gv_package || lv_procedure_name, 40);
3584: ln_step := 4;
3585:
3586: pay_interpreter_pkg.entry_affected(
3587: p_element_entry_id => NULL
3588: ,p_assignment_action_id => NULL
3589: ,p_assignment_id => p_assignment_id
3590: ,p_mode => NULL

Line 3605: hr_utility_trace('pay_interpreter_pkg.entry_affected Returned Rows');

3601: ,t_proration_type => l_pro_type_tab);
3602:
3603: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3604: ln_step := 5;
3605: hr_utility_trace('pay_interpreter_pkg.entry_affected Returned Rows');
3606:
3607: IF int_pkg_events.COUNT > 0 THEN
3608:
3609: FOR i IN 1..int_pkg_events.COUNT