PACKAGE: APPS.QA_QLTSPECR_XMLP_PKG

Source

1 PACKAGE QA_QLTSPECR_XMLP_PKG AS
2 /* $Header: QLTSPECRS.pls 120.0 2007/12/24 10:39:38 krreddy noship $ */
3   P_ORGANIZATION_ID NUMBER;
4 
5   P_QTY_PRECISION NUMBER;
6 
7   P_CATEGORY_SET VARCHAR2(30);
8 
9   P_CATEGORY_SET_LIMITER VARCHAR2(250):='  ';
10 
11   P_SPEC_NAME VARCHAR2(30);
12 
13   P_SPEC_NAME_LIMITER VARCHAR2(250):='  ';
14 
15   P_ITEM VARCHAR2(30);
16 
17   P_ITEM_LIMITER VARCHAR2(250);
18 
19   P_SPEC_TYPE VARCHAR2(250);
20 
21   P_SPEC_TYPE_LIMITER VARCHAR2(250):='  ';
22 
23   P_VENDOR_NUMBER VARCHAR2(30);
24 
25   P_VENDOR_NUMBER_LIMITER VARCHAR2(250):='  ';
26 
27   P_CUSTOMER_NUMBER VARCHAR2(30);
28 
29   P_CUSTOMER_NUMBER_LIMITER VARCHAR2(250):='  ';
30 
31   P_FLEXDATA VARCHAR2(900);
32 
33   P_CONC_REQUEST_ID NUMBER := 0;
34 
35   P_STRUCT_NUM VARCHAR2(15);
36 
37   P_CATEGORY_FLEXDATA VARCHAR2(900);
38 
39   P_ORG_LIMITER VARCHAR2(250):='   ';
40 
41   P_CATEGORY VARCHAR2(100);
42 
43   P_CATEGORY_LIMITER VARCHAR2(400);
44 
45   P_SPEC_TYPE_MEANING VARCHAR2(80);
46 
47   FUNCTION C_TARGET_VALUEFORMULA(DATATYPE IN NUMBER
48                                 ,TARGET_VALUE IN VARCHAR2) RETURN NUMBER;
49 
50   FUNCTION C_UPPER_SPEC_NUMBERFORMULA(DATATYPE IN NUMBER
51                                      ,UPPER_SPEC_LIMIT IN VARCHAR2) RETURN NUMBER;
52 
53   FUNCTION C_UPPER_USER_NUMBERFORMULA(DATATYPE IN NUMBER
54                                      ,UPPER_USER_DEFINED_LIMIT IN VARCHAR2) RETURN NUMBER;
55 
56   FUNCTION C_UPPER_REASON_NUMBERFORMULA(DATATYPE IN NUMBER
57                                        ,UPPER_REASONABLE_LIMIT IN VARCHAR2) RETURN NUMBER;
58 
59   FUNCTION AFTERPFORM RETURN BOOLEAN;
60 
61   FUNCTION BEFOREREPORT RETURN BOOLEAN;
62 
63   FUNCTION AFTERREPORT RETURN BOOLEAN;
64 
65   FUNCTION C_LOWER_SPEC_NUMBERFORMULA(DATATYPE IN NUMBER
66                                      ,LOWER_SPEC_LIMIT IN VARCHAR2) RETURN NUMBER;
67 
68   FUNCTION C_LOWER_USER_NUMBERFORMULA(DATATYPE IN NUMBER
69                                      ,LOWER_USER_DEFINED_LIMIT IN VARCHAR2) RETURN NUMBER;
70 
71   FUNCTION C_LOWER_REASON_NUMBERFORMULA(DATATYPE IN NUMBER
72                                        ,LOWER_REASONABLE_LIMIT IN VARCHAR2) RETURN NUMBER;
73 
74  -- PROCEDURE GET_PRECISION(ID IN NUMBER);
75 
76 END QA_QLTSPECR_XMLP_PKG;
77