APPS.IGS_AS_ENTRY_CONF_PKG dependencies on IGS_AS_ENTRY_CONF

Line 1: PACKAGE BODY igs_as_entry_conf_pkg AS

1: PACKAGE BODY igs_as_entry_conf_pkg AS
2: /* $Header: IGSDI46B.pls 115.11 2003/12/05 11:02:13 kdande ship $ */
3: l_rowid VARCHAR2 (25);
4: old_references igs_as_entry_conf%ROWTYPE;
5: new_references igs_as_entry_conf%ROWTYPE;

Line 4: old_references igs_as_entry_conf%ROWTYPE;

1: PACKAGE BODY igs_as_entry_conf_pkg AS
2: /* $Header: IGSDI46B.pls 115.11 2003/12/05 11:02:13 kdande ship $ */
3: l_rowid VARCHAR2 (25);
4: old_references igs_as_entry_conf%ROWTYPE;
5: new_references igs_as_entry_conf%ROWTYPE;
6:
7: PROCEDURE set_column_values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_as_entry_conf%ROWTYPE;

1: PACKAGE BODY igs_as_entry_conf_pkg AS
2: /* $Header: IGSDI46B.pls 115.11 2003/12/05 11:02:13 kdande ship $ */
3: l_rowid VARCHAR2 (25);
4: old_references igs_as_entry_conf%ROWTYPE;
5: new_references igs_as_entry_conf%ROWTYPE;
6:
7: PROCEDURE set_column_values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2,

Line 42: FROM igs_as_entry_conf

38: x_key_ai_mark_entry_dec_points IN NUMBER
39: ) AS
40: CURSOR cur_old_ref_values IS
41: SELECT *
42: FROM igs_as_entry_conf
43: WHERE ROWID = x_rowid;
44: BEGIN
45: l_rowid := x_rowid;
46: -- Code for setting the Old and New Reference Values.

Line 100: FROM igs_as_entry_conf

96: FUNCTION get_pk_for_validation (x_s_control_num IN NUMBER)
97: RETURN BOOLEAN AS
98: CURSOR cur_rowid IS
99: SELECT ROWID
100: FROM igs_as_entry_conf
101: WHERE s_control_num = x_s_control_num
102: FOR UPDATE NOWAIT;
103: lv_rowid cur_rowid%ROWTYPE;
104: BEGIN

Line 499: FROM igs_as_entry_conf

495: x_key_ai_mark_entry_dec_points IN NUMBER
496: ) AS
497: CURSOR c IS
498: SELECT ROWID
499: FROM igs_as_entry_conf
500: WHERE s_control_num = x_s_control_num;
501: x_last_update_date DATE;
502: x_last_updated_by NUMBER;
503: x_last_update_login NUMBER;

Line 556: INSERT INTO igs_as_entry_conf

552: x_key_ai_grade_derive_flag => x_key_ai_grade_derive_flag,
553: x_key_ai_allow_invalid_flag => x_key_ai_allow_invalid_flag,
554: x_key_ai_mark_entry_dec_points => x_key_ai_mark_entry_dec_points
555: );
556: INSERT INTO igs_as_entry_conf
557: (s_control_num,
558: key_allow_invalid_ind,
559: key_collect_mark_ind,
560: key_grade_derive_ind,

Line 668: FROM igs_as_entry_conf

664: key_ai_mark_mndtry_flag,
665: key_ai_grade_derive_flag,
666: key_ai_allow_invalid_flag,
667: key_ai_mark_entry_dec_points
668: FROM igs_as_entry_conf
669: WHERE ROWID = x_rowid
670: FOR UPDATE NOWAIT;
671: tlinfo c1%ROWTYPE;
672: BEGIN

Line 851: UPDATE igs_as_entry_conf

847: x_key_ai_grade_derive_flag => x_key_ai_grade_derive_flag,
848: x_key_ai_allow_invalid_flag => x_key_ai_allow_invalid_flag,
849: x_key_ai_mark_entry_dec_points => x_key_ai_mark_entry_dec_points
850: );
851: UPDATE igs_as_entry_conf
852: SET key_allow_invalid_ind = new_references.key_allow_invalid_ind,
853: key_collect_mark_ind = new_references.key_collect_mark_ind,
854: key_grade_derive_ind = new_references.key_grade_derive_ind,
855: key_mark_mndtry_ind = new_references.key_mark_mndtry_ind,

Line 914: FROM igs_as_entry_conf

910: x_key_ai_mark_entry_dec_points IN NUMBER
911: ) AS
912: CURSOR c1 IS
913: SELECT ROWID
914: FROM igs_as_entry_conf
915: WHERE s_control_num = x_s_control_num;
916: BEGIN
917: OPEN c1;
918: FETCH c1 INTO x_rowid;

Line 988: DELETE FROM igs_as_entry_conf

984: before_dml (
985: p_action => 'DELETE',
986: x_rowid => x_rowid
987: );
988: DELETE FROM igs_as_entry_conf
989: WHERE ROWID = x_rowid;
990:
991: IF (SQL%NOTFOUND) THEN
992: RAISE NO_DATA_FOUND;

Line 995: END igs_as_entry_conf_pkg;

991: IF (SQL%NOTFOUND) THEN
992: RAISE NO_DATA_FOUND;
993: END IF;
994: END delete_row;
995: END igs_as_entry_conf_pkg;