APPS.IGS_EN_GEN_012 dependencies on IGS_PE_TYP_INSTANCES_PKG

Line 8: --npalanis 10-JUN-2003 Bug:2923413 igs_pe_typ_instances_pkgs call

4: --Change History:
5: --Who When What
6: --ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure
7: call as a part of bug 3544927.
8: --npalanis 10-JUN-2003 Bug:2923413 igs_pe_typ_instances_pkgs call
9: -- modified for the new employment category column added in the table
10: --pradhakr 16-Dec-2002 Changed the call to the update_row of igs_en_su_attempt
11: -- table to igs_en_sua_api.update_unit_attempt.
12: -- Changes wrt ENCR031 build. Bug#2643207

Line 1976: Igs_Pe_Typ_Instances_Pkg.update_row(

1972:
1973: BEGIN
1974:
1975: FOR c2_rec IN c2 LOOP
1976: Igs_Pe_Typ_Instances_Pkg.update_row(
1977: -- X_ROWID =>l_rowid, -- Old
1978: X_ROWID =>c2_rec.ROWID, -- New due to bug no#1516658
1979: X_PERSON_ID =>c2_rec.PERSON_ID,
1980: X_COURSE_CD =>c2_rec.COURSE_CD,

Line 1999: Igs_Pe_Typ_Instances_Pkg.insert_row(

1995: X_EMPLMNT_CATEGORY_CODE => c2_rec.emplmnt_category_code);
1996:
1997: END LOOP; -- End loop for Ending the Type.
1998:
1999: Igs_Pe_Typ_Instances_Pkg.insert_row(
2000: X_ROWID =>l_rowid,
2001: X_PERSON_ID => v_sca_exists.PERSON_ID,
2002: X_COURSE_CD =>v_sca_exists.COURSE_CD,
2003: X_TYPE_INSTANCE_ID =>l_pk,

Line 2025: Igs_Pe_Typ_Instances_Pkg.insert_row(

2021: END;-- End for Update Process
2022:
2023: ELSE -- If Cursor%NOTFOUND
2024:
2025: Igs_Pe_Typ_Instances_Pkg.insert_row(
2026: X_ROWID =>l_rowid,
2027: X_PERSON_ID => v_sca_exists.PERSON_ID,
2028: X_COURSE_CD =>v_sca_exists.COURSE_CD,
2029: X_TYPE_INSTANCE_ID =>l_pk,

Line 2309: Igs_Pe_Typ_Instances_Pkg.update_row(

2305:
2306:
2307: FOR c2_rec IN c2 LOOP
2308:
2309: Igs_Pe_Typ_Instances_Pkg.update_row(
2310: -- previously l_rowid was being passed to the update row
2311: -- changed it to c2_rec.rowid
2312: -- amuthu 27-Jul-2001
2313: X_ROWID =>c2_rec.ROWID,

Line 2334: Igs_Pe_Typ_Instances_Pkg.insert_row(

2330: X_EMPLMNT_CATEGORY_CODE => c2_rec.emplmnt_category_code);
2331: END LOOP; -- End loop for Ending the Type.
2332:
2333:
2334: Igs_Pe_Typ_Instances_Pkg.insert_row(
2335: X_ROWID =>l_rowid,
2336: X_PERSON_ID => c_ps_att_rec.PERSON_ID,
2337: X_COURSE_CD =>c_ps_att_rec.COURSE_CD,
2338: X_TYPE_INSTANCE_ID =>l_pk,

Line 2361: Igs_Pe_Typ_Instances_Pkg.insert_row(

2357: ELSE -- If Cursor%NOTFOUND
2358: DECLARE
2359: l_org_id NUMBER := igs_ge_gen_003.get_org_id;
2360: BEGIN
2361: Igs_Pe_Typ_Instances_Pkg.insert_row(
2362: X_ROWID =>l_rowid,
2363: X_PERSON_ID => c_ps_att_rec.PERSON_ID,
2364: X_COURSE_CD =>c_ps_att_rec.COURSE_CD,
2365: X_TYPE_INSTANCE_ID =>l_pk,

Line 2742: Igs_Pe_Typ_Instances_Pkg.update_row(

2738:
2739:
2740:
2741: FOR c2_rec IN c2 LOOP
2742: Igs_Pe_Typ_Instances_Pkg.update_row(
2743: -- previously l_rowid was being passed to the update row
2744: -- changed it to c2_rec.rowid
2745: -- amuthu 27-Jul-2001
2746: X_ROWID =>c2_rec.ROWID,

Line 2765: Igs_Pe_Typ_Instances_Pkg.insert_row(

2761: X_END_METHOD =>'PRG_ATTMPT_ST_INACTIVE',
2762: X_MODE =>'R',
2763: X_EMPLMNT_CATEGORY_CODE => c2_rec.emplmnt_category_code);
2764: END LOOP; -- End loop for Ending the Type.
2765: Igs_Pe_Typ_Instances_Pkg.insert_row(
2766: X_ROWID =>l_rowid,
2767: X_PERSON_ID => c_enps_att_rec.PERSON_ID,
2768: X_COURSE_CD =>c_enps_att_rec.COURSE_CD,
2769: X_TYPE_INSTANCE_ID =>l_pk,

Line 2794: Igs_Pe_Typ_Instances_Pkg.insert_row(

2790: DECLARE
2791:
2792: l_org_id NUMBER := igs_ge_gen_003.get_org_id;
2793: BEGIN
2794: Igs_Pe_Typ_Instances_Pkg.insert_row(
2795: X_ROWID =>l_rowid,
2796: X_PERSON_ID => c_enps_att_rec.PERSON_ID,
2797: X_COURSE_CD =>c_enps_att_rec.COURSE_CD,
2798: X_TYPE_INSTANCE_ID =>l_pk,