DBA Data[Home] [Help]

PACKAGE: APPS.CSI_PRICING_ATTRIBS_PUB

Source


1 PACKAGE csi_pricing_attribs_pub AUTHID CURRENT_USER AS
2 /* $Header: csippas.pls 115.20 2003/09/04 00:57:38 sguthiva ship $ */
3 
4 /*------------------------------------------------------*/
5 /* procedure name: get_pricing_attribs                  */
6 /* description :   Gets the pricing attributes of an    */
7 /*                 item instance                        */
8 /*                                                      */
9 /*------------------------------------------------------*/
10 
11 PROCEDURE get_pricing_attribs
12  (    p_api_version               IN      NUMBER
13      ,p_commit                    IN      VARCHAR2 := fnd_api.g_false
14      ,p_init_msg_list             IN      VARCHAR2 := fnd_api.g_false
15      ,p_validation_level          IN      NUMBER   := fnd_api.g_valid_level_full
16      ,p_pricing_attribs_query_rec IN      csi_datastructures_pub.pricing_attribs_query_rec
17      ,p_time_stamp                IN      DATE
18      ,x_pricing_attribs_tbl           OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
19      ,x_return_status                 OUT NOCOPY VARCHAR2
20      ,x_msg_count                     OUT NOCOPY NUMBER
21      ,x_msg_data                      OUT NOCOPY VARCHAR2
22  );
23 
24 
25 
26 /*------------------------------------------------------*/
27 /* procedure name: create_pricing_attribs               */
28 /* description :  Associates pricing attributes to an   */
29 /*                item instance                         */
30 /*                                                      */
31 /*------------------------------------------------------*/
32 
33 PROCEDURE create_pricing_attribs
34  (    p_api_version         IN     NUMBER
35      ,p_commit              IN     VARCHAR2 := fnd_api.g_false
36      ,p_init_msg_list       IN     VARCHAR2 := fnd_api.g_false
37      ,p_validation_level    IN     NUMBER   := fnd_api.g_valid_level_full
38      ,p_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
39      ,p_txn_rec             IN OUT NOCOPY csi_datastructures_pub.transaction_rec
40      ,x_return_status          OUT NOCOPY VARCHAR2
41      ,x_msg_count              OUT NOCOPY NUMBER
42      ,x_msg_data               OUT NOCOPY VARCHAR2
43  );
44 
45 
46 
47 
48 /*------------------------------------------------------*/
49 /* procedure name: update_pricing_attribs               */
50 /* description :  Updates the existing pricing          */
51 /*                attributes for an item instance       */
52 /*                                                      */
53 /*------------------------------------------------------*/
54 
55 PROCEDURE update_pricing_attribs
56  (    p_api_version             IN     NUMBER
57      ,p_commit                  IN     VARCHAR2 := fnd_api.g_false
58      ,p_init_msg_list           IN     VARCHAR2 := fnd_api.g_false
59      ,p_validation_level        IN     NUMBER   := fnd_api.g_valid_level_full
60      ,p_pricing_attribs_tbl     IN     csi_datastructures_pub.pricing_attribs_tbl
61      ,p_txn_rec                 IN OUT NOCOPY csi_datastructures_pub.transaction_rec
62      ,x_return_status              OUT NOCOPY VARCHAR2
63      ,x_msg_count                  OUT NOCOPY NUMBER
64      ,x_msg_data                   OUT NOCOPY VARCHAR2
65  );
66 
67 
68 
69 
70 
71 /*------------------------------------------------------*/
72 /* procedure name: expire_pricing_attribs               */
73 /* description :  Expires the existing pricing          */
74 /*                attributes for an item instance       */
75 /*                                                      */
76 /*------------------------------------------------------*/
77 
78 PROCEDURE expire_pricing_attribs
79  (    p_api_version                 IN     NUMBER
80      ,p_commit                      IN     VARCHAR2 := fnd_api.g_false
81      ,p_init_msg_list               IN     VARCHAR2 := fnd_api.g_false
82      ,p_validation_level            IN     NUMBER   := fnd_api.g_valid_level_full
83      ,p_pricing_attribs_tbl         IN     csi_datastructures_pub.pricing_attribs_tbl
84      ,p_txn_rec                     IN OUT NOCOPY csi_datastructures_pub.transaction_rec
85      ,x_return_status                  OUT NOCOPY VARCHAR2
86      ,x_msg_count                      OUT NOCOPY NUMBER
87      ,x_msg_data                       OUT NOCOPY VARCHAR2
88  );
89 
90 
91 
92 
93 
94 END csi_pricing_attribs_pub;