[Home] [Help]
2: /* $Header: IGSRE20S.pls 120.1 2006/01/17 03:39:21 rnirwani noship $ */
3: /*#
4: * The Research Thesis Import process is a public API designed for use in populating rows with data
5: * during a system conversion. This API is also used by the Legacy Import Process for Enrollment and
6: * Records when importing rows from the IGS_RE_LGCY_THE_INT interface table.
7: * @rep:scope public
8: * @rep:product IGS
9: * @rep:lifecycle active
10: * @rep:displayname Import Legacy Research Thesis
64: -- Who When What
65: -- (reverse chronological order - newest change first)
66:
67: TYPE the_dtls_rec_type IS RECORD (
68: person_number igs_re_lgcy_the_int.person_number%TYPE,
69: program_cd igs_re_lgcy_the_int.program_cd%TYPE,
70: title igs_re_lgcy_the_int.title%TYPE,
71: final_title_ind igs_re_lgcy_the_int.final_title_ind%TYPE,
72: short_title igs_re_lgcy_the_int.short_title%TYPE,
65: -- (reverse chronological order - newest change first)
66:
67: TYPE the_dtls_rec_type IS RECORD (
68: person_number igs_re_lgcy_the_int.person_number%TYPE,
69: program_cd igs_re_lgcy_the_int.program_cd%TYPE,
70: title igs_re_lgcy_the_int.title%TYPE,
71: final_title_ind igs_re_lgcy_the_int.final_title_ind%TYPE,
72: short_title igs_re_lgcy_the_int.short_title%TYPE,
73: abbreviated_title igs_re_lgcy_the_int.abbreviated_title%TYPE,
66:
67: TYPE the_dtls_rec_type IS RECORD (
68: person_number igs_re_lgcy_the_int.person_number%TYPE,
69: program_cd igs_re_lgcy_the_int.program_cd%TYPE,
70: title igs_re_lgcy_the_int.title%TYPE,
71: final_title_ind igs_re_lgcy_the_int.final_title_ind%TYPE,
72: short_title igs_re_lgcy_the_int.short_title%TYPE,
73: abbreviated_title igs_re_lgcy_the_int.abbreviated_title%TYPE,
74: final_thesis_result_cd igs_re_lgcy_the_int.final_thesis_result_cd%TYPE,
67: TYPE the_dtls_rec_type IS RECORD (
68: person_number igs_re_lgcy_the_int.person_number%TYPE,
69: program_cd igs_re_lgcy_the_int.program_cd%TYPE,
70: title igs_re_lgcy_the_int.title%TYPE,
71: final_title_ind igs_re_lgcy_the_int.final_title_ind%TYPE,
72: short_title igs_re_lgcy_the_int.short_title%TYPE,
73: abbreviated_title igs_re_lgcy_the_int.abbreviated_title%TYPE,
74: final_thesis_result_cd igs_re_lgcy_the_int.final_thesis_result_cd%TYPE,
75: expected_submission_dt igs_re_lgcy_the_int.expected_submission_dt%TYPE,
68: person_number igs_re_lgcy_the_int.person_number%TYPE,
69: program_cd igs_re_lgcy_the_int.program_cd%TYPE,
70: title igs_re_lgcy_the_int.title%TYPE,
71: final_title_ind igs_re_lgcy_the_int.final_title_ind%TYPE,
72: short_title igs_re_lgcy_the_int.short_title%TYPE,
73: abbreviated_title igs_re_lgcy_the_int.abbreviated_title%TYPE,
74: final_thesis_result_cd igs_re_lgcy_the_int.final_thesis_result_cd%TYPE,
75: expected_submission_dt igs_re_lgcy_the_int.expected_submission_dt%TYPE,
76: library_lodgement_dt igs_re_lgcy_the_int.library_lodgement_dt%TYPE,
69: program_cd igs_re_lgcy_the_int.program_cd%TYPE,
70: title igs_re_lgcy_the_int.title%TYPE,
71: final_title_ind igs_re_lgcy_the_int.final_title_ind%TYPE,
72: short_title igs_re_lgcy_the_int.short_title%TYPE,
73: abbreviated_title igs_re_lgcy_the_int.abbreviated_title%TYPE,
74: final_thesis_result_cd igs_re_lgcy_the_int.final_thesis_result_cd%TYPE,
75: expected_submission_dt igs_re_lgcy_the_int.expected_submission_dt%TYPE,
76: library_lodgement_dt igs_re_lgcy_the_int.library_lodgement_dt%TYPE,
77: library_catalogue_number igs_re_lgcy_the_int.library_catalogue_number%TYPE,
70: title igs_re_lgcy_the_int.title%TYPE,
71: final_title_ind igs_re_lgcy_the_int.final_title_ind%TYPE,
72: short_title igs_re_lgcy_the_int.short_title%TYPE,
73: abbreviated_title igs_re_lgcy_the_int.abbreviated_title%TYPE,
74: final_thesis_result_cd igs_re_lgcy_the_int.final_thesis_result_cd%TYPE,
75: expected_submission_dt igs_re_lgcy_the_int.expected_submission_dt%TYPE,
76: library_lodgement_dt igs_re_lgcy_the_int.library_lodgement_dt%TYPE,
77: library_catalogue_number igs_re_lgcy_the_int.library_catalogue_number%TYPE,
78: embargo_expiry_dt igs_re_lgcy_the_int.embargo_expiry_dt%TYPE,
71: final_title_ind igs_re_lgcy_the_int.final_title_ind%TYPE,
72: short_title igs_re_lgcy_the_int.short_title%TYPE,
73: abbreviated_title igs_re_lgcy_the_int.abbreviated_title%TYPE,
74: final_thesis_result_cd igs_re_lgcy_the_int.final_thesis_result_cd%TYPE,
75: expected_submission_dt igs_re_lgcy_the_int.expected_submission_dt%TYPE,
76: library_lodgement_dt igs_re_lgcy_the_int.library_lodgement_dt%TYPE,
77: library_catalogue_number igs_re_lgcy_the_int.library_catalogue_number%TYPE,
78: embargo_expiry_dt igs_re_lgcy_the_int.embargo_expiry_dt%TYPE,
79: thesis_format igs_re_lgcy_the_int.thesis_format%TYPE,
72: short_title igs_re_lgcy_the_int.short_title%TYPE,
73: abbreviated_title igs_re_lgcy_the_int.abbreviated_title%TYPE,
74: final_thesis_result_cd igs_re_lgcy_the_int.final_thesis_result_cd%TYPE,
75: expected_submission_dt igs_re_lgcy_the_int.expected_submission_dt%TYPE,
76: library_lodgement_dt igs_re_lgcy_the_int.library_lodgement_dt%TYPE,
77: library_catalogue_number igs_re_lgcy_the_int.library_catalogue_number%TYPE,
78: embargo_expiry_dt igs_re_lgcy_the_int.embargo_expiry_dt%TYPE,
79: thesis_format igs_re_lgcy_the_int.thesis_format%TYPE,
80: embargo_details igs_re_lgcy_the_int.embargo_details%TYPE,
73: abbreviated_title igs_re_lgcy_the_int.abbreviated_title%TYPE,
74: final_thesis_result_cd igs_re_lgcy_the_int.final_thesis_result_cd%TYPE,
75: expected_submission_dt igs_re_lgcy_the_int.expected_submission_dt%TYPE,
76: library_lodgement_dt igs_re_lgcy_the_int.library_lodgement_dt%TYPE,
77: library_catalogue_number igs_re_lgcy_the_int.library_catalogue_number%TYPE,
78: embargo_expiry_dt igs_re_lgcy_the_int.embargo_expiry_dt%TYPE,
79: thesis_format igs_re_lgcy_the_int.thesis_format%TYPE,
80: embargo_details igs_re_lgcy_the_int.embargo_details%TYPE,
81: thesis_topic igs_re_lgcy_the_int.thesis_topic%TYPE,
74: final_thesis_result_cd igs_re_lgcy_the_int.final_thesis_result_cd%TYPE,
75: expected_submission_dt igs_re_lgcy_the_int.expected_submission_dt%TYPE,
76: library_lodgement_dt igs_re_lgcy_the_int.library_lodgement_dt%TYPE,
77: library_catalogue_number igs_re_lgcy_the_int.library_catalogue_number%TYPE,
78: embargo_expiry_dt igs_re_lgcy_the_int.embargo_expiry_dt%TYPE,
79: thesis_format igs_re_lgcy_the_int.thesis_format%TYPE,
80: embargo_details igs_re_lgcy_the_int.embargo_details%TYPE,
81: thesis_topic igs_re_lgcy_the_int.thesis_topic%TYPE,
82: citation igs_re_lgcy_the_int.citation%TYPE,
75: expected_submission_dt igs_re_lgcy_the_int.expected_submission_dt%TYPE,
76: library_lodgement_dt igs_re_lgcy_the_int.library_lodgement_dt%TYPE,
77: library_catalogue_number igs_re_lgcy_the_int.library_catalogue_number%TYPE,
78: embargo_expiry_dt igs_re_lgcy_the_int.embargo_expiry_dt%TYPE,
79: thesis_format igs_re_lgcy_the_int.thesis_format%TYPE,
80: embargo_details igs_re_lgcy_the_int.embargo_details%TYPE,
81: thesis_topic igs_re_lgcy_the_int.thesis_topic%TYPE,
82: citation igs_re_lgcy_the_int.citation%TYPE,
83: comments igs_re_lgcy_the_int.comments%TYPE,
76: library_lodgement_dt igs_re_lgcy_the_int.library_lodgement_dt%TYPE,
77: library_catalogue_number igs_re_lgcy_the_int.library_catalogue_number%TYPE,
78: embargo_expiry_dt igs_re_lgcy_the_int.embargo_expiry_dt%TYPE,
79: thesis_format igs_re_lgcy_the_int.thesis_format%TYPE,
80: embargo_details igs_re_lgcy_the_int.embargo_details%TYPE,
81: thesis_topic igs_re_lgcy_the_int.thesis_topic%TYPE,
82: citation igs_re_lgcy_the_int.citation%TYPE,
83: comments igs_re_lgcy_the_int.comments%TYPE,
84: submission_dt igs_re_lgcy_the_int.submission_dt%TYPE,
77: library_catalogue_number igs_re_lgcy_the_int.library_catalogue_number%TYPE,
78: embargo_expiry_dt igs_re_lgcy_the_int.embargo_expiry_dt%TYPE,
79: thesis_format igs_re_lgcy_the_int.thesis_format%TYPE,
80: embargo_details igs_re_lgcy_the_int.embargo_details%TYPE,
81: thesis_topic igs_re_lgcy_the_int.thesis_topic%TYPE,
82: citation igs_re_lgcy_the_int.citation%TYPE,
83: comments igs_re_lgcy_the_int.comments%TYPE,
84: submission_dt igs_re_lgcy_the_int.submission_dt%TYPE,
85: thesis_exam_type igs_re_lgcy_the_int.thesis_exam_TYPE%TYPE,
78: embargo_expiry_dt igs_re_lgcy_the_int.embargo_expiry_dt%TYPE,
79: thesis_format igs_re_lgcy_the_int.thesis_format%TYPE,
80: embargo_details igs_re_lgcy_the_int.embargo_details%TYPE,
81: thesis_topic igs_re_lgcy_the_int.thesis_topic%TYPE,
82: citation igs_re_lgcy_the_int.citation%TYPE,
83: comments igs_re_lgcy_the_int.comments%TYPE,
84: submission_dt igs_re_lgcy_the_int.submission_dt%TYPE,
85: thesis_exam_type igs_re_lgcy_the_int.thesis_exam_TYPE%TYPE,
86: thesis_panel_type igs_re_lgcy_the_int.thesis_panel_TYPE%TYPE,
79: thesis_format igs_re_lgcy_the_int.thesis_format%TYPE,
80: embargo_details igs_re_lgcy_the_int.embargo_details%TYPE,
81: thesis_topic igs_re_lgcy_the_int.thesis_topic%TYPE,
82: citation igs_re_lgcy_the_int.citation%TYPE,
83: comments igs_re_lgcy_the_int.comments%TYPE,
84: submission_dt igs_re_lgcy_the_int.submission_dt%TYPE,
85: thesis_exam_type igs_re_lgcy_the_int.thesis_exam_TYPE%TYPE,
86: thesis_panel_type igs_re_lgcy_the_int.thesis_panel_TYPE%TYPE,
87: thesis_result_cd igs_re_lgcy_the_int.thesis_result_cd%TYPE
80: embargo_details igs_re_lgcy_the_int.embargo_details%TYPE,
81: thesis_topic igs_re_lgcy_the_int.thesis_topic%TYPE,
82: citation igs_re_lgcy_the_int.citation%TYPE,
83: comments igs_re_lgcy_the_int.comments%TYPE,
84: submission_dt igs_re_lgcy_the_int.submission_dt%TYPE,
85: thesis_exam_type igs_re_lgcy_the_int.thesis_exam_TYPE%TYPE,
86: thesis_panel_type igs_re_lgcy_the_int.thesis_panel_TYPE%TYPE,
87: thesis_result_cd igs_re_lgcy_the_int.thesis_result_cd%TYPE
88: );
81: thesis_topic igs_re_lgcy_the_int.thesis_topic%TYPE,
82: citation igs_re_lgcy_the_int.citation%TYPE,
83: comments igs_re_lgcy_the_int.comments%TYPE,
84: submission_dt igs_re_lgcy_the_int.submission_dt%TYPE,
85: thesis_exam_type igs_re_lgcy_the_int.thesis_exam_TYPE%TYPE,
86: thesis_panel_type igs_re_lgcy_the_int.thesis_panel_TYPE%TYPE,
87: thesis_result_cd igs_re_lgcy_the_int.thesis_result_cd%TYPE
88: );
89:
82: citation igs_re_lgcy_the_int.citation%TYPE,
83: comments igs_re_lgcy_the_int.comments%TYPE,
84: submission_dt igs_re_lgcy_the_int.submission_dt%TYPE,
85: thesis_exam_type igs_re_lgcy_the_int.thesis_exam_TYPE%TYPE,
86: thesis_panel_type igs_re_lgcy_the_int.thesis_panel_TYPE%TYPE,
87: thesis_result_cd igs_re_lgcy_the_int.thesis_result_cd%TYPE
88: );
89:
90: -- irep annotations below.
83: comments igs_re_lgcy_the_int.comments%TYPE,
84: submission_dt igs_re_lgcy_the_int.submission_dt%TYPE,
85: thesis_exam_type igs_re_lgcy_the_int.thesis_exam_TYPE%TYPE,
86: thesis_panel_type igs_re_lgcy_the_int.thesis_panel_TYPE%TYPE,
87: thesis_result_cd igs_re_lgcy_the_int.thesis_result_cd%TYPE
88: );
89:
90: -- irep annotations below.
91: /*#
90: -- irep annotations below.
91: /*#
92: * The Research Thesis Import process is a public API designed for use in populating rows with data
93: * during a system conversion. This API is also used by the Legacy Import Process for Enrollment and
94: * Records when importing rows from the IGS_RE_LGCY_THE_INT interface table.
95: * @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.
96: * @param P_init_msg_list Set to FND_API.G_TRUE to have API automatically to initialize message list.
97: * @param p_commit Set to FND_API.G_TRUE to have API to commit automatically.
98: * @param p_validation_level Public API will always perform full level of validation.