APPS.IGS_HE_EN_SUSA_CC_PKG dependencies on IGS_HE_EN_SUSA_CC

Line 1: PACKAGE BODY igs_he_en_susa_cc_pkg AS

1: PACKAGE BODY igs_he_en_susa_cc_pkg AS
2: /* $Header: IGSWI44B.pls 120.2 2005/07/03 18:46:50 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_en_susa_cc%ROWTYPE;

Line 5: old_references igs_he_en_susa_cc%ROWTYPE;

1: PACKAGE BODY igs_he_en_susa_cc_pkg AS
2: /* $Header: IGSWI44B.pls 120.2 2005/07/03 18:46:50 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_en_susa_cc%ROWTYPE;
6: new_references igs_he_en_susa_cc%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_he_en_susa_cc%ROWTYPE;

2: /* $Header: IGSWI44B.pls 120.2 2005/07/03 18:46:50 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_en_susa_cc%ROWTYPE;
6: new_references igs_he_en_susa_cc%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 37: FROM igs_he_en_susa_cc

33: */
34:
35: CURSOR cur_old_ref_values IS
36: SELECT *
37: FROM igs_he_en_susa_cc
38: WHERE rowid = x_rowid;
39:
40: BEGIN
41:

Line 125: FROM igs_he_en_susa_cc

121: || (reverse chronological order - newest change first)
122: */
123: CURSOR cur_rowid IS
124: SELECT rowid
125: FROM igs_he_en_susa_cc
126: WHERE he_susa_cc_id = x_he_susa_cc_id
127: FOR UPDATE NOWAIT;
128:
129: lv_rowid cur_rowid%RowType;

Line 165: FROM igs_he_en_susa_cc

161: || (reverse chronological order - newest change first)
162: */
163: CURSOR cur_rowid IS
164: SELECT rowid
165: FROM igs_he_en_susa_cc
166: WHERE person_id = x_person_id
167: AND course_cd = x_course_cd
168: AND unit_set_cd = x_unit_set_cd
169: AND sequence_number = x_sequence_number

Line 317: fnd_message.set_token ('ROUTINE', 'IGS_HE_EN_SUSA_CC_PKG.INSERT_ROW');

313: x_last_update_login := -1;
314: END IF;
315: ELSE
316: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
317: fnd_message.set_token ('ROUTINE', 'IGS_HE_EN_SUSA_CC_PKG.INSERT_ROW');
318: igs_ge_msg_stack.add;
319: app_exception.raise_exception;
320: END IF;
321:

Line 345: INSERT INTO igs_he_en_susa_cc (

341:
342: IF (x_mode = 'S') THEN
343: igs_sc_gen_001.set_ctx('R');
344: END IF;
345: INSERT INTO igs_he_en_susa_cc (
346: he_susa_cc_id,
347: person_id,
348: course_cd,
349: unit_set_cd,

Line 360: igs_he_en_susa_cc_s.NEXTVAL,

356: last_update_date,
357: last_updated_by,
358: last_update_login
359: ) VALUES (
360: igs_he_en_susa_cc_s.NEXTVAL,
361: new_references.person_id,
362: new_references.course_cd,
363: new_references.unit_set_cd,
364: new_references.sequence_number,

Line 426: FROM igs_he_en_susa_cc

422: sequence_number,
423: cost_centre,
424: subject,
425: proportion
426: FROM igs_he_en_susa_cc
427: WHERE rowid = x_rowid
428: FOR UPDATE NOWAIT;
429:
430: tlinfo c1%ROWTYPE;

Line 508: fnd_message.set_token ('ROUTINE', 'IGS_HE_EN_SUSA_CC_PKG.UPDATE_ROW');

504: x_last_update_login := -1;
505: END IF;
506: ELSE
507: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
508: fnd_message.set_token ('ROUTINE', 'IGS_HE_EN_SUSA_CC_PKG.UPDATE_ROW');
509: igs_ge_msg_stack.add;
510: app_exception.raise_exception;
511: END IF;
512:

Line 534: UPDATE igs_he_en_susa_cc

530:
531: IF (x_mode = 'S') THEN
532: igs_sc_gen_001.set_ctx('R');
533: END IF;
534: UPDATE igs_he_en_susa_cc
535: SET
536: person_id = new_references.person_id,
537: course_cd = new_references.course_cd,
538: unit_set_cd = new_references.unit_set_cd,

Line 600: FROM igs_he_en_susa_cc

596: || (reverse chronological order - newest change first)
597: */
598: CURSOR c1 IS
599: SELECT rowid
600: FROM igs_he_en_susa_cc
601: WHERE he_susa_cc_id = x_he_susa_cc_id;
602:
603: BEGIN
604:

Line 665: DELETE FROM igs_he_en_susa_cc

661:
662: IF (x_mode = 'S') THEN
663: igs_sc_gen_001.set_ctx('R');
664: END IF;
665: DELETE FROM igs_he_en_susa_cc
666: WHERE rowid = x_rowid;
667:
668: IF (SQL%NOTFOUND) THEN
669: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 684: END igs_he_en_susa_cc_pkg;

680:
681: END delete_row;
682:
683:
684: END igs_he_en_susa_cc_pkg;