[Home] [Help]
PACKAGE: APPS.GL_GLXJETAX_XMLP_PKG
Source
1 PACKAGE GL_GLXJETAX_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: GLXJETAXS.pls 120.1 2008/01/02 05:58:05 vijranga noship $ */
3 P_LEDGER_ID number;
4 P_CHART_OF_ACCOUNTS_ID number;
5 P_LOW_BAL_SEG varchar2(25);
6 CP_START_DATE varchar2(25);
7 CP_END_DATE varchar2(25);
8 P_HIGH_BAL_SEG varchar2(25);
9 P_TAX_TYPE varchar2(1);
10 P_TAX_CODE varchar2(50);
11 P_START_DATE date;
12 P_END_DATE date;
13 P_POSTING_STATUS varchar2(1);
14 P_CONC_REQUEST_ID number;
15 P_ACCESS_SET_ID number;
16 C_OLD_GROUPS varchar2(2000);
17 C_OLD_HEADER_ID number;
18 C_RUN_ACCOUNTED_DR number;
19 C_RUN_ACCOUNTED_CR number;
20 H_LEDGER_NAME varchar2(30);
21 H_CURRENCY_CODE varchar2(15);
22 H_POSTING_MEANING varchar2(30);
23 H_ACCESS_SET_NAME varchar2(30);
24 P_BAL_SEGMENT varchar2(600) := '(gcc1.SEGMENT1||gcc1.SEGMENT2||gcc1.SEGMENT3||gcc1.SEGMENT4||gcc1.SEGMENT5||gcc1.SEGMENT6||gcc1.SEGMENT7||gcc1.SEGMENT8||gcc1.SEGMENT9||gcc1.SEGMENT10||gcc1.SEGMENT11||
25 gcc1.SEGMENT12||gcc1.SEGMENT13||gcc1.SEGMENT14||gcc1.SEGMENT15||gcc1.SEGMENT16||gcc1.SEGMENT17||
26 gcc1.SEGMENT18||gcc1.SEGMENT19||gcc1.SEGMENT20||gcc1.SEGMENT21||gcc1.SEGMENT22||gcc1.SEGMENT23||gcc1.SEGMENT24||gcc1.SEGMENT25||gcc1.SEGMENT26||gcc1.SEGMENT27||gcc1.SEGMENT28||gcc1.SEGMENT29||gcc1.SEGMENT30)' ;
27 P_TAXABLE_ACC_SEGMENT varchar2(6000) := '(gcc1.SEGMENT1||gcc1.SEGMENT2||gcc1.SEGMENT3||gcc1.SEGMENT4||gcc1.SEGMENT5||gcc1.SEGMENT6||gcc1.SEGMENT7||gcc1.SEGMENT8||gcc1.SEGMENT9||gcc1.SEGMENT10||
28 gcc1.SEGMENT11||gcc1.SEGMENT12||gcc1.SEGMENT13||gcc1.SEGMENT14||gcc1.SEGMENT15||gcc1.SEGMENT16||gcc1.SEGMENT17||gcc1.SEGMENT18||gcc1.SEGMENT19||gcc1.SEGMENT20||gcc1.SEGMENT21||gcc1.SEGMENT22||
29 gcc1.SEGMENT23||gcc1.SEGMENT24||gcc1.SEGMENT25||gcc1.SEGMENT26||gcc1.SEGMENT27||gcc1.SEGMENT28||gcc1.SEGMENT29||gcc1.SEGMENT30)' ;
30 P_TAX_ACC_SEGMENT varchar2(6000) := '(gcc2.SEGMENT1||gcc2.SEGMENT2||gcc2.SEGMENT3||gcc2.SEGMENT4||gcc2.SEGMENT5||gcc2.SEGMENT6||gcc2.SEGMENT7||gcc2.SEGMENT8||gcc2.SEGMENT9||
31 gcc2.SEGMENT10||gcc2.SEGMENT11||gcc2.SEGMENT12||gcc2.SEGMENT13||gcc2.SEGMENT14||gcc2.SEGMENT15||gcc2.SEGMENT16||gcc2.SEGMENT17||gcc2.SEGMENT18||gcc2.SEGMENT19||gcc2.SEGMENT20||
32 gcc2.SEGMENT21||gcc2.SEGMENT22||gcc2.SEGMENT23||gcc2.SEGMENT24||gcc2.SEGMENT25||gcc2.SEGMENT26||gcc2.SEGMENT27||gcc2.SEGMENT28||gcc2.SEGMENT29||gcc2.SEGMENT30)' ;
33 P_WHERE_BAL_SEGMENT varchar2(300) := 'gcc1.segment1 between '||'00'||' and '||'ZZ' ;
34 P_WHERE_POSTING_STATUS varchar2(100) := 'gjb.status'||''''||' = '||'U' ;
35 P_WHERE_TAX varchar2(300) := '1 = 1' ;
36 --P_WHERE_DAS varchar2(600);
37 P_WHERE_DAS varchar2(600) := '1 = 1' ;
38 function BeforeReport return boolean ;
39 function AfterReport return boolean ;
40 function c_dr_or_crformula(C_TAXABLE_ACC_DR in number, C_TAXABLE_ACC_CR in number) return varchar2 ;
41 function c_taxable_acc_amountformula(C_TAXABLE_ACC_DR in number, C_TAXABLE_ACC_CR in number) return number ;
42 function c_accounted_amountformula(C_ACCOUNTED_DR in number, C_ACCOUNTED_CR in number) return number ;
43 function c_grossformula(C_GROSS_DR in number, C_GROSS_CR in number) return number ;
44 function c_gross_drformula(C_TAXABLE_ACC_DR in number, C_ACCOUNTED_DR in number) return number ;
45 function c_gross_crformula(C_TAXABLE_ACC_CR in number, C_ACCOUNTED_CR in number) return number ;
46 function c_jou_grossformula(C_JOU_GROSS_DR in number, C_JOU_GROSS_CR in number) return number ;
47 function c_jou_accounted_sumformula(C_JOU_ACCOUNTED_DR in number, C_JOU_ACCOUNTED_CR in number) return number ;
48 function c_jou_taxable_acc_sumformula(C_JOU_TAXABLE_ACC_DR in number, C_JOU_TAXABLE_ACC_CR in number) return number ;
49 function c_jou_gross_drformula(C_JOU_TAXABLE_ACC_DR in number, C_JOU_ACCOUNTED_DR in number) return number ;
50 function c_jou_gross_crformula(C_JOU_TAXABLE_ACC_CR in number, C_JOU_ACCOUNTED_CR in number) return number ;
51 function c_tax_codeformula(C_TAX_TYPE_CODE in varchar2, C_TAX_CODE_ID in number) return varchar2 ;
52 function c_jou_dr_or_crformula(C_JOU_TAXABLE_ACC_DR in number, C_JOU_TAXABLE_ACC_CR in number) return varchar2 ;
53 function C_OLD_GROUPSFormula return VARCHAR2 ;
54 function c_new_groupformula(C_JE_HEADER_ID in number, C_TAX_GROUP_ID in number, C_ACCOUNTED_DR in number, C_ACCOUNTED_CR in number) return varchar2 ;
55 function C_OLD_HEADER_IDFormula return Number ;
56 function C_RUN_ACCOUNTED_DRFormula return Number ;
57 function C_RUN_ACCOUNTED_CRFormula return Number ;
58 function g_taxablegroupfilter(ACC_SECURE in varchar2) return boolean ;
59 function g_bal_segmentgroupfilter(BAL_SECURE in varchar2) return boolean ;
60 Function C_OLD_GROUPS_p return varchar2;
61 Function C_OLD_HEADER_ID_p return number;
62 Function C_RUN_ACCOUNTED_DR_p return number;
63 Function C_RUN_ACCOUNTED_CR_p return number;
64 Function H_LEDGER_NAME_p return varchar2;
65 Function H_CURRENCY_CODE_p return varchar2;
66 Function H_POSTING_MEANING_p return varchar2;
67 Function H_ACCESS_SET_NAME_p return varchar2;
68 Function P_BAL_SEGMENT_p return varchar2;
69 Function P_TAXABLE_ACC_SEGMENT_p return varchar2;
70 Function P_TAX_ACC_SEGMENT_p return varchar2;
71 Function P_WHERE_BAL_SEGMENT_p return varchar2;
72 Function P_WHERE_POSTING_STATUS_p return varchar2;
73 Function P_WHERE_TAX_p return varchar2;
74 Function P_WHERE_DAS_p return varchar2;
75 END GL_GLXJETAX_XMLP_PKG;
76
77