DBA Data[Home] [Help]

APPS.IGS_PR_GEN_006 dependencies on IGS_PR_OU_PS

Line 763: FROM IGS_PR_OU_PS poc

759: -- amuthu 6-Dec-2001
760: DECLARE
761: CURSOR c_poc IS
762: SELECT poc.course_cd
763: FROM IGS_PR_OU_PS poc
764: WHERE poc.progression_rule_cat = p_progression_rule_cat AND
765: poc.pra_sequence_number = p_pra_sequence_number AND
766: poc.pro_sequence_number = p_pro_sequence_number;
767: CURSOR c_pous IS

Line 809: IGS_PR_OU_PS_PKG.INSERT_ROW (

805: lv_rowid VARCHAR2(25);
806: l_org_id NUMBER(15);
807: BEGIN
808: l_org_id := igs_ge_gen_003.get_org_id;
809: IGS_PR_OU_PS_PKG.INSERT_ROW (
810: X_ROWID =>LV_ROWID,
811: X_PROGRESSION_RULE_CAT =>p_progression_rule_cat,
812: X_PRA_SEQUENCE_NUMBER =>p_new_pra_sequence_number,
813: X_PRO_SEQUENCE_NUMBER =>p_new_pro_sequence_number,