APPS.LNS_FUNDING_PUB dependencies on LNS_DISB_HISTORIES_H

Line 3878: from LNS_DISB_HISTORIES_H

3874:
3875: -- submition attemts info
3876: CURSOR attempts_cur(P_DISB_LINE_ID number) IS
3877: select count(1) + 1
3878: from LNS_DISB_HISTORIES_H
3879: where DISB_LINE_ID = P_DISB_LINE_ID;
3880:
3881: -- query liability distribution info - invoice header
3882: CURSOR liability_distr_cur(P_LOAN_ID number) IS

Line 4730: LNS_DISB_HISTORIES_H_PKG.Insert_Row(

4726: l_DISB_LINE_REC.REQUEST_DATE := sysdate;
4727:
4728: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Inserting new history record...');
4729: -- calling history table handler api
4730: LNS_DISB_HISTORIES_H_PKG.Insert_Row(
4731: X_DISB_HISTORY_ID => l_hist_id,
4732: P_DISB_LINE_ID => l_DISB_LINE_REC.DISB_LINE_ID,
4733: P_ATTEMPT_NUMBER => l_attempt,
4734: P_BANK_ACCOUNT_ID => l_DISB_LINE_REC.BANK_ACCOUNT_ID,

Line 4837: LNS_DISB_HISTORIES_H_PKG.Insert_Row(

4833: l_DISB_LINE_REC.REQUEST_DATE := sysdate;
4834:
4835: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Inserting new history record...');
4836: -- calling history table handler api
4837: LNS_DISB_HISTORIES_H_PKG.Insert_Row(
4838: X_DISB_HISTORY_ID => l_hist_id,
4839: P_DISB_LINE_ID => l_DISB_LINE_REC.DISB_LINE_ID,
4840: P_ATTEMPT_NUMBER => l_attempt,
4841: P_BANK_ACCOUNT_ID => l_DISB_LINE_REC.BANK_ACCOUNT_ID,

Line 5600: from lns_disb_histories_h

5596:
5597: -- getting last history record to update status
5598: CURSOR last_hist_rec_cur(P_DISB_LINE_ID number) IS
5599: select max(DISB_HISTORY_ID), max(OBJECT_VERSION_NUMBER+1)
5600: from lns_disb_histories_h
5601: where DISB_LINE_ID = P_DISB_LINE_ID;
5602:
5603: -- query term version
5604: CURSOR term_version_cur(P_LOAN_ID number) IS

Line 5782: LNS_DISB_HISTORIES_H_PKG.Update_Row(

5778: close last_hist_rec_cur;
5779:
5780: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating history record...');
5781: -- calling history table handler api
5782: LNS_DISB_HISTORIES_H_PKG.Update_Row(
5783: P_DISB_HISTORY_ID => l_hist_id,
5784: P_STATUS => l_DISB_LINE_REC.STATUS,
5785: P_OBJECT_VERSION_NUMBER => l_hist_version);
5786:

Line 6862: from lns_disb_histories_h

6858:
6859: -- getting last history record to update status
6860: CURSOR last_hist_rec_cur(P_DISB_LINE_ID number) IS
6861: select max(DISB_HISTORY_ID), max(OBJECT_VERSION_NUMBER+1)
6862: from lns_disb_histories_h
6863: where DISB_LINE_ID = P_DISB_LINE_ID;
6864:
6865: CURSOR submitDisb_exist_cur(c_disb_header_id NUMBER) IS
6866: select count(1)

Line 6989: LNS_DISB_HISTORIES_H_PKG.Update_Row(

6985: if l_hist_id is not null and l_hist_version is not null then
6986:
6987: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating history record...');
6988: -- calling history table handler api
6989: LNS_DISB_HISTORIES_H_PKG.Update_Row(
6990: P_DISB_HISTORY_ID => l_hist_id,
6991: P_STATUS => 'CANCELLED',
6992: P_OBJECT_VERSION_NUMBER => l_hist_version);
6993:

Line 9316: from lns_disb_histories_h

9312:
9313: -- getting last history record to update status
9314: CURSOR last_hist_rec_cur(P_DISB_LINE_ID number) IS
9315: select max(DISB_HISTORY_ID), max(OBJECT_VERSION_NUMBER+1)
9316: from lns_disb_histories_h
9317: where DISB_LINE_ID = P_DISB_LINE_ID;
9318:
9319: BEGIN
9320:

Line 9383: LNS_DISB_HISTORIES_H_PKG.Update_Row(

9379: if l_hist_id is not null and l_hist_version is not null then
9380:
9381: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating history record...');
9382: -- calling history table handler api
9383: LNS_DISB_HISTORIES_H_PKG.Update_Row(
9384: P_DISB_HISTORY_ID => l_hist_id,
9385: P_STATUS => 'CANCELLED',
9386: P_OBJECT_VERSION_NUMBER => l_hist_version);
9387: