[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_select_date IN DATE := fnd_api.g_miss_date
) IS
BEGIN
PSB_POSITIONS_PVT.Initialize_View(
p_worksheet_id => p_worksheet_id,
p_start_date => p_start_date,
p_end_date => p_end_date,
p_select_date => p_select_date
);
SELECT a.default_rule_id,
f.priority priority,
b.global_default_flag,
b.overwrite,
a.assignment_type,
a.attribute_id,
a.attribute_value_id,
a.attribute_value,
a.pay_element_id,
a.pay_element_option_id,
a.pay_basis,
a.element_value_type,
a.element_value,
a.currency_code
FROM psb_default_assignments a,
psb_defaults b,
psb_set_relations c,
psb_budget_positions d,
psb_entity_set e,
psb_entity_assignment f
WHERE a.default_rule_id = b.default_rule_id
AND b.default_rule_id = c.default_rule_id
AND c.account_position_set_id = d.account_position_set_id
AND d.data_extract_id = p_data_extract_id
AND d.position_id = p_position_id
AND e.entity_set_id = f.entity_set_id
AND f.entity_id = b.default_rule_id
AND e.data_extract_id = p_data_extract_id
AND e.entity_type = 'DEFAULT_RULE'
AND NVL(e.executable_from_position, 'N') = 'Y'
UNION
SELECT a.default_rule_id,
d.priority priority,
b.global_default_flag,
b.overwrite,
a.assignment_type,
a.attribute_id,
a.attribute_value_id,
a.attribute_value,
a.pay_element_id,
a.pay_element_option_id,
a.pay_basis,
a.element_value_type,
a.element_value,
a.currency_code
FROM psb_default_assignments a,
psb_defaults b,
psb_entity_set c,
psb_entity_assignment d
WHERE a.default_rule_id = b.default_rule_id
AND b.global_default_flag = 'Y'
AND b.data_extract_id = p_data_extract_id
AND c.entity_set_id = d.entity_set_id
AND b.default_rule_id = d.entity_id
AND c.data_extract_id = p_data_extract_id
AND c.entity_type = 'DEFAULT_RULE'
AND NVL(c.executable_from_position, 'N') = 'Y'
ORDER BY 2;
SELECT effective_start_date,
effective_end_date
FROM psb_positions
WHERE position_id = p_position_id ;
SELECT a.default_rule_id,
f.priority priority,
a.global_default_flag,
a.overwrite
FROM psb_defaults a,
psb_set_relations b,
psb_budget_positions c,
psb_entity_set e,
psb_entity_assignment f
WHERE EXISTS
(SELECT 1
FROM PSB_DEFAULT_ACCOUNT_DISTRS d
WHERE d.default_rule_id = a.default_rule_id)
AND a.default_rule_id = b.default_rule_id
AND b.account_position_set_id = c.account_position_set_id
AND c.data_extract_id = p_data_extract_id
AND c.position_id = p_position_id
AND e.entity_set_id = f.entity_set_id
AND f.entity_id = a.default_rule_id
AND e.data_extract_id = p_data_extract_id
AND e.entity_type = 'DEFAULT_RULE'
AND NVL(e.executable_from_position, 'N') = 'Y'
UNION
SELECT a.default_rule_id,
c.priority priority,
a.global_default_flag,
a.overwrite
FROM psb_defaults a,
psb_entity_set b,
psb_entity_assignment c
WHERE EXISTS (SELECT 1
FROM PSB_DEFAULT_ACCOUNT_DISTRS d
WHERE d.default_rule_id = a.default_rule_id)
AND a.global_default_flag = 'Y'
AND a.data_extract_id = p_data_extract_id
AND b.entity_set_id = c.entity_set_id
AND a.default_rule_id = c.entity_id
AND b.data_extract_id = p_data_extract_id
AND b.entity_type = 'DEFAULT_RULE'
AND NVL(b.executable_from_position, 'N') = 'Y'
ORDER BY 2;
SELECT 'Exists'
FROM dual
WHERE EXISTS
(SELECT 1
FROM PSB_DEFAULT_ACCOUNT_DISTRS a,
PSB_DEFAULTS b
WHERE a.default_rule_id = b.default_rule_id
AND b.global_default_flag = 'Y'
AND b.data_extract_id = p_data_extract_id
AND a.default_rule_id = l_default_rule_id
);
SELECT chart_of_accounts_id,
code_combination_id,
distribution_percent
FROM PSB_DEFAULT_ACCOUNT_DISTRS
WHERE default_rule_id = l_default_rule_id;
SELECT *
FROM PSB_POSITION_PAY_DISTRIBUTIONS
WHERE (((p_position_end_date IS NOT NULL)
AND (((effective_start_date <= p_position_end_date)
AND (effective_end_date IS NULL))
OR ((effective_start_date BETWEEN p_position_start_date AND p_position_end_date)
OR (effective_end_date BETWEEN p_position_start_date AND p_position_end_date)
OR ((effective_start_date < p_position_start_date)
AND (effective_end_date > p_position_end_date)))))
OR ((p_position_end_date IS NULL)
AND (NVL(effective_end_date, p_position_start_date) >= p_position_start_date)))
AND data_extract_id = p_data_extract_id
AND position_id = p_position_id
AND ((worksheet_id IS NULL AND NOT EXISTS
/* Bug 4545909 Start */
(SELECT 1 FROM psb_position_pay_distributions
WHERE worksheet_id = p_worksheet_id
AND position_id = p_position_id))
OR worksheet_id = p_worksheet_id
OR (worksheet_id IS NULL AND p_worksheet_id IS NULL));
DELETE FROM psb_budget_positions
WHERE position_id = p_position_id
AND data_extract_id = p_data_extract_id;
PSB_POSITION_PAY_DISTR_PVT.Delete_Distributions_Position
(p_api_version => 1.0,
p_return_status => l_return_status,
p_msg_count => l_msg_count,
p_msg_data => l_msg_data,
p_position_id => p_position_id,
p_worksheet_id => l_worksheet_id);
FUNCTION Get_Select_Date RETURN DATE IS
BEGIN
Return PSB_POSITIONS_PVT.Get_Select_Date ;
END Get_Select_Date;
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_distribution_id in number
)
IS
BEGIN
PSB_POSITION_PAY_DISTR_PVT.DELETE_ROW (
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
p_validation_level => p_validation_level,
p_return_status => p_return_status,
p_msg_count => p_msg_count,
p_msg_data => p_msg_data,
p_distribution_id => p_distribution_id
);
END DELETE_ROW;