APPS.IGS_PE_CREDENTIALS_PKG dependencies on IGS_PE_CREDENTIALS

Line 1: PACKAGE BODY igs_pe_credentials_pkg AS

1: PACKAGE BODY igs_pe_credentials_pkg AS
2: /* $Header: IGSNI96B.pls 120.1 2005/06/28 05:18:10 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_credentials%ROWTYPE;

Line 5: old_references igs_pe_credentials%ROWTYPE;

1: PACKAGE BODY igs_pe_credentials_pkg AS
2: /* $Header: IGSNI96B.pls 120.1 2005/06/28 05:18:10 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_credentials%ROWTYPE;
6: new_references igs_pe_credentials%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_pe_credentials%ROWTYPE;

2: /* $Header: IGSNI96B.pls 120.1 2005/06/28 05:18:10 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_credentials%ROWTYPE;
6: new_references igs_pe_credentials%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 39: FROM igs_pe_credentials

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

Line 140: FROM igs_pe_credentials

136: || (reverse chronological order - newest change first)
137: */
138: CURSOR cur_rowid IS
139: SELECT rowid
140: FROM igs_pe_credentials
141: WHERE credential_id = x_credential_id
142: FOR UPDATE NOWAIT;
143:
144: lv_rowid cur_rowid%RowType;

Line 175: FROM igs_pe_credentials

171: || (reverse chronological order - newest change first)
172: */
173: CURSOR cur_rowid IS
174: SELECT rowid
175: FROM igs_pe_credentials
176: WHERE ((credential_type_id = x_credential_type_id));
177:
178: lv_rowid cur_rowid%RowType;
179:

Line 209: FROM igs_pe_credentials

205: || (reverse chronological order - newest change first)
206:
207: CURSOR cur_rowid IS
208: SELECT rowid
209: FROM igs_pe_credentials
210: WHERE ((rating = x_code_id));
211:
212: lv_rowid cur_rowid%RowType;
213:

Line 243: FROM igs_pe_credentials

239: || (reverse chronological order - newest change first)
240: */
241: CURSOR cur_rowid IS
242: SELECT rowid
243: FROM igs_pe_credentials
244: WHERE ((person_id = x_party_id));
245:
246: lv_rowid cur_rowid%RowType;
247:

Line 402: FROM igs_pe_credentials

398: || (reverse chronological order - newest change first)
399: */
400: CURSOR c IS
401: SELECT rowid
402: FROM igs_pe_credentials
403: WHERE credential_id = x_credential_id;
404:
405: x_last_update_date DATE;
406: x_last_updated_by NUMBER;

Line 430: SELECT igs_pe_credentials_s.NEXTVAL

426: igs_ge_msg_stack.add;
427: app_exception.raise_exception;
428: END IF;
429:
430: SELECT igs_pe_credentials_s.NEXTVAL
431: INTO x_credential_id
432: FROM dual;
433:
434: before_dml(

Line 457: INSERT INTO igs_pe_credentials (

453:
454: IF (x_mode = 'S') THEN
455: igs_sc_gen_001.set_ctx('R');
456: END IF;
457: INSERT INTO igs_pe_credentials (
458: credential_id,
459: person_id,
460: credential_type_id,
461: date_received,

Line 552: FROM igs_pe_credentials

548: recommender_name,
549: recommender_title,
550: recommender_organization,
551: rating_code
552: FROM igs_pe_credentials
553: WHERE rowid = x_rowid
554: FOR UPDATE NOWAIT;
555:
556: tlinfo c1%ROWTYPE;

Line 665: UPDATE igs_pe_credentials

661:
662: IF (x_mode = 'S') THEN
663: igs_sc_gen_001.set_ctx('R');
664: END IF;
665: UPDATE igs_pe_credentials
666: SET
667: person_id = new_references.person_id,
668: credential_type_id = new_references.credential_type_id,
669: date_received = new_references.date_received,

Line 733: FROM igs_pe_credentials

729: || (reverse chronological order - newest change first)
730: */
731: CURSOR c1 IS
732: SELECT rowid
733: FROM igs_pe_credentials
734: WHERE credential_id = x_credential_id;
735:
736: BEGIN
737:

Line 802: DELETE FROM igs_pe_credentials

798:
799: IF (x_mode = 'S') THEN
800: igs_sc_gen_001.set_ctx('R');
801: END IF;
802: DELETE FROM igs_pe_credentials
803: WHERE rowid = x_rowid;
804:
805: IF (SQL%NOTFOUND) THEN
806: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 819: END igs_pe_credentials_pkg;

815:
816: END delete_row;
817:
818:
819: END igs_pe_credentials_pkg;