PACKAGE: APPS.PO_POXRRCVV_XMLP_PKG

Source

1 PACKAGE PO_POXRRCVV_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: POXRRCVVS.pls 120.2 2011/07/20 23:36:04 fayang ship $ */
3 	P_CONC_REQUEST_ID	varchar2(32767);
4 	P_ORG_ID	varchar2(40);
5 	P_CURRENCY_CODE	varchar2(15);
6 	P_EXCHANGE_RATE	number;
7 	P_SORT_OPTION	varchar2(38);
8 	P_ITEM_FROM	varchar2(800);
9 	P_ITEM_TO	varchar2(800);
10 	P_CATEGORY_SET	number;
11 	P_CAT_NUM	number;
12 	P_CAT_FROM	varchar2(800);
13 	P_CAT_TO	varchar2(800);
14 	P_ZERO_COST	number;
15 	P_ORGANIZATION	varchar2(60);
16 	ROUND_UNIT	number := 1;
17 	FORMAT_MASK     varchar2(50);
18 	P_ITEM_SEG	varchar2(2400) := 'MSI.DESCRIPTION||MSI.DESCRIPTION||MSI.DESCRIPTION||MSI.DESCRIPTION||MSI.DESCRIPTION||MSI.DESCRIPTION';
19 	P_CAT_SEG	varchar2(2400) := 'MC.ATTRIBUTE1||MC.ATTRIBUTE1||MC.ATTRIBUTE1||MC.ATTRIBUTE1||MC.ATTRIBUTE1||MC.ATTRIBUTE1||MC.ATTRIBUTE1||MC.ATTRIBUTE1||MC.ATTRIBUTE1';
20 	P_ITEM_WHERE	varchar2(2400);
21 	P_CAT_WHERE	varchar2(2400);
22 	P_SORT_BY	varchar2(80);
23 	P_CAT_SET_NAME	varchar2(40);
24 	P_DETAIL_LEVEL	varchar2(80);
25 	P_COST_TYPE_ID	number;
26 	P_DEF_COST_TYPE	number :=1;
27 	P_COST_TYPE	varchar2(40);
28 	P_EXT_PREC	number;
29 	P_qty_precision	number;
30 	P_ORG_WHERE	varchar2(2400);
31 	P_RPT_OPTION	number;
32 	P_CURRENCY_DSP	varchar2(50);
33 	P_DOCUMENT_TYPE	varchar2(40);
34 	P_DOCUMENT_TYPE_DISPLAYED	varchar2(80);
35 	P_sort_option1	number;
36 	P_ITEM_REVISION	number;
37 	P_Title	varchar2(60);
38 	P_sort_header_displayed	varchar2(80);
39 	P_AS_OF_DATE	varchar2(30);
40 	P_AS_OF_DATE1	varchar2(30);
41 	P_ONE_TIME	number;
42 	P_PERIOD_END	number;
43 	function AfterReport return boolean  ;
44 	function BeforeReport return boolean  ;
45 	function itemcatformula(CATEGORY_PSEG in varchar2) return varchar2  ;
46 	function comp_avg_unit_price (ITEM_QUANTITY in number, ITEM_TOTAL_PUR_VALUE in number, c_ext_precision in number) return number  ;
47 	procedure get_precision1  ;
48 	function total_pur_valueformula(total_purchase_value in number) return number  ;
49 	function c_quantityformula(quantity in number) return number  ;
50 	function c_total_pur_valueformula(total_pur_value in number) return number  ;
51 	function CF_SORT_HEADER_DISPLAYEDFormul return Char  ;
52 	function CF_cat_range_dispFormula return Char  ;
53 	function CF_item_range_dispFormula return Char  ;
54 	function cf_item_cost_dispformula(SORT_COLUMN in varchar2) return char  ;
55 	function CF_MAIN_DISPFormula return Char  ;
56 	function CF_REV_DISPFormula return Char  ;
57 	function CF_CAT_DISPFormula return Char  ;
58 	function CF_cat_fromFormula return Char  ;
59 	function CF_cat_toFormula return Char  ;
60 	function CF_cost_typeFormula return Char  ;
61 	function CF_currency_dspFormula return Char  ;
62 	function CF_detail_levelFormula return Char  ;
63 	function CF_item_fromFormula return Char  ;
64 	function CF_item_toFormula return Char  ;
65 	function CF_titleFormula return Char  ;
66 	function CF_cat_set_nameFormula return Char  ;
67 	function CF_SORT_DISPFormula return Char  ;
68 END PO_POXRRCVV_XMLP_PKG;
69