PACKAGE: APPS.PO_POXDETIT_XMLP_PKG

Source

1 PACKAGE PO_POXDETIT_XMLP_PKG AS
2 /* $Header: POXDETITS.pls 120.1 2007/12/25 10:55:25 krreddy noship $ */
3 	P_title	varchar2(50);
4 	P_ACTIVE_INACTIVE	varchar2(40);
5 	P_CONC_REQUEST_ID	number;
6 	P_FLEX_ITEM	varchar2(800);
7 	P_STRUCT_NUM	varchar2(40);
8 	P_FLEX_ACC	varchar2(31000);
9 	P_FLEX_CAT	varchar2(31000);
10 	P_FLEX_ASS	varchar2(800);
11 	P_buyer_name	varchar2(80);
12 	P_WHERE_CAT	varchar2(1000);
13 	P_category_from	varchar2(900);
14 	P_category_to	varchar2(900);
15 	P_WHERE_ITEM	varchar2(1000);
16 	P_item_from	varchar2(900);
17 	P_item_to	varchar2(900);
18 	P_ORDERBY	varchar2(40);
19 	P_ORDERBY_CAT	varchar2(298);
20 	P_ORDERBY_ITEM	varchar2(298);
21 	P_qty_precision	number;
22 	ORG_ID	varchar2(40);
23 	P_act_inact_disp	varchar2(80);
24 	P_item_cross_ref	varchar2(40);
25 	P_ITEM_STRUCT_NUM	varchar2(40);
26 	P_ASS_STRUCT_NUM	varchar2(40);
27 	P_OFA_STATUS	varchar2(32767);
28 	P_CST_STATUS	varchar2(32767);
29 	P_fa_installed	number;
30 	P_acat_struct_num	number;
31 	ORGANIZATION_ID	varchar2(40);
32 	P_CHART_OF_ACCOUNTS_ID	number;
33 	function BeforeReport return boolean  ;
34 	function AfterReport return boolean  ;
35 	function orderby_clauseFormula return VARCHAR2  ;
36 	procedure get_precision  ;
37 	function get_p_struct_num return boolean  ;
38 	function C_OFA_dynamicFormula return VARCHAR2  ;
39 	function C_OFA_WhereFormula return VARCHAR2  ;
40 	function C_CST_SELECTFormula return VARCHAR2  ;
41 	function C_CST_FROMFormula return VARCHAR2  ;
42 	function C_CST_WHEREFormula return VARCHAR2  ;
43 	function noteformula(item_note_datatype_id in number, item_note_media_id in number) return char  ;
44 	l_INDUSTRY       VARCHAR2(100);
45         l_ORACLE_SCHEMA VARCHAR2(100);
46         temp boolean;
47 END PO_POXDETIT_XMLP_PKG;
48