DBA Data[Home] [Help]

APPS.IGS_PR_VAL_SPO dependencies on IGS_PR_VAL_SPO

Line 1: PACKAGE BODY igs_pr_val_spo AS

1: PACKAGE BODY igs_pr_val_spo AS
2: /* $Header: IGSPR21B.pls 115.10 2003/04/14 09:51:58 anilk ship $ */
3:
4: -------------------------------------------------------------------------------------------
5: --Change History:

Line 52: IF igs_pr_val_spo.prgp_val_spo_ins (

48: RETURN FALSE;
49: END IF;
50: -- Validate insert
51: IF p_inserting THEN
52: IF igs_pr_val_spo.prgp_val_spo_ins (
53: gt_rowid_table(v_index).person_id,
54: gt_rowid_table(v_index).course_cd,
55: gt_rowid_table(v_index).prg_cal_type,
56: gt_rowid_table(v_index).prg_ci_sequence_number,

Line 69: IF igs_pr_val_spo.prgp_val_spo_dcsn (

65: -- Check the decision status can be changed
66: IF p_inserting OR (p_updating AND
67: gt_rowid_table(v_index).new_decision_status <>
68: gt_rowid_table(v_index).old_decision_status) THEN
69: IF igs_pr_val_spo.prgp_val_spo_dcsn (
70: gt_rowid_table(v_index).person_id,
71: gt_rowid_table(v_index).course_cd,
72: gt_rowid_table(v_index).prg_cal_type,
73: gt_rowid_table(v_index).prg_ci_sequence_number,

Line 94: IF igs_pr_val_spo.prgp_val_spo_approve (

90: -- Check the decision status can be set to approved
91: IF p_inserting OR (p_updating AND
92: gt_rowid_table(v_index).new_decision_status <>
93: gt_rowid_table(v_index).old_decision_status) THEN
94: IF igs_pr_val_spo.prgp_val_spo_approve (
95: gt_rowid_table(v_index).person_id,
96: gt_rowid_table(v_index).course_cd,
97: gt_rowid_table(v_index).sequence_number,
98: gt_rowid_table(v_index).progression_outcome_type,

Line 115: IF igs_pr_val_spo.prgp_val_spo_drtn (

111: NVL(gt_rowid_table(v_index).new_duration, -1) <>
112: NVL(gt_rowid_table(v_index).old_duration, -1) OR
113: NVL(gt_rowid_table(v_index).new_duration_type, ' ') <>
114: NVL(gt_rowid_table(v_index).old_duration_type, ' ')) THEN
115: IF igs_pr_val_spo.prgp_val_spo_drtn (
116: gt_rowid_table(v_index).person_id,
117: gt_rowid_table(v_index).course_cd,
118: gt_rowid_table(v_index).sequence_number,
119: gt_rowid_table(v_index).new_decision_status,

Line 2309: END igs_pr_val_spo;

2305: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
2306: IGS_GE_MSG_STACK.ADD;
2307: App_Exception.Raise_Exception;
2308: END prgp_val_spo_exp_dt;
2309: END igs_pr_val_spo;