APPS.FUN_NET_BATCHES_PKG dependencies on FUN_NET_BATCHES_ALL

Line 56: l_batch_id fun_net_batches_all.batch_id%TYPE;

52: x_attribute19 IN VARCHAR2,
53: x_attribute20 IN VARCHAR2
54: ) IS
55:
56: l_batch_id fun_net_batches_all.batch_id%TYPE;
57: l_batch_number fun_net_batches_all.batch_number%TYPE;
58: l_path VARCHAR2(100);
59: BEGIN
60:

Line 57: l_batch_number fun_net_batches_all.batch_number%TYPE;

53: x_attribute20 IN VARCHAR2
54: ) IS
55:
56: l_batch_id fun_net_batches_all.batch_id%TYPE;
57: l_batch_number fun_net_batches_all.batch_number%TYPE;
58: l_path VARCHAR2(100);
59: BEGIN
60:
61: l_path := g_path||'Insert_Row';

Line 62: fun_net_util.Log_String(g_proc_level,l_path,'Before inserting into fun_net_batches_all');

58: l_path VARCHAR2(100);
59: BEGIN
60:
61: l_path := g_path||'Insert_Row';
62: fun_net_util.Log_String(g_proc_level,l_path,'Before inserting into fun_net_batches_all');
63:
64: IF x_batch_id IS NULL THEN
65: SELECT fun_net_batches_s.NEXTVAL INTO l_batch_id FROM DUAL;
66: x_batch_id := l_batch_id;

Line 218: fun_net_util.Log_String(g_proc_level,l_path,'Before updating fun_net_batches_all');

214:
215: l_path VARCHAR2(100);
216: BEGIN
217: l_path := g_path||'Update_Row';
218: fun_net_util.Log_String(g_proc_level,l_path,'Before updating fun_net_batches_all');
219:
220: UPDATE FUN_NET_BATCHES_ALL SET
221: batch_id = x_batch_id,
222: object_version_number = x_object_version_number,

Line 220: UPDATE FUN_NET_BATCHES_ALL SET

216: BEGIN
217: l_path := g_path||'Update_Row';
218: fun_net_util.Log_String(g_proc_level,l_path,'Before updating fun_net_batches_all');
219:
220: UPDATE FUN_NET_BATCHES_ALL SET
221: batch_id = x_batch_id,
222: object_version_number = x_object_version_number,
223: agreement_id = x_agreement_id,
224: batch_name = x_batch_name,

Line 277: UPDATE fun_net_batches_all

273: x_batch_status_code IN VARCHAR2
274: ) IS
275: PRAGMA AUTONOMOUS_TRANSACTION;
276: BEGIN
277: UPDATE fun_net_batches_all
278: SET batch_status_code = x_batch_status_code
279: WHERE batch_id = x_batch_id;
280:
281: IF SQL%FOUND THEN

Line 406: FROM FUN_NET_BATCHES_ALL

402: x_attribute17,
403: x_attribute18,
404: x_attribute19,
405: x_attribute20
406: FROM FUN_NET_BATCHES_ALL
407: WHERE batch_id = x_batch_id;
408:
409: IF SQL%NOTFOUND THEN
410: RAISE NO_DATA_FOUND;

Line 422: DELETE fun_net_batches_all

418: ) IS
419:
420: BEGIN
421:
422: DELETE fun_net_batches_all
423: WHERE batch_id = x_batch_id;
424:
425: IF ( SQL%NOTFOUND ) THEN
426: RAISE NO_DATA_FOUND;