[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_row (x_rowid IN OUT NOCOPY VARCHAR2,
x_facility_mapping_id NUMBER,
x_facility_id NUMBER,
x_segment1_low VARCHAR2,
x_segment1_high VARCHAR2,
x_segment2_low VARCHAR2,
x_segment2_high VARCHAR2,
x_segment3_low VARCHAR2,
x_segment3_high VARCHAR2,
x_segment4_low VARCHAR2,
x_segment4_high VARCHAR2,
x_segment5_low VARCHAR2,
x_segment5_high VARCHAR2,
x_segment6_low VARCHAR2,
x_segment6_high VARCHAR2,
x_segment7_low VARCHAR2,
x_segment7_high VARCHAR2,
x_segment8_low VARCHAR2,
x_segment8_high VARCHAR2,
x_segment9_low VARCHAR2,
x_segment9_high VARCHAR2,
x_segment10_low VARCHAR2,
x_segment10_high VARCHAR2,
x_segment11_low VARCHAR2,
x_segment11_high VARCHAR2,
x_segment12_low VARCHAR2,
x_segment12_high VARCHAR2,
x_segment13_low VARCHAR2,
x_segment13_high VARCHAR2,
x_segment14_low VARCHAR2,
x_segment14_high VARCHAR2,
x_segment15_low VARCHAR2,
x_segment15_high VARCHAR2,
x_segment16_low VARCHAR2,
x_segment16_high VARCHAR2,
x_segment17_low VARCHAR2,
x_segment17_high VARCHAR2,
x_segment18_low VARCHAR2,
x_segment18_high VARCHAR2,
x_segment19_low VARCHAR2,
x_segment19_high VARCHAR2,
x_segment20_low VARCHAR2,
x_segment20_high VARCHAR2,
x_segment21_low VARCHAR2,
x_segment21_high VARCHAR2,
x_segment22_low VARCHAR2,
x_segment22_high VARCHAR2,
x_segment23_low VARCHAR2,
x_segment23_high VARCHAR2,
x_segment24_low VARCHAR2,
x_segment24_high VARCHAR2,
x_segment25_low VARCHAR2,
x_segment25_high VARCHAR2,
x_segment26_low VARCHAR2,
x_segment26_high VARCHAR2,
x_segment27_low VARCHAR2,
x_segment27_high VARCHAR2,
x_segment28_low VARCHAR2,
x_segment28_high VARCHAR2,
x_segment29_low VARCHAR2,
x_segment29_high VARCHAR2,
x_segment30_low VARCHAR2,
x_segment30_high VARCHAR2,
x_chart_of_accounts_id NUMBER,
x_org_id NUMBER,
x_set_of_books_id NUMBER,
x_start_date DATE,
x_end_date DATE,
x_created_by NUMBER,
x_creation_date DATE,
x_last_updated_by NUMBER,
x_last_update_date DATE,
x_last_update_login NUMBER) IS
v_debug_info VARCHAR2(100);
SELECT ROWID
FROM GHG_org_account_mappings_all
WHERE account_mapping_id = x_facility_mapping_id;
v_debug_info := 'Inserting into GHG_org_account_mappings_all';
INSERT INTO GHG_ORG_ACCOUNT_MAPPINGS_all (account_mapping_id,
ghg_organization_id,
segment1_low,
segment1_high,
segment2_low,
segment2_high,
segment3_low,
segment3_high,
segment4_low,
segment4_high,
segment5_low,
segment5_high,
segment6_low,
segment6_high,
segment7_low,
segment7_high,
segment8_low,
segment8_high,
segment9_low,
segment9_high,
segment10_low,
segment10_high,
segment11_low,
segment11_high,
segment12_low,
segment12_high,
segment13_low,
segment13_high,
segment14_low,
segment14_high,
segment15_low,
segment15_high,
segment16_low,
segment16_high,
segment17_low,
segment17_high,
segment18_low,
segment18_high,
segment19_low,
segment19_high,
segment20_low,
segment20_high,
segment21_low,
segment21_high,
segment22_low,
segment22_high,
segment23_low,
segment23_high,
segment24_low,
segment24_high,
segment25_low,
segment25_high,
segment26_low,
segment26_high,
segment27_low,
segment27_high,
segment28_low,
segment28_high,
segment29_low,
segment29_high,
segment30_low,
segment30_high,
chart_of_accounts_id,
org_id,
set_of_books_id,
start_date,
end_date,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login)
VALUES (x_facility_mapping_id,
x_facility_id,
x_segment1_low,
x_segment1_high,
x_segment2_low,
x_segment2_high,
x_segment3_low,
x_segment3_high,
x_segment4_low,
x_segment4_high,
x_segment5_low,
x_segment5_high,
x_segment6_low,
x_segment6_high,
x_segment7_low,
x_segment7_high,
x_segment8_low,
x_segment8_high,
x_segment9_low,
x_segment9_high,
x_segment10_low,
x_segment10_high,
x_segment11_low,
x_segment11_high,
x_segment12_low,
x_segment12_high,
x_segment13_low,
x_segment13_high,
x_segment14_low,
x_segment14_high,
x_segment15_low,
x_segment15_high,
x_segment16_low,
x_segment16_high,
x_segment17_low,
x_segment17_high,
x_segment18_low,
x_segment18_high,
x_segment19_low,
x_segment19_high,
x_segment20_low,
x_segment20_high,
x_segment21_low,
x_segment21_high,
x_segment22_low,
x_segment22_high,
x_segment23_low,
x_segment23_high,
x_segment24_low,
x_segment24_high,
x_segment25_low,
x_segment25_high,
x_segment26_low,
x_segment26_high,
x_segment27_low,
x_segment27_high,
x_segment28_low,
x_segment28_high,
x_segment29_low,
x_segment29_high,
x_segment30_low,
x_segment30_high,
x_chart_of_accounts_id,
x_org_id,
x_set_of_books_id,
x_start_date,
x_end_date,
x_created_by,
x_creation_date,
x_last_updated_by,
x_last_update_date,
x_last_update_login);
END insert_row;
PROCEDURE update_row (x_rowid IN OUT NOCOPY VARCHAR2,
x_facility_mapping_id NUMBER,
x_facility_id NUMBER,
x_segment1_low VARCHAR2,
x_segment1_high VARCHAR2,
x_segment2_low VARCHAR2,
x_segment2_high VARCHAR2,
x_segment3_low VARCHAR2,
x_segment3_high VARCHAR2,
x_segment4_low VARCHAR2,
x_segment4_high VARCHAR2,
x_segment5_low VARCHAR2,
x_segment5_high VARCHAR2,
x_segment6_low VARCHAR2,
x_segment6_high VARCHAR2,
x_segment7_low VARCHAR2,
x_segment7_high VARCHAR2,
x_segment8_low VARCHAR2,
x_segment8_high VARCHAR2,
x_segment9_low VARCHAR2,
x_segment9_high VARCHAR2,
x_segment10_low VARCHAR2,
x_segment10_high VARCHAR2,
x_segment11_low VARCHAR2,
x_segment11_high VARCHAR2,
x_segment12_low VARCHAR2,
x_segment12_high VARCHAR2,
x_segment13_low VARCHAR2,
x_segment13_high VARCHAR2,
x_segment14_low VARCHAR2,
x_segment14_high VARCHAR2,
x_segment15_low VARCHAR2,
x_segment15_high VARCHAR2,
x_segment16_low VARCHAR2,
x_segment16_high VARCHAR2,
x_segment17_low VARCHAR2,
x_segment17_high VARCHAR2,
x_segment18_low VARCHAR2,
x_segment18_high VARCHAR2,
x_segment19_low VARCHAR2,
x_segment19_high VARCHAR2,
x_segment20_low VARCHAR2,
x_segment20_high VARCHAR2,
x_segment21_low VARCHAR2,
x_segment21_high VARCHAR2,
x_segment22_low VARCHAR2,
x_segment22_high VARCHAR2,
x_segment23_low VARCHAR2,
x_segment23_high VARCHAR2,
x_segment24_low VARCHAR2,
x_segment24_high VARCHAR2,
x_segment25_low VARCHAR2,
x_segment25_high VARCHAR2,
x_segment26_low VARCHAR2,
x_segment26_high VARCHAR2,
x_segment27_low VARCHAR2,
x_segment27_high VARCHAR2,
x_segment28_low VARCHAR2,
x_segment28_high VARCHAR2,
x_segment29_low VARCHAR2,
x_segment29_high VARCHAR2,
x_segment30_low VARCHAR2,
x_segment30_high VARCHAR2,
x_chart_of_accounts_id NUMBER,
x_org_id NUMBER,
x_set_of_books_id NUMBER,
x_start_date DATE,
x_end_date DATE,
x_created_by NUMBER,
x_creation_date DATE,
x_last_updated_by NUMBER,
x_last_update_date DATE,
x_last_update_login NUMBER) IS
v_debug_info VARCHAR2(100);
UPDATE GHG_org_account_mappings_all
SET account_mapping_id = x_facility_mapping_id,
ghg_organization_id = x_facility_id,
segment1_low = x_segment1_low,
segment1_high = x_segment1_low,
segment2_low = x_segment2_low,
segment2_high = x_segment2_low,
segment3_low = x_segment3_low,
segment3_high = x_segment3_low,
segment4_low = x_segment4_low,
segment4_high = x_segment4_low,
segment5_low = x_segment5_low,
segment5_high = x_segment5_low,
segment6_low = x_segment6_low,
segment6_high = x_segment6_low,
segment7_low = x_segment7_low,
segment7_high = x_segment7_low,
segment8_low = x_segment8_low,
segment8_high = x_segment8_low,
segment9_low = x_segment9_low,
segment9_high = x_segment9_low,
segment10_low = x_segment10_low,
segment10_high = x_segment10_low,
segment11_low = x_segment11_low,
segment11_high = x_segment11_low,
segment12_low = x_segment12_low,
segment12_high = x_segment12_low,
segment13_low = x_segment13_low,
segment13_high = x_segment13_low,
segment14_low = x_segment14_low,
segment14_high = x_segment14_low,
segment15_low = x_segment15_low,
segment15_high = x_segment15_low,
segment16_low = x_segment16_low,
segment16_high = x_segment16_low,
segment17_low = x_segment17_low,
segment17_high = x_segment17_low,
segment18_low = x_segment18_low,
segment18_high = x_segment18_low,
segment19_low = x_segment19_low,
segment19_high = x_segment19_low,
segment20_low = x_segment20_low,
segment20_high = x_segment20_low,
segment21_low = x_segment21_low,
segment21_high = x_segment21_low,
segment22_low = x_segment22_low,
segment22_high = x_segment22_low,
segment23_low = x_segment23_low,
segment23_high = x_segment23_low,
segment24_low = x_segment24_low,
segment24_high = x_segment24_low,
segment25_low = x_segment25_low,
segment25_high = x_segment25_low,
segment26_low = x_segment26_low,
segment26_high = x_segment26_low,
segment27_low = x_segment27_low,
segment27_high = x_segment27_low,
segment28_low = x_segment28_low,
segment28_high = x_segment28_low,
segment29_low = x_segment29_low,
segment29_high = x_segment29_low,
segment30_low = x_segment30_low,
segment30_high = x_segment30_low,
chart_of_accounts_id = x_chart_of_accounts_id,
org_id = x_org_id,
set_of_books_id = x_set_of_books_id,
start_date = x_start_date,
end_date = x_end_date,
created_by = x_created_by,
creation_date = x_creation_date,
last_updated_by = x_last_updated_by,
last_update_date = x_last_update_date,
last_update_login = x_last_update_login
WHERE rowid = x_rowid;
END update_row;
PROCEDURE delete_row (x_facility_mapping_id NUMBER) IS
v_row_count NUMBER(15);
DELETE FROM GHG_org_account_mappings_all
WHERE account_mapping_id = x_facility_mapping_id;
END delete_row;
x_last_updated_by NUMBER,
x_last_update_date DATE,
x_last_update_login NUMBER) IS
v_debug_info VARCHAR2(100);
SELECT account_mapping_id,
ghg_organization_id,
segment1_low,
segment1_high,
segment2_low,
segment2_high,
segment3_low,
segment3_high,
segment4_low,
segment4_high,
segment5_low,
segment5_high,
segment6_low,
segment6_high,
segment7_low,
segment7_high,
segment8_low,
segment8_high,
segment9_low,
segment9_high,
segment10_low,
segment10_high,
segment11_low,
segment11_high,
segment12_low,
segment12_high,
segment13_low,
segment13_high,
segment14_low,
segment14_high,
segment15_low,
segment15_high,
segment16_low,
segment16_high,
segment17_low,
segment17_high,
segment18_low,
segment18_high,
segment19_low,
segment19_high,
segment20_low,
segment20_high,
segment21_low,
segment21_high,
segment22_low,
segment22_high,
segment23_low,
segment23_high,
segment24_low,
segment24_high,
segment25_low,
segment25_high,
segment26_low,
segment26_high,
segment27_low,
segment27_high,
segment28_low,
segment28_high,
segment29_low,
segment29_high,
segment30_low,
segment30_high,
chart_of_accounts_id,
org_id,
set_of_books_id,
start_date,
end_date,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login
FROM GHG_org_account_mappings_all
WHERE rowid = x_rowid
FOR UPDATE of account_mapping_id NOWAIT;
AND ((recinfo.last_updated_by = x_last_updated_by) OR (recinfo.last_updated_by IS NULL AND x_last_updated_by IS NULL))
AND ((recinfo.last_update_date = x_last_update_date) OR (recinfo.last_update_date IS NULL AND x_last_update_date IS NULL))
AND ((recinfo.last_update_login = x_last_update_login) OR (recinfo.last_update_login IS NULL AND x_last_update_login IS NULL)) ) THEN
NULL;
SELECT application_column_name
FROM fnd_id_flex_segments_vl
WHERE id_flex_num = v_chart_of_accounts_id
AND id_flex_code = 'GL#'
ORDER BY segment_num;
SELECT chart_of_accounts_id
INTO v_chart_of_acc_id
FROM ghg_org_account_mappings_all
WHERE account_mapping_id = v_facility_mapping_id;
v_sqltext := 'SELECT count(*) FROM gl_code_combinations gc, ap_invoice_distributions_all ai, ghg_transactions_all gt, ghg_org_account_mappings_all ga ';