PACKAGE: APPS.ONT_OEXOEUBK_XMLP_PKG

Source

1 PACKAGE ONT_OEXOEUBK_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: OEXOEUBKS.pls 120.2 2008/05/05 06:37:47 dwkrishn noship $ */
3   P_CONC_REQUEST_ID NUMBER;
4 
5   P_SOB_ID NUMBER;
6 
7   P_ORDER_BY VARCHAR2(30);
8 
9   P_CREATED_BY_LOW VARCHAR2(240);
10 
11   P_ITEM_FLEX_CODE VARCHAR2(32767);
12 
13   P_ORGANIZATION_ID VARCHAR2(32767);
14 
15   P_ORGANIZATION_ID1 VARCHAR2(32767);
16 
17   C_PERIODICITY_DSP_FLAG VARCHAR2(1);
18 
19   P_ORDER_DATE_LOW DATE;
20 
21   P_ORDER_DATE_HIGH DATE;
22 
23   LP_CREATED_BY VARCHAR2(500);
24 
25   LP_ORDER_BY VARCHAR2(500);
26 
27   LP_ORDER_DATE VARCHAR2(500);
28 
29   P_CREATED_BY_HIGH VARCHAR2(240);
30 
31   LP_ORDER_DATE_RANGE VARCHAR2(500);
32 
33   LP_CREATED_BY_RANGE VARCHAR2(500);
34 
35   LP_ORDER_BY_MEAN VARCHAR2(100);
36 
37   P_ITEM_STRUCTURE_NUM NUMBER;
38 
39   P_PRINT_DESCRIPTION VARCHAR2(32767);
40 
41   LP_ORDER_CATEGORY VARCHAR2(500);
42 
43   LP_LINE_CATEGORY VARCHAR2(500);
44 
45   P_ORDER_CATEGORY VARCHAR2(30);
46 
47   P_LINE_CATEGORY VARCHAR2(30);
48 
49   P_ONE_TIME VARCHAR2(32767);
50 
51   RP_REPORT_NAME VARCHAR2(240);
52 
53   RP_SUB_TITLE VARCHAR2(240);
54 
55   RP_COMPANY_NAME VARCHAR2(100);
56 
57   RP_FUNCTIONAL_CURRENCY VARCHAR2(20);
58 
59   RP_DATA_FOUND VARCHAR2(300);
60 
61   RP_ITEM_FLEX_ALL_SEG VARCHAR2(2000) := 'MSI.SEGMENT1';
62 
63   RP_PRINT_DESCRIPTION VARCHAR2(100);
64 
65   RP_DUMMY_ITEM VARCHAR2(2000);
66 
67   FUNCTION BEFOREREPORT RETURN BOOLEAN;
68 
69   FUNCTION AFTERREPORT RETURN BOOLEAN;
70 
71   FUNCTION P_ITEM_FLEX_CODEVALIDTRIGGER RETURN BOOLEAN;
72 
73   FUNCTION AFTERPFORM RETURN BOOLEAN;
74 
75   FUNCTION RP_ORDER_CATEGORYFORMULA RETURN VARCHAR2;
76 
77   FUNCTION RP_LINE_CATEGORYFORMULA RETURN VARCHAR2;
78 
79   FUNCTION C_MASTER_ORGFORMULA RETURN NUMBER;
80 
81   FUNCTION C_PERIODICITY_DSPFORMULA(CHARGE_PERIODICITY_CODE IN VARCHAR2) RETURN CHAR;
82 
83   FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
84 
85   FUNCTION RP_SUB_TITLE_P RETURN VARCHAR2;
86 
87   FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
88 
89   FUNCTION RP_FUNCTIONAL_CURRENCY_P RETURN VARCHAR2;
90 
91   FUNCTION RP_DATA_FOUND_P RETURN VARCHAR2;
92 
93   FUNCTION RP_ITEM_FLEX_ALL_SEG_P RETURN VARCHAR2;
94 
95   FUNCTION RP_PRINT_DESCRIPTION_P RETURN VARCHAR2;
96 
97   FUNCTION RP_DUMMY_ITEM_P RETURN VARCHAR2;
98 function Item_dspFormula(inventory_item_id_L IN number,
99                         item_identifier_type_L IN VARCHAR2,
100 			 ordered_item_id_L IN NUMBER,
101                          ORGANIZATION_ID_L IN NUMBER,
102 			 ordered_item_L IN VARCHAR2) return Char;
103 
104 END ONT_OEXOEUBK_XMLP_PKG;
105