eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_SV_BATCH_PROCESS_PKG dependencies on IGS_SV_EMPL_INFO

Line 68: TYPE g_empl_rec_type IS TABLE OF IGS_SV_EMPL_INFO%ROWTYPE INDEX BY BINARY_INTEGER;

64: TYPE g_address_rec_type IS TABLE OF IGS_SV_ADDRESSES%ROWTYPE INDEX BY BINARY_INTEGER;
65: TYPE g_edu_rec_type IS TABLE OF IGS_SV_PRGMS_INFO%ROWTYPE INDEX BY BINARY_INTEGER;
66: TYPE g_dependent_rec_type IS TABLE OF IGS_SV_DEPDNT_INFO%ROWTYPE INDEX BY BINARY_INTEGER;
67: TYPE g_convictions_rec_type IS TABLE OF IGS_SV_CONVICTIONS%ROWTYPE INDEX BY BINARY_INTEGER;
68: TYPE g_empl_rec_type IS TABLE OF IGS_SV_EMPL_INFO%ROWTYPE INDEX BY BINARY_INTEGER;
69: TYPE g_parallel_batches_tbl IS TABLE OF IGS_SV_BATCHES.BATCH_ID%TYPE INDEX BY BINARY_INTEGER;
70: TYPE g_running_batches_tbl IS TABLE OF IGS_SV_BATCHES.BATCH_ID%TYPE INDEX BY BINARY_INTEGER;
71:
72: g_parallel_batches g_parallel_batches_tbl;

Line 5260: p_data_rec IN OUT NOCOPY IGS_SV_EMPL_INFO%ROWTYPE -- Data record

5256:
5257: END Validate_ev_Legal_Info;
5258:
5259: FUNCTION Get_Empl_Info (
5260: p_data_rec IN OUT NOCOPY IGS_SV_EMPL_INFO%ROWTYPE -- Data record
5261: ) RETURN VARCHAR2 -- 'S' Record found, 'N' - not found. 'U' - Unexpected error
5262: IS
5263:
5264: l_api_name CONSTANT VARCHAR2(25) := 'Get_Empl_Info';

Line 5279: FROM igs_sv_empl_info

5275: course_relevance,
5276: empl_time,
5277: empl_name,
5278: action_code
5279: FROM igs_sv_empl_info
5280: WHERE
5281: person_id = p_data_rec.person_id and
5282: nonimg_empl_id = p_data_rec.nonimg_empl_id and
5283: batch_id IN

Line 5285: FROM igs_sv_empl_info emp,

5281: person_id = p_data_rec.person_id and
5282: nonimg_empl_id = p_data_rec.nonimg_empl_id and
5283: batch_id IN
5284: ( SELECT max(emp.batch_id)
5285: FROM igs_sv_empl_info emp,
5286: igs_sv_persons pr
5287: WHERE emp.person_id = pr.person_id
5288: AND emp.batch_id = pr.batch_id
5289: AND pr.record_status <> 'E'

Line 5396: p_data_rec IN OUT NOCOPY IGS_SV_EMPL_INFO%ROWTYPE --Data record

5392:
5393: -- only for validation of the input record
5394: FUNCTION validate_employment_Info(
5395: p_person_rec IN t_student_rec,
5396: p_data_rec IN OUT NOCOPY IGS_SV_EMPL_INFO%ROWTYPE --Data record
5397: ) RETURN BOOLEAN
5398: IS
5399: l_not_valid BOOLEAN := FALSE;
5400: l_visa_type VARCHAR2(5);

Line 8090: (IGS_SV_EMPL_INFO).

8086:
8087: Date Created By : Oct 14, 2002
8088:
8089: Purpose : Insert employment information on the student
8090: (IGS_SV_EMPL_INFO).
8091:
8092: Remarks :
8093:
8094: Change History

Line 8100: p_data_rec IN IGS_SV_EMPL_INFO%ROWTYPE --Data record

8096: ------------------------------------------------------------------------
8097:
8098: ******************************************************************/
8099: PROCEDURE Insert_Empl_Info (
8100: p_data_rec IN IGS_SV_EMPL_INFO%ROWTYPE --Data record
8101: )
8102: IS
8103: l_api_name CONSTANT VARCHAR(30) := 'Insert_Empl_Info';
8104: l_action VARCHAR2(6);

Line 8140: 'IGS_SV_EMPL_INFO',

8136: p_data_rec.person_id,
8137: l_action,
8138: l_tag_code,
8139: 'SEND',
8140: 'IGS_SV_EMPL_INFO',
8141: p_data_rec.nonimg_empl_id);
8142: /* Debug */
8143: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8144: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Employment_Info';

Line 8149: INSERT INTO igs_sv_empl_info (

8145: 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;
8146: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8147: END IF;
8148:
8149: INSERT INTO igs_sv_empl_info (
8150: batch_id ,
8151: person_id ,
8152: nonimg_empl_id ,
8153: empl_rec_type ,

Line 10907: l_cur_rec g_empl_rec_type; ---IGS_SV_EMPL_INFO%ROWTYPE; prbhardw

10903: ) RETURN VARCHAR2
10904: IS
10905:
10906: l_api_name CONSTANT VARCHAR2(30) := 'Update_Employment_Info';
10907: l_cur_rec g_empl_rec_type; ---IGS_SV_EMPL_INFO%ROWTYPE; prbhardw
10908: l_prev_rec IGS_SV_EMPL_INFO%ROWTYPE;
10909: l_status VARCHAR2(1);
10910:
10911: l_count NUMBER(10);

Line 10908: l_prev_rec IGS_SV_EMPL_INFO%ROWTYPE;

10904: IS
10905:
10906: l_api_name CONSTANT VARCHAR2(30) := 'Update_Employment_Info';
10907: l_cur_rec g_empl_rec_type; ---IGS_SV_EMPL_INFO%ROWTYPE; prbhardw
10908: l_prev_rec IGS_SV_EMPL_INFO%ROWTYPE;
10909: l_status VARCHAR2(1);
10910:
10911: l_count NUMBER(10);
10912: l_current NUMBER(10);

Line 11294: DELETE FROM igs_sv_empl_info WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;

11290: DELETE FROM igs_sv_convictions WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;
11291:
11292: DELETE FROM igs_sv_depdnt_info WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;
11293:
11294: DELETE FROM igs_sv_empl_info WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;
11295:
11296: DELETE FROM igs_sv_finance_info WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;
11297:
11298: DELETE FROM igs_sv_legal_info WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;