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_COND_ASSIGNMENT_PUB dependencies on LNS_COND_ASSIGNMENTS

Line 149: FROM LNS_COND_ASSIGNMENTS

145: THEN
146: BEGIN
147: SELECT 'Y'
148: INTO l_dummy
149: FROM LNS_COND_ASSIGNMENTS
150: WHERE cond_assignment_id = l_COND_ASSIGNMENT_id;
151:
152: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_DUPLICATE_COLUMN');
153: FND_MESSAGE.SET_TOKEN('COLUMN', 'cond_assignment_id');

Line 166: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_create_COND_ASSIGNMENT procedure: Before call to LNS_COND_ASSIGNMENTS_PKG.Insert_Row');

162:
163: Set_Defaults(p_COND_ASSIGNMENT_rec);
164:
165: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
166: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_create_COND_ASSIGNMENT procedure: Before call to LNS_COND_ASSIGNMENTS_PKG.Insert_Row');
167: END IF;
168:
169: -- call table-handler.
170: LNS_COND_ASSIGNMENTS_PKG.Insert_Row (

Line 170: LNS_COND_ASSIGNMENTS_PKG.Insert_Row (

166: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_create_COND_ASSIGNMENT procedure: Before call to LNS_COND_ASSIGNMENTS_PKG.Insert_Row');
167: END IF;
168:
169: -- call table-handler.
170: LNS_COND_ASSIGNMENTS_PKG.Insert_Row (
171: X_COND_ASSIGNMENT_ID => p_COND_ASSIGNMENT_rec.cond_assignment_id,
172: P_OBJECT_VERSION_NUMBER => 1,
173: P_LOAN_ID => p_COND_ASSIGNMENT_rec.loan_id,
174: P_CONDITION_ID => p_COND_ASSIGNMENT_rec.condition_id,

Line 251: FROM LNS_COND_ASSIGNMENTS

247: -- check whether record has been updated by another user. If not, lock it.
248: BEGIN
249: SELECT OBJECT_VERSION_NUMBER
250: INTO l_object_version_number
251: FROM LNS_COND_ASSIGNMENTS
252: WHERE COND_ASSIGNMENT_ID = p_COND_ASSIGNMENT_rec.cond_assignment_id
253: FOR UPDATE OF COND_ASSIGNMENT_ID NOWAIT;
254:
255: IF NOT

Line 266: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_COND_ASSIGNMENTs');

262: )
263: )
264: THEN
265: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
266: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_COND_ASSIGNMENTs');
267: FND_MSG_PUB.ADD;
268: RAISE FND_API.G_EXC_ERROR;
269: END IF;
270:

Line 284: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_update_COND_ASSIGNMENT procedure: Before call to LNS_COND_ASSIGNMENTS_PKG.Update_Row');

280:
281: Set_Defaults(p_COND_ASSIGNMENT_rec);
282:
283: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
284: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_update_COND_ASSIGNMENT procedure: Before call to LNS_COND_ASSIGNMENTS_PKG.Update_Row');
285: END IF;
286:
287: -- log history
288: LNS_LOAN_HISTORY_PUB.log_record_pre(p_COND_ASSIGNMENT_rec.cond_assignment_id,

Line 290: 'LNS_COND_ASSIGNMENTS');

286:
287: -- log history
288: LNS_LOAN_HISTORY_PUB.log_record_pre(p_COND_ASSIGNMENT_rec.cond_assignment_id,
289: 'COND_ASSIGNMENT_ID',
290: 'LNS_COND_ASSIGNMENTS');
291:
292: --Call to table-handler
293: LNS_COND_ASSIGNMENTS_PKG.Update_Row (
294: P_COND_ASSIGNMENT_ID => p_COND_ASSIGNMENT_rec.cond_assignment_id,

Line 293: LNS_COND_ASSIGNMENTS_PKG.Update_Row (

289: 'COND_ASSIGNMENT_ID',
290: 'LNS_COND_ASSIGNMENTS');
291:
292: --Call to table-handler
293: LNS_COND_ASSIGNMENTS_PKG.Update_Row (
294: P_COND_ASSIGNMENT_ID => p_COND_ASSIGNMENT_rec.cond_assignment_id,
295: P_OBJECT_VERSION_NUMBER => p_OBJECT_VERSION_NUMBER,
296: P_LOAN_ID => p_COND_ASSIGNMENT_rec.LOAN_ID,
297: P_CONDITION_ID => p_COND_ASSIGNMENT_rec.CONDITION_ID,

Line 317: 'LNS_COND_ASSIGNMENTS',

313:
314: -- log record changes
315: LNS_LOAN_HISTORY_PUB.log_record_post(p_COND_ASSIGNMENT_rec.cond_assignment_id,
316: 'COND_ASSIGNMENT_ID',
317: 'LNS_COND_ASSIGNMENTS',
318: p_COND_ASSIGNMENT_rec.loan_id);
319:
320: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
321: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_update_COND_ASSIGNMENT procedure: After call to LNS_COND_ASSIGNMENTS_PKG.Update_Row');

Line 321: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_update_COND_ASSIGNMENT procedure: After call to LNS_COND_ASSIGNMENTS_PKG.Update_Row');

317: 'LNS_COND_ASSIGNMENTS',
318: p_COND_ASSIGNMENT_rec.loan_id);
319:
320: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
321: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_update_COND_ASSIGNMENT procedure: After call to LNS_COND_ASSIGNMENTS_PKG.Update_Row');
322: END IF;
323:
324: END do_update_COND_ASSIGNMENT;
325:

Line 375: FROM LNS_COND_ASSIGNMENTS

371: -- check whether record has been deleted by another user. If not, lock it.
372: BEGIN
373: SELECT loan_id, object_version_number
374: INTO l_loan_id, l_object_version_num
375: FROM LNS_COND_ASSIGNMENTS
376: WHERE COND_ASSIGNMENT_ID = p_COND_ASSIGNMENT_id
377: FOR UPDATE NOWAIT;
378:
379: EXCEPTION

Line 391: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_delete_COND_ASSIGNMENT procedure: Before call to LNS_COND_ASSIGNMENTS_PKG.Delete_Row');

387: END IF;
388:
389:
390: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
391: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_delete_COND_ASSIGNMENT procedure: Before call to LNS_COND_ASSIGNMENTS_PKG.Delete_Row');
392: END IF;
393:
394: -- log history
395: LNS_LOAN_HISTORY_PUB.log_record_pre(p_cond_assignment_id,

Line 397: 'LNS_COND_ASSIGNMENTS');

393:
394: -- log history
395: LNS_LOAN_HISTORY_PUB.log_record_pre(p_cond_assignment_id,
396: 'COND_ASSIGNMENT_ID',
397: 'LNS_COND_ASSIGNMENTS');
398:
399: BEGIN
400:
401: UPDATE LNS_COND_ASSIGNMENTS

Line 401: UPDATE LNS_COND_ASSIGNMENTS

397: 'LNS_COND_ASSIGNMENTS');
398:
399: BEGIN
400:
401: UPDATE LNS_COND_ASSIGNMENTS
402: SET END_DATE_ACTIVE = SYSDATE,
403: OBJECT_VERSION_NUMBER = nvl(l_object_version_num, 1) + 1
404: WHERE COND_ASSIGNMENT_ID = p_cond_assignment_id;
405:

Line 417: LNS_COND_ASSIGNMENTS_PKG.Update_Row (

413: END;
414:
415: /*
416: --Call to table-handler
417: LNS_COND_ASSIGNMENTS_PKG.Update_Row (
418: P_COND_ASSIGNMENT_ID => p_COND_ASSIGNMENT_ID,
419: P_OBJECT_VERSION_NUMBER => null,
420: P_LOAN_ID => p_COND_ASSIGNMENT_rec.LOAN_ID,
421: P_CONDITION_ID => p_COND_ASSIGNMENT_rec.CONDITION_ID,

Line 437: 'LNS_COND_ASSIGNMENTS',

433: */
434: -- log record changes
435: LNS_LOAN_HISTORY_PUB.log_record_post(p_cond_assignment_id,
436: 'COND_ASSIGNMENT_ID',
437: 'LNS_COND_ASSIGNMENTS',
438: l_loan_id);
439:
440: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
441: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_delete_COND_ASSIGNMENT procedure: After call to LNS_COND_ASSIGNMENTS_PKG.Delete_Row');

Line 441: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_delete_COND_ASSIGNMENT procedure: After call to LNS_COND_ASSIGNMENTS_PKG.Delete_Row');

437: 'LNS_COND_ASSIGNMENTS',
438: l_loan_id);
439:
440: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
441: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_delete_COND_ASSIGNMENT procedure: After call to LNS_COND_ASSIGNMENTS_PKG.Delete_Row');
442: END IF;
443:
444: END do_delete_COND_ASSIGNMENT;
445:

Line 791: select LNS_COND_ASSIGNMENTS_S.NEXTVAL COND_ASSIGNMENT_ID,

787: PROCEDURE create_LP_COND_ASSIGNMENT(
788: P_LOAN_ID IN NUMBER ) IS
789:
790: CURSOR loan_prod_cond ( c_loan_id NUMBER ) IS
791: select LNS_COND_ASSIGNMENTS_S.NEXTVAL COND_ASSIGNMENT_ID,
792: LnsLoanHeaders.LOAN_ID,
793: LnsConditions.CONDITION_ID,
794: LnsConditions.CONDITION_DESCRIPTION,
795: LnsLoanProductLines.MANDATORY_FLAG

Line 815: FROM LNS_COND_ASSIGNMENTS_VL LnsCondAssignments

811:
812:
813: CURSOR loan_cond_count ( c_loan_id NUMBER ) IS
814: SELECT count(COND_ASSIGNMENT_ID)
815: FROM LNS_COND_ASSIGNMENTS_VL LnsCondAssignments
816: WHERE LnsCondAssignments.LOAN_ID = c_loan_id ;
817:
818:
819: l_cond_assignment_id NUMBER ;

Line 939: --If records have been inserted into lns_cond_assignments table

935:
936:
937: END LOOP ;
938:
939: --If records have been inserted into lns_cond_assignments table
940: --they need to be committed since the commit does not happen on the UI
941: --unless the user explicitly commits from the UI page
942: IF (is_commit_needed = TRUE) THEN
943: COMMIT WORK;

Line 1010: select LNS_COND_ASSIGNMENTS_S.NEXTVAL into l_temp_cond_assignment_id from DUAL;

1006:
1007: FETCH loan_prod_disb_cond INTO l_condition_id,l_cond_desc,l_mandatory_flag ;
1008: EXIT WHEN loan_prod_disb_cond%NOTFOUND ;
1009:
1010: select LNS_COND_ASSIGNMENTS_S.NEXTVAL into l_temp_cond_assignment_id from DUAL;
1011: l_cond_assignment_rec.COND_ASSIGNMENT_ID := l_temp_cond_assignment_id;
1012:
1013: --commented below line as it was throwing error PLS-00357 during the build by release team
1014: --l_cond_assignment_rec.COND_ASSIGNMENT_ID := LNS_COND_ASSIGNMENTS_S.NEXTVAL;

Line 1014: --l_cond_assignment_rec.COND_ASSIGNMENT_ID := LNS_COND_ASSIGNMENTS_S.NEXTVAL;

1010: select LNS_COND_ASSIGNMENTS_S.NEXTVAL into l_temp_cond_assignment_id from DUAL;
1011: l_cond_assignment_rec.COND_ASSIGNMENT_ID := l_temp_cond_assignment_id;
1012:
1013: --commented below line as it was throwing error PLS-00357 during the build by release team
1014: --l_cond_assignment_rec.COND_ASSIGNMENT_ID := LNS_COND_ASSIGNMENTS_S.NEXTVAL;
1015:
1016: l_cond_assignment_rec.LOAN_ID := P_LOAN_ID ;
1017: l_cond_assignment_rec.CONDITION_ID := l_condition_id ;
1018: l_cond_assignment_rec.CONDITION_DESCRIPTION := l_cond_desc ;

Line 1059: FROM LNS_COND_ASSIGNMENTS LnsCondAssignments

1055: PROCEDURE delete_DISB_COND_ASSIGNMENT( P_DISB_HEADER_ID IN NUMBER ) IS
1056:
1057: CURSOR loan_disb_cond ( c_disb_header_id NUMBER ) IS
1058: SELECT COND_ASSIGNMENT_ID
1059: FROM LNS_COND_ASSIGNMENTS LnsCondAssignments
1060: WHERE LnsCondAssignments.DISB_HEADER_ID = c_disb_header_id ;
1061:
1062: l_cond_assignment_id NUMBER ;
1063: x_return_status VARCHAR2(1) ;

Line 1127: WHERE EXISTS ( SELECT NULL FROM LNS_COND_ASSIGNMENTS

1123: ) RETURN VARCHAR2 IS
1124:
1125: CURSOR C_Is_Exist_Assignment (X_COND_Id NUMBER) IS
1126: SELECT 'X' FROM DUAL
1127: WHERE EXISTS ( SELECT NULL FROM LNS_COND_ASSIGNMENTS
1128: WHERE CONDITION_ID = X_COND_ID )
1129: OR EXISTS ( SELECT NULL FROM LNS_LOAN_PRODUCT_LINES
1130: WHERE LINE_REFERENCE_ID = X_COND_ID
1131: AND ( LOAN_PRODUCT_LINE_TYPE = 'CONDITION' OR LOAN_PRODUCT_LINE_TYPE='DISB_CONDITION' )

Line 1201: LNS_COND_ASSIGNMENTS cond_ass

1197: cond.CONDITION_TYPE,
1198: cond_ass.MANDATORY_FLAG,
1199: cond.CUSTOM_PROCEDURE
1200: from LNS_CONDITIONS_VL cond,
1201: LNS_COND_ASSIGNMENTS cond_ass
1202: where decode(P_CONDITION_TYPE, 'APPROVAL', cond_ass.LOAN_ID,
1203: 'CONVERSION', cond_ass.LOAN_ID,
1204: 'DISBURSEMENT', cond_ass.DISB_HEADER_ID,
1205: cond_ass.OWNER_OBJECT_ID) = P_OWNER_OBJECT_ID

Line 1311: from LNS_COND_ASSIGNMENTS

1307: if P_COMPLETE_FLAG = 'Y' then
1308: FOR j IN 1..l_cond_assignment_tbl.COUNT LOOP
1309:
1310: select OBJECT_VERSION_NUMBER into l_version_number
1311: from LNS_COND_ASSIGNMENTS
1312: where COND_ASSIGNMENT_ID = l_cond_assignment_tbl(j).COND_ASSIGNMENT_ID;
1313:
1314: update_COND_ASSIGNMENT (
1315: p_init_msg_list => FND_API.G_FALSE,

Line 1415: LNS_COND_ASSIGNMENTS cond_ass

1411: cond.CONDITION_TYPE,
1412: cond_ass.MANDATORY_FLAG,
1413: cond.CUSTOM_PROCEDURE
1414: from LNS_CONDITIONS_VL cond,
1415: LNS_COND_ASSIGNMENTS cond_ass
1416: where cond_ass.cond_assignment_id = P_COND_ASSIGNMENT_ID
1417: and cond.condition_id = cond_ass.condition_id
1418: and cond_ass.END_DATE_ACTIVE is null;
1419:

Line 1571: LNS_COND_ASSIGNMENTS cond_ass

1567: cond.CONDITION_DESCRIPTION,
1568: cond_ass.MANDATORY_FLAG,
1569: cond_ass.DELETE_DISABLED_FLAG
1570: from LNS_CONDITIONS_VL cond,
1571: LNS_COND_ASSIGNMENTS cond_ass
1572: where cond_ass.LOAN_ID = P_LOAN_ID
1573: and cond.CONDITION_TYPE = P_CONDITION_TYPE
1574: and cond.condition_id = cond_ass.condition_id
1575: and decode(cond.CONDITION_TYPE, 'DISBURSEMENT', cond_ass.DISB_HEADER_ID, cond_ass.OWNER_OBJECT_ID) is null

Line 1767: LNS_COND_ASSIGNMENTS cond_ass

1763: -- checking for number of not met non-custom conditions
1764: CURSOR conditions_cur(P_OWNER_OBJECT_ID number, P_CONDITION_TYPE varchar2) IS
1765: select count(1)
1766: from LNS_CONDITIONS_VL cond,
1767: LNS_COND_ASSIGNMENTS cond_ass
1768: where
1769: decode(P_CONDITION_TYPE, 'APPROVAL', cond_ass.LOAN_ID,
1770: 'CONVERSION', cond_ass.LOAN_ID,
1771: 'DISBURSEMENT', cond_ass.DISB_HEADER_ID,