PACKAGE: APPS.PO_POXRCPPV_XMLP_PKG

Source

1 PACKAGE PO_POXRCPPV_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: POXRCPPVS.pls 120.4 2011/07/21 00:03:45 fayang ship $ */
3 	P_title	varchar2(50);
4 	P_CONC_REQUEST_ID	number;
5 	P_VENDOR_FROM	varchar2(240);
6 	P_VENDOR_TO	varchar2(240);
7 	P_FLEX_CAT	varchar2(31000);
8 	P_FLEX_ITEM	varchar2(800);
9 	P_TRANS_DATE_FROM	date;
10 	P_TRANS_DATE_TO	date;
11 	P_DESTINATION_TYPE	varchar2(40);
12 	P_orderby	varchar2(40);
13 	P_ORDERBY_CAT	varchar2(298);
14 	P_ORDERBY_ITEM	varchar2(298);
15 	P_qty_precision	varchar2(40);
16 	P_CATEGORY_FROM	varchar2(900);
17 	P_CATEGORY_TO	varchar2(900);
18 	P_STRUCT_NUM	number;
19 	P_WHERE_CAT	varchar2(2000);
20 	P_wip_status	varchar2(32767);
21 	P_ORG_ID	varchar2(40);
22 	P_org_displayed	varchar2(240);
23 	P_TX_DATE_WHERE	varchar2(500);
24 	P_select_wip varchar2(2000);
25 	P_from_wip varchar2(500);
26 	P_where_wip varchar2(2000);
27 	P_MTL_TX_DATE_WHERE varchar2(1000);
28 	P_VENDOR_NAME_WHERE varchar2(1000);
29 	function BeforeReport return boolean  ;
30 	function from_std_unitcost return character  ;
31 	function where_std_unit_cost return character  ;
32 	function get_std_unit_cost return character  ;
33 	function c_price_varianceformula(PO_Functional_Price in number, STD_UNIT_COST in number, moh_absorbed_per_unit in number, Quantity_received in number, c_precision in number) return number  ;
34 	function orderby_clauseFormula return VARCHAR2  ;
35 	procedure get_precision  ;
36 	function c_price_variance1formula(PO_Functional_Price1 in number, STD_UNIT_COST1 in number, moh_absorbed_per_unit1 in number, Quantity_received1 in number, c_precision in number) return number  ;
37 	function AfterPForm return boolean  ;
38 	function std_unit_cost_fformula(inventory_item_id in number, organization_id in varchar2, receipt_date in date, process_enabled_flag in varchar2, std_unit_cost in number, c_ext_precision in number) return number  ;
39 	function AfterReport return boolean  ;
40         /* Support for landed cost management */
41         function c_price_varianceformula_lcm(functional_landed_cost in number, prior_landed_cost in number, quantity_received in number, c_precision in number) return number;
42 
43 END PO_POXRCPPV_XMLP_PKG;
44