PACKAGE: APPS.GMD_SUBSTITUTION_PVT

Source

1 PACKAGE GMD_SUBSTITUTION_PVT AS
2 /* $Header: GMDVSUBS.pls 120.0.12000000.1 2007/01/31 16:17:05 appldev noship $ */
3 
4   m_api_version   CONSTANT NUMBER         := 1;
5   m_pkg_name      CONSTANT VARCHAR2 (30)  := 'GMD_SUBSTITUTION_PVT';
6 
7   -- Creation of substitution header
8   PROCEDURE Create_substitution_header
9   ( p_substitution_id      IN  gmd_item_substitution_hdr.substitution_id%TYPE
10   , p_substitution_hdr_rec IN  gmd_substitution_pub.gmd_substitution_hdr_rec_type
11   , x_message_count        OUT NOCOPY  NUMBER
12   , x_message_list         OUT NOCOPY  VARCHAR2
13   , x_return_status        OUT NOCOPY  VARCHAR2
14   );
15 
16   -- Creation of substitution detail
17   PROCEDURE Create_substitution_detail
18   ( p_substitution_line_id IN  gmd_item_substitution_dtl.substitution_line_id%TYPE
19   , p_substitution_id      IN  gmd_item_substitution_dtl.substitution_id%TYPE
20   , p_substitution_dtl_rec IN  gmd_substitution_pub.gmd_substitution_dtl_rec_type
21   , x_message_count        OUT NOCOPY  NUMBER
22   , x_message_list         OUT NOCOPY  VARCHAR2
23   , x_return_status        OUT NOCOPY  VARCHAR2
24   );
25 
26   -- Creation of formula association
27   PROCEDURE Create_formula_association
28   ( p_substitution_id           IN  gmd_formula_substitution.substitution_id%TYPE
29   , p_formula_substitution_tbl  IN  gmd_substitution_pub.gmd_formula_substitution_tab
30   , x_message_count             OUT NOCOPY  NUMBER
31   , x_message_list              OUT NOCOPY  VARCHAR2
32   , x_return_status             OUT NOCOPY  VARCHAR2
33   );
34 
35   -- Update of substitution header
36   PROCEDURE Update_substitution_header
37   ( p_substitution_hdr_rec IN          gmd_item_substitution_hdr%ROWTYPE
38   , x_message_count        OUT NOCOPY  NUMBER
39   , x_message_list         OUT NOCOPY  VARCHAR2
40   , x_return_status        OUT NOCOPY  VARCHAR2
41   );
42 
43   -- Update of substitution lines
44   PROCEDURE Update_substitution_detail
45   ( p_substitution_dtl_rec  IN          gmd_item_substitution_dtl%ROWTYPE
46   , x_message_count         OUT NOCOPY  NUMBER
47   , x_message_list          OUT NOCOPY  VARCHAR2
48   , x_return_status         OUT NOCOPY  VARCHAR2
49   );
50 
51   -- Deletion of formula association
52   PROCEDURE Delete_formula_association
53   ( p_formula_substitution_id  IN          NUMBER
54   , x_message_count            OUT NOCOPY  NUMBER
55   , x_message_list             OUT NOCOPY  VARCHAR2
56   , x_return_status            OUT NOCOPY  VARCHAR2
57   );
58 
59   -- Deletion of formula association
60   PROCEDURE Copy_substitution
61   ( p_old_substitution_id      IN          NUMBER
62   , x_new_substitution_version OUT NOCOPY  NUMBER
63   , x_message_count            OUT NOCOPY  NUMBER
64   , x_message_list             OUT NOCOPY  VARCHAR2
65   , x_return_status            OUT NOCOPY  VARCHAR2
66   );
67 
68 END GMD_SUBSTITUTION_PVT;