PACKAGE: APPS.PO_POXCORIT_XMLP_PKG

Source

1 PACKAGE PO_POXCORIT_XMLP_PKG AS
2 /* $Header: POXCORITS.pls 120.1 2007/12/25 10:52:25 krreddy noship $ */
3 	P_CONC_REQUEST_ID	number;
4 	P_COUNTRY_OF_ORIGIN_CODE	varchar2(2);
5 	P_FLEX_ITEM	varchar2(1000);
6 	P_ORG_ID	number;
7 	P_ORGANIZATION_NAME	varchar2(80);
8 	P_QUERY_WHERE_COUNTRY_CODE	varchar2(1000);
9 	P_CAT_STRUCT_NUM	varchar2(40);
10 	P_FLEX_CAT	varchar2(1000);
11 	P_TITLE	varchar2(60);
12 	P_ITEM_FROM	varchar2(900);
13 	P_ITEM_TO	varchar2(900);
14 	P_CAT_FROM	varchar2(900);
15 	P_CAT_TO	varchar2(900);
16 	P_DATE_FROM	date;
17 	P_DATE_TO	date;
18 	P_QUERY_WHERE_CAT	varchar2(1000);
19 	P_QUERY_WHERE_ITEM	varchar2(1000);
20 	P_ITEM_STRUCT_NUM	varchar2(40);
21 	function BeforeReport return boolean  ;
22 	function AfterReport return boolean  ;
23 	function get_p_struct_num return boolean  ;
24 	function f_get_vendor_item_number (p_org_id number
25              , p_vendor_id number
26              , p_vendor_site_id number
27              , p_item_id number)return varchar2  ;
28 	function cf_vendor_item_numberformula(C_USING_ORG_ID in number, C_VENDOR_ID in number, C_VENDOR_SITE_ID in number, C_ITEM_ID in number) return varchar2  ;
29 END PO_POXCORIT_XMLP_PKG;
30