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.

APPS.IGS_PR_GEN_006 dependencies on IGS_PR_OU_UNIT

Line 733: gv_err_ins_pous VARCHAR2(255); -- IGS_PR_OU_UNIT_SET

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
735: gv_err_ins_popf VARCHAR2(255); -- IGS_PR_OU_FND
736: gv_new_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE;
737: BEGIN -- IGS_PR_ins_copy_pra

Line 734: gv_err_ins_popu VARCHAR2(255); -- IGS_PR_OU_UNIT

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
735: gv_err_ins_popf VARCHAR2(255); -- IGS_PR_OU_FND
736: gv_new_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE;
737: BEGIN -- IGS_PR_ins_copy_pra
738: -- Copy a IGS_PR_RU_APPL structure. This is used when parent object

Line 754: -- Prodecdure to create new IGS_PR_OU_RS, IGS_PR_OU_UNIT_SET

750: p_new_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE,
751: p_message_name IN OUT NOCOPY IGS_PR_S_SCRATCH_PAD.MESSAGE_NAME%TYPE)
752: IS
753: BEGIN -- prgpl_ins_poc
754: -- Prodecdure to create new IGS_PR_OU_RS, IGS_PR_OU_UNIT_SET
755: -- and IGS_PR_OU_UNIT records
756:
757: --Modified as part of Academic Standing and Progression build
758: -- to add records to the IGS_PR_OU_AWD table as well

Line 755: -- and IGS_PR_OU_UNIT records

751: p_message_name IN OUT NOCOPY IGS_PR_S_SCRATCH_PAD.MESSAGE_NAME%TYPE)
752: IS
753: BEGIN -- prgpl_ins_poc
754: -- Prodecdure to create new IGS_PR_OU_RS, IGS_PR_OU_UNIT_SET
755: -- and IGS_PR_OU_UNIT records
756:
757: --Modified as part of Academic Standing and Progression build
758: -- to add records to the IGS_PR_OU_AWD table as well
759: -- amuthu 6-Dec-2001

Line 770: FROM IGS_PR_OU_UNIT_SET pous

766: poc.pro_sequence_number = p_pro_sequence_number;
767: CURSOR c_pous IS
768: SELECT pous.unit_set_cd,
769: pous.us_version_number
770: FROM IGS_PR_OU_UNIT_SET pous
771: WHERE pous.progression_rule_cat = p_progression_rule_cat AND
772: pous.pra_sequence_number = p_pra_sequence_number AND
773: pous.pro_sequence_number = p_pro_sequence_number;
774:

Line 784: FROM IGS_PR_OU_UNIT popu

780: poa.pro_sequence_number = p_pro_sequence_number;
781: CURSOR c_popu IS
782: SELECT popu.unit_cd,
783: popu.s_unit_type
784: FROM IGS_PR_OU_UNIT popu
785: WHERE popu.progression_rule_cat = p_progression_rule_cat AND
786: popu.pra_sequence_number = p_pra_sequence_number AND
787: popu.pro_sequence_number = p_pro_sequence_number;
788: --

Line 835: IGS_PR_OU_UNIT_SET_PKG.INSERT_ROW (

831: lv_rowid VARCHAR2(25);
832: l_org_id NUMBER(15);
833: BEGIN
834: l_org_id := igs_ge_gen_003.get_org_id;
835: IGS_PR_OU_UNIT_SET_PKG.INSERT_ROW (
836: X_ROWID =>LV_ROWID,
837: X_PROGRESSION_RULE_CAT =>p_progression_rule_cat,
838: X_PRA_SEQUENCE_NUMBER =>p_new_pra_sequence_number,
839: X_PRO_SEQUENCE_NUMBER =>p_new_pro_sequence_number,

Line 891: IGS_PR_OU_UNIT_PKG.INSERT_ROW (

887: lv_rowid VARCHAR2(25);
888: l_org_id NUMBER(15);
889: BEGIN
890: l_org_id := igs_ge_gen_003.get_org_id;
891: IGS_PR_OU_UNIT_PKG.INSERT_ROW (
892: X_ROWID =>LV_ROWID,
893: X_PROGRESSION_RULE_CAT =>p_progression_rule_cat,
894: X_PRA_SEQUENCE_NUMBER =>p_new_pra_sequence_number,
895: X_PRO_SEQUENCE_NUMBER =>p_new_pro_sequence_number,

Line 1313: -- Where existing, copy IGS_PR_OU_RS, IGS_PR_OU_UNIT_SET and

1309: ELSE
1310: RAISE;
1311: END IF;
1312: END;
1313: -- Where existing, copy IGS_PR_OU_RS, IGS_PR_OU_UNIT_SET and
1314: -- IGS_PR_OU_UNIT records, moving from the old to new pro record
1315: IF v_error_ins_pro = FALSE THEN
1316: prgpl_ins_poc_pous_popu(
1317: p_progression_rule_cat,

Line 1314: -- IGS_PR_OU_UNIT records, moving from the old to new pro record

1310: RAISE;
1311: END IF;
1312: END;
1313: -- Where existing, copy IGS_PR_OU_RS, IGS_PR_OU_UNIT_SET and
1314: -- IGS_PR_OU_UNIT records, moving from the old to new pro record
1315: IF v_error_ins_pro = FALSE THEN
1316: prgpl_ins_poc_pous_popu(
1317: p_progression_rule_cat,
1318: p_sequence_number, -- old pra_sequence_number

Line 1325: gv_err_ins_pous := 'IGS_PR_OU_UNIT_SET ';

1321: v_new_pro_sequence_number,
1322: p_message_name); -- IN OUT NOCOPY
1323: ELSE
1324: gv_err_ins_poc := 'IGS_PR_OU_RS ';
1325: gv_err_ins_pous := 'IGS_PR_OU_UNIT_SET ';
1326: gv_err_ins_popu := 'IGS_PR_OU_UNIT ';
1327: END IF;
1328: OPEN c_pra_check_pro (
1329: p_progression_rule_cat,

Line 1326: gv_err_ins_popu := 'IGS_PR_OU_UNIT ';

1322: p_message_name); -- IN OUT NOCOPY
1323: ELSE
1324: gv_err_ins_poc := 'IGS_PR_OU_RS ';
1325: gv_err_ins_pous := 'IGS_PR_OU_UNIT_SET ';
1326: gv_err_ins_popu := 'IGS_PR_OU_UNIT ';
1327: END IF;
1328: OPEN c_pra_check_pro (
1329: p_progression_rule_cat,
1330: p_sequence_number,

Line 1373: gv_err_ins_pous := 'IGS_PR_OU_UNIT_SET ';

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 ';
1375: gv_err_ins_popf := 'IGS_PR_OU_FND';
1376: END IF;
1377: RETURN gv_new_pra_sequence_number;

Line 1374: gv_err_ins_popu := 'IGS_PR_OU_UNIT ';

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 ';
1375: gv_err_ins_popf := 'IGS_PR_OU_FND';
1376: END IF;
1377: RETURN gv_new_pra_sequence_number;
1378: EXCEPTION