31: *
32: */
33:
34: FUNCTION DEAL_STATUS_CHECK(
35: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE) RETURN BOOLEAN;
36:
37: /**
38: * FUNCTION INTEREST_OVERRIDE_CHECK
39: *
93: * 14-JUL-2005 Rajesh Jose o Created.
94: */
95:
96: FUNCTION INTEREST_CHECK_COVER(
97: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
98: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
99: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
100: DEFAULT NULL,
101: p_date IN DATE DEFAULT NULL,
94: */
95:
96: FUNCTION INTEREST_CHECK_COVER(
97: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
98: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
99: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
100: DEFAULT NULL,
101: p_date IN DATE DEFAULT NULL,
102: p_maturity_date IN DATE DEFAULT NULL,
95:
96: FUNCTION INTEREST_CHECK_COVER(
97: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
98: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
99: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
100: DEFAULT NULL,
101: p_date IN DATE DEFAULT NULL,
102: p_maturity_date IN DATE DEFAULT NULL,
103: p_check_intset_record IN VARCHAR2 DEFAULT 'N') RETURN BOOLEAN;
131: * 14-JUL-2005 Rajesh Jose o Created.
132: */
133:
134: FUNCTION SETTLED_INTEREST_CHECK(
135: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
136: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
137: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
138: DEFAULT NULL,
139: p_date IN DATE DEFAULT NULL,
132: */
133:
134: FUNCTION SETTLED_INTEREST_CHECK(
135: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
136: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
137: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
138: DEFAULT NULL,
139: p_date IN DATE DEFAULT NULL,
140: p_maturity_date IN DATE DEFAULT NULL,
133:
134: FUNCTION SETTLED_INTEREST_CHECK(
135: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
136: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
137: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
138: DEFAULT NULL,
139: p_date IN DATE DEFAULT NULL,
140: p_maturity_date IN DATE DEFAULT NULL,
141: p_check_intset_record IN VARCHAR2 DEFAULT 'N') RETURN BOOLEAN;
166: * 14-JUL-2005 Rajesh Jose o Created.
167: */
168:
169: FUNCTION INTEREST_REVALUED_CHECK(
170: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
171: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
172: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
173: DEFAULT NULL,
174: p_date IN DATE DEFAULT NULL) RETURN BOOLEAN;
167: */
168:
169: FUNCTION INTEREST_REVALUED_CHECK(
170: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
171: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
172: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
173: DEFAULT NULL,
174: p_date IN DATE DEFAULT NULL) RETURN BOOLEAN;
175:
168:
169: FUNCTION INTEREST_REVALUED_CHECK(
170: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
171: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
172: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
173: DEFAULT NULL,
174: p_date IN DATE DEFAULT NULL) RETURN BOOLEAN;
175:
176: /**
200: * 14-JUL-2005 Rajesh Jose o Created.
201: */
202:
203: FUNCTION INTEREST_ACCRUAL_CHECK(
204: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
205: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
206: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
207: DEFAULT NULL,
208: p_date IN DATE DEFAULT NULL) RETURN BOOLEAN;
201: */
202:
203: FUNCTION INTEREST_ACCRUAL_CHECK(
204: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
205: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
206: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
207: DEFAULT NULL,
208: p_date IN DATE DEFAULT NULL) RETURN BOOLEAN;
209:
202:
203: FUNCTION INTEREST_ACCRUAL_CHECK(
204: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
205: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
206: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
207: DEFAULT NULL,
208: p_date IN DATE DEFAULT NULL) RETURN BOOLEAN;
209:
210: /**
236: * 14-JUL-2005 Rajesh Jose o Created.
237: */
238:
239: FUNCTION INTEREST_JOURNAL_CHECK(
240: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
241: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
242: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
243: DEFAULT NULL,
244: p_date IN DATE DEFAULT NULL,
237: */
238:
239: FUNCTION INTEREST_JOURNAL_CHECK(
240: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
241: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
242: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
243: DEFAULT NULL,
244: p_date IN DATE DEFAULT NULL,
245: p_check_intset_record IN VARCHAR2 DEFAULT 'N') RETURN BOOLEAN;
238:
239: FUNCTION INTEREST_JOURNAL_CHECK(
240: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
241: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
242: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
243: DEFAULT NULL,
244: p_date IN DATE DEFAULT NULL,
245: p_check_intset_record IN VARCHAR2 DEFAULT 'N') RETURN BOOLEAN;
246:
270: * 14-JUL-2005 Rajesh Jose o Created.
271: */
272:
273: FUNCTION INTEREST_RECONCILED_CHECK(
274: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
275: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
276: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
277: DEFAULT NULL,
278: p_date IN DATE DEFAULT NULL) RETURN BOOLEAN;
271: */
272:
273: FUNCTION INTEREST_RECONCILED_CHECK(
274: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
275: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
276: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
277: DEFAULT NULL,
278: p_date IN DATE DEFAULT NULL) RETURN BOOLEAN;
279:
272:
273: FUNCTION INTEREST_RECONCILED_CHECK(
274: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
275: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
276: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
277: DEFAULT NULL,
278: p_date IN DATE DEFAULT NULL) RETURN BOOLEAN;
279:
280:
307: * 14-JUL-2005 Rajesh Jose o Created.
308: */
309:
310: FUNCTION SETTLED_INTEREST_TAX_CHECK(
311: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
312: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
313: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
314: DEFAULT NULL,
315: p_date IN DATE DEFAULT NULL,
308: */
309:
310: FUNCTION SETTLED_INTEREST_TAX_CHECK(
311: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
312: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
313: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
314: DEFAULT NULL,
315: p_date IN DATE DEFAULT NULL,
316: p_maturity_date IN DATE DEFAULT NULL) RETURN BOOLEAN;
309:
310: FUNCTION SETTLED_INTEREST_TAX_CHECK(
311: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
312: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
313: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE
314: DEFAULT NULL,
315: p_date IN DATE DEFAULT NULL,
316: p_maturity_date IN DATE DEFAULT NULL) RETURN BOOLEAN;
317: