DBA Data[Home] [Help]

APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on PAY_INTERPRETER_PKG

Line 1036: p_per_events IN pay_interpreter_pkg.t_detailed_output_table_type

1032:
1033: END arch_pay_action_level_data;
1034:
1035: PROCEDURE chk_person_rec_chng (
1036: p_per_events IN pay_interpreter_pkg.t_detailed_output_table_type
1037: ) IS
1038:
1039: lv_old_value VARCHAR2(150);
1040: lv_new_value VARCHAR2(150);

Line 2342: pay_interpreter_pkg.t_detailed_output_table_type

2338: ,p_gre_id IN NUMBER
2339: ,p_eff_start_date IN DATE
2340: ,p_eff_end_date IN DATE
2341: ,p_asg_events IN
2342: pay_interpreter_pkg.t_detailed_output_table_type
2343: ) IS
2344:
2345: CURSOR c_get_report_term_rehire (cp_asg_id IN NUMBER) IS
2346: SELECT segment10

Line 3309: int_pkg_events pay_interpreter_pkg.t_detailed_output_table_type;

3305:
3306: ln_gre_id NUMBER;
3307: ln_event_group_id NUMBER;
3308:
3309: int_pkg_events pay_interpreter_pkg.t_detailed_output_table_type;
3310: --asg_events_table t_int_asg_event_table;
3311: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
3312: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
3313: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;

Line 3311: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;

3307: ln_event_group_id NUMBER;
3308:
3309: int_pkg_events pay_interpreter_pkg.t_detailed_output_table_type;
3310: --asg_events_table t_int_asg_event_table;
3311: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
3312: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
3313: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
3314: l_global_env pay_interpreter_pkg.t_global_env_rec;
3315: l_dynamic_sql pay_interpreter_pkg.t_dynamic_sql_tab;

Line 3312: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;

3308:
3309: int_pkg_events pay_interpreter_pkg.t_detailed_output_table_type;
3310: --asg_events_table t_int_asg_event_table;
3311: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
3312: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
3313: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
3314: l_global_env pay_interpreter_pkg.t_global_env_rec;
3315: l_dynamic_sql pay_interpreter_pkg.t_dynamic_sql_tab;
3316:

Line 3313: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;

3309: int_pkg_events pay_interpreter_pkg.t_detailed_output_table_type;
3310: --asg_events_table t_int_asg_event_table;
3311: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
3312: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
3313: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
3314: l_global_env pay_interpreter_pkg.t_global_env_rec;
3315: l_dynamic_sql pay_interpreter_pkg.t_dynamic_sql_tab;
3316:
3317:

Line 3314: l_global_env pay_interpreter_pkg.t_global_env_rec;

3310: --asg_events_table t_int_asg_event_table;
3311: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
3312: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
3313: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
3314: l_global_env pay_interpreter_pkg.t_global_env_rec;
3315: l_dynamic_sql pay_interpreter_pkg.t_dynamic_sql_tab;
3316:
3317:
3318: asg_events pay_interpreter_pkg.t_detailed_output_table_type;

Line 3315: l_dynamic_sql pay_interpreter_pkg.t_dynamic_sql_tab;

3311: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
3312: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
3313: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
3314: l_global_env pay_interpreter_pkg.t_global_env_rec;
3315: l_dynamic_sql pay_interpreter_pkg.t_dynamic_sql_tab;
3316:
3317:
3318: asg_events pay_interpreter_pkg.t_detailed_output_table_type;
3319: per_events pay_interpreter_pkg.t_detailed_output_table_type;

Line 3318: asg_events pay_interpreter_pkg.t_detailed_output_table_type;

3314: l_global_env pay_interpreter_pkg.t_global_env_rec;
3315: l_dynamic_sql pay_interpreter_pkg.t_dynamic_sql_tab;
3316:
3317:
3318: asg_events pay_interpreter_pkg.t_detailed_output_table_type;
3319: per_events pay_interpreter_pkg.t_detailed_output_table_type;
3320: ele_events pay_interpreter_pkg.t_detailed_output_table_type;
3321: eev_events pay_interpreter_pkg.t_detailed_output_table_type;
3322: asg_count NUMBER;

Line 3319: per_events pay_interpreter_pkg.t_detailed_output_table_type;

3315: l_dynamic_sql pay_interpreter_pkg.t_dynamic_sql_tab;
3316:
3317:
3318: asg_events pay_interpreter_pkg.t_detailed_output_table_type;
3319: per_events pay_interpreter_pkg.t_detailed_output_table_type;
3320: ele_events pay_interpreter_pkg.t_detailed_output_table_type;
3321: eev_events pay_interpreter_pkg.t_detailed_output_table_type;
3322: asg_count NUMBER;
3323: per_count NUMBER;

Line 3320: ele_events pay_interpreter_pkg.t_detailed_output_table_type;

3316:
3317:
3318: asg_events pay_interpreter_pkg.t_detailed_output_table_type;
3319: per_events pay_interpreter_pkg.t_detailed_output_table_type;
3320: ele_events pay_interpreter_pkg.t_detailed_output_table_type;
3321: eev_events pay_interpreter_pkg.t_detailed_output_table_type;
3322: asg_count NUMBER;
3323: per_count NUMBER;
3324: ele_count NUMBER;

Line 3321: eev_events pay_interpreter_pkg.t_detailed_output_table_type;

3317:
3318: asg_events pay_interpreter_pkg.t_detailed_output_table_type;
3319: per_events pay_interpreter_pkg.t_detailed_output_table_type;
3320: ele_events pay_interpreter_pkg.t_detailed_output_table_type;
3321: eev_events pay_interpreter_pkg.t_detailed_output_table_type;
3322: asg_count NUMBER;
3323: per_count NUMBER;
3324: ele_count NUMBER;
3325: eev_count NUMBER;

Line 3381: pay_interpreter_pkg.entry_affected(

3377:
3378: hr_utility.set_location(gv_package || lv_procedure_name, 40);
3379: ln_step := 4;
3380:
3381: pay_interpreter_pkg.entry_affected(
3382: p_element_entry_id => NULL
3383: ,p_assignment_action_id => NULL
3384: ,p_assignment_id => p_assignment_id
3385: ,p_mode => NULL

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

3396: ,t_proration_type => l_pro_type_tab);
3397:
3398: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3399: ln_step := 5;
3400: hr_utility_trace('pay_interpreter_pkg.entry_affected Returned Rows');
3401:
3402: IF int_pkg_events.COUNT > 0 THEN
3403:
3404: FOR i IN 1..int_pkg_events.COUNT