[Home] [Help]
PACKAGE: APPS.OTA_CERT_APPROVAL_SS
Source
1 PACKAGE OTA_CERT_APPROVAL_SS AUTHID CURRENT_USER AS
2 /* $Header: otcrtrev.pkh 120.1 2005/07/11 05:49 dbatra noship $*/
3
4
5 -- Global variables
6 g_date_format varchar2(10) := 'RRRR/MM/DD';
7
8 procedure save_cert_enroll_detail(
9 p_login_person_id in number,
10 p_item_type in varchar2,
11 p_item_key in varchar2,
12 p_activity_id in number,
13 p_certification_id in varchar2,
14 p_person_id in number,
15 p_certification_status_code in varchar2 default null,
16 p_completion_date in varchar2 default null,
17 p_UNENROLLMENT_DATE in varchar2 default null,
18 p_EXPIRATION_DATE in varchar2 default null,
19 p_EARLIEST_ENROLL_DATE in varchar2 default null,
20 p_IS_HISTORY_FLAG in varchar2 default 'N',
21 p_business_group_id in varchar2 default null,
22 p_attribute_category in varchar2 default null,
23 p_attribute1 in varchar2 default null,
24 p_attribute2 in varchar2 default null,
25 p_attribute3 in varchar2 default null,
26 p_attribute4 in varchar2 default null,
27 p_attribute5 in varchar2 default null,
28 p_attribute6 in varchar2 default null,
29 p_attribute7 in varchar2 default null,
30 p_attribute8 in varchar2 default null,
31 p_attribute9 in varchar2 default null,
32 p_attribute10 in varchar2 default null,
33 p_attribute11 in varchar2 default null,
34 p_attribute12 in varchar2 default null,
35 p_attribute13 in varchar2 default null,
36 p_attribute14 in varchar2 default null,
37 p_attribute15 in varchar2 default null,
38 p_attribute16 in varchar2 default null,
39 p_attribute17 in varchar2 default null,
40 p_attribute18 in varchar2 default null,
41 p_attribute19 in varchar2 default null,
42 p_attribute20 in varchar2 default null,
43 p_from in varchar2,
44 p_error_message OUT NOCOPY VARCHAR2
45 );
46
47
48
49
50
51 PROCEDURE get_add_enr_dtl_data_from_tt
52 (p_item_type in varchar2
53 ,p_item_key in varchar2
54 ,p_activity_id in varchar2
55 -- ,p_trans_rec_count out nocopy number
56 -- ,p_person_id out nocopy number
57 ,p_add_enroll_detail_data out nocopy varchar2
58 );
59
60
61
62 procedure get_add_enr_dtl_data_from_tt
63 (p_transaction_step_id in number
64 ,p_add_enroll_detail_data out nocopy varchar2
65 );
66
67 PROCEDURE get_review_data
68 (p_item_type in varchar2
69 ,p_item_key in varchar2
70 ,p_activity_id in varchar2
71 ,p_review_data out nocopy varchar2
72 );
73
74 procedure get_review_data
75 (p_transaction_step_id in number
76 ,p_review_data out nocopy varchar2
77 );
78
79
80 procedure process_api
81 (p_validate IN BOOLEAN DEFAULT FALSE
82 ,p_transaction_step_id IN NUMBER DEFAULT NULL
83 ,p_effective_date in varchar2 DEFAULT NULL
84 );
85
86 procedure create_enrollment
87 (itemtype in varchar2,
88 itemkey in varchar2,
89 actid in number,
90 funmode in varchar2,
91 result out nocopy varchar2 );
92
93 procedure cancel_enrollment
94 (itemtype in varchar2,
95 itemkey in varchar2,
96 actid in number,
97 funmode in varchar2,
98 result out nocopy varchar2 );
99
100 procedure validate_enrollment
101 (p_item_type in varchar2,
102 p_item_key in varchar2,
103 p_message out nocopy varchar2) ;
104
105
106
107
108
109 Procedure APPROVED ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
110 itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
111 actid IN NUMBER,
112 funcmode IN VARCHAR2,
113 resultout OUT nocopy VARCHAR2 );
114
115
116
117 -- ---------------------------------------------------------------------------
118 -- |----------------------< get_approval_req >--------------------------|
119 -- ---------------------------------------------------------------------------
120 --
121 PROCEDURE get_approval_req ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
122 itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
123 actid IN NUMBER,
124 funcmode IN VARCHAR2,
125 resultout OUT nocopy VARCHAR2 );
126
127
128 end OTA_CERT_APPROVAL_SS;
129