APPS.IGS_DA_SETUP_PKG dependencies on IGS_DA_SETUP

Line 1: PACKAGE BODY igs_da_setup_pkg AS

1: PACKAGE BODY igs_da_setup_pkg AS
2: /* $Header: IGSKI40B.pls 120.1 2005/09/28 02:23:01 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_da_setup%ROWTYPE;

Line 5: old_references igs_da_setup%ROWTYPE;

1: PACKAGE BODY igs_da_setup_pkg AS
2: /* $Header: IGSKI40B.pls 120.1 2005/09/28 02:23:01 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_da_setup%ROWTYPE;
6: new_references igs_da_setup%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_da_setup%ROWTYPE;

2: /* $Header: IGSKI40B.pls 120.1 2005/09/28 02:23:01 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_da_setup%ROWTYPE;
6: new_references igs_da_setup%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 44: FROM igs_da_setup

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

Line 180: FROM igs_da_setup

176: || (reverse chronological order - newest change first)
177: */
178: CURSOR cur_rowid IS
179: SELECT rowid
180: FROM igs_da_setup
181: WHERE s_control_num = x_s_control_num
182: FOR UPDATE NOWAIT;
183:
184: lv_rowid cur_rowid%RowType;

Line 214: FROM igs_da_setup

210: || (reverse chronological order - newest change first)
211: */
212: CURSOR cur_rowid IS
213: SELECT rowid
214: FROM igs_da_setup
215: WHERE ((wif_major_unit_set_cat = x_unit_set_cat))
216: OR ((wif_minor_unit_set_cat = x_unit_set_cat))
217: OR ((wif_track_unit_set_cat = x_unit_set_cat));
218:

Line 251: FROM igs_da_setup

247: || (reverse chronological order - newest change first)
248: */
249: CURSOR cur_rowid IS
250: SELECT rowid
251: FROM igs_da_setup
252: WHERE ((default_inst_id_type = x_org_alternate_id_type));
253:
254: lv_rowid cur_rowid%RowType;
255:

Line 412: fnd_message.set_token ('ROUTINE', 'IGS_DA_SETUP_PKG.INSERT_ROW');

408: x_last_update_login := -1;
409: END IF;
410: ELSE
411: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
412: fnd_message.set_token ('ROUTINE', 'IGS_DA_SETUP_PKG.INSERT_ROW');
413: igs_ge_msg_stack.add;
414: app_exception.raise_exception;
415: END IF;
416:

Line 442: INSERT INTO igs_da_setup (

438: x_last_updated_by => x_last_updated_by,
439: x_last_update_login => x_last_update_login
440: );
441:
442: INSERT INTO igs_da_setup (
443: s_control_num,
444: program_definition_ind,
445: default_student_id_type,
446: default_inst_id_type,

Line 532: FROM igs_da_setup

528: display_container_ind,
529: container_title,
530: link_text,
531: link_url
532: FROM igs_da_setup
533: WHERE rowid = x_rowid
534: FOR UPDATE NOWAIT;
535:
536: tlinfo c1%ROWTYPE;

Line 628: fnd_message.set_token ('ROUTINE', 'IGS_DA_SETUP_PKG.UPDATE_ROW');

624: x_last_update_login := -1;
625: END IF;
626: ELSE
627: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
628: fnd_message.set_token ('ROUTINE', 'IGS_DA_SETUP_PKG.UPDATE_ROW');
629: igs_ge_msg_stack.add;
630: app_exception.raise_exception;
631: END IF;
632:

Line 658: UPDATE igs_da_setup

654: x_last_updated_by => x_last_updated_by,
655: x_last_update_login => x_last_update_login
656: );
657:
658: UPDATE igs_da_setup
659: SET
660: program_definition_ind = new_references.program_definition_ind,
661: default_student_id_type = new_references.default_student_id_type,
662: default_inst_id_type = new_references.default_inst_id_type,

Line 716: FROM igs_da_setup

712: || (reverse chronological order - newest change first)
713: */
714: CURSOR c1 IS
715: SELECT rowid
716: FROM igs_da_setup
717: WHERE s_control_num = x_s_control_num;
718:
719: BEGIN
720:

Line 791: DELETE FROM igs_da_setup

787: p_action => 'DELETE',
788: x_rowid => x_rowid
789: );
790:
791: DELETE FROM igs_da_setup
792: WHERE rowid = x_rowid;
793:
794: IF (SQL%NOTFOUND) THEN
795: RAISE NO_DATA_FOUND;

Line 801: END igs_da_setup_pkg;

797:
798: END delete_row;
799:
800:
801: END igs_da_setup_pkg;