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.XTR_COMMON_FUNCTIONS dependencies on XTR_DEALS

Line 35: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE) RETURN BOOLEAN IS

31: *
32: */
33:
34: FUNCTION DEAL_STATUS_CHECK(
35: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE) RETURN BOOLEAN IS
36:
37: CURSOR chk_status is
38: SELECT 1
39: FROM xtr_deals_v

Line 39: FROM xtr_deals_v

35: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE) RETURN BOOLEAN IS
36:
37: CURSOR chk_status is
38: SELECT 1
39: FROM xtr_deals_v
40: WHERE deal_no = p_deal_number
41: AND status_code = 'CURRENT';
42:
43: l_dummy number(1);

Line 137: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,

133: * 14-JUL-2005 Rajesh Jose o Created.
134: */
135:
136: FUNCTION INTEREST_CHECK_COVER(
137: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
138: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
139: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
140: DEFAULT NULL,
141: p_date IN DATE DEFAULT NULL,

Line 138: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,

134: */
135:
136: FUNCTION INTEREST_CHECK_COVER(
137: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
138: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
139: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
140: DEFAULT NULL,
141: p_date IN DATE DEFAULT NULL,
142: p_maturity_date IN DATE DEFAULT NULL,

Line 139: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE

135:
136: FUNCTION INTEREST_CHECK_COVER(
137: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
138: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
139: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
140: DEFAULT NULL,
141: p_date IN DATE DEFAULT NULL,
142: p_maturity_date IN DATE DEFAULT NULL,
143: p_check_intset_record IN VARCHAR2 DEFAULT 'N') RETURN BOOLEAN IS

Line 222: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,

218: * 14-JUL-2005 Rajesh Jose o Created.
219: */
220:
221: FUNCTION SETTLED_INTEREST_CHECK(
222: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
223: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
224: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
225: DEFAULT NULL,
226: p_date IN DATE DEFAULT NULL,

Line 223: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,

219: */
220:
221: FUNCTION SETTLED_INTEREST_CHECK(
222: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
223: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
224: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
225: DEFAULT NULL,
226: p_date IN DATE DEFAULT NULL,
227: p_maturity_date IN DATE DEFAULT NULL,

Line 224: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE

220:
221: FUNCTION SETTLED_INTEREST_CHECK(
222: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
223: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
224: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
225: DEFAULT NULL,
226: p_date IN DATE DEFAULT NULL,
227: p_maturity_date IN DATE DEFAULT NULL,
228: p_check_intset_record IN VARCHAR2 DEFAULT 'N') RETURN BOOLEAN IS

Line 340: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,

336: * 14-JUL-2005 Rajesh Jose o Created.
337: */
338:
339: FUNCTION INTEREST_REVALUED_CHECK(
340: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
341: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
342: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
343: DEFAULT NULL,
344: p_date IN DATE DEFAULT NULL) RETURN BOOLEAN IS

Line 341: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,

337: */
338:
339: FUNCTION INTEREST_REVALUED_CHECK(
340: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
341: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
342: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
343: DEFAULT NULL,
344: p_date IN DATE DEFAULT NULL) RETURN BOOLEAN IS
345:

Line 342: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE

338:
339: FUNCTION INTEREST_REVALUED_CHECK(
340: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
341: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
342: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
343: DEFAULT NULL,
344: p_date IN DATE DEFAULT NULL) RETURN BOOLEAN IS
345:
346: CURSOR chk_reval_tmm_irs(l_date date) IS

Line 437: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,

433: * 14-JUL-2005 Rajesh Jose o Created.
434: */
435:
436: FUNCTION INTEREST_ACCRUAL_CHECK(
437: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
438: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
439: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
440: DEFAULT NULL,
441: p_date IN DATE DEFAULT NULL) RETURN BOOLEAN IS

Line 438: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,

434: */
435:
436: FUNCTION INTEREST_ACCRUAL_CHECK(
437: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
438: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
439: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
440: DEFAULT NULL,
441: p_date IN DATE DEFAULT NULL) RETURN BOOLEAN IS
442:

Line 439: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE

435:
436: FUNCTION INTEREST_ACCRUAL_CHECK(
437: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
438: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
439: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
440: DEFAULT NULL,
441: p_date IN DATE DEFAULT NULL) RETURN BOOLEAN IS
442:
443: l_accrual_check NUMBER;

Line 507: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,

503: * 14-JUL-2005 Rajesh Jose o Created.
504: */
505:
506: FUNCTION INTEREST_JOURNAL_CHECK(
507: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
508: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
509: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
510: DEFAULT NULL,
511: p_date IN DATE DEFAULT NULL,

Line 508: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,

504: */
505:
506: FUNCTION INTEREST_JOURNAL_CHECK(
507: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
508: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
509: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
510: DEFAULT NULL,
511: p_date IN DATE DEFAULT NULL,
512: p_check_intset_record IN VARCHAR2 DEFAULT 'N') RETURN BOOLEAN IS

Line 509: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE

505:
506: FUNCTION INTEREST_JOURNAL_CHECK(
507: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
508: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
509: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
510: DEFAULT NULL,
511: p_date IN DATE DEFAULT NULL,
512: p_check_intset_record IN VARCHAR2 DEFAULT 'N') RETURN BOOLEAN IS
513:

Line 605: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,

601: * 14-JUL-2005 Rajesh Jose o Created.
602: */
603:
604: FUNCTION INTEREST_RECONCILED_CHECK(
605: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
606: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
607: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
608: DEFAULT NULL,
609: p_date IN DATE DEFAULT NULL) RETURN BOOLEAN IS

Line 606: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,

602: */
603:
604: FUNCTION INTEREST_RECONCILED_CHECK(
605: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
606: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
607: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
608: DEFAULT NULL,
609: p_date IN DATE DEFAULT NULL) RETURN BOOLEAN IS
610:

Line 607: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE

603:
604: FUNCTION INTEREST_RECONCILED_CHECK(
605: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
606: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
607: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
608: DEFAULT NULL,
609: p_date IN DATE DEFAULT NULL) RETURN BOOLEAN IS
610:
611: CURSOR chk_recon IS

Line 672: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,

668: * 14-JUL-2005 Rajesh Jose o Created.
669: */
670:
671: FUNCTION SETTLED_INTEREST_TAX_CHECK(
672: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
673: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
674: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
675: DEFAULT NULL,
676: p_date IN DATE DEFAULT NULL,

Line 673: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,

669: */
670:
671: FUNCTION SETTLED_INTEREST_TAX_CHECK(
672: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
673: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
674: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
675: DEFAULT NULL,
676: p_date IN DATE DEFAULT NULL,
677: p_maturity_date IN DATE DEFAULT NULL) RETURN BOOLEAN IS

Line 674: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE

670:
671: FUNCTION SETTLED_INTEREST_TAX_CHECK(
672: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
673: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
674: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
675: DEFAULT NULL,
676: p_date IN DATE DEFAULT NULL,
677: p_maturity_date IN DATE DEFAULT NULL) RETURN BOOLEAN IS
678: