DBA Data[Home] [Help]

APPS.PAY_NL_WAGE_REPORT_PKG dependencies on PAY_INTERPRETER_PKG

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

5603: --
5604: --------------------------------------------------------------------------------
5605: -- COPY
5606: --------------------------------------------------------------------------------
5607: PROCEDURE copy(p_copy_from IN OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type
5608: ,p_from IN NUMBER
5609: ,p_copy_to IN OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type
5610: ,p_to IN NUMBER) IS
5611: BEGIN

Line 5609: ,p_copy_to IN OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type

5605: -- COPY
5606: --------------------------------------------------------------------------------
5607: PROCEDURE copy(p_copy_from IN OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type
5608: ,p_from IN NUMBER
5609: ,p_copy_to IN OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type
5610: ,p_to IN NUMBER) IS
5611: BEGIN
5612: --
5613: p_copy_to(p_to).dated_table_id := p_copy_from(p_from).dated_table_id;

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

5627: --
5628: --------------------------------------------------------------------------------
5629: -- SORT_CHANGES
5630: --------------------------------------------------------------------------------
5631: PROCEDURE sort_changes(p_detail_tab IN OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type) IS
5632: --
5633: l_temp_table pay_interpreter_pkg.t_detailed_output_table_type;
5634: --
5635: BEGIN

Line 5633: l_temp_table pay_interpreter_pkg.t_detailed_output_table_type;

5629: -- SORT_CHANGES
5630: --------------------------------------------------------------------------------
5631: PROCEDURE sort_changes(p_detail_tab IN OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type) IS
5632: --
5633: l_temp_table pay_interpreter_pkg.t_detailed_output_table_type;
5634: --
5635: BEGIN
5636: IF p_detail_tab.count > 0 THEN
5637: FOR i IN p_detail_tab.first..p_detail_tab.last LOOP

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

5673: ,p_start_date IN DATE
5674: ,p_end_date IN DATE
5675: ,p_ass_start_date IN DATE
5676: ,p_event_group_id IN pay_event_groups.event_group_id%TYPE
5677: ,p_detail_tab IN OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type) IS
5678: CURSOR csr_get_element_entries(c_assignment_id NUMBER
5679: ,c_eff_date DATE) IS
5680: SELECT peef.element_entry_id
5681: FROM pay_element_entries_f peef

Line 5703: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;

5699: FROM per_assignment_extra_info
5700: WHERE assignment_extra_info_id = c_a_extra_info_id
5701: AND aei_information_category IN ('NL_LBR','NL_INF','NL_TML','NL_LHI','NL_SII');
5702: --
5703: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
5704: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
5705: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
5706: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
5707: --

Line 5704: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;

5700: WHERE assignment_extra_info_id = c_a_extra_info_id
5701: AND aei_information_category IN ('NL_LBR','NL_INF','NL_TML','NL_LHI','NL_SII');
5702: --
5703: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
5704: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
5705: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
5706: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
5707: --
5708: l_index NUMBER;

Line 5705: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;

5701: AND aei_information_category IN ('NL_LBR','NL_INF','NL_TML','NL_LHI','NL_SII');
5702: --
5703: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
5704: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
5705: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
5706: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
5707: --
5708: l_index NUMBER;
5709: l_cnt NUMBER;

Line 5706: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;

5702: --
5703: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
5704: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
5705: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
5706: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
5707: --
5708: l_index NUMBER;
5709: l_cnt NUMBER;
5710: l_eff_date DATE;

Line 5736: pay_interpreter_pkg.entry_affected(

5732: l_cnt := 1;
5733: FOR c_rec IN csr_get_element_entries(p_assignment_id,p_end_date) LOOP
5734: --##--Fnd_file.put_line(FND_FILE.LOG,'####### Calling interpretor for element_entry_id : '||c_rec.element_entry_id);
5735: BEGIN
5736: pay_interpreter_pkg.entry_affected(
5737: p_element_entry_id => c_rec.element_entry_id
5738: ,p_assignment_action_id => NULL
5739: ,p_assignment_id => p_assignment_id
5740: ,p_mode => 'REPORTS'

Line 5814: pay_interpreter_pkg.entry_affected(

5810: END LOOP;
5811: IF l_cnt = 1 THEN
5812: --##--Fnd_file.put_line(FND_FILE.LOG,'####### Calling interpretor for assignment : '||p_assignment_id);
5813: BEGIN
5814: pay_interpreter_pkg.entry_affected(
5815: p_element_entry_id => NULL
5816: ,p_assignment_action_id => NULL
5817: ,p_assignment_id => p_assignment_id
5818: ,p_mode => 'REPORTS'

Line 6311: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;

6307: l_zw_insured PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6308: l_zvw_situation PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
6309: l_zvw_defaulted VARCHAR2(1);
6310: --
6311: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
6312: l_event_group_id pay_event_groups.event_group_id%TYPE;
6313: l_assignment_id NUMBER;
6314: l_event_group_name VARCHAR2(50) := 'NL_WAGES_REPORT_EVG';
6315: l_chk VARCHAR2(2);