APPS.IGS_FI_F_TYP_CA_INST_PKG dependencies on GL_CODE_COMBINATIONS

Line 606: CURSOR c_gl_code_combinations_pk IS

602:
603: END Check_Constraints;
604:
605: PROCEDURE Check_Parent_Existance IS
606: CURSOR c_gl_code_combinations_pk IS
607: SELECT 'X'
608: FROM GL_CODE_COMBINATIONS
609: WHERE code_combination_id = new_references.rec_gl_ccid;
610: l_ccid_temp c_gl_code_combinations_pk%ROWTYPE;

Line 608: FROM GL_CODE_COMBINATIONS

604:
605: PROCEDURE Check_Parent_Existance IS
606: CURSOR c_gl_code_combinations_pk IS
607: SELECT 'X'
608: FROM GL_CODE_COMBINATIONS
609: WHERE code_combination_id = new_references.rec_gl_ccid;
610: l_ccid_temp c_gl_code_combinations_pk%ROWTYPE;
611:
612: BEGIN

Line 610: l_ccid_temp c_gl_code_combinations_pk%ROWTYPE;

606: CURSOR c_gl_code_combinations_pk IS
607: SELECT 'X'
608: FROM GL_CODE_COMBINATIONS
609: WHERE code_combination_id = new_references.rec_gl_ccid;
610: l_ccid_temp c_gl_code_combinations_pk%ROWTYPE;
611:
612: BEGIN
613: IF (((old_references.fee_cal_type = new_references.fee_cal_type) AND
614: (old_references.fee_ci_sequence_number = new_references.fee_ci_sequence_number)) OR

Line 776: OPEN c_gl_code_combinations_pk;

772: (new_references.rec_gl_ccid IS NULL))
773: THEN
774: NULL;
775: ELSE
776: OPEN c_gl_code_combinations_pk;
777: FETCH c_gl_code_combinations_pk INTO l_ccid_temp;
778: IF c_gl_code_combinations_pk%NOTFOUND THEN
779: CLOSE c_gl_code_combinations_pk;
780: FND_MESSAGE.set_name ('FND', 'FORM_RECORD_DELETED');

Line 777: FETCH c_gl_code_combinations_pk INTO l_ccid_temp;

773: THEN
774: NULL;
775: ELSE
776: OPEN c_gl_code_combinations_pk;
777: FETCH c_gl_code_combinations_pk INTO l_ccid_temp;
778: IF c_gl_code_combinations_pk%NOTFOUND THEN
779: CLOSE c_gl_code_combinations_pk;
780: FND_MESSAGE.set_name ('FND', 'FORM_RECORD_DELETED');
781: IGS_GE_MSG_STACK.ADD;

Line 778: IF c_gl_code_combinations_pk%NOTFOUND THEN

774: NULL;
775: ELSE
776: OPEN c_gl_code_combinations_pk;
777: FETCH c_gl_code_combinations_pk INTO l_ccid_temp;
778: IF c_gl_code_combinations_pk%NOTFOUND THEN
779: CLOSE c_gl_code_combinations_pk;
780: FND_MESSAGE.set_name ('FND', 'FORM_RECORD_DELETED');
781: IGS_GE_MSG_STACK.ADD;
782: App_Exception.Raise_Exception;

Line 779: CLOSE c_gl_code_combinations_pk;

775: ELSE
776: OPEN c_gl_code_combinations_pk;
777: FETCH c_gl_code_combinations_pk INTO l_ccid_temp;
778: IF c_gl_code_combinations_pk%NOTFOUND THEN
779: CLOSE c_gl_code_combinations_pk;
780: FND_MESSAGE.set_name ('FND', 'FORM_RECORD_DELETED');
781: IGS_GE_MSG_STACK.ADD;
782: App_Exception.Raise_Exception;
783: END IF;

Line 784: IF c_gl_code_combinations_pk%ISOPEN THEN

780: FND_MESSAGE.set_name ('FND', 'FORM_RECORD_DELETED');
781: IGS_GE_MSG_STACK.ADD;
782: App_Exception.Raise_Exception;
783: END IF;
784: IF c_gl_code_combinations_pk%ISOPEN THEN
785: CLOSE c_gl_code_combinations_pk;
786: END IF;
787: END IF;
788:

Line 785: CLOSE c_gl_code_combinations_pk;

781: IGS_GE_MSG_STACK.ADD;
782: App_Exception.Raise_Exception;
783: END IF;
784: IF c_gl_code_combinations_pk%ISOPEN THEN
785: CLOSE c_gl_code_combinations_pk;
786: END IF;
787: END IF;
788:
789: -- Added by jbegum for bug #2113459