PACKAGE: APPS.INV_INVTRSTS_XMLP_PKG

Source

1 PACKAGE INV_INVTRSTS_XMLP_PKG AS
2 /* $Header: INVTRSTSS.pls 120.2 2008/01/08 06:48:11 dwkrishn noship $ */
3   P_STRUCT_NUM NUMBER;
4   P_ITEM_FLEX VARCHAR2(900);
5   P_STYPE1 VARCHAR2(40);
6   P_STYPE2 VARCHAR2(40);
7   P_STYPE3 VARCHAR2(40);
8   P_STYPE4 VARCHAR2(40);
9   P_STYPE5 VARCHAR2(40);
10   P_SELECTION NUMBER;
11   P_DATE_LO VARCHAR2(22);
12   P_DATE_LO_1 VARCHAR2(22);
13   P_SORT_ID NUMBER;
14   P_ORG_ID NUMBER;
15   P_CONC_REQUEST_ID NUMBER := 0;
16   P_CAT_FLEX VARCHAR2(900) := '(MC.SEGMENT1||''\n''||MC.SEGMENT2||''\n''||MC.SEGMENT3||''\n''||MC.SEGMENT4||''\n''||MC.SEGMENT5||''\n''||MC.SEGMENT6||''\n''||MC.SEGMENT7||''\n''||MC.SEGMENT8||''\n''||MC.SEGMENT9||''\n''||MC.SEGMENT10||''\n''||
17   MC.SEGMENT11||''\n''||MC.SEGMENT12||''\n''||MC.SEGMENT13||''\n''||MC.SEGMENT14||''\n''||MC.SEGMENT15||''\n''||
18   MC.SEGMENT16||''\n''||MC.SEGMENT17||''\n''||MC.SEGMENT18||''\n''||MC.SEGMENT19||''\n''||MC.SEGMENT20)';
19   P_WHERE_CAT VARCHAR2(2400);
20   P_CAT_HI VARCHAR2(900);
21   P_CAT_LO VARCHAR2(900);
22   P_CAT_SET_ID NUMBER;
23   P_SUBINV_HI VARCHAR2(40);
24   P_SUBINV_LO VARCHAR2(40);
25   P_ITEM_LO VARCHAR2(900);
26   P_ITEM_HI VARCHAR2(900);
27   P_WHERE_ITEM VARCHAR2(2400);
28   P_DATE_HI VARCHAR2(22);
29    P_DATE_HI_1 VARCHAR2(22);
30   P_CAT_STRUCT_NUM NUMBER;
31   P_VIEW VARCHAR2(40) := 'txn_usage_view';
32   P_VIEW_PUT VARCHAR2(40);
33   P_QTY_PRECISION NUMBER;
34   P_ITEM_STATUS NUMBER;
35   P_CAT_SORT VARCHAR2(900);
36   P_ORDER_ITEM VARCHAR2(900);
37   P_DROP VARCHAR2(32767);
38   P_CBO_FLAG NUMBER;
39   FUNCTION AFTERREPORT RETURN BOOLEAN;
40   FUNCTION C_FROM_CATFORMULA RETURN VARCHAR2;
41   FUNCTION C_WHERE_CATFORMULA RETURN VARCHAR2;
42   FUNCTION C_SOURCE_TYPE1FORMULA RETURN VARCHAR2;
43   FUNCTION C_SOURCE_TYPE2FORMULA RETURN VARCHAR2;
44   FUNCTION C_SOURCE_TYPE3FORMULA RETURN VARCHAR2;
45   FUNCTION C_WHERE_SUBINVFORMULA RETURN VARCHAR2;
46   FUNCTION BEFOREREPORT RETURN BOOLEAN;
47   FUNCTION AFTERPFORM RETURN BOOLEAN;
48   FUNCTION C_ITEM_TOTALFORMULA(SOURCE_TYPE1 IN NUMBER
49                               ,SOURCE_TYPE2 IN NUMBER
50                               ,SOURCE_TYPE3 IN NUMBER
51                               ,OTHER IN NUMBER) RETURN NUMBER;
52   FUNCTION C_CAT_SET_NAMEFORMULA RETURN VARCHAR2;
53   FUNCTION BEFOREPFORM RETURN BOOLEAN;
54   FUNCTION C_CURRENCY_CODEFORMULA(R_CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
55   FUNCTION P_VIEW_PUTVALIDTRIGGER RETURN BOOLEAN;
56   FUNCTION C_STATUS_WHEREFORMULA RETURN VARCHAR2;
57   FUNCTION C_CAT_PADFORMULA(C_CAT_FIELD IN VARCHAR2) RETURN VARCHAR2;
58 END INV_INVTRSTS_XMLP_PKG;
59 
60