DBA Data[Home] [Help]

APPS.EGO_ITEM_USER_ATTRS_CP_PUB dependencies on EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 432: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

428: l_can_edit_this_instance VARCHAR2(1);
429: l_token_table ERROR_HANDLER.Token_Tbl_Type;
430: l_could_edit_prev_instance VARCHAR2(1);
431: l_at_start_of_row BOOLEAN;
432: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
433: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
434: p_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
435: p_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
436: l_user_privileges_table EGO_DATA_SECURITY.EGO_PRIVILEGE_NAME_TABLE_TYPE;

Line 433: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

429: l_token_table ERROR_HANDLER.Token_Tbl_Type;
430: l_could_edit_prev_instance VARCHAR2(1);
431: l_at_start_of_row BOOLEAN;
432: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
433: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
434: p_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
435: p_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
436: l_user_privileges_table EGO_DATA_SECURITY.EGO_PRIVILEGE_NAME_TABLE_TYPE;
437: l_privilege_table_index NUMBER;

Line 599: l_default_dl_view_priv_list EGO_COL_NAME_VALUE_PAIR_ARRAY;

595: FROM EGO_DATA_LEVEL_B
596: WHERE APPLICATION_ID = 431
597: AND ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP';
598:
599: l_default_dl_view_priv_list EGO_COL_NAME_VALUE_PAIR_ARRAY;
600: l_default_dl_edit_priv_list EGO_COL_NAME_VALUE_PAIR_ARRAY;
601: l_default_dl_view_priv_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
602: l_default_dl_edit_priv_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
603: BEGIN

Line 600: l_default_dl_edit_priv_list EGO_COL_NAME_VALUE_PAIR_ARRAY;

596: WHERE APPLICATION_ID = 431
597: AND ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP';
598:
599: l_default_dl_view_priv_list EGO_COL_NAME_VALUE_PAIR_ARRAY;
600: l_default_dl_edit_priv_list EGO_COL_NAME_VALUE_PAIR_ARRAY;
601: l_default_dl_view_priv_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
602: l_default_dl_edit_priv_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
603: BEGIN
604: l_api_name := 'Process_Item_User_Attrs_Data';

Line 2361: l_default_dl_view_priv_list := EGO_COL_NAME_VALUE_PAIR_ARRAY();

2357: l_privilege_predicate_api_name := NULL;
2358: END IF;
2359:
2360: -- creating default privileges
2361: l_default_dl_view_priv_list := EGO_COL_NAME_VALUE_PAIR_ARRAY();
2362: l_default_dl_edit_priv_list := EGO_COL_NAME_VALUE_PAIR_ARRAY();
2363: FOR i IN c_data_levels_for_sec LOOP
2364: IF i.ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP' AND i.DATA_LEVEL_NAME IN ('ITEM_SUP', 'ITEM_SUP_SITE', 'ITEM_SUP_SITE_ORG') THEN
2365: l_default_dl_view_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(i.DATA_LEVEL_ID, 'EGO_VIEW_ITEM_SUP_ASSIGN');

Line 2362: l_default_dl_edit_priv_list := EGO_COL_NAME_VALUE_PAIR_ARRAY();

2358: END IF;
2359:
2360: -- creating default privileges
2361: l_default_dl_view_priv_list := EGO_COL_NAME_VALUE_PAIR_ARRAY();
2362: l_default_dl_edit_priv_list := EGO_COL_NAME_VALUE_PAIR_ARRAY();
2363: FOR i IN c_data_levels_for_sec LOOP
2364: IF i.ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP' AND i.DATA_LEVEL_NAME IN ('ITEM_SUP', 'ITEM_SUP_SITE', 'ITEM_SUP_SITE_ORG') THEN
2365: l_default_dl_view_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(i.DATA_LEVEL_ID, 'EGO_VIEW_ITEM_SUP_ASSIGN');
2366: l_default_dl_edit_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(i.DATA_LEVEL_ID, 'EGO_EDIT_ITEM_SUP_ASSIGN');

Line 3103: l_old_data_level_nv_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

3099: ,x_msg_count OUT NOCOPY NUMBER
3100: ,x_msg_data OUT NOCOPY VARCHAR2
3101: ) IS
3102:
3103: l_old_data_level_nv_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3104: l_new_data_level_nv_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3105: l_api_name VARCHAR2(30);
3106:
3107: BEGIN

Line 3104: l_new_data_level_nv_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

3100: ,x_msg_data OUT NOCOPY VARCHAR2
3101: ) IS
3102:
3103: l_old_data_level_nv_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3104: l_new_data_level_nv_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3105: l_api_name VARCHAR2(30);
3106:
3107: BEGIN
3108: l_api_name := 'Impl_Item_Attr_Change_Line';

Line 3125: l_old_data_level_nv_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

3121: ---------------------------------------------------------------------
3122: -- Build data structures to pass in Data Level info, if applicable --
3123: ---------------------------------------------------------------------
3124: IF (p_old_revision_id IS NOT NULL) THEN
3125: l_old_data_level_nv_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
3126: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID',
3127: p_old_revision_id)
3128: );
3129: END IF;

Line 3131: l_new_data_level_nv_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

3127: p_old_revision_id)
3128: );
3129: END IF;
3130: IF (p_new_revision_id IS NOT NULL) THEN
3131: l_new_data_level_nv_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
3132: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID',
3133: p_new_revision_id)
3134: );
3135: END IF;