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 103: FROM LNS_COND_ASSIGNMENTS

99: THEN
100: BEGIN
101: SELECT 'Y'
102: INTO l_dummy
103: FROM LNS_COND_ASSIGNMENTS
104: WHERE cond_assignment_id = l_COND_ASSIGNMENT_id;
105:
106: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_DUPLICATE_COLUMN');
107: FND_MESSAGE.SET_TOKEN('COLUMN', 'cond_assignment_id');

Line 120: 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');

116:
117: Set_Defaults(p_COND_ASSIGNMENT_rec);
118:
119: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
120: 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');
121: END IF;
122:
123: -- call table-handler.
124: LNS_COND_ASSIGNMENTS_PKG.Insert_Row (

Line 124: LNS_COND_ASSIGNMENTS_PKG.Insert_Row (

120: 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');
121: END IF;
122:
123: -- call table-handler.
124: LNS_COND_ASSIGNMENTS_PKG.Insert_Row (
125: X_COND_ASSIGNMENT_ID => p_COND_ASSIGNMENT_rec.cond_assignment_id,
126: P_OBJECT_VERSION_NUMBER => 1,
127: P_LOAN_ID => p_COND_ASSIGNMENT_rec.loan_id,
128: P_CONDITION_ID => p_COND_ASSIGNMENT_rec.condition_id,

Line 202: FROM LNS_COND_ASSIGNMENTS

198: -- check whether record has been updated by another user. If not, lock it.
199: BEGIN
200: SELECT OBJECT_VERSION_NUMBER
201: INTO l_object_version_number
202: FROM LNS_COND_ASSIGNMENTS
203: WHERE COND_ASSIGNMENT_ID = p_COND_ASSIGNMENT_rec.cond_assignment_id
204: FOR UPDATE OF COND_ASSIGNMENT_ID NOWAIT;
205:
206: IF NOT

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

213: )
214: )
215: THEN
216: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
217: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_COND_ASSIGNMENTs');
218: FND_MSG_PUB.ADD;
219: RAISE FND_API.G_EXC_ERROR;
220: END IF;
221:

Line 235: 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');

231:
232: Set_Defaults(p_COND_ASSIGNMENT_rec);
233:
234: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
235: 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');
236: END IF;
237:
238: -- log history
239: LNS_LOAN_HISTORY_PUB.log_record_pre(p_COND_ASSIGNMENT_rec.cond_assignment_id,

Line 241: 'LNS_COND_ASSIGNMENTS');

237:
238: -- log history
239: LNS_LOAN_HISTORY_PUB.log_record_pre(p_COND_ASSIGNMENT_rec.cond_assignment_id,
240: 'COND_ASSIGNMENT_ID',
241: 'LNS_COND_ASSIGNMENTS');
242:
243: --Call to table-handler
244: LNS_COND_ASSIGNMENTS_PKG.Update_Row (
245: P_COND_ASSIGNMENT_ID => p_COND_ASSIGNMENT_rec.cond_assignment_id,

Line 244: LNS_COND_ASSIGNMENTS_PKG.Update_Row (

240: 'COND_ASSIGNMENT_ID',
241: 'LNS_COND_ASSIGNMENTS');
242:
243: --Call to table-handler
244: LNS_COND_ASSIGNMENTS_PKG.Update_Row (
245: P_COND_ASSIGNMENT_ID => p_COND_ASSIGNMENT_rec.cond_assignment_id,
246: P_OBJECT_VERSION_NUMBER => p_OBJECT_VERSION_NUMBER,
247: P_LOAN_ID => p_COND_ASSIGNMENT_rec.LOAN_ID,
248: P_CONDITION_ID => p_COND_ASSIGNMENT_rec.CONDITION_ID,

Line 266: 'LNS_COND_ASSIGNMENTS',

262:
263: -- log record changes
264: LNS_LOAN_HISTORY_PUB.log_record_post(p_COND_ASSIGNMENT_rec.cond_assignment_id,
265: 'COND_ASSIGNMENT_ID',
266: 'LNS_COND_ASSIGNMENTS',
267: p_COND_ASSIGNMENT_rec.loan_id);
268:
269: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
270: 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 270: 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');

266: 'LNS_COND_ASSIGNMENTS',
267: p_COND_ASSIGNMENT_rec.loan_id);
268:
269: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
270: 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');
271: END IF;
272:
273: END do_update_COND_ASSIGNMENT;
274:

Line 324: FROM LNS_COND_ASSIGNMENTS

320: -- check whether record has been deleted by another user. If not, lock it.
321: BEGIN
322: SELECT loan_id, object_version_number
323: INTO l_loan_id, l_object_version_num
324: FROM LNS_COND_ASSIGNMENTS
325: WHERE COND_ASSIGNMENT_ID = p_COND_ASSIGNMENT_id
326: FOR UPDATE NOWAIT;
327:
328: EXCEPTION

Line 340: 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');

336: END IF;
337:
338:
339: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
340: 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');
341: END IF;
342:
343: -- log history
344: LNS_LOAN_HISTORY_PUB.log_record_pre(p_cond_assignment_id,

Line 346: 'LNS_COND_ASSIGNMENTS');

342:
343: -- log history
344: LNS_LOAN_HISTORY_PUB.log_record_pre(p_cond_assignment_id,
345: 'COND_ASSIGNMENT_ID',
346: 'LNS_COND_ASSIGNMENTS');
347:
348: BEGIN
349:
350: UPDATE LNS_COND_ASSIGNMENTS

Line 350: UPDATE LNS_COND_ASSIGNMENTS

346: 'LNS_COND_ASSIGNMENTS');
347:
348: BEGIN
349:
350: UPDATE LNS_COND_ASSIGNMENTS
351: SET END_DATE_ACTIVE = SYSDATE,
352: OBJECT_VERSION_NUMBER = nvl(l_object_version_num, 1) + 1
353: WHERE COND_ASSIGNMENT_ID = p_cond_assignment_id;
354:

Line 366: LNS_COND_ASSIGNMENTS_PKG.Update_Row (

362: END;
363:
364: /*
365: --Call to table-handler
366: LNS_COND_ASSIGNMENTS_PKG.Update_Row (
367: P_COND_ASSIGNMENT_ID => p_COND_ASSIGNMENT_ID,
368: P_OBJECT_VERSION_NUMBER => null,
369: P_LOAN_ID => p_COND_ASSIGNMENT_rec.LOAN_ID,
370: P_CONDITION_ID => p_COND_ASSIGNMENT_rec.CONDITION_ID,

Line 386: 'LNS_COND_ASSIGNMENTS',

382: */
383: -- log record changes
384: LNS_LOAN_HISTORY_PUB.log_record_post(p_cond_assignment_id,
385: 'COND_ASSIGNMENT_ID',
386: 'LNS_COND_ASSIGNMENTS',
387: l_loan_id);
388:
389: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
390: 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 390: 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');

386: 'LNS_COND_ASSIGNMENTS',
387: l_loan_id);
388:
389: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
390: 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');
391: END IF;
392:
393: END do_delete_COND_ASSIGNMENT;
394:

Line 740: select LNS_COND_ASSIGNMENTS_S.NEXTVAL COND_ASSIGNMENT_ID,

736: PROCEDURE create_LP_COND_ASSIGNMENT(
737: P_LOAN_ID IN NUMBER ) IS
738:
739: CURSOR loan_prod_cond ( c_loan_id NUMBER ) IS
740: select LNS_COND_ASSIGNMENTS_S.NEXTVAL COND_ASSIGNMENT_ID,
741: LnsLoanHeaders.LOAN_ID,
742: LnsConditions.CONDITION_ID,
743: LnsConditions.CONDITION_DESCRIPTION,
744: LnsLoanProductLines.MANDATORY_FLAG

Line 764: FROM LNS_COND_ASSIGNMENTS_VL LnsCondAssignments

760:
761:
762: CURSOR loan_cond_count ( c_loan_id NUMBER ) IS
763: SELECT count(COND_ASSIGNMENT_ID)
764: FROM LNS_COND_ASSIGNMENTS_VL LnsCondAssignments
765: WHERE LnsCondAssignments.LOAN_ID = c_loan_id ;
766:
767:
768: l_cond_assignment_id NUMBER ;

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

882:
883:
884: END LOOP ;
885:
886: --If records have been inserted into lns_cond_assignments table
887: --they need to be committed since the commit does not happen on the UI
888: --unless the user explicitly commits from the UI page
889: IF (is_commit_needed = TRUE) THEN
890: COMMIT WORK;

Line 905: select LNS_COND_ASSIGNMENTS_S.NEXTVAL COND_ASSIGNMENT_ID,

901: PROCEDURE create_LP_DISB_COND_ASSIGNMENT(
902: P_DISB_HEADER_ID IN NUMBER , P_LOAN_PRODUCT_LINE_ID IN NUMBER) IS
903:
904: CURSOR loan_prod_disb_cond ( c_loan_prod_line_id NUMBER ) IS
905: select LNS_COND_ASSIGNMENTS_S.NEXTVAL COND_ASSIGNMENT_ID,
906: LnsConditions.CONDITION_ID,
907: LnsConditions.CONDITION_DESCRIPTION,
908: LnsLoanProductLines.MANDATORY_FLAG
909:

Line 1004: FROM LNS_COND_ASSIGNMENTS LnsCondAssignments

1000: PROCEDURE delete_DISB_COND_ASSIGNMENT( P_DISB_HEADER_ID IN NUMBER ) IS
1001:
1002: CURSOR loan_disb_cond ( c_disb_header_id NUMBER ) IS
1003: SELECT COND_ASSIGNMENT_ID
1004: FROM LNS_COND_ASSIGNMENTS LnsCondAssignments
1005: WHERE LnsCondAssignments.DISB_HEADER_ID = c_disb_header_id ;
1006:
1007: l_cond_assignment_id NUMBER ;
1008: x_return_status VARCHAR2(1) ;

Line 1072: WHERE EXISTS ( SELECT NULL FROM LNS_COND_ASSIGNMENTS

1068: ) RETURN VARCHAR2 IS
1069:
1070: CURSOR C_Is_Exist_Assignment (X_COND_Id NUMBER) IS
1071: SELECT 'X' FROM DUAL
1072: WHERE EXISTS ( SELECT NULL FROM LNS_COND_ASSIGNMENTS
1073: WHERE CONDITION_ID = X_COND_ID )
1074: OR EXISTS ( SELECT NULL FROM LNS_LOAN_PRODUCT_LINES
1075: WHERE LINE_REFERENCE_ID = X_COND_ID
1076: AND ( LOAN_PRODUCT_LINE_TYPE = 'CONDITION' OR LOAN_PRODUCT_LINE_TYPE='DISB_CONDITION' )