DBA Data[Home] [Help]

APPS.IGS_RE_THE_LGCY_PUB dependencies on IGS_RE_LGCY_THE_INT

Line 6: * Records when importing rows from the IGS_RE_LGCY_THE_INT interface table.

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

Line 68: person_number igs_re_lgcy_the_int.person_number%TYPE,

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,

Line 69: program_cd igs_re_lgcy_the_int.program_cd%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,

Line 70: title igs_re_lgcy_the_int.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,

Line 71: final_title_ind igs_re_lgcy_the_int.final_title_ind%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,

Line 72: short_title igs_re_lgcy_the_int.short_title%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,

Line 73: abbreviated_title igs_re_lgcy_the_int.abbreviated_title%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,

Line 74: final_thesis_result_cd igs_re_lgcy_the_int.final_thesis_result_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,
78: embargo_expiry_dt igs_re_lgcy_the_int.embargo_expiry_dt%TYPE,

Line 75: expected_submission_dt igs_re_lgcy_the_int.expected_submission_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,

Line 76: library_lodgement_dt igs_re_lgcy_the_int.library_lodgement_dt%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,

Line 77: library_catalogue_number igs_re_lgcy_the_int.library_catalogue_number%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,

Line 78: embargo_expiry_dt igs_re_lgcy_the_int.embargo_expiry_dt%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,

Line 79: thesis_format igs_re_lgcy_the_int.thesis_format%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,

Line 80: embargo_details igs_re_lgcy_the_int.embargo_details%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,

Line 81: thesis_topic igs_re_lgcy_the_int.thesis_topic%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,

Line 82: citation igs_re_lgcy_the_int.citation%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,

Line 83: comments igs_re_lgcy_the_int.comments%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

Line 84: submission_dt igs_re_lgcy_the_int.submission_dt%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: );

Line 85: thesis_exam_type igs_re_lgcy_the_int.thesis_exam_TYPE%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: );
89:

Line 86: thesis_panel_type igs_re_lgcy_the_int.thesis_panel_TYPE%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:
90: -- irep annotations below.

Line 87: thesis_result_cd igs_re_lgcy_the_int.thesis_result_cd%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.
91: /*#

Line 94: * Records when importing rows from the IGS_RE_LGCY_THE_INT interface table.

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.