PACKAGE: APPS.AR_ARXTDR_XMLP_PKG

Source

1 PACKAGE AR_ARXTDR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: ARXTDRS.pls 120.0 2007/12/27 14:11:32 abraghun noship $ */
3 	P_CONC_REQUEST_ID	number;
4 	P_INVOICE_NUM_LOW	varchar2(32767);
5 	P_INVOICE_NUM_HIGH	varchar2(32767);
6 	P_TRANSACTION_TYPE	varchar2(32767);
7 	--P_CONS_PROFILE_VALUE	varchar2(10);
8 	P_CONS_PROFILE_VALUE	varchar2(10):= 'N';
9 	LP_QUERY_SHOW_BILL	varchar2(1000):='arps.trx_number';
10 	LP_TABLE_SHOW_BILL	varchar2(1000):= ' ';
11 	LP_WHERE_SHOW_BILL	varchar2(1000):= ' ';
12 	P_BASE_LANG	varchar2(4);
13 	RP_COMPANY_NAME	varchar2(30);
14 	RP_REPORT_NAME	varchar2(80);
15 	RP_DATA_FOUND	varchar2(3);
16 	RP_LINES	number;
17 	RP_FR_LINES	number;
18 	RP_TX_LINES	number;
19 	RP_SALESREPS	number;
20 	RP_REV_ACCTS	number;
21 	RP_TX_CUST_TRX_ID	number;
22 	CP_ACC_MESSAGE	varchar2(2000);
23 	P_TRANSACTION_TYPE_DUMMY varchar2(32767);
24 	function report_nameformula(Company_Name in varchar2) return varchar2  ;
25 	function YES_MEANINGFormula return VARCHAR2  ;
26 	function NO_MEANINGFormula return VARCHAR2  ;
27 	function TRX_FLEX_DELIMFormula return VARCHAR2  ;
28 	function LOC_FLEX_ALL_SEGFormula return VARCHAR2  ;
29 	function BeforeReport return boolean  ;
30 	function AfterReport return boolean  ;
31 	function ship_to_address5formula(ship_to_city in varchar2, ship_to_state in varchar2, ship_to_postal_code in varchar2, ship_to_country in varchar2) return varchar2  ;
32 	function bill_to_address5formula(bill_to_city in varchar2, bill_to_state in varchar2, bill_to_postal_code in varchar2, bill_to_country in varchar2) return varchar2  ;
33 	--function d_sold_toformula(sold_to_customer_number in varchar2) return varchar2  ;
34 	function d_sold_toformula(sold_to_customer_number in varchar2,sold_to_customer_name in varchar2) return varchar2 ;
35 	function d_remit_toformula(remit_to_address1 in varchar2, remit_to_address2 in varchar2, remit_to_address3 in varchar2,
36 	remit_to_address4 in varchar2, remit_to_city in varchar2, remit_to_state in varchar2, remit_to_postal_code in varchar2, remit_to_country in varchar2) return varchar2  ;
37 	function D_LOCATIONFormula return VARCHAR2  ;
38 	function ITEM_FLEX_STRUCTUREFormula return Number  ;
39 	function RP_INV_RANGEFormula return VARCHAR2  ;
40 	function tr_inv_amountformula(TR_LN_EXTD_AMOUNT in number, TR_TX_EXTD_AMOUNT in number, TR_FR_EXTD_AMOUNT in number) return number  ;
41 	function ln_additional_infoformula(LN_ORDER_NUMBER in varchar2, LN_ORDER_DATE in date, LN_ORDER_REVISION in number, LN_SALES_CHANNEL in varchar2,
42 	LN_DURATION in number, LN_ACCOUNTING_RULE in varchar2, LN_RULE_START_DATE in date) return varchar2  ;
43 	function trx_transaction_flexformula(customer_trx_id in number) return varchar2  ;
44 	function line_transaction_flexformula(tf_customer_trx_line_id in number) return varchar2  ;
45 	FUNCTION COMP_TX_CUST_TRX_ID (P_CUST_TRX_ID number) RETURN boolean  ;
46 	function cf_acc_messageformula(acc_gl_date in date) return number  ;
47 	Function RP_COMPANY_NAME_p return varchar2;
48 	Function RP_REPORT_NAME_p return varchar2;
49 	Function RP_DATA_FOUND_p return varchar2;
50 	Function RP_LINES_p return number;
51 	Function RP_FR_LINES_p return number;
52 	Function RP_TX_LINES_p return number;
53 	Function RP_SALESREPS_p return number;
54 	Function RP_REV_ACCTS_p return number;
55 	Function RP_TX_CUST_TRX_ID_p return number;
56 	Function CP_ACC_MESSAGE_p return varchar2;
57 END AR_ARXTDR_XMLP_PKG;
58