[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