APPS.IGS_AS_USEC_SESSNS_PKG dependencies on IGS_AS_USEC_SESSNS

Line 1: PACKAGE BODY igs_as_usec_sessns_pkg AS

1: PACKAGE BODY igs_as_usec_sessns_pkg AS
2: /* $Header: IGSDI79B.pls 115.1 2003/11/04 11:00:45 msrinivi noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_usec_sessns%ROWTYPE;

Line 5: old_references igs_as_usec_sessns%ROWTYPE;

1: PACKAGE BODY igs_as_usec_sessns_pkg AS
2: /* $Header: IGSDI79B.pls 115.1 2003/11/04 11:00:45 msrinivi noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_usec_sessns%ROWTYPE;
6: new_references igs_as_usec_sessns%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_as_usec_sessns%ROWTYPE;

2: /* $Header: IGSDI79B.pls 115.1 2003/11/04 11:00:45 msrinivi noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_usec_sessns%ROWTYPE;
6: new_references igs_as_usec_sessns%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 36: FROM igs_as_usec_sessns

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

Line 97: FROM igs_as_usec_sessns

93: || (reverse chronological order - newest change first)
94: */
95: CURSOR cur_rowid IS
96: SELECT rowid
97: FROM igs_as_usec_sessns
98: WHERE session_name = x_session_name
99: AND uoo_id = x_uoo_id
100: FOR UPDATE NOWAIT;
101:

Line 274: fnd_message.set_token ('ROUTINE', 'IGS_AS_USEC_SESSNS_PKG.INSERT_ROW');

270: x_last_update_login := -1;
271: END IF;
272: ELSE
273: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
274: fnd_message.set_token ('ROUTINE', 'IGS_AS_USEC_SESSNS_PKG.INSERT_ROW');
275: igs_ge_msg_stack.add;
276: app_exception.raise_exception;
277: END IF;
278:

Line 296: INSERT INTO igs_as_usec_sessns (

292: x_last_updated_by => x_last_updated_by,
293: x_last_update_login => x_last_update_login
294: );
295:
296: INSERT INTO igs_as_usec_sessns (
297: session_name,
298: session_description,
299: uoo_id,
300: unit_section_occurrence_id,

Line 391: FROM igs_as_usec_sessns

387: unit_section_occurrence_id,
388: session_start_date_time,
389: session_end_date_time,
390: session_location_desc
391: FROM igs_as_usec_sessns
392: WHERE rowid = x_rowid
393: FOR UPDATE NOWAIT;
394:
395: tlinfo c1%ROWTYPE;

Line 509: fnd_message.set_token ('ROUTINE', 'IGS_AS_USEC_SESSNS_PKG.UPDATE_ROW');

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

Line 531: UPDATE igs_as_usec_sessns

527: x_last_updated_by => x_last_updated_by,
528: x_last_update_login => x_last_update_login
529: );
530:
531: UPDATE igs_as_usec_sessns
532: SET
533: session_description = new_references.session_description,
534: unit_section_occurrence_id = new_references.unit_section_occurrence_id,
535: session_start_date_time = new_references.session_start_date_time,

Line 610: FROM igs_as_usec_sessns

606: || (reverse chronological order - newest change first)
607: */
608: CURSOR c1 IS
609: SELECT rowid
610: FROM igs_as_usec_sessns
611: WHERE session_name = x_session_name
612: AND uoo_id = x_uoo_id;
613:
614: L_RETURN_STATUS VARCHAR2(10);

Line 713: p_session_name igs_as_usec_sessns.session_name%TYPE,

709: || Who When What
710: || (reverse chronological order - newest change first)
711: */
712: CURSOR c_child_rec (
713: p_session_name igs_as_usec_sessns.session_name%TYPE,
714: p_uoo_id igs_as_usec_sessns.uoo_id%TYPE
715: )
716: IS
717: SELECT rowid

Line 714: p_uoo_id igs_as_usec_sessns.uoo_id%TYPE

710: || (reverse chronological order - newest change first)
711: */
712: CURSOR c_child_rec (
713: p_session_name igs_as_usec_sessns.session_name%TYPE,
714: p_uoo_id igs_as_usec_sessns.uoo_id%TYPE
715: )
716: IS
717: SELECT rowid
718: FROM igs_as_sua_ses_atts

Line 750: DELETE FROM igs_as_usec_sessns

746: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
747: RAISE FND_API.G_EXC_ERROR ;
748: END IF;
749:
750: DELETE FROM igs_as_usec_sessns
751: WHERE rowid = x_rowid;
752:
753: IF (SQL%NOTFOUND) THEN
754: RAISE NO_DATA_FOUND;

Line 805: FROM igs_as_usec_sessns

801: || (reverse chronological order - newest change first)
802: */
803: CURSOR cur_rowid IS
804: SELECT rowid
805: FROM igs_as_usec_sessns
806: WHERE unit_section_occurrence_id = x_unit_section_occurrence_id;
807:
808: lv_rowid cur_rowid%ROWTYPE;
809:

Line 840: FROM igs_as_usec_sessns

836: || (reverse chronological order - newest change first)
837: */
838: CURSOR cur_rowid IS
839: SELECT rowid
840: FROM igs_as_usec_sessns
841: WHERE uoo_id = x_uoo_id;
842:
843: lv_rowid cur_rowid%ROWTYPE;
844:

Line 861: END igs_as_usec_sessns_pkg;

857:
858: END get_fk_igs_ps_unit_ofr_opt;
859:
860:
861: END igs_as_usec_sessns_pkg;