1 PACKAGE CSD_LOGISTICS_PUB AUTHID CURRENT_USER as
2 /* $Header: csdplogs.pls 120.9.12000000.1 2007/01/19 18:18:10 appldev ship $ */
3 /*#
4 * This is the public interface for managing repair logistics . It allows
5 * creation/update of repair logistics lines for a repair order.
6 * @rep:scope public
7 * @rep:product CSD
8 * @rep:displayname Repair Logistics
9 * @rep:lifecycle active
10 * @rep:category BUSINESS_ENTITY CSD_REPAIR_LOGISTICS
11 */
12
13
14 Type Upd_Prodtxn_Rec_Type IS Record
15 ( Product_Transaction_ID NUMBER,
16 Action_Type VARCHAR2(30),
17 Action_Code VARCHAR2(30),
18 Inventory_Item_Id NUMBER,
19 Txn_Billing_Type_Id NUMBER,
20 Price_List_ID NUMBER,
21 Quantity NUMBER,
22 Revision VARCHAR2(10),
23 source_Serial_Number VARCHAR2(50),
24 source_Instance_Id NUMBER,
25 non_source_Serial_Number VARCHAR2(50),
26 non_source_Instance_Id NUMBER,
27 Lot_Number VARCHAR2(80),
28 Sub_Inventory VARCHAR2(30),
29 Return_Reason VARCHAR2(30),
30 Return_By_Date DATE,
31 PO_Number VARCHAR2(50),
32 Invoice_To_Org_Id NUMBER,
33 Ship_To_Org_Id NUMBER,
34 Unit_Of_Measure_Code VARCHAR2(3),
35 Charge NUMBER,
36 Interface_To_OM_Flag VARCHAR2(1),
37 Book_Sales_Order_Flag VARCHAR2(1),
38 No_Charge_Flag VARCHAR2(1),
39 New_Order_Flag VARCHAR2(1),
40 Object_Version_Number NUMBER ,
41 Prod_Txn_Status VARCHAR2(30),
42 Context VARCHAR2(30),
43 Attribute1 VARCHAR2(150),
44 Attribute2 VARCHAR2(150),
45 Attribute3 VARCHAR2(150),
46 Attribute4 VARCHAR2(150),
47 Attribute5 VARCHAR2(150),
48 Attribute6 VARCHAR2(150),
49 Attribute7 VARCHAR2(150),
50 Attribute8 VARCHAR2(150),
51 Attribute9 VARCHAR2(150),
52 Attribute10 VARCHAR2(150),
53 Attribute11 VARCHAR2(150),
54 Attribute12 VARCHAR2(150),
55 Attribute13 VARCHAR2(150),
56 Attribute14 VARCHAR2(150),
57 Attribute15 VARCHAR2(150)
58 ) ;
59
60
61
62
63
64 -- Start of Comments
65 -- Package name : CSD_LOGISTICS_PUB
66 -- Purpose :
67 -- History :
68 -- NOTE :
69 -- End of Comments
70
71 /*#
72 * Creates a new Repair Logistics line for the given Repair order. The Product Pransaction Id
73 * Id is generated if a unique number is not passed. Returns the Product Pransaction Id.
74 * Product transaction is a technical term for logistics line.
75 * @param P_Api_Version api version number
76 * @param P_Commit to decide whether to commit the transaction or not, default to false
77 * @param P_Init_Msg_List initial the message stack, default to false
78 * @param X_Return_Status return status
79 * @param X_Msg_Count return message count
80 * @param X_Msg_Data return message data
81 * @param p_product_txn_rec Logistics line record.
82 * @rep:scope public
83 * @rep:lifecycle active
84 * @rep:displayname Create Logistics Line
85 */
86 /*
87 X_product_transaction_id Generated key for the logistics line.
88 X_order_header_id If he logistics line is interfaced, this indicates the order header id created.
89 X_order_line_id If the logistics line is interfaced, this indicates the order line id created..
90 */
91 PROCEDURE Create_Logistics_Line(
92 p_api_version IN NUMBER,
93 p_commit IN VARCHAR2 := fnd_api.g_false,
94 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
95 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2,
99 p_product_txn_rec IN OUT NOCOPY csd_process_pvt.product_txn_rec,
100 p_add_to_order_flag IN VARCHAR2
101 );
102
103 /*#
104 * Creates default logistics lines for the repair order based on repair type.
105 * @param P_Api_Version api version number
106 * @param P_Commit to decide whether to commit the transaction or not, default to false
107 * @param P_Init_Msg_List initial the message stack, default to false
108 * @param X_Return_Status return status
109 * @param X_Msg_Count return message count
110 * @param X_Msg_Data return message data
111 * @param p_repair_line_id repair line for which the default logistics lines are to be created.
112 * @rep:scope public
113 * @rep:lifecycle active
114 * @rep:displayname Create Default Logitics Lines.
115 */
116
117 PROCEDURE Create_Default_Logistics
118 ( p_api_version IN NUMBER,
119 p_commit IN VARCHAR2 := fnd_api.g_false,
120 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
121 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
122 p_repair_line_id IN NUMBER,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER,
125 x_msg_data OUT NOCOPY VARCHAR2
126 );
127
128 /********************** ************* ****************************************/
129 /*---------------------------------------------------------------------------*/
130 /* procedure name: Update_Logistics_Line */
131 /* description */
132 /* : This is the public API, whose main functionality is to update product*/
133 /* transaction line, interface with OM and progress product trxn line */
134 /* status through BOOKED status. Once all validations are done it will */
135 /* call private API Update_logistics_linbe which will continue to do some */
139 /* Parameters */
136 /* more validations before actually perfoming user intended action. */
137 /* Note: */
138 /* */
140 /* p_api_version IN Standard API paramater */
141 /* p_commit IN Standard API paramater */
142 /* x_return_status OUT Standard API paramater */
143 /* x_msg_count OUT Standard API paramater */
144 /* x_msg_data OUT Standard API paramater */
145 /* p_Upd_ProdTxn_Rec IN user input values are stored in this record */
146 /*---------------------------------------------------------------------------*/
147 /*#
148 * Updates a given Logistics line. It is interfaced/booked based on the input flags.
149 * @param P_Api_Version api version number
150 * @param P_Commit to decide whether to commit the transaction or not, default to false
151 * @param P_Init_Msg_List initial the message stack, default to false
152 * @param X_Return_Status return status
153 * @param X_Msg_Count return message count
154 * @param X_Msg_Data return message data
155 * @param p_Upd_ProdTxn_Rec This contains the fields to be updated in the logistics line.
156 * @param X_object_version_number Updated Object version number of the logistics line.
157 * @param X_order_header_id If he logistics line is interfaced, this indicates the order header id created.
158 * @param X_order_line_id If the logistics line is interfaced, this indicates the order line id created.
159 * @rep:scope public
160 * @rep:lifecycle active
161 * @rep:displayname Update Repair Logistics Line.
162 */
163 procedure Update_Logistics_Line(p_api_version IN NUMBER,
164 p_commit IN VARCHAR2,
165 p_init_msg_list IN VARCHAR2,
166 x_return_status OUT NOCOPY VARCHAR2,
167 x_msg_count OUT NOCOPY NUMBER,
168 x_msg_data OUT NOCOPY VARCHAR2,
169 p_Upd_ProdTxn_Rec IN CSD_LOGISTICS_PUB.Upd_ProdTxn_Rec_Type,
170 x_object_version_number OUT NOCOPY NUMBER,
171 x_order_header_id OUT NOCOPY NUMBER,
172 x_order_line_id OUT NOCOPY NUMBER );
173
174
175
176 End CSD_LOGISTICS_PUB;