DBA Data[Home] [Help]

PACKAGE: APPS.CZ_IB_LOCKING

Source


1 PACKAGE CZ_IB_LOCKING AS
2 /*	$Header: cziblcks.pls 120.0 2005/05/24 19:16:32 appldev noship $*/
3 
4 ------------------------------------------------------------------------------------------
5 
6 m_msg_count                   NUMBER;
7 m_msg_data                    VARCHAR2(2000);
8 m_return_status               VARCHAR2(255);
9 
10 --------------------------------------------------------------------------------------
11 -- API name    :  lock_Config
12 -- Package Name:  CZ_IB_LOCKING
13 -- Type        :  Public
14 -- Pre-reqs    :  None
15 -- Function    :  Lock configuration specified by
16 --                p_config_session_hdr_id, p_config_session_rev_nbr (,p_config_session_item_id)
17 -- Version     :  Current version 1.0
18 --                Initial version 1.0
19 --
20 -- Note        : this procedure calls procedure CSI_CZ_INT.lock_item_instance()
21 -- for each instance with configuration specified by parameters
22 -- p_config_session_hdr_id, p_config_session_rev_nbr and p_config_session_item_id
23 -- others parameters are passed to CSI_CZ_INT.lock_item_instance() directly
24 --
25 PROCEDURE lock_Config
26 (
27   p_api_version            IN  NUMBER,
28   p_config_session_hdr_id  IN  NUMBER,
29   p_config_session_rev_nbr IN  NUMBER,
30   p_config_session_item_id IN  NUMBER,
31   p_source_application_id  IN  NUMBER,
32   p_source_header_ref      IN  VARCHAR2,
33   p_source_line_ref1       IN  VARCHAR2,
34   p_source_line_ref2       IN  VARCHAR2,
35   p_source_line_ref3       IN  VARCHAR2,
36   p_commit                 IN  VARCHAR2,
37   p_init_msg_list          IN  VARCHAR2,
38   p_validation_level       IN  NUMBER,
39   x_locking_key            OUT NOCOPY NUMBER,
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 -- API name    :  unlock_Config
47 -- Package Name:  CZ_IB_LOCKING
48 -- Type        :  Public
49 -- Pre-reqs    :  None
50 -- Function    :  Unlock configuration specified by
51 --                p_config_session_hdr_id, p_config_session_rev_nbr (,p_config_session_item_id)
52 -- Version     :  Current version 1.0
53 --                Initial version 1.0
54 --
55 -- Note        : this procedure calls procedure CSI_CZ_INT.unlock_item_instance()
56 -- for each instance with configuration specified by parameters
57 -- p_config_session_hdr_id, p_config_session_rev_nbr and p_config_session_item_id
58 -- others parameters are passed to CSI_CZ_INT.unlock_item_instance() directly
59 --
60 PROCEDURE unlock_Config
61   (
62   p_api_version            IN  NUMBER,
63   p_config_session_hdr_id  IN  NUMBER,
64   p_config_session_rev_nbr IN  NUMBER,
65   p_config_session_item_id IN  NUMBER,
66   p_locking_key            IN  NUMBER,
67   p_source_application_id  IN  NUMBER,
68   p_source_header_ref      IN  VARCHAR2,
69   p_source_line_ref1       IN  VARCHAR2,
70   p_source_line_ref2       IN  VARCHAR2,
71   p_source_line_ref3       IN  VARCHAR2,
72   p_commit                 IN  VARCHAR2,
73   p_init_msg_list          IN  VARCHAR2,
74   p_validation_level       IN  NUMBER,
75   x_return_status          OUT NOCOPY VARCHAR2,
76   x_msg_count              OUT NOCOPY NUMBER,
77   x_msg_data               OUT NOCOPY VARCHAR2
78   );
79 
80 END;