APPS.IGS_PS_GEN_001 dependencies on IGS_FI_FND_SRC_RSTN

Line 93: gv_fsr_rec IGS_FI_FND_SRC_RSTN%ROWTYPE;

89: gv_cow_rec IGS_PS_OWN%ROWTYPE;
90: gv_cvn_rec IGS_PS_VER_NOTE%ROWTYPE;
91: gv_ae_rec IGS_PE_ALTERNATV_EXT%ROWTYPE;
92: gv_cgm_rec IGS_PS_GRP_MBR%ROWTYPE;
93: gv_fsr_rec IGS_FI_FND_SRC_RSTN%ROWTYPE;
94: gv_cfos_rec IGS_PS_FIELD_STUDY%ROWTYPE;
95: gv_ccat_rec IGS_PS_CATEGORISE%ROWTYPE;
96: gv_crcd_rec IGS_PS_REF_CD%ROWTYPE;
97: gv_cal_rec IGS_PS_ANL_LOAD%ROWTYPE;

Line 169: FROM IGS_FI_FND_SRC_RSTN

165: WHERE course_cd = p_old_course_cd AND
166: version_number = p_old_version_number;
167: CURSOR gc_fsr_rec IS
168: SELECT *
169: FROM IGS_FI_FND_SRC_RSTN
170: WHERE course_cd = p_old_course_cd AND
171: version_number = p_old_version_number;
172: CURSOR gc_cfos_rec IS
173: SELECT *

Line 1442: -- procedure for inserting new IGS_FI_FND_SRC_RSTN records

1438: App_Exception.Raise_Exception;
1439: END IF;
1440: END crsp_ins_cgm_rec;
1441:
1442: -- procedure for inserting new IGS_FI_FND_SRC_RSTN records
1443:
1444: -- Bug#3060697 Modified the call to IGS_FI_FND_SRC_RSTN_PKG.INSERT_ROW.
1445: -- Replaced the string 'Y' with gv_fsr_rec.restricted_ind as the parameter being passed to X_RESTRICTED_IND
1446:

Line 1444: -- Bug#3060697 Modified the call to IGS_FI_FND_SRC_RSTN_PKG.INSERT_ROW.

1440: END crsp_ins_cgm_rec;
1441:
1442: -- procedure for inserting new IGS_FI_FND_SRC_RSTN records
1443:
1444: -- Bug#3060697 Modified the call to IGS_FI_FND_SRC_RSTN_PKG.INSERT_ROW.
1445: -- Replaced the string 'Y' with gv_fsr_rec.restricted_ind as the parameter being passed to X_RESTRICTED_IND
1446:
1447:
1448: PROCEDURE crsp_ins_fsr_rec (

Line 1453: IGS_FI_FND_SRC_RSTN_PKG.INSERT_ROW(

1449: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1450: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1451: BEGIN
1452: x_rowid := NULL;
1453: IGS_FI_FND_SRC_RSTN_PKG.INSERT_ROW(
1454: X_ROWID => x_rowid,
1455: X_COURSE_CD => p_new_course_cd,
1456: X_FUNDING_SOURCE => gv_fsr_rec.funding_source,
1457: X_VERSION_NUMBER => p_new_version_number,

Line 1942: -- calling procedure to insert IGS_FI_FND_SRC_RSTN records

1938: EXIT;
1939: END IF;
1940: END LOOP;
1941: CLOSE gc_ae_rec;
1942: -- calling procedure to insert IGS_FI_FND_SRC_RSTN records
1943: OPEN gc_fsr_rec;
1944: LOOP
1945: FETCH gc_fsr_rec INTO gv_fsr_rec;
1946: IF gc_fsr_rec%FOUND THEN