PACKAGE: APPS.WSH_DEPARTURE_TEMPLATE_ROWS

Source

1 package wsh_departure_template_rows AUTHID CURRENT_USER as
2 /* $Header: WSHTDEPS.pls 115.1 99/07/16 08:22:30 porting shi $ */
3 
4 
5 procedure insert_row(
6   X_rowid			in out varchar2,
7   X_departure_template_id	in out number,
8   X_name			varchar2,
9   X_organization_id		number,
10   X_vehicle_item_id		number,
11   X_vehicle_number 		varchar2,
12   X_freight_carrier_code	varchar2,
13   X_planned_frequency		varchar2,
14   X_planned_day			varchar2,
15   X_planned_time		number,
16   X_weight_uom_code		varchar2,
17   X_volume_uom_code		varchar2,
18   X_routing_instructions	varchar2,
19   X_attribute_category		varchar2,
20   X_attribute1			varchar2,
21   X_attribute2			varchar2,
22   X_attribute3			varchar2,
23   X_attribute4			varchar2,
24   X_attribute5			varchar2,
25   X_attribute6			varchar2,
26   X_attribute7			varchar2,
27   X_attribute8			varchar2,
28   X_attribute9			varchar2,
29   X_attribute10			varchar2,
30   X_attribute11			varchar2,
31   X_attribute12			varchar2,
32   X_attribute13			varchar2,
33   X_attribute14			varchar2,
34   X_attribute15			varchar2,
35   X_creation_date		date,
36   X_created_by			number,
37   X_last_update_date		date,
38   X_last_updated_by		number,
39   X_last_update_login		number);
40 
41 procedure lock_row(
42   X_rowid			varchar2,
43   X_departure_template_id	number,
44   X_name			varchar2,
45   X_organization_id		number,
46   X_vehicle_item_id		number,
47   X_vehicle_number 		varchar2,
48   X_freight_carrier_code	varchar2,
49   X_planned_frequency		varchar2,
50   X_planned_day			varchar2,
51   X_planned_time		number,
52   X_weight_uom_code		varchar2,
53   X_volume_uom_code		varchar2,
54   X_routing_instructions	varchar2,
55   X_attribute_category		varchar2,
56   X_attribute1			varchar2,
57   X_attribute2			varchar2,
58   X_attribute3			varchar2,
59   X_attribute4			varchar2,
60   X_attribute5			varchar2,
61   X_attribute6			varchar2,
62   X_attribute7			varchar2,
63   X_attribute8			varchar2,
64   X_attribute9			varchar2,
65   X_attribute10			varchar2,
66   X_attribute11			varchar2,
67   X_attribute12			varchar2,
68   X_attribute13			varchar2,
69   X_attribute14			varchar2,
70   X_attribute15			varchar2);
71 
72 procedure update_row(
73   X_rowid			varchar2,
74   X_departure_template_id	number,
75   X_name			varchar2,
76   X_organization_id		number,
77   X_vehicle_item_id		number,
78   X_vehicle_number 		varchar2,
79   X_freight_carrier_code	varchar2,
80   X_planned_frequency		varchar2,
81   X_planned_day			varchar2,
82   X_planned_time		number,
83   X_weight_uom_code		varchar2,
84   X_volume_uom_code		varchar2,
85   X_routing_instructions	varchar2,
86   X_attribute_category		varchar2,
87   X_attribute1			varchar2,
88   X_attribute2			varchar2,
89   X_attribute3			varchar2,
90   X_attribute4			varchar2,
91   X_attribute5			varchar2,
92   X_attribute6			varchar2,
93   X_attribute7			varchar2,
94   X_attribute8			varchar2,
95   X_attribute9			varchar2,
96   X_attribute10			varchar2,
97   X_attribute11			varchar2,
98   X_attribute12			varchar2,
99   X_attribute13			varchar2,
100   X_attribute14			varchar2,
101   X_attribute15			varchar2,
102   X_last_update_date            date,
103   X_last_updated_by             number,
104   X_last_update_login           number);
105 
106 
107 procedure delete_row(X_rowid varchar2);
108 
109 
110 end wsh_departure_template_rows;