APPS.JA_CN_UPDATE_BANK_SEQ_PKG dependencies on JA_CN_VOUCHER_BANK_NUM

Line 65: --insert 1 into JA_CN_VOUCHER_BANK_NUM table

61: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.begin',
62: 'begin procedure');
63: END IF; --( g_proc_level >= g_dbg_level)
64:
65: --insert 1 into JA_CN_VOUCHER_BANK_NUM table
66: INSERT INTO JA_CN_VOUCHER_BANK_NUM
67: (legal_entity_id,
68: Balance_Segment,
69: ledger_id,

Line 66: INSERT INTO JA_CN_VOUCHER_BANK_NUM

62: 'begin procedure');
63: END IF; --( g_proc_level >= g_dbg_level)
64:
65: --insert 1 into JA_CN_VOUCHER_BANK_NUM table
66: INSERT INTO JA_CN_VOUCHER_BANK_NUM
67: (legal_entity_id,
68: Balance_Segment,
69: ledger_id,
70: Period_Name,

Line 145: -- update the JA_CN_VOUCHER_BANK_NUM table with new next_number

141: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.begin',
142: 'begin procedure');
143: END IF; --( g_proc_level >= g_dbg_level)
144:
145: -- update the JA_CN_VOUCHER_BANK_NUM table with new next_number
146: UPDATE JA_CN_VOUCHER_BANK_NUM jcjn
147: SET jcjn.next_number = p_next_number,
148: jcjn.last_updated_by = fnd_global.USER_ID,
149: jcjn.last_update_date = SYSDATE,

Line 146: UPDATE JA_CN_VOUCHER_BANK_NUM jcjn

142: 'begin procedure');
143: END IF; --( g_proc_level >= g_dbg_level)
144:
145: -- update the JA_CN_VOUCHER_BANK_NUM table with new next_number
146: UPDATE JA_CN_VOUCHER_BANK_NUM jcjn
147: SET jcjn.next_number = p_next_number,
148: jcjn.last_updated_by = fnd_global.USER_ID,
149: jcjn.last_update_date = SYSDATE,
150: jcjn.last_update_login = fnd_global.LOGIN_ID

Line 210: FROM JA_CN_VOUCHER_BANK_NUM jcjn

206:
207: -- this cursor is used to get stored next_number
208: CURSOR c_sequence IS
209: SELECT next_number
210: FROM JA_CN_VOUCHER_BANK_NUM jcjn
211: WHERE jcjn.legal_entity_id = NVL(p_legal_entity_ID, -1)
212: AND jcjn.balance_segment=p_bsv
213: and jcjn.ledger_id = P_ledger_id
214: AND jcjn.period_name = p_period_name;