[Home] [Help]
1: PACKAGE BODY EGO_ITEM_USER_ATTRS_CP_PUB AS
2: /* $Header: EGOCIUAB.pls 120.80.12020000.6 2012/09/28 10:37:49 jewen 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:
2965:
2966: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting User Attributes Bulk Load', 1);
2967:
2968: IF p_validate_only = FND_API.G_TRUE AND p_ignore_security_for_validate = FND_API.G_FALSE THEN
2969: l_privilege_predicate_api_name := 'EGO_ITEM_USER_ATTRS_CP_PUB.Get_Item_Security_Predicate';
2970: ELSE
2971: l_privilege_predicate_api_name := NULL;
2972: END IF;
2973:
3540: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3541: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2
3542: ,p_default_dl_view_priv_list => l_default_dl_view_priv_list
3543: ,p_default_dl_edit_priv_list => l_default_dl_edit_priv_list
3544: ,p_privilege_predicate_api_name => 'EGO_ITEM_USER_ATTRS_CP_PUB.Get_Item_Security_Predicate' --IN VARCHAR2
3545: ,p_related_class_codes_query => l_related_class_codes_query --IN VARCHAR2
3546: ,p_validate => FALSE
3547: ,p_do_dml => TRUE
3548: ,p_do_req_def_valiadtion => FALSE -- Fix for bug#9336604 TRUE --Doing this validation here since the value may have come from template
3579: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3580: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2
3581: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2
3582: ,p_default_edit_privilege => 'EGO_EDIT_ITEM' --IN VARCHAR2
3583: ,p_privilege_predicate_api_name => 'EGO_ITEM_USER_ATTRS_CP_PUB.Get_Item_Security_Predicate' --IN VARCHAR2
3584: ,p_related_class_codes_query => l_related_class_codes_query --IN VARCHAR2
3585: ,p_validate => FALSE
3586: ,p_do_dml => TRUE
3587: ,p_do_req_def_valiadtion => TRUE --Doing this validation here since the value may have come from template
3619: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3620: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2
3621: ,p_default_view_privilege => 'EGO_VIEW_ITEM' --IN VARCHAR2
3622: ,p_default_edit_privilege => 'EGO_EDIT_ITEM' --IN VARCHAR2
3623: ,p_privilege_predicate_api_name => 'EGO_ITEM_USER_ATTRS_CP_PUB.Get_Item_Security_Predicate' --IN VARCHAR2
3624: ,p_related_class_codes_query => l_related_class_codes_query --IN VARCHAR2
3625: ,p_validate => FALSE
3626: ,p_do_dml => TRUE
3627: ,p_do_req_def_valiadtion => TRUE --Doing this validation here since the value may have come from template
3889: ,p_tables_application_id => 431
3890: ,p_change_line_id => p_change_line_id
3891: ,p_old_data_level_nv_pairs => l_old_data_level_nv_pairs
3892: ,p_new_data_level_nv_pairs => l_new_data_level_nv_pairs
3893: ,p_related_class_code_function => 'EGO_ITEM_USER_ATTRS_CP_PUB.Get_Related_Class_Codes'
3894: ,p_init_msg_list => p_init_msg_list
3895: ,p_commit => p_commit
3896: ,x_return_status => x_return_status
3897: ,x_errorcode => x_errorcode
4395: END Copy_data_to_Intf;
4396:
4397: ----------------------------------------------------------------------
4398:
4399: END EGO_ITEM_USER_ATTRS_CP_PUB;