APPS.IGS_AD_VAL_APAC dependencies on IGS_AD_PRD_AD_PRC_CA_PKG

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,