1: PACKAGE csi_cz_int AUTHID CURRENT_USER AS
2: /* $Header: csigczis.pls 120.1 2005/10/25 17:58:21 srramakr noship $ */
3:
4: TYPE config_query_record IS RECORD(
5: config_header_id number := fnd_api.g_miss_num,
6: config_revision_number number := fnd_api.g_miss_num);
7:
8: TYPE config_query_table IS TABLE OF config_query_record INDEX BY BINARY_INTEGER;
9:
2: /* $Header: csigczis.pls 120.1 2005/10/25 17:58:21 srramakr noship $ */
3:
4: TYPE config_query_record IS RECORD(
5: config_header_id number := fnd_api.g_miss_num,
6: config_revision_number number := fnd_api.g_miss_num);
7:
8: TYPE config_query_table IS TABLE OF config_query_record INDEX BY BINARY_INTEGER;
9:
10: TYPE config_pair_record IS RECORD(
7:
8: TYPE config_query_table IS TABLE OF config_query_record INDEX BY BINARY_INTEGER;
9:
10: TYPE config_pair_record IS RECORD(
11: subject_header_id number := fnd_api.g_miss_num,
12: subject_revision_number number := fnd_api.g_miss_num,
13: subject_item_id number := fnd_api.g_miss_num,
14: object_header_id number := fnd_api.g_miss_num,
15: object_revision_number number := fnd_api.g_miss_num,
8: TYPE config_query_table IS TABLE OF config_query_record INDEX BY BINARY_INTEGER;
9:
10: TYPE config_pair_record IS RECORD(
11: subject_header_id number := fnd_api.g_miss_num,
12: subject_revision_number number := fnd_api.g_miss_num,
13: subject_item_id number := fnd_api.g_miss_num,
14: object_header_id number := fnd_api.g_miss_num,
15: object_revision_number number := fnd_api.g_miss_num,
16: object_item_id number := fnd_api.g_miss_num,
9:
10: TYPE config_pair_record IS RECORD(
11: subject_header_id number := fnd_api.g_miss_num,
12: subject_revision_number number := fnd_api.g_miss_num,
13: subject_item_id number := fnd_api.g_miss_num,
14: object_header_id number := fnd_api.g_miss_num,
15: object_revision_number number := fnd_api.g_miss_num,
16: object_item_id number := fnd_api.g_miss_num,
17: root_header_id number := fnd_api.g_miss_num,
10: TYPE config_pair_record IS RECORD(
11: subject_header_id number := fnd_api.g_miss_num,
12: subject_revision_number number := fnd_api.g_miss_num,
13: subject_item_id number := fnd_api.g_miss_num,
14: object_header_id number := fnd_api.g_miss_num,
15: object_revision_number number := fnd_api.g_miss_num,
16: object_item_id number := fnd_api.g_miss_num,
17: root_header_id number := fnd_api.g_miss_num,
18: root_revision_number number := fnd_api.g_miss_num,
11: subject_header_id number := fnd_api.g_miss_num,
12: subject_revision_number number := fnd_api.g_miss_num,
13: subject_item_id number := fnd_api.g_miss_num,
14: object_header_id number := fnd_api.g_miss_num,
15: object_revision_number number := fnd_api.g_miss_num,
16: object_item_id number := fnd_api.g_miss_num,
17: root_header_id number := fnd_api.g_miss_num,
18: root_revision_number number := fnd_api.g_miss_num,
19: root_item_id number := fnd_api.g_miss_num, -- added the keys for root,bug 3892929
12: subject_revision_number number := fnd_api.g_miss_num,
13: subject_item_id number := fnd_api.g_miss_num,
14: object_header_id number := fnd_api.g_miss_num,
15: object_revision_number number := fnd_api.g_miss_num,
16: object_item_id number := fnd_api.g_miss_num,
17: root_header_id number := fnd_api.g_miss_num,
18: root_revision_number number := fnd_api.g_miss_num,
19: root_item_id number := fnd_api.g_miss_num, -- added the keys for root,bug 3892929
20: -- sub_header_id_locked number := fnd_api.g_miss_num, -- added all the below for MACD locking, bug4147624
13: subject_item_id number := fnd_api.g_miss_num,
14: object_header_id number := fnd_api.g_miss_num,
15: object_revision_number number := fnd_api.g_miss_num,
16: object_item_id number := fnd_api.g_miss_num,
17: root_header_id number := fnd_api.g_miss_num,
18: root_revision_number number := fnd_api.g_miss_num,
19: root_item_id number := fnd_api.g_miss_num, -- added the keys for root,bug 3892929
20: -- sub_header_id_locked number := fnd_api.g_miss_num, -- added all the below for MACD locking, bug4147624
21: -- sub_item_id_locked number := fnd_api.g_miss_num,
14: object_header_id number := fnd_api.g_miss_num,
15: object_revision_number number := fnd_api.g_miss_num,
16: object_item_id number := fnd_api.g_miss_num,
17: root_header_id number := fnd_api.g_miss_num,
18: root_revision_number number := fnd_api.g_miss_num,
19: root_item_id number := fnd_api.g_miss_num, -- added the keys for root,bug 3892929
20: -- sub_header_id_locked number := fnd_api.g_miss_num, -- added all the below for MACD locking, bug4147624
21: -- sub_item_id_locked number := fnd_api.g_miss_num,
22: -- sub_rev_num_locked number := fnd_api.g_miss_num,
15: object_revision_number number := fnd_api.g_miss_num,
16: object_item_id number := fnd_api.g_miss_num,
17: root_header_id number := fnd_api.g_miss_num,
18: root_revision_number number := fnd_api.g_miss_num,
19: root_item_id number := fnd_api.g_miss_num, -- added the keys for root,bug 3892929
20: -- sub_header_id_locked number := fnd_api.g_miss_num, -- added all the below for MACD locking, bug4147624
21: -- sub_item_id_locked number := fnd_api.g_miss_num,
22: -- sub_rev_num_locked number := fnd_api.g_miss_num,
23: -- obj_header_id_locked number := fnd_api.g_miss_num,
16: object_item_id number := fnd_api.g_miss_num,
17: root_header_id number := fnd_api.g_miss_num,
18: root_revision_number number := fnd_api.g_miss_num,
19: root_item_id number := fnd_api.g_miss_num, -- added the keys for root,bug 3892929
20: -- sub_header_id_locked number := fnd_api.g_miss_num, -- added all the below for MACD locking, bug4147624
21: -- sub_item_id_locked number := fnd_api.g_miss_num,
22: -- sub_rev_num_locked number := fnd_api.g_miss_num,
23: -- obj_header_id_locked number := fnd_api.g_miss_num,
24: -- obj_item_id_locked number := fnd_api.g_miss_num,
17: root_header_id number := fnd_api.g_miss_num,
18: root_revision_number number := fnd_api.g_miss_num,
19: root_item_id number := fnd_api.g_miss_num, -- added the keys for root,bug 3892929
20: -- sub_header_id_locked number := fnd_api.g_miss_num, -- added all the below for MACD locking, bug4147624
21: -- sub_item_id_locked number := fnd_api.g_miss_num,
22: -- sub_rev_num_locked number := fnd_api.g_miss_num,
23: -- obj_header_id_locked number := fnd_api.g_miss_num,
24: -- obj_item_id_locked number := fnd_api.g_miss_num,
25: -- obj_rev_num_locked number := fnd_api.g_miss_num,
18: root_revision_number number := fnd_api.g_miss_num,
19: root_item_id number := fnd_api.g_miss_num, -- added the keys for root,bug 3892929
20: -- sub_header_id_locked number := fnd_api.g_miss_num, -- added all the below for MACD locking, bug4147624
21: -- sub_item_id_locked number := fnd_api.g_miss_num,
22: -- sub_rev_num_locked number := fnd_api.g_miss_num,
23: -- obj_header_id_locked number := fnd_api.g_miss_num,
24: -- obj_item_id_locked number := fnd_api.g_miss_num,
25: -- obj_rev_num_locked number := fnd_api.g_miss_num,
26: source_application_id number := fnd_api.g_miss_num,
19: root_item_id number := fnd_api.g_miss_num, -- added the keys for root,bug 3892929
20: -- sub_header_id_locked number := fnd_api.g_miss_num, -- added all the below for MACD locking, bug4147624
21: -- sub_item_id_locked number := fnd_api.g_miss_num,
22: -- sub_rev_num_locked number := fnd_api.g_miss_num,
23: -- obj_header_id_locked number := fnd_api.g_miss_num,
24: -- obj_item_id_locked number := fnd_api.g_miss_num,
25: -- obj_rev_num_locked number := fnd_api.g_miss_num,
26: source_application_id number := fnd_api.g_miss_num,
27: source_txn_header_ref varchar2(30) := fnd_api.g_miss_char,
20: -- sub_header_id_locked number := fnd_api.g_miss_num, -- added all the below for MACD locking, bug4147624
21: -- sub_item_id_locked number := fnd_api.g_miss_num,
22: -- sub_rev_num_locked number := fnd_api.g_miss_num,
23: -- obj_header_id_locked number := fnd_api.g_miss_num,
24: -- obj_item_id_locked number := fnd_api.g_miss_num,
25: -- obj_rev_num_locked number := fnd_api.g_miss_num,
26: source_application_id number := fnd_api.g_miss_num,
27: source_txn_header_ref varchar2(30) := fnd_api.g_miss_char,
28: source_txn_line_ref1 varchar2(30):= fnd_api.g_miss_char,
21: -- sub_item_id_locked number := fnd_api.g_miss_num,
22: -- sub_rev_num_locked number := fnd_api.g_miss_num,
23: -- obj_header_id_locked number := fnd_api.g_miss_num,
24: -- obj_item_id_locked number := fnd_api.g_miss_num,
25: -- obj_rev_num_locked number := fnd_api.g_miss_num,
26: source_application_id number := fnd_api.g_miss_num,
27: source_txn_header_ref varchar2(30) := fnd_api.g_miss_char,
28: source_txn_line_ref1 varchar2(30):= fnd_api.g_miss_char,
29: source_txn_line_ref2 varchar2(30):= fnd_api.g_miss_char,
22: -- sub_rev_num_locked number := fnd_api.g_miss_num,
23: -- obj_header_id_locked number := fnd_api.g_miss_num,
24: -- obj_item_id_locked number := fnd_api.g_miss_num,
25: -- obj_rev_num_locked number := fnd_api.g_miss_num,
26: source_application_id number := fnd_api.g_miss_num,
27: source_txn_header_ref varchar2(30) := fnd_api.g_miss_char,
28: source_txn_line_ref1 varchar2(30):= fnd_api.g_miss_char,
29: source_txn_line_ref2 varchar2(30):= fnd_api.g_miss_char,
30: source_txn_line_ref3 varchar2(30):= fnd_api.g_miss_char,
23: -- obj_header_id_locked number := fnd_api.g_miss_num,
24: -- obj_item_id_locked number := fnd_api.g_miss_num,
25: -- obj_rev_num_locked number := fnd_api.g_miss_num,
26: source_application_id number := fnd_api.g_miss_num,
27: source_txn_header_ref varchar2(30) := fnd_api.g_miss_char,
28: source_txn_line_ref1 varchar2(30):= fnd_api.g_miss_char,
29: source_txn_line_ref2 varchar2(30):= fnd_api.g_miss_char,
30: source_txn_line_ref3 varchar2(30):= fnd_api.g_miss_char,
31: lock_id number := fnd_api.g_miss_num,
24: -- obj_item_id_locked number := fnd_api.g_miss_num,
25: -- obj_rev_num_locked number := fnd_api.g_miss_num,
26: source_application_id number := fnd_api.g_miss_num,
27: source_txn_header_ref varchar2(30) := fnd_api.g_miss_char,
28: source_txn_line_ref1 varchar2(30):= fnd_api.g_miss_char,
29: source_txn_line_ref2 varchar2(30):= fnd_api.g_miss_char,
30: source_txn_line_ref3 varchar2(30):= fnd_api.g_miss_char,
31: lock_id number := fnd_api.g_miss_num,
32: lock_status number := fnd_api.g_miss_num);
25: -- obj_rev_num_locked number := fnd_api.g_miss_num,
26: source_application_id number := fnd_api.g_miss_num,
27: source_txn_header_ref varchar2(30) := fnd_api.g_miss_char,
28: source_txn_line_ref1 varchar2(30):= fnd_api.g_miss_char,
29: source_txn_line_ref2 varchar2(30):= fnd_api.g_miss_char,
30: source_txn_line_ref3 varchar2(30):= fnd_api.g_miss_char,
31: lock_id number := fnd_api.g_miss_num,
32: lock_status number := fnd_api.g_miss_num);
33:
26: source_application_id number := fnd_api.g_miss_num,
27: source_txn_header_ref varchar2(30) := fnd_api.g_miss_char,
28: source_txn_line_ref1 varchar2(30):= fnd_api.g_miss_char,
29: source_txn_line_ref2 varchar2(30):= fnd_api.g_miss_char,
30: source_txn_line_ref3 varchar2(30):= fnd_api.g_miss_char,
31: lock_id number := fnd_api.g_miss_num,
32: lock_status number := fnd_api.g_miss_num);
33:
34: TYPE config_pair_table IS TABLE OF config_pair_record INDEX BY BINARY_INTEGER;
27: source_txn_header_ref varchar2(30) := fnd_api.g_miss_char,
28: source_txn_line_ref1 varchar2(30):= fnd_api.g_miss_char,
29: source_txn_line_ref2 varchar2(30):= fnd_api.g_miss_char,
30: source_txn_line_ref3 varchar2(30):= fnd_api.g_miss_char,
31: lock_id number := fnd_api.g_miss_num,
32: lock_status number := fnd_api.g_miss_num);
33:
34: TYPE config_pair_table IS TABLE OF config_pair_record INDEX BY BINARY_INTEGER;
35:
28: source_txn_line_ref1 varchar2(30):= fnd_api.g_miss_char,
29: source_txn_line_ref2 varchar2(30):= fnd_api.g_miss_char,
30: source_txn_line_ref3 varchar2(30):= fnd_api.g_miss_char,
31: lock_id number := fnd_api.g_miss_num,
32: lock_status number := fnd_api.g_miss_num);
33:
34: TYPE config_pair_table IS TABLE OF config_pair_record INDEX BY BINARY_INTEGER;
35:
36: -- used for outputing in generate_config_trees and add_to_config_tree procedures
45: TYPE config_model_tbl_type IS TABLE OF config_model_rec_type INDEX BY BINARY_INTEGER;
46:
47: -- Added the following rec structure for the Item Instance Locking, Bug 4147624
48: TYPE config_rec IS RECORD(
49: source_application_id number := fnd_api.g_miss_num,
50: source_txn_header_ref varchar2(30) := fnd_api.g_miss_char,
51: source_txn_line_ref1 varchar2(30):= fnd_api.g_miss_char,
52: source_txn_line_ref2 varchar2(30):= fnd_api.g_miss_char,
53: source_txn_line_ref3 varchar2(30):= fnd_api.g_miss_char,
46:
47: -- Added the following rec structure for the Item Instance Locking, Bug 4147624
48: TYPE config_rec IS RECORD(
49: source_application_id number := fnd_api.g_miss_num,
50: source_txn_header_ref varchar2(30) := fnd_api.g_miss_char,
51: source_txn_line_ref1 varchar2(30):= fnd_api.g_miss_char,
52: source_txn_line_ref2 varchar2(30):= fnd_api.g_miss_char,
53: source_txn_line_ref3 varchar2(30):= fnd_api.g_miss_char,
54: instance_id number := fnd_api.g_miss_num,
47: -- Added the following rec structure for the Item Instance Locking, Bug 4147624
48: TYPE config_rec IS RECORD(
49: source_application_id number := fnd_api.g_miss_num,
50: source_txn_header_ref varchar2(30) := fnd_api.g_miss_char,
51: source_txn_line_ref1 varchar2(30):= fnd_api.g_miss_char,
52: source_txn_line_ref2 varchar2(30):= fnd_api.g_miss_char,
53: source_txn_line_ref3 varchar2(30):= fnd_api.g_miss_char,
54: instance_id number := fnd_api.g_miss_num,
55: lock_id number := fnd_api.g_miss_num,
48: TYPE config_rec IS RECORD(
49: source_application_id number := fnd_api.g_miss_num,
50: source_txn_header_ref varchar2(30) := fnd_api.g_miss_char,
51: source_txn_line_ref1 varchar2(30):= fnd_api.g_miss_char,
52: source_txn_line_ref2 varchar2(30):= fnd_api.g_miss_char,
53: source_txn_line_ref3 varchar2(30):= fnd_api.g_miss_char,
54: instance_id number := fnd_api.g_miss_num,
55: lock_id number := fnd_api.g_miss_num,
56: lock_status number := fnd_api.g_miss_num,
49: source_application_id number := fnd_api.g_miss_num,
50: source_txn_header_ref varchar2(30) := fnd_api.g_miss_char,
51: source_txn_line_ref1 varchar2(30):= fnd_api.g_miss_char,
52: source_txn_line_ref2 varchar2(30):= fnd_api.g_miss_char,
53: source_txn_line_ref3 varchar2(30):= fnd_api.g_miss_char,
54: instance_id number := fnd_api.g_miss_num,
55: lock_id number := fnd_api.g_miss_num,
56: lock_status number := fnd_api.g_miss_num,
57: config_inst_hdr_id number := fnd_api.g_miss_num,
50: source_txn_header_ref varchar2(30) := fnd_api.g_miss_char,
51: source_txn_line_ref1 varchar2(30):= fnd_api.g_miss_char,
52: source_txn_line_ref2 varchar2(30):= fnd_api.g_miss_char,
53: source_txn_line_ref3 varchar2(30):= fnd_api.g_miss_char,
54: instance_id number := fnd_api.g_miss_num,
55: lock_id number := fnd_api.g_miss_num,
56: lock_status number := fnd_api.g_miss_num,
57: config_inst_hdr_id number := fnd_api.g_miss_num,
58: config_inst_item_id number := fnd_api.g_miss_num,
51: source_txn_line_ref1 varchar2(30):= fnd_api.g_miss_char,
52: source_txn_line_ref2 varchar2(30):= fnd_api.g_miss_char,
53: source_txn_line_ref3 varchar2(30):= fnd_api.g_miss_char,
54: instance_id number := fnd_api.g_miss_num,
55: lock_id number := fnd_api.g_miss_num,
56: lock_status number := fnd_api.g_miss_num,
57: config_inst_hdr_id number := fnd_api.g_miss_num,
58: config_inst_item_id number := fnd_api.g_miss_num,
59: config_inst_rev_num number := fnd_api.g_miss_num);
52: source_txn_line_ref2 varchar2(30):= fnd_api.g_miss_char,
53: source_txn_line_ref3 varchar2(30):= fnd_api.g_miss_char,
54: instance_id number := fnd_api.g_miss_num,
55: lock_id number := fnd_api.g_miss_num,
56: lock_status number := fnd_api.g_miss_num,
57: config_inst_hdr_id number := fnd_api.g_miss_num,
58: config_inst_item_id number := fnd_api.g_miss_num,
59: config_inst_rev_num number := fnd_api.g_miss_num);
60:
53: source_txn_line_ref3 varchar2(30):= fnd_api.g_miss_char,
54: instance_id number := fnd_api.g_miss_num,
55: lock_id number := fnd_api.g_miss_num,
56: lock_status number := fnd_api.g_miss_num,
57: config_inst_hdr_id number := fnd_api.g_miss_num,
58: config_inst_item_id number := fnd_api.g_miss_num,
59: config_inst_rev_num number := fnd_api.g_miss_num);
60:
61: TYPE config_tbl IS TABLE OF config_rec INDEX BY BINARY_INTEGER;
54: instance_id number := fnd_api.g_miss_num,
55: lock_id number := fnd_api.g_miss_num,
56: lock_status number := fnd_api.g_miss_num,
57: config_inst_hdr_id number := fnd_api.g_miss_num,
58: config_inst_item_id number := fnd_api.g_miss_num,
59: config_inst_rev_num number := fnd_api.g_miss_num);
60:
61: TYPE config_tbl IS TABLE OF config_rec INDEX BY BINARY_INTEGER;
62:
55: lock_id number := fnd_api.g_miss_num,
56: lock_status number := fnd_api.g_miss_num,
57: config_inst_hdr_id number := fnd_api.g_miss_num,
58: config_inst_item_id number := fnd_api.g_miss_num,
59: config_inst_rev_num number := fnd_api.g_miss_num);
60:
61: TYPE config_tbl IS TABLE OF config_rec INDEX BY BINARY_INTEGER;
62:
63: PROCEDURE get_configuration_revision(
97: -- Initial version 1.0
98:
99: Procedure CSI_CONFIG_LAUNCH_PRMS
100: ( p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
102: p_commit IN VARCHAR2 := FND_API.g_false,
103: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
98:
99: Procedure CSI_CONFIG_LAUNCH_PRMS
100: ( p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
102: p_commit IN VARCHAR2 := FND_API.g_false,
103: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2,
99: Procedure CSI_CONFIG_LAUNCH_PRMS
100: ( p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
102: p_commit IN VARCHAR2 := FND_API.g_false,
103: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2,
107: x_configurable OUT NOCOPY VARCHAR2,
125: -- IN: p_config_hdr_id (required), config_hdr_id of an instance
126: -- p_config_hdr_id (required), config_hdr_id of an instance
127: -- p_config_rev_nbr (required), config_rev_nbr of an instance
128: -- p_config_item_id (required), config_item_id of an instance item
129: -- OUT: x_return_value, has one of the following values FND_API.G_TRUE,
130: -- FND_API.G_FALSE,NULL
131: -- x_return_status, standard out parameter (see generate_config_trees)
132: -- x_msg_count, standard out parameter
133: -- x_msg_data, standard out parameter
126: -- p_config_hdr_id (required), config_hdr_id of an instance
127: -- p_config_rev_nbr (required), config_rev_nbr of an instance
128: -- p_config_item_id (required), config_item_id of an instance item
129: -- OUT: x_return_value, has one of the following values FND_API.G_TRUE,
130: -- FND_API.G_FALSE,NULL
131: -- x_return_status, standard out parameter (see generate_config_trees)
132: -- x_msg_count, standard out parameter
133: -- x_msg_data, standard out parameter
134:
171:
172: -- Added the following new API's for the Item Instance Locking, Bug 4147624
173:
174: Function check_item_instance_lock (
175: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
176: p_config_rec IN config_rec,
177: x_return_status OUT NOCOPY VARCHAR2,
178: x_msg_count OUT NOCOPY NUMBER,
179: x_msg_data OUT NOCOPY VARCHAR2)
180: RETURN BOOLEAN;
181:
182: PROCEDURE lock_item_instances(
183: p_api_version IN NUMBER,
184: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
185: p_commit IN VARCHAR2 := FND_API.g_false,
186: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
187: px_config_tbl IN OUT NOCOPY config_tbl,
188: x_return_status OUT NOCOPY varchar2,
181:
182: PROCEDURE lock_item_instances(
183: p_api_version IN NUMBER,
184: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
185: p_commit IN VARCHAR2 := FND_API.g_false,
186: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
187: px_config_tbl IN OUT NOCOPY config_tbl,
188: x_return_status OUT NOCOPY varchar2,
189: x_msg_count OUT NOCOPY NUMBER,
182: PROCEDURE lock_item_instances(
183: p_api_version IN NUMBER,
184: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
185: p_commit IN VARCHAR2 := FND_API.g_false,
186: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
187: px_config_tbl IN OUT NOCOPY config_tbl,
188: x_return_status OUT NOCOPY varchar2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2 );
190: x_msg_data OUT NOCOPY VARCHAR2 );
191:
192: PROCEDURE Unlock_Current_Node(
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
195: p_commit IN VARCHAR2 := FND_API.g_false,
196: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
197: p_config_rec IN config_rec,
198: x_conn_config_tbl OUT NOCOPY config_tbl,
191:
192: PROCEDURE Unlock_Current_Node(
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
195: p_commit IN VARCHAR2 := FND_API.g_false,
196: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
197: p_config_rec IN config_rec,
198: x_conn_config_tbl OUT NOCOPY config_tbl,
199: x_return_status OUT NOCOPY varchar2,
192: PROCEDURE Unlock_Current_Node(
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
195: p_commit IN VARCHAR2 := FND_API.g_false,
196: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
197: p_config_rec IN config_rec,
198: x_conn_config_tbl OUT NOCOPY config_tbl,
199: x_return_status OUT NOCOPY varchar2,
200: x_msg_count OUT NOCOPY NUMBER,
201: x_msg_data OUT NOCOPY VARCHAR2 );
202:
203: PROCEDURE unlock_item_instances(
204: p_api_version IN NUMBER,
205: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
206: p_commit IN VARCHAR2 := FND_API.g_false,
207: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
208: p_config_tbl IN config_tbl,
209: x_return_status OUT NOCOPY varchar2,
202:
203: PROCEDURE unlock_item_instances(
204: p_api_version IN NUMBER,
205: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
206: p_commit IN VARCHAR2 := FND_API.g_false,
207: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
208: p_config_tbl IN config_tbl,
209: x_return_status OUT NOCOPY varchar2,
210: x_msg_count OUT NOCOPY NUMBER,
203: PROCEDURE unlock_item_instances(
204: p_api_version IN NUMBER,
205: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
206: p_commit IN VARCHAR2 := FND_API.g_false,
207: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
208: p_config_tbl IN config_tbl,
209: x_return_status OUT NOCOPY varchar2,
210: x_msg_count OUT NOCOPY NUMBER,
211: x_msg_data OUT NOCOPY VARCHAR2 );