1 PACKAGE WSH_CAL_ASG_PKG AUTHID CURRENT_USER AS
2 -- $Header: WSHCAPKS.pls 115.7 2003/07/22 07:48:53 msutar ship $
3
4 TYPE CalAsgRecType IS RECORD (
5 CALENDAR_CODE VARCHAR2(10),
6 CALENDAR_TYPE VARCHAR2(10),
7 ENABLED_FLAG VARCHAR2(1),
8 ASSOCIATION_TYPE VARCHAR2(20),
9 LOCATION_ASSOCIATION_ID NUMBER,
10 ORGANIZATION_ID NUMBER,
11 VENDOR_ID NUMBER,
12 CUSTOMER_ID NUMBER,
13 CUSTOMER_SITE_USE_ID NUMBER,
14 FREIGHT_CODE VARCHAR2(25),
15 FREIGHT_ORG_ID NUMBER,
16 HR_LOCATION_ID NUMBER,
17 VENDOR_SITE_ID NUMBER,
18 ATTRIBUTE_CATEGORY VARCHAR2(150),
19 ATTRIBUTE1 VARCHAR2(150),
20 ATTRIBUTE2 VARCHAR2(150),
21 ATTRIBUTE3 VARCHAR2(150),
22 ATTRIBUTE4 VARCHAR2(150),
23 ATTRIBUTE5 VARCHAR2(150),
24 ATTRIBUTE6 VARCHAR2(150),
25 ATTRIBUTE7 VARCHAR2(150),
26 ATTRIBUTE8 VARCHAR2(150),
27 ATTRIBUTE9 VARCHAR2(150),
28 ATTRIBUTE10 VARCHAR2(150),
29 ATTRIBUTE11 VARCHAR2(150),
30 ATTRIBUTE12 VARCHAR2(150),
31 ATTRIBUTE13 VARCHAR2(150),
32 ATTRIBUTE14 VARCHAR2(150),
33 ATTRIBUTE15 VARCHAR2(150),
34 LOCATION_ID NUMBER,
35 CARRIER_ID NUMBER,
36 CARRIER_SITE_ID NUMBER
37 );
38
39 --===================
40 -- PROCEDURES
41 --===================
42 --========================================================================
43 -- PROCEDURE : Create_Cal_Asg PUBLIC
44 -- PARAMETERS: p_api_version_number known api versionerror buffer
45 -- p_init_msg_list FND_API.G_TRUE to reset list
46 -- x_return_status return status
47 -- x_msg_count number of messages in the list
48 -- x_msg_data text of messages
49 -- VERSION : current version 1.0
50 -- initial version 1.0
51 -- COMMENT : Sets up a transportation calendar with a location, vendor,
52 -- customer, org, or carrier
53 --========================================================================
54 PROCEDURE Create_Cal_Asg
55 ( p_api_version_number IN NUMBER
56 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
57 , p_cal_asg_info IN CalAsgRecType DEFAULT NULL
58 , x_return_status OUT NOCOPY VARCHAR2
59 , x_msg_count OUT NOCOPY NUMBER
60 , x_msg_data OUT NOCOPY VARCHAR2
61 , x_Calendar_Aassignment_Id OUT NOCOPY NUMBER
62 );
63
64 --========================================================================
65 -- PROCEDURE : Update_Cal_Asg PUBLIC
66 -- PARAMETERS: p_api_version_number known api versionerror buffer
67 -- p_init_msg_list FND_API.G_TRUE to reset list
68 -- x_return_status return status
69 -- x_msg_count number of messages in the list
70 -- x_msg_data text of messages
71 -- p_calendar_assignment_id Primary Key
72 -- VERSION : current version 1.0
73 -- initial version 1.0
74 -- COMMENT : Updates the calendar code for an association
75 --========================================================================
76 PROCEDURE Update_Cal_Asg
77 ( p_api_version_number IN NUMBER
78 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
79 , p_calendar_asgmt_id IN NUMBER
80 , p_cal_asg_info IN CalAsgRecType DEFAULT NULL
81 , x_return_status OUT NOCOPY VARCHAR2
82 , x_msg_count OUT NOCOPY NUMBER
83 , x_msg_data OUT NOCOPY VARCHAR2
84 );
85 --========================================================================
86 -- PROCEDURE : Lock_Cal_Asg PUBLIC
87 -- PARAMETERS: p_Calendar_assignment_id primary key
88 -- VERSION : current version 1.0
89 -- initial version 1.0
90 -- COMMENT : Locks a row in the WSH_CALENDAR_ASSIGNMENTS table
91 --========================================================================
92 PROCEDURE Lock_Cal_Asg
93 ( p_Calendar_assignment_id IN NUMBER
94 , p_cal_asg_info IN CalAsgRecType DEFAULT NULL
95 );
96 --========================================================================
97 -- PROCEDURE : Delete_Cal_Asg PUBLIC
98 -- PARAMETERS: p_api_version_number known api versionerror buffer
99 -- p_init_msg_list FND_API.G_TRUE to reset list
100 -- x_return_status return status
101 -- x_msg_count number of messages in the list
102 -- x_msg_data text of messages
103 -- p_calendar_assignment_id primary key
104 -- VERSION : current version 1.0
105 -- initial version 1.0
106 -- COMMENT : Deletes a calendar assignment.
107 -- The order in which it looks at the parameters
108 -- are:
109 -- - p_rowid
110 -- - p_calendar_assignment_id
111 --========================================================================
112 PROCEDURE Delete_Cal_Asg
113 ( p_api_version_number IN NUMBER
114 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
115 , x_return_status OUT NOCOPY VARCHAR2
116 , x_msg_count OUT NOCOPY NUMBER
117 , x_msg_data OUT NOCOPY VARCHAR2
118 , p_calendar_assignment_id IN NUMBER
119 );
120 END WSH_CAL_ASG_PKG;