APPS.IGS_AD_IMP_007 dependencies on IGS_PE_FUND_SRC_INT

Line 3298: FROM igs_pe_fund_src_int ai, igs_ad_interface_all i

3294: --cursor to select records from interface records
3295: CURSOR c_pfs(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
3296: SELECT ai.*,
3297: i.person_id
3298: FROM igs_pe_fund_src_int ai, igs_ad_interface_all i
3299: WHERE ai.interface_run_id = cp_interface_run_id
3300: AND i.interface_id = ai.interface_id
3301: AND i.interface_run_id = cp_interface_run_id
3302: AND ai.status = '2';

Line 3375: igs_ad_imp_001.logerrormessage(pfs_rec.interface_fund_source_id,'E133','IGS_PE_FUND_SRC_INT');

3371: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
3372: END IF;
3373:
3374: IF l_enable_log = 'Y' THEN
3375: igs_ad_imp_001.logerrormessage(pfs_rec.interface_fund_source_id,'E133','IGS_PE_FUND_SRC_INT');
3376: END IF;
3377:
3378: END crt_pe_fund_source; -- end local proc to create new record
3379:

Line 3430: UPDATE igs_pe_fund_src_int

3426: EXCEPTION
3427: -- search for NO_DATA_FOUND, as its not trapped, OTHERS will be raised
3428: WHEN OTHERS THEN
3429: -- update for failure
3430: UPDATE igs_pe_fund_src_int
3431: SET status = '3',
3432: error_code = l_error
3433: WHERE interface_fund_source_id = pfs_rec.interface_fund_source_id;
3434:

Line 3454: igs_ad_imp_001.logerrormessage(pfs_rec.interface_fund_source_id,l_error,'IGS_PE_FUND_SRC_INT');

3450: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
3451: END IF;
3452:
3453: IF l_enable_log = 'Y' THEN
3454: igs_ad_imp_001.logerrormessage(pfs_rec.interface_fund_source_id,l_error,'IGS_PE_FUND_SRC_INT');
3455: END IF;
3456: RETURN FALSE ;
3457:
3458: END Validate_Record; -- End Local function Validate_Record

Line 3497: UPDATE igs_pe_fund_src_int

3493: crt_pe_fund_source (pfs_rec => pfs_rec,
3494: error_code => l_error_code,
3495: status => l_status );
3496:
3497: UPDATE igs_pe_fund_src_int
3498: SET status = l_status,
3499: error_code = l_error_code
3500: WHERE interface_fund_source_id = pfs_rec.interface_fund_source_id;
3501: