APPS.IGS_UC_PROC_COM_INST_DATA dependencies on IGS_UC_COM_SCSICNTS

Line 1269: FROM igs_uc_com_scsicnts csscn

1265: p_site_code igs_uc_cschcnt_ints.sitecode%TYPE,
1266: p_contact_cd igs_uc_cschcnt_ints.contactcode%TYPE) IS
1267: SELECT csscn.rowid,
1268: csscn.*
1269: FROM igs_uc_com_scsicnts csscn
1270: WHERE csscn.school = p_school
1271: AND csscn.sitecode = p_site_code
1272: AND csscn.contact_code = p_contact_cd;
1273:

Line 1368: igs_uc_com_scsicnts_pkg.insert_row --IGSXI12B.pls

1364: IF old_schsite_cnt_rec.rowid IS NULL THEN
1365:
1366: BEGIN
1367: -- insert a new record in the main table
1368: igs_uc_com_scsicnts_pkg.insert_row --IGSXI12B.pls
1369: (
1370: x_rowid => old_schsite_cnt_rec.rowid
1371: ,x_school => new_schcntct_rec.school
1372: ,x_sitecode => new_schcntct_rec.sitecode

Line 1400: igs_uc_com_scsicnts_pkg.update_row --IGSXI12B.pls

1396: ELSE -- update
1397:
1398: BEGIN
1399: -- update a new record in the main table
1400: igs_uc_com_scsicnts_pkg.update_row --IGSXI12B.pls
1401: (
1402: x_rowid => old_schsite_cnt_rec.rowid
1403: ,x_school => new_schcntct_rec.school
1404: ,x_sitecode => new_schcntct_rec.sitecode