[Home] [Help]
127: -- -------- -------- -----------------------------------------------------------
128: -- 11/08/05 mviswana Created
129: -- -----------------------------------------------------------------------------
130: PROCEDURE Log_EGO_Ext_PVT_Parameters(
131: p_ext_attr_grp_tbl IN EGO_USER_ATTR_ROW_TABLE
132: ,p_ext_attr_tbl IN EGO_USER_ATTR_DATA_TABLE) ;
133:
134:
135: -- =============================================================================
270: ,x_msg_data OUT NOCOPY VARCHAR2
271: )IS
272:
273: l_user_attr_data_table EGO_USER_ATTR_DATA_TABLE;
274: l_user_attr_row_table EGO_USER_ATTR_ROW_TABLE;
275: l_pk_name_value_pair EGO_COL_NAME_VALUE_PAIR_ARRAY;
276: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
277: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;
278: l_failed_row_id_list VARCHAR2(4000);
722:
723: IF p_ext_attr_grp_tbl(i).context <> l_old_context AND
724: l_old_context IS NOT NULL THEN
725: IF (l_user_attr_row_table IS NULL) THEN
726: l_user_attr_row_table := EGO_USER_ATTR_ROW_TABLE();
727: --DBMS_OUTPUT.PUT_LINE('instanciated');
728: ELSE
729: l_user_attr_row_table.DELETE();
730: --DBMS_OUTPUT.PUT_LINE('deleted');
730: --DBMS_OUTPUT.PUT_LINE('deleted');
731: END IF;
732: ELSE
733: IF (l_user_attr_row_table IS NULL) THEN
734: l_user_attr_row_table := EGO_USER_ATTR_ROW_TABLE();
735: END IF;
736: END IF;
737:
738: --Extend the object and start adding values
1301: (EGO_COL_NAME_VALUE_PAIR_OBJ('CONTEXT', v_get_old_context_value.context));
1302:
1303: --Instanciate a new EGO_USER_ATTR_ROW_OBJ (only once)
1304: IF (l_user_attr_row_table IS NULL) THEN
1305: l_user_attr_row_table := EGO_USER_ATTR_ROW_TABLE();
1306: END IF;
1307:
1308: --Extend the object to add value it it
1309: l_user_attr_row_table.EXTEND();
1563: **************************/
1564: IF p_ext_attr_grp_tbl(i).context <> l_old_context AND
1565: l_old_context IS NOT NULL THEN
1566: IF (l_user_attr_row_table IS NULL) THEN
1567: l_user_attr_row_table := EGO_USER_ATTR_ROW_TABLE();
1568: --DBMS_OUTPUT.PUT_LINE('instanciated');
1569: ELSE
1570: l_user_attr_row_table.DELETE();
1571: --DBMS_OUTPUT.PUT_LINE('deleted');
1571: --DBMS_OUTPUT.PUT_LINE('deleted');
1572: END IF;
1573: ELSE
1574: IF (l_user_attr_row_table IS NULL) THEN
1575: l_user_attr_row_table := EGO_USER_ATTR_ROW_TABLE();
1576: END IF;
1577: END IF;
1578:
1579: --Extend the object and start adding values
3967:
3968:
3969: l_pk_col_name_value_pair EGO_COL_NAME_VALUE_PAIR_ARRAY;
3970: l_attr_group_request_table EGO_ATTR_GROUP_REQUEST_TABLE;
3971: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
3972: l_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
3973: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;
3974: l_return_status VARCHAR2(1);
3975: l_errorcode NUMBER;
6475: -- -------- -------- -----------------------------------------------------------
6476: -- 11/08/05 mviswana Created
6477: -- -----------------------------------------------------------------------------
6478: PROCEDURE Log_EGO_Ext_PVT_Parameters(
6479: p_ext_attr_grp_tbl IN EGO_USER_ATTR_ROW_TABLE
6480: ,p_ext_attr_tbl IN EGO_USER_ATTR_DATA_TABLE)
6481:
6482: IS
6483:
6794: l_pk_name_value_pair EGO_COL_NAME_VALUE_PAIR_ARRAY;
6795: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
6796: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;
6797: l_user_attr_data_table EGO_USER_ATTR_DATA_TABLE;
6798: l_user_attr_row_table EGO_USER_ATTR_ROW_TABLE;
6799: l_count NUMBER;
6800: --
6801: CURSOR c_get_old_context_value
6802: ( p_incident_id IN NUMBER
6843:
6844: --Instanciate a new EGO_USER_ATTR_ROW_OBJ (only once)
6845: IF l_user_attr_row_table IS NULL
6846: THEN
6847: l_user_attr_row_table := EGO_USER_ATTR_ROW_TABLE();
6848: END IF;
6849:
6850: --Extend the object to add value it it
6851: l_user_attr_row_table.EXTEND();