1 PACKAGE BODY CE_BNK_STMT_RECON_RPT_PKG
2 -- $Header: CEBNKSTMTRECONB.pls 120.0.12000000.2 2007/06/09 01:43:32 csutaria noship $
3 --*****************************************************************************
4 -- Copyright (c) 2000 Oracle Solution Services (India) Product Development
5 -- All rights reserved
6 --*****************************************************************************
7 --
8 --
9 -- PROGRAM NAME
10 -- CEBNKSTMTRECONB.pls
11 --
12 -- DESCRIPTION
13 -- This script creates the package body of CE_BNK_STMT_RECON_RPT_PKG.
14 -- This package is used by the 'Israel - Bank Statement Reconciliation' report.
15 --
16 -- USAGE
17 --
18 -- To execute This can be applied by running this script at SQL*Plus.
19 --
20 -- PROGRAM LIST DESCRIPTION
21 --
22 -- beforeReportTrigger It is a public function which is run just after the
23 -- queries are parsed and before queries are executed.
24 --
25 -- DEPENDENCIES
26 -- None
27 --
28 -- CALLED BY
29 -- DataTemplate Extract in 'Israel - Bank Statement Reconciliation' report.
30 --
31 -- LAST UPDATE DATE 10-FEB-2007
32 --
33 --
34 -- HISTORY
35 -- =======
36 --
37 -- VERSION DATE AUTHOR(S) DESCRIPTION
38 -- ------- ----------- ----------------- ------------------------------------
39 -- Draft1A 10-FEB-2007 Harsh Poddar Draft Version
40 --***************************************************************************
41
42 AS
43
44 FUNCTION beforeReportTrigger RETURN BOOLEAN IS
45
46 BEGIN
47
48 cep_standard.init_security;
49 ce_auto_bank_match.set_all;
50 --Added the Quotes for the Values retrieved
51 gc_trx_type_payment := ''''||fnd_message.get_string('CE','CE_BNK_STMT_RECON_PAYMENT')||'''';
52 gc_trx_type_receipt := ''''||fnd_message.get_string('CE','CE_BNK_STMT_RECON_RECEIPT')||'''';
53 gc_origin_accounted := ''''||fnd_message.get_string('CE','CE_BNK_STMT_RECON_ACCOUNTED')||'''';
54 gc_origin_bank_stmt := ''''||fnd_message.get_string('CE','CE_BNK_STMT_RECON_BANK_STMT')||'''';
55
56 SELECT cibav.bank_account_name, cibav.currency_code
57 INTO gc_bank_account_name, gc_currency_code
58 FROM ce_internal_bank_accounts_v cibav
59 WHERE cibav.bank_account_id = P_BANK_ACCOUNT_ID;
60
61 SELECT csp.set_of_books_id
62 INTO gn_sob_id
63 FROM ce_system_parameters csp,
64 ce_bank_accts_gt_v cbagv
65 WHERE csp.legal_entity_id = cbagv.account_owner_org_id
66 AND cbagv.bank_account_id = P_BANK_ACCOUNT_ID;
67
68 SELECT glp.start_date
69 INTO gc_from_date
70 FROM gl_period_statuses glp
71 WHERE glp.application_id = 101
72 AND glp.period_name = P_ACC_PERIOD_FROM
73 AND glp.set_of_books_id = gn_sob_id;
74
75 SELECT glp.end_date
76 INTO gc_to_date
77 FROM gl_period_statuses glp
78 WHERE glp.application_id = 101
79 AND glp.period_name = P_ACC_PERIOD_TO
80 AND glp.set_of_books_id = gn_sob_id;
81
82 RETURN (TRUE);
83
84 END beforeReportTrigger;
85
86 END CE_BNK_STMT_RECON_RPT_PKG;