APPS.CSD_LOGISTICS_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 5

    * creation/update  of repair logistics lines for a repair order.
    * @rep:scope public
    * @rep:product CSD
    * @rep:displayname  Repair Logistics
    * @rep:lifecycle active
    * @rep:category BUSINESS_ENTITY REPAIR_LOGISTICS
    */
-- Start of Comments
-- Package name     : CSD_LOGISTICS_PUB
-- Purpose          :
-- History          :
-- NOTE             :
-- End of Comments

G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSD_LOGISTICS_PUB';

Line: 124

    * Updates a given Logistics line. It is interfaced/booked based on the input flags.
    * @param P_Api_Version api version number
    * @param P_Commit to decide whether to commit the transaction or not, default to false
    * @param P_Init_Msg_List initial the message stack, default to false
    * @param X_Return_Status return status
    * @param X_Msg_Count return message count
    * @param X_Msg_Data return message data
    * @param p_Upd_ProdTxn_Rec This contains the fields to be updated in the logistics line.
    * @param X_object_version_number Updated Object version number of the logistics line.
    * @param X_order_header_id If he logistics line is interfaced, this indicates the order  header id created.
    * @param X_order_line_id If the logistics line is interfaced, this indicates the order line id created..
    * @rep:scope public
    * @rep:lifecycle active
    * @rep:displayname Update Repair Logistics Line.
    */
	procedure Update_Logistics_Line(p_api_version            IN NUMBER,
                                    p_commit                 IN VARCHAR2,
                                    p_init_msg_list          IN VARCHAR2,
                                    x_return_status          OUT NOCOPY VARCHAR2,
                                    x_msg_count              OUT NOCOPY NUMBER,
                                    x_msg_data               OUT NOCOPY VARCHAR2,
                                    p_Upd_ProdTxn_Rec        IN CSD_LOGISTICS_PUB.Upd_ProdTxn_Rec_Type,
								    x_object_version_number  OUT NOCOPY NUMBER,
								    x_order_header_id        OUT NOCOPY NUMBER,
								    x_order_line_id          OUT NOCOPY NUMBER ) IS
	    --
	    l_api_name           CONSTANT VARCHAR2(30) := 'Update_Logistics_Line';

Line: 156

	    SAVEPOINT UPDATE_LOGISTICS_LINE_PUB;

Line: 175

	    CSD_LOGISTICS_PVT.Update_Logistics_Line(P_Api_Version           => p_api_version,
	                                     P_Commit                => p_commit,
	                                     P_Init_Msg_List         => p_init_msg_list,
	                                     P_Validation_Level      => FND_API.G_VALID_LEVEL_FULL,
	                                     X_Return_Status         => x_return_status,
	                                     X_Msg_Count             => x_msg_count,
	                                     X_Msg_Data              => x_msg_data,
	                                     P_UPD_PRODTXN_REC       => p_Upd_ProdTxn_Rec,
	                                     X_OBJECT_VERSION_NUMBER => x_object_Version_number,
										 X_ORDER_HEADER_ID       => x_order_header_id,
										 X_ORDER_LINE_ID         => x_order_line_id);

Line: 190

	        ROLLBACK TO UPDATE_LOGISTICS_LINE_PUB;

Line: 208

	        ROLLBACK TO UPDATE_LOGISTICS_LINE_PUB;

Line: 214

	                           'csd.plsql.csd_logistics_pub.update_logistics_pub',
	                           'EXC_ERROR[' || x_msg_data || ']');

Line: 220

	        ROLLBACK TO UPDATE_LOGISTICS_LINE_PUB;

Line: 226

	                           'csd.plsql.csd_logistics_pub.update_logistics_pub',
	                           'EXC_UNEXP_ERROR[' || x_msg_data || ']');

Line: 231

	        Rollback TO UPDATE_LOGISTICS_LINE_PUB;

Line: 241

	                           'csd.plsql.csd_logistics_pub.update_logistics_pub',
	                           'SQL MEssage[' || SQLERRM || ']');

Line: 245

	End UPDATE_LOGISTICS_LINE;