[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
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_PAY_ELEMENT_ID in NUMBER,
P_BUSINESS_GROUP_ID in NUMBER,
P_DATA_EXTRACT_ID in NUMBER,
p_BUDGET_SET_ID in NUMBER := FND_API.G_MISS_NUM,
P_NAME in VARCHAR2,
P_DESCRIPTION in VARCHAR2,
P_ELEMENT_VALUE_TYPE in VARCHAR2,
P_FORMULA_ID in NUMBER,
P_OVERWRITE_FLAG in VARCHAR2,
P_REQUIRED_FLAG in VARCHAR2,
P_FOLLOW_SALARY in VARCHAR2,
P_PAY_BASIS IN VARCHAR2,
P_START_DATE in DATE,
P_END_DATE in DATE,
P_PROCESSING_TYPE in VARCHAR2,
P_PERIOD_TYPE in VARCHAR2,
P_PROCESS_PERIOD_TYPE in VARCHAR2,
P_MAX_ELEMENT_VALUE_TYPE in VARCHAR2,
P_MAX_ELEMENT_VALUE in NUMBER,
P_SALARY_FLAG in VARCHAR2,
P_SALARY_TYPE in VARCHAR2,
P_OPTION_FLAG in VARCHAR2,
P_HR_ELEMENT_TYPE_ID in NUMBER,
P_ATTRIBUTE_CATEGORY 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';
select ROWID from psb_pay_elements
where pay_element_id = p_pay_element_id;
SAVEPOINT INSERT_ROW_PVT;
INSERT INTO psb_pay_elements
(
PAY_ELEMENT_ID ,
BUSINESS_GROUP_ID ,
DATA_EXTRACT_ID ,
BUDGET_SET_ID ,
NAME ,
DESCRIPTION ,
ELEMENT_VALUE_TYPE ,
FORMULA_ID ,
OVERWRITE_FLAG ,
REQUIRED_FLAG ,
FOLLOW_SALARY ,
PAY_BASIS ,
START_DATE ,
END_DATE ,
PROCESSING_TYPE ,
PERIOD_TYPE ,
PROCESS_PERIOD_TYPE ,
MAX_ELEMENT_VALUE_TYPE ,
MAX_ELEMENT_VALUE ,
SALARY_FLAG ,
SALARY_TYPE ,
OPTION_FLAG ,
HR_ELEMENT_TYPE_ID ,
ATTRIBUTE_CATEGORY ,
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_PAY_ELEMENT_ID ,
P_BUSINESS_GROUP_ID ,
P_DATA_EXTRACT_ID ,
decode(P_BUDGET_SET_ID, FND_API.G_MISS_NUM,null,P_BUDGET_SET_ID) ,
P_NAME ,
P_DESCRIPTION ,
P_ELEMENT_VALUE_TYPE ,
P_FORMULA_ID ,
P_OVERWRITE_FLAG ,
P_REQUIRED_FLAG ,
P_FOLLOW_SALARY ,
P_PAY_BASIS ,
P_START_DATE ,
P_END_DATE ,
P_PROCESSING_TYPE ,
P_PERIOD_TYPE ,
P_PROCESS_PERIOD_TYPE ,
P_MAX_ELEMENT_VALUE_TYPE ,
P_MAX_ELEMENT_VALUE ,
P_SALARY_FLAG ,
P_SALARY_TYPE ,
P_OPTION_FLAG ,
P_HR_ELEMENT_TYPE_ID ,
P_ATTRIBUTE_CATEGORY ,
P_ATTRIBUTE1 ,
P_ATTRIBUTE2 ,
P_ATTRIBUTE3 ,
P_ATTRIBUTE4 ,
P_ATTRIBUTE5 ,
P_ATTRIBUTE6 ,
P_ATTRIBUTE7 ,
P_ATTRIBUTE8 ,
P_ATTRIBUTE9 ,
P_ATTRIBUTE10 ,
/* Bug 4222417 Start */
NVL(P_LAST_UPDATE_DATE,SYSDATE) ,
NVL(P_LAST_UPDATED_BY,FND_GLOBAL.USER_ID) ,
NVL(P_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID) ,
NVL(P_CREATED_BY,FND_GLOBAL.USER_ID) ,
NVL(P_CREATION_DATE,SYSDATE)
/* Bug 4222417 End */
);
rollback to INSERT_ROW_PVT;
rollback to INSERT_ROW_PVT;
rollback to INSERT_ROW_PVT;
END Insert_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_PAY_ELEMENT_ID in NUMBER,
P_BUSINESS_GROUP_ID in NUMBER,
P_DATA_EXTRACT_ID in NUMBER,
P_BUDGET_SET_ID in NUMBER := FND_API.G_MISS_NUM,
P_NAME in VARCHAR2,
P_DESCRIPTION in VARCHAR2,
P_ELEMENT_VALUE_TYPE in VARCHAR2,
P_FORMULA_ID in NUMBER,
P_OVERWRITE_FLAG in VARCHAR2,
P_REQUIRED_FLAG in VARCHAR2,
P_FOLLOW_SALARY in VARCHAR2,
P_PAY_BASIS IN VARCHAR2,
P_START_DATE in DATE,
P_END_DATE in DATE,
P_PROCESSING_TYPE in VARCHAR2,
P_PERIOD_TYPE in VARCHAR2,
P_PROCESS_PERIOD_TYPE in VARCHAR2,
P_MAX_ELEMENT_VALUE_TYPE in VARCHAR2,
P_MAX_ELEMENT_VALUE in NUMBER,
P_SALARY_FLAG in VARCHAR2,
P_SALARY_TYPE in VARCHAR2,
P_OPTION_FLAG in VARCHAR2,
P_HR_ELEMENT_TYPE_ID in NUMBER,
P_ATTRIBUTE_CATEGORY 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_pay_elements SET
PAY_ELEMENT_ID = P_PAY_ELEMENT_ID,
BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID,
DATA_EXTRACT_ID = P_DATA_EXTRACT_ID,
BUDGET_SET_ID = decode(P_BUDGET_SET_ID,FND_API.G_MISS_NUM,null,P_BUDGET_SET_ID),
NAME = P_NAME,
DESCRIPTION = P_DESCRIPTION,
ELEMENT_VALUE_TYPE = P_ELEMENT_VALUE_TYPE,
FORMULA_ID = P_FORMULA_ID,
OVERWRITE_FLAG = P_OVERWRITE_FLAG,
REQUIRED_FLAG = P_REQUIRED_FLAG,
FOLLOW_SALARY = P_FOLLOW_SALARY,
PAY_BASIS = P_PAY_BASIS,
START_DATE = P_START_DATE,
END_DATE = P_END_DATE,
PROCESSING_TYPE = P_PROCESSING_TYPE,
PERIOD_TYPE = P_PERIOD_TYPE,
PROCESS_PERIOD_TYPE = P_PROCESS_PERIOD_TYPE,
MAX_ELEMENT_VALUE_TYPE = P_MAX_ELEMENT_VALUE_TYPE,
MAX_ELEMENT_VALUE = P_MAX_ELEMENT_VALUE,
SALARY_FLAG = P_SALARY_FLAG,
SALARY_TYPE = P_SALARY_TYPE,
OPTION_FLAG = P_OPTION_FLAG,
HR_ELEMENT_TYPE_ID = P_HR_ELEMENT_TYPE_ID,
ATTRIBUTE_CATEGORY = P_ATTRIBUTE_CATEGORY,
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 pay_element_id INTO l_pay_element_id
FROM psb_pay_elements
WHERE rowid = p_row_id ;
SELECT position_set_group_id
FROM psb_element_pos_set_groups
WHERE pay_element_id = l_pay_element_id
)
LOOP
PSB_Set_Relation_PVT.Delete_Entity_Relation
(
p_api_version => 1.0 ,
p_init_msg_list => FND_API.G_FALSE ,
p_commit => FND_API.G_FALSE ,
p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
p_return_status => l_return_status ,
p_msg_count => l_msg_count ,
p_msg_data => l_msg_data ,
--
p_entity_type => 'PSG' ,
p_entity_id => l_pos_set_group_rec.position_set_group_id
) ;
DELETE psb_pay_element_rates
WHERE pay_element_id = l_pay_element_id ;
DELETE psb_pay_element_options
WHERE pay_element_id = l_pay_element_id ;
DELETE psb_pay_element_distributions
WHERE position_set_group_id IN
(
SELECT position_set_group_id
FROM psb_element_pos_set_groups
WHERE pay_element_id = l_pay_element_id
) ;
DELETE psb_element_pos_set_groups
WHERE pay_element_id = l_pay_element_id ;
DELETE psb_pay_elements
WHERE rowid = p_row_id ;
ROLLBACK TO Delete_Row_Pvt ;
ROLLBACK TO Delete_Row_Pvt ;
ROLLBACK TO Delete_Row_Pvt ;
END Delete_Row;
CURSOR C IS SELECT * FROM PSB_PAY_ELEMENTS WHERE ROWID = p_Row_Id
FOR UPDATE of PAY_ELEMENT_Id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
SELECT '1'
FROM psb_pay_elements
WHERE name = p_name
AND ( (p_Row_Id IS NULL)
OR (RowId <> p_Row_Id) )
AND (DATA_EXTRACT_ID = P_DATA_EXTRACT_ID);
SELECT '1'
FROM psb_position_assignments
WHERE pay_element_id = p_pay_element_id ;
SELECT '1'
FROM psb_ws_element_lines
WHERE pay_element_id = p_pay_element_id ;
SELECT '1'
FROM psb_default_assignments
WHERE pay_element_id = p_pay_element_id ;
l_last_update_date DATE;
l_last_updated_by NUMBER;
l_last_update_login NUMBER;
SELECT DISTINCT *
FROM psb_pay_elements
WHERE pay_element_id = p_source_pay_element_id;
SELECT pay_element_option_id,pay_element_id,
name, grade_step, sequence_number
FROM psb_pay_element_options
WHERE pay_element_id = p_source_pay_element_id;
SELECT pay_element_rate_id,pay_element_option_id,
effective_start_date,effective_end_date,
worksheet_id,element_value_type,
element_value,formula_id,
maximum_value,mid_value,
minimum_value,currency_code,pay_basis
FROM psb_pay_element_rates
WHERE (((pay_element_option_id = l_source_pay_element_option_id ) AND
(pay_element_id = p_source_pay_element_id)) or
((pay_element_id = p_source_pay_element_id) AND
(pay_element_option_id IS NULL)))
AND worksheet_id IS NULL;
select position_set_group_id,name
FROM psb_element_pos_set_groups
WHERE pay_element_id = p_source_pay_element_id;
SELECT aps.name,
effective_start_date,
effective_end_date
FROM psb_set_relations rels, psb_account_position_sets aps
WHERE rels.account_position_set_id = aps.account_position_set_id
AND aps.data_extract_id = p_source_data_extract_id
AND rels.position_set_group_id = l_source_set_group_id;
SELECT account_position_set_id
FROM psb_account_position_sets
WHERE name = l_set_name
AND data_extract_id = p_target_data_extract_id;
SELECT distribution_id,distribution_set_id,
chart_of_accounts_id,effective_start_date,
effective_end_date,distribution_percent,
code_combination_id,concatenated_segments,
segment1,segment2,
segment3,segment4,
segment5,segment6,
segment7,segment8,
segment9,segment10,
segment11,segment12,
segment13,segment14,
segment15,segment16,
segment17,segment18,
segment19,segment20,
segment21,segment22,
segment23,segment24,
segment25,segment26,
segment27,segment28,
segment29,segment30
FROM psb_pay_element_distributions
WHERE position_set_group_id = l_source_set_group_id
order by distribution_set_id;
l_last_update_date := sysDATE;
l_last_updated_by := FND_GLOBAL.USER_ID;
l_last_update_login := FND_GLOBAL.LOGIN_ID;
SELECT psb_pay_elements_s.NEXTVAL
INTO l_pay_element_id
FROM DUAL;
PSB_PAY_ELEMENTS_PVT.INSERT_ROW
( p_api_version => 1.0,
p_init_msg_list => null,
p_commit => null,
p_validation_level => null,
p_return_status => l_return_status,
p_msg_count => l_msg_count,
p_msg_data => l_msg_data,
p_row_id => l_rowid,
p_pay_element_id => l_pay_element_id,
p_business_group_id => l_pay_element_rec.business_group_id,
p_data_extract_id => p_target_data_extract_id,
p_budget_set_id => l_budget_set_id,
p_name => l_pay_element_rec.name,
p_description => l_pay_element_rec.description,
p_element_value_type => l_pay_element_rec.element_value_type,
p_formula_id => l_pay_element_rec.formula_id,
p_overwrite_flag => l_pay_element_rec.overwrite_flag,
p_required_flag => l_pay_element_rec.required_flag,
p_follow_salary => l_pay_element_rec.follow_salary,
p_pay_basis => l_pay_element_rec.pay_basis,
p_start_date => l_pay_element_rec.start_date,
p_end_date => l_pay_element_rec.end_date,
p_processing_type => l_pay_element_rec.processing_type,
p_period_type => l_pay_element_rec.period_type,
p_process_period_type => l_pay_element_rec.process_period_type,
p_max_element_value_type => l_pay_element_rec.max_element_value_type,
p_max_element_value => l_pay_element_rec.max_element_value,
p_salary_flag => l_pay_element_rec.salary_flag,
p_salary_type => l_pay_element_rec.salary_type,
p_option_flag => l_pay_element_rec.option_flag,
p_hr_element_type_id => l_pay_element_rec.hr_element_type_id,
p_attribute_category => l_pay_element_rec.attribute_category,
p_attribute1 => l_pay_element_rec.attribute1,
p_attribute2 => l_pay_element_rec.attribute2,
p_attribute3 => l_pay_element_rec.attribute3,
p_attribute4 => l_pay_element_rec.attribute4,
p_attribute5 => l_pay_element_rec.attribute5,
p_attribute6 => l_pay_element_rec.attribute6,
p_attribute7 => l_pay_element_rec.attribute7,
p_attribute8 => l_pay_element_rec.attribute8,
p_attribute9 => l_pay_element_rec.attribute9,
p_attribute10 => l_pay_element_rec.attribute10,
p_last_update_date => l_last_update_date,
p_last_updated_by => l_last_updated_by,
p_last_update_login => l_last_update_login,
p_created_by => l_created_by,
p_creation_date => l_creation_date
);
SELECT psb_pay_element_options_s.NEXTVAL
INTO l_pay_element_option_id
FROM DUAL;
PSB_PAY_ELEMENT_OPTIONS_PVT.INSERT_ROW
( p_api_version => 1.0,
p_init_msg_list => null,
p_commit => null,
p_validation_level => null,
p_return_status => l_return_status,
p_msg_count => l_msg_count,
p_msg_data => l_msg_data,
p_pay_element_option_id => l_pay_element_option_id,
p_pay_element_id => l_pay_element_id,
p_name => l_pay_element_options_rec.name,
p_grade_step => l_pay_element_options_rec.grade_step,
p_sequence_number => l_pay_element_options_rec.sequence_number,
p_last_update_date => l_last_update_date,
p_last_updated_by => l_last_updated_by,
p_last_update_login => l_last_update_login,
p_created_by => l_created_by,
p_creation_date => l_creation_date
);
SELECT psb_pay_element_rates_s.NEXTVAL
INTO l_pay_element_rate_id
FROM DUAL;
PSB_PAY_ELEMENT_RATES_PVT.INSERT_ROW
( p_api_version => 1.0,
p_init_msg_list => null,
p_commit => null,
p_validation_level => null,
p_return_status => l_return_status,
p_msg_count => l_msg_count,
p_msg_data => l_msg_data,
p_pay_element_rate_id => l_pay_element_rate_id,
p_pay_element_option_id => l_pay_element_option_id,
p_pay_element_id => l_pay_element_id,
p_effective_start_date => l_pay_element_rates_rec.effective_start_date,
p_effective_end_date => l_pay_element_rates_rec.effective_end_date,
p_worksheet_id => l_pay_element_rates_rec.worksheet_id,
p_element_value_type => l_pay_element_rates_rec.element_value_type,
p_element_value => l_pay_element_rates_rec.element_value,
p_pay_basis => l_pay_element_rates_rec.pay_basis,
p_formula_id => l_pay_element_rates_rec.formula_id,
p_maximum_value => l_pay_element_rates_rec.maximum_value,
p_mid_value => l_pay_element_rates_rec.mid_value,
p_minimum_value => l_pay_element_rates_rec.minimum_value,
p_currency_code => l_pay_element_rates_rec.currency_code,
p_last_update_date => l_last_update_date,
p_last_updated_by => l_last_updated_by,
p_last_update_login => l_last_update_login,
p_created_by => l_created_by,
p_creation_date => l_creation_date
) ;
SELECT psb_pay_element_rates_s.NEXTVAL
INTO l_pay_element_rate_id
FROM DUAL;
PSB_PAY_ELEMENT_RATES_PVT.INSERT_ROW
( p_api_version => 1.0,
p_init_msg_list => null,
p_commit => null,
p_validation_level => null,
p_return_status => l_return_status,
p_msg_count => l_msg_count,
p_msg_data => l_msg_data,
p_pay_element_rate_id => l_pay_element_rate_id,
p_pay_element_option_id => l_pay_element_option_id,
p_pay_element_id => l_pay_element_id,
p_effective_start_date =>
l_pay_element_rates_rec.effective_start_date,
p_effective_end_date =>
l_pay_element_rates_rec.effective_end_date,
p_worksheet_id => l_pay_element_rates_rec.worksheet_id,
p_element_value_type =>
l_pay_element_rates_rec.element_value_type,
p_element_value => l_pay_element_rates_rec.element_value,
p_pay_basis => l_pay_element_rates_rec.pay_basis,
p_formula_id => l_pay_element_rates_rec.formula_id,
p_maximum_value => l_pay_element_rates_rec.maximum_value,
p_mid_value => l_pay_element_rates_rec.mid_value,
p_minimum_value => l_pay_element_rates_rec.minimum_value,
p_currency_code => l_pay_element_rates_rec.currency_code,
p_last_update_date => l_last_update_date,
p_last_updated_by => l_last_updated_by,
p_last_update_login => l_last_update_login,
p_created_by => l_created_by,
p_creation_date => l_creation_date
) ;
SELECT psb_element_pos_set_groups_s.NEXTVAL
INTO l_position_set_group_id
FROM DUAL;
PSB_ELEMENT_POS_SET_GROUPS_PVT.Insert_Row
( p_api_version => 1.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
p_validation_level => FND_API.G_VALID_LEVEL_FULL,
p_return_status => l_return_status,
p_msg_count => l_msg_count,
p_msg_data => l_msg_data,
--
p_position_set_group_id => l_position_set_group_id,
p_pay_element_id => l_pay_element_id,
p_name => l_set_groups_rec.name,
p_last_update_date => l_last_update_date,
p_last_updated_by => l_last_updated_by,
p_last_update_login => l_last_update_login,
p_created_by => l_created_by,
p_creation_date => l_creation_date
);
SELECT psb_pay_element_distribution_s.NEXTVAL INTO
l_distribution_id
FROM DUAL;
SELECT psb_element_distribution_set_s.NEXTVAL INTO
l_distribution_set_id
FROM DUAL;
PSB_ELE_DISTRIBUTIONS_I_PVT.Insert_Row
( p_api_version => 1.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
p_validation_level => FND_API.G_VALID_LEVEL_FULL,
p_return_status => l_return_status,
p_msg_count => l_msg_count,
p_msg_data => l_msg_data,
--
p_distribution_id => l_distribution_id,
p_position_set_group_id => l_position_set_group_id,
p_chart_of_accounts_id =>
l_account_distr_rec.chart_of_accounts_id,
p_effective_start_date =>
l_account_distr_rec.effective_start_date,
p_effective_end_date =>
l_account_distr_rec.effective_end_date,
p_distribution_percent =>
l_account_distr_rec.distribution_percent,
p_concatenated_segments =>
l_account_distr_rec.concatenated_segments,
p_code_combination_id =>
l_account_distr_rec.code_combination_id,
p_distribution_set_id => l_distribution_set_id,
p_segment1 => l_account_distr_rec.segment1,
p_segment2 => l_account_distr_rec.segment2,
p_segment3 => l_account_distr_rec.segment3,
p_segment4 => l_account_distr_rec.segment4,
p_segment5 => l_account_distr_rec.segment5,
p_segment6 => l_account_distr_rec.segment6,
p_segment7 => l_account_distr_rec.segment7,
p_segment8 => l_account_distr_rec.segment8,
p_segment9 => l_account_distr_rec.segment9,
p_segment10 => l_account_distr_rec.segment10,
p_segment11 => l_account_distr_rec.segment11,
p_segment12 => l_account_distr_rec.segment12,
p_segment13 => l_account_distr_rec.segment13,
p_segment14 => l_account_distr_rec.segment14,
p_segment15 => l_account_distr_rec.segment15,
p_segment16 => l_account_distr_rec.segment16,
p_segment17 => l_account_distr_rec.segment17,
p_segment18 => l_account_distr_rec.segment18,
p_segment19 => l_account_distr_rec.segment19,
p_segment20 => l_account_distr_rec.segment20,
p_segment21 => l_account_distr_rec.segment21,
p_segment22 => l_account_distr_rec.segment22,
p_segment23 => l_account_distr_rec.segment23,
p_segment24 => l_account_distr_rec.segment24,
p_segment25 => l_account_distr_rec.segment25,
p_segment26 => l_account_distr_rec.segment26,
p_segment27 => l_account_distr_rec.segment27,
p_segment28 => l_account_distr_rec.segment28,
p_segment29 => l_account_distr_rec.segment29,
p_segment30 => l_account_distr_rec.segment30,
p_last_update_date => l_last_update_date,
p_last_updated_by => l_last_updated_by,
p_last_update_login => l_last_update_login,
p_created_by => l_created_by,
p_creation_date => l_creation_date
);
PSB_Set_Relation_PVT.Insert_Row
( p_api_version => 1.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
p_validation_level => FND_API.G_VALID_LEVEL_FULL,
p_return_status => l_return_status,
p_msg_count => l_msg_count,
p_msg_data => l_msg_data,
p_Row_Id => l_rowid2,
p_Set_Relation_Id => l_set_relation_id,
p_Account_Position_Set_Id =>
l_account_sets_rec.account_position_set_id,
p_Allocation_Rule_Id => null,
p_Budget_Group_Id => null,
p_Budget_Workflow_Rule_Id => null,
p_Constraint_Id => null,
p_Default_Rule_Id => null,
p_Parameter_Id => null,
p_Position_Set_Group_Id => l_position_set_group_id,
/* Budget Revision Rules Enhancement Start */
p_rule_id => null,
p_apply_balance_flag => null,
/* Budget Revision Rules Enhancement End */
p_Effective_Start_Date =>
l_position_sets_rec.effective_start_date,
p_Effective_End_Date =>
l_position_sets_rec.effective_end_date,
p_last_update_date => l_last_update_date,
p_last_updated_by => l_last_updated_by,
p_last_update_login => l_last_update_login,
p_created_by => l_created_by,
p_creation_date => l_creation_date
);