DBA Data[Home] [Help]

PACKAGE: APPS.CSD_LOGISTICS_PVT

Source


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;