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.OKL_TRQ_PVT dependencies on DUAL

Line 178: RESIDUAL,

174: DATE_OF_CONVERSION,
175: VARIABLE_RATE_YN,
176: REQUEST_STATUS_CODE,
177: YIELD,
178: RESIDUAL,
179: COMMENTS,
180: PAYMENT_FREQUENCY_CODE,
181: RESTRUCTURE_DATE,
182: PAST_DUE_YN,

Line 267: l_trqv_rec.residual,

263: l_trqv_rec.date_of_conversion,
264: l_trqv_rec.variable_rate_yn,
265: l_trqv_rec.request_status_code,
266: l_trqv_rec.yield,
267: l_trqv_rec.residual,
268: l_trqv_rec.comments,
269: l_trqv_rec.payment_frequency_code,
270: l_trqv_rec.restructure_date,
271: l_trqv_rec.past_due_yn,

Line 389: RESIDUAL,

385: DATE_OF_CONVERSION,
386: VARIABLE_RATE_YN,
387: REQUEST_STATUS_CODE,
388: YIELD,
389: RESIDUAL,
390: COMMENTS,
391: PAYMENT_FREQUENCY_CODE,
392: RESTRUCTURE_DATE,
393: PAST_DUE_YN,

Line 476: l_trq_rec.residual,

472: l_trq_rec.date_of_conversion,
473: l_trq_rec.variable_rate_yn,
474: l_trq_rec.request_status_code,
475: l_trq_rec.yield,
476: l_trq_rec.residual,
477: l_trq_rec.comments,
478: l_trq_rec.payment_frequency_code,
479: l_trq_rec.restructure_date,
480: l_trq_rec.past_due_yn,

Line 713: IF (l_trqv_rec.residual = OKL_API.G_MISS_NUM ) THEN

709: END IF;
710: IF (l_trqv_rec.yield = OKL_API.G_MISS_NUM ) THEN
711: l_trqv_rec.yield := NULL;
712: END IF;
713: IF (l_trqv_rec.residual = OKL_API.G_MISS_NUM ) THEN
714: l_trqv_rec.residual := NULL;
715: END IF;
716: IF (l_trqv_rec.comments = OKL_API.G_MISS_CHAR ) THEN
717: l_trqv_rec.comments := NULL;

Line 714: l_trqv_rec.residual := NULL;

710: IF (l_trqv_rec.yield = OKL_API.G_MISS_NUM ) THEN
711: l_trqv_rec.yield := NULL;
712: END IF;
713: IF (l_trqv_rec.residual = OKL_API.G_MISS_NUM ) THEN
714: l_trqv_rec.residual := NULL;
715: END IF;
716: IF (l_trqv_rec.comments = OKL_API.G_MISS_CHAR ) THEN
717: l_trqv_rec.comments := NULL;
718: END IF;

Line 1612: p_to.residual := p_from.residual;

1608: p_to.date_of_conversion := p_from.date_of_conversion;
1609: p_to.variable_rate_yn := p_from.variable_rate_yn;
1610: p_to.request_status_code := p_from.request_status_code;
1611: p_to.yield := p_from.yield;
1612: p_to.residual := p_from.residual;
1613: p_to.comments := p_from.comments;
1614: p_to.payment_frequency_code := p_from.payment_frequency_code;
1615: p_to.restructure_date := p_from.restructure_date;
1616: p_to.past_due_yn := p_from.past_due_yn;

Line 1698: p_to.residual := p_from.residual;

1694: p_to.date_of_conversion := p_from.date_of_conversion;
1695: p_to.variable_rate_yn := p_from.variable_rate_yn;
1696: p_to.request_status_code := p_from.request_status_code;
1697: p_to.yield := p_from.yield;
1698: p_to.residual := p_from.residual;
1699: p_to.comments := p_from.comments;
1700: p_to.payment_frequency_code := p_from.payment_frequency_code;
1701: p_to.restructure_date := p_from.restructure_date;
1702: p_to.past_due_yn := p_from.past_due_yn;

Line 2069: residual,

2065: date_of_conversion,
2066: variable_rate_yn,
2067: request_status_code,
2068: yield,
2069: residual,
2070: comments,
2071: payment_frequency_code,
2072: restructure_date,
2073: past_due_yn,

Line 2150: l_trq_rec.residual,

2146: l_trq_rec.date_of_conversion,
2147: l_trq_rec.variable_rate_yn,
2148: l_trq_rec.request_status_code,
2149: l_trq_rec.yield,
2150: l_trq_rec.residual,
2151: l_trq_rec.comments,
2152: l_trq_rec.payment_frequency_code,
2153: l_trq_rec.restructure_date,
2154: l_trq_rec.past_due_yn,

Line 2253: from dual;

2249: --Hand coded
2250: CURSOR req_num_seq
2251: IS
2252: select OKL_TRQ_SEQ.nextval
2253: from dual;
2254: --End Hand coding
2255: BEGIN
2256: x_trqv_rec := p_trqv_rec;
2257: x_trqv_rec.OBJECT_VERSION_NUMBER := 1;

Line 3154: IF (x_trq_rec.residual = OKL_API.G_MISS_NUM)

3150: IF (x_trq_rec.yield = OKL_API.G_MISS_NUM)
3151: THEN
3152: x_trq_rec.yield := l_trq_rec.yield;
3153: END IF;
3154: IF (x_trq_rec.residual = OKL_API.G_MISS_NUM)
3155: THEN
3156: x_trq_rec.residual := l_trq_rec.residual;
3157: END IF;
3158: IF (x_trq_rec.comments = OKL_API.G_MISS_CHAR)

Line 3156: x_trq_rec.residual := l_trq_rec.residual;

3152: x_trq_rec.yield := l_trq_rec.yield;
3153: END IF;
3154: IF (x_trq_rec.residual = OKL_API.G_MISS_NUM)
3155: THEN
3156: x_trq_rec.residual := l_trq_rec.residual;
3157: END IF;
3158: IF (x_trq_rec.comments = OKL_API.G_MISS_CHAR)
3159: THEN
3160: x_trq_rec.comments := l_trq_rec.comments;

Line 3341: RESIDUAL = l_def_trq_rec.residual,

3337: DATE_OF_CONVERSION = l_def_trq_rec.date_of_conversion,
3338: VARIABLE_RATE_YN = l_def_trq_rec.variable_rate_yn,
3339: REQUEST_STATUS_CODE = l_def_trq_rec.request_status_code,
3340: YIELD = l_def_trq_rec.yield,
3341: RESIDUAL = l_def_trq_rec.residual,
3342: COMMENTS = l_def_trq_rec.comments,
3343: PAYMENT_FREQUENCY_CODE = l_def_trq_rec.payment_frequency_code,
3344: RESTRUCTURE_DATE = l_def_trq_rec.restructure_date,
3345: PAST_DUE_YN = l_def_trq_rec.past_due_yn,

Line 3678: IF (x_trqv_rec.residual = OKL_API.G_MISS_NUM)

3674: IF (x_trqv_rec.yield = OKL_API.G_MISS_NUM)
3675: THEN
3676: x_trqv_rec.yield := l_db_trqv_rec.yield;
3677: END IF;
3678: IF (x_trqv_rec.residual = OKL_API.G_MISS_NUM)
3679: THEN
3680: x_trqv_rec.residual := l_db_trqv_rec.residual;
3681: END IF;
3682: IF (x_trqv_rec.comments = OKL_API.G_MISS_CHAR)

Line 3680: x_trqv_rec.residual := l_db_trqv_rec.residual;

3676: x_trqv_rec.yield := l_db_trqv_rec.yield;
3677: END IF;
3678: IF (x_trqv_rec.residual = OKL_API.G_MISS_NUM)
3679: THEN
3680: x_trqv_rec.residual := l_db_trqv_rec.residual;
3681: END IF;
3682: IF (x_trqv_rec.comments = OKL_API.G_MISS_CHAR)
3683: THEN
3684: x_trqv_rec.comments := l_db_trqv_rec.comments;