eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_CO_PROCESS dependencies on IGS_CO_INTERAC_HIST

Line 1729: -- Insert the record into the igs_co_interac_hist table with the all relevant

1725: p_award_year => p_award_year);*/
1726: END IF;
1727:
1728: --
1729: -- Insert the record into the igs_co_interac_hist table with the all relevant
1730: -- details and status from 'p_request_status'.
1731: --
1732: l_rowid := NULL;
1733: igs_co_interac_hist_pkg.insert_row(

Line 1733: igs_co_interac_hist_pkg.insert_row(

1729: -- Insert the record into the igs_co_interac_hist table with the all relevant
1730: -- details and status from 'p_request_status'.
1731: --
1732: l_rowid := NULL;
1733: igs_co_interac_hist_pkg.insert_row(
1734: x_rowid => l_rowid,
1735: x_student_id => TO_NUMBER(p_person_id),
1736: x_request_id => TO_NUMBER(p_request_id),
1737: x_document_id => TO_NUMBER(p_document_id),

Line 1889: l_parameter_8 igs_co_interac_hist.adm_application_number%TYPE;

1885: l_acad_ci_sequence_number igs_ad_missing_items_letter_v.acad_ci_sequence_number%TYPE;
1886: l_adm_cal_type VARCHAR(15); --igs_ad_ps_appl_inst.adm_cal_type%TYPE;
1887: l_adm_ci_sequence_number igs_ad_ps_appl_inst.adm_ci_sequence_number%TYPE;
1888: l_parameter_7 hz_parties.party_id%TYPE;
1889: l_parameter_8 igs_co_interac_hist.adm_application_number%TYPE;
1890: l_parameter_9 igs_co_interac_hist.nominated_course_cd%TYPE;
1891: l_parameter_10 igs_co_interac_hist.ci_sequence_number%TYPE;
1892:
1893: BEGIN

Line 1890: l_parameter_9 igs_co_interac_hist.nominated_course_cd%TYPE;

1886: l_adm_cal_type VARCHAR(15); --igs_ad_ps_appl_inst.adm_cal_type%TYPE;
1887: l_adm_ci_sequence_number igs_ad_ps_appl_inst.adm_ci_sequence_number%TYPE;
1888: l_parameter_7 hz_parties.party_id%TYPE;
1889: l_parameter_8 igs_co_interac_hist.adm_application_number%TYPE;
1890: l_parameter_9 igs_co_interac_hist.nominated_course_cd%TYPE;
1891: l_parameter_10 igs_co_interac_hist.ci_sequence_number%TYPE;
1892:
1893: BEGIN
1894: --** proc level logging.

Line 1891: l_parameter_10 igs_co_interac_hist.ci_sequence_number%TYPE;

1887: l_adm_ci_sequence_number igs_ad_ps_appl_inst.adm_ci_sequence_number%TYPE;
1888: l_parameter_7 hz_parties.party_id%TYPE;
1889: l_parameter_8 igs_co_interac_hist.adm_application_number%TYPE;
1890: l_parameter_9 igs_co_interac_hist.nominated_course_cd%TYPE;
1891: l_parameter_10 igs_co_interac_hist.ci_sequence_number%TYPE;
1892:
1893: BEGIN
1894: --** proc level logging.
1895: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

Line 2269: kpadiyar 18-NOV-2002 Removed the calls to the igs_co_interac_hist_pkg.update_row as the only column being updated was the outcome_status column

2265: Who When What
2266:
2267: (reverse chronological order - newest change first)
2268: Bayadav 24-MAY-2002 Included two system letter codes 'ENADHOC', 'SFADHOC' for adhoc letters as a part of bug 2376434
2269: kpadiyar 18-NOV-2002 Removed the calls to the igs_co_interac_hist_pkg.update_row as the only column being updated was the outcome_status column
2270: and as this column has been obsoleted all the relevant calls to the update row have been removed.
2271: gmaheswa 5-Jan-2004 Bug 4869737 Added a call to SET_ORG_ID to disable OSS for R12.
2272: ***************************************************************/
2273: CURSOR c_crm_id(cp_request_id NUMBER) IS

Line 2281: FROM igs_co_interac_hist hist

2277: l_c_crm_id c_crm_id%ROWTYPE;
2278:
2279: CURSOR cur_int_hist(cp_request_id NUMBER) IS
2280: SELECT hist.rowid row_id, hist.*
2281: FROM igs_co_interac_hist hist
2282: WHERE request_id = TO_NUMBER(cp_request_id);
2283: l_cur_int_hist cur_int_hist%ROWTYPE;
2284:
2285: CURSOR cur_gen_update IS