PACKAGE BODY: APPS.AP_APXSOBLX_XMLP_PKG

Source

1 PACKAGE BODY AP_APXSOBLX_XMLP_PKG AS
2 /* $Header: APXSOBLXB.pls 120.1 2011/03/03 11:53:15 asansari ship $ */
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 l_calendar_unaware  NUMBER :=0; --Bug11774150
22 begin
23   begin
24 /*srw.user_exit('FND SRWINIT');*/null;
25 P_CONC_REQUEST_ID:=FND_GLOBAL.conc_request_id;
26 l_date:=fnd_date.chardate_to_date(chardate => p_as_of_date, calendar_aware => l_calendar_unaware); --Bug11774150
27 p_as_of_date_1 := to_char(p_as_of_date,'DD-MON-YY');
28 AP_GET_SUPPLIER_BALANCE_PKG.ap_get_supplier_balance(
29                                 p_conc_request_id
30                                ,p_set_of_books_id
31                                ,l_date
32                                ,p_supplier_name_from
33                                ,p_supplier_name_to
34                                ,p_currency
35                                ,p_min_invoice_balance
36                                ,p_min_open_balance
37                                ,p_include_prepayments
38                                ,p_reference_number
39                                ,p_debug_flag
40                                ,p_trace_flag
41                                       );
42    end;
43   return (TRUE);
44 end;
45 function AfterReport return boolean is
46 begin
47   /*srw.user_exit('FND SRWEXIT');*/null;
48   return (TRUE);
49 end;
50 function cf_displayformula(CF_cur_total in number) return number is
51 begin
52         IF CF_cur_total >= p_min_open_balance THEN
53   	return (1);
54   ELSE
55 	return(0);
56   END IF;
57 end;
58 --Functions to refer Oracle report placeholders--
59 END AP_APXSOBLX_XMLP_PKG ;
60