APPS.IGS_UC_PROC_REFERENCE_DATA dependencies on IGS_UC_CJNTADM_INTS

Line 1420: FROM igs_uc_cjntadm_ints

1416: ,parentinst2
1417: ,parentinst3
1418: ,parentinst4
1419: ,parentinst5
1420: FROM igs_uc_cjntadm_ints
1421: WHERE record_status = 'N';
1422:
1423: -- check whether corresponding record already exists.
1424: CURSOR old_cjntadm_cur (p_childinst igs_uc_cjntadm_ints.childinst%TYPE) IS

Line 1424: CURSOR old_cjntadm_cur (p_childinst igs_uc_cjntadm_ints.childinst%TYPE) IS

1420: FROM igs_uc_cjntadm_ints
1421: WHERE record_status = 'N';
1422:
1423: -- check whether corresponding record already exists.
1424: CURSOR old_cjntadm_cur (p_childinst igs_uc_cjntadm_ints.childinst%TYPE) IS
1425: SELECT rowid
1426: FROM igs_uc_jnt_adm_inst
1427: WHERE child_inst = p_childinst ;
1428:

Line 1618: UPDATE igs_uc_cjntadm_ints

1614:
1615: -- update the interface table rec - record_status if successfully processed or Error Code if any error encountered
1616: -- while processing the record.
1617: IF g_error_code IS NOT NULL THEN
1618: UPDATE igs_uc_cjntadm_ints
1619: SET error_code = g_error_code
1620: WHERE rowid = new_cjntadm_rec.rowid;
1621:
1622: -- log error message/meaning.

Line 1628: UPDATE igs_uc_cjntadm_ints

1624: -- update error count
1625: g_error_rec_cnt := g_error_rec_cnt + 1;
1626:
1627: ELSE
1628: UPDATE igs_uc_cjntadm_ints
1629: SET record_status = 'D',
1630: error_code = NULL
1631: WHERE rowid = new_cjntadm_rec.rowid;
1632: