1 PACKAGE IGS_RE_GEN_003 AUTHID CURRENT_USER AS
2 /* $Header: IGSRE03S.pls 115.3 2002/11/29 03:27:15 nsidana ship $ */
3 PROCEDURE RESP_INS_MIL_HIST(
4 p_person_id IN NUMBER ,
5 p_ca_sequence_number IN NUMBER ,
6 p_sequence_number IN NUMBER ,
7 p_old_milestone_type IN VARCHAR2 ,
8 p_new_milestone_type IN VARCHAR2 ,
9 p_old_milestone_status IN VARCHAR2 ,
10 p_new_milestone_status IN VARCHAR2 ,
11 p_old_due_dt IN DATE ,
12 p_new_due_dt IN DATE ,
13 p_old_description IN VARCHAR2 ,
14 p_new_description IN VARCHAR2 ,
15 p_old_actual_reached_dt IN DATE ,
16 p_new_actual_reached_dt IN DATE ,
17 p_old_preced_sequence_number IN NUMBER ,
18 p_new_preced_sequence_number IN NUMBER ,
19 p_old_ovrd_ntfctn_immnnt_days IN NUMBER ,
20 p_new_ovrd_ntfctn_immnnt_days IN NUMBER ,
21 p_old_ovrd_ntfctn_rmndr_days IN NUMBER ,
22 p_new_ovrd_ntfctn_rmndr_days IN NUMBER ,
23 p_old_re_reminder_days IN NUMBER ,
24 p_new_re_reminder_days IN NUMBER ,
25 p_old_comments IN VARCHAR2 ,
26 p_new_comments IN VARCHAR2 ,
27 p_old_update_who IN NUMBER ,
28 p_new_update_who IN NUMBER ,
29 p_old_update_on IN DATE ,
30 p_new_update_on IN DATE ) ;
31
32
33 PROCEDURE RESP_INS_TEX_HIST(
34 P_PERSON_ID IN NUMBER ,
35 P_CA_SEQUENCE_NUMBER IN NUMBER ,
36 P_THE_SEQUENCE_NUMBER IN NUMBER ,
37 P_CREATION_DT IN DATE ,
38 P_OLD_SUBMISSION_DT IN DATE ,
39 P_NEW_SUBMISSION_DT IN DATE ,
40 P_OLD_THESIS_EXAM_TYPE IN VARCHAR2 ,
41 P_NEW_THESIS_EXAM_TYPE IN VARCHAR2 ,
42 p_old_thesis_panel_type IN VARCHAR2 ,
43 p_new_thesis_panel_type IN VARCHAR2 ,
44 p_old_thesis_result_cd IN VARCHAR2 ,
45 p_new_thesis_result_cd IN VARCHAR2 ,
46 p_old_tracking_id IN NUMBER ,
47 p_new_tracking_id NUMBER ,
48 p_old_update_who IN NUMBER ,
49 p_new_update_who IN NUMBER ,
50 p_old_update_on IN DATE ,
51 p_new_update_on IN DATE ) ;
52
53
54 FUNCTION RESP_INS_TEX_TRI(
55 p_person_id IN NUMBER ,
56 p_ca_sequence_number IN NUMBER ,
57 p_the_sequence_number IN NUMBER ,
58 p_creation_dt IN DATE ,
59 p_thesis_panel_type IN VARCHAR2 ,
60 p_message_name OUT NOCOPY VARCHAR2 )
61 RETURN NUMBER ;
62
63 PROCEDURE RESP_INS_THE_HIST(
64 p_person_id IN NUMBER ,
65 p_ca_sequence_number IN NUMBER ,
66 p_sequence_number IN NUMBER ,
67 p_old_title IN VARCHAR2 ,
68 p_new_title IN VARCHAR2 ,
69 p_old_final_title_ind IN VARCHAR2 ,
70 p_new_final_title_ind IN VARCHAR2 ,
71 p_old_short_title IN VARCHAR2 ,
72 p_new_short_title IN VARCHAR2 ,
73 p_old_abbreviated_title IN VARCHAR2 ,
74 p_new_abbreviated_title IN VARCHAR2 ,
75 p_old_thesis_result_cd IN VARCHAR2 ,
76 p_new_thesis_result_cd IN VARCHAR2 ,
77 p_old_expected_submission_dt IN DATE ,
78 p_new_expected_submission_dt IN DATE ,
79 p_old_library_lodgement_dt IN DATE ,
80 p_new_library_lodgement_dt IN DATE ,
81 p_old_library_catalogue_number IN VARCHAR2 ,
82 p_new_library_catalogue_number IN VARCHAR2 ,
83 p_old_embargo_expiry_dt IN DATE ,
84 p_new_embargo_expiry_dt IN DATE ,
85 p_old_thesis_format IN VARCHAR2 ,
86 p_new_thesis_format IN VARCHAR2 ,
87 p_old_logical_delete_dt IN DATE ,
88 p_new_logical_delete_dt IN DATE ,
89 p_old_embargo_details IN VARCHAR2 ,
90 p_new_embargo_details IN VARCHAR2 ,
91 p_old_thesis_topic IN VARCHAR2 ,
92 p_new_thesis_topic IN VARCHAR2 ,
93 p_old_citation IN VARCHAR2 ,
94 p_new_citation IN VARCHAR2 ,
95 p_old_comments IN VARCHAR2 ,
96 p_new_comments IN VARCHAR2 ,
97 p_old_update_who IN NUMBER ,
98 p_new_update_who IN NUMBER ,
99 p_old_update_on IN DATE ,
100 p_new_update_on IN DATE ) ;
101
102 PROCEDURE RESP_INS_TPM_HIST(
103 p_ca_person_id IN NUMBER ,
104 p_ca_sequence_number IN NUMBER ,
105 p_the_sequence_number IN NUMBER ,
106 p_creation_dt IN DATE ,
107 p_person_id IN NUMBER ,
108 p_old_panel_member_type IN VARCHAR2 ,
109 p_new_panel_member_type IN VARCHAR2 ,
110 p_old_confirmed_dt IN DATE ,
111 p_new_confirmed_dt IN DATE ,
112 p_old_declined_dt IN DATE ,
113 p_new_declined_dt IN DATE ,
114 p_old_anonymity_ind IN VARCHAR2 ,
115 p_new_anonymity_ind IN VARCHAR2 ,
116 p_old_thesis_result_cd IN VARCHAR2 ,
117 p_new_thesis_result_cd IN VARCHAR2 ,
118 p_old_paid_dt IN DATE ,
119 p_new_paid_dt IN DATE ,
120 p_old_tracking_id IN NUMBER ,
121 p_new_tracking_id IN NUMBER ,
122 p_old_recommendation_summary IN VARCHAR2 ,
123 p_new_recommendation_summary IN VARCHAR2 ,
124 p_old_update_who IN NUMBER ,
125 p_new_update_who IN NUMBER ,
126 p_old_update_on IN DATE ,
127 p_new_update_on IN DATE ) ;
128
129
130 FUNCTION RESP_INS_TPM_TRI(
131 p_ca_person_id IN NUMBER ,
132 p_ca_sequence_number IN NUMBER ,
133 p_person_id IN NUMBER ,
134 p_panel_member_type IN VARCHAR2 ,
135 p_message_name OUT NOCOPY VARCHAR2 )
136 RETURN NUMBER ;
137
138 END IGS_RE_GEN_003 ;