APPS.LNS_APPROVAL_ACTION_PUB dependencies on LNS_APPROVAL_ACTIONS

Line 98: FROM LNS_APPROVAL_ACTIONS

94: THEN
95: BEGIN
96: SELECT 'Y'
97: INTO l_dummy
98: FROM LNS_APPROVAL_ACTIONS
99: WHERE action_id = l_action_id;
100:
101: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_DUPLICATE_COLUMN');
102: FND_MESSAGE.SET_TOKEN('COLUMN', 'action_id');

Line 112: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_create_approval_action procedure: Before call to LNS_APPROVAL_ACTIONS_PKG.Insert_Row');

108: NULL;
109: END;
110: END IF;
111:
112: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_create_approval_action procedure: Before call to LNS_APPROVAL_ACTIONS_PKG.Insert_Row');
113:
114: -- call table-handler.
115: LNS_APPROVAL_ACTIONS_PKG.Insert_Row(X_ACTION_ID => p_approval_action_rec.action_id
116: ,P_OBJECT_VERSION_NUMBER => 1

Line 115: LNS_APPROVAL_ACTIONS_PKG.Insert_Row(X_ACTION_ID => p_approval_action_rec.action_id

111:
112: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_create_approval_action procedure: Before call to LNS_APPROVAL_ACTIONS_PKG.Insert_Row');
113:
114: -- call table-handler.
115: LNS_APPROVAL_ACTIONS_PKG.Insert_Row(X_ACTION_ID => p_approval_action_rec.action_id
116: ,P_OBJECT_VERSION_NUMBER => 1
117: ,P_LOAN_ID => p_approval_action_rec.loan_id
118: ,P_ACTION_TYPE => p_approval_action_rec.action_type
119: ,P_AMOUNT => p_approval_action_rec.amount

Line 194: FROM LNS_APPROVAL_ACTIONS

190: SELECT OBJECT_VERSION_NUMBER,
191: ROWID
192: INTO l_object_version_number,
193: l_rowid
194: FROM LNS_APPROVAL_ACTIONS
195: WHERE ACTION_ID = p_approval_action_rec.action_id
196: FOR UPDATE OF ACTION_ID NOWAIT;
197:
198: IF NOT

Line 209: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_approval_actions');

205: )
206: )
207: THEN
208: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
209: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_approval_actions');
210: FND_MSG_PUB.ADD;
211: RAISE FND_API.G_EXC_ERROR;
212: END IF;
213:

Line 224: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_update_approval_action procedure: Before call to LNS_APPROVAL_ACTIONS_PKG.Update_Row');

220: FND_MSG_PUB.ADD;
221: RAISE FND_API.G_EXC_ERROR;
222: END;
223:
224: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_update_approval_action procedure: Before call to LNS_APPROVAL_ACTIONS_PKG.Update_Row');
225:
226: -- log history
227: LNS_LOAN_HISTORY_PUB.log_record_pre(p_approval_action_rec.action_id,
228: 'ACTION_ID',

Line 229: 'LNS_APPROVAL_ACTIONS');

225:
226: -- log history
227: LNS_LOAN_HISTORY_PUB.log_record_pre(p_approval_action_rec.action_id,
228: 'ACTION_ID',
229: 'LNS_APPROVAL_ACTIONS');
230:
231: --Call to table-handler
232: LNS_APPROVAL_ACTIONS_PKG.Update_Row (X_ACTION_ID => p_approval_action_rec.action_id
233: ,P_OBJECT_VERSION_NUMBER => p_OBJECT_VERSION_NUMBER

Line 232: LNS_APPROVAL_ACTIONS_PKG.Update_Row (X_ACTION_ID => p_approval_action_rec.action_id

228: 'ACTION_ID',
229: 'LNS_APPROVAL_ACTIONS');
230:
231: --Call to table-handler
232: LNS_APPROVAL_ACTIONS_PKG.Update_Row (X_ACTION_ID => p_approval_action_rec.action_id
233: ,P_OBJECT_VERSION_NUMBER => p_OBJECT_VERSION_NUMBER
234: ,P_LOAN_ID => p_approval_action_rec.LOAN_ID
235: ,P_ACTION_TYPE => p_approval_action_rec.ACTION_TYPE
236: ,P_AMOUNT => p_approval_action_rec.AMOUNT

Line 264: 'LNS_APPROVAL_ACTIONS',

260:
261: -- log record changes
262: LNS_LOAN_HISTORY_PUB.log_record_post(p_approval_action_rec.action_id,
263: 'ACTION_ID',
264: 'LNS_APPROVAL_ACTIONS',
265: p_approval_action_rec.loan_id);
266:
267: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_update_approval_action procedure: After call to LNS_APPROVAL_ACTIONS_PKG.Update_Row');
268:

Line 267: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_update_approval_action procedure: After call to LNS_APPROVAL_ACTIONS_PKG.Update_Row');

263: 'ACTION_ID',
264: 'LNS_APPROVAL_ACTIONS',
265: p_approval_action_rec.loan_id);
266:
267: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_update_approval_action procedure: After call to LNS_APPROVAL_ACTIONS_PKG.Update_Row');
268:
269: END do_update_approval_action;
270:
271: /*===========================================================================+

Line 315: FROM LNS_APPROVAL_ACTIONS

311: -- check whether record has been deleted by another user. If not, lock it.
312: BEGIN
313: SELECT 'Y'
314: INTO l_dummy
315: FROM LNS_APPROVAL_ACTIONS
316: WHERE ACTION_ID = p_action_id;
317:
318: EXCEPTION
319: WHEN NO_DATA_FOUND THEN

Line 328: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_delete_approval_action procedure: Before call to LNS_APPROVAL_ACTIONS_PKG.Delete_Row');

324: RAISE FND_API.G_EXC_ERROR;
325: END;
326: END IF;
327:
328: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_delete_approval_action procedure: Before call to LNS_APPROVAL_ACTIONS_PKG.Delete_Row');
329:
330: --Call to table-handler
331: LNS_APPROVAL_ACTIONS_PKG.Delete_Row (P_ACTION_ID => p_action_id);
332:

Line 331: LNS_APPROVAL_ACTIONS_PKG.Delete_Row (P_ACTION_ID => p_action_id);

327:
328: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_delete_approval_action procedure: Before call to LNS_APPROVAL_ACTIONS_PKG.Delete_Row');
329:
330: --Call to table-handler
331: LNS_APPROVAL_ACTIONS_PKG.Delete_Row (P_ACTION_ID => p_action_id);
332:
333: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_delete_approval_action procedure: After call to LNS_APPROVAL_ACTIONS_PKG.Delete_Row');
334:
335: END do_delete_approval_action;

Line 333: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_delete_approval_action procedure: After call to LNS_APPROVAL_ACTIONS_PKG.Delete_Row');

329:
330: --Call to table-handler
331: LNS_APPROVAL_ACTIONS_PKG.Delete_Row (P_ACTION_ID => p_action_id);
332:
333: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_delete_approval_action procedure: After call to LNS_APPROVAL_ACTIONS_PKG.Delete_Row');
334:
335: END do_delete_approval_action;
336:
337: PROCEDURE validate_loan (