[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
X_Charge_Range_Id IN OUT NOCOPY NUMBER,
X_Charge_Center_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_Creation_Date DATE,
X_Created_By NUMBER,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Last_Update_Login NUMBER
) IS
CURSOR C IS SELECT rowid FROM IGI_ITR_CHARGE_RANGES
WHERE charge_range_id = X_Charge_Range_Id
AND charge_center_id = X_Charge_Center_Id;
CURSOR C2 IS SELECT IGI_IGI_itr_charge_ranges_s.nextval FROM sys.dual;
INSERT INTO IGI_ITR_CHARGE_RANGES(
charge_range_id,
charge_center_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,
creation_date,
created_by,
last_update_date,
last_updated_by,
last_update_login
) VALUES (
X_Charge_Range_Id,
X_Charge_Center_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_Creation_Date,
X_Created_By,
X_Last_Update_Date,
X_Last_Updated_By,
X_Last_Update_Login
);
END Insert_Row;
SELECT *
FROM IGI_ITR_CHARGE_RANGES
WHERE rowid = X_Rowid
FOR UPDATE of Charge_Range_Id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
PROCEDURE Update_Row(X_Rowid VARCHAR2,
X_Charge_Range_Id NUMBER,
X_Charge_Center_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_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Last_Update_Login NUMBER
) IS
BEGIN
UPDATE IGI_ITR_CHARGE_RANGES
SET
charge_range_id = X_Charge_Range_Id,
charge_center_id = X_Charge_Center_Id,
segment1_low = X_Segment1_Low,
segment1_high = X_Segment1_High,
segment2_low = X_Segment2_Low,
segment2_high = X_Segment2_High,
segment3_low = X_Segment3_Low,
segment3_high = X_Segment3_High,
segment4_low = X_Segment4_Low,
segment4_high = X_Segment4_High,
segment5_low = X_Segment5_Low,
segment5_high = X_Segment5_High,
segment6_low = X_Segment6_Low,
segment6_high = X_Segment6_High,
segment7_low = X_Segment7_Low,
segment7_high = X_Segment7_High,
segment8_low = X_Segment8_Low,
segment8_high = X_Segment8_High,
segment9_low = X_Segment9_Low,
segment9_high = X_Segment9_High,
segment10_low = X_Segment10_Low,
segment10_high = X_Segment10_High,
segment11_low = X_Segment11_Low,
segment11_high = X_Segment11_High,
segment12_low = X_Segment12_Low,
segment12_high = X_Segment12_High,
segment13_low = X_Segment13_Low,
segment13_high = X_Segment13_High,
segment14_low = X_Segment14_Low,
segment14_high = X_Segment14_High,
segment15_low = X_Segment15_Low,
segment15_high = X_Segment15_High,
segment16_low = X_Segment16_Low,
segment16_high = X_Segment16_High,
segment17_low = X_Segment17_Low,
segment17_high = X_Segment17_High,
segment18_low = X_Segment18_Low,
segment18_high = X_Segment18_High,
segment19_low = X_Segment19_Low,
segment19_high = X_Segment19_High,
segment20_low = X_Segment20_Low,
segment20_high = X_Segment20_High,
segment21_low = X_Segment21_Low,
segment21_high = X_Segment21_High,
segment22_low = X_Segment22_Low,
segment22_high = X_Segment22_High,
segment23_low = X_Segment23_Low,
segment23_high = X_Segment23_High,
segment24_low = X_Segment24_Low,
segment24_high = X_Segment24_High,
segment25_low = X_Segment25_Low,
segment25_high = X_Segment25_High,
segment26_low = X_Segment26_Low,
segment26_high = X_Segment26_High,
segment27_low = X_Segment27_Low,
segment27_high = X_Segment27_High,
segment28_low = X_Segment28_Low,
segment28_high = X_Segment28_High,
segment29_low = X_Segment29_Low,
segment29_high = X_Segment29_High,
segment30_low = X_Segment30_Low,
segment30_high = X_Segment30_High,
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;
PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
BEGIN
DELETE FROM IGI_ITR_CHARGE_RANGES
WHERE rowid = X_Rowid;
END Delete_Row;