[Home] [Help]
PACKAGE: APPS.IES_SVY_DEPLOYMENT_PVT
Source
1 PACKAGE IES_SVY_DEPLOYMENT_PVT AUTHID CURRENT_USER AS
2 /* $Header: iesdpyps.pls 120.1 2005/06/16 11:15:33 appldev $ */
3 ----------------------------------------------------------------------------------------------------------
4 -- Procedure
5 -- Submit_Deployment
6
7 -- PURPOSE
8 -- Submit Deployment to Concurrent Manager at the specified_time.
9 --
10 -- PARAMETERS
11
12 -- NOTES
13 -- created rrsundar 05/03/2000
14 ---------------------------------------------------------------------------------------------------------
15
16
17 Procedure Submit_Deployment
18 (
19 p_api_version IN NUMBER ,
20 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
21 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
22 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
23 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
24 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,
25 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
26 x_message OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
27 p_user_id IN NUMBER ,
28 p_resp_id IN NUMBER ,
29 p_deployment_id IN NUMBER := NULL ,
30 p_list_entry_id IN NUMBER := NULL ,
31 p_template_id IN NUMBER := NULL ,
32 p_start_time IN DATE := NULL ,
33 p_reminder_type IN VARCHAR2 := NULL
34 );
35 ---------------------------------------------------------------------------------------------------------
36 -- Procedure
37 -- FM_Single_Request
38 -- PURPOSE Wrapper API to select the appropriate template details and submit a request to the
39 -- fulfillment engine.
40 --
41 --
42 -- PARAMETERS
43 -- NOTES
44 -- created kpandey 05/02/2000
45 ---------------------------------------------------------------------------------------------------------
46 PROCEDURE FM_Single_Request
47 (
48 p_api_version IN NUMBER ,
49 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
50 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
51 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
52 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
53 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,
54 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
55 x_message OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
56 -- errbuf OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
57 -- retcode OUT NOCOPY /* file.sql.39 change */ NUMBER ,
58 p_list_entry_id IN NUMBER ,
59 p_template_id IN NUMBER ,
60 p_deployment_id IN NUMBER ,
61 p_user_id IN NUMBER
62 );
63
64 ----------------------------------------------------------------------------------------------------------
65 -- Procedure
66 -- FM_Group_Request
67 -- PURPOSE Wrapper API to select the appropriate template details and submit a
68 -- group request (mass e-mail invitation) to the fulfillment engine.
69 --
70 --
71 -- PARAMETERS
72 -- NOTES
73 -- created kpandey 06/07/2000
74 ---------------------------------------------------------------------------------------------------------
75 PROCEDURE FM_Group_Request
76 (
77 errbuf OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
78 retcode OUT NOCOPY /* file.sql.39 change */ NUMBER ,
79 p_api_version IN NUMBER ,
80 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
81 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
82 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
83 p_deployment_id IN NUMBER ,
84 p_template_id IN NUMBER ,
85 p_reminder_type IN VARCHAR2 ,
86 p_user_id IN NUMBER ,
87 p_reminder_hst_id IN NUMBER
88 -- no other out params are allowed here since its called from concurrent manager
89 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
90 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,
91 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
92 -- x_message OUT NOCOPY /* file.sql.39 change */ VARCHAR2
93 );
94
95 ----------------------------------------------------------------------------------------------------------
96 -- Procedure
97 -- Populate_Survey_List_Entries
98 -- PURPOSE Wrapper API to populate IEY_SUREVY_LIST_ENTRIES based on the list_header_id and .
99 -- deployment_id
100 --
101 -- PARAMETERS
102 -- NOTES
103 -- created kpandey 06/07/2000
104 ---------------------------------------------------------------------------------------------------------
105 PROCEDURE Populate_Survey_List_Entries
106 (
107 p_api_version IN NUMBER ,
108 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
109 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
110 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
111 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
112 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,
113 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
114 x_message OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
115 p_survey_deployment_id IN NUMBER
116 );
117
118 Procedure Update_Dep_Status (p_dep_id NUMBER,
119 p_status VARCHAR2,
120 p_reminder_type VARCHAR2,
121 p_update_flag VARCHAR2);
122
123 END; -- Package spec
124