APPS.IGS_AD_ASSIGN_REVIEW_GRP dependencies on IGS_AD_APPL_ARP_PKG

Line 420: igs_ad_appl_arp_pkg.insert_row (

416: IF c_arp_rec_found%NOTFOUND THEN
417: -- Insert Using TableHandler
418: lv_rowid := NULL;
419: lv_appl_arp_id := NULL;
420: igs_ad_appl_arp_pkg.insert_row (
421: x_rowid => lv_rowid,
422: x_appl_arp_id => lv_appl_arp_id,
423: x_person_id => l_person_id,
424: x_admission_appl_number => l_admission_appl_number,

Line 439: igs_ad_appl_arp_pkg.update_row (

435: LPAD(l_nominated_course_cd,'15',' ')||
436: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));
437: ELSIF c_arp_rec_found_rec.appl_revprof_revgr_id IS NULL THEN
438: -- Update Using Table Handler
439: igs_ad_appl_arp_pkg.update_row (
440: x_rowid => c_arp_rec_found_rec.rowid,
441: x_appl_arp_id => c_arp_rec_found_rec.appl_arp_id,
442: x_person_id => c_arp_rec_found_rec.person_id,
443: x_admission_appl_number => c_arp_rec_found_rec.admission_appl_number,

Line 791: igs_ad_appl_arp_pkg.insert_row (

787: IF c_arp_rec_found%NOTFOUND THEN
788: -- Insert Using TableHandler
789: lv_rowid := NULL;
790: lv_appl_arp_id := NULL;
791: igs_ad_appl_arp_pkg.insert_row (
792: x_rowid => lv_rowid,
793: x_appl_arp_id => lv_appl_arp_id,
794: x_person_id => l_person_id,
795: x_admission_appl_number => l_admission_appl_number,

Line 811: igs_ad_appl_arp_pkg.update_row (

807: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));
808:
809: ELSIF c_arp_rec_found_rec.appl_revprof_revgr_id IS NULL THEN
810: -- Update Using Table Handler
811: igs_ad_appl_arp_pkg.update_row (
812: x_rowid => c_arp_rec_found_rec.rowid,
813: x_appl_arp_id => c_arp_rec_found_rec.appl_arp_id,
814: x_person_id => c_arp_rec_found_rec.person_id,
815: x_admission_appl_number => c_arp_rec_found_rec.admission_appl_number,

Line 1163: igs_ad_appl_arp_pkg.insert_row (

1159: IF c_arp_rec_found%NOTFOUND THEN
1160: -- Insert Using TableHandler
1161: lv_rowid := NULL;
1162: lv_appl_arp_id := NULL;
1163: igs_ad_appl_arp_pkg.insert_row (
1164: x_rowid => lv_rowid,
1165: x_appl_arp_id => lv_appl_arp_id,
1166: x_person_id => l_person_id,
1167: x_admission_appl_number => l_admission_appl_number,

Line 1184: igs_ad_appl_arp_pkg.update_row (

1180: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));
1181:
1182: ELSIF c_arp_rec_found_rec.appl_revprof_revgr_id IS NULL THEN
1183: -- Update Using Table Handler
1184: igs_ad_appl_arp_pkg.update_row (
1185: x_rowid => c_arp_rec_found_rec.rowid,
1186: x_appl_arp_id => c_arp_rec_found_rec.appl_arp_id,
1187: x_person_id => c_arp_rec_found_rec.person_id,
1188: x_admission_appl_number => c_arp_rec_found_rec.admission_appl_number,

Line 1464: igs_ad_appl_arp_pkg.insert_row (

1460: IF c_arp_rec_found%NOTFOUND THEN
1461: -- Insert Using TableHandler
1462: lv_rowid := NULL;
1463: lv_appl_arp_id := NULL;
1464: igs_ad_appl_arp_pkg.insert_row (
1465: x_rowid => lv_rowid,
1466: x_appl_arp_id => lv_appl_arp_id,
1467: x_person_id => l_person_id,
1468: x_admission_appl_number => l_admission_appl_number,

Line 1484: igs_ad_appl_arp_pkg.update_row (

1480: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));
1481:
1482: ELSIF c_arp_rec_found_rec.appl_revprof_revgr_id IS NULL THEN
1483: -- Update Using Table Handler
1484: igs_ad_appl_arp_pkg.update_row (
1485: x_rowid => c_arp_rec_found_rec.rowid,
1486: x_appl_arp_id => c_arp_rec_found_rec.appl_arp_id,
1487: x_person_id => c_arp_rec_found_rec.person_id,
1488: x_admission_appl_number => c_arp_rec_found_rec.admission_appl_number,

Line 1687: igs_ad_appl_arp_pkg.insert_row (

1683: IF c_arp_rec_found%NOTFOUND THEN
1684: -- Insert Using TableHandler
1685: lv_rowid := NULL;
1686: lv_appl_arp_id := NULL;
1687: igs_ad_appl_arp_pkg.insert_row (
1688: x_rowid => lv_rowid,
1689: x_appl_arp_id => lv_appl_arp_id,
1690: x_person_id => l_person_id,
1691: x_admission_appl_number => l_admission_appl_number,

Line 1708: igs_ad_appl_arp_pkg.update_row (

1704: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));
1705:
1706: ELSIF c_arp_rec_found_rec.appl_revprof_revgr_id IS NULL THEN
1707: -- Update Using Table Handler
1708: igs_ad_appl_arp_pkg.update_row (
1709: x_rowid => c_arp_rec_found_rec.rowid,
1710: x_appl_arp_id => c_arp_rec_found_rec.appl_arp_id,
1711: x_person_id => c_arp_rec_found_rec.person_id,
1712: x_admission_appl_number => c_arp_rec_found_rec.admission_appl_number,

Line 1906: igs_ad_appl_arp_pkg.insert_row (

1902: IF c_arp_rec_found%NOTFOUND THEN
1903: -- Insert Using TableHandler
1904: lv_rowid := NULL;
1905: lv_appl_arp_id := NULL;
1906: igs_ad_appl_arp_pkg.insert_row (
1907: x_rowid => lv_rowid,
1908: x_appl_arp_id => lv_appl_arp_id,
1909: x_person_id => l_person_id,
1910: x_admission_appl_number => l_admission_appl_number,

Line 1927: igs_ad_appl_arp_pkg.update_row (

1923: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));
1924:
1925: ELSIF c_arp_rec_found_rec.appl_revprof_revgr_id IS NULL THEN
1926: -- Update Using Table Handler
1927: igs_ad_appl_arp_pkg.update_row (
1928: x_rowid => c_arp_rec_found_rec.rowid,
1929: x_appl_arp_id => c_arp_rec_found_rec.appl_arp_id,
1930: x_person_id => c_arp_rec_found_rec.person_id,
1931: x_admission_appl_number => c_arp_rec_found_rec.admission_appl_number,