PACKAGE: APPS.ONT_OEXOEWFR_XMLP_PKG

Source

1 PACKAGE ONT_OEXOEWFR_XMLP_PKG AS
2 /* $Header: OEXOEWFRS.pls 120.1 2007/12/25 07:29:00 npannamp noship $ */
3   P_REPORT1 NUMBER;
4 
5   P_REPORT2 NUMBER;
6 
7   P_REPORT3 NUMBER;
8 
9   P_REPORT4 NUMBER;
10 
11   P_REPORT5 NUMBER;
12 
13   P_REPORT6 NUMBER;
14 
15   P_REPORT7 NUMBER;
16 
17   P_REPORT8 NUMBER;
18 
19   P_REPORT9 NUMBER;
20 
21   P_REPORT10 NUMBER;
22 
23   P_REPORT11 NUMBER;
24 
25   P_REPORT12 NUMBER;
26 
27   P_REPORT13 NUMBER;
28 
29   P_ACTIONS VARCHAR2(30);
30 
31   P_OVERDUE_DAYS NUMBER;
32 
33   P_ORDER_TYPE VARCHAR2(30);
34 
35   P_ORDER_NO_LOW NUMBER;
36 
37   P_ORDER_NO_HIGH NUMBER;
38 
39   P_LINE_CATEGORY VARCHAR2(32767);
40 
41   P_ITEM VARCHAR2(32767);
42 
43   P_NO_DATA VARCHAR2(32767);
44 
45   PARAM_WHERE_CLAUSE VARCHAR2(500);
46 
47   P_CONC_REQUEST_ID NUMBER;
48 
49   P_ORG_ID NUMBER;
50 
51   P_SOB_ID NUMBER;
52 
53   CP_TYPE NUMBER;
54 
55   RP_COMPANY_NAME VARCHAR2(240);
56 
57   FUNCTION CF_EXTENDED_VALUEFORMULA(HEADER_ID1 IN NUMBER
58                                    ,LINE_ID IN NUMBER
59                                    ,LINE_VALUE IN NUMBER
60                                    ,LINE_CATEGORY_CODE IN VARCHAR2) RETURN NUMBER;
61 
62   FUNCTION CF_HOLD_VALUEFORMULA(HEADER_ID1 IN NUMBER
63                                ,LINE_ID IN NUMBER) RETURN CHAR;
64 
65   FUNCTION CF_COUNTRYFORMULA RETURN CHAR;
66 
67   FUNCTION CF_CURRENCYFORMULA RETURN CHAR;
68 
69   FUNCTION P_OVERDUE_DAYSVALIDTRIGGER RETURN BOOLEAN;
70 
71   FUNCTION P_NO_DATAVALIDTRIGGER RETURN BOOLEAN;
72 
73   FUNCTION P_ACTIONSVALIDTRIGGER RETURN BOOLEAN;
74 
75   FUNCTION AFTERPFORM RETURN BOOLEAN;
76 
77   FUNCTION AFTERPFORM0009 RETURN BOOLEAN;
78 
79   FUNCTION CF_ITEM_Y_NFORMULA(CONCATENATED_SEGMENTS IN VARCHAR2
80                              ,DESCRIPTION IN VARCHAR2) RETURN CHAR;
81 
82   FUNCTION CF_BOOKED_DISPLAYFORMULA(BOOKED_FLAG IN VARCHAR2) RETURN CHAR;
83 
84   FUNCTION BEFOREREPORT RETURN BOOLEAN;
85 
86   FUNCTION BEFOREPFORM RETURN BOOLEAN;
87 
88   FUNCTION PARAM_WHERE_CLAUSEVALIDTRIGGER RETURN BOOLEAN;
89 
90   FUNCTION AFTERREPORT RETURN BOOLEAN;
91 
92   FUNCTION BETWEENPAGE RETURN BOOLEAN;
93 
94   FUNCTION CF_LINE_NUMBERFORMULA(LINE_NUMBER IN NUMBER
95                                 ,SHIPMENT_NUMBER IN NUMBER
96                                 ,OPTION_NUMBER IN NUMBER
97                                 ,COMPONENT_NUMBER IN NUMBER
98                                 ,SERVICE_NUMBER IN NUMBER) RETURN CHAR;
99 
100   FUNCTION CF_ORDERED_DATEFORMULA(LINE_ID IN NUMBER
101                                  ,HEADER_ID1 IN NUMBER
102                                  ,ORDERED_DATE IN DATE) RETURN DATE;
103 
104   FUNCTION G_LINE_IDGROUPFILTER(CF_ORDERED_DATE IN DATE) RETURN BOOLEAN;
105 
106   FUNCTION CF_MASTER_ORGFORMULA RETURN CHAR;
107 
108   FUNCTION CF_TYPEFORMULA(TYPE IN NUMBER) RETURN NUMBER;
109 
110   FUNCTION CF_TITLEFORMULA RETURN CHAR;
111 
112   FUNCTION CF_BOOKED_HEADINGFORMULA RETURN NUMBER;
113 
114   FUNCTION CF_ORDER_TITLEFORMULA RETURN CHAR;
115 
116   FUNCTION CP_TYPE_P RETURN NUMBER;
117 
118   FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
119 
120   TYPE T_REC IS RECORD (P_TYPE NUMBER(5),HEADER_ID NUMBER,ORDER_NUMBER VARCHAR2(32),NAME VARCHAR2(100),ORDER_DATE DATE);
121 
122   TYPE L_REF IS REF CURSOR;
123 
124   PROCEDURE LINE_SHIPMENT_OPTION(P_LINE_NUMBER IN NUMBER
125                                 ,P_SHIPMENT_NUMBER IN NUMBER
126                                 ,P_OPTION_NUMBER IN NUMBER
127                                 ,P_CONCAT_VALUE OUT NOCOPY VARCHAR2
128                                 ,P_COMPONENT_NUMBER IN NUMBER := NULL
129                                 ,P_SERVICE_NUMBER IN NUMBER := NULL);
130 
131 END ONT_OEXOEWFR_XMLP_PKG;
132