APPS.IGS_PS_OFR_PKG dependencies on IGS_PS_VER

Line 137: v_course_cd IGS_PS_VER.course_cd%TYPE;

133: Who When What
134: (reverse chronological order - newest change first)
135: ***************************************************************/
136: v_message_name varchar2(30);
137: v_course_cd IGS_PS_VER.course_cd%TYPE;
138: v_version_number IGS_PS_VER.version_number%TYPE;
139: BEGIN
140:
141: -- Set variables

Line 138: v_version_number IGS_PS_VER.version_number%TYPE;

134: (reverse chronological order - newest change first)
135: ***************************************************************/
136: v_message_name varchar2(30);
137: v_course_cd IGS_PS_VER.course_cd%TYPE;
138: v_version_number IGS_PS_VER.version_number%TYPE;
139: BEGIN
140:
141: -- Set variables
142: IF p_inserting OR p_updating THEN

Line 245: IF NOT IGS_PS_VER_PKG.Get_PK_For_Validation (

241: ((new_references.course_cd IS NULL) OR
242: (new_references.version_number IS NULL))) THEN
243: NULL;
244: ELSE
245: IF NOT IGS_PS_VER_PKG.Get_PK_For_Validation (
246: new_references.course_cd,
247: new_references.version_number
248: ) THEN
249: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

Line 388: PROCEDURE GET_FK_IGS_PS_VER (

384: Close cur_rowid;
385:
386: END GET_FK_IGS_CA_TYPE;
387:
388: PROCEDURE GET_FK_IGS_PS_VER (
389: x_course_cd IN VARCHAR2,
390: x_version_number IN NUMBER
391: ) AS
392: /*************************************************************

Line 422: END GET_FK_IGS_PS_VER;

418: Return;
419: END IF;
420: Close cur_rowid;
421:
422: END GET_FK_IGS_PS_VER;
423:
424: PROCEDURE Before_DML (
425: p_action IN VARCHAR2,
426: x_rowid IN VARCHAR2 DEFAULT NULL,