PACKAGE: APPS.AR_ARYVTSLD_XMLP_PKG

Source

1 PACKAGE AR_ARYVTSLD_XMLP_PKG AS
2 /* $Header: ARYVTSLDS.pls 120.0 2007/12/27 14:12:26 abraghun noship $ */
3   P_REPTYPE VARCHAR2(32767);
4 
5   P_STARTDATE DATE;
6 
7   P_ENDDATE DATE;
8 
9   P_CONC_REQUEST_ID NUMBER := 0;
10 
11   P_CHART_OF_ACCOUNTS_ID NUMBER;
12 
13   P_SET_OF_BOOKS_ID NUMBER;
14 
15   P_REMIT_TO_ADDRESS NUMBER;
16 
17   P_SITE_USE_CODE VARCHAR2(7);
18 
19   LP_WHERE VARCHAR2(200) := 'and 1=1';
20 
21   C_LINE_NO NUMBER;
22 
23   C_GROUP_BY VARCHAR2(240);
24 
25   C_SOBNAME VARCHAR2(60);
26 
27   C_TDR_VAT_NO VARCHAR2(60);
28 
29   C_SOBCURR VARCHAR2(20);
30 
31   C_BRANCH VARCHAR2(240);
32 
33   C_COUNTRY VARCHAR2(20);
34 
35   C_ADDR_ID NUMBER;
36 
37   C_INDUSTRY_CODE VARCHAR2(20);
38 
39   C_SALES_TITLE VARCHAR2(20);
40 
41   C_CITY VARCHAR2(60);
42 
43   C_POSTAL_CODE VARCHAR2(60);
44 
45   C_STREET VARCHAR2(240);
46 
47   FUNCTION C_CURRDATEFORMULA RETURN VARCHAR2;
48 
49   FUNCTION BEFOREREPORT RETURN BOOLEAN;
50 
51   FUNCTION INC_LINE_NO RETURN BOOLEAN;
52 
53   FUNCTION AFTERREPORT RETURN BOOLEAN;
54 
55   PROCEDURE GET_LOOKUP_MEANING(P_LOOKUP_TYPE IN VARCHAR2
56                               ,P_LOOKUP_CODE IN VARCHAR2
57                               ,P_LOOKUP_MEANING IN OUT NOCOPY VARCHAR2);
58 
59   PROCEDURE GET_BOILER_PLATES;
60 
61   FUNCTION SET_DISPLAY_FOR_CORE RETURN BOOLEAN;
62 
63   FUNCTION SET_DISPLAY_FOR_GOV RETURN BOOLEAN;
64 
65   FUNCTION CF_CURRDATEFORMULA RETURN CHAR;
66 
67   FUNCTION CF_STARTFORMULA RETURN CHAR;
68 
69   FUNCTION CF_1FORMULA RETURN CHAR;
70 
71   FUNCTION AFTERPFORM RETURN BOOLEAN;
72 
73   FUNCTION C_LINE_NO_P RETURN NUMBER;
74 
75   FUNCTION C_GROUP_BY_P RETURN VARCHAR2;
76 
77   FUNCTION C_SOBNAME_P RETURN VARCHAR2;
78 
79   FUNCTION C_TDR_VAT_NO_P RETURN VARCHAR2;
80 
81   FUNCTION C_SOBCURR_P RETURN VARCHAR2;
82 
83   FUNCTION C_BRANCH_P RETURN VARCHAR2;
84 
85   FUNCTION C_COUNTRY_P RETURN VARCHAR2;
86 
87   FUNCTION C_ADDR_ID_P RETURN NUMBER;
88 
89   FUNCTION C_INDUSTRY_CODE_P RETURN VARCHAR2;
90 
91   FUNCTION C_SALES_TITLE_P RETURN VARCHAR2;
92 
93   FUNCTION C_CITY_P RETURN VARCHAR2;
94 
95   FUNCTION C_POSTAL_CODE_P RETURN VARCHAR2;
96 
97   FUNCTION C_STREET_P RETURN VARCHAR2;
98 
99   FUNCTION GET(APPL_ID IN INTEGER
100               ,DEP_APPL_ID IN INTEGER
101               ,STATUS OUT NOCOPY VARCHAR2
102               ,INDUSTRY OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
103 
104   FUNCTION GET_APP_INFO(APPLICATION_SHORT_NAME IN VARCHAR2
105                        ,STATUS OUT NOCOPY VARCHAR2
106                        ,INDUSTRY OUT NOCOPY VARCHAR2
107                        ,ORACLE_SCHEMA OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
108 
109   FUNCTION GET_APP_INFO_OTHER(APPLICATION_SHORT_NAME IN VARCHAR2
110                              ,TARGET_SCHEMA IN VARCHAR2
111                              ,STATUS OUT NOCOPY VARCHAR2
112                              ,INDUSTRY OUT NOCOPY VARCHAR2
113                              ,ORACLE_SCHEMA OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
114 
115 END AR_ARYVTSLD_XMLP_PKG;
116