DBA Data[Home] [Help]

PACKAGE: APPS.IGS_RU_GEN_004

Source


1 PACKAGE IGS_RU_GEN_004 AUTHID CURRENT_USER AS
2 /* $Header: IGSRU04S.pls 115.5 2002/11/29 03:39:49 nsidana ship $ */
3 
4 Procedure Rulp_Ins_Make_Rule(
5   p_description_number IN NUMBER DEFAULT NULL,
6   p_return_type  VARCHAR2 DEFAULT NULL,
7   p_rule_description  VARCHAR2 DEFAULT NULL,
8   p_turing_function  VARCHAR2 DEFAULT NULL,
9   p_rule_text  VARCHAR2 DEFAULT NULL,
10   p_message_rule_text  VARCHAR2 DEFAULT NULL,
11   p_description_text  VARCHAR2 ,
12   p_group IN NUMBER DEFAULT 1,
13   p_select_group IN NUMBER DEFAULT 1);
14 
15 Function Rulp_Ins_Ur_Rule(
16   p_unit_cd IN VARCHAR2 ,
17   p_s_rule_call_cd IN VARCHAR2 ,
18   p_insert_rule_only IN BOOLEAN ,
19   p_rul_sequence_number OUT NOCOPY NUMBER ,
20   p_message_name OUT NOCOPY VARCHAR2 )
21 RETURN BOOLEAN;
22 
23 Function Rulp_Val_Adm_Status(
24   p_letter_parameter_type IN VARCHAR2 ,
25   p_adm_appl_status IN VARCHAR2 ,
26   p_adm_fee_status IN VARCHAR2 ,
27   p_adm_doc_status IN VARCHAR2 ,
28   p_adm_entry_qual_status IN VARCHAR2 ,
29   p_late_adm_fee_status IN VARCHAR2 ,
30   p_adm_outcome_status IN VARCHAR2 ,
31   p_adm_cndtnl_offer_status IN VARCHAR2 ,
32   p_adm_offer_resp_status IN VARCHAR2 ,
33   p_adm_offer_dfrmnt_status IN VARCHAR2 ,
34   p_reconsideration IN BOOLEAN ,
35   p_encumbrance IN BOOLEAN ,
36   p_course_invalid IN BOOLEAN ,
37   p_late IN BOOLEAN ,
38   p_incomplete IN BOOLEAN ,
39   p_correspondence_type  VARCHAR2 ,
40   p_valid_alternate  BOOLEAN ,
41   p_valid_address  BOOLEAN ,
42   p_valid_disability  BOOLEAN ,
43   p_valid_visa  BOOLEAN ,
44   p_valid_finance  BOOLEAN ,
45   p_valid_notes  BOOLEAN ,
46   p_valid_statistics  BOOLEAN ,
47   p_valid_alias  BOOLEAN ,
48   p_valid_tertiary  BOOLEAN ,
49   p_valid_aus_sec_ed  BOOLEAN ,
50   p_valid_os_sec_ed  BOOLEAN ,
51   p_valid_employment  BOOLEAN ,
52   p_valid_membership  BOOLEAN ,
53   p_valid_dob  BOOLEAN ,
54   p_valid_title  BOOLEAN ,
55   p_valid_referee  BOOLEAN ,
56   p_valid_scholarship  BOOLEAN ,
57   p_valid_lang_prof  BOOLEAN ,
58   p_valid_interview  BOOLEAN ,
59   p_valid_exchange  BOOLEAN ,
60   p_valid_adm_test IN BOOLEAN ,
61   p_valid_fee_assess  BOOLEAN ,
62   p_valid_cor_category  BOOLEAN ,
63   p_valid_enr_category  BOOLEAN ,
64   p_valid_research  BOOLEAN ,
65   p_valid_rank_app  BOOLEAN ,
66   p_valid_completion  BOOLEAN ,
67   p_valid_rank_set  BOOLEAN ,
68   p_valid_basis_adm  BOOLEAN ,
69   p_valid_crs_international  BOOLEAN ,
70   p_valid_ass_tracking  BOOLEAN ,
71   p_valid_adm_code  BOOLEAN ,
72   p_valid_fund_source IN BOOLEAN ,
73   p_valid_location  BOOLEAN ,
74   p_valid_att_mode  BOOLEAN ,
75   p_valid_att_type  BOOLEAN ,
76   p_valid_unit_set  BOOLEAN )
77 RETURN VARCHAR2;
78 
79 
80 Function Rulp_Val_Desc_Rgi(
81   p_description_number IN NUMBER ,
82   p_description_type IN VARCHAR2 ,
83   p_message_name OUT NOCOPY VARCHAR2 )
84 RETURN VARCHAR2;
85 
86 PRAGMA RESTRICT_REFERENCES (Rulp_Val_Desc_Rgi, WNDS)   ;
87 
88 Function Rulp_Val_Gpa(
89   p_person_id IN NUMBER ,
90   p_course_cd IN VARCHAR2 ,
91   p_prg_cal_type IN VARCHAR2 ,
92   p_prg_ci_sequence_number IN NUMBER ,
93   p_best_worst IN VARCHAR2 DEFAULT 'N',
94   p_recommend_ind IN VARCHAR2 DEFAULT 'N')
95 RETURN VARCHAR2;
96 
97 
98 Function Rulp_Val_Named_Rule(
99   p_return_type  VARCHAR2 ,
100   p_rule_name  VARCHAR2 ,
101   p_person_id IN NUMBER )
102 RETURN VARCHAR2;
103 
104 
105 Function Rulp_Val_Wam(
106   p_person_id IN NUMBER ,
107   p_course_cd IN VARCHAR2 ,
108   p_course_version  NUMBER ,
109   p_prg_cal_type IN VARCHAR2 ,
110   p_prg_ci_sequence_number IN NUMBER ,
111   p_recommend_ind IN VARCHAR2 DEFAULT 'N',
112   p_abort_when_missing IN VARCHAR2 DEFAULT 'N')
113 RETURN VARCHAR2;
114 
115 
116 END IGS_RU_GEN_004;