PACKAGE: APPS.JA_JAINPRRG_XMLP_PKG

Source

1 PACKAGE JA_JAINPRRG_XMLP_PKG AS
2 /* $Header: JAINPRRGS.pls 120.1 2007/12/25 16:26:22 dwkrishn noship $ */
3   P_FROM_DATE DATE;
4 
5   LP_FROM_DATE varchar2(30);
6 
7   LP_TO_DATE varchar2(30);
8 
9   P_TO_DATE DATE;
10 
11   P_ORG_ID NUMBER;
12 
13   P_VENDOR_ID NUMBER;
14 
15   P_VENDOR_SITE_ID NUMBER;
16 
17   P_RUN_NO VARCHAR2(40);
18 
19   LP_RUN_NO VARCHAR2(40);
20 
21   P_CONC_REQUEST_ID NUMBER;
22 
23   P_SOB_NAME VARCHAR2(60);
24 
25   LP_SOB_NAME VARCHAR2(60);
26 
27   P_ORG_NAME VARCHAR2(240);
28 
29   LP_ORG_NAME VARCHAR2(240);
30 
31   P_ORG_ADDR VARCHAR2(1200);
32 
33   LP_ORG_ADDR VARCHAR2(1200);
34 
35   P_COMMIT_DATA VARCHAR2(3);
36 
37   P_LINE_NO NUMBER := 0;
38 
39   P_RND_FACT VARCHAR2(2);
40 
41   CP_SERIAL NUMBER;
42 
43   FUNCTION CF_PO_NUM_N_RELEASEFORMULA(PO_NUMBER IN VARCHAR2
44                                      ,PO_RELEASE_NUM IN NUMBER) RETURN CHAR;
45 
46   FUNCTION CF_TOTAL_AMOUNTFORMULA(CS_LINE_AMOUNT IN NUMBER
47                                  ,CS_EXCISE IN NUMBER
48                                  ,CS_CVD IN NUMBER
49                                  ,CS_ADDCVD IN NUMBER
50                                  ,CS_CUSTOMS IN NUMBER
51                                  ,CS_CST IN NUMBER
52                                  ,CS_LST IN NUMBER
53                                  ,CS_FREIGHT IN NUMBER
54                                  ,CS_OCTROI IN NUMBER
55                                  ,CS_OTHERS IN NUMBER) RETURN NUMBER;
56 
57   Procedure P_ORG_ADDR1VALIDTRIGGER ;
58 
59   FUNCTION CF_VENDOR_NAMEFORMULA(VENDOR_ID IN NUMBER) RETURN CHAR;
60 
61   FUNCTION CF_VENDOR_SITE_CODEFORMULA(VENDOR_SITE_ID IN NUMBER) RETURN CHAR;
62 
63   FUNCTION AFTERPFORM RETURN BOOLEAN;
64 
65   FUNCTION AFTERREPORT RETURN BOOLEAN;
66 
67   FUNCTION G_INVOICEGROUPFILTER RETURN BOOLEAN;
68 
69   FUNCTION BEFOREREPORT RETURN BOOLEAN;
70 
71   FUNCTION CP_SERIAL_P RETURN NUMBER;
72 
73 END JA_JAINPRRG_XMLP_PKG;
74 
75