[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT d.transaction_category
INTO p_rec_attribute_cat
FROM fv_ar_acc_category_map_hdr h,
fv_ar_acc_category_map_dtl d
WHERE h.fv_sla_map_hdr_id = d.fv_sla_map_hdr_id
AND NVL(h.org_id, -1) = NVL(p_org_id, -1)
AND h.receivable_attribute_type = p_rec_attribute_type
AND d.receivable_attribute_id = p_rec_atrribute_id;
SELECT h.org_id,
h.cust_trx_type_id,
h.bill_to_customer_id
INTO p_org_id,
p_rec_atrribute_id,
p_customer_id
FROM ra_customer_trx_all h
WHERE customer_trx_id = p_transcation_id;
SELECT type
INTO l_rect_type
FROM ar_cash_receipts_all
WHERE cash_receipt_id = p_transcation_id;
SELECT h.org_id,
h.receipt_method_id,
hcas.cust_account_id
INTO p_org_id,
p_rec_atrribute_id,
p_customer_id
FROM ar_cash_receipts_all h,
hz_cust_site_uses_all hcsu,
hz_cust_acct_sites_all hcas
WHERE h.cash_receipt_id = p_transcation_id
AND hcsu.site_use_id = h.customer_site_use_id
AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id;
SELECT h.org_id,
h.receivables_trx_id,
hcas.cust_account_id
INTO p_org_id,
p_rec_atrribute_id,
p_customer_id
FROM ar_adjustments_all h,
ar_cash_receipts_all acr,
hz_cust_site_uses_all hcsu,
hz_cust_acct_sites_all hcas
WHERE h.adjustment_id = p_transcation_id
AND h.associated_cash_receipt_id = acr.cash_receipt_id
AND hcsu.site_use_id = acr.customer_site_use_id
AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id;
SELECT h.org_id,
h.receivables_trx_id,
hcas.cust_account_id
INTO p_org_id,
p_rec_atrribute_id,
p_customer_id
FROM ar_adjustments_all h,
ra_customer_trx_all acr,
hz_cust_site_uses_all hcsu,
hz_cust_acct_sites_all hcas
WHERE h.adjustment_id = p_transcation_id
AND h.customer_trx_id = acr.customer_trx_id
AND hcsu.site_use_id = acr.bill_to_site_use_id
AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id;
SELECT t.source_id_int_1,
t.entity_code
INTO l_transcation_id,
l_entity_code
FROM xla_events e,
xla_transaction_entities t
WHERE e.entity_id = t.entity_id
AND e.event_id = p_event_id;
SELECT cash_receipt_id,
payment_set_id
INTO l_cash_receipt_id,
l_payment_set_id
FROM ar_receivable_applications_all ara
WHERE ara.receivable_application_id = p_transcation_id;
l_stmt := 'SELECT advance_required, advance_amount
FROM pa_agreements_all
WHERE payment_set_id = :l_payment_set_id';
SELECT l.event_id,
l.trx_line_dist_ccid,
l.line_number
FROM ar_cust_trx_lines_l_v l
WHERE l.event_id = c_event_id
AND l.trx_line_dist_account_class = 'REV';
SELECT l.event_id,
l.trx_line_dist_ccid,
l.line_number
FROM ar_cust_trx_lines_l_v l
WHERE l.event_id = c_event_id
AND l.trx_line_dist_account_class = 'REV';
SELECT d.event_id,
d.line_number,
d.dist_code_combination_id,
l.trx_line_dist_ccid
FROM ar_distributions_l_v d,
ar_cust_trx_lines_l_v l
WHERE d.dist_source_type IN ('REC', 'ADJ')
AND l.event_id = d.event_id
AND l.line_number = d.line_number
AND d.event_id = c_event_id
AND NVL(d.dist_ref_mf_dist_flag||d.dist_source_table_secondary, ' ') <> 'UUPMFCHMIAR'
UNION
SELECT d.event_id,
d.line_number,
d.dist_code_combination_id,
d.dist_code_combination_id trx_line_dist_ccid
FROM ar_distributions_l_v d
WHERE d.dist_source_type IN ('ACC', 'OTHER ACC')
AND d.event_id = c_event_id
AND NVL(d.dist_ref_mf_dist_flag||d.dist_source_table_secondary, ' ') <> 'UUPMFCHMIAR';
SELECT arv.event_id,
arv.line_number,
arv.dist_code_combination_id
FROM ar_distributions_l_v arv
WHERE arv.event_id = c_event_id
AND dist_source_type = 'MISCCASH'
AND dist_mfar_additional_entry = 'Y'
AND dist_paired_source_type = 'CLEARED';
FOR event_rec IN (SELECT *
FROM xla_events_gt
WHERE application_id = p_application_id) LOOP
fv_sla_utl_processing_pkg.get_ledger_info
(
p_ledger_id => event_rec.ledger_id,
p_ledger_rec => l_ledger_info,
p_error_code => l_error_code,
p_error_desc => l_error_desc
);
'INV_UPDATE',
'DM_CREATE',
'DM_UPDATE',
'CM_CREATE',
'CM_UPDATE'
)) THEN
FOR inv_rec IN cur_ar_inv_extract_details(event_rec.event_id) LOOP
IF (l_error_code = C_SUCCESS) THEN
trace(C_STATE_LEVEL, l_procedure_name, 'Calling get_segment_values');
trace(C_STATE_LEVEL, l_procedure_name, ' Inserting accounting errors into xla_accounting_errors table for event :'||event_rec.event_id);
fv_sla_utl_processing_pkg.INSERT_FV_XLA_ACC_ERRORS
(
p_appli_s_name=> 'FV',
p_msg_name => 'FV_AR_FUND_NO_SETUP',
p_entity_id => event_rec.entity_id,
p_event_id => event_rec.event_id,
p_ledger_id => l_ledger_info.ledger_id
);
-- Update process status code to E
IF (event_rec.event_id is not null) THEN
BEGIN
trace(C_STATE_LEVEL, l_procedure_name, ' Before updating xla_events_gt');
update xla_events_gt
set PROCESS_STATUS_CODE='E'
where event_id=event_rec.event_id
and application_id=p_application_id;
'RECP_UPDATE',
'RECP_REVERSE',
'ADJ_CREATE')) THEN
FOR rec_rec IN cur_ar_rct_extract_details (event_rec.event_id) LOOP
IF (l_error_code = C_SUCCESS) THEN
trace(C_STATE_LEVEL, l_procedure_name, 'Calling get_segment_values');
trace(C_STATE_LEVEL, l_procedure_name, ' Inserting accounting errors into xla_accounting_errors table for event :'||event_rec.event_id);
fv_sla_utl_processing_pkg.INSERT_FV_XLA_ACC_ERRORS
(
p_appli_s_name=> 'FV',
p_msg_name => 'FV_AR_FUND_NO_SETUP',
p_entity_id => event_rec.entity_id,
p_event_id => event_rec.event_id,
p_ledger_id => l_ledger_info.ledger_id
);
-- Update process status code to E
IF (event_rec.event_id is not null) THEN
BEGIN
trace(C_STATE_LEVEL, l_procedure_name, ' Before updating xla_events_gt');
update xla_events_gt
set PROCESS_STATUS_CODE='E'
where event_id=event_rec.event_id
and application_id=p_application_id;
'MISC_RECP_UPDATE',
'MISC_RECP_REVERSE')) THEN
FOR misc_rec IN cur_misc_rct_extract_details (event_rec.event_id) LOOP
IF (l_error_code = C_SUCCESS) THEN
trace(C_STATE_LEVEL, l_procedure_name, 'Calling get_segment_values');
trace(C_STATE_LEVEL, l_procedure_name, ' Inserting accounting errors into xla_accounting_errors table for event :'||event_rec.event_id);
fv_sla_utl_processing_pkg.INSERT_FV_XLA_ACC_ERRORS
(
p_appli_s_name=> 'FV',
p_msg_name => 'FV_AR_FUND_NO_SETUP',
p_entity_id => event_rec.entity_id,
p_event_id => event_rec.event_id,
p_ledger_id => l_ledger_info.ledger_id
);
-- Update process status code to E
IF (event_rec.event_id is not null) THEN
BEGIN
trace(C_STATE_LEVEL, l_procedure_name, ' Before updating xla_events_gt');
update xla_events_gt
set PROCESS_STATUS_CODE='E'
where event_id=event_rec.event_id
and application_id=p_application_id;
INSERT INTO fv_extract_detail_gt VALUES l_fv_extract_detail(l_index);