PACKAGE: APPS.PO_POXPRRFP_XMLP_PKG

Source

1 PACKAGE PO_POXPRRFP_XMLP_PKG AS
2 /* $Header: POXPRRFPS.pls 120.1 2007/12/25 11:33:47 krreddy noship $ */
3 	P_report_type	varchar2(40);
4 	P_agent_id	varchar2(40);
5 	P_rfq_num_from	varchar2(40);
6 	P_rfq_num_to	varchar2(40);
7 	P_release_num_from	varchar2(40);
8 	P_release_num_to	varchar2(40);
9 	P_release_date_from	date;
10 	P_release_date_to	date;
11 	P_orderby	varchar2(40);
12 	P_FLEX_ITEM	varchar2(800);
13 	P_CONC_REQUEST_ID	number;
14 	PO_ITEM	varchar2(40);
15 	PO_HEADER_ID	varchar2(40);
16 	P_test_flag	varchar2(40);
17 	P_QTY_PRECISION	number;
18 	P_QTY_ORDERED	varchar2(40);
19 	P_user_id	number;
20 	MLS_FLAG	varchar2(1);
21 	p_description	varchar2(256);
22 	p_language_where	varchar2(400);
23 	temp_col_name	varchar2(40);
24 	p_uom_col_pol	varchar2(40);
25 	p_uom_col_pll	varchar2(40);
26 	p_uom_join_pll	varchar2(200);
27 	p_uom_join_pol	varchar2(200);
28 	P_fax_enable	varchar2(1);
29 	P_fax_num	varchar2(32767);
30 	P_SINGLE_RFQ_PRINT	number;
31 	C_address_at_top	varchar2(93);
32 	function where_clauseFormula return VARCHAR2  ;
33 	function BeforeReport return boolean  ;
34 	function AfterReport return boolean  ;
35 	function c_amount_pllformula(pll_quantity_ordered in number, pll_price_override in number) return number  ;
36 	function g_headersgroupfilter(rfq_num_type in varchar2, poh_rfq_num in varchar2,poh_po_header_id in number,poh_sequence_num in number) return boolean ;
37 	function c_shiptoformula(pll_ship_address_line1 in varchar2, poh_ship_address_line1 in varchar2, pll_ship_address_line2 in varchar2, poh_ship_address_line2 in varchar2,
38 	pll_ship_address_line3 in varchar2, poh_ship_address_line3 in varchar2, pll_ship_adr_info in varchar2, poh_ship_adr_info in varchar2, pll_ship_country in varchar2, poh_ship_country in varchar2) return varchar2  ;
39 	function check_security(poh_rfq_num in varchar2) return boolean  ;
40 	function round_pol_amt(c_amount_pol in number, c_currency_precision in number) return number  ;
41 	procedure POPULATE_MLS_LEXICALS  ;
42 	function mls_installed return boolean  ;
43 	function c_fax_headerformula(C_first_page in varchar2) return char  ;
44 	function c_fax_trailerformula(poh_no_of_lines in number, C_last_sum in number, CS_poh_vendor_name in varchar2, CS_poh_rfq_num in varchar2, CS_poh_buyer in varchar2, CS_poh_agent_id in varchar2) return char  ;
45 	function c_item_descformula(pol_po_item_id in number, pol_item_description in varchar2, C_msi_desc in varchar2, C_msit_desc in varchar2) return char  ;
46 	function header_noteformula(header_note_datatype_id in number, header_note_media_id in number) return char  ;
47 	function line_noteformula(line_note_datatype_id in number, line_note_media_id in number) return char  ;
48 	function item_noteformula(item_note_datatype_id in number, item_note_media_id in number) return char  ;
49 	Function C_address_at_top_p return varchar2;
50 END PO_POXPRRFP_XMLP_PKG;
51