APPS.IGS_CO_SUBMIT dependencies on IGS_CO_MAPPING

Line 174: l_sys_ltr_code igs_co_mapping.sys_ltr_code%TYPE;

170: ssaleem 09-SEP-2004 3630073. Added p_org_unit_id as a new parameter
171: pacross 08-SEP-2005 Added preview flag for correspondance preview and edit.
172: gmaheswa 5-Jan-2004 Bug 4869737 Added a call to SET_ORG_ID to disable OSS for R12.
173: ***************************************************************/
174: l_sys_ltr_code igs_co_mapping.sys_ltr_code%TYPE;
175: l_request_id igs_co_ou_co_ref.request_id%TYPE;
176: l_no_of_repeats igs_co_mapping.repeat_times%TYPE;
177: l_elapsed_days igs_co_mapping.elapsed_days%TYPE;
178: l_document_id igs_co_mapping.document_id%TYPE;

Line 176: l_no_of_repeats igs_co_mapping.repeat_times%TYPE;

172: gmaheswa 5-Jan-2004 Bug 4869737 Added a call to SET_ORG_ID to disable OSS for R12.
173: ***************************************************************/
174: l_sys_ltr_code igs_co_mapping.sys_ltr_code%TYPE;
175: l_request_id igs_co_ou_co_ref.request_id%TYPE;
176: l_no_of_repeats igs_co_mapping.repeat_times%TYPE;
177: l_elapsed_days igs_co_mapping.elapsed_days%TYPE;
178: l_document_id igs_co_mapping.document_id%TYPE;
179: l_letter_type igs_co_mapping.doc_code%TYPE;
180: l_request_status VARCHAR2 (100);

Line 177: l_elapsed_days igs_co_mapping.elapsed_days%TYPE;

173: ***************************************************************/
174: l_sys_ltr_code igs_co_mapping.sys_ltr_code%TYPE;
175: l_request_id igs_co_ou_co_ref.request_id%TYPE;
176: l_no_of_repeats igs_co_mapping.repeat_times%TYPE;
177: l_elapsed_days igs_co_mapping.elapsed_days%TYPE;
178: l_document_id igs_co_mapping.document_id%TYPE;
179: l_letter_type igs_co_mapping.doc_code%TYPE;
180: l_request_status VARCHAR2 (100);
181: l_send_letter VARCHAR2 (10);

Line 178: l_document_id igs_co_mapping.document_id%TYPE;

174: l_sys_ltr_code igs_co_mapping.sys_ltr_code%TYPE;
175: l_request_id igs_co_ou_co_ref.request_id%TYPE;
176: l_no_of_repeats igs_co_mapping.repeat_times%TYPE;
177: l_elapsed_days igs_co_mapping.elapsed_days%TYPE;
178: l_document_id igs_co_mapping.document_id%TYPE;
179: l_letter_type igs_co_mapping.doc_code%TYPE;
180: l_request_status VARCHAR2 (100);
181: l_send_letter VARCHAR2 (10);
182: l_sql_stmt VARCHAR2 (32767);

Line 179: l_letter_type igs_co_mapping.doc_code%TYPE;

175: l_request_id igs_co_ou_co_ref.request_id%TYPE;
176: l_no_of_repeats igs_co_mapping.repeat_times%TYPE;
177: l_elapsed_days igs_co_mapping.elapsed_days%TYPE;
178: l_document_id igs_co_mapping.document_id%TYPE;
179: l_letter_type igs_co_mapping.doc_code%TYPE;
180: l_request_status VARCHAR2 (100);
181: l_send_letter VARCHAR2 (10);
182: l_sql_stmt VARCHAR2 (32767);
183: -- these variables are required becuase when it is FAM related, Admission Application detials will be Null and when