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.

[Home] [Help]

APPS.IGS_AD_VAL_APAC dependencies on IGS_AD_PRD_AD_PRC_CA

Line 241: cp_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,

237: -- Enhancement: 3132406 nsinha 9/25/2003 added new parameter p_prior_adm_ci_seq_number
238: -- Added logic related to cursor c_apapc_roll.
239: DECLARE
240: CURSOR c_apapc(
241: cp_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,
242: cp_sequence_number IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE,
243: cp_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE) IS
244: SELECT 'x'
245: FROM IGS_AD_PRD_AD_PRC_CA

Line 242: cp_sequence_number IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE,

238: -- Added logic related to cursor c_apapc_roll.
239: DECLARE
240: CURSOR c_apapc(
241: cp_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,
242: cp_sequence_number IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE,
243: cp_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE) IS
244: SELECT 'x'
245: FROM IGS_AD_PRD_AD_PRC_CA
246: WHERE adm_cal_type = cp_cal_type AND

Line 243: cp_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE) IS

239: DECLARE
240: CURSOR c_apapc(
241: cp_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,
242: cp_sequence_number IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE,
243: cp_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE) IS
244: SELECT 'x'
245: FROM IGS_AD_PRD_AD_PRC_CA
246: WHERE adm_cal_type = cp_cal_type AND
247: adm_ci_sequence_number = cp_sequence_number AND

Line 245: FROM IGS_AD_PRD_AD_PRC_CA

241: cp_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,
242: cp_sequence_number IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE,
243: cp_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE) IS
244: SELECT 'x'
245: FROM IGS_AD_PRD_AD_PRC_CA
246: WHERE adm_cal_type = cp_cal_type AND
247: adm_ci_sequence_number = cp_sequence_number AND
248: admission_cat = cp_admission_cat;
249: CURSOR c_apc(

Line 250: cp_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE) IS

246: WHERE adm_cal_type = cp_cal_type AND
247: adm_ci_sequence_number = cp_sequence_number AND
248: admission_cat = cp_admission_cat;
249: CURSOR c_apc(
250: cp_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE) IS
251: SELECT s_admission_process_type
252: FROM IGS_AD_PRCS_CAT
253: WHERE admission_cat = cp_admission_cat
254: AND closed_ind = 'N'; --added the closed indicator for bug# 2380108 (rghosh)

Line 259: cp_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,

255: v_apapc_rec c_apapc%ROWTYPE;
256: v_rowid VARCHAR2(25);
257:
258: CURSOR c_apapc_roll (
259: cp_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,
260: cp_sequence_number IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE,
261: cp_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE) IS
262: SELECT *
263: FROM IGS_AD_PRD_AD_PRC_CA

Line 260: cp_sequence_number IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE,

256: v_rowid VARCHAR2(25);
257:
258: CURSOR c_apapc_roll (
259: cp_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,
260: cp_sequence_number IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE,
261: cp_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE) IS
262: SELECT *
263: FROM IGS_AD_PRD_AD_PRC_CA
264: WHERE adm_cal_type = cp_cal_type AND

Line 261: cp_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE) IS

257:
258: CURSOR c_apapc_roll (
259: cp_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,
260: cp_sequence_number IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE,
261: cp_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE) IS
262: SELECT *
263: FROM IGS_AD_PRD_AD_PRC_CA
264: WHERE adm_cal_type = cp_cal_type AND
265: adm_ci_sequence_number = cp_sequence_number AND

Line 263: FROM IGS_AD_PRD_AD_PRC_CA

259: cp_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,
260: cp_sequence_number IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE,
261: cp_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE) IS
262: SELECT *
263: FROM IGS_AD_PRD_AD_PRC_CA
264: WHERE adm_cal_type = cp_cal_type AND
265: adm_ci_sequence_number = cp_sequence_number AND
266: admission_cat = cp_admission_cat AND
267: NVL (closed_ind,'N') = 'N';

Line 268: l_single_response_flag igs_ad_prd_ad_prc_ca.single_response_flag%TYPE;

264: WHERE adm_cal_type = cp_cal_type AND
265: adm_ci_sequence_number = cp_sequence_number AND
266: admission_cat = cp_admission_cat AND
267: NVL (closed_ind,'N') = 'N';
268: l_single_response_flag igs_ad_prd_ad_prc_ca.single_response_flag%TYPE;
269:
270: BEGIN
271: p_message_name := Null;
272: -- Check that an IGS_AD_PRD_AD_PRC_CA record does not already exist

Line 272: -- Check that an IGS_AD_PRD_AD_PRC_CA record does not already exist

268: l_single_response_flag igs_ad_prd_ad_prc_ca.single_response_flag%TYPE;
269:
270: BEGIN
271: p_message_name := Null;
272: -- Check that an IGS_AD_PRD_AD_PRC_CA record does not already exist
273: OPEN c_apapc(
274: p_adm_cal_type,
275: p_adm_ci_sequence_number,
276: p_admission_cat);

Line 288: IGS_AD_PRD_AD_PRC_CA_PKG.INSERT_ROW(

284:
285: IF p_prior_adm_ci_seq_number IS NULL THEN
286: FOR v_apc_rec IN c_apc(p_admission_cat) LOOP
287:
288: IGS_AD_PRD_AD_PRC_CA_PKG.INSERT_ROW(
289: X_ROWID => v_rowid,
290: X_ADM_CAL_TYPE => p_adm_cal_type,
291: X_ADM_CI_SEQUENCE_NUMBER => p_adm_ci_sequence_number,
292: X_ADMISSION_CAT => p_admission_cat,

Line 299: -- INSERT INTO IGS_AD_PRD_AD_PRC_CA_PKG, the records fetched by above cursor as follows

295:
296: END LOOP;
297: ELSE -- p_prior_adm_ci_seq_number parameter IS NOT NULL
298: -- OPEN c_apapc_roll (p_adm_cal_type, p_prior_adm_ci_seq_number, p_admission_cat)
299: -- INSERT INTO IGS_AD_PRD_AD_PRC_CA_PKG, the records fetched by above cursor as follows
300: FOR v_apapc_rec IN c_apapc_roll (p_adm_cal_type, p_prior_adm_ci_seq_number, p_admission_cat) LOOP
301: --DECODE(v_apapc_rec.include_sr_in_rollover_flag,'Y', v_apapc_rec.single_response_flag ,'N')
302: IF v_apapc_rec.include_sr_in_rollover_flag = 'Y' THEN
303: l_single_response_flag := v_apapc_rec.single_response_flag;

Line 308: IGS_AD_PRD_AD_PRC_CA_PKG.INSERT_ROW (

304: ELSE
305: l_single_response_flag := 'N';
306: END IF;
307:
308: IGS_AD_PRD_AD_PRC_CA_PKG.INSERT_ROW (
309: X_ROWID => v_rowid,
310: X_ADM_CAL_TYPE => p_adm_cal_type,
311: X_ADM_CI_SEQUENCE_NUMBER => p_adm_ci_sequence_number,
312: X_ADMISSION_CAT => p_admission_cat,