The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_ccid (p_ccid IN NUMBER,
p_segment_info IN FND_FLEX_EXT.SEGMENTARRAY,
p_num_segments IN NUMBER)
IS
l_count number := 0;
l_full_path VARCHAR2(1000) := g_path || 'insert_ccid.';
psa_utils.debug_other_string(g_state_level,l_full_path,' Inside insert_ccid ');
psa_utils.debug_other_string(g_state_level,l_full_path,' END - insert ccid ');
psa_utils.debug_other_string(g_excep_level,l_full_path,'EXCEPTION - OTHERS : ERROR IN PSA_MFAR_UTILS.insert_ccid');
End insert_ccid;
SELECT chart_of_accounts_id
INTO g_chart_of_accounts_id
FROM gl_sets_of_books
WHERE set_of_books_id = p_set_of_books_id;
insert_ccid(l_ccid, l_primary_segments, l_num_segments);
insert_ccid(l_ccid, l_override_segments, l_num_segments);
insert_ccid(p_ccid, l_segments, l_segments.count);
/* ========================== INSERT_DISTRIBUTIONS_LOG ===================== */
PROCEDURE INSERT_DISTRIBUTIONS_LOG (p_error_id IN NUMBER,
p_activity IN VARCHAR2,
p_customer_trx_id IN NUMBER,
p_activity_id IN NUMBER,
p_error_message IN VARCHAR2) AS
PRAGMA AUTONOMOUS_TRANSACTION;
l_last_updated_by PSA_MF_DISTRIBUTIONS_LOG.LAST_UPDATED_BY%TYPE;
l_last_update_login PSA_MF_DISTRIBUTIONS_LOG.LAST_UPDATE_LOGIN%TYPE;
l_last_updated_by := FND_GLOBAL.USER_ID;
IF l_last_updated_by IS NULL THEN
l_last_updated_by := -1;
l_last_update_login := FND_GLOBAL.LOGIN_ID;
IF l_last_update_login IS NULL THEN
l_last_update_login := -1;
INSERT INTO PSA_MF_DISTRIBUTIONS_LOG ( ERROR_ID,
ACTIVITY,
CUSTOMER_TRX_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
CREATED_BY,
CREATED_DATE,
ACTIVITY_ID,
ERROR_MESSAGE)
VALUES (p_error_id,
p_activity,
p_customer_trx_id,
SYSDATE,
l_last_updated_by,
l_last_update_login,
l_last_update_login,
SYSDATE,
p_activity_id,
p_error_message);
END INSERT_DISTRIBUTIONS_LOG;
SELECT SUBSTR(v.compiled_value_attributes,5,1) account_code
FROM gl_sets_of_books b,
fnd_flex_values v,
fnd_id_flex_segments s
WHERE v.flex_value_set_id = s.flex_value_set_id
AND v.flex_value = p_natural_account
AND b.set_of_books_id = p_set_of_books_id
AND b.chart_of_accounts_id = p_chart_of_accounts_id
AND (s.application_id, s.id_flex_code, s.id_flex_num, s.application_column_name) =
(SELECT application_id, id_flex_code, id_flex_num, application_column_name
FROM fnd_segment_attribute_values a
WHERE id_flex_code = 'GL#'
AND segment_attribute_type = 'GL_ACCOUNT'
AND attribute_value = 'Y'
AND id_flex_num = b.chart_of_accounts_id
AND application_id =
(SELECT application_id
FROM fnd_application
WHERE application_short_name = 'SQLGL'));
SELECT b.target_account mapped_account
FROM PSA_MF_ACCT_MAP_HEADER_ALL A,
PSA_MF_ACCOUNT_MAPPING_ALL B
WHERE a.psa_acct_mapping_id = b.psa_acct_mapping_id
AND a.org_id = l_org_id
AND a.document_code = p_transaction_type
AND a.lookup_code = c_lookup_code
AND b.source_account = c_source_account
AND trunc(sysdate) >= trunc(b.start_date_active)
AND trunc(sysdate) <= trunc(nvl(b.end_date_active,sysdate));
SELECT *
FROM psa_implementation_all
WHERE org_id = c_org_id;
SELECT set_of_books_id
INTO l_ar_sob_id
FROM ar_system_parameters;
SELECT previous_customer_trx_id
FROM ra_customer_trx_all
WHERE customer_trx_id = p_trx_id;
SELECT code_combination_id
INTO l_ret_code_combination
FROM ra_cust_trx_line_gl_dist_all
WHERE customer_trx_id = l_customer_trx_id
AND account_class = 'REC'
AND account_set_flag = 'N';
SELECT chart_of_accounts_id
INTO l_ret_coa_id
FROM gl_sets_of_books
WHERE set_of_books_id = sob_id;
SELECT user_je_category_name
INTO l_user_cat_name
FROM gl_je_categories
WHERE je_category_name = cat_name;