APPS.IGS_UC_REF_OFF_ABRV_PKG dependencies on IGS_UC_REF_OFF_ABRV

Line 1: PACKAGE BODY igs_uc_ref_off_abrv_pkg AS

1: PACKAGE BODY igs_uc_ref_off_abrv_pkg AS
2: /* $Header: IGSXI30B.pls 120.1 2005/07/31 20:35:43 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_ref_off_abrv%ROWTYPE;

Line 5: old_references igs_uc_ref_off_abrv%ROWTYPE;

1: PACKAGE BODY igs_uc_ref_off_abrv_pkg AS
2: /* $Header: IGSXI30B.pls 120.1 2005/07/31 20:35:43 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_ref_off_abrv%ROWTYPE;
6: new_references igs_uc_ref_off_abrv%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_uc_ref_off_abrv%ROWTYPE;

2: /* $Header: IGSXI30B.pls 120.1 2005/07/31 20:35:43 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_ref_off_abrv%ROWTYPE;
6: new_references igs_uc_ref_off_abrv%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 43: FROM IGS_UC_REF_OFF_ABRV

39: */
40:
41: CURSOR cur_old_ref_values IS
42: SELECT *
43: FROM IGS_UC_REF_OFF_ABRV
44: WHERE rowid = x_rowid;
45:
46: BEGIN
47:

Line 103: igs_uc_cond_details_pkg.get_fk_igs_uc_ref_off_abrv (

99: || (reverse chronological order - newest change first)
100: */
101: BEGIN
102:
103: igs_uc_cond_details_pkg.get_fk_igs_uc_ref_off_abrv (
104: old_references.abbrev_code
105: );
106:
107: END check_child_existance;

Line 123: FROM igs_uc_ref_off_abrv

119: || (reverse chronological order - newest change first)
120: */
121: CURSOR cur_rowid IS
122: SELECT rowid
123: FROM igs_uc_ref_off_abrv
124: WHERE abbrev_code = x_abbrev_code ;
125:
126: lv_rowid cur_rowid%RowType;
127:

Line 259: FROM igs_uc_ref_off_abrv

255: || smaddali 30-apr-2002 added NVL(summary_char, ' ') in insert dml for bug# 2335790
256: */
257: CURSOR c IS
258: SELECT rowid
259: FROM igs_uc_ref_off_abrv
260: WHERE abbrev_code = x_abbrev_code;
261:
262: x_last_update_date DATE;
263: x_last_updated_by NUMBER;

Line 287: /* SELECT igs_uc_ref_off_abrv_s.NEXTVAL

283: igs_ge_msg_stack.add;
284: app_exception.raise_exception;
285: END IF;
286:
287: /* SELECT igs_uc_ref_off_abrv_s.NEXTVAL
288: INTO x_abbrev_code
289: FROM dual;
290: */
291: before_dml(

Line 313: INSERT INTO igs_uc_ref_off_abrv (

309: x_last_update_login => x_last_update_login,
310: x_tariff => x_tariff
311: );
312:
313: INSERT INTO igs_uc_ref_off_abrv (
314: abbrev_code,
315: uv_updater,
316: abbrev_text,
317: letter_format,

Line 403: FROM igs_uc_ref_off_abrv

399: imported,
400: sent_to_ucas,
401: deleted,
402: tariff
403: FROM igs_uc_ref_off_abrv
404: WHERE rowid = x_rowid
405: FOR UPDATE NOWAIT;
406:
407: tlinfo c1%ROWTYPE;

Line 523: UPDATE igs_uc_ref_off_abrv

519: x_last_update_login => x_last_update_login,
520: x_tariff => x_tariff
521: );
522:
523: UPDATE igs_uc_ref_off_abrv
524: SET
525: uv_updater = new_references.uv_updater,
526: abbrev_text = new_references.abbrev_text,
527: letter_format = new_references.letter_format,

Line 577: FROM igs_uc_ref_off_abrv

573:
574: */
575: CURSOR c1 IS
576: SELECT rowid
577: FROM igs_uc_ref_off_abrv
578: WHERE abbrev_code = x_abbrev_code;
579:
580: BEGIN
581:

Line 646: DELETE FROM igs_uc_ref_off_abrv

642: p_action => 'DELETE',
643: x_rowid => x_rowid
644: );
645:
646: DELETE FROM igs_uc_ref_off_abrv
647: WHERE rowid = x_rowid;
648:
649: IF (SQL%NOTFOUND) THEN
650: RAISE NO_DATA_FOUND;

Line 656: END igs_uc_ref_off_abrv_pkg;

652:
653: END delete_row;
654:
655:
656: END igs_uc_ref_off_abrv_pkg;