[Home] [Help]
PACKAGE: APPS.PA_PAXEXONE_XMLP_PKG
Source
1 PACKAGE PA_PAXEXONE_XMLP_PKG AS
2 /* $Header: PAXEXONES.pls 120.0 2008/01/02 11:31:42 krreddy noship $ */
3 EMPLOYEE_ID number;
4 DATE_LOW date;
5 DATE_HIGH date;
6 INCURRED_ORG number;
7 INC_ROUTING_HISTORY varchar2(40);
8 P_CONC_REQUEST_ID number;
9 P_debug_mode varchar2(3);
10 P_rule_optimizer varchar2(3);
11 EXP_ID number;
12 p_ca_set_of_books_id number;
13 p_ca_org_id number;
14 p_mrcsobtype varchar2(10);
15 lp_pa_implementations varchar2(50);
16 lp_pa_implementations_all varchar2(50);
17 lp_pa_expenditure_items varchar2(50);
18 lp_pa_expenditure_items_all varchar2(50);
19 lp_pa_cost_dist_lines varchar2(50);
20 lp_pa_cost_dist_lines_all varchar2(50);
21 lp_pa_expenditures varchar2(50);
22 lp_pa_expenditures_all varchar2(50);
23 lp_pa_proj_expend_view varchar2(50);
24 lp_pa_ei_denorm_v varchar2(50):='pa_ei_denorm_v';
25 lp_ap_invoice_dist varchar2(50):='ap_invoice_distributions';
26 lp_pa_cost_xfer_audit varchar2(50);
27 C_COMPANY_NAME_HEADER varchar2(50);
28 C_employee_name varchar2(80);
29 c_no_data_found varchar2(80);
30 c_incurred_org varchar2(32);
31 FUNCTION get_cover_page_values RETURN BOOLEAN ;
32 function BeforeReport return boolean ;
33 FUNCTION get_company_name RETURN BOOLEAN ;
34 function c_billable_expensesformula(c_total_expenses in number, c_total_billable_expenses in number) return number ;
35 function AfterReport return boolean ;
36 function c_display_total_bill_expformul(c_total_billable_expenses in number) return varchar2 ;
37 function c_display_total_expformula(c_total_expenses in number) return varchar2 ;
38 function c_display_bill_expformula(c_billable_expenses in number) return varchar2 ;
39 function c_expensesformula(expenses in number) return varchar2 ;
40 function c_billable_expformula(billable_expenses in number) return varchar2 ;
41 function c_disp_rep_expensesformula(c_rep_expenses in number) return varchar2 ;
42 function c_amountformula(amount in number) return char ;
43 function c_amount1formula(sse_amount in number) return char ;
44 function c_dis_sum_invoiceformula(c_sum_invoice in number) return char ;
45 function c_disp_sum_sseformula(c_sum_sse in number) return char ;
46 function c_dis_sum_invoice1formula(c_sum_invoice1 in number) return char ;
47 function c_disp_sum_sse1formula(c_sum_sse1 in number) return char ;
48 function c_bill_pctformula(c_sum_invoice in number, c_sum_invoice1 in number) return char ;
49 function AfterPForm return boolean ;
50 Function C_COMPANY_NAME_HEADER_p return varchar2;
51 Function C_employee_name_p return varchar2;
52 Function c_no_data_found_p return varchar2;
53 Function c_incurred_org_p return varchar2;
54 END PA_PAXEXONE_XMLP_PKG;