73: ,p_chart_of_accounts_id In NUMBER
74: ) IS
75:
76: l_procedure_name VARCHAR2(100) := 'Insert_Row';
77: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
78: l_proc_level NUMBER := FND_LOG.Level_Procedure;
79:
80: CURSOR C IS
81: SELECT ROWID
74: ) IS
75:
76: l_procedure_name VARCHAR2(100) := 'Insert_Row';
77: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
78: l_proc_level NUMBER := FND_LOG.Level_Procedure;
79:
80: CURSOR C IS
81: SELECT ROWID
82: FROM JA_CN_DFF_ASSIGNMENTS
85: BEGIN
86:
87: --log for debug
88: IF (l_proc_level >= l_dbg_level) THEN
89: FND_LOG.STRING(l_proc_level,
90: G_MODULE_PREFIX || '.' || l_procedure_name || '.begin',
91: 'Enter procedure');
92: END IF; --( l_proc_level >= l_dbg_level)
93:
135: CLOSE C;
136:
137: --log for debug
138: IF (l_proc_level >= l_dbg_level) THEN
139: FND_LOG.STRING(l_proc_level,
140: G_MODULE_PREFIX || '.' || l_procedure_name || '.end',
141: 'Exit procedure');
142: END IF; --( l_proc_level >= l_dbg_level)
143:
191: ,p_last_update_login IN NUMBER
192: ,p_chart_of_accounts_id In NUMBER) IS
193:
194: l_procedure_name VARCHAR2(100) := 'Update_Row';
195: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
196: l_proc_level NUMBER := FND_LOG.Level_Procedure;
197:
198: BEGIN
199:
192: ,p_chart_of_accounts_id In NUMBER) IS
193:
194: l_procedure_name VARCHAR2(100) := 'Update_Row';
195: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
196: l_proc_level NUMBER := FND_LOG.Level_Procedure;
197:
198: BEGIN
199:
200: --log for debug
198: BEGIN
199:
200: --log for debug
201: IF (l_proc_level >= l_dbg_level) THEN
202: FND_LOG.STRING(l_proc_level,
203: G_MODULE_PREFIX || '.' || l_procedure_name || '.begin',
204: 'Enter procedure');
205: END IF; --( l_proc_level >= l_dbg_level)
206:
225: END IF; --(SQL%NOTFOUND)
226:
227: --log for debug
228: IF (l_proc_level >= l_dbg_level) THEN
229: FND_LOG.STRING(l_proc_level,
230: G_MODULE_PREFIX || '.' || l_procedure_name || '.end',
231: 'Exit procedure');
232: END IF; --( l_proc_level >= l_dbg_level)
233:
281: ,p_last_update_login IN NUMBER
282: ,p_chart_of_accounts_id In NUMBER) IS
283:
284: l_procedure_name VARCHAR2(100) := 'Lock_Row';
285: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
286: l_proc_level NUMBER := FND_LOG.Level_Procedure;
287:
288: CURSOR c IS
289: SELECT *
282: ,p_chart_of_accounts_id In NUMBER) IS
283:
284: l_procedure_name VARCHAR2(100) := 'Lock_Row';
285: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
286: l_proc_level NUMBER := FND_LOG.Level_Procedure;
287:
288: CURSOR c IS
289: SELECT *
290: FROM JA_CN_DFF_ASSIGNMENTS
296: BEGIN
297:
298: --log for debug
299: IF (l_proc_level >= l_dbg_level) THEN
300: FND_LOG.STRING(l_proc_level,
301: G_MODULE_PREFIX || '.' || l_procedure_name || '.begin',
302: 'Begin procedure');
303: END IF; --( l_proc_level >= l_dbg_level)
304:
338: END IF; --IF p_dff_title_code IS NULL
339:
340: --log for debug
341: IF (l_proc_level >= l_dbg_level) THEN
342: FND_LOG.STRING(l_proc_level,
343: G_MODULE_PREFIX || '.' || l_procedure_name || '.end',
344: 'Exit procedure');
345: END IF; --( l_proc_level >= l_dbg_level)
346: END Lock_Row;