[Home] [Help]
PACKAGE: APPS.AR_RAXCBR_XMLP_PKG
Source
1 PACKAGE AR_RAXCBR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: RAXCBRS.pls 120.1 2008/01/08 15:18:15 abraghun noship $ */
3 P_CONC_REQUEST_ID number;
4 P_SORT_BY varchar2(50);
5 P_COMMITMENT_LOW varchar2(32767);
6 P_COMMITMENT_HIGH varchar2(32767);
7 P_AGREEMENT_NAME_LOW varchar2(50);
8 P_AGREEMENT_NAME_HIGH varchar2(50);
9 P_CUSTOMER_NUMBER_LOW varchar2(50);
10 P_CUSTOMER_NUMBER_HIGH varchar2(50);
11 P_CUSTOMER_NAME_LOW varchar2(50);
12 P_CUSTOMER_NAME_HIGH varchar2(50);
13 P_COMMITMENT_TYPE_LOW varchar2(50);
14 P_COMMITMENT_TYPE_HIGH varchar2(50);
15 P_END_DATE_LOW varchar2(50);
16 P_END_DATE_HIGH varchar2(50);
17 P_END_DATE_LOW_1 varchar2(50);
18 P_END_DATE_HIGH_1 varchar2(50);
19 P_CURRENCY_CODE_LOW varchar2(50);
20 P_CURRENCY_CODE_HIGH varchar2(50);
21 P_MIN_PRECISION number;
22 /*LP_CUSTOMER_NAME_LOW varchar2(200);
23 LP_CUSTOMER_NAME_HIGH varchar2(200);
24 LP_CUSTOMER_NUMBER_LOW varchar2(200);
25 LP_CUSTOMER_NUMBER_HIGH varchar2(200);
26 LP_COMMITMENT_LOW varchar2(200);
27 LP_COMMITMENT_HIGH varchar2(200);
28 LP_COMMITMENT_TYPE_LOW varchar2(200);
29 LP_COMMITMENT_TYPE_HIGH varchar2(200);
30 LP_AGREEMENT_NAME_LOW varchar2(200);
31 LP_AGREEMENT_NAME_HIGH varchar2(200);
32 LP_CURRENCY_CODE_LOW varchar2(200);
33 LP_CURRENCY_CODE_HIGH varchar2(200);
34 LP_END_DATE_LOW varchar2(200);
35 LP_END_DATE_HIGH varchar2(200);*/
36 LP_CUSTOMER_NAME_LOW varchar2(200) := ' ';
37 LP_CUSTOMER_NAME_HIGH varchar2(200) := ' ';
38 LP_CUSTOMER_NUMBER_LOW varchar2(200) := ' ';
39 LP_CUSTOMER_NUMBER_HIGH varchar2(200) := ' ';
40 LP_COMMITMENT_LOW varchar2(200) := ' ';
41 LP_COMMITMENT_HIGH varchar2(200) := ' ';
42 LP_COMMITMENT_TYPE_LOW varchar2(200) := ' ';
43 LP_COMMITMENT_TYPE_HIGH varchar2(200) := ' ';
44 LP_AGREEMENT_NAME_LOW varchar2(200) := ' ';
45 LP_AGREEMENT_NAME_HIGH varchar2(200) := ' ';
46 LP_CURRENCY_CODE_LOW varchar2(200) := ' ';
47 LP_CURRENCY_CODE_HIGH varchar2(200) := ' ';
48 LP_END_DATE_LOW varchar2(200) := ' ';
49 LP_END_DATE_HIGH varchar2(200) := ' ';
50 P_GL_DATE_LOW date;
51 P_GL_DATE_HIGH date;
52 P_TRX_DATE_LOW date;
53 P_TRX_DATE_HIGH date;
54 /*LP_GL_DATE_LOW varchar2(200);
55 LP_GL_DATE_HIGH varchar2(200);
56 LP_TRX_DATE_HIGH varchar2(200);
57 LP_TRX_DATE_LOW varchar2(200);*/
58 LP_GL_DATE_LOW varchar2(200):= ' ';
59 LP_GL_DATE_HIGH varchar2(200):= ' ';
60 LP_TRX_DATE_HIGH varchar2(200):= ' ';
61 LP_TRX_DATE_LOW varchar2(200):= ' ';
62 P_SO_SOURCE_CODE varchar2(240);
63 P_LEVEL varchar2(30);
64 --LP_UNBOOKED varchar2(200);
65 LP_UNBOOKED varchar2(200):= ' ';
66 P_UNBOOKED varchar2(1);
67 RP_COMPANY_NAME varchar2(50);
68 RP_REPORT_NAME varchar2(80);
69 RP_DATA_FOUND varchar2(100);
70 c_industry_code varchar2(20);
71 c_salesrep_title varchar2(20);
72 c_salesorder_title varchar2(20);
73 function BeforeReport return boolean ;
74 function AfterReport return boolean ;
75 function report_nameformula(Company_Name in varchar2) return varchar2 ;
76 function c_adjusted_amount_childformula(source in varchar2, trx_class in varchar2, child_customer_trx_id in number, commit_type in varchar2, customer_trx_id1 in number) return number ;
77 function c_oe_amountformula(customer_trx_id1 in number) return number ;
78 function c_commitment_balanceformula(commitment_amount in number, customer_trx_id in number, commit_type in varchar2) return varchar2 ;
79 function AfterPForm return boolean ;
80 procedure get_lookup_meaning(p_lookup_type in VARCHAR2,
81 p_lookup_code in VARCHAR2,
82 p_lookup_meaning in out NOCOPY VARCHAR2)
83 ;
84 procedure get_boiler_plates ;
85 function set_display_for_core(p_field_name in VARCHAR2)
86 return boolean ;
87 function set_display_for_gov(p_field_name in VARCHAR2)
88 return boolean ;
89 function C_Order_ByFormula return Char ;
90 function c_commitment_remformula(commitment_amount in number, c_commitment_balance in varchar2, c_oe_amount in number) return number ;
91 function c_adj_amt_cmformula(source1 in varchar2, commit_type in varchar2, child_customer_trx_id in number, child_cm_customer_trx_id in number, customer_trx_id1 in number) return number ;
92 function c_sum_invoiced_amount_arformul(sum_invoiced_amount_inv in number, sum_invoiced_amount_cm in number) return number ;
93 function c_sum_tax_amount_arformula(sum_tax_amount_inv in number, sum_tax_amount_cm in number) return number ;
94 function c_sum_freight_amount_arformula(sum_freight_amount_inv in number, sum_freight_amount_cm in number) return number ;
95 function c_sum_line_amount_arformula(sum_line_amount_inv in number, sum_line_amount_cm in number) return number ;
96 function c_sum_adjusted_amount_arformul(sum_adjusted_amount_inv in number, sum_adjusted_amount_cm in number) return number ;
97 function c_sum_bal_amount_arformula(sum_bal_amount_inv in number, sum_bal_amount_cm in number) return number ;
98 function C_FORMAT_LEVELFormula return Char ;
99 Function RP_COMPANY_NAME_p return varchar2;
100 Function RP_REPORT_NAME_p return varchar2;
101 Function RP_DATA_FOUND_p return varchar2;
102 Function c_industry_code_p return varchar2;
103 Function c_salesrep_title_p return varchar2;
104 Function c_salesorder_title_p return varchar2;
105 END AR_RAXCBR_XMLP_PKG;
106