APPS.XLA_RETRIVE_CCID_PKG dependencies on XLA_FSAH_CCID_RANGES

Line 255: INSERT INTO xla_fsah_ccid_ranges

251: AND ledger_id = g_seq_context_value (i);
252:
253: IF l_rec_count <> 0
254: THEN
255: INSERT INTO xla_fsah_ccid_ranges
256: (parent_request_id, request_id, batch_id,
257: application_id, ledger_id, from_ccid,
258: to_ccid, status_code)
259: SELECT p_parent_request_id, NULL, p_acc_batch_id,

Line 323: --Procedure for Update table xla_fsah_ccid_ranges with status

319: (p_location => 'xla_retrive_ccid_pkg.collect_ccid_inf');
320: END collect_ccid_inf;
321:
322: --===================================================================================
323: --Procedure for Update table xla_fsah_ccid_ranges with status
324: --===================================================================================
325: PROCEDURE update_ccid_inf (
326: p_parent_request_id IN NUMBER,
327: p_from_ccid OUT NOCOPY NUMBER,

Line 364: UPDATE xla_fsah_ccid_ranges

360: p_module => l_log_module
361: );
362: END IF;
363:
364: UPDATE xla_fsah_ccid_ranges
365: SET status_code = c_ccid_processed
366: WHERE parent_request_id = p_parent_request_id
367: AND status_code = c_ccid_unprocessed
368: AND ROWNUM = 1

Line 510: FROM xla_fsah_ccid_ranges

506: --print_logfile('Ledger Id from main loop: '||' '||g_seq_context_value(i));
507: LOOP
508: SELECT ledger_id, from_ccid
509: INTO l_ledger_id_i, l_start_index
510: FROM xla_fsah_ccid_ranges
511: WHERE parent_request_id = p_parent_request_id
512: AND status_code = 'UNPROCESSED'
513: AND ROWNUM = 1;
514:

Line 541: UPDATE xla_fsah_ccid_ranges

537: argument6 => l_ledger_id_i,
538: argument7 => p_parent_request_id
539: );
540:
541: UPDATE xla_fsah_ccid_ranges
542: SET request_id = l_javacp_request_id_sing
543: WHERE parent_request_id = p_parent_request_id
544: AND from_ccid = l_start_index
545: AND to_ccid = l_end_index;

Line 615: DELETE FROM xla_fsah_ccid_ranges

611: );
612: ---------------------------------------------------------------------------
613: -- Delete rows from table for ranges which are having status 'SUCCESSFUL'
614: --------------------------------------------------------------------------- */
615: DELETE FROM xla_fsah_ccid_ranges
616: WHERE status_message = 'SUCCESSFUL';
617:
618: COMMIT;
619: print_logfile ( TO_CHAR (SYSDATE, 'DD-MON-YYYY HH24:MI:SS')

Line 1069: UPDATE xla_fsah_ccid_ranges

1065: dev_status => l_dstatus,
1066: MESSAGE => l_message
1067: );
1068:
1069: UPDATE xla_fsah_ccid_ranges
1070: SET status_message = l_message
1071: WHERE request_id = p_array_request_id (i);
1072:
1073: IF NOT l_btemp

Line 1102: UPDATE xla_fsah_ccid_ranges

1098: IF l_dstatus = 'WARNING'
1099: THEN
1100: p_warning_status := 'Y';
1101:
1102: UPDATE xla_fsah_ccid_ranges
1103: SET status_message = l_message
1104: WHERE request_id = p_array_request_id (i);
1105: ELSIF l_dstatus = 'ERROR'
1106: THEN

Line 1109: UPDATE xla_fsah_ccid_ranges

1105: ELSIF l_dstatus = 'ERROR'
1106: THEN
1107: p_error_status := 'Y';
1108:
1109: UPDATE xla_fsah_ccid_ranges
1110: SET status_message = l_message
1111: WHERE request_id = p_array_request_id (i);
1112: END IF;
1113: