PACKAGE: APPS.ONT_OEXOHOHS_XMLP_PKG

Source

1 PACKAGE ONT_OEXOHOHS_XMLP_PKG AS
2 /* $Header: OEXOHOHSS.pls 120.2 2008/05/05 06:38:06 dwkrishn noship $ */
3   P_SOB_ID NUMBER;
4 
5   P_CUST_NAME_LO VARCHAR2(360);
6 
7   P_CUST_NAME_HI VARCHAR2(360);
8 
9   P_HOLD_NAME_LO VARCHAR2(30);
10 
11   P_HOLD_NAME_HI VARCHAR2(30);
12 
13   P_MIX_PRECISION VARCHAR2(10);
14 
15   P_CONC_REQUEST_ID NUMBER := 0;
16 
17   P_ORG_ID NUMBER;
18 
19   P_ITEM_FLEX_CODE VARCHAR2(32767);
20 
21   P_FLEX_OR_DESC VARCHAR2(40);
22 
23   P_ITEM_LO VARCHAR2(240);
24 
25   P_ITEM_HI VARCHAR2(240);
26 
27   P_WHERE_FLEX VARCHAR2(240);
28 
29   P_ITEM_STRUCTURE_NUM NUMBER;
30 
31   LP_HOLD_WHERE VARCHAR2(200);
32 
33   LP_CUSTOMER_WHERE VARCHAR2(200);
34 
35   P_ENABLE_TRACE VARCHAR2(5);
36 
37   C_FORMATTED_FLEX_VALUE VARCHAR2(240);
38 
39   RP_ITEM_FLEX_ALL_SEG VARCHAR2(2000) := 'SI.SEGMENT1';
40 
41   FUNCTION SOB_NAMEFORMULA RETURN VARCHAR2;
42 
43   FUNCTION BEFOREREPORT RETURN BOOLEAN;
44 
45   FUNCTION AFTERREPORT RETURN BOOLEAN;
46 
47   FUNCTION ITEM_DISPLAY_MEANINGFORMULA RETURN VARCHAR2;
48 
49   FUNCTION C_CUSTOMER_WHERE RETURN VARCHAR2;
50 
51   FUNCTION C_HOLD_WHERE RETURN VARCHAR2;
52 
53   FUNCTION AFTERPFORM RETURN BOOLEAN;
54 
55   --FUNCTION C_LINE_OR_ORDERFORMULA(ORDER_HOLD_ID IN NUMBER) RETURN VARCHAR2;
56 
57   FUNCTION C_LINE_OR_ORDERFORMULA(P_ORDER_HOLD_ID IN NUMBER) RETURN VARCHAR2;
58 
59   FUNCTION C_SHOW_AMOUNTFORMULA(HEADER_ID IN NUMBER
60                                ,C_LINE_OR_ORDER IN VARCHAR2) RETURN VARCHAR2;
61 function Item_dspFormula(item_identifier_type_L varchar2,
62                          c_master_org_L varchar2 ,
63 			  inventory_item_id_L number,
64 			  ordered_item_id_L number,
65 			  ordered_item_L varchar2,
66 			  ORGANIZATION_ID_L number) return Char;
67 
68   FUNCTION C_MASTER_ORGFORMULA RETURN CHAR;
69 
70   FUNCTION C_AMOUNTFORMULA(AMOUNT IN NUMBER) RETURN NUMBER;
71 
72   FUNCTION C_FORMATTED_FLEX_VALUE_P RETURN VARCHAR2;
73 
74   FUNCTION RP_ITEM_FLEX_ALL_SEG_P RETURN VARCHAR2;
75 
76 END ONT_OEXOHOHS_XMLP_PKG;
77