[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_row (x_rowid IN OUT NOCOPY VARCHAR2,
x_map_accounts_flag VARCHAR2,
x_map_operating_unit_flag VARCHAR2,
x_map_projects_flag VARCHAR2,
x_map_segment1_flag VARCHAR2,
x_map_segment2_flag VARCHAR2,
x_map_segment3_flag VARCHAR2,
x_map_segment4_flag VARCHAR2,
x_map_segment5_flag VARCHAR2,
x_map_segment6_flag VARCHAR2,
x_map_segment7_flag VARCHAR2,
x_map_segment8_flag VARCHAR2,
x_map_segment9_flag VARCHAR2,
x_map_segment10_flag VARCHAR2,
x_map_segment11_flag VARCHAR2,
x_map_segment12_flag VARCHAR2,
x_map_segment13_flag VARCHAR2,
x_map_segment14_flag VARCHAR2,
x_map_segment15_flag VARCHAR2,
x_map_segment16_flag VARCHAR2,
x_map_segment17_flag VARCHAR2,
x_map_segment18_flag VARCHAR2,
x_map_segment19_flag VARCHAR2,
x_map_segment20_flag VARCHAR2,
x_map_segment21_flag VARCHAR2,
x_map_segment22_flag VARCHAR2,
x_map_segment23_flag VARCHAR2,
x_map_segment24_flag VARCHAR2,
x_map_segment25_flag VARCHAR2,
x_map_segment26_flag VARCHAR2,
x_map_segment27_flag VARCHAR2,
x_map_segment28_flag VARCHAR2,
x_map_segment29_flag VARCHAR2,
x_map_segment30_flag VARCHAR2,
x_org_id NUMBER,
x_set_of_books_id NUMBER,
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_SEGMENT_MAPPINGS_ALL
WHERE org_id = x_org_id;
v_debug_info := 'Inserting into GHG_SEGMENT_MAPPINGS_ALL';
INSERT INTO GHG_SEGMENT_MAPPINGS_ALL (map_accounts_flag,
map_operating_unit_flag,
map_projects_flag,
map_segment1_flag,
map_segment2_flag,
map_segment3_flag,
map_segment4_flag,
map_segment5_flag,
map_segment6_flag,
map_segment7_flag,
map_segment8_flag,
map_segment9_flag,
map_segment10_flag,
map_segment11_flag,
map_segment12_flag,
map_segment13_flag,
map_segment14_flag,
map_segment15_flag,
map_segment16_flag,
map_segment17_flag,
map_segment18_flag,
map_segment19_flag,
map_segment20_flag,
map_segment21_flag,
map_segment22_flag,
map_segment23_flag,
map_segment24_flag,
map_segment25_flag,
map_segment26_flag,
map_segment27_flag,
map_segment28_flag,
map_segment29_flag,
map_segment30_flag,
org_id,
set_of_books_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login)
VALUES (x_map_accounts_flag,
x_map_operating_unit_flag,
x_map_projects_flag,
x_map_segment1_flag,
x_map_segment2_flag,
x_map_segment3_flag,
x_map_segment4_flag,
x_map_segment5_flag,
x_map_segment6_flag,
x_map_segment7_flag,
x_map_segment8_flag,
x_map_segment9_flag,
x_map_segment10_flag,
x_map_segment11_flag,
x_map_segment12_flag,
x_map_segment13_flag,
x_map_segment14_flag,
x_map_segment15_flag,
x_map_segment16_flag,
x_map_segment17_flag,
x_map_segment18_flag,
x_map_segment19_flag,
x_map_segment20_flag,
x_map_segment21_flag,
x_map_segment22_flag,
x_map_segment23_flag,
x_map_segment24_flag,
x_map_segment25_flag,
x_map_segment26_flag,
x_map_segment27_flag,
x_map_segment28_flag,
x_map_segment29_flag,
x_map_segment30_flag,
x_org_id,
x_set_of_books_id,
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_map_accounts_flag VARCHAR2,
x_map_operating_unit_flag VARCHAR2,
x_map_projects_flag VARCHAR2,
x_map_segment1_flag VARCHAR2,
x_map_segment2_flag VARCHAR2,
x_map_segment3_flag VARCHAR2,
x_map_segment4_flag VARCHAR2,
x_map_segment5_flag VARCHAR2,
x_map_segment6_flag VARCHAR2,
x_map_segment7_flag VARCHAR2,
x_map_segment8_flag VARCHAR2,
x_map_segment9_flag VARCHAR2,
x_map_segment10_flag VARCHAR2,
x_map_segment11_flag VARCHAR2,
x_map_segment12_flag VARCHAR2,
x_map_segment13_flag VARCHAR2,
x_map_segment14_flag VARCHAR2,
x_map_segment15_flag VARCHAR2,
x_map_segment16_flag VARCHAR2,
x_map_segment17_flag VARCHAR2,
x_map_segment18_flag VARCHAR2,
x_map_segment19_flag VARCHAR2,
x_map_segment20_flag VARCHAR2,
x_map_segment21_flag VARCHAR2,
x_map_segment22_flag VARCHAR2,
x_map_segment23_flag VARCHAR2,
x_map_segment24_flag VARCHAR2,
x_map_segment25_flag VARCHAR2,
x_map_segment26_flag VARCHAR2,
x_map_segment27_flag VARCHAR2,
x_map_segment28_flag VARCHAR2,
x_map_segment29_flag VARCHAR2,
x_map_segment30_flag VARCHAR2,
x_org_id NUMBER,
x_set_of_books_id NUMBER, -- added 13-Mar-09 for R12
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_SEGMENT_MAPPINGS_ALL
SET map_accounts_flag = x_map_accounts_flag,
map_operating_unit_flag = x_map_operating_unit_flag,
map_projects_flag = x_map_projects_flag,
map_segment1_flag = x_map_segment1_flag,
map_segment2_flag = x_map_segment2_flag,
map_segment3_flag = x_map_segment3_flag,
map_segment4_flag = x_map_segment4_flag,
map_segment5_flag = x_map_segment5_flag,
map_segment6_flag = x_map_segment6_flag,
map_segment7_flag = x_map_segment7_flag,
map_segment8_flag = x_map_segment8_flag,
map_segment9_flag = x_map_segment9_flag,
map_segment10_flag = x_map_segment10_flag,
map_segment11_flag = x_map_segment11_flag,
map_segment12_flag = x_map_segment12_flag,
map_segment13_flag = x_map_segment13_flag,
map_segment14_flag = x_map_segment14_flag,
map_segment15_flag = x_map_segment15_flag,
map_segment16_flag = x_map_segment16_flag,
map_segment17_flag = x_map_segment17_flag,
map_segment18_flag = x_map_segment18_flag,
map_segment19_flag = x_map_segment19_flag,
map_segment20_flag = x_map_segment20_flag,
map_segment21_flag = x_map_segment21_flag,
map_segment22_flag = x_map_segment22_flag,
map_segment23_flag = x_map_segment23_flag,
map_segment24_flag = x_map_segment24_flag,
map_segment25_flag = x_map_segment25_flag,
map_segment26_flag = x_map_segment26_flag,
map_segment27_flag = x_map_segment27_flag,
map_segment28_flag = x_map_segment28_flag,
map_segment29_flag = x_map_segment29_flag,
map_segment30_flag = x_map_segment30_flag,
org_id = x_org_id,
set_of_books_id = x_set_of_books_id,
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_org_id NUMBER) IS
v_row_count NUMBER(15);
DELETE FROM GHG_SEGMENT_MAPPINGS_ALL
WHERE org_id = x_org_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 map_accounts_flag,
map_operating_unit_flag,
map_projects_flag,
map_segment1_flag,
map_segment2_flag,
map_segment3_flag,
map_segment4_flag,
map_segment5_flag,
map_segment6_flag,
map_segment7_flag,
map_segment8_flag,
map_segment9_flag,
map_segment10_flag,
map_segment11_flag,
map_segment12_flag,
map_segment13_flag,
map_segment14_flag,
map_segment15_flag,
map_segment16_flag,
map_segment17_flag,
map_segment18_flag,
map_segment19_flag,
map_segment20_flag,
map_segment21_flag,
map_segment22_flag,
map_segment23_flag,
map_segment24_flag,
map_segment25_flag,
map_segment26_flag,
map_segment27_flag,
map_segment28_flag,
map_segment29_flag,
map_segment30_flag,
org_id,
set_of_books_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login
FROM GHG_SEGMENT_MAPPINGS_ALL
WHERE rowid = x_rowid
FOR UPDATE of org_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;