APPS.JL_ZZ_GL_AXI_MODEL_RANGES_PKG dependencies on JL_ZZ_GL_AXI_MODEL_RANGES

Line 1: PACKAGE BODY JL_ZZ_GL_AXI_MODEL_RANGES_PKG AS

1: PACKAGE BODY JL_ZZ_GL_AXI_MODEL_RANGES_PKG AS
2: /* $Header: jlzzgmrb.pls 115.1 2002/11/13 23:55:46 vsidhart ship $ */
3: ------------------------------------------------------------
4: -- Insert row procedure --
5: ------------------------------------------------------------

Line 97: FROM jl_zz_gl_axi_model_ranges

93: -- Main cursor --
94: ------------------------------------------------------------
95: CURSOR C IS
96: SELECT ROWID
97: FROM jl_zz_gl_axi_model_ranges
98: WHERE model_id = p_model_id;
99:
100: current_calling_sequence VARCHAR2(2000);
101: debug_info VARCHAR2(100);

Line 105: current_calling_sequence := 'JL_ZZ_GL_AXI_MODEL_RANGES_PKG.INSERT_ROW <-' ||

101: debug_info VARCHAR2(100);
102:
103: BEGIN
104:
105: current_calling_sequence := 'JL_ZZ_GL_AXI_MODEL_RANGES_PKG.INSERT_ROW <-' ||
106: p_calling_sequence;
107:
108: debug_info := 'INSERT INTO JL_ZZ_GL_AXI_MODEL_RANGES';
109:

Line 108: debug_info := 'INSERT INTO JL_ZZ_GL_AXI_MODEL_RANGES';

104:
105: current_calling_sequence := 'JL_ZZ_GL_AXI_MODEL_RANGES_PKG.INSERT_ROW <-' ||
106: p_calling_sequence;
107:
108: debug_info := 'INSERT INTO JL_ZZ_GL_AXI_MODEL_RANGES';
109:
110: INSERT INTO jl_zz_gl_axi_model_ranges
111: ( model_id
112: , last_update_date

Line 110: INSERT INTO jl_zz_gl_axi_model_ranges

106: p_calling_sequence;
107:
108: debug_info := 'INSERT INTO JL_ZZ_GL_AXI_MODEL_RANGES';
109:
110: INSERT INTO jl_zz_gl_axi_model_ranges
111: ( model_id
112: , last_update_date
113: , last_updated_by
114: , creation_date

Line 403: current_calling_sequence := 'JL_ZZ_GL_AXI_MODEL_RANGES_PKG.UPDATE_ROW <-' ||

399: current_calling_sequence VARCHAR2(2000);
400: debug_info VARCHAR2(100);
401:
402: BEGIN
403: current_calling_sequence := 'JL_ZZ_GL_AXI_MODEL_RANGES_PKG.UPDATE_ROW <-' ||
404: p_calling_sequence;
405:
406: debug_info := 'UPDATE JL_ZZ_GL_AXI_MODEL_RANGES';
407:

Line 406: debug_info := 'UPDATE JL_ZZ_GL_AXI_MODEL_RANGES';

402: BEGIN
403: current_calling_sequence := 'JL_ZZ_GL_AXI_MODEL_RANGES_PKG.UPDATE_ROW <-' ||
404: p_calling_sequence;
405:
406: debug_info := 'UPDATE JL_ZZ_GL_AXI_MODEL_RANGES';
407:
408: UPDATE jl_zz_gl_axi_model_ranges
409: SET model_id = p_model_id
410: , last_update_date = p_last_update_date

Line 408: UPDATE jl_zz_gl_axi_model_ranges

404: p_calling_sequence;
405:
406: debug_info := 'UPDATE JL_ZZ_GL_AXI_MODEL_RANGES';
407:
408: UPDATE jl_zz_gl_axi_model_ranges
409: SET model_id = p_model_id
410: , last_update_date = p_last_update_date
411: , last_updated_by = p_last_updated_by
412: , creation_date = p_creation_date

Line 521: current_calling_sequence := 'JL_ZZ_GL_AXI_MODEL_RANGES_PKG.DELETE_ROW <-' ||

517: current_calling_sequence VARCHAR2(2000);
518: debug_info VARCHAR2(100);
519:
520: BEGIN
521: current_calling_sequence := 'JL_ZZ_GL_AXI_MODEL_RANGES_PKG.DELETE_ROW <-' ||
522: p_calling_sequence;
523:
524: debug_info := 'DELETE FROM JL_ZZ_GL_AXI_MODEL_RANGES';
525:

Line 524: debug_info := 'DELETE FROM JL_ZZ_GL_AXI_MODEL_RANGES';

520: BEGIN
521: current_calling_sequence := 'JL_ZZ_GL_AXI_MODEL_RANGES_PKG.DELETE_ROW <-' ||
522: p_calling_sequence;
523:
524: debug_info := 'DELETE FROM JL_ZZ_GL_AXI_MODEL_RANGES';
525:
526: DELETE FROM jl_zz_gl_axi_model_ranges
527: WHERE rowid = P_Rowid;
528:

Line 526: DELETE FROM jl_zz_gl_axi_model_ranges

522: p_calling_sequence;
523:
524: debug_info := 'DELETE FROM JL_ZZ_GL_AXI_MODEL_RANGES';
525:
526: DELETE FROM jl_zz_gl_axi_model_ranges
527: WHERE rowid = P_Rowid;
528:
529: IF (SQL%NOTFOUND) THEN
530: RAISE NO_DATA_FOUND;

Line 546: END JL_ZZ_GL_AXI_MODEL_RANGES_PKG;

542:
543: app_exception.raise_exception;
544: END delete_row;
545:
546: END JL_ZZ_GL_AXI_MODEL_RANGES_PKG;