[Home] [Help]
PACKAGE: APPS.WSH_FREIGHT_COSTS_GRP
Source
1 PACKAGE WSH_FREIGHT_COSTS_GRP AUTHID CURRENT_USER as
2 /* $Header: WSHFCGPS.pls 120.0.12010000.1 2008/07/29 06:04:34 appldev ship $ */
3
4 --===================
5 -- PROCEDURES
6 --===================
7 --========================================================================
8 -- PROCEDURE : Create_Update_Freight_Costs
9 --
10 -- PARAMETERS: p_api_version_number known api versionerror buffer
11 -- p_init_msg_list initialize message stack
12 -- x_return_status return status
13 -- x_msg_count number of messages in the list
14 -- x_msg_data text of messages
15 -- p_freight_cost_rec freight cost record
16 -- p_source_code source system
17 --
18 --
19 -- COMMENT : Create or Update freight costs
20 -- org_organization_definitions. If both values are
21 -- specified then only Org_Id is used
22 --========================================================================
23
24 TYPE PubFreightCostRecType IS RECORD(
25 FREIGHT_COST_ID NUMBER DEFAULT FND_API.G_MISS_NUM
26 , FREIGHT_COST_TYPE_ID NUMBER DEFAULT FND_API.G_MISS_NUM
27 , UNIT_AMOUNT NUMBER DEFAULT FND_API.G_MISS_NUM
28 , CALCULATION_METHOD VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
29 , UOM VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR
30 , QUANTITY NUMBER DEFAULT FND_API.G_MISS_NUM
31 , TOTAL_AMOUNT NUMBER DEFAULT FND_API.G_MISS_NUM
32 , CURRENCY_CODE VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR
33 , CONVERSION_DATE DATE DEFAULT FND_API.G_MISS_DATE
34 , CONVERSION_RATE NUMBER DEFAULT FND_API.G_MISS_NUM
35 , CONVERSION_TYPE_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
36 , TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM
37 , TRIP_NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
38 , STOP_ID NUMBER DEFAULT FND_API.G_MISS_NUM
39 , STOP_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM
40 , PLANNED_DEP_DATE DATE DEFAULT FND_API.G_MISS_DATE
41 , DELIVERY_ID NUMBER DEFAULT FND_API.G_MISS_NUM
42 , DELIVERY_NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
43 , DELIVERY_LEG_ID NUMBER DEFAULT FND_API.G_MISS_NUM
44 , DELIVERY_DETAIL_ID NUMBER DEFAULT FND_API.G_MISS_NUM
45 , ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
46 , ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
47 , ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
48 , ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
49 , ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
50 , ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
51 , ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
52 , ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
53 , ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
54 , ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
55 , ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
56 , ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
57 , ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
58 , ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
59 , ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
60 , ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
61 , CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE
62 , CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM
63 , LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE
64 , LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM
65 , LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM
66 , PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM
67 , PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM
68 , PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE
69 , REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM
70 , FREIGHT_COST_TYPE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
71 , FREIGHT_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
72 , PRICING_LIST_HEADER_ID NUMBER DEFAULT FND_API.G_MISS_NUM
73 , PRICING_LIST_LINE_ID NUMBER DEFAULT FND_API.G_MISS_NUM
74 , APPLIED_TO_CHARGE_ID NUMBER DEFAULT FND_API.G_MISS_NUM
75 , CHARGE_UNIT_VALUE NUMBER DEFAULT FND_API.G_MISS_NUM
76 , CHARGE_SOURCE_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
77 , LINE_TYPE_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
78 , ESTIMATED_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
79 , ACTION_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
80 , COMMODITY_CATEGORY_ID NUMBER DEFAULT FND_API.G_MISS_NUM
81 );
82
83 TYPE PubFreightCostTabType IS TABLE OF PubFreightCostRecType INDEX BY BINARY_INTEGER;
84
85 PROCEDURE Create_Update_Freight_Costs (
86 p_api_version_number IN NUMBER
87 , p_init_msg_list IN VARCHAR2
88 , p_commit IN VARCHAR2
89 , x_return_status OUT NOCOPY VARCHAR2
90 , x_msg_count OUT NOCOPY NUMBER
91 , x_msg_data OUT NOCOPY VARCHAR2
92 , p_pub_freight_costs IN WSH_FREIGHT_COSTS_GRP.PubFreightCostRecType
93 , p_action_code IN VARCHAR2
94 , x_freight_cost_id OUT NOCOPY NUMBER
95 );
96
97 PROCEDURE Validate_freight_Cost_type(
98 p_freight_cost_type IN VARCHAR2
99 , x_freight_cost_type_id IN OUT NOCOPY NUMBER
100 , x_return_status OUT NOCOPY VARCHAR2
101 );
102
103 PROCEDURE Delete_Freight_costs(
104 p_api_version_number IN NUMBER
105 , p_init_msg_list IN VARCHAR2
106 , p_commit IN VARCHAR2
107 , x_return_status OUT NOCOPY VARCHAR2
108 , x_msg_count OUT NOCOPY NUMBER
109 , x_msg_data OUT NOCOPY VARCHAR2
110 , p_pub_freight_costs IN WSH_FREIGHT_COSTS_GRP.PubFreightCostRecType
111 );
112
113 --Harmonizing Project : heali
114 TYPE FreightInRecType IS RECORD
115 (
116 caller VARCHAR2(32767),
117 action_code VARCHAR2(32767),
118 phase NUMBER
119 );
120
121 TYPE FreightOutRecType IS RECORD
122 (
123 freight_cost_id NUMBER,
124 rowid VARCHAR2(4000)
125 );
126
127 TYPE freight_rec_tab_type IS TABLE OF WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type INDEX BY BINARY_INTEGER;
128 TYPE freight_out_tab_type IS TABLE OF FreightOutRecType INDEX BY BINARY_INTEGER;
129
130 PROCEDURE Create_Update_Freight_Costs(
131 p_api_version_number IN NUMBER,
132 p_init_msg_list IN VARCHAR2,
133 p_commit IN VARCHAR2,
134 p_freight_info_tab IN freight_rec_tab_type,
135 p_in_rec IN freightInRecType,
136 x_out_tab OUT NOCOPY freight_out_tab_type,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2
140 );
141
142 --Harmonizing Project : heali
143
144 END WSH_FREIGHT_COSTS_GRP;