APPS.JA_CN_UPDATE_JL_SEQ_PKG dependencies on JA_CN_JOURNAL_NUMBERING

Line 23: -- ja_cn_journal_numbering |

19: --| |
20: --| HISTORY |
21: --| 03/13/2006 Jackey Li Created |
22: -- 04/28/2007 Qingjun Zhao Add column Ledger_id to table |
23: -- ja_cn_journal_numbering |
24: --+======================================================================*/
25:
26: --==== Golbal Variables ============
27: g_module_name VARCHAR2(30) := 'JA_CN_UPDATE_JL_SEQ_PKG';

Line 50: -- ja_cn_journal_numbering

46: --
47: -- CHANGE HISTORY:
48: -- 03/13/2006 Jackey Li Created
49: -- 04/28/2007 Qingjun Zhao Add column Ledger_id to table
50: -- ja_cn_journal_numbering
51: --===========================================================================
52: PROCEDURE Create_JL_Seq(p_legal_entity_ID IN NUMBER,
53: p_ledger_id in number,
54: p_period_name IN VARCHAR2) IS

Line 66: --insert 1 into JA_CN_JOURNAL_NUMBERING table

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

Line 67: INSERT INTO JA_CN_JOURNAL_NUMBERING

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

Line 127: -- ja_cn_journal_numbering

123: --
124: -- CHANGE HISTORY:
125: -- 03/13/2006 Jackey Li Created
126: -- 04/28/2007 Qingjun Zhao Add column Ledger_id to table
127: -- ja_cn_journal_numbering
128: --===========================================================================
129: PROCEDURE Update_JL_Seq(p_legal_entity_ID IN NUMBER,
130: p_ledger_id in number,
131: p_period_name IN VARCHAR2,

Line 144: -- update the JA_CN_JOURNAL_NUMBERING table with new next_number

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

Line 145: UPDATE JA_CN_JOURNAL_NUMBERING jcjn

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

Line 192: -- ja_cn_journal_numbering

188: --
189: -- CHANGE HISTORY:
190: -- 03/13/2006 Jackey Li Created
191: -- 04/28/2007 Qingjun Zhao Add column Ledger_id to table
192: -- ja_cn_journal_numbering
193: --===========================================================================
194: FUNCTION Fetch_JL_Seq(p_legal_entity_ID IN NUMBER,
195: p_ledger_id in number,
196: p_period_name IN VARCHAR2) RETURN NUMBER IS

Line 206: FROM JA_CN_JOURNAL_NUMBERING jcjn

202:
203: -- this cursor is used to get stored next_number
204: CURSOR c_sequence IS
205: SELECT next_number
206: FROM JA_CN_JOURNAL_NUMBERING jcjn
207: WHERE jcjn.legal_entity_id = NVL(p_legal_entity_ID, -1)
208: and jcjn.ledger_id = P_ledger_id
209: AND jcjn.period_name = p_period_name;
210: BEGIN