APPS.PSB_COPY_DATA_EXTRACT_PVT dependencies on PSB_ATTRIBUTE_VALUES

Line 47: lr_attribute_value psb_attribute_values.attribute_value%TYPE;

43: l_creation_date date;
44: l_created_by number;
45: lr_attribute_id number;
46: --UTF8 changes for Bug No : 2615261
47: lr_attribute_value psb_attribute_values.attribute_value%TYPE;
48: l_attribute_value_id number;
49: l_attr_dummy number := 0;
50: l_rowid varchar2(100);
51: l_status varchar2(1);

Line 60: from psb_attribute_values

56:
57: Cursor C_Attr_Val is
58: Select attribute_value_id,attribute_id,
59: attribute_value,hr_value_id,description
60: from psb_attribute_values
61: where data_extract_id = p_src_data_extract_id;
62:
63: Cursor C_ref_attr is
64: Select attribute_value_id

Line 65: from psb_attribute_values

61: where data_extract_id = p_src_data_extract_id;
62:
63: Cursor C_ref_attr is
64: Select attribute_value_id
65: from psb_attribute_values
66: where attribute_id = lr_attribute_id
67: and attribute_value = lr_attribute_value
68: and data_extract_id = p_data_extract_id;
69:

Line 127: PSB_ATTRIBUTE_VALUES_PVT.UPDATE_ROW

123:
124: For C_ref_attr_rec in C_ref_attr
125: Loop
126: l_attr_dummy := 1;
127: PSB_ATTRIBUTE_VALUES_PVT.UPDATE_ROW
128: ( p_api_version => 1.0,
129: p_init_msg_lISt => NULL,
130: p_commit => NULL,
131: p_validation_level => NULL,

Line 184: select psb_attribute_values_s.nextval into

180: End Loop;
181:
182: if (l_attr_dummy = 0) then
183:
184: select psb_attribute_values_s.nextval into
185: l_attribute_value_id from dual;
186:
187: PSB_ATTRIBUTE_VALUES_PVT.INSERT_ROW
188: ( p_api_version => 1.0,

Line 187: PSB_ATTRIBUTE_VALUES_PVT.INSERT_ROW

183:
184: select psb_attribute_values_s.nextval into
185: l_attribute_value_id from dual;
186:
187: PSB_ATTRIBUTE_VALUES_PVT.INSERT_ROW
188: ( p_api_version => 1.0,
189: p_init_msg_list => null,
190: p_commit => null,
191: p_validation_level => null,

Line 764: l_src_attribute_value psb_attribute_values.attribute_value%TYPE;

760: l_src_pay_element_name varchar2(30);
761: l_src_pay_option_name psb_pay_element_options.name%type; -- bug 5149134
762: l_src_grade_step number;
763: --UTF8 changes for Bug No : 2615261
764: l_src_attribute_value psb_attribute_values.attribute_value%TYPE;
765: l_src_entity_id number;
766: l_entity_id number;
767: l_set_relation_id number;
768: l_set_name varchar2(100);

Line 860: from psb_attribute_values

856: 'STEP', peo.grade_step, -1)) = l_src_grade_step;
857:
858: Cursor C_Attr_Val is
859: Select attribute_value
860: from psb_attribute_values
861: where data_extract_id = p_src_data_extract_id
862: and attribute_value_id = l_src_attribute_value_id;
863:
864: Cursor C_Attr_Val_Dest is

Line 866: from psb_attribute_values

862: and attribute_value_id = l_src_attribute_value_id;
863:
864: Cursor C_Attr_Val_Dest is
865: Select attribute_value_id
866: from psb_attribute_values
867: where data_extract_id = p_data_extract_id
868: and attribute_value = l_src_attribute_value;
869:
870: Cursor C_Alloc is