PACKAGE: APPS.JA_JAINITCR_XMLP_PKG

Source

1 PACKAGE JA_JAINITCR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JAINITCRS.pls 120.1 2007/12/25 16:21:53 dwkrishn noship $ */
3   P_VENDOR_ID NUMBER;
4 
5   P_FROM_DATE DATE;
6 
7   P_TO_DATE DATE;
8 
9   P_CERTIFICATE_START_NO NUMBER;
10 
11   P_CERTIFICATE_END_NO NUMBER;
12 
13   P_PLACE VARCHAR2(40);
14 
15   P_NAME VARCHAR2(60);
16 
17   P_DESIGNATION VARCHAR2(40);
18 
19   P_ORGANIZATION_ID NUMBER;
20 
21   P_FIN_YEAR NUMBER;
22 
23   P_ORG_TAN_NUM VARCHAR2(50);
24 
25   P_CONC_REQUEST_ID NUMBER;
26 
27   P_SELECTED_CERT_DATE VARCHAR2(1000);
28 
29   P_SELECTED_CERT_ID VARCHAR2(1000);
30 
31   P_SELECTED_VENDOR VARCHAR2(1000);
32 
33   P_ACK_NUM_FOR_QUART_ONE VARCHAR2(70);
34 
35   P_ACK_NUM_FOR_QUART_TWO VARCHAR2(70);
36 
37   P_ACK_NUM_FOR_QUART_THREE VARCHAR2(70);
38 
39   P_ACK_NUM_FOR_QUART_FOUR VARCHAR2(70);
40 
41   CP_CESS_AMT NUMBER;
42 
43   CP_SURCHARGE_AMT NUMBER;
44 
45   CP_SH_CESS_AMT NUMBER;
46 
47   CP_1 VARCHAR2(32767);
48 
49   FUNCTION CONVERT_NUMBER(IN_NUMERAL IN INTEGER := 0) RETURN VARCHAR2;
50 
51   FUNCTION CF_3FORMULA(CS_TDS_AMOUNT IN NUMBER) RETURN VARCHAR2;
52 
53   FUNCTION AFTERREPORT RETURN BOOLEAN;
54 
55   FUNCTION BANK_BRANCHFORMULA(C_CHQ IN VARCHAR2
56                              ,TDS_INVOICE_ID IN NUMBER
57                              ,TDS_ID IN NUMBER) RETURN VARCHAR2;
58 
59   FUNCTION CF_1FORMULA RETURN VARCHAR2;
60 
61   FUNCTION CF_2FORMULA RETURN VARCHAR2;
62 
63   FUNCTION CP_1FORMULA RETURN CHAR;
64 
65   FUNCTION CF_VEN_PAN_NOFORMULA(VEN_ID IN NUMBER) RETURN CHAR;
66 
67   FUNCTION CF_CHECK_DEP_DATEFORMULA(CHQ IN NUMBER) RETURN DATE;
68 
69   FUNCTION BEFOREREPORT RETURN BOOLEAN;
70 
71   FUNCTION F_SELECTED_CERT_DATE RETURN VARCHAR2;
72 
73   FUNCTION F_SELECTED_CERT_ID RETURN VARCHAR2;
74 
75   FUNCTION F_SELECTED_VENDOR RETURN VARCHAR2;
76 
77   FUNCTION AFTERPFORM RETURN BOOLEAN;
78 
79   FUNCTION CF_TDS_AMTFORMULA(TDS_INVOICE_ID IN NUMBER
80                             ,TDS_INVOICE_AMT IN NUMBER) RETURN NUMBER;
81 
82   FUNCTION CF_BSR_CODEFORMULA(BANK_ACCOUNT_ID IN NUMBER) RETURN VARCHAR2;
83 
84   FUNCTION CP_CESS_AMT_P RETURN NUMBER;
85 
86   FUNCTION CP_SURCHARGE_AMT_P RETURN NUMBER;
87 
88   FUNCTION CP_SH_CESS_AMT_P RETURN NUMBER;
89 
90   FUNCTION CP_1_P RETURN VARCHAR2;
91 
92 END JA_JAINITCR_XMLP_PKG;
93 
94 
95