The following lines contain the word 'select', 'insert', 'update' or 'delete':
x_last_update_date IN DATE ,
x_last_updated_by IN NUMBER ,
x_last_update_login IN NUMBER
) AS
/*
|| Created By : [email protected]
|| Created On : 18-APR-2002
|| Purpose : Initialises the Old and New references for the columns of the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
*/
CURSOR cur_old_ref_values IS
SELECT *
FROM igi_dos_sources
WHERE rowid = x_rowid;
IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
CLOSE cur_old_ref_values;
fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
IF (p_action = 'UPDATE') THEN
new_references.creation_date := old_references.creation_date;
new_references.last_update_date := x_last_update_date;
new_references.last_updated_by := x_last_updated_by;
new_references.last_update_login := x_last_update_login;
fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
SELECT rowid
FROM igi_dos_sources
WHERE source_id = x_source_id
FOR UPDATE NOWAIT;
SELECT rowid
FROM igi_dos_sources
WHERE ((dossier_id = x_dossier_id));
fnd_message.set_name ('FND', 'FND-CANNOT DELETE MASTER');
x_last_update_date IN DATE ,
x_last_updated_by IN NUMBER ,
x_last_update_login IN NUMBER
) AS
/*
|| Created By : [email protected]
|| Created On : 18-APR-2002
|| Purpose : Initialises the columns, Checks Constraints, Calls the
|| Trigger Handlers for the table, before any DML operation.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
*/
BEGIN
set_column_values (
p_action,
x_rowid,
x_dossier_id,
x_source_id,
x_sob_id,
x_coa_id,
x_segment25_low,
x_budget,
x_line_num,
x_budget_entity_id,
x_budget_entity_name,
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_high,
x_segment7_low,
x_segment8_high,
x_segment8_low,
x_segment9_high,
x_segment9_low,
x_segment10_high,
x_segment10_low,
x_segment11_high,
x_segment11_low,
x_segment12_high,
x_segment12_low,
x_segment13_high,
x_segment13_low,
x_segment14_high,
x_segment14_low,
x_segment15_high,
x_segment15_low,
x_segment16_high,
x_segment16_low,
x_segment17_high,
x_segment17_low,
x_segment18_high,
x_segment18_low,
x_segment19_high,
x_segment19_low,
x_segment20_high,
x_segment20_low,
x_segment21_high,
x_segment21_low,
x_segment22_high,
x_segment22_low,
x_segment23_high,
x_segment23_low,
x_segment24_high,
x_segment24_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_segments_low_ccid,
x_segments_high_ccid,
x_segments_low_ccid_desc,
x_segments_high_ccid_desc,
x_budget_version_id,
x_period_name,
x_creation_date,
x_created_by,
x_last_update_date,
x_last_updated_by,
x_last_update_login
);
IF (p_action = 'INSERT') THEN
-- Call all the procedures related to Before Insert.
IF ( get_pk_for_validation(
new_references.source_id
)
) THEN
fnd_message.set_name('FND','FORM_DUPLICATE_KEY_IN_INDEX');
ELSIF (p_action = 'UPDATE') THEN
-- Call all the procedures related to Before Update.
check_parent_existance;
ELSIF (p_action = 'DELETE') THEN
-- Call all the procedures related to Before Delete.
check_child_existance;
ELSIF (p_action = 'VALIDATE_INSERT') THEN
-- Call all the procedures related to Before Insert.
IF ( get_pk_for_validation (
new_references.source_id
)
) THEN
fnd_message.set_name('FND','FORM_DUPLICATE_KEY_IN_INDEX');
ELSIF (p_action = 'VALIDATE_DELETE') THEN
check_child_existance;
PROCEDURE insert_row (
x_rowid IN OUT NOCOPY VARCHAR2,
x_dossier_id IN NUMBER,
x_source_id IN OUT NOCOPY NUMBER,
x_sob_id IN NUMBER,
x_coa_id IN NUMBER,
x_segment25_low IN VARCHAR2,
x_budget IN VARCHAR2,
x_line_num IN NUMBER,
x_budget_entity_id IN NUMBER,
x_budget_entity_name IN VARCHAR2,
x_segment1_low IN VARCHAR2,
x_segment1_high IN VARCHAR2,
x_segment2_low IN VARCHAR2,
x_segment2_high IN VARCHAR2,
x_segment3_low IN VARCHAR2,
x_segment3_high IN VARCHAR2,
x_segment4_low IN VARCHAR2,
x_segment4_high IN VARCHAR2,
x_segment5_low IN VARCHAR2,
x_segment5_high IN VARCHAR2,
x_segment6_low IN VARCHAR2,
x_segment6_high IN VARCHAR2,
x_segment7_high IN VARCHAR2,
x_segment7_low IN VARCHAR2,
x_segment8_high IN VARCHAR2,
x_segment8_low IN VARCHAR2,
x_segment9_high IN VARCHAR2,
x_segment9_low IN VARCHAR2,
x_segment10_high IN VARCHAR2,
x_segment10_low IN VARCHAR2,
x_segment11_high IN VARCHAR2,
x_segment11_low IN VARCHAR2,
x_segment12_high IN VARCHAR2,
x_segment12_low IN VARCHAR2,
x_segment13_high IN VARCHAR2,
x_segment13_low IN VARCHAR2,
x_segment14_high IN VARCHAR2,
x_segment14_low IN VARCHAR2,
x_segment15_high IN VARCHAR2,
x_segment15_low IN VARCHAR2,
x_segment16_high IN VARCHAR2,
x_segment16_low IN VARCHAR2,
x_segment17_high IN VARCHAR2,
x_segment17_low IN VARCHAR2,
x_segment18_high IN VARCHAR2,
x_segment18_low IN VARCHAR2,
x_segment19_high IN VARCHAR2,
x_segment19_low IN VARCHAR2,
x_segment20_high IN VARCHAR2,
x_segment20_low IN VARCHAR2,
x_segment21_high IN VARCHAR2,
x_segment21_low IN VARCHAR2,
x_segment22_high IN VARCHAR2,
x_segment22_low IN VARCHAR2,
x_segment23_high IN VARCHAR2,
x_segment23_low IN VARCHAR2,
x_segment24_high IN VARCHAR2,
x_segment24_low IN VARCHAR2,
x_segment25_high IN VARCHAR2,
x_segment26_low IN VARCHAR2,
x_segment26_high IN VARCHAR2,
x_segment27_low IN VARCHAR2,
x_segment27_high IN VARCHAR2,
x_segment28_low IN VARCHAR2,
x_segment28_high IN VARCHAR2,
x_segment29_low IN VARCHAR2,
x_segment29_high IN VARCHAR2,
x_segment30_low IN VARCHAR2,
x_segment30_high IN VARCHAR2,
x_segments_low_ccid IN NUMBER,
x_segments_high_ccid IN NUMBER,
x_segments_low_ccid_desc IN VARCHAR2,
x_segments_high_ccid_desc IN VARCHAR2,
x_budget_version_id IN NUMBER,
x_period_name IN VARCHAR2,
x_mode IN VARCHAR2 ) AS
/*
|| Created By : [email protected]
|| Created On : 18-APR-2002
|| Purpose : Handles the INSERT DML logic for the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
*/
CURSOR c IS
SELECT rowid
FROM igi_dos_sources
WHERE source_id = x_source_id;
x_last_update_date DATE;
x_last_updated_by NUMBER;
x_last_update_login NUMBER;
x_last_update_date := SYSDATE;
x_last_updated_by := 1;
x_last_update_login := 0;
x_last_updated_by := fnd_global.user_id;
IF (x_last_updated_by IS NULL) THEN
x_last_updated_by := -1;
x_last_update_login := fnd_global.login_id;
IF (x_last_update_login IS NULL) THEN
x_last_update_login := -1;
FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_sources_pkg.insert_row.Msg1',FALSE);
SELECT igi_dos_sources_s.NEXTVAL
INTO x_source_id
FROM dual;
p_action => 'INSERT',
x_rowid => x_rowid,
x_dossier_id => x_dossier_id,
x_source_id => x_source_id,
x_sob_id => x_sob_id,
x_coa_id => x_coa_id,
x_segment25_low => x_segment25_low,
x_budget => x_budget,
x_line_num => x_line_num,
x_budget_entity_id => x_budget_entity_id,
x_budget_entity_name => x_budget_entity_name,
x_segment1_low => x_segment1_low,
x_segment1_high => x_segment1_high,
x_segment2_low => x_segment2_low,
x_segment2_high => x_segment2_high,
x_segment3_low => x_segment3_low,
x_segment3_high => x_segment3_high,
x_segment4_low => x_segment4_low,
x_segment4_high => x_segment4_high,
x_segment5_low => x_segment5_low,
x_segment5_high => x_segment5_high,
x_segment6_low => x_segment6_low,
x_segment6_high => x_segment6_high,
x_segment7_high => x_segment7_high,
x_segment7_low => x_segment7_low,
x_segment8_high => x_segment8_high,
x_segment8_low => x_segment8_low,
x_segment9_high => x_segment9_high,
x_segment9_low => x_segment9_low,
x_segment10_high => x_segment10_high,
x_segment10_low => x_segment10_low,
x_segment11_high => x_segment11_high,
x_segment11_low => x_segment11_low,
x_segment12_high => x_segment12_high,
x_segment12_low => x_segment12_low,
x_segment13_high => x_segment13_high,
x_segment13_low => x_segment13_low,
x_segment14_high => x_segment14_high,
x_segment14_low => x_segment14_low,
x_segment15_high => x_segment15_high,
x_segment15_low => x_segment15_low,
x_segment16_high => x_segment16_high,
x_segment16_low => x_segment16_low,
x_segment17_high => x_segment17_high,
x_segment17_low => x_segment17_low,
x_segment18_high => x_segment18_high,
x_segment18_low => x_segment18_low,
x_segment19_high => x_segment19_high,
x_segment19_low => x_segment19_low,
x_segment20_high => x_segment20_high,
x_segment20_low => x_segment20_low,
x_segment21_high => x_segment21_high,
x_segment21_low => x_segment21_low,
x_segment22_high => x_segment22_high,
x_segment22_low => x_segment22_low,
x_segment23_high => x_segment23_high,
x_segment23_low => x_segment23_low,
x_segment24_high => x_segment24_high,
x_segment24_low => x_segment24_low,
x_segment25_high => x_segment25_high,
x_segment26_low => x_segment26_low,
x_segment26_high => x_segment26_high,
x_segment27_low => x_segment27_low,
x_segment27_high => x_segment27_high,
x_segment28_low => x_segment28_low,
x_segment28_high => x_segment28_high,
x_segment29_low => x_segment29_low,
x_segment29_high => x_segment29_high,
x_segment30_low => x_segment30_low,
x_segment30_high => x_segment30_high,
x_segments_low_ccid => x_segments_low_ccid,
x_segments_high_ccid => x_segments_high_ccid,
x_segments_low_ccid_desc => x_segments_low_ccid_desc,
x_segments_high_ccid_desc => x_segments_high_ccid_desc,
x_budget_version_id => x_budget_version_id,
x_period_name => x_period_name,
x_creation_date => x_last_update_date,
x_created_by => x_last_updated_by,
x_last_update_date => x_last_update_date,
x_last_updated_by => x_last_updated_by,
x_last_update_login => x_last_update_login
);
INSERT INTO igi_dos_sources (
dossier_id,
source_id,
sob_id,
coa_id,
segment25_low,
budget,
line_num,
budget_entity_id,
budget_entity_name,
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_high,
segment7_low,
segment8_high,
segment8_low,
segment9_high,
segment9_low,
segment10_high,
segment10_low,
segment11_high,
segment11_low,
segment12_high,
segment12_low,
segment13_high,
segment13_low,
segment14_high,
segment14_low,
segment15_high,
segment15_low,
segment16_high,
segment16_low,
segment17_high,
segment17_low,
segment18_high,
segment18_low,
segment19_high,
segment19_low,
segment20_high,
segment20_low,
segment21_high,
segment21_low,
segment22_high,
segment22_low,
segment23_high,
segment23_low,
segment24_high,
segment24_low,
segment25_high,
segment26_low,
segment26_high,
segment27_low,
segment27_high,
segment28_low,
segment28_high,
segment29_low,
segment29_high,
segment30_low,
segment30_high,
segments_low_ccid,
segments_high_ccid,
segments_low_ccid_desc,
segments_high_ccid_desc,
budget_version_id,
period_name,
creation_date,
created_by,
last_update_date,
last_updated_by,
last_update_login
) VALUES (
new_references.dossier_id,
new_references.source_id,
new_references.sob_id,
new_references.coa_id,
new_references.segment25_low,
new_references.budget,
new_references.line_num,
new_references.budget_entity_id,
new_references.budget_entity_name,
new_references.segment1_low,
new_references.segment1_high,
new_references.segment2_low,
new_references.segment2_high,
new_references.segment3_low,
new_references.segment3_high,
new_references.segment4_low,
new_references.segment4_high,
new_references.segment5_low,
new_references.segment5_high,
new_references.segment6_low,
new_references.segment6_high,
new_references.segment7_high,
new_references.segment7_low,
new_references.segment8_high,
new_references.segment8_low,
new_references.segment9_high,
new_references.segment9_low,
new_references.segment10_high,
new_references.segment10_low,
new_references.segment11_high,
new_references.segment11_low,
new_references.segment12_high,
new_references.segment12_low,
new_references.segment13_high,
new_references.segment13_low,
new_references.segment14_high,
new_references.segment14_low,
new_references.segment15_high,
new_references.segment15_low,
new_references.segment16_high,
new_references.segment16_low,
new_references.segment17_high,
new_references.segment17_low,
new_references.segment18_high,
new_references.segment18_low,
new_references.segment19_high,
new_references.segment19_low,
new_references.segment20_high,
new_references.segment20_low,
new_references.segment21_high,
new_references.segment21_low,
new_references.segment22_high,
new_references.segment22_low,
new_references.segment23_high,
new_references.segment23_low,
new_references.segment24_high,
new_references.segment24_low,
new_references.segment25_high,
new_references.segment26_low,
new_references.segment26_high,
new_references.segment27_low,
new_references.segment27_high,
new_references.segment28_low,
new_references.segment28_high,
new_references.segment29_low,
new_references.segment29_high,
new_references.segment30_low,
new_references.segment30_high,
new_references.segments_low_ccid,
new_references.segments_high_ccid,
new_references.segments_low_ccid_desc,
new_references.segments_high_ccid_desc,
new_references.budget_version_id,
new_references.period_name,
x_last_update_date,
x_last_updated_by,
x_last_update_date,
x_last_updated_by,
x_last_update_login
);
END insert_row;
SELECT
dossier_id,
sob_id,
coa_id,
segment25_low,
budget,
line_num,
budget_entity_id,
budget_entity_name,
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_high,
segment7_low,
segment8_high,
segment8_low,
segment9_high,
segment9_low,
segment10_high,
segment10_low,
segment11_high,
segment11_low,
segment12_high,
segment12_low,
segment13_high,
segment13_low,
segment14_high,
segment14_low,
segment15_high,
segment15_low,
segment16_high,
segment16_low,
segment17_high,
segment17_low,
segment18_high,
segment18_low,
segment19_high,
segment19_low,
segment20_high,
segment20_low,
segment21_high,
segment21_low,
segment22_high,
segment22_low,
segment23_high,
segment23_low,
segment24_high,
segment24_low,
segment25_high,
segment26_low,
segment26_high,
segment27_low,
segment27_high,
segment28_low,
segment28_high,
segment29_low,
segment29_high,
segment30_low,
segment30_high,
segments_low_ccid,
segments_high_ccid,
segments_low_ccid_desc,
segments_high_ccid_desc,
budget_version_id,
period_name
FROM igi_dos_sources
WHERE rowid = x_rowid
FOR UPDATE NOWAIT;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
PROCEDURE update_row (
x_rowid IN VARCHAR2,
x_dossier_id IN NUMBER,
x_source_id IN NUMBER,
x_sob_id IN NUMBER,
x_coa_id IN NUMBER,
x_segment25_low IN VARCHAR2,
x_budget IN VARCHAR2,
x_line_num IN NUMBER,
x_budget_entity_id IN NUMBER,
x_budget_entity_name IN VARCHAR2,
x_segment1_low IN VARCHAR2,
x_segment1_high IN VARCHAR2,
x_segment2_low IN VARCHAR2,
x_segment2_high IN VARCHAR2,
x_segment3_low IN VARCHAR2,
x_segment3_high IN VARCHAR2,
x_segment4_low IN VARCHAR2,
x_segment4_high IN VARCHAR2,
x_segment5_low IN VARCHAR2,
x_segment5_high IN VARCHAR2,
x_segment6_low IN VARCHAR2,
x_segment6_high IN VARCHAR2,
x_segment7_high IN VARCHAR2,
x_segment7_low IN VARCHAR2,
x_segment8_high IN VARCHAR2,
x_segment8_low IN VARCHAR2,
x_segment9_high IN VARCHAR2,
x_segment9_low IN VARCHAR2,
x_segment10_high IN VARCHAR2,
x_segment10_low IN VARCHAR2,
x_segment11_high IN VARCHAR2,
x_segment11_low IN VARCHAR2,
x_segment12_high IN VARCHAR2,
x_segment12_low IN VARCHAR2,
x_segment13_high IN VARCHAR2,
x_segment13_low IN VARCHAR2,
x_segment14_high IN VARCHAR2,
x_segment14_low IN VARCHAR2,
x_segment15_high IN VARCHAR2,
x_segment15_low IN VARCHAR2,
x_segment16_high IN VARCHAR2,
x_segment16_low IN VARCHAR2,
x_segment17_high IN VARCHAR2,
x_segment17_low IN VARCHAR2,
x_segment18_high IN VARCHAR2,
x_segment18_low IN VARCHAR2,
x_segment19_high IN VARCHAR2,
x_segment19_low IN VARCHAR2,
x_segment20_high IN VARCHAR2,
x_segment20_low IN VARCHAR2,
x_segment21_high IN VARCHAR2,
x_segment21_low IN VARCHAR2,
x_segment22_high IN VARCHAR2,
x_segment22_low IN VARCHAR2,
x_segment23_high IN VARCHAR2,
x_segment23_low IN VARCHAR2,
x_segment24_high IN VARCHAR2,
x_segment24_low IN VARCHAR2,
x_segment25_high IN VARCHAR2,
x_segment26_low IN VARCHAR2,
x_segment26_high IN VARCHAR2,
x_segment27_low IN VARCHAR2,
x_segment27_high IN VARCHAR2,
x_segment28_low IN VARCHAR2,
x_segment28_high IN VARCHAR2,
x_segment29_low IN VARCHAR2,
x_segment29_high IN VARCHAR2,
x_segment30_low IN VARCHAR2,
x_segment30_high IN VARCHAR2,
x_segments_low_ccid IN NUMBER,
x_segments_high_ccid IN NUMBER,
x_segments_low_ccid_desc IN VARCHAR2,
x_segments_high_ccid_desc IN VARCHAR2,
x_budget_version_id IN NUMBER,
x_period_name IN VARCHAR2,
x_mode IN VARCHAR2 ) AS
/*
|| Created By : [email protected]
|| Created On : 18-APR-2002
|| Purpose : Handles the UPDATE DML logic for the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
*/
x_last_update_date DATE ;
x_last_updated_by NUMBER;
x_last_update_login NUMBER;
x_last_update_date := SYSDATE;
x_last_updated_by := 1;
x_last_update_login := 0;
x_last_updated_by := fnd_global.user_id;
IF x_last_updated_by IS NULL THEN
x_last_updated_by := -1;
x_last_update_login := fnd_global.login_id;
IF (x_last_update_login IS NULL) THEN
x_last_update_login := -1;
FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_sources_pkg.update_row.Msg1',FALSE);
p_action => 'UPDATE',
x_rowid => x_rowid,
x_dossier_id => x_dossier_id,
x_source_id => x_source_id,
x_sob_id => x_sob_id,
x_coa_id => x_coa_id,
x_segment25_low => x_segment25_low,
x_budget => x_budget,
x_line_num => x_line_num,
x_budget_entity_id => x_budget_entity_id,
x_budget_entity_name => x_budget_entity_name,
x_segment1_low => x_segment1_low,
x_segment1_high => x_segment1_high,
x_segment2_low => x_segment2_low,
x_segment2_high => x_segment2_high,
x_segment3_low => x_segment3_low,
x_segment3_high => x_segment3_high,
x_segment4_low => x_segment4_low,
x_segment4_high => x_segment4_high,
x_segment5_low => x_segment5_low,
x_segment5_high => x_segment5_high,
x_segment6_low => x_segment6_low,
x_segment6_high => x_segment6_high,
x_segment7_high => x_segment7_high,
x_segment7_low => x_segment7_low,
x_segment8_high => x_segment8_high,
x_segment8_low => x_segment8_low,
x_segment9_high => x_segment9_high,
x_segment9_low => x_segment9_low,
x_segment10_high => x_segment10_high,
x_segment10_low => x_segment10_low,
x_segment11_high => x_segment11_high,
x_segment11_low => x_segment11_low,
x_segment12_high => x_segment12_high,
x_segment12_low => x_segment12_low,
x_segment13_high => x_segment13_high,
x_segment13_low => x_segment13_low,
x_segment14_high => x_segment14_high,
x_segment14_low => x_segment14_low,
x_segment15_high => x_segment15_high,
x_segment15_low => x_segment15_low,
x_segment16_high => x_segment16_high,
x_segment16_low => x_segment16_low,
x_segment17_high => x_segment17_high,
x_segment17_low => x_segment17_low,
x_segment18_high => x_segment18_high,
x_segment18_low => x_segment18_low,
x_segment19_high => x_segment19_high,
x_segment19_low => x_segment19_low,
x_segment20_high => x_segment20_high,
x_segment20_low => x_segment20_low,
x_segment21_high => x_segment21_high,
x_segment21_low => x_segment21_low,
x_segment22_high => x_segment22_high,
x_segment22_low => x_segment22_low,
x_segment23_high => x_segment23_high,
x_segment23_low => x_segment23_low,
x_segment24_high => x_segment24_high,
x_segment24_low => x_segment24_low,
x_segment25_high => x_segment25_high,
x_segment26_low => x_segment26_low,
x_segment26_high => x_segment26_high,
x_segment27_low => x_segment27_low,
x_segment27_high => x_segment27_high,
x_segment28_low => x_segment28_low,
x_segment28_high => x_segment28_high,
x_segment29_low => x_segment29_low,
x_segment29_high => x_segment29_high,
x_segment30_low => x_segment30_low,
x_segment30_high => x_segment30_high,
x_segments_low_ccid => x_segments_low_ccid,
x_segments_high_ccid => x_segments_high_ccid,
x_segments_low_ccid_desc => x_segments_low_ccid_desc,
x_segments_high_ccid_desc => x_segments_high_ccid_desc,
x_budget_version_id => x_budget_version_id,
x_period_name => x_period_name,
x_creation_date => x_last_update_date,
x_created_by => x_last_updated_by,
x_last_update_date => x_last_update_date,
x_last_updated_by => x_last_updated_by,
x_last_update_login => x_last_update_login
);
UPDATE igi_dos_sources
SET
dossier_id = new_references.dossier_id,
sob_id = new_references.sob_id,
coa_id = new_references.coa_id,
segment25_low = new_references.segment25_low,
budget = new_references.budget,
line_num = new_references.line_num,
budget_entity_id = new_references.budget_entity_id,
budget_entity_name = new_references.budget_entity_name,
segment1_low = new_references.segment1_low,
segment1_high = new_references.segment1_high,
segment2_low = new_references.segment2_low,
segment2_high = new_references.segment2_high,
segment3_low = new_references.segment3_low,
segment3_high = new_references.segment3_high,
segment4_low = new_references.segment4_low,
segment4_high = new_references.segment4_high,
segment5_low = new_references.segment5_low,
segment5_high = new_references.segment5_high,
segment6_low = new_references.segment6_low,
segment6_high = new_references.segment6_high,
segment7_high = new_references.segment7_high,
segment7_low = new_references.segment7_low,
segment8_high = new_references.segment8_high,
segment8_low = new_references.segment8_low,
segment9_high = new_references.segment9_high,
segment9_low = new_references.segment9_low,
segment10_high = new_references.segment10_high,
segment10_low = new_references.segment10_low,
segment11_high = new_references.segment11_high,
segment11_low = new_references.segment11_low,
segment12_high = new_references.segment12_high,
segment12_low = new_references.segment12_low,
segment13_high = new_references.segment13_high,
segment13_low = new_references.segment13_low,
segment14_high = new_references.segment14_high,
segment14_low = new_references.segment14_low,
segment15_high = new_references.segment15_high,
segment15_low = new_references.segment15_low,
segment16_high = new_references.segment16_high,
segment16_low = new_references.segment16_low,
segment17_high = new_references.segment17_high,
segment17_low = new_references.segment17_low,
segment18_high = new_references.segment18_high,
segment18_low = new_references.segment18_low,
segment19_high = new_references.segment19_high,
segment19_low = new_references.segment19_low,
segment20_high = new_references.segment20_high,
segment20_low = new_references.segment20_low,
segment21_high = new_references.segment21_high,
segment21_low = new_references.segment21_low,
segment22_high = new_references.segment22_high,
segment22_low = new_references.segment22_low,
segment23_high = new_references.segment23_high,
segment23_low = new_references.segment23_low,
segment24_high = new_references.segment24_high,
segment24_low = new_references.segment24_low,
segment25_high = new_references.segment25_high,
segment26_low = new_references.segment26_low,
segment26_high = new_references.segment26_high,
segment27_low = new_references.segment27_low,
segment27_high = new_references.segment27_high,
segment28_low = new_references.segment28_low,
segment28_high = new_references.segment28_high,
segment29_low = new_references.segment29_low,
segment29_high = new_references.segment29_high,
segment30_low = new_references.segment30_low,
segment30_high = new_references.segment30_high,
segments_low_ccid = new_references.segments_low_ccid,
segments_high_ccid = new_references.segments_high_ccid,
segments_low_ccid_desc = new_references.segments_low_ccid_desc,
segments_high_ccid_desc = new_references.segments_high_ccid_desc,
budget_version_id = new_references.budget_version_id,
period_name = new_references.period_name,
last_update_date = x_last_update_date,
last_updated_by = x_last_updated_by,
last_update_login = x_last_update_login
WHERE rowid = x_rowid;
END update_row;
|| Purpose : Adds a row if there is no existing row, otherwise updates existing row in the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
*/
CURSOR c1 IS
SELECT rowid
FROM igi_dos_sources
WHERE source_id = x_source_id;
insert_row (
x_rowid,
x_dossier_id,
x_source_id,
x_sob_id,
x_coa_id,
x_segment25_low,
x_budget,
x_line_num,
x_budget_entity_id,
x_budget_entity_name,
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_high,
x_segment7_low,
x_segment8_high,
x_segment8_low,
x_segment9_high,
x_segment9_low,
x_segment10_high,
x_segment10_low,
x_segment11_high,
x_segment11_low,
x_segment12_high,
x_segment12_low,
x_segment13_high,
x_segment13_low,
x_segment14_high,
x_segment14_low,
x_segment15_high,
x_segment15_low,
x_segment16_high,
x_segment16_low,
x_segment17_high,
x_segment17_low,
x_segment18_high,
x_segment18_low,
x_segment19_high,
x_segment19_low,
x_segment20_high,
x_segment20_low,
x_segment21_high,
x_segment21_low,
x_segment22_high,
x_segment22_low,
x_segment23_high,
x_segment23_low,
x_segment24_high,
x_segment24_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_segments_low_ccid,
x_segments_high_ccid,
x_segments_low_ccid_desc,
x_segments_high_ccid_desc,
x_budget_version_id,
x_period_name,
x_mode
);
update_row (
x_rowid,
x_dossier_id,
x_source_id,
x_sob_id,
x_coa_id,
x_segment25_low,
x_budget,
x_line_num,
x_budget_entity_id,
x_budget_entity_name,
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_high,
x_segment7_low,
x_segment8_high,
x_segment8_low,
x_segment9_high,
x_segment9_low,
x_segment10_high,
x_segment10_low,
x_segment11_high,
x_segment11_low,
x_segment12_high,
x_segment12_low,
x_segment13_high,
x_segment13_low,
x_segment14_high,
x_segment14_low,
x_segment15_high,
x_segment15_low,
x_segment16_high,
x_segment16_low,
x_segment17_high,
x_segment17_low,
x_segment18_high,
x_segment18_low,
x_segment19_high,
x_segment19_low,
x_segment20_high,
x_segment20_low,
x_segment21_high,
x_segment21_low,
x_segment22_high,
x_segment22_low,
x_segment23_high,
x_segment23_low,
x_segment24_high,
x_segment24_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_segments_low_ccid,
x_segments_high_ccid,
x_segments_low_ccid_desc,
x_segments_high_ccid_desc,
x_budget_version_id,
x_period_name,
x_mode
);
PROCEDURE delete_row (
x_rowid IN VARCHAR2
) AS
/*
|| Created By : [email protected]
|| Created On : 18-APR-2002
|| Purpose : Handles the DELETE DML logic for the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
*/
BEGIN
before_dml (
p_action => 'DELETE',
x_rowid => x_rowid
);
DELETE FROM igi_dos_sources
WHERE rowid = x_rowid;
END delete_row;