[Home] [Help]
1: PACKAGE BODY EGO_ITEM_USER_ATTRS_CP_PUB AS
2: /* $Header: EGOCIUAB.pls 120.59 2007/11/09 03:02:54 mantyaku ship $ */
3:
4:
5: -----------------------
12: ------------------------------
13: -- Private Global Variables --
14: ------------------------------
15:
16: G_LOG_HEAD CONSTANT VARCHAR2(50) := 'fnd.plsql.ego.EGO_ITEM_USER_ATTRS_CP_PUB.';
17: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EGO_ITEM_USER_ATTRS_CP_PUB';
18: G_API_VERSION NUMBER := 1.0;
19: G_ITEM_NAME CONSTANT VARCHAR2(10) := 'EGO_ITEM';
20: G_ITEM_OBJECT_ID NUMBER;
13: -- Private Global Variables --
14: ------------------------------
15:
16: G_LOG_HEAD CONSTANT VARCHAR2(50) := 'fnd.plsql.ego.EGO_ITEM_USER_ATTRS_CP_PUB.';
17: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EGO_ITEM_USER_ATTRS_CP_PUB';
18: G_API_VERSION NUMBER := 1.0;
19: G_ITEM_NAME CONSTANT VARCHAR2(10) := 'EGO_ITEM';
20: G_ITEM_OBJECT_ID NUMBER;
21:
2351:
2352: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting User Attributes Bulk Load', 1);
2353:
2354: IF p_validate_only = FND_API.G_TRUE AND p_ignore_security_for_validate = FND_API.G_FALSE THEN
2355: l_privilege_predicate_api_name := 'EGO_ITEM_USER_ATTRS_CP_PUB.Get_Item_Security_Predicate';
2356: ELSE
2357: l_privilege_predicate_api_name := NULL;
2358: END IF;
2359:
2803: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2804: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
2805: ,p_default_dl_view_priv_list => l_default_dl_view_priv_list
2806: ,p_default_dl_edit_priv_list => l_default_dl_edit_priv_list
2807: ,p_privilege_predicate_api_name => 'EGO_ITEM_USER_ATTRS_CP_PUB.Get_Item_Security_Predicate' --IN VARCHAR2
2808: ,p_related_class_codes_query => l_related_class_codes_query --IN VARCHAR2
2809: ,p_validate => FALSE
2810: ,p_do_dml => TRUE
2811: ,p_do_req_def_valiadtion => TRUE --Doing this validation here since the value may have come from template
2841: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2842: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
2843: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2
2844: ,p_default_edit_privilege => 'EGO_EDIT_ITEM' --IN VARCHAR2
2845: ,p_privilege_predicate_api_name => 'EGO_ITEM_USER_ATTRS_CP_PUB.Get_Item_Security_Predicate' --IN VARCHAR2
2846: ,p_related_class_codes_query => l_related_class_codes_query --IN VARCHAR2
2847: ,p_validate => FALSE
2848: ,p_do_dml => TRUE
2849: ,p_do_req_def_valiadtion => TRUE --Doing this validation here since the value may have come from template
2879: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2880: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
2881: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2
2882: ,p_default_edit_privilege => 'EGO_EDIT_ITEM' --IN VARCHAR2
2883: ,p_privilege_predicate_api_name => 'EGO_ITEM_USER_ATTRS_CP_PUB.Get_Item_Security_Predicate' --IN VARCHAR2
2884: ,p_related_class_codes_query => l_related_class_codes_query --IN VARCHAR2
2885: ,p_validate => FALSE
2886: ,p_do_dml => TRUE
2887: ,p_do_req_def_valiadtion => TRUE --Doing this validation here since the value may have come from template
3147: ,p_tables_application_id => 431
3148: ,p_change_line_id => p_change_line_id
3149: ,p_old_data_level_nv_pairs => l_old_data_level_nv_pairs
3150: ,p_new_data_level_nv_pairs => l_new_data_level_nv_pairs
3151: ,p_related_class_code_function => 'EGO_ITEM_USER_ATTRS_CP_PUB.Get_Related_Class_Codes'
3152: ,p_init_msg_list => p_init_msg_list
3153: ,p_commit => p_commit
3154: ,x_return_status => x_return_status
3155: ,x_errorcode => x_errorcode
3627: END Copy_data_to_Intf;
3628:
3629: ----------------------------------------------------------------------
3630:
3631: END EGO_ITEM_USER_ATTRS_CP_PUB;