APPS.IGS_FI_FND_SRC_RSTN_PKG dependencies on IGS_FI_FND_SRC_RSTN

Line 1: package body IGS_FI_FND_SRC_RSTN_PKG AS

1: package body IGS_FI_FND_SRC_RSTN_PKG AS
2: /* $Header: IGSSI40B.pls 115.3 2002/11/29 03:46:46 nsidana ship $*/
3:
4:
5:

Line 8: old_references IGS_FI_FND_SRC_RSTN%RowType;

4:
5:
6: l_rowid VARCHAR2(25);
7:
8: old_references IGS_FI_FND_SRC_RSTN%RowType;
9:
10: new_references IGS_FI_FND_SRC_RSTN%RowType;
11:
12:

Line 10: new_references IGS_FI_FND_SRC_RSTN%RowType;

6: l_rowid VARCHAR2(25);
7:
8: old_references IGS_FI_FND_SRC_RSTN%RowType;
9:
10: new_references IGS_FI_FND_SRC_RSTN%RowType;
11:
12:
13:
14: PROCEDURE Set_Column_Values (

Line 48: FROM IGS_FI_FND_SRC_RSTN

44: CURSOR cur_old_ref_values IS
45:
46: SELECT *
47:
48: FROM IGS_FI_FND_SRC_RSTN
49:
50: WHERE rowid = x_rowid;
51:
52:

Line 130: -- ON IGS_FI_FND_SRC_RSTN

126: -- "OSS_TST".trg_fsr_br_iud
127:
128: -- BEFORE INSERT OR DELETE OR UPDATE
129:
130: -- ON IGS_FI_FND_SRC_RSTN
131:
132: -- FOR EACH ROW
133:
134:

Line 148: v_course_cd IGS_FI_FND_SRC_RSTN.course_cd%TYPE;

144: ) AS
145:
146: v_message_name varchar2(30);
147:
148: v_course_cd IGS_FI_FND_SRC_RSTN.course_cd%TYPE;
149:
150: v_version_number IGS_FI_FND_SRC_RSTN.version_number%TYPE;
151:
152: v_dflt_ind IGS_FI_FND_SRC_RSTN.dflt_ind%TYPE;

Line 150: v_version_number IGS_FI_FND_SRC_RSTN.version_number%TYPE;

146: v_message_name varchar2(30);
147:
148: v_course_cd IGS_FI_FND_SRC_RSTN.course_cd%TYPE;
149:
150: v_version_number IGS_FI_FND_SRC_RSTN.version_number%TYPE;
151:
152: v_dflt_ind IGS_FI_FND_SRC_RSTN.dflt_ind%TYPE;
153:
154: v_restricted_ind IGS_FI_FND_SRC_RSTN.restricted_ind%TYPE;

Line 152: v_dflt_ind IGS_FI_FND_SRC_RSTN.dflt_ind%TYPE;

148: v_course_cd IGS_FI_FND_SRC_RSTN.course_cd%TYPE;
149:
150: v_version_number IGS_FI_FND_SRC_RSTN.version_number%TYPE;
151:
152: v_dflt_ind IGS_FI_FND_SRC_RSTN.dflt_ind%TYPE;
153:
154: v_restricted_ind IGS_FI_FND_SRC_RSTN.restricted_ind%TYPE;
155:
156: BEGIN

Line 154: v_restricted_ind IGS_FI_FND_SRC_RSTN.restricted_ind%TYPE;

150: v_version_number IGS_FI_FND_SRC_RSTN.version_number%TYPE;
151:
152: v_dflt_ind IGS_FI_FND_SRC_RSTN.dflt_ind%TYPE;
153:
154: v_restricted_ind IGS_FI_FND_SRC_RSTN.restricted_ind%TYPE;
155:
156: BEGIN
157:
158: -- Set variables.

Line 387: FROM IGS_FI_FND_SRC_RSTN

383: x_funding_source IN VARCHAR2
384: ) RETURN BOOLEAN AS
385: CURSOR cur_rowid IS
386: SELECT rowid
387: FROM IGS_FI_FND_SRC_RSTN
388: WHERE course_cd = x_course_cd
389: AND version_number = x_version_number
390: AND funding_source = x_funding_source
391: FOR UPDATE NOWAIT;

Line 411: FROM IGS_FI_FND_SRC_RSTN

407: x_funding_source IN VARCHAR2
408: ) AS
409: CURSOR cur_rowid IS
410: SELECT rowid
411: FROM IGS_FI_FND_SRC_RSTN
412: WHERE funding_source = x_funding_source ;
413:
414: lv_rowid cur_rowid%RowType;
415: BEGIN

Line 445: FROM IGS_FI_FND_SRC_RSTN

441: CURSOR cur_rowid IS
442:
443: SELECT rowid
444:
445: FROM IGS_FI_FND_SRC_RSTN
446:
447: WHERE course_cd = x_course_cd
448:
449: AND version_number = x_version_number ;

Line 591: cursor C is select ROWID from IGS_FI_FND_SRC_RSTN

587: X_DFLT_IND in VARCHAR2,
588: X_RESTRICTED_IND in VARCHAR2,
589: X_MODE in VARCHAR2 default 'R'
590: ) AS
591: cursor C is select ROWID from IGS_FI_FND_SRC_RSTN
592: where COURSE_CD = X_COURSE_CD
593: and FUNDING_SOURCE = X_FUNDING_SOURCE
594: and VERSION_NUMBER = X_VERSION_NUMBER;
595: X_LAST_UPDATE_DATE DATE;

Line 635: insert into IGS_FI_FND_SRC_RSTN (

631: x_last_updated_by=>X_LAST_UPDATED_BY,
632: x_last_update_login=>X_LAST_UPDATE_LOGIN
633: );
634:
635: insert into IGS_FI_FND_SRC_RSTN (
636: COURSE_CD,
637: VERSION_NUMBER,
638: FUNDING_SOURCE,
639: DFLT_IND,

Line 680: from IGS_FI_FND_SRC_RSTN

676: ) AS
677: cursor c1 is select
678: DFLT_IND,
679: RESTRICTED_IND
680: from IGS_FI_FND_SRC_RSTN
681: where ROWID=X_ROWID
682: for update nowait;
683: tlinfo c1%rowtype;
684:

Line 770: update IGS_FI_FND_SRC_RSTN set

766:
767: );
768:
769:
770: update IGS_FI_FND_SRC_RSTN set
771: DFLT_IND = NEW_REFERENCES.DFLT_IND,
772: RESTRICTED_IND = NEW_REFERENCES.RESTRICTED_IND,
773: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
774: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 793: cursor c1 is select rowid from IGS_FI_FND_SRC_RSTN

789: X_DFLT_IND in VARCHAR2,
790: X_RESTRICTED_IND in VARCHAR2,
791: X_MODE in VARCHAR2 default 'R'
792: ) AS
793: cursor c1 is select rowid from IGS_FI_FND_SRC_RSTN
794: where COURSE_CD = X_COURSE_CD
795: and FUNDING_SOURCE = X_FUNDING_SOURCE
796: and VERSION_NUMBER = X_VERSION_NUMBER
797: ;

Line 833: delete from IGS_FI_FND_SRC_RSTN

829: Before_DML (
830: p_action => 'DELETE',
831: x_rowid => X_ROWID
832: );
833: delete from IGS_FI_FND_SRC_RSTN
834: where ROWID=X_ROWID;
835: if (sql%notfound) then
836: raise no_data_found;
837: end if;

Line 839: end IGS_FI_FND_SRC_RSTN_PKG;

835: if (sql%notfound) then
836: raise no_data_found;
837: end if;
838: end DELETE_ROW;
839: end IGS_FI_FND_SRC_RSTN_PKG;