DBA Data[Home] [Help]

PACKAGE: APPS.INV_INVIRRIT_XMLP_PKG

Source


1 PACKAGE INV_INVIRRIT_XMLP_PKG AS
2 /* $Header: INVIRRITS.pls 120.1 2007/12/25 10:31:35 dwkrishn noship $ */
3   P_ITEM_LO VARCHAR2(300);
4 
5   P_ITEM_HI VARCHAR2(300);
6 
7   P_CATG_LO VARCHAR2(300);
8 
9   P_CATG_HI VARCHAR2(300);
10 
11   P_ITEM_FLEXDATA1 VARCHAR2(480);
12 
13   P_ITEM_WHERE VARCHAR2(2400);
14 
15   P_ITEM_NUM VARCHAR2(15);
16 
17   P_CATG_FLEXDATA1 VARCHAR2(480);
18 
19   P_CATG_WHERE VARCHAR2(2400);
20 
21   P_SEGMENT_DELIMITER VARCHAR2(1);
22 
23   P_DESC_TYPE_FLAG NUMBER;
24 
25   P_CONC_REQUEST_ID NUMBER := 0;
26 
27   P_ORG_ID VARCHAR2(22);
28 
29   P_ITEM_FLEXDATA2 VARCHAR2(480);
30 
31   P_RELATION_TYPE NUMBER;
32 
33   P_CATG_FLEXDATA2 VARCHAR2(480);
34 
35   P_CATG_STRUCT_ID VARCHAR2(15);
36 
37   P_CATG_SET_ID NUMBER;
38 
39   P_TRACE_FLAG NUMBER;
40 
41   P_OPTIMIZER_CODE NUMBER;
42 
43   FUNCTION C_RPT_TITLEFORMULA(C_RELATION_NAME IN VARCHAR2) RETURN VARCHAR2;
44 
45   FUNCTION BEFOREREPORT RETURN BOOLEAN;
46 
47   FUNCTION C_ITEM_LABELFORMULA(C_RELATION_NAME IN VARCHAR2) RETURN VARCHAR2;
48 
49   FUNCTION BEFOREPFORM RETURN BOOLEAN;
50 
51   FUNCTION AFTERPFORM RETURN BOOLEAN;
52 
53   FUNCTION C_RECIPROCAL_VALUEFORMULA(RECIPROCAL_FLAG IN VARCHAR2) RETURN VARCHAR2;
54 
55   FUNCTION C_ICG_DESC_1FORMULA(ITEM_ID1 IN NUMBER) RETURN VARCHAR2;
56 
57   FUNCTION C_ICG_DESC_2FORMULA(ITEM_ID2 IN NUMBER) RETURN VARCHAR2;
58 
59   FUNCTION AFTERREPORT RETURN BOOLEAN;
60 
61 END INV_INVIRRIT_XMLP_PKG;
62