DBA Data[Home] [Help]

PACKAGE: APPS.BOM_CSTRUSTA_XMLP_PKG

Source


1 PACKAGE BOM_CSTRUSTA_XMLP_PKG AS
2 /* $Header: CSTRUSTAS.pls 120.0 2007/12/24 10:23:27 dwkrishn noship $ */
3   P_UPDATE_ID NUMBER;
4 
5   P_CONC_REQUEST_ID NUMBER := 0;
6 
7   P_ITEM_SEG VARCHAR2(1440);
8 
9   P_ACCT_SEG1 VARCHAR2(1440);
10 
11   P_ACCT_SEG2 VARCHAR2(1440);
12 
13   P_GL_NUM NUMBER;
14 
15   P_ORGANIZATION VARCHAR2(240);
16 
17   P_ITEM_RANGE VARCHAR2(80);
18 
19   P_CURRENCY_CODE VARCHAR2(15);
20 
21   ROUND_UNIT NUMBER;
22 
23   P_EXT_PREC NUMBER;
24 
25   P_ADJ_ACCOUNT VARCHAR2(40);
26 
27   P_RANGE_OPTION VARCHAR2(40);
28 
29   P_ITEM_FROM VARCHAR2(40);
30 
31   P_ITEM_TO VARCHAR2(40);
32 
33   P_CATEGORY_SET VARCHAR2(40);
34 
35   P_CAT_SET_NAME VARCHAR2(40);
36 
37   P_CAT_SEG VARCHAR2(1440);
38 
39   P_RPT_ONLY NUMBER;
40 
41   P_DEL_SNAPSHOT NUMBER;
42 
43   P_ORG_ID NUMBER;
44 
45   P_CAT_NUM NUMBER;
46 
47   P_ITEM VARCHAR2(40);
48 
49   P_CAT VARCHAR2(40);
50 
51   P_QTY_PRECISION NUMBER;
52 
53   P_COST_TYPE_ID NUMBER;
54 
55   P_COST_TYPE VARCHAR2(10);
56 
57   P_UPDATE_DATE DATE;
58 
59   P_UPDATE_DESC VARCHAR2(240);
60 
61   P_TRACE VARCHAR2(1);
62 
63   FUNCTION ACC_ADJUSTMENTFORMULA(ACCOUNT_TOTAL IN NUMBER) RETURN NUMBER;
64 
65   FUNCTION AFTERREPORT RETURN BOOLEAN;
66 
67   FUNCTION INTRANSIT_ACCT_DESCFORMULA(INTRANSIT_ACCT IN VARCHAR2
68                                      ,INTRANSIT_ACCT_SEG IN VARCHAR2
69                                      ,INTRANSIT_ACCT_DESC IN VARCHAR2) RETURN VARCHAR2;
70 
71   FUNCTION REP_ADJUSTMENTFORMULA(REP_INTRANSIT IN NUMBER) RETURN NUMBER;
72 
73   FUNCTION ORG_ADJUSTMENTFORMULA(ORG_INTRANSIT IN NUMBER) RETURN NUMBER;
74 
75   FUNCTION BEFOREREPORT RETURN BOOLEAN;
76 
77   FUNCTION INTRANSIT_ACCT_PSEGFORMULA(INTRANSIT_ACCT IN VARCHAR2
78                                      ,INTRANSIT_ACCT_SEG IN VARCHAR2
79                                      ,INTRANSIT_ACCT_PSEG IN VARCHAR2) RETURN VARCHAR2;
80 
81   FUNCTION ITEM_PSEGFORMULA(ITEM_NUMBER IN VARCHAR2
82                            ,ITEM_SEGMENT IN VARCHAR2
83                            ,ITEM_PSEG IN VARCHAR2) RETURN VARCHAR2;
84 
85 END BOM_CSTRUSTA_XMLP_PKG;
86