DBA Data[Home] [Help]

APPS.IGS_PR_CLASS_RANK dependencies on IGS_PR_COHORT_INST_PKG

Line 161: igs_pr_cohort_inst_pkg.INSERT_ROW(

157: CLOSE cur_inst_query;
158:
159: l_rowid := NULL;
160:
161: igs_pr_cohort_inst_pkg.INSERT_ROW(
162: x_rowid => l_rowid ,
163: x_cohort_name => p_cohort_name,
164: x_load_cal_type => p_cal_type ,
165: x_load_ci_sequence_number => p_ci_sequence_number ,

Line 228: igs_pr_cohort_inst_pkg.insert_row(

224: FOR cohort_old_rec IN cur_cohort_old (p_org_unit_cd,p_cal_type,p_ci_sequence_number) LOOP
225:
226: -- The Cohort Instances are created for the Cohort Name which are in the Organization but does not have the Instance
227:
228: igs_pr_cohort_inst_pkg.insert_row(
229: x_rowid => l_rowid ,
230: x_cohort_name => cohort_old_rec.cohort_name,
231: x_load_cal_type => p_cal_type ,
232: x_load_ci_sequence_number => p_ci_sequence_number ,

Line 296: igs_pr_cohort_inst_pkg.insert_row(

292: l_count := l_count + 1;
293:
294: -- Instance for this cohort is created and then the ranking process for this new instance is run.
295:
296: igs_pr_cohort_inst_pkg.insert_row(
297: x_rowid => l_rowid ,
298: x_cohort_name => cohort_org_rec.cohort_name,
299: x_load_cal_type => p_cal_type ,
300: x_load_ci_sequence_number => p_ci_sequence_number ,

Line 763: igs_pr_cohort_inst_pkg.update_row(

759: --
760: -- Updating the Cohert Instance table with the rundate as the System Date. Rest of the values are retained.
761: --
762:
763: igs_pr_cohort_inst_pkg.update_row(
764: x_rowid => rank_status_rec.row_id,
765: x_cohort_name => rank_status_rec.cohort_name,
766: x_load_cal_type => rank_status_rec.load_cal_type,
767: x_load_ci_sequence_number => rank_status_rec.load_ci_sequence_number,

Line 1197: igs_pr_cohort_inst_pkg.update_row(

1193: --
1194: -- Updating the Cohert Instance table with the rundate as the System Date. Rest of the values are retained.
1195: --
1196:
1197: igs_pr_cohort_inst_pkg.update_row(
1198: x_rowid => rank_status_rec.row_id,
1199: x_cohort_name => rank_status_rec.cohort_name,
1200: x_load_cal_type => rank_status_rec.load_cal_type,
1201: x_load_ci_sequence_number => rank_status_rec.load_ci_sequence_number,