DBA Data[Home] [Help]

APPS.EGO_ITEM_USER_ATTRS_CP_PUB dependencies on EGO_COL_NAME_VALUE_PAIR_OBJ

Line 276: -- into the EGO_COL_NAME_VALUE_PAIR_OBJ is 150 chars); if the --

272:
273: -------------------------------------------------------------------
274: -- We build a list of all parent catalog groups, as long as the --
275: -- list is less than 151 characters long (the longest we can fit --
276: -- into the EGO_COL_NAME_VALUE_PAIR_OBJ is 150 chars); if the --
277: -- list is too long to fully copy, we can only hope that the --
278: -- portion we copied will contain all the information we need. --
279: -------------------------------------------------------------------
280: FOR cat_rec IN parent_catalog_group_cursor

Line 601: l_default_dl_view_priv_obj EGO_COL_NAME_VALUE_PAIR_OBJ;

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';
605: SetGlobals();

Line 602: l_default_dl_edit_priv_obj EGO_COL_NAME_VALUE_PAIR_OBJ;

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';
605: SetGlobals();
606: RETCODE := L_CONC_RET_STS_SUCCESS;

Line 2365: l_default_dl_view_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(i.DATA_LEVEL_ID, 'EGO_VIEW_ITEM_SUP_ASSIGN');

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');
2367: ELSE
2368: l_default_dl_view_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(i.DATA_LEVEL_ID, 'EGO_VIEW_ITEM');
2369: l_default_dl_edit_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(i.DATA_LEVEL_ID, 'EGO_EDIT_ITEM');

Line 2366: l_default_dl_edit_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(i.DATA_LEVEL_ID, 'EGO_EDIT_ITEM_SUP_ASSIGN');

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');
2367: ELSE
2368: l_default_dl_view_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(i.DATA_LEVEL_ID, 'EGO_VIEW_ITEM');
2369: l_default_dl_edit_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(i.DATA_LEVEL_ID, 'EGO_EDIT_ITEM');
2370: END IF;

Line 2368: l_default_dl_view_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(i.DATA_LEVEL_ID, 'EGO_VIEW_ITEM');

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');
2367: ELSE
2368: l_default_dl_view_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(i.DATA_LEVEL_ID, 'EGO_VIEW_ITEM');
2369: l_default_dl_edit_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(i.DATA_LEVEL_ID, 'EGO_EDIT_ITEM');
2370: END IF;
2371: l_default_dl_view_priv_list.EXTEND;
2372: l_default_dl_view_priv_list(l_default_dl_view_priv_list.COUNT) := l_default_dl_view_priv_obj;

Line 2369: l_default_dl_edit_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(i.DATA_LEVEL_ID, 'EGO_EDIT_ITEM');

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');
2367: ELSE
2368: l_default_dl_view_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(i.DATA_LEVEL_ID, 'EGO_VIEW_ITEM');
2369: l_default_dl_edit_priv_obj := EGO_COL_NAME_VALUE_PAIR_OBJ(i.DATA_LEVEL_ID, 'EGO_EDIT_ITEM');
2370: END IF;
2371: l_default_dl_view_priv_list.EXTEND;
2372: l_default_dl_view_priv_list(l_default_dl_view_priv_list.COUNT) := l_default_dl_view_priv_obj;
2373:

Line 3126: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID',

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;
3130: IF (p_new_revision_id IS NOT NULL) THEN

Line 3132: EGO_COL_NAME_VALUE_PAIR_OBJ('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;
3136: