APPS.LNS_LOAN_COLLATERAL_PUB dependencies on LNS_UTILITY_PUB

Line 35: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,

31: 'LNS_ASSET_ASSIGNMENTS');
32: UPDATE LNS_ASSET_ASSIGNMENTS
33: SET
34: END_DATE_ACTIVE = SYSDATE ,
35: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,
36: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN,
37: LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
38: OBJECT_VERSION_NUMBER = fee_assignment_rec.OBJECT_VERSION_NUMBER + 1
39: WHERE current of fee_assignment_cur ;

Line 36: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN,

32: UPDATE LNS_ASSET_ASSIGNMENTS
33: SET
34: END_DATE_ACTIVE = SYSDATE ,
35: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,
36: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN,
37: LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
38: OBJECT_VERSION_NUMBER = fee_assignment_rec.OBJECT_VERSION_NUMBER + 1
39: WHERE current of fee_assignment_cur ;
40:

Line 37: LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE,

33: SET
34: END_DATE_ACTIVE = SYSDATE ,
35: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,
36: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN,
37: LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
38: OBJECT_VERSION_NUMBER = fee_assignment_rec.OBJECT_VERSION_NUMBER + 1
39: WHERE current of fee_assignment_cur ;
40:
41:

Line 51: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,

47:
48: /*-- update collaterals
49: UPDATE LNS_ASSET_ASSIGNMENTS
50: SET END_DATE_ACTIVE = SYSDATE,
51: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,
52: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN,
53: LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
54: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
55: WHERE LOAN_ID = p_loan_id; */

Line 52: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN,

48: /*-- update collaterals
49: UPDATE LNS_ASSET_ASSIGNMENTS
50: SET END_DATE_ACTIVE = SYSDATE,
51: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,
52: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN,
53: LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
54: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
55: WHERE LOAN_ID = p_loan_id; */
56:

Line 53: LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE,

49: UPDATE LNS_ASSET_ASSIGNMENTS
50: SET END_DATE_ACTIVE = SYSDATE,
51: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,
52: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN,
53: LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
54: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
55: WHERE LOAN_ID = p_loan_id; */
56:
57:

Line 62: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,

58: /* No need to end date Assets - Bug # 4212254
59: --update acquired assets
60: UPDATE LNS_ASSETS
61: SET END_DATE_ACTIVE = SYSDATE,
62: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,
63: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN,
64: LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
65: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
66: WHERE ACQUIRED_ASSET_LOAN_ID = p_loan_id; */

Line 63: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN,

59: --update acquired assets
60: UPDATE LNS_ASSETS
61: SET END_DATE_ACTIVE = SYSDATE,
62: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,
63: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN,
64: LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
65: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
66: WHERE ACQUIRED_ASSET_LOAN_ID = p_loan_id; */
67:

Line 64: LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE,

60: UPDATE LNS_ASSETS
61: SET END_DATE_ACTIVE = SYSDATE,
62: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,
63: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN,
64: LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
65: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
66: WHERE ACQUIRED_ASSET_LOAN_ID = p_loan_id; */
67:
68: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN