eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.LNS_REP_UTILS dependencies on LNS_REP_UTILS

Line 1: PACKAGE BODY LNS_REP_UTILS as

1: PACKAGE BODY LNS_REP_UTILS as
2: /* $Header: LNS_REP_UTILS_B.pls 120.49.12020000.3 2012/08/14 18:28:41 scherkas ship $ */
3:
4: /*========================================================================
5: | PUBLIC PROCEDURE PRINT_CLOB

Line 2: /* $Header: LNS_REP_UTILS_B.pls 120.49.12020000.3 2012/08/14 18:28:41 scherkas ship $ */

1: PACKAGE BODY LNS_REP_UTILS as
2: /* $Header: LNS_REP_UTILS_B.pls 120.49.12020000.3 2012/08/14 18:28:41 scherkas ship $ */
3:
4: /*========================================================================
5: | PUBLIC PROCEDURE PRINT_CLOB
6: |

Line 31: G_PKG_NAME CONSTANT VARCHAR2(30):= 'LNS_REP_UTILS';

27:
28: /*=======================================================================+
29: | Package Global Constants
30: +=======================================================================*/
31: G_PKG_NAME CONSTANT VARCHAR2(30):= 'LNS_REP_UTILS';
32: G_LOG_ENABLED varchar2(5);
33: G_MSG_LEVEL NUMBER;
34: g_org_id number;
35:

Line 42: return lns_rep_utils.g_loan_start_date_from;

38: ========================================================================*/
39:
40: FUNCTION get_loan_start_date_from return DATE is
41: BEGIN
42: return lns_rep_utils.g_loan_start_date_from;
43: END get_loan_start_date_from;
44:
45: /*========================================================================+
46: Function which returns the global variable g_loan_start_date_to

Line 51: return lns_rep_utils.g_loan_start_date_to;

47: ========================================================================*/
48:
49: FUNCTION get_loan_start_date_to return DATE is
50: BEGIN
51: return lns_rep_utils.g_loan_start_date_to;
52: END get_loan_start_date_to;
53: /*========================================================================+
54: Function which returns the global variable g_bill_due_date_from
55: ========================================================================*/

Line 59: return lns_rep_utils.g_bill_due_date_from;

55: ========================================================================*/
56:
57: FUNCTION get_bill_due_date_from return DATE is
58: BEGIN
59: return lns_rep_utils.g_bill_due_date_from;
60: END get_bill_due_date_from;
61:
62: /*========================================================================+
63: Function which returns the global variable g_bill_due_date_to

Line 68: return lns_rep_utils.g_bill_due_date_to;

64: ========================================================================*/
65:
66: FUNCTION get_bill_due_date_to return DATE is
67: BEGIN
68: return lns_rep_utils.g_bill_due_date_to;
69: END get_bill_due_date_to;
70: /*========================================================================
71: | PRIVATE PROCEDURE LogMessage
72: |

Line 388: l_query := l_query || ' and trunc(lh.loan_start_date) >= lns_rep_utils.get_loan_start_date_from()';

384: THEN
385: l_query := l_query || ' and lh.cust_account_id = :CUST_ACCOUNT_ID';
386: END IF;
387: IF loan_start_date_from IS NOT NULL and loan_start_date_to is NULL THEN
388: l_query := l_query || ' and trunc(lh.loan_start_date) >= lns_rep_utils.get_loan_start_date_from()';
389: END IF;
390: IF loan_start_date_to IS NOT NULL and loan_start_date_from is NULL THEN
391: l_query := l_query || ' and trunc(lh.loan_start_date) <= lns_rep_utils.get_loan_start_date_to()';
392: END IF;

Line 391: l_query := l_query || ' and trunc(lh.loan_start_date) <= lns_rep_utils.get_loan_start_date_to()';

387: IF loan_start_date_from IS NOT NULL and loan_start_date_to is NULL THEN
388: l_query := l_query || ' and trunc(lh.loan_start_date) >= lns_rep_utils.get_loan_start_date_from()';
389: END IF;
390: IF loan_start_date_to IS NOT NULL and loan_start_date_from is NULL THEN
391: l_query := l_query || ' and trunc(lh.loan_start_date) <= lns_rep_utils.get_loan_start_date_to()';
392: END IF;
393: IF loan_start_date_from IS NOT NULL and loan_start_date_to is NOT NULL THEN
394: l_query := l_query || ' and trunc(lh.loan_start_date) between lns_rep_utils.get_loan_start_date_from() and lns_rep_utils.get_loan_start_date_to()';
395: END IF;

Line 394: l_query := l_query || ' and trunc(lh.loan_start_date) between lns_rep_utils.get_loan_start_date_from() and lns_rep_utils.get_loan_start_date_to()';

390: IF loan_start_date_to IS NOT NULL and loan_start_date_from is NULL THEN
391: l_query := l_query || ' and trunc(lh.loan_start_date) <= lns_rep_utils.get_loan_start_date_to()';
392: END IF;
393: IF loan_start_date_from IS NOT NULL and loan_start_date_to is NOT NULL THEN
394: l_query := l_query || ' and trunc(lh.loan_start_date) between lns_rep_utils.get_loan_start_date_from() and lns_rep_utils.get_loan_start_date_to()';
395: END IF;
396: IF legal_entity_id IS NOT NULL
397: THEN
398: l_query := l_query || ' and lh.legal_entity_id = :LEGAL_ENTITY_ID';

Line 841: '(select lns_rep_utils.get_bill_due_date_from() from_dt, ' ||

837: ' fund_act.lookup_code(+) = head.ACTIVITY_CODE) ' ||
838: 'AS Disbursement_Schedule ' ||
839: 'from ' ||
840: 'lns_loan_headers_all_vl lh, ' ||
841: '(select lns_rep_utils.get_bill_due_date_from() from_dt, ' ||
842: ' lns_rep_utils.get_bill_due_date_to() to_dt ' ||
843: ' from dual) dateparameters, ' ||
844: 'hz_parties hp, ' ||
845: 'lns_lookups llk, ' ||

Line 842: ' lns_rep_utils.get_bill_due_date_to() to_dt ' ||

838: 'AS Disbursement_Schedule ' ||
839: 'from ' ||
840: 'lns_loan_headers_all_vl lh, ' ||
841: '(select lns_rep_utils.get_bill_due_date_from() from_dt, ' ||
842: ' lns_rep_utils.get_bill_due_date_to() to_dt ' ||
843: ' from dual) dateparameters, ' ||
844: 'hz_parties hp, ' ||
845: 'lns_lookups llk, ' ||
846: 'LNS_PAY_SUM_V pay, ' ||

Line 881: ' trunc(am.DUE_DATE) between lns_rep_utils.get_bill_due_date_from() ' ||

877: ' (select loan_id ' ||
878: ' from lns_amortization_scheds am ' ||
879: ' where am.loan_id = lh.loan_id and ' ||
880: ' (REVERSED_FLAG is null or REVERSED_FLAG = ''N'') and ' ||
881: ' trunc(am.DUE_DATE) between lns_rep_utils.get_bill_due_date_from() ' ||
882: ' and lns_rep_utils.get_bill_due_date_to())';
883: l_temp_where_clause VARCHAR2(200);
884: BEGIN
885: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

Line 882: ' and lns_rep_utils.get_bill_due_date_to())';

878: ' from lns_amortization_scheds am ' ||
879: ' where am.loan_id = lh.loan_id and ' ||
880: ' (REVERSED_FLAG is null or REVERSED_FLAG = ''N'') and ' ||
881: ' trunc(am.DUE_DATE) between lns_rep_utils.get_bill_due_date_from() ' ||
882: ' and lns_rep_utils.get_bill_due_date_to())';
883: l_temp_where_clause VARCHAR2(200);
884: BEGIN
885: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
886: l_loan_type_id := loan_type_id;

Line 3402: END LNS_REP_UTILS;

3398: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
3399: end if;
3400:
3401: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
3402: END LNS_REP_UTILS;