DBA Data[Home] [Help]

PACKAGE: APPS.IGS_RU_GEN_001

Source


1 PACKAGE IGS_RU_GEN_001 AS
2 /* $Header: IGSRU01S.pls 120.1 2005/09/30 04:27:22 appldev ship $ */
3   /*************************************************************
4   Created By : nsinha
5   Date Created By :
6   Purpose :
7   Know limitations, enhancements or remarks
8   Change History
9   Who             When            What
10   Navin           27-Aug-2001     Added a package variable p_evaluated_part
11                                   as part of Bug# : 1899513.
12   (reverse chronological order - newest change first)
13   ***************************************************************/
14 
15 Function Rulp_Val_Senna(
16   p_rule_call_name IN VARCHAR2 DEFAULT NULL,
17   p_person_id IN NUMBER DEFAULT NULL,
18   p_course_cd IN VARCHAR2 DEFAULT NULL,
19   p_course_version IN NUMBER DEFAULT NULL,
20   p_unit_cd IN VARCHAR2 DEFAULT NULL,
21   p_unit_version IN NUMBER DEFAULT NULL,
22   p_cal_type IN VARCHAR2 DEFAULT NULL,
23   p_ci_sequence_number IN NUMBER DEFAULT NULL,
24   p_message OUT NOCOPY VARCHAR2 ,
25   p_rule_number  NUMBER DEFAULT NULL,
26   p_param_1  VARCHAR2 DEFAULT NULL,
27   p_param_2  VARCHAR2 DEFAULT NULL,
28   p_param_3  VARCHAR2 DEFAULT NULL,
29   p_param_4  VARCHAR2 DEFAULT NULL,
30   p_param_5  VARCHAR2 DEFAULT NULL,
31   p_param_6  VARCHAR2 DEFAULT NULL,
32   p_param_7  VARCHAR2 DEFAULT NULL,
33   p_param_8  VARCHAR2 DEFAULT NULL,
34   p_param_9  VARCHAR2 DEFAULT NULL,
35   p_param_10  VARCHAR2 DEFAULT NULL,
36   p_param_11  VARCHAR2 DEFAULT NULL,
37   p_param_12  VARCHAR2 DEFAULT NULL,
38   p_param_13  VARCHAR2 DEFAULT NULL,
39   p_param_14  VARCHAR2 DEFAULT NULL,
40   p_param_15  VARCHAR2 DEFAULT NULL,
41   p_param_16  VARCHAR2 DEFAULT NULL,
42   p_param_17  VARCHAR2 DEFAULT NULL,
43   p_param_18  VARCHAR2 DEFAULT NULL,
44   p_param_19  VARCHAR2 DEFAULT NULL,
45   p_param_20  VARCHAR2 DEFAULT NULL,
46   p_param_21  VARCHAR2 DEFAULT NULL,
47   p_param_22  VARCHAR2 DEFAULT NULL,
48   p_param_23  VARCHAR2 DEFAULT NULL,
49   p_param_24  VARCHAR2 DEFAULT NULL,
50   p_param_25  VARCHAR2 DEFAULT NULL,
51   p_param_26  VARCHAR2 DEFAULT NULL,
52   p_param_27  VARCHAR2 DEFAULT NULL,
53   p_param_28  VARCHAR2 DEFAULT NULL,
54   p_param_29  VARCHAR2 DEFAULT NULL,
55   p_param_30  VARCHAR2 DEFAULT NULL,
56   p_param_31  VARCHAR2 DEFAULT NULL,
57   p_param_32  VARCHAR2 DEFAULT NULL,
58   p_param_33  VARCHAR2 DEFAULT NULL,
59   p_param_34  VARCHAR2 DEFAULT NULL,
60   p_param_35  VARCHAR2 DEFAULT NULL,
61   p_param_36  VARCHAR2 DEFAULT NULL,
62   p_param_37  VARCHAR2 DEFAULT NULL,
63   p_param_38  VARCHAR2 DEFAULT NULL,
64   p_param_39  VARCHAR2 DEFAULT NULL,
65   p_param_40  VARCHAR2 DEFAULT NULL,
66   p_param_41  VARCHAR2 DEFAULT NULL,
67   p_param_42  VARCHAR2 DEFAULT NULL,
68   p_param_43  VARCHAR2 DEFAULT NULL,
69   p_param_44  VARCHAR2 DEFAULT NULL,
70   p_param_45  VARCHAR2 DEFAULT NULL,
71   p_param_46  VARCHAR2 DEFAULT NULL,
72   p_param_47  VARCHAR2 DEFAULT NULL,
73   p_param_48  VARCHAR2 DEFAULT NULL,
74   p_param_49  VARCHAR2 DEFAULT NULL,
75   p_param_50  VARCHAR2 DEFAULT NULL,
76   p_param_51  VARCHAR2 DEFAULT NULL,
77   p_param_52  VARCHAR2 DEFAULT NULL,
78   p_param_53  VARCHAR2 DEFAULT NULL,
79   p_param_54  VARCHAR2 DEFAULT NULL,
80   p_param_55  VARCHAR2 DEFAULT NULL,
81   p_param_56  VARCHAR2 DEFAULT NULL,
82   p_param_57  VARCHAR2 DEFAULT NULL,
83   p_param_58  VARCHAR2 DEFAULT NULL,
84   p_param_59  VARCHAR2 DEFAULT NULL,
85   p_param_60  VARCHAR2 DEFAULT NULL,
86   p_param_61  VARCHAR2 DEFAULT NULL,
87   p_param_62  VARCHAR2 DEFAULT NULL,
88   p_param_63  VARCHAR2 DEFAULT NULL,
89   p_param_64  VARCHAR2 DEFAULT NULL,
90   p_param_65  VARCHAR2 DEFAULT NULL,
91   p_param_66  VARCHAR2 DEFAULT NULL,
92   p_param_67  VARCHAR2 DEFAULT NULL,
93   p_param_68  VARCHAR2 DEFAULT NULL,
94   p_param_69  VARCHAR2 DEFAULT NULL,
95   p_param_70  VARCHAR2 DEFAULT NULL,
96   p_param_71  VARCHAR2 DEFAULT NULL,
97   p_param_72  VARCHAR2 DEFAULT NULL,
98   p_param_73  VARCHAR2 DEFAULT NULL,
99   p_param_74  VARCHAR2 DEFAULT NULL,
100   p_param_75  VARCHAR2 DEFAULT NULL,
101   p_param_76  VARCHAR2 DEFAULT NULL,
102   p_param_77  VARCHAR2 DEFAULT NULL,
103   p_param_78  VARCHAR2 DEFAULT NULL,
104   p_param_79  VARCHAR2 DEFAULT NULL,
105   p_param_80  VARCHAR2 DEFAULT NULL,
106   p_param_81  VARCHAR2 DEFAULT NULL,
107   p_param_82  VARCHAR2 DEFAULT NULL,
108   p_param_83  VARCHAR2 DEFAULT NULL,
109   p_param_84  VARCHAR2 DEFAULT NULL,
110   p_param_85  VARCHAR2 DEFAULT NULL,
111   p_param_86  VARCHAR2 DEFAULT NULL,
112   p_param_87  VARCHAR2 DEFAULT NULL,
113   p_param_88  VARCHAR2 DEFAULT NULL,
114   p_param_89  VARCHAR2 DEFAULT NULL,
115   p_param_90  VARCHAR2 DEFAULT NULL,
116   p_param_91  VARCHAR2 DEFAULT NULL,
117   p_param_92  VARCHAR2 DEFAULT NULL,
118   p_param_93  VARCHAR2 DEFAULT NULL,
119   p_param_94  VARCHAR2 DEFAULT NULL,
120   p_param_95  VARCHAR2 DEFAULT NULL,
121   p_param_96  VARCHAR2 DEFAULT NULL,
122   p_param_97  VARCHAR2 DEFAULT NULL,
123   p_param_98  VARCHAR2 DEFAULT NULL,
124   p_param_99  VARCHAR2 DEFAULT NULL)
125 RETURN VARCHAR2;
126 
127 -- Package variables
128 p_evaluated_part   VARCHAR2(2000);
129 
130 END IGS_RU_GEN_001;