[Home] [Help]
63: TYPE g_address_rec_type IS TABLE OF IGS_SV_ADDRESSES%ROWTYPE INDEX BY BINARY_INTEGER;
64: TYPE g_edu_rec_type IS TABLE OF IGS_SV_PRGMS_INFO%ROWTYPE INDEX BY BINARY_INTEGER;
65: TYPE g_dependent_rec_type IS TABLE OF IGS_SV_DEPDNT_INFO%ROWTYPE INDEX BY BINARY_INTEGER;
66: TYPE g_convictions_rec_type IS TABLE OF IGS_SV_CONVICTIONS%ROWTYPE INDEX BY BINARY_INTEGER;
67: TYPE g_empl_rec_type IS TABLE OF IGS_SV_EMPL_INFO%ROWTYPE INDEX BY BINARY_INTEGER;
68: TYPE g_parallel_batches_tbl IS TABLE OF IGS_SV_BATCHES.BATCH_ID%TYPE INDEX BY BINARY_INTEGER;
69: TYPE g_running_batches_tbl IS TABLE OF IGS_SV_BATCHES.BATCH_ID%TYPE INDEX BY BINARY_INTEGER;
70:
71: g_parallel_batches g_parallel_batches_tbl;
4300:
4301: END Validate_ev_Legal_Info;
4302:
4303: FUNCTION Get_Empl_Info (
4304: p_data_rec IN OUT NOCOPY IGS_SV_EMPL_INFO%ROWTYPE -- Data record
4305: ) RETURN VARCHAR2 -- 'S' Record found, 'N' - not found. 'U' - Unexpected error
4306: IS
4307:
4308: l_api_name CONSTANT VARCHAR2(25) := 'Get_Empl_Info';
4319: course_relevance,
4320: empl_time,
4321: empl_name,
4322: action_code
4323: FROM igs_sv_empl_info
4324: WHERE
4325: person_id = p_data_rec.person_id and
4326: nonimg_empl_id = p_data_rec.nonimg_empl_id and
4327: batch_id IN
4325: person_id = p_data_rec.person_id and
4326: nonimg_empl_id = p_data_rec.nonimg_empl_id and
4327: batch_id IN
4328: ( SELECT max(emp.batch_id)
4329: FROM igs_sv_empl_info emp,
4330: igs_sv_persons pr
4331: WHERE emp.person_id = pr.person_id
4332: AND emp.batch_id = pr.batch_id
4333: AND pr.record_status <> 'E'
4436:
4437: -- only for validation of the input record
4438: FUNCTION validate_employment_Info(
4439: p_person_rec IN t_student_rec,
4440: p_data_rec IN OUT NOCOPY IGS_SV_EMPL_INFO%ROWTYPE --Data record
4441: ) RETURN BOOLEAN
4442: IS
4443: l_not_valid BOOLEAN := FALSE;
4444: l_visa_type VARCHAR2(5);
7010:
7011: Date Created By : Oct 14, 2002
7012:
7013: Purpose : Insert employment information on the student
7014: (IGS_SV_EMPL_INFO).
7015:
7016: Remarks :
7017:
7018: Change History
7020: ------------------------------------------------------------------------
7021:
7022: ******************************************************************/
7023: PROCEDURE Insert_Empl_Info (
7024: p_data_rec IN IGS_SV_EMPL_INFO%ROWTYPE --Data record
7025: )
7026: IS
7027: l_api_name CONSTANT VARCHAR(30) := 'Insert_Empl_Info';
7028: l_action VARCHAR2(6);
7060: p_data_rec.person_id,
7061: l_action,
7062: l_tag_code,
7063: 'SEND',
7064: 'IGS_SV_EMPL_INFO',
7065: p_data_rec.nonimg_empl_id);
7066: /* Debug */
7067: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7068: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Employment_Info';
7069: l_debug_str := 'mut_exclusive chk returns '||l_btch_id||' for batch: '||p_data_rec.batch_id||'person: '||p_data_rec.person_id||' action: '||l_action||' tag: '||l_tag_code;
7070: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7071: END IF;
7072:
7073: INSERT INTO igs_sv_empl_info (
7074: batch_id ,
7075: person_id ,
7076: nonimg_empl_id ,
7077: empl_rec_type ,
9789: ) RETURN VARCHAR2
9790: IS
9791:
9792: l_api_name CONSTANT VARCHAR2(30) := 'Update_Employment_Info';
9793: l_cur_rec g_empl_rec_type; ---IGS_SV_EMPL_INFO%ROWTYPE; prbhardw
9794: l_prev_rec IGS_SV_EMPL_INFO%ROWTYPE;
9795: l_status VARCHAR2(1);
9796:
9797: l_count NUMBER(10);
9790: IS
9791:
9792: l_api_name CONSTANT VARCHAR2(30) := 'Update_Employment_Info';
9793: l_cur_rec g_empl_rec_type; ---IGS_SV_EMPL_INFO%ROWTYPE; prbhardw
9794: l_prev_rec IGS_SV_EMPL_INFO%ROWTYPE;
9795: l_status VARCHAR2(1);
9796:
9797: l_count NUMBER(10);
9798: l_current NUMBER(10);
10145: DELETE FROM igs_sv_depdnt_info WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;
10146:
10147: DELETE FROM igs_sv_depdnt_info WHERE batch_id > p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;
10148:
10149: DELETE FROM igs_sv_empl_info WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;
10150:
10151: DELETE FROM igs_sv_empl_info WHERE batch_id > p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;
10152:
10153: DELETE FROM igs_sv_finance_info WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;
10147: DELETE FROM igs_sv_depdnt_info WHERE batch_id > p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;
10148:
10149: DELETE FROM igs_sv_empl_info WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;
10150:
10151: DELETE FROM igs_sv_empl_info WHERE batch_id > p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;
10152:
10153: DELETE FROM igs_sv_finance_info WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;
10154:
10155: DELETE FROM igs_sv_legal_info WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;