DBA Data[Home] [Help]

PACKAGE: APPS.BOM_CSTRDICR_XMLP_PKG

Source


1 PACKAGE BOM_CSTRDICR_XMLP_PKG AS
2 /* $Header: CSTRDICRS.pls 120.0 2007/12/24 09:54:52 dwkrishn noship $ */
3   P_ORG_ID VARCHAR2(40);
4   P_STRUCT_NUM VARCHAR2(40);
5   P_SELECT_ITEM VARCHAR2(850);
6   P_SELECT_CAT VARCHAR2(850);
7   P_WHERE_ITEM VARCHAR2(850) := '1 = 1';
8   P_FROM_ITEM VARCHAR2(240);
9   P_TO_ITEM VARCHAR2(240);
10   P_FROM_CAT VARCHAR2(240);
11   P_TO_CAT VARCHAR2(240);
12   P_WHERE_CAT VARCHAR2(850) := '1 = 1';
13   P_CONC_REQUEST_ID NUMBER := 0;
14   P_CST_TYPE VARCHAR2(40);
15   P_CATEGORY_SET NUMBER;
16   REPORT_SORT_OPT NUMBER;
17   SHOW_ELEM_SUM NUMBER;
18   P_QTY_PRECISION NUMBER;
19   P_VIEW_COST NUMBER;
20   P_TRACE_FLAG NUMBER;
21   FORMAT_MASK VARCHAR2(100);
22   L_ITEM_FLEX_NUM number;
23   FUNCTION BEFOREREPORT RETURN BOOLEAN;
24   FUNCTION AFTERREPORT RETURN BOOLEAN;
25   FUNCTION DISP_CURRENCYFORMULA(CURR_CODE_SAVED IN VARCHAR2) RETURN VARCHAR2;
26   FUNCTION ORDER_FUNC(C_FLEXPAD_ITEM IN VARCHAR2
27                      ,C_FLEXPAD_CAT IN VARCHAR2
28                      ,UOM IN VARCHAR2) RETURN CHARACTER;
29   FUNCTION C_FLEXPAD_ITEMFORMULA(C_ITEM_NUM_FLEX IN VARCHAR2
30                                 ,C_FLEXPAD_ITEM IN VARCHAR2) RETURN VARCHAR2;
31   FUNCTION C_FLEXPAD_CATFORMULA(C_CAT_FLEX IN VARCHAR2
32                                ,C_FLEXPAD_CAT IN VARCHAR2) RETURN VARCHAR2;
33   FUNCTION AFTERPFORM RETURN BOOLEAN;
34 END BOM_CSTRDICR_XMLP_PKG;
35