PACKAGE BODY: APPS.FA_FASPARTX_XMLP_PKG

Source

1 PACKAGE BODY FA_FASPARTX_XMLP_PKG AS
2 /* $Header: FASPARTXB.pls 120.0.12010000.1 2008/07/28 13:17:14 appldev ship $ */
3 
4 function report_nameformula(Company_Name in varchar2) return varchar2 is
5 begin
6  P_CONC_REQUEST_ID := fnd_global.CONC_REQUEST_ID;
7 
8 DECLARE
9   l_report_name VARCHAR2(80);
10 BEGIN
11   RP_Company_Name := Company_Name;
12   SELECT cp.user_concurrent_program_name
13   INTO   l_report_name
14   FROM    FND_CONCURRENT_PROGRAMS_VL cp,
15          FND_CONCURRENT_REQUESTS cr
16   WHERE  cr.request_id = P_CONC_REQUEST_ID
17   AND    cp.application_id = cr.program_application_id
18   AND    cp.concurrent_program_id=cr.concurrent_program_id;
19 
20   RP_Report_Name := l_report_name;
21   RETURN(l_report_name);
22 
23 EXCEPTION
24   WHEN OTHERS THEN
25     RP_Report_Name := ':Parent Asset Transactions Report:';
26     RETURN(RP_REPORT_NAME);
27 END;
28 RETURN NULL; end;
29 
30 function BeforeReport return boolean is
31 begin
32 
33 /*SRW.USER_EXIT('FND SRWINIT');*/null;
34   return (TRUE);
35 end;
36 
37 function AfterReport return boolean is
38 begin
39 
40 /*SRW.USER_EXIT('FND SRWEXIT');*/null;
41   return (TRUE);
42 end;
43 
44 function Period1_PCFormula return Number is
45 begin
46 
47 DECLARE
48   l_period_POD  DATE;
49   l_period_PCD  DATE;
50   l_period_PC   NUMBER(15);
51   l_period_FY   NUMBER(15);
52 BEGIN
53   SELECT period_counter,
54          period_open_date,
55          nvl(period_close_date, sysdate),
56          fiscal_year
57   INTO   l_period_PC,
58          l_period_POD,
59          l_period_PCD,
60          l_period_FY
61   FROM   FA_DEPRN_PERIODS
62   WHERE  book_type_code = P_BOOK
63   AND    period_name    = P_PERIOD1;
64 
65   Period1_POD := l_period_POD;
66   Period1_PCD := l_period_PCD;
67   Period1_FY  := l_period_FY;
68   return(l_period_PC);
69 END;
70 RETURN NULL; end;
71 
72 --Functions to refer Oracle report placeholders--
73 
74  Function ACCT_BAL_APROMPT_p return varchar2 is
75 	Begin
76 	 return ACCT_BAL_APROMPT;
77 	 END;
78  Function ACCT_CC_APROMPT_p return varchar2 is
79 	Begin
80 	 return ACCT_CC_APROMPT;
81 	 END;
82  Function CAT_MAJ_RPROMPT_p return varchar2 is
83 	Begin
84 	 return CAT_MAJ_RPROMPT;
85 	 END;
86  Function Period1_POD_p return date is
87 	Begin
88 	 return Period1_POD;
89 	 END;
90  Function Period1_PCD_p return date is
91 	Begin
92 	 return Period1_PCD;
93 	 END;
94  Function Period1_FY_p return number is
95 	Begin
96 	 return Period1_FY;
97 	 END;
98  Function RP_COMPANY_NAME_p return varchar2 is
99 	Begin
100 	 return RP_COMPANY_NAME;
101 	 END;
102  Function RP_REPORT_NAME_p return varchar2 is
103 	Begin
104 	 return RP_REPORT_NAME;
105 	 END;
106 END FA_FASPARTX_XMLP_PKG ;
107