DBA Data[Home] [Help]

APPS.XTR_COMMON_FUNCTIONS dependencies on XTR_DEALS

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

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: *

Line 97: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,

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,

Line 98: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,

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,

Line 99: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE

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;

Line 135: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,

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,

Line 136: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,

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,

Line 137: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE

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;

Line 170: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,

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;

Line 171: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,

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:

Line 172: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE

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: /**

Line 204: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,

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;

Line 205: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,

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:

Line 206: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE

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: /**

Line 240: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,

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,

Line 241: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,

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;

Line 242: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE

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:

Line 274: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,

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;

Line 275: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,

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:

Line 276: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE

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:

Line 311: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,

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,

Line 312: p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,

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;

Line 313: p_transaction_number IN XTR_DEALS.TRANSACTION_NO%TYPE

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: