APPS.PSB_ENTITY_SET_PVT dependencies on PSB_ATTRIBUTE_VALUES

Line 688: l_attribute_id psb_attribute_values.attribute_id%TYPE;

684: l_parameter_formula_id NUMBER;
685: l_constraint_formula_id NUMBER;
686: l_business_group_id psb_data_extracts.business_group_id%TYPE ;
687: l_source_data_extract_id psb_data_extracts.data_extract_id%TYPE ;
688: l_attribute_id psb_attribute_values.attribute_id%TYPE;
689: l_attribute_value_id psb_attribute_values.attribute_value_id%TYPE;
690: l_attribute_value psb_attribute_values.attribute_value%TYPE;
691: l_create_formula_flag VARCHAR2(1);
692: l_value_table_flag psb_attributes.value_table_flag%TYPE;

Line 689: l_attribute_value_id psb_attribute_values.attribute_value_id%TYPE;

685: l_constraint_formula_id NUMBER;
686: l_business_group_id psb_data_extracts.business_group_id%TYPE ;
687: l_source_data_extract_id psb_data_extracts.data_extract_id%TYPE ;
688: l_attribute_id psb_attribute_values.attribute_id%TYPE;
689: l_attribute_value_id psb_attribute_values.attribute_value_id%TYPE;
690: l_attribute_value psb_attribute_values.attribute_value%TYPE;
691: l_create_formula_flag VARCHAR2(1);
692: l_value_table_flag psb_attributes.value_table_flag%TYPE;
693: l_source_option_flag psb_pay_elements.option_flag%TYPE;

Line 690: l_attribute_value psb_attribute_values.attribute_value%TYPE;

686: l_business_group_id psb_data_extracts.business_group_id%TYPE ;
687: l_source_data_extract_id psb_data_extracts.data_extract_id%TYPE ;
688: l_attribute_id psb_attribute_values.attribute_id%TYPE;
689: l_attribute_value_id psb_attribute_values.attribute_value_id%TYPE;
690: l_attribute_value psb_attribute_values.attribute_value%TYPE;
691: l_create_formula_flag VARCHAR2(1);
692: l_value_table_flag psb_attributes.value_table_flag%TYPE;
693: l_source_option_flag psb_pay_elements.option_flag%TYPE;
694: l_source_salary_flag psb_pay_elements.salary_flag%TYPE;

Line 718: FROM psb_attribute_values

714: and data_extract_id = p_target_data_extract_id ;
715: --
716: CURSOR l_find_attribute_value_id_csr IS
717: SELECT attribute_value_id
718: FROM psb_attribute_values
719: WHERE attribute_id = l_attribute_id
720: and attribute_value = l_attribute_value
721: and data_extract_id = p_target_data_extract_id ;
722: --

Line 1777: l_attribute_value psb_attribute_values.attribute_value%TYPE;

1773: l_return_status VARCHAR2(1);
1774: l_msg_count NUMBER;
1775: l_msg_data VARCHAR2(1000);
1776: l_count NUMBER := 0;
1777: l_attribute_value psb_attribute_values.attribute_value%TYPE;
1778: l_attribute_id NUMBER;
1779: l_attribute_value_id NUMBER;
1780:
1781: CURSOR l_attr_value_csr IS

Line 1791: psb_attribute_values attr_values

1787: psb_account_position_sets sets,
1788: psb_account_position_set_lines lines,
1789: psb_position_set_line_values pos_val,
1790: psb_attributes attrs,
1791: psb_attribute_values attr_values
1792: WHERE assgn.entity_set_id = p_source_entity_set_id
1793: and assgn.entity_id = entity.entity_id
1794: and entity.entity_subtype = 'POSITION'
1795: and DECODE(p_entity_type,

Line 1814: psb_attribute_values attr_values

1810: FROM psb_entity_assignment assgn,
1811: psb_entity entity,
1812: psb_parameter_formulas formulas,
1813: psb_attributes attrs,
1814: psb_attribute_values attr_values
1815: WHERE assgn.entity_set_id = p_source_entity_set_id
1816: and assgn.entity_id = entity.entity_id
1817: and entity.entity_subtype = 'POSITION'
1818: and formulas.parameter_id = entity.entity_id

Line 1829: psb_attribute_values attr_values

1825:
1826: CURSOR l_attribute_value_csr IS
1827: SELECT attr_values.*
1828: FROM psb_attributes attrs,
1829: psb_attribute_values attr_values
1830: WHERE attrs.value_table_flag = 'Y'
1831: and attrs.attribute_id = l_attribute_id
1832: and attr_values.attribute_value = l_attribute_value
1833: and attr_values.data_extract_id = p_source_data_extract_id;

Line 1882: psb_attribute_values attr_values

1878: l_attribute_value := l_attr_value_rec.attribute_value;
1879:
1880: SELECT count(*) into l_count
1881: FROM psb_attributes attrs,
1882: psb_attribute_values attr_values
1883: WHERE attrs.value_table_flag = 'Y'
1884: and attrs.attribute_id = l_attribute_id
1885: and attr_values.attribute_value = l_attribute_value
1886: and attr_values.data_extract_id = p_target_data_extract_id;

Line 1894: SELECT psb_attribute_values_s.nextval INTO l_attribute_value_id

1890: OPEN l_attribute_value_csr;
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,

Line 1897: PSB_ATTRIBUTE_VALUES_PVT.INSERT_ROW

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,
1900: p_commit => null,
1901: p_validation_level => null,