DBA Data[Home] [Help]

APPS.PAY_NL_WAGE_REPORT_PKG dependencies on PAY_INTERPRETER_PKG

Line 9272: PROCEDURE copy(p_copy_from IN OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type

9268: --
9269: --------------------------------------------------------------------------------
9270: -- COPY
9271: --------------------------------------------------------------------------------
9272: PROCEDURE copy(p_copy_from IN OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type
9273: ,p_from IN NUMBER
9274: ,p_copy_to IN OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type
9275: ,p_to IN NUMBER) IS
9276: BEGIN

Line 9274: ,p_copy_to IN OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type

9270: -- COPY
9271: --------------------------------------------------------------------------------
9272: PROCEDURE copy(p_copy_from IN OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type
9273: ,p_from IN NUMBER
9274: ,p_copy_to IN OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type
9275: ,p_to IN NUMBER) IS
9276: BEGIN
9277: --
9278: p_copy_to(p_to).dated_table_id := p_copy_from(p_from).dated_table_id;

Line 9296: PROCEDURE sort_changes(p_detail_tab IN OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type) IS

9292: --
9293: --------------------------------------------------------------------------------
9294: -- SORT_CHANGES
9295: --------------------------------------------------------------------------------
9296: PROCEDURE sort_changes(p_detail_tab IN OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type) IS
9297: --
9298: l_temp_table pay_interpreter_pkg.t_detailed_output_table_type;
9299: --
9300: BEGIN

Line 9298: l_temp_table pay_interpreter_pkg.t_detailed_output_table_type;

9294: -- SORT_CHANGES
9295: --------------------------------------------------------------------------------
9296: PROCEDURE sort_changes(p_detail_tab IN OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type) IS
9297: --
9298: l_temp_table pay_interpreter_pkg.t_detailed_output_table_type;
9299: --
9300: BEGIN
9301: IF p_detail_tab.count > 0 THEN
9302: FOR i IN p_detail_tab.first..p_detail_tab.last LOOP

Line 9342: ,p_detail_tab IN OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type) IS

9338: ,p_start_date IN DATE
9339: ,p_end_date IN DATE
9340: ,p_ass_start_date IN DATE
9341: ,p_event_group_id IN pay_event_groups.event_group_id%TYPE
9342: ,p_detail_tab IN OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type) IS
9343: CURSOR csr_get_element_entries(c_assignment_id NUMBER
9344: ,c_eff_date DATE) IS
9345: SELECT peef.element_entry_id
9346: FROM pay_element_entries_f peef

Line 9369: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;

9365: WHERE assignment_extra_info_id = c_a_extra_info_id
9366: AND aei_information_category IN ('NL_LBR','NL_INF','NL_TML','NL_LHI','NL_SII'--);
9367: ,'NL_MEI','NL_WMR'); /*LC 2010*/
9368: --
9369: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
9370: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
9371: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
9372: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
9373: --

Line 9370: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;

9366: AND aei_information_category IN ('NL_LBR','NL_INF','NL_TML','NL_LHI','NL_SII'--);
9367: ,'NL_MEI','NL_WMR'); /*LC 2010*/
9368: --
9369: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
9370: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
9371: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
9372: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
9373: --
9374: l_index NUMBER;

Line 9371: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;

9367: ,'NL_MEI','NL_WMR'); /*LC 2010*/
9368: --
9369: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
9370: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
9371: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
9372: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
9373: --
9374: l_index NUMBER;
9375: l_cnt NUMBER;

Line 9372: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;

9368: --
9369: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
9370: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
9371: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
9372: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
9373: --
9374: l_index NUMBER;
9375: l_cnt NUMBER;
9376: l_eff_date DATE;

Line 9402: pay_interpreter_pkg.entry_affected(

9398: l_cnt := 1;
9399: FOR c_rec IN csr_get_element_entries(p_assignment_id,p_end_date) LOOP
9400: --##--Fnd_file.put_line(FND_FILE.LOG,'####### Calling interpretor for element_entry_id : '||c_rec.element_entry_id);
9401: BEGIN
9402: pay_interpreter_pkg.entry_affected(
9403: p_element_entry_id => c_rec.element_entry_id
9404: ,p_assignment_action_id => NULL
9405: ,p_assignment_id => p_assignment_id
9406: ,p_mode => 'REPORTS'

Line 9480: pay_interpreter_pkg.entry_affected(

9476: END LOOP;
9477: IF l_cnt = 1 THEN
9478: --##--Fnd_file.put_line(FND_FILE.LOG,'####### Calling interpretor for assignment : '||p_assignment_id);
9479: BEGIN
9480: pay_interpreter_pkg.entry_affected(
9481: p_element_entry_id => NULL
9482: ,p_assignment_action_id => NULL
9483: ,p_assignment_id => p_assignment_id
9484: ,p_mode => 'REPORTS'

Line 10055: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;

10051: --
10052: l_small_job pay_run_result_values.result_value%TYPE; /*LC 2010*/
10053: l_assg_small_job pay_run_result_values.result_value%TYPE; /*LC 2010*/
10054: --
10055: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
10056: l_event_group_id pay_event_groups.event_group_id%TYPE;
10057: l_assignment_id NUMBER;
10058: l_event_group_name VARCHAR2(50) := 'NL_WAGES_REPORT_EVG';
10059: l_chk VARCHAR2(2);