[Home] [Help]
2: /* $Header: IGSRE19S.pls 120.1 2006/01/17 03:36:09 rnirwani noship $ */
3: /*#
4: * The Research Supervisor Import process is a public API designed for use in populating rows with
5: * data during a system conversion. This API is also used by the Legacy Import Process for Enrollment
6: * and Records when importing rows from the IGS_RE_LGCY_SPR_INT interface table.
7: * @rep:scope public
8: * @rep:product IGS
9: * @rep:lifecycle active
10: * @rep:displayname Import Legacy Research Supervisor
26: | |
27: | HISTORY |
28: | Who When What |
29: | pradhakr 03-Dec-2002 Changed the reference to the table |
30: | igs_re_lgcy_sprvsr_int to igs_re_lgcy_spr_int. |
31: *==============================================================================*/
32:
33: TYPE sprvsr_dtls_rec_type IS RECORD
34: (
31: *==============================================================================*/
32:
33: TYPE sprvsr_dtls_rec_type IS RECORD
34: (
35: ca_person_number igs_re_lgcy_spr_int.ca_person_number%TYPE,
36: program_cd igs_re_lgcy_spr_int.program_cd%TYPE,
37: person_number igs_re_lgcy_spr_int.person_number%TYPE,
38: start_dt igs_re_lgcy_spr_int.start_dt%TYPE,
39: end_dt igs_re_lgcy_spr_int.end_dt%TYPE,
32:
33: TYPE sprvsr_dtls_rec_type IS RECORD
34: (
35: ca_person_number igs_re_lgcy_spr_int.ca_person_number%TYPE,
36: program_cd igs_re_lgcy_spr_int.program_cd%TYPE,
37: person_number igs_re_lgcy_spr_int.person_number%TYPE,
38: start_dt igs_re_lgcy_spr_int.start_dt%TYPE,
39: end_dt igs_re_lgcy_spr_int.end_dt%TYPE,
40: research_supervisor_type igs_re_lgcy_spr_int.research_supervisor_type%TYPE,
33: TYPE sprvsr_dtls_rec_type IS RECORD
34: (
35: ca_person_number igs_re_lgcy_spr_int.ca_person_number%TYPE,
36: program_cd igs_re_lgcy_spr_int.program_cd%TYPE,
37: person_number igs_re_lgcy_spr_int.person_number%TYPE,
38: start_dt igs_re_lgcy_spr_int.start_dt%TYPE,
39: end_dt igs_re_lgcy_spr_int.end_dt%TYPE,
40: research_supervisor_type igs_re_lgcy_spr_int.research_supervisor_type%TYPE,
41: supervisor_profession igs_re_lgcy_spr_int.supervisor_profession%TYPE,
34: (
35: ca_person_number igs_re_lgcy_spr_int.ca_person_number%TYPE,
36: program_cd igs_re_lgcy_spr_int.program_cd%TYPE,
37: person_number igs_re_lgcy_spr_int.person_number%TYPE,
38: start_dt igs_re_lgcy_spr_int.start_dt%TYPE,
39: end_dt igs_re_lgcy_spr_int.end_dt%TYPE,
40: research_supervisor_type igs_re_lgcy_spr_int.research_supervisor_type%TYPE,
41: supervisor_profession igs_re_lgcy_spr_int.supervisor_profession%TYPE,
42: supervision_percentage igs_re_lgcy_spr_int.supervision_percentage%TYPE,
35: ca_person_number igs_re_lgcy_spr_int.ca_person_number%TYPE,
36: program_cd igs_re_lgcy_spr_int.program_cd%TYPE,
37: person_number igs_re_lgcy_spr_int.person_number%TYPE,
38: start_dt igs_re_lgcy_spr_int.start_dt%TYPE,
39: end_dt igs_re_lgcy_spr_int.end_dt%TYPE,
40: research_supervisor_type igs_re_lgcy_spr_int.research_supervisor_type%TYPE,
41: supervisor_profession igs_re_lgcy_spr_int.supervisor_profession%TYPE,
42: supervision_percentage igs_re_lgcy_spr_int.supervision_percentage%TYPE,
43: funding_percentage igs_re_lgcy_spr_int.funding_percentage%TYPE,
36: program_cd igs_re_lgcy_spr_int.program_cd%TYPE,
37: person_number igs_re_lgcy_spr_int.person_number%TYPE,
38: start_dt igs_re_lgcy_spr_int.start_dt%TYPE,
39: end_dt igs_re_lgcy_spr_int.end_dt%TYPE,
40: research_supervisor_type igs_re_lgcy_spr_int.research_supervisor_type%TYPE,
41: supervisor_profession igs_re_lgcy_spr_int.supervisor_profession%TYPE,
42: supervision_percentage igs_re_lgcy_spr_int.supervision_percentage%TYPE,
43: funding_percentage igs_re_lgcy_spr_int.funding_percentage%TYPE,
44: org_unit_cd igs_re_lgcy_spr_int.org_unit_cd%TYPE,
37: person_number igs_re_lgcy_spr_int.person_number%TYPE,
38: start_dt igs_re_lgcy_spr_int.start_dt%TYPE,
39: end_dt igs_re_lgcy_spr_int.end_dt%TYPE,
40: research_supervisor_type igs_re_lgcy_spr_int.research_supervisor_type%TYPE,
41: supervisor_profession igs_re_lgcy_spr_int.supervisor_profession%TYPE,
42: supervision_percentage igs_re_lgcy_spr_int.supervision_percentage%TYPE,
43: funding_percentage igs_re_lgcy_spr_int.funding_percentage%TYPE,
44: org_unit_cd igs_re_lgcy_spr_int.org_unit_cd%TYPE,
45: replaced_person_number igs_re_lgcy_spr_int.replaced_person_number%TYPE,
38: start_dt igs_re_lgcy_spr_int.start_dt%TYPE,
39: end_dt igs_re_lgcy_spr_int.end_dt%TYPE,
40: research_supervisor_type igs_re_lgcy_spr_int.research_supervisor_type%TYPE,
41: supervisor_profession igs_re_lgcy_spr_int.supervisor_profession%TYPE,
42: supervision_percentage igs_re_lgcy_spr_int.supervision_percentage%TYPE,
43: funding_percentage igs_re_lgcy_spr_int.funding_percentage%TYPE,
44: org_unit_cd igs_re_lgcy_spr_int.org_unit_cd%TYPE,
45: replaced_person_number igs_re_lgcy_spr_int.replaced_person_number%TYPE,
46: comments igs_re_lgcy_spr_int.comments%TYPE
39: end_dt igs_re_lgcy_spr_int.end_dt%TYPE,
40: research_supervisor_type igs_re_lgcy_spr_int.research_supervisor_type%TYPE,
41: supervisor_profession igs_re_lgcy_spr_int.supervisor_profession%TYPE,
42: supervision_percentage igs_re_lgcy_spr_int.supervision_percentage%TYPE,
43: funding_percentage igs_re_lgcy_spr_int.funding_percentage%TYPE,
44: org_unit_cd igs_re_lgcy_spr_int.org_unit_cd%TYPE,
45: replaced_person_number igs_re_lgcy_spr_int.replaced_person_number%TYPE,
46: comments igs_re_lgcy_spr_int.comments%TYPE
47: );
40: research_supervisor_type igs_re_lgcy_spr_int.research_supervisor_type%TYPE,
41: supervisor_profession igs_re_lgcy_spr_int.supervisor_profession%TYPE,
42: supervision_percentage igs_re_lgcy_spr_int.supervision_percentage%TYPE,
43: funding_percentage igs_re_lgcy_spr_int.funding_percentage%TYPE,
44: org_unit_cd igs_re_lgcy_spr_int.org_unit_cd%TYPE,
45: replaced_person_number igs_re_lgcy_spr_int.replaced_person_number%TYPE,
46: comments igs_re_lgcy_spr_int.comments%TYPE
47: );
48:
41: supervisor_profession igs_re_lgcy_spr_int.supervisor_profession%TYPE,
42: supervision_percentage igs_re_lgcy_spr_int.supervision_percentage%TYPE,
43: funding_percentage igs_re_lgcy_spr_int.funding_percentage%TYPE,
44: org_unit_cd igs_re_lgcy_spr_int.org_unit_cd%TYPE,
45: replaced_person_number igs_re_lgcy_spr_int.replaced_person_number%TYPE,
46: comments igs_re_lgcy_spr_int.comments%TYPE
47: );
48:
49: -- irep annotations below
42: supervision_percentage igs_re_lgcy_spr_int.supervision_percentage%TYPE,
43: funding_percentage igs_re_lgcy_spr_int.funding_percentage%TYPE,
44: org_unit_cd igs_re_lgcy_spr_int.org_unit_cd%TYPE,
45: replaced_person_number igs_re_lgcy_spr_int.replaced_person_number%TYPE,
46: comments igs_re_lgcy_spr_int.comments%TYPE
47: );
48:
49: -- irep annotations below
50: /*#
49: -- irep annotations below
50: /*#
51: * The Research Supervisor Import process is a public API designed for use in populating rows with
52: * data during a system conversion. This API is also used by the Legacy Import Process for Enrollment
53: * and Records when importing rows from the IGS_RE_LGCY_SPR_INT interface table.
54: * @param p_api_version The version number will be used to compare with claim public api's current version number.Unexpected error is raised if version in-compatibility exists.
55: * @param P_init_msg_list Set to FND_API.G_TRUE to have API automatically to initialize message list.
56: * @param p_commit Set to FND_API.G_TRUE to have API to commit automatically.
57: * @param p_validation_level Public API will always perform full level of validation.