APPS.PSB_ENTITY_SET_PVT dependencies on DUAL

Line 910: FROM dual;

906: --use this assignment for formula rec
907: l_source_entity_id := l_entity_rec.entity_id;
908:
909: SELECT psb_entity_s.nextval INTO l_entity_id
910: FROM dual;
911:
912: -- Call Create parameter API.
913:
914: -- name for the new parameter

Line 1107: FROM dual;

1103: l_account_position_set_id IS NOT NULL
1104: THEN
1105:
1106: SELECT psb_set_relations_s.nextval INTO l_set_relation_id
1107: FROM dual;
1108:
1109: IF p_entity_type = 'P' THEN
1110: l_parameter_id := l_entity_id;
1111: l_constraint_id := l_sets_rec.constraint_id;

Line 1348: FROM dual;

1344:
1345: IF l_create_formula_flag = 'Y' THEN
1346:
1347: SELECT psb_parameter_formulas_s.nextval INTO l_parameter_formula_id
1348: FROM dual;
1349:
1350: debug('Processing formula' || l_para_formula_rec.parameter_formula_id);
1351:
1352: PSB_PARAMETER_FORMULAS_PVT.INSERT_ROW

Line 1595: FROM dual;

1591:
1592: IF l_create_formula_flag = 'Y' THEN
1593:
1594: SELECT psb_constraint_formulas_s.nextval INTO l_constraint_formula_id
1595: FROM dual;
1596:
1597: debug('Processing formula for constraint_formula_id: ' ||
1598: l_const_formula_rec.constraint_formula_id);
1599:

Line 1895: FROM dual;

1891: FETCH l_attribute_value_csr INTO l_attribute_value_rec;
1892: CLOSE l_attribute_value_csr;
1893:
1894: SELECT psb_attribute_values_s.nextval INTO l_attribute_value_id
1895: FROM dual;
1896:
1897: PSB_ATTRIBUTE_VALUES_PVT.INSERT_ROW
1898: ( p_api_version => 1.0,
1899: p_init_msg_list => null,

Line 2046: FROM DUAL

2042: l_return_value VARCHAR2(5) := 'FALSE';
2043: --
2044: CURSOR c_check_references_ws IS
2045: SELECT 1
2046: FROM DUAL
2047: WHERE EXISTS(
2048: SELECT 1
2049: FROM PSB_WORKSHEETS
2050: WHERE ((parameter_set_id = p_entity_set_id)

Line 2059: FROM DUAL

2055: );
2056:
2057: CURSOR c_check_references_br IS
2058: SELECT 1
2059: FROM DUAL
2060: WHERE EXISTS(
2061: SELECT 1
2062: FROM PSB_BUDGET_REVISIONS
2063: WHERE ((parameter_set_id = p_entity_set_id)