eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.PAY_PAYJPWTM_XMLP_PKG

Source


1 PACKAGE PAY_PAYJPWTM_XMLP_PKG AS
2 /* $Header: PAYJPWTMS.pls 120.2 2008/04/02 10:31:58 amakrish noship $ */
3 	P_BUSINESS_GROUP_ID NUMBER;
4   P_YEAR NUMBER;
5   P_ITAX_ORGANIZATION_ID NUMBER;
6   P_ITAX_ORGANIZATION_ID1 NUMBER;
7   P_ITAX_ORGANIZATION_ID2 NUMBER;
8   P_ITAX_ORGANIZATION_ID3 NUMBER;
9   P_ITAX_ORGANIZATION_ID4 NUMBER;
10   P_ITAX_ORGANIZATION_ID5 NUMBER;
11   P_ITAX_ORGANIZATION_ID6 NUMBER;
12   P_ITAX_ORGANIZATION_ID7 NUMBER;
13   P_ITAX_ORGANIZATION_ID8 NUMBER;
14   P_ITAX_ORGANIZATION_ID9 NUMBER;
15   P_ITAX_ORGANIZATION_ID10 NUMBER;
16   P_KANJI_FLAG VARCHAR2(10);
17   P_CHARACTER_SET VARCHAR2(30);
18   P_CONC_REQUEST_ID NUMBER;
19   P_MEDIA_TYPE VARCHAR2(30);
20   P_MAGNETIC_FILE_NAME VARCHAR2(80);
21   P_ADDITIONAL_WHERE_CLAUSE VARCHAR2(2000):=' ';
22   P_START_DATE DATE;
23   P_END_DATE DATE;
24   P_ADDITIONAL_WHERE_CLAUSE2 VARCHAR2(2000):=' ';
25   P_USE_ARCHIVE_FLAG VARCHAR2(1);
26   CP_EMPLOYER_ADDRESS VARCHAR2(450);
27   CP_EMPLOYER_NAME VARCHAR2(150);
28   CP_EMPLOYER_TELEPHONE_NUMBER VARCHAR2(150);
29   CP_ITAX_ORG_NUMBER NUMBER := 0;
30   CP_TAXABLE_INCOME NUMBER;
31   CP_NET_TAXABLE_INCOME NUMBER;
32   CP_TOTAL_INCOME_EXEMPT NUMBER;
33   CP_WITHHOLDING_ITAX NUMBER;
34   CP_SPOUSE_SP_EXEMPT NUMBER;
35   CP_SI_PREM NUMBER;
36   CP_MUTUAL_AID_PREM NUMBER;
37   CP_LI_PREM_EXEMPT NUMBER;
38   CP_AI_PREM_EXEMPT NUMBER;
39   CP_HOUSING_TAX_REDUCTION NUMBER;
40   CP_PP_PREM NUMBER;
41   CP_SPOUSE_NET_TAXABLE_INCOME NUMBER;
42   CP_LONG_AI_PREM NUMBER;
43   CP_DISASTER_TAX_REDUCTION NUMBER;
44   CP_FOREIGN_ADDRESS VARCHAR2(1);
45   CP_DEP_SPOUSE VARCHAR2(1);
46   CP_AGED_SPOUSE VARCHAR2(1);
47   CP_NUM_SPECIFIEDS_KOU NUMBER;
48   CP_NUM_SPECIFIEDS_OTSU NUMBER;
49   CP_NUM_AGEDS_KOU NUMBER;
50   CP_NUM_AGED_PARENTS_LT NUMBER;
51   CP_NUM_AGEDS_OTSU NUMBER;
52   CP_NUM_DEPS_KOU NUMBER;
53   CP_NUM_DEPS_OTSU NUMBER;
54   CP_NUM_SVR_DISABLEDS NUMBER;
55   CP_NUM_SVR_DISABLEDS_LT NUMBER;
56   CP_NUM_DISABLEDS NUMBER;
57   CP_BIRTH_ERA VARCHAR2(1);
58   CP_BIRTH_YEAR NUMBER;
59   CP_BIRTH_MONTH NUMBER;
60   CP_BIRTH_DAY NUMBER;
61   CP_HUSBAND_EXISTS VARCHAR2(1);
62   CP_MINOR VARCHAR2(1);
63   CP_OTSU VARCHAR2(1);
64   CP_SVR_DISABLED VARCHAR2(1);
65   CP_DISABLED VARCHAR2(1);
66   CP_AGED VARCHAR2(1);
67   CP_WIDOW VARCHAR2(1);
68   CP_WIDOWER VARCHAR2(1);
69   CP_WORKING_STUDENT VARCHAR2(1);
70   CP_DECEASED_TERMINATION VARCHAR2(1);
71   CP_DISASTERED VARCHAR2(1);
72   CP_FOREIGNER VARCHAR2(1);
73   CP_EMPLOYED VARCHAR2(1);
74   CP_EMPLOYMENT_YEAR NUMBER;
75   CP_EMPLOYMENT_MONTH NUMBER;
76   CP_EMPLOYMENT_DAY NUMBER;
77   CP_HOUSING_RESIDENCE_YEAR NUMBER;
78   CP_HOUSING_RESIDENCE_MONTH NUMBER;
79   CP_HOUSING_RESIDENCE_DAY NUMBER;
80   CP_PREV_JOB_TERMINATION_YEAR NUMBER;
81   CP_PREV_JOB_TERMINATION_MONTH NUMBER;
82   CP_PREV_JOB_TERMINATION_DAY NUMBER;
83   CP_PREV_JOB_EMPLOYER_NAME VARCHAR2(150);
84   CP_PREV_JOB_FOREIGN_ADDRESS VARCHAR2(1);
85   CP_PREV_JOB_EMPLOYER_ADDRESS VARCHAR2(450);
86   CP_PREV_JOB_TAXABLE_INCOME NUMBER;
87   CP_PREV_JOB_ITAX NUMBER;
88   CP_PREV_JOB_SI_PREM NUMBER;
89   CP_ORIGINAL_DESCRIPTION VARCHAR2(32767);
90   CP_DESCRIPTION VARCHAR2(32767);
91   CP_SUBMISSION_REQUIRED_FLAG VARCHAR2(1);
92   CP_COUNT NUMBER;
93   CP_TAXABLE_INCOME_SUM NUMBER;
94   CP_ITAX_SUM NUMBER;
95   CP_EARNINGS_TYPE VARCHAR2(255);
96   CP_MAGNETIC_FILE_NAME VARCHAR2(40);
97   CP_REPORT_TITLE VARCHAR2(255);
98   CP_KANJI_FLAG VARCHAR2(1);
99   CP_HQ_REFERENCE_NUMBER1 VARCHAR2(150);
100   CP_HQ_REFERENCE_NUMBER2 VARCHAR2(150);
101   CP_HQ_EMPLOYER_ADDRESS VARCHAR2(150);
102   CP_HQ_EMPLOYER_NAME VARCHAR2(150);
103   CP_BG_DPNT_REF_TYPE VARCHAR2(30);
104   CP_YEAR NUMBER;
105   FUNCTION AFTERPFORM RETURN BOOLEAN;
106   FUNCTION BEFOREREPORT RETURN BOOLEAN;
107   FUNCTION AFTERREPORT RETURN BOOLEAN;
108   FUNCTION TO_JP_CHAR(P_DATE IN DATE ,P_DATE_FORMAT IN VARCHAR2) RETURN VARCHAR2;
109   FUNCTION CF_ASSACTFORMULULA(ASSIGNMENT_ACTION_ID IN NUMBER,ASSIGNMENT_ID IN NUMBER,ACTION_SEQUENCE IN NUMBER,EFFECTIVE_DATE IN DATE,
110     DATE_EARNED IN DATE,ITAX_ORGANIZATION_ID IN NUMBER,ITAX_CATEGORY IN VARCHAR2,ITAX_YEA_CATEGORY IN VARCHAR2,DPNT_REF_TYPE IN VARCHAR2,
111     DPNT_EFFECTIVE_DATE IN DATE,PERSON_ID IN NUMBER,SEX IN VARCHAR2,DATE_OF_BIRTH IN DATE,LEAVING_REASON IN VARCHAR2,LAST_NAME_KANJI IN VARCHAR2,
112     LAST_NAME_KANA IN VARCHAR2,EMPLOYMENT_CATEGORY IN VARCHAR2,ARCHIVE_ASSIGNMENT_ACTION_ID IN NUMBER,SUBMISSION_REQUIRED_FLAG IN VARCHAR2,
113     ADDRESS_ID IN NUMBER,COUNTRY IN VARCHAR2,JP_DATE_OF_BIRTH IN VARCHAR2,JP_ACTUAL_TERMINATION_DATE IN VARCHAR2,JP_DATE_START IN VARCHAR2)
114   RETURN NUMBER;
115   PROCEDURE TRACE(P_TEXT IN VARCHAR2);
116   FUNCTION CF_ITAX_ORGFORMULA(CS_COUNT IN NUMBER,ITAX_ORGANIZATION_ID IN NUMBER) RETURN NUMBER;
117   FUNCTION CP_EMPLOYER_ADDRESS_P RETURN VARCHAR2;
118   FUNCTION CP_EMPLOYER_NAME_P RETURN VARCHAR2;
119   FUNCTION CP_EMPLOYER_TELEPHONE_NUMBER_P RETURN VARCHAR2;
120   FUNCTION CP_ITAX_ORG_NUMBER_P RETURN NUMBER;
121   FUNCTION CP_TAXABLE_INCOME_P RETURN NUMBER;
122   FUNCTION CP_NET_TAXABLE_INCOME_P RETURN NUMBER;
123   FUNCTION CP_TOTAL_INCOME_EXEMPT_P RETURN NUMBER;
124   FUNCTION CP_WITHHOLDING_ITAX_P RETURN NUMBER;
125   FUNCTION CP_SPOUSE_SP_EXEMPT_P RETURN NUMBER;
126   FUNCTION CP_SI_PREM_P RETURN NUMBER;
127   FUNCTION CP_MUTUAL_AID_PREM_P RETURN NUMBER;
128   FUNCTION CP_LI_PREM_EXEMPT_P RETURN NUMBER;
129   FUNCTION CP_AI_PREM_EXEMPT_P RETURN NUMBER;
130   FUNCTION CP_HOUSING_TAX_REDUCTION_P RETURN NUMBER;
131   FUNCTION CP_PP_PREM_P RETURN NUMBER;
132   FUNCTION CP_SPOUSE_NET_TAXABLE_INCOME_P RETURN NUMBER;
133   FUNCTION CP_LONG_AI_PREM_P RETURN NUMBER;
134   FUNCTION CP_DISASTER_TAX_REDUCTION_P RETURN NUMBER;
135   FUNCTION CP_FOREIGN_ADDRESS_P RETURN VARCHAR2;
136   FUNCTION CP_DEP_SPOUSE_P RETURN VARCHAR2;
137   FUNCTION CP_AGED_SPOUSE_P RETURN VARCHAR2;
138   FUNCTION CP_NUM_SPECIFIEDS_KOU_P RETURN NUMBER;
139   FUNCTION CP_NUM_SPECIFIEDS_OTSU_P RETURN NUMBER;
140   FUNCTION CP_NUM_AGEDS_KOU_P RETURN NUMBER;
141   FUNCTION CP_NUM_AGED_PARENTS_LT_P RETURN NUMBER;
142   FUNCTION CP_NUM_AGEDS_OTSU_P RETURN NUMBER;
143   FUNCTION CP_NUM_DEPS_KOU_P RETURN NUMBER;
144   FUNCTION CP_NUM_DEPS_OTSU_P RETURN NUMBER;
145   FUNCTION CP_NUM_SVR_DISABLEDS_P RETURN NUMBER;
146   FUNCTION CP_NUM_SVR_DISABLEDS_LT_P RETURN NUMBER;
147   FUNCTION CP_NUM_DISABLEDS_P RETURN NUMBER;
148   FUNCTION CP_BIRTH_ERA_P RETURN VARCHAR2;
149   FUNCTION CP_BIRTH_YEAR_P RETURN NUMBER;
150   FUNCTION CP_BIRTH_MONTH_P RETURN NUMBER;
151   FUNCTION CP_BIRTH_DAY_P RETURN NUMBER;
152   FUNCTION CP_HUSBAND_EXISTS_P RETURN VARCHAR2;
153   FUNCTION CP_MINOR_P RETURN VARCHAR2;
154   FUNCTION CP_OTSU_P RETURN VARCHAR2;
155   FUNCTION CP_SVR_DISABLED_P RETURN VARCHAR2;
156   FUNCTION CP_DISABLED_P RETURN VARCHAR2;
157   FUNCTION CP_AGED_P RETURN VARCHAR2;
158   FUNCTION CP_WIDOW_P RETURN VARCHAR2;
159   FUNCTION CP_WIDOWER_P RETURN VARCHAR2;
160   FUNCTION CP_WORKING_STUDENT_P RETURN VARCHAR2;
161   FUNCTION CP_DECEASED_TERMINATION_P RETURN VARCHAR2;
162   FUNCTION CP_DISASTERED_P RETURN VARCHAR2;
163   FUNCTION CP_FOREIGNER_P RETURN VARCHAR2;
164   FUNCTION CP_EMPLOYED_P RETURN VARCHAR2;
165   FUNCTION CP_EMPLOYMENT_YEAR_P RETURN NUMBER;
166   FUNCTION CP_EMPLOYMENT_MONTH_P RETURN NUMBER;
167   FUNCTION CP_EMPLOYMENT_DAY_P RETURN NUMBER;
168   FUNCTION CP_HOUSING_RESIDENCE_YEAR_P RETURN NUMBER;
169   FUNCTION CP_HOUSING_RESIDENCE_MONTH_P RETURN NUMBER;
170   FUNCTION CP_HOUSING_RESIDENCE_DAY_P RETURN NUMBER;
171   FUNCTION CP_PREV_JOB_TERMINATION_YEAR_P RETURN NUMBER;
172   FUNCTION CP_PREV_JOB_TERMINATION_MON_p RETURN NUMBER;
173   FUNCTION CP_PREV_JOB_TERMINATION_DAY_P RETURN NUMBER;
174   FUNCTION CP_PREV_JOB_EMPLOYER_NAME_P RETURN VARCHAR2;
175   FUNCTION CP_PREV_JOB_FOREIGN_ADDRESS_P RETURN VARCHAR2;
176   FUNCTION CP_PREV_JOB_EMPLOYER_ADDRESS_P RETURN VARCHAR2;
177   FUNCTION CP_PREV_JOB_TAXABLE_INCOME_P RETURN NUMBER;
178   FUNCTION CP_PREV_JOB_ITAX_P RETURN NUMBER;
179   FUNCTION CP_PREV_JOB_SI_PREM_P RETURN NUMBER;
180   FUNCTION CP_ORIGINAL_DESCRIPTION_P RETURN VARCHAR2;
181   FUNCTION CP_DESCRIPTION_P RETURN VARCHAR2;
182   FUNCTION CP_SUBMISSION_REQUIRED_FLAG_P RETURN VARCHAR2;
183   FUNCTION CP_COUNT_P RETURN NUMBER;
184   FUNCTION CP_TAXABLE_INCOME_SUM_P RETURN NUMBER;
185   FUNCTION CP_ITAX_SUM_P RETURN NUMBER;
186   FUNCTION CP_EARNINGS_TYPE_P RETURN VARCHAR2;
187   FUNCTION CP_MAGNETIC_FILE_NAME_P RETURN VARCHAR2;
188   FUNCTION CP_REPORT_TITLE_P RETURN VARCHAR2;
189   FUNCTION CP_KANJI_FLAG_P RETURN VARCHAR2;
190   FUNCTION CP_HQ_REFERENCE_NUMBER1_P RETURN VARCHAR2;
191   FUNCTION CP_HQ_REFERENCE_NUMBER2_P RETURN VARCHAR2;
192   FUNCTION CP_HQ_EMPLOYER_ADDRESS_P RETURN VARCHAR2;
193   FUNCTION CP_HQ_EMPLOYER_NAME_P RETURN VARCHAR2;
194   FUNCTION CP_BG_DPNT_REF_TYPE_P RETURN VARCHAR2;
195   FUNCTION CP_YEAR_P RETURN NUMBER;
196   G_SPACE VARCHAR2(10) := ' ';
197  -- PROCEDURE OPEN_MAGFILE;
198   --PROCEDURE CLOSE_MAGFILE;
199  -- PROCEDURE PUT(P_TEXT IN VARCHAR2);
200  -- PROCEDURE PUT(P_TEXT IN VARCHAR2 ,P_LENGTH IN NUMBER ,P_PADDING_CHARACTER IN VARCHAR2 := G_SPACE);
201  -- PROCEDURE PUT(P_NUMBER IN NUMBER ,P_LENGTH IN NUMBER);
202  -- PROCEDURE CSV(P_TEXT IN VARCHAR2 ,P_EOR IN BOOLEAN := FALSE);
203 --  PROCEDURE CSV(P_NUMBER IN NUMBER ,P_EOR IN BOOLEAN := FALSE);
204 --  PROCEDURE CSV(P_NUMBER IN NUMBER ,P_LENGTH IN NUMBER ,P_EOR IN BOOLEAN := FALSE);
205 END PAY_PAYJPWTM_XMLP_PKG;