1 PACKAGE csf_requests_pvt AUTHID CURRENT_USER AS
2 /* $Header: CSFVREQS.pls 120.10.12020000.2 2012/07/23 19:09:10 kramini 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_resource_tbl IN resource_tbl_type DEFAULT NULL
17 , p_status_id IN NUMBER DEFAULT NULL
18 , p_route_based_flag IN VARCHAR2 DEFAULT 'N'
19 , p_changed_option_start IN DATE DEFAULT NULL
20 , p_changed_option_end IN DATE DEFAULT NULL
21 , p_changed_planned_start IN DATE DEFAULT NULL
22 , p_changed_planned_end IN DATE DEFAULT NULL
23 , p_disabled_access_hours_flag IN VARCHAR2 DEFAULT 'N'
24 , p_set_plan_task_confirmed IN VARCHAR2 DEFAULT 'N'
25 , p_parent_id IN NUMBER DEFAULT NULL
26 , p_spares_mandatory IN VARCHAR2 DEFAULT NULL
27 , p_spares_source IN VARCHAR2 DEFAULT NULL
28 , p_standby_param IN VARCHAR2 DEFAULT NULL
29 , p_resource_preference IN VARCHAR2 DEFAULT NULL
30 , p_cust_or_disp_init IN VARCHAR2 DEFAULT NULL
31 , x_request_id OUT NOCOPY NUMBER
32 );
33
34 PROCEDURE create_resource_results(
35 p_api_version IN NUMBER
36 , p_init_msg_list IN VARCHAR2 DEFAULT NULL
37 , p_commit IN VARCHAR2 DEFAULT NULL
38 , x_return_status OUT NOCOPY VARCHAR2
39 , x_msg_count OUT NOCOPY NUMBER
40 , x_msg_data OUT NOCOPY VARCHAR2
41 , p_request_task_id IN VARCHAR2
42 , p_resource_tbl IN resource_tbl_type
43 );
44
45 PROCEDURE create_plan_option(
46 p_api_version IN NUMBER
47 , p_init_msg_list IN VARCHAR2 DEFAULT NULL
48 , p_commit IN VARCHAR2 DEFAULT NULL
49 , x_return_status OUT NOCOPY VARCHAR2
50 , x_msg_count OUT NOCOPY NUMBER
51 , x_msg_data OUT NOCOPY VARCHAR2
52 , p_request_task_id IN NUMBER
53 , p_scheduled_start_date IN DATE
54 , p_scheduled_end_date IN DATE
55 , p_resource_id IN NUMBER
56 , p_resource_type IN VARCHAR2
57 , p_cost IN NUMBER
58 , p_terr_id IN NUMBER
59 , p_win_to_promis_id IN NUMBER
60 , p_spares_cost IN NUMBER
61 , p_spares_date IN DATE
62 , p_shift_type IN VARCHAR2
63 , x_plan_option_id OUT NOCOPY NUMBER
64 );
65
66 PROCEDURE create_plan_option_task(
67 p_api_version IN NUMBER
68 , p_init_msg_list IN VARCHAR2 DEFAULT NULL
69 , p_commit IN VARCHAR2 DEFAULT NULL
70 , x_return_status OUT NOCOPY VARCHAR2
71 , x_msg_count OUT NOCOPY NUMBER
72 , x_msg_data OUT NOCOPY VARCHAR2
73 , p_plan_option_id IN NUMBER
74 , p_task_id IN NUMBER
75 , p_scheduled_start_date IN DATE
76 , p_scheduled_end_date IN DATE
77 , p_travel_time IN NUMBER
78 , p_task_assign_id IN NUMBER
79 , p_trip_id IN NUMBER
80 );
81
82 PROCEDURE create_message(
83 p_api_version IN NUMBER
84 , p_init_msg_list IN VARCHAR2 DEFAULT NULL
85 , p_commit IN VARCHAR2 DEFAULT NULL
86 , x_return_status OUT NOCOPY VARCHAR2
87 , x_msg_count OUT NOCOPY NUMBER
88 , x_msg_data OUT NOCOPY VARCHAR2
89 , p_request_id IN NUMBER
90 , p_name IN VARCHAR2
91 , p_type IN VARCHAR2
92 , x_message_id OUT NOCOPY NUMBER
93 );
94
95 PROCEDURE create_message_token(
96 p_api_version IN NUMBER
97 , p_init_msg_list IN VARCHAR2 DEFAULT NULL
98 , p_commit IN VARCHAR2 DEFAULT NULL
99 , x_return_status OUT NOCOPY VARCHAR2
100 , x_msg_count OUT NOCOPY NUMBER
101 , x_msg_data OUT NOCOPY VARCHAR2
102 , p_message_id IN NUMBER
103 , p_name IN VARCHAR2
104 , p_value IN VARCHAR2
105 );
106
107 PROCEDURE create_plan_options(
108 p_api_version IN NUMBER
109 , p_init_msg_list IN VARCHAR2
110 , p_commit IN VARCHAR2
111 , x_return_status OUT NOCOPY VARCHAR2
112 , x_msg_count OUT NOCOPY NUMBER
113 , x_msg_data OUT NOCOPY VARCHAR2
114 , p_request_task_id IN NUMBER
115 , p_scheduled_start_date_tbl IN jtf_date_table
116 , p_scheduled_end_date_tbl IN jtf_date_table
117 , p_resource_id_tbl IN jtf_number_table
118 , p_resource_type_tbl IN jtf_varchar2_table_100
119 , p_cost_tbl IN jtf_number_table
120 , p_terr_id_tbl IN jtf_number_table
121 , p_win_to_promis_id_tbl IN jtf_number_table
122 , p_spares_cost_tbl IN jtf_number_table
123 , p_spares_date_tbl IN jtf_date_table
124 , p_spares_warehouseInfo_tbl IN jtf_varchar2_table_4000 DEFAULT NULL
125 , p_spares_shippingMethod_tbl IN jtf_varchar2_table_4000 DEFAULT NULL
126 , p_spares_shippingDistance_tbl IN jtf_varchar2_table_4000 DEFAULT NULL
127 , p_shift_type_tbl IN jtf_varchar2_table_100
128 , x_plan_option_id_tbl OUT NOCOPY jtf_number_table
129 );
130
131 PROCEDURE create_multi_trips_request(
132 p_api_version IN NUMBER
133 , p_init_msg_list IN VARCHAR2 DEFAULT NULL
134 , p_commit IN VARCHAR2 DEFAULT NULL
135 , x_return_status OUT NOCOPY VARCHAR2
136 , x_msg_count OUT NOCOPY NUMBER
137 , x_msg_data OUT NOCOPY VARCHAR2
138 , p_parent_req_name IN VARCHAR2
139 , p_child_req_name IN VARCHAR2
140 , p_trip_tbl IN object_tbl_type DEFAULT NULL
141 , p_resource_tbl IN resource_tbl_type DEFAULT NULL
142 , x_sched_request_id OUT NOCOPY NUMBER
143 );
144
145 END csf_requests_pvt;