1 PACKAGE CSD_LOGISTICS_PVT AUTHID CURRENT_USER as
2 /* $Header: csdvlogs.pls 120.4 2005/09/29 17:18:44 takwong noship $ */
3 -- Start of Comments
4 -- Package name : CSD_LOGISTICS_PVT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 PROCEDURE Create_Logistics_Line(
11 p_api_version IN NUMBER,
12 p_commit IN VARCHAR2 := fnd_api.g_false,
13 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
14 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
15 x_return_status OUT NOCOPY VARCHAR2,
16 x_msg_count OUT NOCOPY NUMBER,
17 x_msg_data OUT NOCOPY VARCHAR2,
18 p_product_txn_rec IN OUT NOCOPY csd_process_pvt.product_txn_rec,
19 p_add_to_order_flag IN VARCHAR2
20 );
21
22
23 PROCEDURE Create_Default_Logistics
24 ( p_api_version IN NUMBER,
25 p_commit IN VARCHAR2 := fnd_api.g_false,
26 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
27 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
28 p_repair_line_id IN NUMBER,
29 x_return_status OUT NOCOPY VARCHAR2,
30 x_msg_count OUT NOCOPY NUMBER,
31 x_msg_data OUT NOCOPY VARCHAR2
32 );
33
34 /********************** ************* ****************************************/
35 /*---------------------------------------------------------------------------*/
36 /* procedure name: UUpdate_Logistics_Line */
37 /* description */
38 /* : This is a private API, whose main functionality is to update product*/
39 /* transaction line, interface with OM and progress product trxn line */
40 /* status through BOOKED status. Once all validations are done it will */
41 /* private API Update_PRoduct_Txn which will continue to do some more */
42 /* more validations before actually perfoming user intended action. */
43 /* Note: */
44 /* Contract_Line_Id from CSD_Product_Txns_v is assigned to contract_id */
45 /* in l_Product_Txn_Rec */
46 /* Parameters */
47 /* p_api_version IN Standard API paramater */
48 /* p_commit IN Standard API paramater */
49 /* p_init_msg_list IN Standard API paramater */
50 /* x_return_status OUT Standard API paramater */
51 /* x_msg_count OUT Standard API paramater */
52 /* x_msg_data OUT Standard API paramater */
53 /* p_Upd_ProductTxn_Rec IN user input values are stored in this record */
54 /*---------------------------------------------------------------------------*/
55 procedure Update_Logistics_Line(p_api_version IN NUMBER,
56 p_commit IN VARCHAR2,
57 p_init_msg_list IN VARCHAR2,
58 p_validation_level IN NUMBER,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_msg_count OUT NOCOPY NUMBER,
61 x_msg_data OUT NOCOPY VARCHAR2,
62 p_Upd_ProdTxn_Rec IN CSD_LOGISTICS_PUB.Upd_ProdTxn_Rec_Type,
63 x_object_version_number OUT NOCOPY NUMBER,
64 x_order_header_id OUT NOCOPY NUMBER,
65 x_order_line_id OUT NOCOPY NUMBER );
66
67
68 /*----------------------------------------------------------------*/
69 /* procedure name: update_product_txn */
70 /* description : procedure to update product txn lines.It is */
71 /* called from update_logistics_line API */
72 /* This is different from the process_pvt api */
73 /* in the sense that this does not commit if */
74 /* something fails (booking or release). */
75 /*----------------------------------------------------------------*/
76
77 PROCEDURE update_product_txn(p_api_version IN NUMBER,
78 p_commit IN VARCHAR2,
79 p_init_msg_list IN VARCHAR2,
80 p_validation_level IN NUMBER,
81 x_product_txn_rec IN OUT NOCOPY CSD_PROCESS_PVT.PRODUCT_TXN_REC,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2);
85
86
87
88 End CSD_LOGISTICS_PVT;