1 PACKAGE csf_requests_pvt AS
2 /* $Header: CSFVREQS.pls 120.4 2008/02/07 12:50:07 venjayar ship $ */
3
4 TYPE resource_tbl_type IS TABLE OF csf_r_resource_results%ROWTYPE;
5 TYPE object_tbl_type IS TABLE OF NUMBER;
6
7 PROCEDURE create_scheduler_request(
8 p_api_version IN NUMBER
9 , p_init_msg_list IN VARCHAR2 DEFAULT NULL
10 , p_commit IN VARCHAR2 DEFAULT NULL
11 , x_return_status OUT NOCOPY VARCHAR2
12 , x_msg_count OUT NOCOPY NUMBER
13 , x_msg_data OUT NOCOPY VARCHAR2
14 , p_name IN VARCHAR2
15 , p_object_id IN NUMBER
16 , p_spares_likelihood IN NUMBER DEFAULT NULL
17 , p_resource_tbl IN resource_tbl_type DEFAULT NULL
18 , p_status_id IN NUMBER DEFAULT NULL
19 , p_route_based_flag IN VARCHAR2 DEFAULT 'N'
20 , p_changed_option_start IN DATE DEFAULT NULL
21 , p_changed_option_end IN DATE DEFAULT NULL
22 , p_changed_planned_start IN DATE DEFAULT NULL
23 , p_changed_planned_end IN DATE DEFAULT NULL
24 , p_disabled_access_hours_flag IN VARCHAR2 DEFAULT 'N'
25 , p_set_plan_task_confirmed IN VARCHAR2 DEFAULT 'N'
26 , p_parent_id IN NUMBER DEFAULT NULL
27 , x_request_id OUT NOCOPY NUMBER
28 );
29
30 PROCEDURE create_resource_results(
31 p_api_version IN NUMBER
32 , p_init_msg_list IN VARCHAR2 DEFAULT NULL
33 , p_commit IN VARCHAR2 DEFAULT NULL
34 , x_return_status OUT NOCOPY VARCHAR2
35 , x_msg_count OUT NOCOPY NUMBER
36 , x_msg_data OUT NOCOPY VARCHAR2
37 , p_request_task_id IN VARCHAR2
38 , p_resource_tbl IN resource_tbl_type
39 );
40
41 PROCEDURE create_plan_option(
42 p_api_version IN NUMBER
43 , p_init_msg_list IN VARCHAR2 DEFAULT NULL
44 , p_commit IN VARCHAR2 DEFAULT NULL
45 , x_return_status OUT NOCOPY VARCHAR2
46 , x_msg_count OUT NOCOPY NUMBER
47 , x_msg_data OUT NOCOPY VARCHAR2
48 , p_request_task_id IN NUMBER
49 , p_scheduled_start_date IN DATE
50 , p_scheduled_end_date IN DATE
51 , p_resource_id IN NUMBER
52 , p_resource_type IN VARCHAR2
53 , p_cost IN NUMBER
54 , p_terr_id IN NUMBER
55 , p_win_to_promis_id IN NUMBER
56 , p_spares_cost IN NUMBER
57 , p_spares_date IN DATE
58 , x_plan_option_id OUT NOCOPY NUMBER
59 );
60
61 PROCEDURE create_plan_option_task(
62 p_api_version IN NUMBER
63 , p_init_msg_list IN VARCHAR2 DEFAULT NULL
64 , p_commit IN VARCHAR2 DEFAULT NULL
65 , x_return_status OUT NOCOPY VARCHAR2
66 , x_msg_count OUT NOCOPY NUMBER
67 , x_msg_data OUT NOCOPY VARCHAR2
68 , p_plan_option_id IN NUMBER
69 , p_task_id IN NUMBER
70 , p_scheduled_start_date IN DATE
71 , p_scheduled_end_date IN DATE
72 , p_travel_time IN NUMBER
73 , p_task_assign_id IN NUMBER
74 , p_trip_id IN NUMBER
75 );
76
77 PROCEDURE create_message(
78 p_api_version IN NUMBER
79 , p_init_msg_list IN VARCHAR2 DEFAULT NULL
80 , p_commit IN VARCHAR2 DEFAULT NULL
81 , x_return_status OUT NOCOPY VARCHAR2
82 , x_msg_count OUT NOCOPY NUMBER
83 , x_msg_data OUT NOCOPY VARCHAR2
84 , p_request_id IN NUMBER
85 , p_name IN VARCHAR2
86 , p_type IN VARCHAR2
87 , x_message_id OUT NOCOPY NUMBER
88 );
89
90 PROCEDURE create_message_token(
91 p_api_version IN NUMBER
92 , p_init_msg_list IN VARCHAR2 DEFAULT NULL
93 , p_commit IN VARCHAR2 DEFAULT NULL
94 , x_return_status OUT NOCOPY VARCHAR2
95 , x_msg_count OUT NOCOPY NUMBER
96 , x_msg_data OUT NOCOPY VARCHAR2
97 , p_message_id IN NUMBER
98 , p_name IN VARCHAR2
99 , p_value IN VARCHAR2
100 );
101
102 PROCEDURE create_plan_options(
103 p_api_version IN NUMBER
104 , p_init_msg_list IN VARCHAR2
105 , p_commit IN VARCHAR2
106 , x_return_status OUT NOCOPY VARCHAR2
107 , x_msg_count OUT NOCOPY NUMBER
108 , x_msg_data OUT NOCOPY VARCHAR2
109 , p_request_task_id IN NUMBER
110 , p_scheduled_start_date_tbl IN jtf_date_table
111 , p_scheduled_end_date_tbl IN jtf_date_table
112 , p_resource_id_tbl IN jtf_number_table
113 , p_resource_type_tbl IN jtf_varchar2_table_100
114 , p_cost_tbl IN jtf_number_table
115 , p_terr_id_tbl IN jtf_number_table
116 , p_win_to_promis_id_tbl IN jtf_number_table
117 , p_spares_cost_tbl IN jtf_number_table
118 , p_spares_date_tbl IN jtf_date_table
119 , x_plan_option_id_tbl OUT NOCOPY jtf_number_table
120 );
121
122 PROCEDURE create_multi_trips_request(
123 p_api_version IN NUMBER
124 , p_init_msg_list IN VARCHAR2 DEFAULT NULL
125 , p_commit IN VARCHAR2 DEFAULT NULL
126 , x_return_status OUT NOCOPY VARCHAR2
127 , x_msg_count OUT NOCOPY NUMBER
128 , x_msg_data OUT NOCOPY VARCHAR2
129 , p_parent_req_name IN VARCHAR2
130 , p_child_req_name IN VARCHAR2
131 , p_trip_tbl IN object_tbl_type DEFAULT NULL
132 , p_resource_tbl IN resource_tbl_type DEFAULT NULL
133 , x_sched_request_id OUT NOCOPY NUMBER
134 );
135
136 END csf_requests_pvt;