[Home] [Help]
PACKAGE: APPS.GMD_SUBSTITUTION_PVT
Source
1 PACKAGE GMD_SUBSTITUTION_PVT AUTHID CURRENT_USER 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;