APPS.IGS_PR_GEN_006 dependencies on IGS_PR_RU_CA_TYPE

Line 730: gv_err_ins_prrc VARCHAR2(255); -- IGS_PR_RU_CA_TYPE

726: gv_other_detail VARCHAR2(255);
727: gv_err_inserting VARCHAR2(255);
728: gv_err_ins_rule VARCHAR2(255); -- creating progression rule
729: gv_err_ins_pra VARCHAR2(255); -- IGS_PR_RU_APPL
730: gv_err_ins_prrc VARCHAR2(255); -- IGS_PR_RU_CA_TYPE
731: gv_err_ins_pro VARCHAR2(255); -- IGS_PR_RU_OU
732: gv_err_ins_poc VARCHAR2(255); -- IGS_PR_OU_RS
733: gv_err_ins_pous VARCHAR2(255); -- IGS_PR_OU_UNIT_SET
734: gv_err_ins_popu VARCHAR2(255); -- IGS_PR_OU_UNIT

Line 1066: FROM IGS_PR_RU_CA_TYPE prrc

1062: prrc.start_sequence_number,
1063: prrc.end_sequence_number,
1064: prrc.start_effective_period,
1065: prrc.num_of_applications
1066: FROM IGS_PR_RU_CA_TYPE prrc
1067: WHERE prrc.progression_rule_cat = p_progression_rule_cat AND
1068: prrc.pra_sequence_number = p_sequence_number;
1069: -- Retrieve child of old IGS_PR_RU_APPL record
1070: CURSOR c_pro IS

Line 1248: IGS_PR_RU_CA_TYPE_PKG.INSERT_ROW (

1244: lv_rowid VARCHAR2(25);
1245: l_org_id NUMBER(15);
1246: BEGIN
1247: l_org_id := igs_ge_gen_003.get_org_id;
1248: IGS_PR_RU_CA_TYPE_PKG.INSERT_ROW (
1249: X_ROWID =>LV_ROWID,
1250: X_PROGRESSION_RULE_CAT =>p_progression_rule_cat,
1251: X_PRA_SEQUENCE_NUMBER=> gv_new_pra_sequence_number,
1252: X_PRG_CAL_TYPE =>v_prrc_rec.prg_cal_type,

Line 1370: gv_err_ins_prrc := 'IGS_PR_RU_CA_TYPE ';

1366: END LOOP;
1367: ELSE
1368: -- Records cannot be inserted because a new IGS_PR_RU_APPL
1369: -- record was not created.
1370: gv_err_ins_prrc := 'IGS_PR_RU_CA_TYPE ';
1371: gv_err_ins_pro := 'IGS_PR_RU_OU ';
1372: gv_err_ins_poc := 'IGS_PR_OU_RS ';
1373: gv_err_ins_pous := 'IGS_PR_OU_UNIT_SET ';
1374: gv_err_ins_popu := 'IGS_PR_OU_UNIT ';