APPS.IGS_PS_UNIT_OFR_OPT_PKG dependencies on IGS_PS_USEC_CAL_NUMS_PKG

Line 1038: igs_ps_usec_cal_nums_pkg.update_row( x_mode => 'R',

1034: FOR rec_teach_to_load IN c_teach_to_load(p_c_cal_type,p_n_seq_num) LOOP
1035: OPEN c_call_number (rec_teach_to_load.lcal_type,rec_teach_to_load.lseq_num);
1036: FETCH c_call_number INTO rec_call_number;
1037: IF c_call_number%FOUND THEN
1038: igs_ps_usec_cal_nums_pkg.update_row( x_mode => 'R',
1039: x_rowid => rec_call_number.row_id,
1040: x_unit_section_call_number_id => rec_call_number.call_id,
1041: x_calender_type => rec_teach_to_load.lcal_type,
1042: x_ci_sequence_number => rec_teach_to_load.lseq_num,

Line 1048: igs_ps_usec_cal_nums_pkg.insert_row ( x_rowid => l_c_rowid,

1044:
1045: ELSE
1046: l_c_rowid := NULL;
1047: l_n_usc_number_id := NULL;
1048: igs_ps_usec_cal_nums_pkg.insert_row ( x_rowid => l_c_rowid,
1049: x_unit_section_call_number_id => l_n_usc_number_id,
1050: x_calender_type => rec_teach_to_load.lcal_type,
1051: x_ci_sequence_number => rec_teach_to_load.lseq_num,
1052: x_call_number => l_n_max_cal_num,