1 Package OKS_K_ACTIONS_PVT AS
2 /* $Header: OKSKACTS.pls 120.4.12000000.5 2007/04/05 22:15:04 skkoppul ship $ */
3
4 PROCEDURE setRemindersYn
5 (
6 p_api_version IN NUMBER,
7 p_init_msg_list IN VARCHAR2,
8 p_chr_id IN NUMBER,
9 p_suppress_Yn IN VARCHAR2,
10 x_return_status OUT NOCOPY VARCHAR2,
11 x_msg_data OUT NOCOPY VARCHAR2,
12 x_msg_count OUT NOCOPY NUMBER
13 );
14
15 PROCEDURE send_email
16 (p_chr_id IN number
17 ,p_to_address IN VARCHAR2
18 ,p_cc_address IN VARCHAR2
19 ,p_from_address IN VARCHAR2
20 ,p_reply_to_address IN VARCHAR2
21 ,p_subject IN VARCHAR2
22 ,p_message_template_id IN number
23 ,p_attachment_template_id IN number
24 ,p_email_text IN VARCHAR2
25 ,p_contract_status_code IN VARCHAR2
26 ,x_request_id OUT NOCOPY number
27 ,x_return_status OUT NOCOPY VARCHAR2
28 ,x_msg_count OUT NOCOPY NUMBER
29 ,x_msg_data OUT NOCOPY varchar2
30 );
31
32 PROCEDURE execute_qa_check_list(
33 p_api_version IN NUMBER,
34 p_init_msg_list IN VARCHAR2 ,
35 x_return_status OUT NOCOPY VARCHAR2,
36 x_msg_count OUT NOCOPY NUMBER,
37 x_msg_data OUT NOCOPY VARCHAR2,
38 p_qcl_id IN NUMBER,
39 p_chr_id IN NUMBER,
40 p_override_flag IN VARCHAR2);
41
42 FUNCTION get_to_email (p_contract_id IN NUMBER) RETURN VARCHAR2;
43
47 p_init_msg_list IN VARCHAR2,
44 PROCEDURE launch_qa_report
45 (
46 p_api_version IN NUMBER,
48 p_contract_list IN VARCHAR2,
49 x_cp_request_id OUT NOCOPY NUMBER,
50 x_return_status OUT NOCOPY VARCHAR2,
51 x_msg_data OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER
53 ) ;
54
55
56 /*
57 This function checks if the contract is valid for Renewal Workbench Table Action
58 s. This check is done before doing following Actions
59 Enable Reminders, Disable Reminders, Submit for Approval and Publish to Customer
60 Parameter: contract id
61 Returns: Y or N. If the ste_code is ENTERED then returns Y else returns N
62 */
63 FUNCTION validateForRenewalAction (p_chr_id NUMBER, p_called_from VARCHAR2 DEFAULT NULL)
64 RETURN VARCHAR2;
65
66 /*
67 This method will insert the email details
68 into OKS_EMAIL_DETAILS table and
69 will return email_id as the output parameter value.- Bug#4911901
70 */
71
72 PROCEDURE STORE_EMAIL_DTLS
73 (
74 p_from_address IN VARCHAR2,
75 p_to_address IN VARCHAR2,
76 p_cc_address IN VARCHAR2,
77 p_reply_to_address IN VARCHAR2,
78 p_message_template_id IN NUMBER,
79 p_attachment_template_id IN NUMBER,
80 p_email_subject IN VARCHAR2,
81 p_email_body IN VARCHAR2,
82 p_email_contract_status IN VARCHAR2,
83 x_email_id OUT NOCOPY NUMBER,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_msg_data OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER
87 );
88
89 /*
90 This API will retrieve email details from OKS_EMAIL_DETAILS table.- Bug#4911901
91 */
92
93 PROCEDURE GET_EMAIL_DTLS
94 (
95 p_email_id IN NUMBER,
96 x_email_body OUT NOCOPY VARCHAR2,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_data OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER
100 );
101
102 /*
103 This API will delete email details from OKS_EMAIL_DETAILS table.- Bug#4911901
104 */
105 PROCEDURE DEL_EMAIL_DTLS
106 (
107 p_email_id IN NUMBER,
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_data OUT NOCOPY VARCHAR2,
113 /* Overloaded send_email API that has been already defined.- Bug#4911901*/
110 x_msg_count OUT NOCOPY NUMBER
111 );
112
114 PROCEDURE send_email
115 (p_chr_id IN NUMBER
116 ,p_email_Id IN NUMBER
117 ,p_to_address IN VARCHAR2
118 ,p_cc_address IN VARCHAR2
119 ,p_from_address IN VARCHAR2
120 ,p_reply_to_address IN VARCHAR2
121 ,p_subject IN VARCHAR2
122 ,p_message_template_id IN NUMBER
123 ,p_attachment_template_id IN NUMBER
124 ,p_contract_status_code IN VARCHAR2
125 ,x_request_id OUT NOCOPY NUMBER
126 ,x_return_status OUT NOCOPY VARCHAR2
127 ,x_msg_count OUT NOCOPY NUMBER
128 ,x_msg_data OUT NOCOPY VARCHAR2
129 );
130
131 /*
132 This API will update contract status, followup, forecast, notes for Mass and Single update contract action
133 */
134 PROCEDURE update_single_contracts
135 (
136 p_chr_id IN OKC_K_HEADERS_ALL_B.ID%TYPE,
137 p_status_code IN OKC_K_HEADERS_ALL_B.STS_CODE%TYPE default NULL,
138 p_reason_code IN OKC_K_HEADERS_ALL_B.TRN_CODE%TYPE default NULL,
139 p_comments IN VARCHAR2 default NULL,
140 p_due_date IN OKS_K_HEADERS_B.FOLLOW_UP_DATE%TYPE default NULL,
141 p_action IN OKS_K_HEADERS_B.FOLLOW_UP_ACTION%TYPE default NULL,
142 p_est_percent IN OKS_K_HEADERS_B.EST_REV_PERCENT%TYPE default NULL,
143 p_est_date IN OKS_K_HEADERS_B.EST_REV_DATE%TYPE default NULL,
144 p_contract_notes IN JTF_NOTES_TL.NOTES%TYPE default NULL,
145 x_succ_err_contract OUT NOCOPY VARCHAR2,
146 x_return_status OUT NOCOPY VARCHAR2,
147 x_msg_data OUT NOCOPY VARCHAR2,
148 x_msg_count OUT NOCOPY NUMBER
149 );
150
151
152 END OKS_K_ACTIONS_PVT;
153