PACKAGE: APPS.INV_INVRCWSR_XMLP_PKG

Source

1 PACKAGE INV_INVRCWSR_XMLP_PKG AS
2 /* $Header: INVRCWSRS.pls 120.1 2007/12/25 10:49:21 dwkrishn noship $ */
3   P_ORG_ID NUMBER;
4 
5   P_HEADER_ID NUMBER;
6 
7   P_RC_SUBINV VARCHAR2(10);
8 
9   P_ACTUAL_START_DATE VARCHAR2(32767);
10 
11   P_ORG_NAME VARCHAR2(240);
12 
13   P_ORG_CODE VARCHAR2(10);
14 
15   P_REQUEST_DATE VARCHAR2(32767);
16 
17   P_REPORT_NAME VARCHAR2(50);
18 
19   P_CONC_REQUEST_ID NUMBER;
20 
21   P_PRINTER VARCHAR2(30);
22 
23   P_ITEM_FLEXSQL VARCHAR2(1000);
24 
25   P_LOCATOR_FLEXSQL VARCHAR2(2000);
26 
27   P_APPLICATION_NAME VARCHAR2(240);
28 
29   P_RESPONSIBILITY_NAME VARCHAR2(100);
30 
31   ORDER_BY_CLAUSE VARCHAR2(40);
32 
33   P_EXPENSE_ACCT_FLEXSQL VARCHAR2(2000);
34 
35   P_STATUS_HOLD VARCHAR2(80);
36 
37   P_STATUS_PENDING VARCHAR2(80);
38 
39   P_STATUS_PROCESSING VARCHAR2(80);
40 
41   P_STATUS_ERROR VARCHAR2(80);
42 
43   P_STATUS_COMPLETED VARCHAR2(80);
44 
45   P_COUNT_TYPE_ONHAND VARCHAR2(80);
46 
47   P_COUNT_TYPE_ORDER VARCHAR2(80);
48 
49   P_COUNT_TYPE_PAR VARCHAR2(80);
50 
51   P_SOURCE_TYPE_INV VARCHAR2(80);
52 
53   P_SOURCE_TYPE_SUPPLIER VARCHAR2(80);
54 
55   P_SOURCE_TYPE_SUB VARCHAR2(80);
56 
57   P_QTY_PRECISION NUMBER;
58 
59   P_ITEM_LOCATOR_FOUND NUMBER := 1;
60 
61   P_ERROR NUMBER;
62 
63   P_EXPENSEACCOUNT_FLEXNUM NUMBER;
64 
65   FUNCTION AFTERPFORM RETURN BOOLEAN;
66 
67   FUNCTION BEFOREREPORT RETURN BOOLEAN;
68 
69   FUNCTION AFTERREPORT RETURN BOOLEAN;
70 
71   FUNCTION CF_LOCATORFORMULA(LOCATOR_ID IN NUMBER
72                             ,ORGANIZATION_ID IN NUMBER) RETURN VARCHAR2;
73 
74   FUNCTION CF_PAR_LEVELFORMULA(LOCATOR_ID IN NUMBER
75                               ,ITEM_ID IN NUMBER) RETURN NUMBER;
76 
77   FUNCTION CF_ERRORFORMULA(ERROR_CODE IN NUMBER
78                           ,PROCESS_STATUS_CODE IN NUMBER
79                           ,PLANNING_LEVEL IN NUMBER
80                           ,QUANTITY_TRACKED IN NUMBER
81                           ,COUNT_TYPE_CODE IN NUMBER
82                           ,LOCATOR_ID IN NUMBER
83                           ,CF_PAR_LEVEL IN NUMBER) RETURN CHAR;
84 
85   FUNCTION CF_PROCESS_STATUSFORMULA(PROCESS_STATUS_CODE IN NUMBER) RETURN CHAR;
86 
87   FUNCTION CF_SOURCE_TYPEFORMULA(SOURCE_TYPE_CODE IN NUMBER) RETURN CHAR;
88 
89   FUNCTION CF_COUNT_TYPEFORMULA(COUNT_TYPE_CODE IN NUMBER) RETURN CHAR;
90 
91   FUNCTION CF_SOURCE_ORG_CODEFORMULA(SOURCE_ORG_ID IN NUMBER) RETURN CHAR;
92 
93   FUNCTION IS_COUNT_PROCESSED(PROCESS_STATUS_CODE IN NUMBER) RETURN BOOLEAN;
94 
95   FUNCTION SETUP_ERROR(CF_ERROR IN VARCHAR2) RETURN BOOLEAN;
96 
97 END INV_INVRCWSR_XMLP_PKG;
98