DBA Data[Home] [Help]

PACKAGE: APPS.PO_POXPOBPS_XMLP_PKG

Source


1 PACKAGE PO_POXPOBPS_XMLP_PKG AS
2 /* $Header: POXPOBPSS.pls 120.2 2007/12/25 11:09:22 krreddy noship $ */
3 	P_title	varchar2(50);
4 	P_qty_precision	number;
5 	QTY_PRECISION VARCHAR2(100);
6 	P_PO_NUM_FROM	varchar2(40);
7 	P_PO_NUM_TO	varchar2(40);
8 	P_BUYER	varchar2(240);
9 	P_VENDOR_FROM	varchar2(240);
10 	P_VENDOR_TO	varchar2(240);
11 	P_CATEGORY_FROM	varchar2(900);
12 	P_EXPIRATION_DATE	date;
13 	P_FLEX_ITEM	varchar2(800);
14 	P_CONC_REQUEST_ID	number;
15 	P_CATEGORY_TO	varchar2(900);
16 	P_WHERE_CAT	varchar2(2000);
17 	P_FLEX_CAT	varchar2(31000);
18 	P_STRUCT_NUM	number;
19 	P_ORDERBY	varchar2(200);
20 	P_ITEM_STRUCT_NUM	varchar2(40);
21 	P_ORDERBY_DISPLAYED	varchar2(80);
22 	function BeforeReport return boolean  ;
23 	function AfterReport return boolean  ;
24 	procedure get_precision  ;
25 	function orderby_clauseFormula return VARCHAR2  ;
26 	function get_p_struct_num return boolean  ;
27 	function cur_planned_amt_agreed(PO_type in varchar2, po_header_id1 in number) return number  ;
28 	function cur_planned_amt_released(PO_type in varchar2, PO_HEADER_ID1 in number) return number  ;
29 	function c_amount_rel(po_header_id1 in number) return number  ;
30 	function c_amount_rem(po_header_id1 in number) return number  ;
31 	function c_po_relformula(global_agreement_flag in varchar2, std_po in varchar2, Release in number) return char  ;
32 	function c_org_nameformula(po_org_id in number, global_agreement_flag in varchar2) return char  ;
33 END PO_POXPOBPS_XMLP_PKG;
34