APPS.IGS_CO_GEN_002 dependencies on IGS_CO_S_PER_LT_PARM

Line 81: cp_sequence_number IGS_CO_S_PER_LT_PARM.sequence_number%TYPE,

77: WHERE spl.sequence_number = cp_sequence_number
78: AND spl.person_id = cp_person_id
79: FOR UPDATE OF spl.sequence_number NOWAIT;
80: CURSOR c_splp(
81: cp_sequence_number IGS_CO_S_PER_LT_PARM.sequence_number%TYPE,
82: cp_person_id IGS_CO_S_PER_LT_PARM.person_id%TYPE) IS
83: SELECT ROWID
84: FROM IGS_CO_S_PER_LT_PARM splp
85: WHERE splp.spl_sequence_number = cp_sequence_number

Line 82: cp_person_id IGS_CO_S_PER_LT_PARM.person_id%TYPE) IS

78: AND spl.person_id = cp_person_id
79: FOR UPDATE OF spl.sequence_number NOWAIT;
80: CURSOR c_splp(
81: cp_sequence_number IGS_CO_S_PER_LT_PARM.sequence_number%TYPE,
82: cp_person_id IGS_CO_S_PER_LT_PARM.person_id%TYPE) IS
83: SELECT ROWID
84: FROM IGS_CO_S_PER_LT_PARM splp
85: WHERE splp.spl_sequence_number = cp_sequence_number
86: AND splp.person_id = cp_person_id

Line 84: FROM IGS_CO_S_PER_LT_PARM splp

80: CURSOR c_splp(
81: cp_sequence_number IGS_CO_S_PER_LT_PARM.sequence_number%TYPE,
82: cp_person_id IGS_CO_S_PER_LT_PARM.person_id%TYPE) IS
83: SELECT ROWID
84: FROM IGS_CO_S_PER_LT_PARM splp
85: WHERE splp.spl_sequence_number = cp_sequence_number
86: AND splp.person_id = cp_person_id
87: FOR UPDATE OF splp.spl_sequence_number NOWAIT;
88: CURSOR c_splrg(

Line 196: IGS_CO_S_PER_LT_PARM_PKG.DELETE_ROW(X_ROWID=>v_splp_rec.ROWID);

192: -- delete any parameters for this letter
193: FOR v_splp_rec IN c_splp(
194: v_spl_sequence_number,
195: v_ocr_rec.person_id) LOOP
196: IGS_CO_S_PER_LT_PARM_PKG.DELETE_ROW(X_ROWID=>v_splp_rec.ROWID);
197: END LOOP;
198: -- delete the repeating groups. Must delete in the correct order as
199: -- table can contain parent/child relationship
200: FOR v_splrg_rec IN c_splrg(

Line 284: -- a record into the IGS_CO_S_PER_LT_PARM table.

280: p_letter_order_number IN number)
281: RETURN BOOLEAN AS
282: BEGIN -- corp_ins_splp
283: -- This module calculates the value for a IGS_CO_LTR_PARAM and inserts
284: -- a record into the IGS_CO_S_PER_LT_PARM table.
285: DECLARE
286: cst_in CONSTANT VARCHAR2(2) := 'IN';
287: cst_out CONSTANT VARCHAR2(3) := 'OUT';
288: cst_phrase CONSTANT VARCHAR2(6) := 'PHRASE';

Line 303: v_sequence_number IGS_CO_S_PER_LT_PARM.sequence_number%TYPE;

299: cst_v_value CONSTANT VARCHAR2(7) := 'v_value';
300: v_dbms INTEGER;
301: v_dbms_return INTEGER;
302: v_value VARCHAR2(2000);
303: v_sequence_number IGS_CO_S_PER_LT_PARM.sequence_number%TYPE;
304: v_lpt_s_letter_parameter_type
305: IGS_CO_LTR_PARM_TYPE.S_LETTER_PARAMETER_TYPE%TYPE;
306: v_letter_text IGS_CO_LTR_PARM_TYPE.letter_text%TYPE;
307: v_code_block IGS_CO_S_LTR_PARAM.code_block%TYPE;

Line 311: v_aal_sequence_number IGS_CO_S_PER_LT_PARM.sequence_number%TYPE;

307: v_code_block IGS_CO_S_LTR_PARAM.code_block%TYPE;
308: v_slpt_s_letter_parameter_type
309: IGS_CO_S_LTR_PARAM.S_LETTER_PARAMETER_TYPE%TYPE;
310: v_adm_appl_num IGS_AD_APPL.admission_appl_number%TYPE;
311: v_aal_sequence_number IGS_CO_S_PER_LT_PARM.sequence_number%TYPE;
312: v_extra_context VARCHAR2(100);
313: v_message_name varchar2(30);
314: X_ROWID VARCHAR2(25);
315: CURSOR c_get_nxt_seq IS

Line 316: SELECT IGS_CO_S_PER_LT_PARM_SEQ_NUM_S.NEXTVAL

312: v_extra_context VARCHAR2(100);
313: v_message_name varchar2(30);
314: X_ROWID VARCHAR2(25);
315: CURSOR c_get_nxt_seq IS
316: SELECT IGS_CO_S_PER_LT_PARM_SEQ_NUM_S.NEXTVAL
317: FROM DUAL;
318: CURSOR c_lpt IS
319: SELECT lpt.S_LETTER_PARAMETER_TYPE,
320: lpt.letter_text,

Line 459: IGS_CO_S_PER_LT_PARM_PKG.INSERT_ROW(X_ROWID=>X_ROWID,

455: -- splp_sequence_number.NEXTVAL
456: OPEN c_get_nxt_seq;
457: FETCH c_get_nxt_seq INTO v_sequence_number;
458: CLOSE c_get_nxt_seq;
459: IGS_CO_S_PER_LT_PARM_PKG.INSERT_ROW(X_ROWID=>X_ROWID,
460: X_PERSON_ID=>p_person_id,
461: X_CORRESPONDENCE_TYPE=>p_correspondence_type,
462: X_LETTER_REFERENCE_NUMBER=>p_letter_reference_number,
463: X_SPL_SEQUENCE_NUMBER=>p_spl_sequence_number,