APPS.EGO_ICC_BULKLOAD_PVT dependencies on EGO_USER_V

Line 4650: l_user_name ego_user_v.party_name%TYPE;

4646: l_return_status VARCHAR2(1);
4647: l_return_status2 VARCHAR2(1);
4648: l_locking_party_id NUMBER;
4649: l_lock_flag ego_object_lock.lock_flag%TYPE;
4650: l_user_name ego_user_v.party_name%TYPE;
4651:
4652:
4653: -- for error logging
4654: --

Line 5395: l_party_id ego_user_v.party_id%TYPE := null;

5391: FUNCTION Get_party_id ( p_user_id IN NUMBER)
5392: RETURN NUMBER
5393: IS
5394:
5395: l_party_id ego_user_v.party_id%TYPE := null;
5396:
5397: BEGIN
5398:
5399: SELECT party_id

Line 5401: from ego_user_v

5397: BEGIN
5398:
5399: SELECT party_id
5400: INTO l_party_id
5401: from ego_user_v
5402: where user_id = p_user_id;
5403:
5404: return l_party_id;
5405:

Line 5411: from ego_user_v

5407: WHEN OTHERS THEN
5408: -- defaulting to MFG
5409: SELECT party_id
5410: INTO l_party_id
5411: from ego_user_v
5412: where user_name = G_DEFAULT_USER_NAME;
5413: return l_party_id;
5414: END Get_party_id;
5415:

Line 5433: l_party_id ego_user_v.party_id%type;

5429: l_msg_name fnd_new_messages.message_name%TYPE := null;
5430: l_msg_text fnd_new_messages.message_text%TYPE := null;
5431: l_obj_name VARCHAR2(30) := 'EGO_ITEM_CATALOG_CATEGORY';
5432: l_sysdate DATE;
5433: l_party_id ego_user_v.party_id%type;
5434:
5435: BEGIN
5436: write_debug(l_proc_name, 'Start ');
5437: x_return_status := G_RET_STS_SUCCESS;