DBA Data[Home] [Help]

APPS.PAY_IN_EOY_REPORTS dependencies on PAY_IN_EOY_REPORTS

Line 1: PACKAGE BODY pay_in_eoy_reports AS

1: PACKAGE BODY pay_in_eoy_reports AS
2: /* $Header: pyineoyr.pkb 120.21.12010000.3 2008/08/06 07:26:46 ubhat ship $ */
3: g_tmp_clob CLOB;
4: g_clob_cnt NUMBER;
5: g_fetch_clob_cnt NUMBER;

Line 17: g_package CONSTANT VARCHAR2(100) := 'pay_in_eoy_reports.';

13:
14: g_index NUMBER;
15: g_index_16aa NUMBER;
16: g_debug BOOLEAN ;
17: g_package CONSTANT VARCHAR2(100) := 'pay_in_eoy_reports.';
18:
19: TYPE record_type IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;
20: t_table_1 record_type;
21: t_table_surcharge record_type;

Line 523: , pay_in_eoy_reports.get_location_details ( TO_NUMBER(action_information7)

519: , UPPER(Action_information14) rep_father_value
520: , 'REP_POSITION' rep_designation
521: , Action_information13 rep_designation_value
522: , 'PLACE' gre_place
523: , pay_in_eoy_reports.get_location_details ( TO_NUMBER(action_information7)
524: , NULL
525: , 'CITY') gre_place_value
526: FROM pay_action_information
527: WHERE action_context_id = p_action_context_id

Line 2214: -- g_package := 'pay_in_eoy_reports';

2210:
2211: -- Initialize Globals
2212: g_clob_cnt := 0;
2213: g_fetch_clob_cnt := 0;
2214: -- g_package := 'pay_in_eoy_reports';
2215: g_chunk_size := 10;
2216: g_salary_record(1).Name := 'SECTION_17_1';
2217: g_salary_record(2).Name := 'SECTION_17_2';
2218: g_salary_record(3).Name := 'SECTION_17_3';

Line 2240: END PAY_IN_EOY_REPORTS;

2236: g_salary_record(21).Name := 'BALANCE_TAX';
2237: g_salary_record(22).Name := 'EMPLOYER_TAX';
2238: g_salary_record(23).Name := 'TDS_DEDUCTED';
2239:
2240: END PAY_IN_EOY_REPORTS;