APPS.EGO_OBJ_TYPE_LIFECYCLES_PUB dependencies on EGO_OBJ_TYPE_LIFECYCLES

Line 1: PACKAGE BODY EGO_OBJ_TYPE_LIFECYCLES_PUB AS

1: PACKAGE BODY EGO_OBJ_TYPE_LIFECYCLES_PUB AS
2: /* $Header: EGOPOTLB.pls 115.2 2002/12/19 08:34:15 wwahid noship $ */
3:
4: -- ------------------------------------------------------------
5: -- -------------- Global variables and constants --------------

Line 8: g_pkg_name VARCHAR2(30) := 'EGO_OBJ_TYPE_LIFECYCLES_PUB';

4: -- ------------------------------------------------------------
5: -- -------------- Global variables and constants --------------
6: -- ------------------------------------------------------------
7:
8: g_pkg_name VARCHAR2(30) := 'EGO_OBJ_TYPE_LIFECYCLES_PUB';
9: g_current_user_id NUMBER := EGO_SCTX.Get_User_Id();
10: g_current_login_id NUMBER := FND_GLOBAL.Login_Id;
11:
12: G_DUPLICATE_EXCEPTION EXCEPTION;

Line 70: EGO_OBJ_TYPE_LIFECYCLES

66: -- Check if the obj_type_lifecycle already exists
67:
68: SELECT COUNT (*) INTO l_count
69: FROM
70: EGO_OBJ_TYPE_LIFECYCLES
71: WHERE
72: OBJECT_ID = p_object_id
73: AND OBJECT_CLASSIFICATION_CODE = p_object_classification_code
74: AND LIFECYCLE_ID = p_lifecycle_id;

Line 81: INSERT INTO EGO_OBJ_TYPE_LIFECYCLES

77: THEN
78: RAISE G_DUPLICATE_EXCEPTION;
79: END IF;
80:
81: INSERT INTO EGO_OBJ_TYPE_LIFECYCLES
82: (
83: OBJECT_ID
84: , OBJECT_CLASSIFICATION_CODE
85: , LIFECYCLE_ID

Line 226: DELETE FROM EGO_OBJ_TYPE_LIFECYCLES

222:
223: -----------------------------------
224:
225:
226: DELETE FROM EGO_OBJ_TYPE_LIFECYCLES
227: WHERE
228: OBJECT_ID = p_object_id
229: AND OBJECT_CLASSIFICATION_CODE = p_object_classification_code
230: AND LIFECYCLE_ID = p_lifecycle_id;

Line 274: END EGO_OBJ_TYPE_LIFECYCLES_PUB;

270: END Delete_Obj_Type_Lifecycle;
271:
272: ----------------------------------------------------------------------
273:
274: END EGO_OBJ_TYPE_LIFECYCLES_PUB;