[Home] [Help]
PACKAGE BODY: APPS.CSD_REPAIR_ESTIMATE_REPORT_PVT
Source
1 PACKAGE BODY CSD_Repair_Estimate_Report_Pvt AS
2 /* $Header: csdvertb.pls 120.3 2008/03/20 20:44:15 rfieldma noship $ */
3
4
5
6 /*--------------------------------------------------*/
7 /* procedure name: BEFORE_REPORT */
8 /* description : auto gen by XDO converter */
9 /* may have data source logic later */
10 /* */
11 /*--------------------------------------------------*/
12 function BeforeReport return boolean is
13 begin
14
15
16 /*SRW.USER_EXIT('FND SRWINIT');*/null;
17
18 return (TRUE);
19 end;
20
21
22
23 /*--------------------------------------------------*/
24 /* procedure name: AFTER_REPORT */
25 /* description : auto gen by XDO converter */
26 /* may have data source logic later */
27 /* */
28 /*--------------------------------------------------*/
29 function AfterReport return boolean is
30 begin
31
32 /*SRW.USER_EXIT('FND SRWEXIT');*/null;
33
34 return (TRUE);
35 end;
36
37
38 /*---------------------------------------------------*/
39 /*procedure name:CF_CUST_POFormula */
40 /* description :Procedure to return the PO number of*/
41 /* repair order line */
42 /*---------------------------------------------------*/
43
44
45 function CF_CUST_POFormula return varchar2 is
46 l_po_number csd_repair_estimate.po_number%type;
47 begin
48
49 select po_number
50 INTO l_po_number
51 from csd_repair_estimate cre
52 where cre.repair_line_id =P_REPAIR_LINE_ID;
53
54 Return l_po_number;
55
56 /*------------------------------------------------------*/
57 /*Exceptions */
58 /* description : Incase of exceptions returning null. */
59 /*------------------------------------------------------*/
60
61
62 Exception
63 When Others then
64 return ' ';
65 end;
66
67 --Functions to refer Oracle report placeholders--
68
69 END CSD_Repair_Estimate_Report_Pvt;