APPS.IGS_AS_SUA_REF_CDS_PKG dependencies on IGS_AS_SUA_REF_CDS

Line 1: PACKAGE BODY igs_as_sua_ref_cds_pkg AS

1: PACKAGE BODY igs_as_sua_ref_cds_pkg AS
2: /* $Header: IGSDI84B.pls 120.1 2005/09/16 15:33:56 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_sua_ref_cds%ROWTYPE;

Line 5: old_references igs_as_sua_ref_cds%ROWTYPE;

1: PACKAGE BODY igs_as_sua_ref_cds_pkg AS
2: /* $Header: IGSDI84B.pls 120.1 2005/09/16 15:33:56 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_sua_ref_cds%ROWTYPE;
6: new_references igs_as_sua_ref_cds%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_as_sua_ref_cds%ROWTYPE;

2: /* $Header: IGSDI84B.pls 120.1 2005/09/16 15:33:56 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_sua_ref_cds%ROWTYPE;
6: new_references igs_as_sua_ref_cds%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 38: FROM igs_as_sua_ref_cds

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

Line 127: FROM igs_as_sua_ref_cds

123: || (reverse chronological order - newest change first)
124: */
125: CURSOR cur_rowid IS
126: SELECT rowid
127: FROM igs_as_sua_ref_cds
128: WHERE suar_id = x_suar_id
129: FOR UPDATE NOWAIT;
130:
131: lv_rowid cur_rowid%RowType;

Line 167: FROM igs_as_sua_ref_cds

163: || (reverse chronological order - newest change first)
164: */
165: CURSOR cur_rowid IS
166: SELECT rowid
167: FROM igs_as_sua_ref_cds
168: WHERE person_id = x_person_id
169: AND course_cd = x_course_cd
170: AND uoo_id = x_uoo_id
171: AND reference_code_id = x_reference_code_id

Line 318: fnd_message.set_token ('ROUTINE', 'IGS_AS_SUA_REF_CDS_PKG.INSERT_ROW');

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

Line 344: INSERT INTO igs_as_sua_ref_cds (

340: x_last_updated_by => x_last_updated_by,
341: x_last_update_login => x_last_update_login
342: );
343:
344: INSERT INTO igs_as_sua_ref_cds (
345: suar_id,
346: person_id,
347: course_cd,
348: uoo_id,

Line 360: igs_as_sua_ref_cds_s.NEXTVAL,

356: last_update_date,
357: last_updated_by,
358: last_update_login
359: ) VALUES (
360: igs_as_sua_ref_cds_s.NEXTVAL,
361: new_references.person_id,
362: new_references.course_cd,
363: new_references.uoo_id,
364: new_references.reference_code_id,

Line 410: FROM igs_as_sua_ref_cds

406: reference_cd_type,
407: reference_cd,
408: applied_course_cd,
409: deleted_date
410: FROM igs_as_sua_ref_cds
411: WHERE rowid = x_rowid
412: FOR UPDATE NOWAIT;
413:
414: tlinfo c1%ROWTYPE;

Line 494: fnd_message.set_token ('ROUTINE', 'IGS_AS_SUA_REF_CDS_PKG.UPDATE_ROW');

490: x_last_update_login := -1;
491: END IF;
492: ELSE
493: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
494: fnd_message.set_token ('ROUTINE', 'IGS_AS_SUA_REF_CDS_PKG.UPDATE_ROW');
495: igs_ge_msg_stack.add;
496: app_exception.raise_exception;
497: END IF;
498:

Line 518: UPDATE igs_as_sua_ref_cds

514: x_last_updated_by => x_last_updated_by,
515: x_last_update_login => x_last_update_login
516: );
517:
518: UPDATE igs_as_sua_ref_cds
519: SET
520: person_id = new_references.person_id,
521: course_cd = new_references.course_cd,
522: uoo_id = new_references.uoo_id,

Line 564: FROM igs_as_sua_ref_cds

560: || (reverse chronological order - newest change first)
561: */
562: CURSOR c1 IS
563: SELECT rowid
564: FROM igs_as_sua_ref_cds
565: WHERE suar_id = x_suar_id;
566:
567: BEGIN
568:

Line 627: DELETE FROM igs_as_sua_ref_cds

623: p_action => 'DELETE',
624: x_rowid => x_rowid
625: );
626:
627: DELETE FROM igs_as_sua_ref_cds
628: WHERE rowid = x_rowid;
629:
630: IF (SQL%NOTFOUND) THEN
631: RAISE NO_DATA_FOUND;

Line 636: PROCEDURE Get_UFK_Igs_As_Sua_Ref_Cds (

632: END IF;
633:
634: END delete_row;
635:
636: PROCEDURE Get_UFK_Igs_As_Sua_Ref_Cds (
637: x_reference_cd_type IN VARCHAR2,
638: x_reference_cd IN VARCHAR2
639: ) AS
640:

Line 654: FROM igs_as_sua_ref_cds

650: ***************************************************************/
651:
652: CURSOR cur_rowid IS
653: SELECT rowid
654: FROM igs_as_sua_ref_cds
655: WHERE reference_cd_type = x_reference_cd_type
656: AND reference_cd = x_reference_cd;
657:
658: lv_rowid cur_rowid%RowType;

Line 673: END Get_UFK_Igs_As_Sua_Ref_Cds;

669: Return;
670: END IF;
671: Close cur_rowid;
672:
673: END Get_UFK_Igs_As_Sua_Ref_Cds;
674:
675:
676: END igs_as_sua_ref_cds_pkg;

Line 676: END igs_as_sua_ref_cds_pkg;

672:
673: END Get_UFK_Igs_As_Sua_Ref_Cds;
674:
675:
676: END igs_as_sua_ref_cds_pkg;