[Home] [Help]
3: l_attr_group_id NUMBER;
4: l_pk_column_values ego_col_name_value_pair_array;
5: l_request_table ego_attr_group_request_table := ego_attr_group_request_table();
6: l_attributes_row_table ego_user_attr_row_table;
7: l_attributes_data_table ego_user_attr_data_table := ego_user_attr_data_table();
8: l_return_status VARCHAR2(100);
9: l_errorcode NUMBER;
10: l_msg_count NUMBER;
11: l_msg_data VARCHAR2(4000);
20: l_attr_group_id := NULL;
21: l_pk_column_values := NULL;
22: l_request_table := ego_attr_group_request_table();
23: l_attributes_row_table := NULL;
24: l_attributes_data_table := ego_user_attr_data_table();
25: l_return_status := '';
26: l_errorcode := '';
27: l_msg_count := '';
28: l_msg_data := '';
124: l_request_table.delete;
125: FOR j IN (SELECT DISTINCT attr_group_id
126: FROM pos_supp_prof_ext_b
127: WHERE party_id = p_party_id) LOOP
128: l_attributes_data_table := ego_user_attr_data_table();
129: l_attr_group_id := j.attr_group_id;
130: BEGIN
131: SELECT attr_group_name
132: INTO l_attr_group_disp_name
258: l_error_msg_tbl error_handler.error_tbl_type;
259:
260: l_pk_column_values ego_col_name_value_pair_array;
261: l_attributes_row_table ego_user_attr_row_table := ego_user_attr_row_table();
262: l_attributes_data_table ego_user_attr_data_table := ego_user_attr_data_table();
263: l_class_code_name_value_pairs ego_col_name_value_pair_array := ego_col_name_value_pair_array();
264: -- l_row_identifier NUMBER := 1020;
265: TYPE rec1 IS RECORD(
266:
441:
442: END IF;
443: /* Build the Data Object */
444: --l_uda_data_rec := p_uda_rec_tbl(datacntr);
445: l_attributes_data_table := ego_user_attr_data_table();
446: process_attribute_group(l_data_level_1,
447: l_data_level_2,
448: l_data_level_3,
449: l_data_level,