PACKAGE BODY: APPS.AP_APXSOBLX_XMLP_PKG

Source

1 PACKAGE BODY AP_APXSOBLX_XMLP_PKG AS
2 /* $Header: APXSOBLXB.pls 120.0 2007/12/27 08:30:19 vjaganat noship $ */
3 function cf_cur_totalformula(c_inv_total in number, c_prepay_total in number) return number is
4 begin
5   /*srw.reference(c_inv_total);*/null;
6   /*srw.reference(c_prepay_total);*/null;
7 return(c_inv_total-nvl(c_prepay_total,0));
8 end;
9 function CF_as_of_date_displayFormula return char is
10 day varchar2(2);
11 month varchar2(30);
12 year varchar2(4);
13 begin
14 month:=rtrim(to_char(p_as_of_date,'Month'),' ');
15 day:=to_char(p_as_of_date,'DD');
16 year:=to_char(p_as_of_DATE,'YYYY');
17 return(month||' '||day||','||year);
18 end;
19 function BeforeReport return boolean is
20 l_date date;
21 begin
22   begin
23 /*srw.user_exit('FND SRWINIT');*/null;
24 P_CONC_REQUEST_ID:=FND_GLOBAL.conc_request_id;
25 l_date:=fnd_date.chardate_to_date(p_as_of_date);
26 p_as_of_date_1 := to_char(p_as_of_date,'DD-MON-YY');
27 AP_GET_SUPPLIER_BALANCE_PKG.ap_get_supplier_balance(
28                                 p_conc_request_id
29                                ,p_set_of_books_id
30                                ,l_date
31                                ,p_supplier_name_from
32                                ,p_supplier_name_to
33                                ,p_currency
34                                ,p_min_invoice_balance
35                                ,p_min_open_balance
36                                ,p_include_prepayments
37                                ,p_reference_number
38                                ,p_debug_flag
39                                ,p_trace_flag
40                                       );
41    end;
42   return (TRUE);
43 end;
44 function AfterReport return boolean is
45 begin
46   /*srw.user_exit('FND SRWEXIT');*/null;
47   return (TRUE);
48 end;
49 function cf_displayformula(CF_cur_total in number) return number is
50 begin
51         IF CF_cur_total >= p_min_open_balance THEN
52   	return (1);
53   ELSE
54 	return(0);
55   END IF;
56 end;
57 --Functions to refer Oracle report placeholders--
58 END AP_APXSOBLX_XMLP_PKG ;
59