DBA Data[Home] [Help]

APPS.JL_CO_GL_NIT_ACCTS_PKG dependencies on JL_CO_GL_NIT_ACCTS

Line 1: PACKAGE BODY JL_CO_GL_NIT_ACCTS_PKG as

1: PACKAGE BODY JL_CO_GL_NIT_ACCTS_PKG as
2: /* $Header: jlcoglab.pls 115.1 2002/03/01 16:54:21 pkm ship $ */
3:
4: PROCEDURE Lock_Row(
5: X_rowid VARCHAR2,

Line 57: FROM jl_co_gl_nit_accts

53: ATTRIBUTE12,
54: ATTRIBUTE13,
55: ATTRIBUTE14,
56: ATTRIBUTE15
57: FROM jl_co_gl_nit_accts
58: WHERE chart_of_accounts_id = X_chart_of_accounts_id
59: AND flex_value_id = X_flex_value_id
60: FOR UPDATE of nit_required
61: NOWAIT;

Line 182: UPDATE jl_co_gl_nit_accts

178: X_attribute15 VARCHAR2
179: ) IS
180:
181: BEGIN
182: UPDATE jl_co_gl_nit_accts
183: SET chart_of_accounts_id = X_chart_of_accounts_id,
184: flex_value_id = X_flex_value_id,
185: account_code = X_account_code,
186: nit_required = X_nit_required,

Line 221: FROM jl_co_gl_nit_accts

217: PROCEDURE Delete_Row( X_rowid VARCHAR2
218: ) IS
219: BEGIN
220: DELETE
221: FROM jl_co_gl_nit_accts
222: WHERE rowid = X_rowid;
223:
224: IF (SQL%NOTFOUND)
225: THEN

Line 230: END JL_CO_GL_NIT_ACCTS_PKG;

226: raise NO_DATA_FOUND;
227: END IF;
228: END Delete_Row;
229:
230: END JL_CO_GL_NIT_ACCTS_PKG;