1 package IGS_LOOKUPS_VIEW_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSMI14S.pls 115.6 2003/05/09 05:06:13 pkpatel ship $ */
3
4 PROCEDURE lock_row (
5 x_rowid IN VARCHAR2,
6 x_lookup_type IN VARCHAR2,
7 x_lookup_code IN VARCHAR2,
8 x_closed_ind IN VARCHAR2,
9 x_security_allowed_ind IN VARCHAR2,
10 x_step_type_restriction_num_in IN VARCHAR2,
11 x_unit_outcome_ind IN VARCHAR2,
12 x_display_name IN VARCHAR2,
13 x_display_order IN NUMBER,
14 x_step_order_applicable_ind IN VARCHAR2,
15 x_academic_transcript_ind IN VARCHAR2,
16 x_cmpltn_requirements_ind IN VARCHAR2,
17 x_fee_ass_ind IN VARCHAR2,
18 x_step_group_type IN VARCHAR2,
19 x_final_result_ind IN VARCHAR2,
20 x_system_generated_ind IN VARCHAR2,
21 x_transaction_cat IN VARCHAR2,
22 x_encumbrance_level IN NUMBER,
23 x_open_for_enrollments IN VARCHAR2,
24 x_system_calculated IN VARCHAR2,
25 x_system_mandatory_ind IN VARCHAR2,
26 x_default_display_seq IN NUMBER,
27 x_av_transcript_disp_options IN VARCHAR2
28 );
29
30
31 PROCEDURE update_row (
32 x_rowid IN VARCHAR2,
33 x_lookup_type IN VARCHAR2,
34 x_lookup_code IN VARCHAR2,
35 x_closed_ind IN VARCHAR2,
36 x_security_allowed_ind IN VARCHAR2,
37 x_step_type_restriction_num_in IN VARCHAR2,
38 x_unit_outcome_ind IN VARCHAR2,
39 x_display_name IN VARCHAR2,
40 x_display_order IN NUMBER,
41 x_step_order_applicable_ind IN VARCHAR2,
42 x_academic_transcript_ind IN VARCHAR2,
43 x_cmpltn_requirements_ind IN VARCHAR2,
44 x_fee_ass_ind IN VARCHAR2,
45 x_step_group_type IN VARCHAR2,
46 x_final_result_ind IN VARCHAR2,
47 x_system_generated_ind IN VARCHAR2,
48 x_transaction_cat IN VARCHAR2,
49 x_encumbrance_level IN NUMBER,
50 x_open_for_enrollments IN VARCHAR2,
51 x_system_calculated IN VARCHAR2,
52 x_system_mandatory_ind IN VARCHAR2,
53 x_default_display_seq IN NUMBER,
54 x_av_transcript_disp_options IN VARCHAR2,
55 x_mode IN VARCHAR2 DEFAULT 'R'
56 );
57
58 FUNCTION Get_PK_For_Validation (
59 X_LOOKUP_TYPE in VARCHAR2,
60 X_LOOKUP_CODE in VARCHAR2
61 )RETURN BOOLEAN ;
62
63 end IGS_LOOKUPS_VIEW_PKG;