[Home] [Help]
322: PON_UDA_IMPORT_PKG.DEBUG('Attribute row Array: l_data_level_3 ' || l_data_level_3, d_progress);
323: PON_UDA_IMPORT_PKG.DEBUG('Attribute row Array: l_transaction_type ' || l_transaction_type, d_progress);
324: d_progress := 130;
325: x_attributes_row_table.EXTEND(1);
326: x_attributes_row_table(l_count + 1) := ego_user_attr_row_obj
327: (
328: l_row_identifier
329: ,l_attr_group_id
330: ,l_attr_group_app_id
475: )
476: IS
477: d_progress NUMBER := 0;
478: l_attr_row_table_index NUMBER;
479: l_attr_row_obj EGO_USER_ATTR_ROW_OBJ;
480: l_attr_name_val EGO_USER_ATTR_DATA_OBJ;
481: l_row_identifier NUMBER;
482: l_attr_group_type VARCHAR2(200);
483: l_attr_group_name VARCHAR2(200);
747: l_sql_query VARCHAR2(4000);
748: l_check NUMBER;
749: v_query_hdl NUMBER;
750: l_pk_name_value_pair EGO_COL_NAME_VALUE_PAIR_OBJ;
751: l_attr_row_obj EGO_USER_ATTR_ROW_OBJ;
752: l_rows_processed NUMBER;
753: l_attr_grp_loc_index NUMBER;
754: l_row_identifier NUMBER;
755: l_user_row_identifier NUMBER;
962:
963: d_progress := 430;
964: PON_UDA_IMPORT_PKG.DEBUG('Before adding AG to attribute row table', d_progress);
965: x_attributes_row_table.EXTEND(1);
966: x_attributes_row_table(x_attributes_row_table.COUNT) := ego_user_attr_row_obj
967: (
968: l_row_identifier
969: ,l_attr_group_id
970: ,201
1053:
1054: d_progress := 610;
1055: PON_UDA_IMPORT_PKG.DEBUG('Before adding AG to attribute row table', d_progress);
1056: x_attributes_row_table.EXTEND(1);
1057: x_attributes_row_table(x_attributes_row_table.COUNT) := ego_user_attr_row_obj
1058: (
1059: l_row_identifier
1060: ,l_attr_group_id
1061: ,201
1237: )
1238: IS
1239: d_progress NUMBER := 0;
1240: l_attr_group_id_index NUMBER;
1241: l_attr_row_obj EGO_USER_ATTR_ROW_OBJ;
1242: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
1243: l_action_id NUMBER;
1244: l_data_level_name VARCHAR2(200);
1245: l_data_level_id NUMBER;
1272: l_ext_attr_value_pairs_ind NUMBER;
1273:
1274: l_pk_column_name_value EGO_COL_NAME_VALUE_PAIR_OBJ;
1275: l_attr_name_value EGO_USER_ATTR_DATA_OBJ;
1276: l_attributes_row ego_user_attr_row_obj;
1277: l_external_attr_value EGO_COL_NAME_VALUE_PAIR_OBJ;
1278:
1279: l_err_txt VARCHAR2(2000);
1280:
2703: ,p_progress IN NUMBER
2704: )
2705: IS
2706: l_structure_ind NUMBER;
2707: l_structure EGO_USER_ATTR_ROW_OBJ;
2708: BEGIN
2709: IF p_structure_array IS NOT NULL THEN
2710: l_structure_ind := p_structure_array.FIRST;
2711: WHILE (l_structure_ind IS NOT NULL AND l_structure_ind <= p_structure_array.LAST)