APPS.OKC_K_ENTITY_LOCKS_PKG dependencies on OKC_K_ENTITY_LOCKS

Line 1: PACKAGE BODY okc_k_entity_locks_pkg

1: PACKAGE BODY okc_k_entity_locks_pkg
2: /* $Header: OKCVELKB.pls 120.0 2011/12/09 11:11:10 serukull noship $ */
3:
4: AS
5:

Line 15: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_K_ENTITY_LOCKS_PKG';

11: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
12: ---------------------------------------------------------------------------
13: -- GLOBAL VARIABLES
14: ---------------------------------------------------------------------------
15: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_K_ENTITY_LOCKS_PKG';
16: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
17:
18: ------------------------------------------------------------------------------
19: -- GLOBAL CONSTANTS

Line 71: INSERT INTO okc_k_entity_locks(

67: G_PKG_NAME, '1000: Entered Insert_Row Procedure' );
68: END IF;
69:
70:
71: INSERT INTO okc_k_entity_locks(
72: k_entity_lock_id,
73: entity_name,
74: entity_pk1,
75: entity_pk2,

Line 90: okc_k_entity_locks_s.NEXTVAL,

86: LAST_UPDATE_DATE,
87: LAST_UPDATE_LOGIN
88: )
89: VALUES(
90: okc_k_entity_locks_s.NEXTVAL,
91: P_ENTITY_NAME,
92: p_entity_pk1,
93: p_entity_pk2,
94: p_entity_pk3,

Line 166: l_del_Sql := 'DELETE FROM OKC_K_ENTITY_LOCKS WHERE ENTITY_NAME = P_ENTITY_NAME AND ENTITY_PK1 = '|| ''''||p_entity_pk1 ||'''';

162: FND_LOG.STRING(G_STMT_LEVEL, G_PKG_NAME, '0100: p_LOCK_by_document_id '||p_LOCK_by_document_id);
163: END IF;
164:
165:
166: l_del_Sql := 'DELETE FROM OKC_K_ENTITY_LOCKS WHERE ENTITY_NAME = P_ENTITY_NAME AND ENTITY_PK1 = '|| ''''||p_entity_pk1 ||'''';
167:
168: IF p_entity_pk2 IS NOT NULL THEN
169: l_del_Sql := l_del_Sql || ' AND ENTITY_PK2 = '|| ''''||p_entity_pk2||'''';
170: END IF;

Line 220: END okc_k_entity_locks_pkg;

216: X_RETURN_STATUS := G_RET_STS_UNEXP_ERROR;
217: --FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
218: END DELETE_row;
219:
220: END okc_k_entity_locks_pkg;