[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
| PROCEDURE Insert_Row |
+========================================================================*/
PROCEDURE Insert_Row
(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
p_return_status OUT NOCOPY VARCHAR2,
p_msg_count OUT NOCOPY NUMBER,
p_msg_data OUT NOCOPY VARCHAR2,
--
p_Row_Id IN OUT NOCOPY VARCHAR2,
p_Line_Sequence_Id IN OUT NOCOPY NUMBER,
p_Account_Position_Set_Id IN NUMBER,
p_Description IN VARCHAR2,
p_Business_Group_Id IN NUMBER,
p_Attribute_Id IN NUMBER,
p_Include_Or_Exclude_Type IN VARCHAR2,
p_Segment1_Low IN VARCHAR2,
p_Segment2_Low IN VARCHAR2,
p_Segment3_Low IN VARCHAR2,
p_Segment4_Low IN VARCHAR2,
p_Segment5_Low IN VARCHAR2,
p_Segment6_Low IN VARCHAR2,
p_Segment7_Low IN VARCHAR2,
p_Segment8_Low IN VARCHAR2,
p_Segment9_Low IN VARCHAR2,
p_Segment10_Low IN VARCHAR2,
p_Segment11_Low IN VARCHAR2,
p_Segment12_Low IN VARCHAR2,
p_Segment13_Low IN VARCHAR2,
p_Segment14_Low IN VARCHAR2,
p_Segment15_Low IN VARCHAR2,
p_Segment16_Low IN VARCHAR2,
p_Segment17_Low IN VARCHAR2,
p_Segment18_Low IN VARCHAR2,
p_Segment19_Low IN VARCHAR2,
p_Segment20_Low IN VARCHAR2,
p_Segment21_Low IN VARCHAR2,
p_Segment22_Low IN VARCHAR2,
p_Segment23_Low IN VARCHAR2,
p_Segment24_Low IN VARCHAR2,
p_Segment25_Low IN VARCHAR2,
p_Segment26_Low IN VARCHAR2,
p_Segment27_Low IN VARCHAR2,
p_Segment28_Low IN VARCHAR2,
p_Segment29_Low IN VARCHAR2,
p_Segment30_Low IN VARCHAR2,
p_Segment1_High IN VARCHAR2,
p_Segment2_High IN VARCHAR2,
p_Segment3_High IN VARCHAR2,
p_Segment4_High IN VARCHAR2,
p_Segment5_High IN VARCHAR2,
p_Segment6_High IN VARCHAR2,
p_Segment7_High IN VARCHAR2,
p_Segment8_High IN VARCHAR2,
p_Segment9_High IN VARCHAR2,
p_Segment10_High IN VARCHAR2,
p_Segment11_High IN VARCHAR2,
p_Segment12_High IN VARCHAR2,
p_Segment13_High IN VARCHAR2,
p_Segment14_High IN VARCHAR2,
p_Segment15_High IN VARCHAR2,
p_Segment16_High IN VARCHAR2,
p_Segment17_High IN VARCHAR2,
p_Segment18_High IN VARCHAR2,
p_Segment19_High IN VARCHAR2,
p_Segment20_High IN VARCHAR2,
p_Segment21_High IN VARCHAR2,
p_Segment22_High IN VARCHAR2,
p_Segment23_High IN VARCHAR2,
p_Segment24_High IN VARCHAR2,
p_Segment25_High IN VARCHAR2,
p_Segment26_High IN VARCHAR2,
p_Segment27_High IN VARCHAR2,
p_Segment28_High IN VARCHAR2,
p_Segment29_High IN VARCHAR2,
p_Segment30_High IN VARCHAR2,
p_context IN VARCHAR2,
p_attribute1 IN VARCHAR2,
p_attribute2 IN VARCHAR2,
p_attribute3 IN VARCHAR2,
p_attribute4 IN VARCHAR2,
p_attribute5 IN VARCHAR2,
p_attribute6 IN VARCHAR2,
p_attribute7 IN VARCHAR2,
p_attribute8 IN VARCHAR2,
p_attribute9 IN VARCHAR2,
p_attribute10 IN VARCHAR2,
p_Last_Update_Date IN DATE,
p_Last_Updated_By IN NUMBER,
p_Last_Update_Login IN NUMBER,
p_Created_By IN NUMBER,
p_Creation_Date IN DATE
)
IS
--
l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
CURSOR C IS SELECT rowid
FROM psb_account_position_set_lines
WHERE line_sequence_id = p_Line_Sequence_Id;
CURSOR C2 IS SELECT psb_acct_position_set_lines_s.nextval
FROM dual;
SAVEPOINT Insert_Row_Pvt ;
INSERT INTO psb_account_position_set_lines
(
line_sequence_id,
account_position_set_id,
description,
business_group_id,
attribute_id,
include_or_exclude_type,
segment1_low,
segment2_low,
segment3_low,
segment4_low,
segment5_low,
segment6_low,
segment7_low,
segment8_low,
segment9_low,
segment10_low,
segment11_low,
segment12_low,
segment13_low,
segment14_low,
segment15_low,
segment16_low,
segment17_low,
segment18_low,
segment19_low,
segment20_low,
segment21_low,
segment22_low,
segment23_low,
segment24_low,
segment25_low,
segment26_low,
segment27_low,
segment28_low,
segment29_low,
segment30_low,
segment1_high,
segment2_high,
segment3_high,
segment4_high,
segment5_high,
segment6_high,
segment7_high,
segment8_high,
segment9_high,
segment10_high,
segment11_high,
segment12_high,
segment13_high,
segment14_high,
segment15_high,
segment16_high,
segment17_high,
segment18_high,
segment19_high,
segment20_high,
segment21_high,
segment22_high,
segment23_high,
segment24_high,
segment25_high,
segment26_high,
segment27_high,
segment28_high,
segment29_high,
segment30_high,
context,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
last_update_date,
last_updated_by,
last_update_login,
created_by,
creation_date
)
VALUES
(
p_Line_Sequence_Id,
p_Account_Position_Set_Id,
p_Description,
p_Business_Group_Id,
p_Attribute_Id,
p_Include_Or_Exclude_Type,
p_Segment1_Low,
p_Segment2_Low,
p_Segment3_Low,
p_Segment4_Low,
p_Segment5_Low,
p_Segment6_Low,
p_Segment7_Low,
p_Segment8_Low,
p_Segment9_Low,
p_Segment10_Low,
p_Segment11_Low,
p_Segment12_Low,
p_Segment13_Low,
p_Segment14_Low,
p_Segment15_Low,
p_Segment16_Low,
p_Segment17_Low,
p_Segment18_Low,
p_Segment19_Low,
p_Segment20_Low,
p_Segment21_Low,
p_Segment22_Low,
p_Segment23_Low,
p_Segment24_Low,
p_Segment25_Low,
p_Segment26_Low,
p_Segment27_Low,
p_Segment28_Low,
p_Segment29_Low,
p_Segment30_Low,
p_Segment1_High,
p_Segment2_High,
p_Segment3_High,
p_Segment4_High,
p_Segment5_High,
p_Segment6_High,
p_Segment7_High,
p_Segment8_High,
p_Segment9_High,
p_Segment10_High,
p_Segment11_High,
p_Segment12_High,
p_Segment13_High,
p_Segment14_High,
p_Segment15_High,
p_Segment16_High,
p_Segment17_High,
p_Segment18_High,
p_Segment19_High,
p_Segment20_High,
p_Segment21_High,
p_Segment22_High,
p_Segment23_High,
p_Segment24_High,
p_Segment25_High,
p_Segment26_High,
p_Segment27_High,
p_Segment28_High,
p_Segment29_High,
p_Segment30_High,
p_context,
p_attribute1,
p_attribute2,
p_attribute3,
p_attribute4,
p_attribute5,
p_attribute6,
p_attribute7,
p_attribute8,
p_attribute9,
p_attribute10,
p_Last_Update_Date,
p_Last_Updated_By,
p_Last_Update_Login,
p_Created_By,
p_Creation_Date
);
ROLLBACK TO Insert_Row_Pvt ;
ROLLBACK TO Insert_Row_Pvt ;
ROLLBACK TO Insert_Row_Pvt ;
END Insert_Row;
SELECT *
FROM psb_account_position_set_lines
WHERE rowid = p_Row_Id
FOR UPDATE of Line_Sequence_Id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
| PROCEDURE Update_Row |
+==========================================================================*/
PROCEDURE Update_Row
(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
p_return_status OUT NOCOPY VARCHAR2,
p_msg_count OUT NOCOPY NUMBER,
p_msg_data OUT NOCOPY VARCHAR2,
--
p_Row_Id IN VARCHAR2,
p_Line_Sequence_Id IN NUMBER,
p_Account_Position_Set_Id IN NUMBER,
p_Description IN VARCHAR2,
p_Business_Group_Id IN NUMBER,
p_Attribute_Id IN NUMBER,
p_Include_Or_Exclude_Type IN VARCHAR2,
p_Segment1_Low IN VARCHAR2,
p_Segment2_Low IN VARCHAR2,
p_Segment3_Low IN VARCHAR2,
p_Segment4_Low IN VARCHAR2,
p_Segment5_Low IN VARCHAR2,
p_Segment6_Low IN VARCHAR2,
p_Segment7_Low IN VARCHAR2,
p_Segment8_Low IN VARCHAR2,
p_Segment9_Low IN VARCHAR2,
p_Segment10_Low IN VARCHAR2,
p_Segment11_Low IN VARCHAR2,
p_Segment12_Low IN VARCHAR2,
p_Segment13_Low IN VARCHAR2,
p_Segment14_Low IN VARCHAR2,
p_Segment15_Low IN VARCHAR2,
p_Segment16_Low IN VARCHAR2,
p_Segment17_Low IN VARCHAR2,
p_Segment18_Low IN VARCHAR2,
p_Segment19_Low IN VARCHAR2,
p_Segment20_Low IN VARCHAR2,
p_Segment21_Low IN VARCHAR2,
p_Segment22_Low IN VARCHAR2,
p_Segment23_Low IN VARCHAR2,
p_Segment24_Low IN VARCHAR2,
p_Segment25_Low IN VARCHAR2,
p_Segment26_Low IN VARCHAR2,
p_Segment27_Low IN VARCHAR2,
p_Segment28_Low IN VARCHAR2,
p_Segment29_Low IN VARCHAR2,
p_Segment30_Low IN VARCHAR2,
p_Segment1_High IN VARCHAR2,
p_Segment2_High IN VARCHAR2,
p_Segment3_High IN VARCHAR2,
p_Segment4_High IN VARCHAR2,
p_Segment5_High IN VARCHAR2,
p_Segment6_High IN VARCHAR2,
p_Segment7_High IN VARCHAR2,
p_Segment8_High IN VARCHAR2,
p_Segment9_High IN VARCHAR2,
p_Segment10_High IN VARCHAR2,
p_Segment11_High IN VARCHAR2,
p_Segment12_High IN VARCHAR2,
p_Segment13_High IN VARCHAR2,
p_Segment14_High IN VARCHAR2,
p_Segment15_High IN VARCHAR2,
p_Segment16_High IN VARCHAR2,
p_Segment17_High IN VARCHAR2,
p_Segment18_High IN VARCHAR2,
p_Segment19_High IN VARCHAR2,
p_Segment20_High IN VARCHAR2,
p_Segment21_High IN VARCHAR2,
p_Segment22_High IN VARCHAR2,
p_Segment23_High IN VARCHAR2,
p_Segment24_High IN VARCHAR2,
p_Segment25_High IN VARCHAR2,
p_Segment26_High IN VARCHAR2,
p_Segment27_High IN VARCHAR2,
p_Segment28_High IN VARCHAR2,
p_Segment29_High IN VARCHAR2,
p_Segment30_High IN VARCHAR2,
p_context IN VARCHAR2,
p_attribute1 IN VARCHAR2,
p_attribute2 IN VARCHAR2,
p_attribute3 IN VARCHAR2,
p_attribute4 IN VARCHAR2,
p_attribute5 IN VARCHAR2,
p_attribute6 IN VARCHAR2,
p_attribute7 IN VARCHAR2,
p_attribute8 IN VARCHAR2,
p_attribute9 IN VARCHAR2,
p_attribute10 IN VARCHAR2,
p_Last_Update_Date IN DATE,
p_Last_Updated_By IN NUMBER,
p_Last_Update_Login IN NUMBER
)
IS
--
l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
SAVEPOINT Update_Row_Pvt ;
UPDATE psb_account_position_set_lines
SET
line_sequence_id = p_Line_Sequence_Id,
account_position_set_id = p_Account_Position_Set_Id,
description = p_Description,
business_group_id = p_Business_Group_Id,
attribute_id = p_Attribute_Id,
include_or_exclude_type = p_Include_Or_Exclude_Type,
segment1_low = p_Segment1_Low,
segment2_low = p_Segment2_Low,
segment3_low = p_Segment3_Low,
segment4_low = p_Segment4_Low,
segment5_low = p_Segment5_Low,
segment6_low = p_Segment6_Low,
segment7_low = p_Segment7_Low,
segment8_low = p_Segment8_Low,
segment9_low = p_Segment9_Low,
segment10_low = p_Segment10_Low,
segment11_low = p_Segment11_Low,
segment12_low = p_Segment12_Low,
segment13_low = p_Segment13_Low,
segment14_low = p_Segment14_Low,
segment15_low = p_Segment15_Low,
segment16_low = p_Segment16_Low,
segment17_low = p_Segment17_Low,
segment18_low = p_Segment18_Low,
segment19_low = p_Segment19_Low,
segment20_low = p_Segment20_Low,
segment21_low = p_Segment21_Low,
segment22_low = p_Segment22_Low,
segment23_low = p_Segment23_Low,
segment24_low = p_Segment24_Low,
segment25_low = p_Segment25_Low,
segment26_low = p_Segment26_Low,
segment27_low = p_Segment27_Low,
segment28_low = p_Segment28_Low,
segment29_low = p_Segment29_Low,
segment30_low = p_Segment30_Low,
segment1_high = p_Segment1_High,
segment2_high = p_Segment2_High,
segment3_high = p_Segment3_High,
segment4_high = p_Segment4_High,
segment5_high = p_Segment5_High,
segment6_high = p_Segment6_High,
segment7_high = p_Segment7_High,
segment8_high = p_Segment8_High,
segment9_high = p_Segment9_High,
segment10_high = p_Segment10_High,
segment11_high = p_Segment11_High,
segment12_high = p_Segment12_High,
segment13_high = p_Segment13_High,
segment14_high = p_Segment14_High,
segment15_high = p_Segment15_High,
segment16_high = p_Segment16_High,
segment17_high = p_Segment17_High,
segment18_high = p_Segment18_High,
segment19_high = p_Segment19_High,
segment20_high = p_Segment20_High,
segment21_high = p_Segment21_High,
segment22_high = p_Segment22_High,
segment23_high = p_Segment23_High,
segment24_high = p_Segment24_High,
segment25_high = p_Segment25_High,
segment26_high = p_Segment26_High,
segment27_high = p_Segment27_High,
segment28_high = p_Segment28_High,
segment29_high = p_Segment29_High,
segment30_high = p_Segment30_High,
context = p_Context,
attribute1 = p_Attribute1,
attribute2 = p_Attribute2,
attribute3 = p_Attribute3,
attribute4 = p_Attribute4,
attribute5 = p_Attribute5,
attribute6 = p_Attribute6,
attribute7 = p_Attribute7,
attribute8 = p_Attribute8,
attribute9 = p_Attribute9,
attribute10 = p_Attribute10,
last_update_date = p_Last_Update_Date,
last_updated_by = p_Last_Updated_By,
last_update_login = p_Last_Update_Login
WHERE rowid = p_Row_Id;
ROLLBACK TO Update_Row_Pvt ;
ROLLBACK TO Update_Row_Pvt ;
ROLLBACK TO Update_Row_Pvt ;
END Update_Row;
| PROCEDURE Delete_Row |
+==========================================================================*/
PROCEDURE Delete_Row
(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
p_return_status OUT NOCOPY VARCHAR2,
p_msg_count OUT NOCOPY NUMBER,
p_msg_data OUT NOCOPY VARCHAR2,
--
p_Row_Id IN VARCHAR2
)
IS
--
l_api_name CONSTANT VARCHAR2(30) := 'Delete_Row';
SAVEPOINT Delete_Row_Pvt ;
SELECT line_sequence_id INTO l_line_sequence_id
FROM psb_account_position_set_lines
WHERE rowid = p_Row_Id ;
DELETE psb_position_set_line_values
WHERE line_sequence_id = l_line_sequence_id ;
DELETE psb_account_position_set_lines
WHERE rowid = p_Row_Id;
ROLLBACK TO Delete_Row_Pvt ;
ROLLBACK TO Delete_Row_Pvt ;
ROLLBACK TO Delete_Row_Pvt ;
END Delete_Row;