APPS.JL_ZZ_GL_AXI_MODELS_PKG dependencies on JL_ZZ_GL_AXI_MODELS

Line 1: PACKAGE BODY JL_ZZ_GL_AXI_MODELS_PKG AS

1: PACKAGE BODY JL_ZZ_GL_AXI_MODELS_PKG AS
2: /* $Header: jlzzgamb.pls 115.1 2002/11/13 23:56:24 vsidhart ship $ */
3:
4: ------------------------------------------------------------
5: -- Insert row procedure --

Line 37: FROM jl_zz_gl_axi_models

33: , p_calling_sequence IN VARCHAR2) IS
34:
35: CURSOR c IS
36: SELECT ROWID
37: FROM jl_zz_gl_axi_models
38: WHERE model_id = p_model_id;
39:
40: current_calling_sequence VARCHAR2(2000);
41: debug_info VARCHAR2(100);

Line 45: current_calling_sequence := 'JL_ZZ_GL_AXI_MODELS_PKG.INSERT_ROW <-' ||

41: debug_info VARCHAR2(100);
42:
43: BEGIN
44:
45: current_calling_sequence := 'JL_ZZ_GL_AXI_MODELS_PKG.INSERT_ROW <-' ||
46: p_CALLING_SEQUENCE;
47:
48: debug_info := 'INSERT INTO JL_ZZ_GL_AXI_MODELS';
49:

Line 48: debug_info := 'INSERT INTO JL_ZZ_GL_AXI_MODELS';

44:
45: current_calling_sequence := 'JL_ZZ_GL_AXI_MODELS_PKG.INSERT_ROW <-' ||
46: p_CALLING_SEQUENCE;
47:
48: debug_info := 'INSERT INTO JL_ZZ_GL_AXI_MODELS';
49:
50: INSERT INTO jl_zz_gl_axi_models
51: (model_id
52: , name

Line 50: INSERT INTO jl_zz_gl_axi_models

46: p_CALLING_SEQUENCE;
47:
48: debug_info := 'INSERT INTO JL_ZZ_GL_AXI_MODELS';
49:
50: INSERT INTO jl_zz_gl_axi_models
51: (model_id
52: , name
53: , description
54: , last_update_date

Line 168: current_calling_sequence := 'JL_ZZ_GL_AXI_MODELS_PKG.UPDATE_ROW <-' ||

164: current_calling_sequence VARCHAR2(2000);
165: debug_info VARCHAR2(100);
166:
167: BEGIN
168: current_calling_sequence := 'JL_ZZ_GL_AXI_MODELS_PKG.UPDATE_ROW <-' ||
169: p_calling_sequence;
170: debug_info := 'UPDATE JL_ZZ_GL_AXI_MODELS';
171:
172: UPDATE jl_zz_gl_axi_models

Line 170: debug_info := 'UPDATE JL_ZZ_GL_AXI_MODELS';

166:
167: BEGIN
168: current_calling_sequence := 'JL_ZZ_GL_AXI_MODELS_PKG.UPDATE_ROW <-' ||
169: p_calling_sequence;
170: debug_info := 'UPDATE JL_ZZ_GL_AXI_MODELS';
171:
172: UPDATE jl_zz_gl_axi_models
173: SET model_id = p_model_id
174: , name = p_name

Line 172: UPDATE jl_zz_gl_axi_models

168: current_calling_sequence := 'JL_ZZ_GL_AXI_MODELS_PKG.UPDATE_ROW <-' ||
169: p_calling_sequence;
170: debug_info := 'UPDATE JL_ZZ_GL_AXI_MODELS';
171:
172: UPDATE jl_zz_gl_axi_models
173: SET model_id = p_model_id
174: , name = p_name
175: , description = p_description
176: , last_update_date = p_last_update_date

Line 231: current_calling_sequence := 'JL_ZZ_GL_AXI_MODELS_PKG.DELETE_ROW<-' ||

227: CURSOR c1 IS SELECT rowid
228: FROM jl_zz_gl_axi_model_ranges
229: WHERE model_id = p_model_id;
230: BEGIN
231: current_calling_sequence := 'JL_ZZ_GL_AXI_MODELS_PKG.DELETE_ROW<-' ||
232: p_calling_sequence;
233:
234: debug_info := 'DELETE FROM JL_ZZ_GL_AXI_MODELS';
235:

Line 234: debug_info := 'DELETE FROM JL_ZZ_GL_AXI_MODELS';

230: BEGIN
231: current_calling_sequence := 'JL_ZZ_GL_AXI_MODELS_PKG.DELETE_ROW<-' ||
232: p_calling_sequence;
233:
234: debug_info := 'DELETE FROM JL_ZZ_GL_AXI_MODELS';
235:
236: DELETE FROM jl_zz_gl_axi_models
237: WHERE rowid = p_rowid;
238: FOR c1_rec IN c1 LOOP

Line 236: DELETE FROM jl_zz_gl_axi_models

232: p_calling_sequence;
233:
234: debug_info := 'DELETE FROM JL_ZZ_GL_AXI_MODELS';
235:
236: DELETE FROM jl_zz_gl_axi_models
237: WHERE rowid = p_rowid;
238: FOR c1_rec IN c1 LOOP
239: jl_zz_gl_axi_model_ranges_pkg.delete_row(c1_rec.rowid,'JLZZGAAM');
240: END LOOP;

Line 259: END JL_ZZ_GL_AXI_MODELS_PKG;

255:
256: app_exception.raise_exception;
257: END Delete_Row;
258:
259: END JL_ZZ_GL_AXI_MODELS_PKG;