The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT xlr.ledger_id
BULK COLLECT INTO g_seq_context_value
FROM xla_ledger_relationships_v xlr, xla_subledger_options_v xso
WHERE xlr.relationship_enabled_flag = 'Y'
AND xlr.ledger_category_code IN ('ALC', 'PRIMARY', 'SECONDARY')
AND DECODE (xso.valuation_method_flag,
'N', xlr.primary_ledger_id,
DECODE (xlr.ledger_category_code,
'ALC', xlr.primary_ledger_id,
xlr.ledger_id
)
) = p_ledger_id
AND xso.application_id = p_application_id
AND xso.ledger_id =
DECODE (xlr.ledger_category_code,
'ALC', xlr.primary_ledger_id,
xlr.ledger_id
)
AND xso.enabled_flag = 'Y';
SELECT NVL (MAX (ROWNUM), 0)
INTO l_loop_count
FROM gl_code_combinations gcc
WHERE gcc.code_combination_id IN (
SELECT code_combination_id
FROM xla_ae_lines
WHERE ae_header_id IN (
SELECT ae_header_id
FROM xla_ae_headers
WHERE accounting_batch_id = p_acc_batch_id
AND application_id = p_application_id
AND ledger_id = g_seq_context_value (i)));
SELECT NVL (MAX (ROWNUM), 0)
INTO l_rec_count
FROM xla_ae_headers
WHERE accounting_batch_id = p_acc_batch_id
AND application_id = p_application_id
AND ledger_id = g_seq_context_value (i);
INSERT INTO xla_fsah_ccid_ranges
(parent_request_id, request_id, batch_id,
application_id, ledger_id, from_ccid,
to_ccid, status_code)
SELECT p_parent_request_id, NULL, p_acc_batch_id,
p_application_id, g_seq_context_value (i),
MIN (code_combination_id),
MAX (code_combination_id),
c_ccid_unprocessed
FROM (SELECT gcc.code_combination_id,
CEIL
( SUM (COUNT (*)) OVER (ORDER BY gcc.code_combination_id ROWS UNBOUNDED PRECEDING)
/ l_parll_proc_size
) wu
FROM gl_code_combinations gcc
WHERE gcc.code_combination_id IN (
SELECT code_combination_id
FROM xla_ae_lines
WHERE ae_header_id IN (
SELECT ae_header_id
FROM xla_ae_headers
WHERE accounting_batch_id =
p_acc_batch_id
AND application_id =
p_application_id
AND ledger_id =
g_seq_context_value
(i)
GROUP BY ae_header_id))
GROUP BY gcc.code_combination_id)
GROUP BY wu;
PROCEDURE update_ccid_inf (
p_parent_request_id IN NUMBER,
p_from_ccid OUT NOCOPY NUMBER,
p_to_ccid OUT NOCOPY NUMBER,
p_ledger_id OUT NOCOPY NUMBER
)
IS
l_log_module VARCHAR2 (240);
|| ' - Starting of the Update CCID Information'
);
l_log_module := c_default_module || '.update_ccid_inf';
TRACE (p_msg => 'BEGIN of procedure UPDATE_CCID_INF',
p_level => c_level_procedure,
p_module => l_log_module
);
UPDATE xla_fsah_ccid_ranges
SET status_code = c_ccid_processed
WHERE parent_request_id = p_parent_request_id
AND status_code = c_ccid_unprocessed
AND ROWNUM = 1
RETURNING from_ccid, to_ccid, ledger_id
INTO p_from_ccid, p_to_ccid, p_ledger_id;
|| ' - End of the Update CCID Information'
);
print_logfile ('Error occured in update_ccid_inf');
(p_location => 'xla_retrive_ccid_pkg.update_ccid_inf');
END update_ccid_inf;
SELECT ledger_id, from_ccid
INTO l_ledger_id_i, l_start_index
FROM xla_fsah_ccid_ranges
WHERE parent_request_id = p_parent_request_id
AND status_code = 'UNPROCESSED'
AND ROWNUM = 1;
update_ccid_inf
(p_parent_request_id => l_parent_request_id,
p_from_ccid => l_start_index,
p_to_ccid => l_end_index,
p_ledger_id => l_ledger_id_i
);
UPDATE xla_fsah_ccid_ranges
SET request_id = l_javacp_request_id_sing
WHERE parent_request_id = p_parent_request_id
AND from_ccid = l_start_index
AND to_ccid = l_end_index;
l_javacp_request_id.DELETE;
DELETE FROM xla_fsah_ccid_ranges
WHERE status_message = 'SUCCESSFUL';
SELECT xla_array_ccid_inf (e.id_flex_structure_name,
e.chart_of_accounts_id,
e.code_combination_id,
e.segment1,
e.seg1_name,
e.segment2,
e.seg2_name,
e.segment3,
e.seg3_name,
e.segment4,
e.seg4_name,
e.segment5,
e.seg5_name,
e.segment6,
e.seg6_name,
e.segment7,
e.seg7_name,
e.segment8,
e.seg8_name,
e.segment9,
e.seg9_name,
e.segment10,
e.seg10_name,
e.segment11,
e.seg11_name,
e.segment12,
e.seg12_name,
e.segment13,
e.seg13_name,
e.segment14,
e.seg14_name,
e.segment15,
e.seg15_name,
e.segment16,
e.seg16_name,
e.segment17,
e.seg17_name,
e.segment18,
e.seg18_name,
e.segment19,
e.seg19_name,
e.segment20,
e.seg20_name,
e.segment21,
e.seg21_name,
e.segment22,
e.seg22_name,
e.segment23,
e.seg23_name,
e.segment24,
e.seg24_name,
e.segment25,
e.seg25_name,
e.segment26,
e.seg26_name,
e.segment27,
e.seg27_name,
e.segment28,
e.seg28_name,
e.segment29,
e.seg29_name,
e.segment30,
e.seg30_name
)
BULK COLLECT INTO l_thread_ccid_inf
FROM (SELECT ffsv.id_flex_structure_name, gcc.chart_of_accounts_id,
gcc.code_combination_id, gcc.segment1,
'SEGMENT1' seg1_name, gcc.segment2,
'SEGMENT2' seg2_name, gcc.segment3,
'SEGMENT3' seg3_name, gcc.segment4,
'SEGMENT4' seg4_name, gcc.segment5,
'SEGMENT5' seg5_name, gcc.segment6,
'SEGMENT6' seg6_name, gcc.segment7,
'SEGMENT7' seg7_name, gcc.segment8,
'SEGMENT8' seg8_name, gcc.segment9,
'SEGMENT9' seg9_name, gcc.segment10,
'SEGMENT10' seg10_name, gcc.segment11,
'SEGMENT11' seg11_name, gcc.segment12,
'SEGMENT12' seg12_name, gcc.segment13,
'SEGMENT13' seg13_name, gcc.segment14,
'SEGMENT14' seg14_name, gcc.segment15,
'SEGMENT15' seg15_name, gcc.segment16,
'SEGMENT16' seg16_name, gcc.segment17,
'SEGMENT17' seg17_name, gcc.segment18,
'SEGMENT18' seg18_name, gcc.segment19,
'SEGMENT19' seg19_name, gcc.segment20,
'SEGMENT20' seg20_name, gcc.segment21,
'SEGMENT21' seg21_name, gcc.segment22,
'SEGMENT22' seg22_name, gcc.segment23,
'SEGMENT23' seg23_name, gcc.segment24,
'SEGMENT24' seg24_name, gcc.segment25,
'SEGMENT25' seg25_name, gcc.segment26,
'SEGMENT26' seg26_name, gcc.segment27,
'SEGMENT27' seg27_name, gcc.segment28,
'SEGMENT28' seg28_name, gcc.segment29,
'SEGMENT29' seg29_name, gcc.segment30,
'SEGMENT30' seg30_name
FROM gl_code_combinations gcc,
fnd_id_flex_structures_vl ffsv
WHERE gcc.chart_of_accounts_id = ffsv.id_flex_num
AND ffsv.application_id = 101
AND ffsv.id_flex_code = 'GL#'
AND gcc.code_combination_id IN (
SELECT code_combination_id
FROM xla_ae_lines
WHERE ae_header_id IN (
SELECT ae_header_id
FROM xla_ae_headers
WHERE accounting_batch_id =
p_acc_batch_id
AND application_id = p_application_id
AND ledger_id = p_ledger_id))) e
WHERE e.code_combination_id BETWEEN p_min_num AND p_max_num;
SELECT xla_array_ccid_inf (e.id_flex_structure_name,
e.chart_of_accounts_id,
e.code_combination_id,
e.segment1,
e.seg1_name,
e.segment2,
e.seg2_name,
e.segment3,
e.seg3_name,
e.segment4,
e.seg4_name,
e.segment5,
e.seg5_name,
e.segment6,
e.seg6_name,
e.segment7,
e.seg7_name,
e.segment8,
e.seg8_name,
e.segment9,
e.seg9_name,
e.segment10,
e.seg10_name,
e.segment11,
e.seg11_name,
e.segment12,
e.seg12_name,
e.segment13,
e.seg13_name,
e.segment14,
e.seg14_name,
e.segment15,
e.seg15_name,
e.segment16,
e.seg16_name,
e.segment17,
e.seg17_name,
e.segment18,
e.seg18_name,
e.segment19,
e.seg19_name,
e.segment20,
e.seg20_name,
e.segment21,
e.seg21_name,
e.segment22,
e.seg22_name,
e.segment23,
e.seg23_name,
e.segment24,
e.seg24_name,
e.segment25,
e.seg25_name,
e.segment26,
e.seg26_name,
e.segment27,
e.seg27_name,
e.segment28,
e.seg28_name,
e.segment29,
e.seg29_name,
e.segment30,
e.seg30_name
)
BULK COLLECT INTO l_thread_ccid_inf
FROM (SELECT ffsv.id_flex_structure_name, gcc.chart_of_accounts_id,
gcc.code_combination_id, gcc.segment1,
'SEGMENT1' seg1_name, gcc.segment2,
'SEGMENT2' seg2_name, gcc.segment3,
'SEGMENT3' seg3_name, gcc.segment4,
'SEGMENT4' seg4_name, gcc.segment5,
'SEGMENT5' seg5_name, gcc.segment6,
'SEGMENT6' seg6_name, gcc.segment7,
'SEGMENT7' seg7_name, gcc.segment8,
'SEGMENT8' seg8_name, gcc.segment9,
'SEGMENT9' seg9_name, gcc.segment10,
'SEGMENT10' seg10_name, gcc.segment11,
'SEGMENT11' seg11_name, gcc.segment12,
'SEGMENT12' seg12_name, gcc.segment13,
'SEGMENT13' seg13_name, gcc.segment14,
'SEGMENT14' seg14_name, gcc.segment15,
'SEGMENT15' seg15_name, gcc.segment16,
'SEGMENT16' seg16_name, gcc.segment17,
'SEGMENT17' seg17_name, gcc.segment18,
'SEGMENT18' seg18_name, gcc.segment19,
'SEGMENT19' seg19_name, gcc.segment20,
'SEGMENT20' seg20_name, gcc.segment21,
'SEGMENT21' seg21_name, gcc.segment22,
'SEGMENT22' seg22_name, gcc.segment23,
'SEGMENT23' seg23_name, gcc.segment24,
'SEGMENT24' seg24_name, gcc.segment25,
'SEGMENT25' seg25_name, gcc.segment26,
'SEGMENT26' seg26_name, gcc.segment27,
'SEGMENT27' seg27_name, gcc.segment28,
'SEGMENT28' seg28_name, gcc.segment29,
'SEGMENT29' seg29_name, gcc.segment30,
'SEGMENT30' seg30_name
FROM gl_code_combinations gcc,
fnd_id_flex_structures_vl ffsv
WHERE gcc.chart_of_accounts_id = ffsv.id_flex_num
AND ffsv.application_id = 101
AND ffsv.id_flex_code = 'GL#'
AND gcc.code_combination_id IN (
SELECT code_combination_id
FROM xla_ae_lines
WHERE ae_header_id IN (
SELECT ae_header_id
FROM xla_ae_headers
WHERE accounting_batch_id =
p_acc_batch_id
AND application_id = p_application_id
AND ledger_id = p_ledger_id))) e;
SELECT xla_array_ccid_seq_inf (e.application_column_name, e.segment_num)
BULK COLLECT INTO p_ccid_seq_out
FROM fnd_id_flex_segments e
WHERE e.id_flex_code = 'GL#' AND e.id_flex_num = p_coa_num;
UPDATE xla_fsah_ccid_ranges
SET status_message = l_message
WHERE request_id = p_array_request_id (i);
UPDATE xla_fsah_ccid_ranges
SET status_message = l_message
WHERE request_id = p_array_request_id (i);
UPDATE xla_fsah_ccid_ranges
SET status_message = l_message
WHERE request_id = p_array_request_id (i);