eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_ITEM_INSTANCE_PVT dependencies on FND_API

Line 9: inventory_item_id NUMBER := FND_API.G_MISS_NUM

5: /* Declare the PL/SQL tables used by the validation API */
6: /*------------------------------------------------------*/
7: TYPE ITEM_ATTRIBUTE_REC IS RECORD
8: (
9: inventory_item_id NUMBER := FND_API.G_MISS_NUM
10: ,organization_id NUMBER := FND_API.G_MISS_NUM
11: ,master_organization_id NUMBER := FND_API.G_MISS_NUM
12: ,serial_number_control_code NUMBER := FND_API.G_MISS_NUM
13: ,lot_control_code NUMBER := FND_API.G_MISS_NUM

Line 10: ,organization_id NUMBER := FND_API.G_MISS_NUM

6: /*------------------------------------------------------*/
7: TYPE ITEM_ATTRIBUTE_REC IS RECORD
8: (
9: inventory_item_id NUMBER := FND_API.G_MISS_NUM
10: ,organization_id NUMBER := FND_API.G_MISS_NUM
11: ,master_organization_id NUMBER := FND_API.G_MISS_NUM
12: ,serial_number_control_code NUMBER := FND_API.G_MISS_NUM
13: ,lot_control_code NUMBER := FND_API.G_MISS_NUM
14: ,revision_control_code NUMBER := FND_API.G_MISS_NUM

Line 11: ,master_organization_id NUMBER := FND_API.G_MISS_NUM

7: TYPE ITEM_ATTRIBUTE_REC IS RECORD
8: (
9: inventory_item_id NUMBER := FND_API.G_MISS_NUM
10: ,organization_id NUMBER := FND_API.G_MISS_NUM
11: ,master_organization_id NUMBER := FND_API.G_MISS_NUM
12: ,serial_number_control_code NUMBER := FND_API.G_MISS_NUM
13: ,lot_control_code NUMBER := FND_API.G_MISS_NUM
14: ,revision_control_code NUMBER := FND_API.G_MISS_NUM
15: ,Uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR

Line 12: ,serial_number_control_code NUMBER := FND_API.G_MISS_NUM

8: (
9: inventory_item_id NUMBER := FND_API.G_MISS_NUM
10: ,organization_id NUMBER := FND_API.G_MISS_NUM
11: ,master_organization_id NUMBER := FND_API.G_MISS_NUM
12: ,serial_number_control_code NUMBER := FND_API.G_MISS_NUM
13: ,lot_control_code NUMBER := FND_API.G_MISS_NUM
14: ,revision_control_code NUMBER := FND_API.G_MISS_NUM
15: ,Uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
16: ,Trackable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 13: ,lot_control_code NUMBER := FND_API.G_MISS_NUM

9: inventory_item_id NUMBER := FND_API.G_MISS_NUM
10: ,organization_id NUMBER := FND_API.G_MISS_NUM
11: ,master_organization_id NUMBER := FND_API.G_MISS_NUM
12: ,serial_number_control_code NUMBER := FND_API.G_MISS_NUM
13: ,lot_control_code NUMBER := FND_API.G_MISS_NUM
14: ,revision_control_code NUMBER := FND_API.G_MISS_NUM
15: ,Uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
16: ,Trackable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
17: ,shelf_life_code NUMBER := FND_API.G_MISS_NUM

Line 14: ,revision_control_code NUMBER := FND_API.G_MISS_NUM

10: ,organization_id NUMBER := FND_API.G_MISS_NUM
11: ,master_organization_id NUMBER := FND_API.G_MISS_NUM
12: ,serial_number_control_code NUMBER := FND_API.G_MISS_NUM
13: ,lot_control_code NUMBER := FND_API.G_MISS_NUM
14: ,revision_control_code NUMBER := FND_API.G_MISS_NUM
15: ,Uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
16: ,Trackable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
17: ,shelf_life_code NUMBER := FND_API.G_MISS_NUM
18: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 15: ,Uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR

11: ,master_organization_id NUMBER := FND_API.G_MISS_NUM
12: ,serial_number_control_code NUMBER := FND_API.G_MISS_NUM
13: ,lot_control_code NUMBER := FND_API.G_MISS_NUM
14: ,revision_control_code NUMBER := FND_API.G_MISS_NUM
15: ,Uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
16: ,Trackable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
17: ,shelf_life_code NUMBER := FND_API.G_MISS_NUM
18: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
19: ,eam_item_type NUMBER := FND_API.G_MISS_NUM

Line 16: ,Trackable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

12: ,serial_number_control_code NUMBER := FND_API.G_MISS_NUM
13: ,lot_control_code NUMBER := FND_API.G_MISS_NUM
14: ,revision_control_code NUMBER := FND_API.G_MISS_NUM
15: ,Uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
16: ,Trackable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
17: ,shelf_life_code NUMBER := FND_API.G_MISS_NUM
18: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
19: ,eam_item_type NUMBER := FND_API.G_MISS_NUM
20: ,equipment_type NUMBER := FND_API.G_MISS_NUM

Line 17: ,shelf_life_code NUMBER := FND_API.G_MISS_NUM

13: ,lot_control_code NUMBER := FND_API.G_MISS_NUM
14: ,revision_control_code NUMBER := FND_API.G_MISS_NUM
15: ,Uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
16: ,Trackable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
17: ,shelf_life_code NUMBER := FND_API.G_MISS_NUM
18: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
19: ,eam_item_type NUMBER := FND_API.G_MISS_NUM
20: ,equipment_type NUMBER := FND_API.G_MISS_NUM
21: );

Line 18: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

14: ,revision_control_code NUMBER := FND_API.G_MISS_NUM
15: ,Uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
16: ,Trackable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
17: ,shelf_life_code NUMBER := FND_API.G_MISS_NUM
18: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
19: ,eam_item_type NUMBER := FND_API.G_MISS_NUM
20: ,equipment_type NUMBER := FND_API.G_MISS_NUM
21: );
22:

Line 19: ,eam_item_type NUMBER := FND_API.G_MISS_NUM

15: ,Uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
16: ,Trackable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
17: ,shelf_life_code NUMBER := FND_API.G_MISS_NUM
18: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
19: ,eam_item_type NUMBER := FND_API.G_MISS_NUM
20: ,equipment_type NUMBER := FND_API.G_MISS_NUM
21: );
22:
23: TYPE ITEM_ATTRIBUTE_TBL IS TABLE OF ITEM_ATTRIBUTE_REC INDEX BY BINARY_INTEGER;

Line 20: ,equipment_type NUMBER := FND_API.G_MISS_NUM

16: ,Trackable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
17: ,shelf_life_code NUMBER := FND_API.G_MISS_NUM
18: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
19: ,eam_item_type NUMBER := FND_API.G_MISS_NUM
20: ,equipment_type NUMBER := FND_API.G_MISS_NUM
21: );
22:
23: TYPE ITEM_ATTRIBUTE_TBL IS TABLE OF ITEM_ATTRIBUTE_REC INDEX BY BINARY_INTEGER;
24: --

Line 27: generic_id NUMBER := FND_API.G_MISS_NUM

23: TYPE ITEM_ATTRIBUTE_TBL IS TABLE OF ITEM_ATTRIBUTE_REC INDEX BY BINARY_INTEGER;
24: --
25: TYPE GENERIC_ID_REC IS RECORD
26: (
27: generic_id NUMBER := FND_API.G_MISS_NUM
28: ,id_type VARCHAR2(30) := FND_API.G_MISS_CHAR
29: ,terminated_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
30: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
31: );

Line 28: ,id_type VARCHAR2(30) := FND_API.G_MISS_CHAR

24: --
25: TYPE GENERIC_ID_REC IS RECORD
26: (
27: generic_id NUMBER := FND_API.G_MISS_NUM
28: ,id_type VARCHAR2(30) := FND_API.G_MISS_CHAR
29: ,terminated_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
30: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
31: );
32:

Line 29: ,terminated_flag VARCHAR2(30) := FND_API.G_MISS_CHAR

25: TYPE GENERIC_ID_REC IS RECORD
26: (
27: generic_id NUMBER := FND_API.G_MISS_NUM
28: ,id_type VARCHAR2(30) := FND_API.G_MISS_CHAR
29: ,terminated_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
30: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
31: );
32:
33: TYPE GENERIC_ID_TBL IS TABLE OF GENERIC_ID_REC INDEX BY BINARY_INTEGER;

Line 30: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

26: (
27: generic_id NUMBER := FND_API.G_MISS_NUM
28: ,id_type VARCHAR2(30) := FND_API.G_MISS_CHAR
29: ,terminated_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
30: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
31: );
32:
33: TYPE GENERIC_ID_TBL IS TABLE OF GENERIC_ID_REC INDEX BY BINARY_INTEGER;
34: --

Line 37: lookup_code VARCHAR2(30) := FND_API.G_MISS_CHAR

33: TYPE GENERIC_ID_TBL IS TABLE OF GENERIC_ID_REC INDEX BY BINARY_INTEGER;
34: --
35: TYPE LOOKUP_REC IS RECORD
36: (
37: lookup_code VARCHAR2(30) := FND_API.G_MISS_CHAR
38: ,lookup_type VARCHAR2(30) := FND_API.G_MISS_CHAR
39: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
40: );
41:

Line 38: ,lookup_type VARCHAR2(30) := FND_API.G_MISS_CHAR

34: --
35: TYPE LOOKUP_REC IS RECORD
36: (
37: lookup_code VARCHAR2(30) := FND_API.G_MISS_CHAR
38: ,lookup_type VARCHAR2(30) := FND_API.G_MISS_CHAR
39: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
40: );
41:
42: TYPE LOOKUP_TBL IS TABLE OF LOOKUP_REC INDEX BY BINARY_INTEGER;

Line 39: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

35: TYPE LOOKUP_REC IS RECORD
36: (
37: lookup_code VARCHAR2(30) := FND_API.G_MISS_CHAR
38: ,lookup_type VARCHAR2(30) := FND_API.G_MISS_CHAR
39: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
40: );
41:
42: TYPE LOOKUP_TBL IS TABLE OF LOOKUP_REC INDEX BY BINARY_INTEGER;
43: --

Line 46: location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

42: TYPE LOOKUP_TBL IS TABLE OF LOOKUP_REC INDEX BY BINARY_INTEGER;
43: --
44: TYPE LOCATION_REC IS RECORD
45: (
46: location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
47: ,location_id NUMBER := FND_API.G_MISS_NUM
48: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
49: );
50: TYPE LOCATION_TBL IS TABLE OF LOCATION_REC INDEX BY BINARY_INTEGER;

Line 47: ,location_id NUMBER := FND_API.G_MISS_NUM

43: --
44: TYPE LOCATION_REC IS RECORD
45: (
46: location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
47: ,location_id NUMBER := FND_API.G_MISS_NUM
48: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
49: );
50: TYPE LOCATION_TBL IS TABLE OF LOCATION_REC INDEX BY BINARY_INTEGER;
51: --

Line 48: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

44: TYPE LOCATION_REC IS RECORD
45: (
46: location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
47: ,location_id NUMBER := FND_API.G_MISS_NUM
48: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
49: );
50: TYPE LOCATION_TBL IS TABLE OF LOCATION_REC INDEX BY BINARY_INTEGER;
51: --
52: TYPE INS_COUNT_REC IS RECORD

Line 54: inv_count NUMBER := FND_API.G_MISS_NUM

50: TYPE LOCATION_TBL IS TABLE OF LOCATION_REC INDEX BY BINARY_INTEGER;
51: --
52: TYPE INS_COUNT_REC IS RECORD
53: (
54: inv_count NUMBER := FND_API.G_MISS_NUM
55: ,generic_count NUMBER := FND_API.G_MISS_NUM
56: ,location_count NUMBER := FND_API.G_MISS_NUM
57: ,lookup_count NUMBER := FND_API.G_MISS_NUM
58: );

Line 55: ,generic_count NUMBER := FND_API.G_MISS_NUM

51: --
52: TYPE INS_COUNT_REC IS RECORD
53: (
54: inv_count NUMBER := FND_API.G_MISS_NUM
55: ,generic_count NUMBER := FND_API.G_MISS_NUM
56: ,location_count NUMBER := FND_API.G_MISS_NUM
57: ,lookup_count NUMBER := FND_API.G_MISS_NUM
58: );
59: -- PL/SQL tables used by Explode_BOM API.

Line 56: ,location_count NUMBER := FND_API.G_MISS_NUM

52: TYPE INS_COUNT_REC IS RECORD
53: (
54: inv_count NUMBER := FND_API.G_MISS_NUM
55: ,generic_count NUMBER := FND_API.G_MISS_NUM
56: ,location_count NUMBER := FND_API.G_MISS_NUM
57: ,lookup_count NUMBER := FND_API.G_MISS_NUM
58: );
59: -- PL/SQL tables used by Explode_BOM API.
60: --

Line 57: ,lookup_count NUMBER := FND_API.G_MISS_NUM

53: (
54: inv_count NUMBER := FND_API.G_MISS_NUM
55: ,generic_count NUMBER := FND_API.G_MISS_NUM
56: ,location_count NUMBER := FND_API.G_MISS_NUM
57: ,lookup_count NUMBER := FND_API.G_MISS_NUM
58: );
59: -- PL/SQL tables used by Explode_BOM API.
60: --
61: TYPE PARENT_CHILD_REC IS RECORD

Line 134: instance_id NUMBER := fnd_api.g_miss_num

130: /*--------------------------------------------------*/
131:
132: TYPE lock_instances_rec IS RECORD
133: (
134: instance_id NUMBER := fnd_api.g_miss_num
135: ,root_instance_id NUMBER := fnd_api.g_miss_num
136: ,lock_id NUMBER := fnd_api.g_miss_num
137: ,lock_status NUMBER := fnd_api.g_miss_num
138: ,source_application_id NUMBER := fnd_api.g_miss_num

Line 135: ,root_instance_id NUMBER := fnd_api.g_miss_num

131:
132: TYPE lock_instances_rec IS RECORD
133: (
134: instance_id NUMBER := fnd_api.g_miss_num
135: ,root_instance_id NUMBER := fnd_api.g_miss_num
136: ,lock_id NUMBER := fnd_api.g_miss_num
137: ,lock_status NUMBER := fnd_api.g_miss_num
138: ,source_application_id NUMBER := fnd_api.g_miss_num
139: ,source_txn_header_ref VARCHAR2(30) := fnd_api.g_miss_char

Line 136: ,lock_id NUMBER := fnd_api.g_miss_num

132: TYPE lock_instances_rec IS RECORD
133: (
134: instance_id NUMBER := fnd_api.g_miss_num
135: ,root_instance_id NUMBER := fnd_api.g_miss_num
136: ,lock_id NUMBER := fnd_api.g_miss_num
137: ,lock_status NUMBER := fnd_api.g_miss_num
138: ,source_application_id NUMBER := fnd_api.g_miss_num
139: ,source_txn_header_ref VARCHAR2(30) := fnd_api.g_miss_char
140: ,source_txn_line_ref1 VARCHAR2(30) := fnd_api.g_miss_char

Line 137: ,lock_status NUMBER := fnd_api.g_miss_num

133: (
134: instance_id NUMBER := fnd_api.g_miss_num
135: ,root_instance_id NUMBER := fnd_api.g_miss_num
136: ,lock_id NUMBER := fnd_api.g_miss_num
137: ,lock_status NUMBER := fnd_api.g_miss_num
138: ,source_application_id NUMBER := fnd_api.g_miss_num
139: ,source_txn_header_ref VARCHAR2(30) := fnd_api.g_miss_char
140: ,source_txn_line_ref1 VARCHAR2(30) := fnd_api.g_miss_char
141: ,source_txn_line_ref2 VARCHAR2(30) := fnd_api.g_miss_char

Line 138: ,source_application_id NUMBER := fnd_api.g_miss_num

134: instance_id NUMBER := fnd_api.g_miss_num
135: ,root_instance_id NUMBER := fnd_api.g_miss_num
136: ,lock_id NUMBER := fnd_api.g_miss_num
137: ,lock_status NUMBER := fnd_api.g_miss_num
138: ,source_application_id NUMBER := fnd_api.g_miss_num
139: ,source_txn_header_ref VARCHAR2(30) := fnd_api.g_miss_char
140: ,source_txn_line_ref1 VARCHAR2(30) := fnd_api.g_miss_char
141: ,source_txn_line_ref2 VARCHAR2(30) := fnd_api.g_miss_char
142: ,source_txn_line_ref3 VARCHAR2(30) := fnd_api.g_miss_char

Line 139: ,source_txn_header_ref VARCHAR2(30) := fnd_api.g_miss_char

135: ,root_instance_id NUMBER := fnd_api.g_miss_num
136: ,lock_id NUMBER := fnd_api.g_miss_num
137: ,lock_status NUMBER := fnd_api.g_miss_num
138: ,source_application_id NUMBER := fnd_api.g_miss_num
139: ,source_txn_header_ref VARCHAR2(30) := fnd_api.g_miss_char
140: ,source_txn_line_ref1 VARCHAR2(30) := fnd_api.g_miss_char
141: ,source_txn_line_ref2 VARCHAR2(30) := fnd_api.g_miss_char
142: ,source_txn_line_ref3 VARCHAR2(30) := fnd_api.g_miss_char
143: ,config_inst_hdr_id NUMBER := fnd_api.g_miss_num

Line 140: ,source_txn_line_ref1 VARCHAR2(30) := fnd_api.g_miss_char

136: ,lock_id NUMBER := fnd_api.g_miss_num
137: ,lock_status NUMBER := fnd_api.g_miss_num
138: ,source_application_id NUMBER := fnd_api.g_miss_num
139: ,source_txn_header_ref VARCHAR2(30) := fnd_api.g_miss_char
140: ,source_txn_line_ref1 VARCHAR2(30) := fnd_api.g_miss_char
141: ,source_txn_line_ref2 VARCHAR2(30) := fnd_api.g_miss_char
142: ,source_txn_line_ref3 VARCHAR2(30) := fnd_api.g_miss_char
143: ,config_inst_hdr_id NUMBER := fnd_api.g_miss_num
144: ,config_inst_item_id NUMBER := fnd_api.g_miss_num

Line 141: ,source_txn_line_ref2 VARCHAR2(30) := fnd_api.g_miss_char

137: ,lock_status NUMBER := fnd_api.g_miss_num
138: ,source_application_id NUMBER := fnd_api.g_miss_num
139: ,source_txn_header_ref VARCHAR2(30) := fnd_api.g_miss_char
140: ,source_txn_line_ref1 VARCHAR2(30) := fnd_api.g_miss_char
141: ,source_txn_line_ref2 VARCHAR2(30) := fnd_api.g_miss_char
142: ,source_txn_line_ref3 VARCHAR2(30) := fnd_api.g_miss_char
143: ,config_inst_hdr_id NUMBER := fnd_api.g_miss_num
144: ,config_inst_item_id NUMBER := fnd_api.g_miss_num
145: ,config_inst_rev_num NUMBER := fnd_api.g_miss_num

Line 142: ,source_txn_line_ref3 VARCHAR2(30) := fnd_api.g_miss_char

138: ,source_application_id NUMBER := fnd_api.g_miss_num
139: ,source_txn_header_ref VARCHAR2(30) := fnd_api.g_miss_char
140: ,source_txn_line_ref1 VARCHAR2(30) := fnd_api.g_miss_char
141: ,source_txn_line_ref2 VARCHAR2(30) := fnd_api.g_miss_char
142: ,source_txn_line_ref3 VARCHAR2(30) := fnd_api.g_miss_char
143: ,config_inst_hdr_id NUMBER := fnd_api.g_miss_num
144: ,config_inst_item_id NUMBER := fnd_api.g_miss_num
145: ,config_inst_rev_num NUMBER := fnd_api.g_miss_num
146: ,root_config_inst_hdr_id NUMBER := fnd_api.g_miss_num

Line 143: ,config_inst_hdr_id NUMBER := fnd_api.g_miss_num

139: ,source_txn_header_ref VARCHAR2(30) := fnd_api.g_miss_char
140: ,source_txn_line_ref1 VARCHAR2(30) := fnd_api.g_miss_char
141: ,source_txn_line_ref2 VARCHAR2(30) := fnd_api.g_miss_char
142: ,source_txn_line_ref3 VARCHAR2(30) := fnd_api.g_miss_char
143: ,config_inst_hdr_id NUMBER := fnd_api.g_miss_num
144: ,config_inst_item_id NUMBER := fnd_api.g_miss_num
145: ,config_inst_rev_num NUMBER := fnd_api.g_miss_num
146: ,root_config_inst_hdr_id NUMBER := fnd_api.g_miss_num
147: ,root_config_inst_item_id NUMBER := fnd_api.g_miss_num

Line 144: ,config_inst_item_id NUMBER := fnd_api.g_miss_num

140: ,source_txn_line_ref1 VARCHAR2(30) := fnd_api.g_miss_char
141: ,source_txn_line_ref2 VARCHAR2(30) := fnd_api.g_miss_char
142: ,source_txn_line_ref3 VARCHAR2(30) := fnd_api.g_miss_char
143: ,config_inst_hdr_id NUMBER := fnd_api.g_miss_num
144: ,config_inst_item_id NUMBER := fnd_api.g_miss_num
145: ,config_inst_rev_num NUMBER := fnd_api.g_miss_num
146: ,root_config_inst_hdr_id NUMBER := fnd_api.g_miss_num
147: ,root_config_inst_item_id NUMBER := fnd_api.g_miss_num
148: ,root_config_inst_rev_num NUMBER := fnd_api.g_miss_num

Line 145: ,config_inst_rev_num NUMBER := fnd_api.g_miss_num

141: ,source_txn_line_ref2 VARCHAR2(30) := fnd_api.g_miss_char
142: ,source_txn_line_ref3 VARCHAR2(30) := fnd_api.g_miss_char
143: ,config_inst_hdr_id NUMBER := fnd_api.g_miss_num
144: ,config_inst_item_id NUMBER := fnd_api.g_miss_num
145: ,config_inst_rev_num NUMBER := fnd_api.g_miss_num
146: ,root_config_inst_hdr_id NUMBER := fnd_api.g_miss_num
147: ,root_config_inst_item_id NUMBER := fnd_api.g_miss_num
148: ,root_config_inst_rev_num NUMBER := fnd_api.g_miss_num
149: );

Line 146: ,root_config_inst_hdr_id NUMBER := fnd_api.g_miss_num

142: ,source_txn_line_ref3 VARCHAR2(30) := fnd_api.g_miss_char
143: ,config_inst_hdr_id NUMBER := fnd_api.g_miss_num
144: ,config_inst_item_id NUMBER := fnd_api.g_miss_num
145: ,config_inst_rev_num NUMBER := fnd_api.g_miss_num
146: ,root_config_inst_hdr_id NUMBER := fnd_api.g_miss_num
147: ,root_config_inst_item_id NUMBER := fnd_api.g_miss_num
148: ,root_config_inst_rev_num NUMBER := fnd_api.g_miss_num
149: );
150:

Line 147: ,root_config_inst_item_id NUMBER := fnd_api.g_miss_num

143: ,config_inst_hdr_id NUMBER := fnd_api.g_miss_num
144: ,config_inst_item_id NUMBER := fnd_api.g_miss_num
145: ,config_inst_rev_num NUMBER := fnd_api.g_miss_num
146: ,root_config_inst_hdr_id NUMBER := fnd_api.g_miss_num
147: ,root_config_inst_item_id NUMBER := fnd_api.g_miss_num
148: ,root_config_inst_rev_num NUMBER := fnd_api.g_miss_num
149: );
150:
151: TYPE lock_instances_tbl IS TABLE OF lock_instances_rec INDEX BY BINARY_INTEGER;

Line 148: ,root_config_inst_rev_num NUMBER := fnd_api.g_miss_num

144: ,config_inst_item_id NUMBER := fnd_api.g_miss_num
145: ,config_inst_rev_num NUMBER := fnd_api.g_miss_num
146: ,root_config_inst_hdr_id NUMBER := fnd_api.g_miss_num
147: ,root_config_inst_item_id NUMBER := fnd_api.g_miss_num
148: ,root_config_inst_rev_num NUMBER := fnd_api.g_miss_num
149: );
150:
151: TYPE lock_instances_tbl IS TABLE OF lock_instances_rec INDEX BY BINARY_INTEGER;
152:

Line 155: config_inst_hdr_id NUMBER := fnd_api.g_miss_num

151: TYPE lock_instances_tbl IS TABLE OF lock_instances_rec INDEX BY BINARY_INTEGER;
152:
153: TYPE lock_config_rec IS RECORD
154: (
155: config_inst_hdr_id NUMBER := fnd_api.g_miss_num
156: ,config_inst_item_id NUMBER := fnd_api.g_miss_num
157: ,config_inst_rev_num NUMBER := fnd_api.g_miss_num
158: );
159:

Line 156: ,config_inst_item_id NUMBER := fnd_api.g_miss_num

152:
153: TYPE lock_config_rec IS RECORD
154: (
155: config_inst_hdr_id NUMBER := fnd_api.g_miss_num
156: ,config_inst_item_id NUMBER := fnd_api.g_miss_num
157: ,config_inst_rev_num NUMBER := fnd_api.g_miss_num
158: );
159:
160: FUNCTION check_item_instance_lock

Line 157: ,config_inst_rev_num NUMBER := fnd_api.g_miss_num

153: TYPE lock_config_rec IS RECORD
154: (
155: config_inst_hdr_id NUMBER := fnd_api.g_miss_num
156: ,config_inst_item_id NUMBER := fnd_api.g_miss_num
157: ,config_inst_rev_num NUMBER := fnd_api.g_miss_num
158: );
159:
160: FUNCTION check_item_instance_lock
161: ( p_instance_id IN NUMBER :=fnd_api.g_miss_num,

Line 161: ( p_instance_id IN NUMBER :=fnd_api.g_miss_num,

157: ,config_inst_rev_num NUMBER := fnd_api.g_miss_num
158: );
159:
160: FUNCTION check_item_instance_lock
161: ( p_instance_id IN NUMBER :=fnd_api.g_miss_num,
162: p_config_inst_hdr_id IN NUMBER :=fnd_api.g_miss_num,
163: p_config_inst_item_id IN NUMBER :=fnd_api.g_miss_num,
164: p_config_inst_rev_num IN NUMBER :=fnd_api.g_miss_num
165: ) RETURN BOOLEAN;

Line 162: p_config_inst_hdr_id IN NUMBER :=fnd_api.g_miss_num,

158: );
159:
160: FUNCTION check_item_instance_lock
161: ( p_instance_id IN NUMBER :=fnd_api.g_miss_num,
162: p_config_inst_hdr_id IN NUMBER :=fnd_api.g_miss_num,
163: p_config_inst_item_id IN NUMBER :=fnd_api.g_miss_num,
164: p_config_inst_rev_num IN NUMBER :=fnd_api.g_miss_num
165: ) RETURN BOOLEAN;
166:

Line 163: p_config_inst_item_id IN NUMBER :=fnd_api.g_miss_num,

159:
160: FUNCTION check_item_instance_lock
161: ( p_instance_id IN NUMBER :=fnd_api.g_miss_num,
162: p_config_inst_hdr_id IN NUMBER :=fnd_api.g_miss_num,
163: p_config_inst_item_id IN NUMBER :=fnd_api.g_miss_num,
164: p_config_inst_rev_num IN NUMBER :=fnd_api.g_miss_num
165: ) RETURN BOOLEAN;
166:
167: PROCEDURE get_instance_lock_status

Line 164: p_config_inst_rev_num IN NUMBER :=fnd_api.g_miss_num

160: FUNCTION check_item_instance_lock
161: ( p_instance_id IN NUMBER :=fnd_api.g_miss_num,
162: p_config_inst_hdr_id IN NUMBER :=fnd_api.g_miss_num,
163: p_config_inst_item_id IN NUMBER :=fnd_api.g_miss_num,
164: p_config_inst_rev_num IN NUMBER :=fnd_api.g_miss_num
165: ) RETURN BOOLEAN;
166:
167: PROCEDURE get_instance_lock_status
168: ( p_instance_id IN NUMBER ,

Line 174: ,p_commit IN VARCHAR2 := fnd_api.g_false

170: );
171: PROCEDURE lock_item_instances
172: (
173: p_api_version IN NUMBER
174: ,p_commit IN VARCHAR2 := fnd_api.g_false
175: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
176: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
177: ,px_config_tbl IN OUT NOCOPY csi_cz_int.config_tbl
178: -- ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

Line 175: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

171: PROCEDURE lock_item_instances
172: (
173: p_api_version IN NUMBER
174: ,p_commit IN VARCHAR2 := fnd_api.g_false
175: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
176: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
177: ,px_config_tbl IN OUT NOCOPY csi_cz_int.config_tbl
178: -- ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
179: ,x_return_status OUT NOCOPY VARCHAR2

Line 176: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

172: (
173: p_api_version IN NUMBER
174: ,p_commit IN VARCHAR2 := fnd_api.g_false
175: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
176: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
177: ,px_config_tbl IN OUT NOCOPY csi_cz_int.config_tbl
178: -- ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
179: ,x_return_status OUT NOCOPY VARCHAR2
180: ,x_msg_count OUT NOCOPY NUMBER

Line 187: ,p_commit IN VARCHAR2 := fnd_api.g_false

183:
184: PROCEDURE unlock_item_instances
185: (
186: p_api_version IN NUMBER
187: ,p_commit IN VARCHAR2 := fnd_api.g_false
188: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
189: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
190: ,p_config_tbl IN csi_cz_int.config_tbl
191: ,p_unlock_all IN VARCHAR2 :=fnd_api.g_false

Line 188: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

184: PROCEDURE unlock_item_instances
185: (
186: p_api_version IN NUMBER
187: ,p_commit IN VARCHAR2 := fnd_api.g_false
188: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
189: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
190: ,p_config_tbl IN csi_cz_int.config_tbl
191: ,p_unlock_all IN VARCHAR2 :=fnd_api.g_false
192: -- ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

Line 189: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

185: (
186: p_api_version IN NUMBER
187: ,p_commit IN VARCHAR2 := fnd_api.g_false
188: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
189: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
190: ,p_config_tbl IN csi_cz_int.config_tbl
191: ,p_unlock_all IN VARCHAR2 :=fnd_api.g_false
192: -- ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
193: ,x_return_status OUT NOCOPY VARCHAR2

Line 191: ,p_unlock_all IN VARCHAR2 :=fnd_api.g_false

187: ,p_commit IN VARCHAR2 := fnd_api.g_false
188: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
189: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
190: ,p_config_tbl IN csi_cz_int.config_tbl
191: ,p_unlock_all IN VARCHAR2 :=fnd_api.g_false
192: -- ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
193: ,x_return_status OUT NOCOPY VARCHAR2
194: ,x_msg_count OUT NOCOPY NUMBER
195: ,x_msg_data OUT NOCOPY VARCHAR2

Line 201: ,p_commit IN VARCHAR2 := fnd_api.g_false

197:
198: PROCEDURE create_item_instance
199: (
200: p_api_version IN NUMBER
201: ,p_commit IN VARCHAR2 := fnd_api.g_false
202: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
203: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
204: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
205: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

Line 202: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

198: PROCEDURE create_item_instance
199: (
200: p_api_version IN NUMBER
201: ,p_commit IN VARCHAR2 := fnd_api.g_false
202: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
203: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
204: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
205: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
206: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl

Line 203: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

199: (
200: p_api_version IN NUMBER
201: ,p_commit IN VARCHAR2 := fnd_api.g_false
202: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
203: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
204: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
205: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
206: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
207: ,p_asset_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl

Line 216: ,p_called_from_grp IN VARCHAR2 DEFAULT fnd_api.g_false

212: ,p_location_tbl IN OUT NOCOPY csi_item_instance_pvt.location_tbl
213: ,p_generic_id_tbl IN OUT NOCOPY csi_item_instance_pvt.generic_id_tbl
214: ,p_lookup_tbl IN OUT NOCOPY csi_item_instance_pvt.lookup_tbl
215: ,p_ins_count_rec IN OUT NOCOPY csi_item_instance_pvt.ins_count_rec
216: ,p_called_from_grp IN VARCHAR2 DEFAULT fnd_api.g_false
217: ,p_internal_party_id IN NUMBER DEFAULT -9999
218: );
219:
220: /*---------------------------------------------------*/

Line 229: ,p_commit IN VARCHAR2 := fnd_api.g_false

225:
226: PROCEDURE update_item_instance
227: (
228: p_api_version IN NUMBER
229: ,p_commit IN VARCHAR2 := fnd_api.g_false
230: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
231: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
232: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
233: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

Line 230: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

226: PROCEDURE update_item_instance
227: (
228: p_api_version IN NUMBER
229: ,p_commit IN VARCHAR2 := fnd_api.g_false
230: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
231: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
232: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
233: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
234:

Line 231: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

227: (
228: p_api_version IN NUMBER
229: ,p_commit IN VARCHAR2 := fnd_api.g_false
230: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
231: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
232: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
233: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
234:
235: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl

Line 245: ,p_called_from_rel IN VARCHAR2 DEFAULT fnd_api.g_false

241: ,p_location_tbl IN OUT NOCOPY csi_item_instance_pvt.location_tbl
242: ,p_generic_id_tbl IN OUT NOCOPY csi_item_instance_pvt.generic_id_tbl
243: ,p_lookup_tbl IN OUT NOCOPY csi_item_instance_pvt.lookup_tbl
244: ,p_ins_count_rec IN OUT NOCOPY csi_item_instance_pvt.ins_count_rec
245: ,p_called_from_rel IN VARCHAR2 DEFAULT fnd_api.g_false
246: ,p_validation_mode IN VARCHAR2 DEFAULT 'A'
247: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
248: ,p_child_inst_tbl IN OUT NOCOPY csi_item_instance_grp.child_inst_tbl
249: );

Line 260: ,p_commit IN VARCHAR2 := fnd_api.g_false

256:
257: PROCEDURE expire_item_instance
258: (
259: p_api_version IN NUMBER
260: ,p_commit IN VARCHAR2 := fnd_api.g_false
261: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
262: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
263: ,p_instance_rec IN csi_datastructures_pub.instance_rec
264: ,p_expire_children IN VARCHAR2 := fnd_api.g_false

Line 261: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

257: PROCEDURE expire_item_instance
258: (
259: p_api_version IN NUMBER
260: ,p_commit IN VARCHAR2 := fnd_api.g_false
261: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
262: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
263: ,p_instance_rec IN csi_datastructures_pub.instance_rec
264: ,p_expire_children IN VARCHAR2 := fnd_api.g_false
265: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

Line 262: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

258: (
259: p_api_version IN NUMBER
260: ,p_commit IN VARCHAR2 := fnd_api.g_false
261: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
262: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
263: ,p_instance_rec IN csi_datastructures_pub.instance_rec
264: ,p_expire_children IN VARCHAR2 := fnd_api.g_false
265: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
266: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl

Line 264: ,p_expire_children IN VARCHAR2 := fnd_api.g_false

260: ,p_commit IN VARCHAR2 := fnd_api.g_false
261: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
262: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
263: ,p_instance_rec IN csi_datastructures_pub.instance_rec
264: ,p_expire_children IN VARCHAR2 := fnd_api.g_false
265: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
266: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
267: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
268: ,x_return_status OUT NOCOPY VARCHAR2

Line 412: ,p_commit IN VARCHAR2 := fnd_api.g_false

408: /*----------------------------------------------------*/
409:
410: PROCEDURE get_and_update_acct_class
411: ( p_api_version IN NUMBER
412: ,p_commit IN VARCHAR2 := fnd_api.g_false
413: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
414: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
415: ,p_instance_id IN NUMBER
416: ,p_instance_expiry_flag IN VARCHAR2 := fnd_api.g_true

Line 413: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

409:
410: PROCEDURE get_and_update_acct_class
411: ( p_api_version IN NUMBER
412: ,p_commit IN VARCHAR2 := fnd_api.g_false
413: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
414: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
415: ,p_instance_id IN NUMBER
416: ,p_instance_expiry_flag IN VARCHAR2 := fnd_api.g_true
417: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

Line 414: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

410: PROCEDURE get_and_update_acct_class
411: ( p_api_version IN NUMBER
412: ,p_commit IN VARCHAR2 := fnd_api.g_false
413: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
414: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
415: ,p_instance_id IN NUMBER
416: ,p_instance_expiry_flag IN VARCHAR2 := fnd_api.g_true
417: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
418: ,x_acct_class_code OUT NOCOPY VARCHAR2

Line 416: ,p_instance_expiry_flag IN VARCHAR2 := fnd_api.g_true

412: ,p_commit IN VARCHAR2 := fnd_api.g_false
413: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
414: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
415: ,p_instance_id IN NUMBER
416: ,p_instance_expiry_flag IN VARCHAR2 := fnd_api.g_true
417: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
418: ,x_acct_class_code OUT NOCOPY VARCHAR2
419: ,x_return_status OUT NOCOPY VARCHAR2
420: ,x_msg_count OUT NOCOPY NUMBER

Line 445: ,p_commit IN VARCHAR2 := fnd_api.g_false

441:
442: PROCEDURE Split_Item_Instance
443: (
444: p_api_version IN NUMBER
445: ,p_commit IN VARCHAR2 := fnd_api.g_false
446: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
447: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
448: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
449: ,p_quantity1 IN NUMBER

Line 446: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

442: PROCEDURE Split_Item_Instance
443: (
444: p_api_version IN NUMBER
445: ,p_commit IN VARCHAR2 := fnd_api.g_false
446: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
447: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
448: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
449: ,p_quantity1 IN NUMBER
450: ,p_quantity2 IN NUMBER

Line 447: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

443: (
444: p_api_version IN NUMBER
445: ,p_commit IN VARCHAR2 := fnd_api.g_false
446: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
447: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
448: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
449: ,p_quantity1 IN NUMBER
450: ,p_quantity2 IN NUMBER
451: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true

Line 451: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true

447: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
448: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
449: ,p_quantity1 IN NUMBER
450: ,p_quantity2 IN NUMBER
451: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true
452: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true
453: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true
454: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
455: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true

Line 452: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true

448: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
449: ,p_quantity1 IN NUMBER
450: ,p_quantity2 IN NUMBER
451: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true
452: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true
453: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true
454: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
455: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
456: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true

Line 453: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true

449: ,p_quantity1 IN NUMBER
450: ,p_quantity2 IN NUMBER
451: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true
452: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true
453: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true
454: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
455: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
456: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true
457: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_true

Line 454: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true

450: ,p_quantity2 IN NUMBER
451: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true
452: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true
453: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true
454: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
455: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
456: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true
457: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_true
458: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

Line 455: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true

451: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true
452: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true
453: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true
454: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
455: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
456: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true
457: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_true
458: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
459: ,x_new_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec

Line 456: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true

452: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true
453: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true
454: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
455: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
456: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true
457: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_true
458: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
459: ,x_new_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
460: ,x_return_status OUT NOCOPY VARCHAR2

Line 457: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_true

453: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true
454: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
455: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
456: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true
457: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_true
458: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
459: ,x_new_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
460: ,x_return_status OUT NOCOPY VARCHAR2
461: ,x_msg_count OUT NOCOPY NUMBER

Line 473: ,p_commit IN VARCHAR2 := fnd_api.g_false

469: /*---------------------------------------------------*/
470: PROCEDURE Split_Item_Instance_Lines
471: (
472: p_api_version IN NUMBER
473: ,p_commit IN VARCHAR2 := fnd_api.g_false
474: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
475: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
476: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
477: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true

Line 474: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

470: PROCEDURE Split_Item_Instance_Lines
471: (
472: p_api_version IN NUMBER
473: ,p_commit IN VARCHAR2 := fnd_api.g_false
474: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
475: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
476: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
477: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true
478: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true

Line 475: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

471: (
472: p_api_version IN NUMBER
473: ,p_commit IN VARCHAR2 := fnd_api.g_false
474: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
475: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
476: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
477: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true
478: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true
479: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true

Line 477: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true

473: ,p_commit IN VARCHAR2 := fnd_api.g_false
474: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
475: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
476: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
477: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true
478: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true
479: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true
480: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
481: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true

Line 478: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true

474: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
475: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
476: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
477: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true
478: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true
479: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true
480: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
481: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
482: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true

Line 479: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true

475: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
476: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
477: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true
478: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true
479: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true
480: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
481: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
482: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true
483: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_true

Line 480: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true

476: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
477: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true
478: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true
479: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true
480: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
481: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
482: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true
483: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_true
484: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

Line 481: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true

477: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true
478: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true
479: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true
480: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
481: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
482: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true
483: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_true
484: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
485: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl

Line 482: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true

478: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true
479: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true
480: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
481: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
482: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true
483: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_true
484: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
485: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
486: ,x_return_status OUT NOCOPY VARCHAR2

Line 483: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_true

479: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true
480: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
481: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
482: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true
483: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_true
484: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
485: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
486: ,x_return_status OUT NOCOPY VARCHAR2
487: ,x_msg_count OUT NOCOPY NUMBER

Line 578: ,p_commit IN VARCHAR2 := fnd_api.g_false

574: /*---------------------------------------------------*/
575:
576: PROCEDURE create_version_label
577: ( p_api_version IN NUMBER
578: ,p_commit IN VARCHAR2 := fnd_api.g_false
579: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
580: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
581: ,p_version_label_rec IN OUT NOCOPY csi_datastructures_pub.version_label_rec
582: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

Line 579: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

575:
576: PROCEDURE create_version_label
577: ( p_api_version IN NUMBER
578: ,p_commit IN VARCHAR2 := fnd_api.g_false
579: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
580: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
581: ,p_version_label_rec IN OUT NOCOPY csi_datastructures_pub.version_label_rec
582: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
583: ,x_return_status OUT NOCOPY VARCHAR2

Line 580: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

576: PROCEDURE create_version_label
577: ( p_api_version IN NUMBER
578: ,p_commit IN VARCHAR2 := fnd_api.g_false
579: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
580: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
581: ,p_version_label_rec IN OUT NOCOPY csi_datastructures_pub.version_label_rec
582: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
583: ,x_return_status OUT NOCOPY VARCHAR2
584: ,x_msg_count OUT NOCOPY NUMBER

Line 596: ,p_commit IN VARCHAR2 := fnd_api.g_false

592: /*---------------------------------------------------*/
593:
594: PROCEDURE update_version_label
595: ( p_api_version IN NUMBER
596: ,p_commit IN VARCHAR2 := fnd_api.g_false
597: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
598: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
599: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec
600: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

Line 597: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

593:
594: PROCEDURE update_version_label
595: ( p_api_version IN NUMBER
596: ,p_commit IN VARCHAR2 := fnd_api.g_false
597: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
598: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
599: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec
600: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
601: ,p_call_transaction IN VARCHAR2 := fnd_api.g_true

Line 598: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

594: PROCEDURE update_version_label
595: ( p_api_version IN NUMBER
596: ,p_commit IN VARCHAR2 := fnd_api.g_false
597: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
598: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
599: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec
600: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
601: ,p_call_transaction IN VARCHAR2 := fnd_api.g_true
602: ,x_return_status OUT NOCOPY VARCHAR2

Line 601: ,p_call_transaction IN VARCHAR2 := fnd_api.g_true

597: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
598: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
599: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec
600: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
601: ,p_call_transaction IN VARCHAR2 := fnd_api.g_true
602: ,x_return_status OUT NOCOPY VARCHAR2
603: ,x_msg_count OUT NOCOPY NUMBER
604: ,x_msg_data OUT NOCOPY VARCHAR2 );
605:

Line 615: ,p_commit IN VARCHAR2 := fnd_api.g_false

611: /*---------------------------------------------------*/
612:
613: PROCEDURE expire_version_label
614: ( p_api_version IN NUMBER
615: ,p_commit IN VARCHAR2 := fnd_api.g_false
616: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
617: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
618: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec
619: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

Line 616: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

612:
613: PROCEDURE expire_version_label
614: ( p_api_version IN NUMBER
615: ,p_commit IN VARCHAR2 := fnd_api.g_false
616: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
617: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
618: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec
619: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
620: ,x_return_status OUT NOCOPY VARCHAR2

Line 617: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

613: PROCEDURE expire_version_label
614: ( p_api_version IN NUMBER
615: ,p_commit IN VARCHAR2 := fnd_api.g_false
616: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
617: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
618: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec
619: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
620: ,x_return_status OUT NOCOPY VARCHAR2
621: ,x_msg_count OUT NOCOPY NUMBER

Line 627: ext_count NUMBER := FND_API.G_MISS_NUM

623:
624: --
625: TYPE EXT_COUNT_REC IS RECORD
626: (
627: ext_count NUMBER := FND_API.G_MISS_NUM
628: ,ext_attr_count NUMBER := FND_API.G_MISS_NUM
629: ,ext_cat_count NUMBER := FND_API.G_MISS_NUM
630: );
631: --

Line 628: ,ext_attr_count NUMBER := FND_API.G_MISS_NUM

624: --
625: TYPE EXT_COUNT_REC IS RECORD
626: (
627: ext_count NUMBER := FND_API.G_MISS_NUM
628: ,ext_attr_count NUMBER := FND_API.G_MISS_NUM
629: ,ext_cat_count NUMBER := FND_API.G_MISS_NUM
630: );
631: --
632: TYPE EXT_ID_REC IS RECORD

Line 629: ,ext_cat_count NUMBER := FND_API.G_MISS_NUM

625: TYPE EXT_COUNT_REC IS RECORD
626: (
627: ext_count NUMBER := FND_API.G_MISS_NUM
628: ,ext_attr_count NUMBER := FND_API.G_MISS_NUM
629: ,ext_cat_count NUMBER := FND_API.G_MISS_NUM
630: );
631: --
632: TYPE EXT_ID_REC IS RECORD
633: (

Line 634: instance_id NUMBER := FND_API.G_MISS_NUM

630: );
631: --
632: TYPE EXT_ID_REC IS RECORD
633: (
634: instance_id NUMBER := FND_API.G_MISS_NUM
635: ,inv_item_id NUMBER := FND_API.G_MISS_NUM
636: ,inv_mast_org_id NUMBER := FND_API.G_MISS_NUM
637: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
638: );

Line 635: ,inv_item_id NUMBER := FND_API.G_MISS_NUM

631: --
632: TYPE EXT_ID_REC IS RECORD
633: (
634: instance_id NUMBER := FND_API.G_MISS_NUM
635: ,inv_item_id NUMBER := FND_API.G_MISS_NUM
636: ,inv_mast_org_id NUMBER := FND_API.G_MISS_NUM
637: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
638: );
639: TYPE EXT_ID_TBL IS TABLE OF EXT_ID_REC INDEX BY BINARY_INTEGER;

Line 636: ,inv_mast_org_id NUMBER := FND_API.G_MISS_NUM

632: TYPE EXT_ID_REC IS RECORD
633: (
634: instance_id NUMBER := FND_API.G_MISS_NUM
635: ,inv_item_id NUMBER := FND_API.G_MISS_NUM
636: ,inv_mast_org_id NUMBER := FND_API.G_MISS_NUM
637: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
638: );
639: TYPE EXT_ID_TBL IS TABLE OF EXT_ID_REC INDEX BY BINARY_INTEGER;
640: --

Line 637: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

633: (
634: instance_id NUMBER := FND_API.G_MISS_NUM
635: ,inv_item_id NUMBER := FND_API.G_MISS_NUM
636: ,inv_mast_org_id NUMBER := FND_API.G_MISS_NUM
637: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
638: );
639: TYPE EXT_ID_TBL IS TABLE OF EXT_ID_REC INDEX BY BINARY_INTEGER;
640: --
641: TYPE EXT_ATTR_REC IS RECORD

Line 643: instance_id NUMBER := FND_API.G_MISS_NUM

639: TYPE EXT_ID_TBL IS TABLE OF EXT_ID_REC INDEX BY BINARY_INTEGER;
640: --
641: TYPE EXT_ATTR_REC IS RECORD
642: (
643: instance_id NUMBER := FND_API.G_MISS_NUM
644: ,inv_item_id NUMBER := FND_API.G_MISS_NUM
645: ,inv_mast_org_id NUMBER := FND_API.G_MISS_NUM
646: ,attribute_id NUMBER := FND_API.G_MISS_NUM
647: ,attribute_level VARCHAR2(15) := FND_API.G_MISS_CHAR

Line 644: ,inv_item_id NUMBER := FND_API.G_MISS_NUM

640: --
641: TYPE EXT_ATTR_REC IS RECORD
642: (
643: instance_id NUMBER := FND_API.G_MISS_NUM
644: ,inv_item_id NUMBER := FND_API.G_MISS_NUM
645: ,inv_mast_org_id NUMBER := FND_API.G_MISS_NUM
646: ,attribute_id NUMBER := FND_API.G_MISS_NUM
647: ,attribute_level VARCHAR2(15) := FND_API.G_MISS_CHAR
648: ,item_category_id NUMBER := FND_API.G_MISS_NUM

Line 645: ,inv_mast_org_id NUMBER := FND_API.G_MISS_NUM

641: TYPE EXT_ATTR_REC IS RECORD
642: (
643: instance_id NUMBER := FND_API.G_MISS_NUM
644: ,inv_item_id NUMBER := FND_API.G_MISS_NUM
645: ,inv_mast_org_id NUMBER := FND_API.G_MISS_NUM
646: ,attribute_id NUMBER := FND_API.G_MISS_NUM
647: ,attribute_level VARCHAR2(15) := FND_API.G_MISS_CHAR
648: ,item_category_id NUMBER := FND_API.G_MISS_NUM
649: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 646: ,attribute_id NUMBER := FND_API.G_MISS_NUM

642: (
643: instance_id NUMBER := FND_API.G_MISS_NUM
644: ,inv_item_id NUMBER := FND_API.G_MISS_NUM
645: ,inv_mast_org_id NUMBER := FND_API.G_MISS_NUM
646: ,attribute_id NUMBER := FND_API.G_MISS_NUM
647: ,attribute_level VARCHAR2(15) := FND_API.G_MISS_CHAR
648: ,item_category_id NUMBER := FND_API.G_MISS_NUM
649: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
650: );

Line 647: ,attribute_level VARCHAR2(15) := FND_API.G_MISS_CHAR

643: instance_id NUMBER := FND_API.G_MISS_NUM
644: ,inv_item_id NUMBER := FND_API.G_MISS_NUM
645: ,inv_mast_org_id NUMBER := FND_API.G_MISS_NUM
646: ,attribute_id NUMBER := FND_API.G_MISS_NUM
647: ,attribute_level VARCHAR2(15) := FND_API.G_MISS_CHAR
648: ,item_category_id NUMBER := FND_API.G_MISS_NUM
649: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
650: );
651: TYPE EXT_ATTR_TBL IS TABLE OF EXT_ATTR_REC INDEX BY BINARY_INTEGER;

Line 648: ,item_category_id NUMBER := FND_API.G_MISS_NUM

644: ,inv_item_id NUMBER := FND_API.G_MISS_NUM
645: ,inv_mast_org_id NUMBER := FND_API.G_MISS_NUM
646: ,attribute_id NUMBER := FND_API.G_MISS_NUM
647: ,attribute_level VARCHAR2(15) := FND_API.G_MISS_CHAR
648: ,item_category_id NUMBER := FND_API.G_MISS_NUM
649: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
650: );
651: TYPE EXT_ATTR_TBL IS TABLE OF EXT_ATTR_REC INDEX BY BINARY_INTEGER;
652: --

Line 649: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

645: ,inv_mast_org_id NUMBER := FND_API.G_MISS_NUM
646: ,attribute_id NUMBER := FND_API.G_MISS_NUM
647: ,attribute_level VARCHAR2(15) := FND_API.G_MISS_CHAR
648: ,item_category_id NUMBER := FND_API.G_MISS_NUM
649: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
650: );
651: TYPE EXT_ATTR_TBL IS TABLE OF EXT_ATTR_REC INDEX BY BINARY_INTEGER;
652: --
653: TYPE EXT_CAT_REC IS RECORD

Line 655: inv_item_id NUMBER := FND_API.G_MISS_NUM

651: TYPE EXT_ATTR_TBL IS TABLE OF EXT_ATTR_REC INDEX BY BINARY_INTEGER;
652: --
653: TYPE EXT_CAT_REC IS RECORD
654: (
655: inv_item_id NUMBER := FND_API.G_MISS_NUM
656: ,inv_mast_org_id NUMBER := FND_API.G_MISS_NUM
657: ,item_cat_id NUMBER := FND_API.G_MISS_NUM
658: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
659: );

Line 656: ,inv_mast_org_id NUMBER := FND_API.G_MISS_NUM

652: --
653: TYPE EXT_CAT_REC IS RECORD
654: (
655: inv_item_id NUMBER := FND_API.G_MISS_NUM
656: ,inv_mast_org_id NUMBER := FND_API.G_MISS_NUM
657: ,item_cat_id NUMBER := FND_API.G_MISS_NUM
658: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
659: );
660: TYPE EXT_CAT_TBL IS TABLE OF EXT_CAT_REC INDEX BY BINARY_INTEGER;

Line 657: ,item_cat_id NUMBER := FND_API.G_MISS_NUM

653: TYPE EXT_CAT_REC IS RECORD
654: (
655: inv_item_id NUMBER := FND_API.G_MISS_NUM
656: ,inv_mast_org_id NUMBER := FND_API.G_MISS_NUM
657: ,item_cat_id NUMBER := FND_API.G_MISS_NUM
658: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
659: );
660: TYPE EXT_CAT_TBL IS TABLE OF EXT_CAT_REC INDEX BY BINARY_INTEGER;
661: --

Line 658: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

654: (
655: inv_item_id NUMBER := FND_API.G_MISS_NUM
656: ,inv_mast_org_id NUMBER := FND_API.G_MISS_NUM
657: ,item_cat_id NUMBER := FND_API.G_MISS_NUM
658: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
659: );
660: TYPE EXT_CAT_TBL IS TABLE OF EXT_CAT_REC INDEX BY BINARY_INTEGER;
661: --
662:

Line 751: ,p_commit IN VARCHAR2 := fnd_api.g_false

747: /*---------------------------------------------------*/
748:
749: PROCEDURE create_extended_attrib_values
750: ( p_api_version IN NUMBER
751: ,p_commit IN VARCHAR2 := fnd_api.g_false
752: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
753: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
754: ,p_ext_attrib_rec IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_rec
755: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

Line 752: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

748:
749: PROCEDURE create_extended_attrib_values
750: ( p_api_version IN NUMBER
751: ,p_commit IN VARCHAR2 := fnd_api.g_false
752: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
753: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
754: ,p_ext_attrib_rec IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_rec
755: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
756: ,x_return_status OUT NOCOPY VARCHAR2

Line 753: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

749: PROCEDURE create_extended_attrib_values
750: ( p_api_version IN NUMBER
751: ,p_commit IN VARCHAR2 := fnd_api.g_false
752: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
753: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
754: ,p_ext_attrib_rec IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_rec
755: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
756: ,x_return_status OUT NOCOPY VARCHAR2
757: ,x_msg_count OUT NOCOPY NUMBER

Line 763: ,p_called_from_grp IN VARCHAR2 DEFAULT fnd_api.g_false

759: ,p_ext_id_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_id_tbl
760: ,p_ext_count_rec IN OUT NOCOPY csi_item_instance_pvt.ext_count_rec
761: ,p_ext_attr_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_attr_tbl
762: ,p_ext_cat_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_cat_tbl
763: ,p_called_from_grp IN VARCHAR2 DEFAULT fnd_api.g_false
764: );
765:
766: /*---------------------------------------------------*/
767: /* procedure name: update_extended_attrib_values */

Line 775: ,p_commit IN VARCHAR2 := fnd_api.g_false

771: /*---------------------------------------------------*/
772:
773: PROCEDURE update_extended_attrib_values
774: ( p_api_version IN NUMBER
775: ,p_commit IN VARCHAR2 := fnd_api.g_false
776: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
777: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
778: ,p_ext_attrib_rec IN csi_datastructures_pub.extend_attrib_values_rec
779: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

Line 776: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

772:
773: PROCEDURE update_extended_attrib_values
774: ( p_api_version IN NUMBER
775: ,p_commit IN VARCHAR2 := fnd_api.g_false
776: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
777: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
778: ,p_ext_attrib_rec IN csi_datastructures_pub.extend_attrib_values_rec
779: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
780: ,x_return_status OUT NOCOPY VARCHAR2

Line 777: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

773: PROCEDURE update_extended_attrib_values
774: ( p_api_version IN NUMBER
775: ,p_commit IN VARCHAR2 := fnd_api.g_false
776: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
777: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
778: ,p_ext_attrib_rec IN csi_datastructures_pub.extend_attrib_values_rec
779: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
780: ,x_return_status OUT NOCOPY VARCHAR2
781: ,x_msg_count OUT NOCOPY NUMBER

Line 794: ,p_commit IN VARCHAR2 := fnd_api.g_false

790: /*---------------------------------------------------*/
791:
792: PROCEDURE expire_extended_attrib_values
793: ( p_api_version IN NUMBER
794: ,p_commit IN VARCHAR2 := fnd_api.g_false
795: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
796: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
797: ,p_ext_attrib_rec IN csi_datastructures_pub.extend_attrib_values_rec
798: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

Line 795: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

791:
792: PROCEDURE expire_extended_attrib_values
793: ( p_api_version IN NUMBER
794: ,p_commit IN VARCHAR2 := fnd_api.g_false
795: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
796: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
797: ,p_ext_attrib_rec IN csi_datastructures_pub.extend_attrib_values_rec
798: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
799: ,x_return_status OUT NOCOPY VARCHAR2

Line 796: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

792: PROCEDURE expire_extended_attrib_values
793: ( p_api_version IN NUMBER
794: ,p_commit IN VARCHAR2 := fnd_api.g_false
795: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
796: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
797: ,p_ext_attrib_rec IN csi_datastructures_pub.extend_attrib_values_rec
798: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
799: ,x_return_status OUT NOCOPY VARCHAR2
800: ,x_msg_count OUT NOCOPY NUMBER

Line 813: ,p_commit IN VARCHAR2 := fnd_api.g_false

809:
810: PROCEDURE copy_single_item_instance
811: (
812: p_api_version IN NUMBER
813: ,p_commit IN VARCHAR2 := fnd_api.g_false
814: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
815: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
816: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
817: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false

Line 814: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

810: PROCEDURE copy_single_item_instance
811: (
812: p_api_version IN NUMBER
813: ,p_commit IN VARCHAR2 := fnd_api.g_false
814: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
815: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
816: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
817: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
818: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false

Line 815: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

811: (
812: p_api_version IN NUMBER
813: ,p_commit IN VARCHAR2 := fnd_api.g_false
814: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
815: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
816: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
817: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
818: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
819: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false

Line 817: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false

813: ,p_commit IN VARCHAR2 := fnd_api.g_false
814: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
815: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
816: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
817: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
818: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
819: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
820: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false
821: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false

Line 818: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false

814: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
815: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
816: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
817: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
818: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
819: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
820: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false
821: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
822: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false

Line 819: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false

815: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
816: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
817: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
818: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
819: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
820: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false
821: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
822: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
823: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false

Line 820: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false

816: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
817: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
818: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
819: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
820: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false
821: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
822: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
823: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
824: ,p_call_from_split IN VARCHAR2 := fnd_api.g_false

Line 821: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false

817: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
818: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
819: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
820: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false
821: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
822: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
823: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
824: ,p_call_from_split IN VARCHAR2 := fnd_api.g_false
825: ,p_call_from_bom_expl IN VARCHAR2 DEFAULT fnd_api.g_false -- should be passed only from Explode BOM

Line 822: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false

818: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
819: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
820: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false
821: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
822: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
823: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
824: ,p_call_from_split IN VARCHAR2 := fnd_api.g_false
825: ,p_call_from_bom_expl IN VARCHAR2 DEFAULT fnd_api.g_false -- should be passed only from Explode BOM
826: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

Line 823: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false

819: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
820: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false
821: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
822: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
823: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
824: ,p_call_from_split IN VARCHAR2 := fnd_api.g_false
825: ,p_call_from_bom_expl IN VARCHAR2 DEFAULT fnd_api.g_false -- should be passed only from Explode BOM
826: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
827: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl

Line 824: ,p_call_from_split IN VARCHAR2 := fnd_api.g_false

820: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false
821: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
822: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
823: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
824: ,p_call_from_split IN VARCHAR2 := fnd_api.g_false
825: ,p_call_from_bom_expl IN VARCHAR2 DEFAULT fnd_api.g_false -- should be passed only from Explode BOM
826: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
827: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
828: ,x_return_status OUT NOCOPY VARCHAR2

Line 825: ,p_call_from_bom_expl IN VARCHAR2 DEFAULT fnd_api.g_false -- should be passed only from Explode BOM

821: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
822: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
823: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
824: ,p_call_from_split IN VARCHAR2 := fnd_api.g_false
825: ,p_call_from_bom_expl IN VARCHAR2 DEFAULT fnd_api.g_false -- should be passed only from Explode BOM
826: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
827: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
828: ,x_return_status OUT NOCOPY VARCHAR2
829: ,x_msg_count OUT NOCOPY NUMBER

Line 845: ,p_commit IN VARCHAR2 := fnd_api.g_false

841:
842: PROCEDURE Explode_Bom
843: (
844: p_api_version IN NUMBER
845: ,p_commit IN VARCHAR2 := fnd_api.g_false
846: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
847: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
848: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
849: ,p_explosion_level IN NUMBER

Line 846: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

842: PROCEDURE Explode_Bom
843: (
844: p_api_version IN NUMBER
845: ,p_commit IN VARCHAR2 := fnd_api.g_false
846: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
847: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
848: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
849: ,p_explosion_level IN NUMBER
850: ,p_item_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl

Line 847: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

843: (
844: p_api_version IN NUMBER
845: ,p_commit IN VARCHAR2 := fnd_api.g_false
846: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
847: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
848: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
849: ,p_explosion_level IN NUMBER
850: ,p_item_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
851: ,p_item_relation_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl

Line 852: ,p_create_instance IN VARCHAR2 DEFAULT FND_API.G_FALSE

848: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
849: ,p_explosion_level IN NUMBER
850: ,p_item_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
851: ,p_item_relation_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
852: ,p_create_instance IN VARCHAR2 DEFAULT FND_API.G_FALSE
853: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
854: ,x_return_status OUT NOCOPY VARCHAR2
855: ,x_msg_count OUT NOCOPY NUMBER
856: ,x_msg_data OUT NOCOPY VARCHAR2

Line 867: ,p_commit IN VARCHAR2 := fnd_api.g_false

863: /*---------------------------------------------------*/
864:
865: PROCEDURE get_instance_hist
866: ( p_api_version IN NUMBER
867: ,p_commit IN VARCHAR2 := fnd_api.g_false
868: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
869: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
870: ,p_transaction_id IN NUMBER
871: ,x_instance_history_tbl OUT NOCOPY csi_datastructures_pub.instance_history_tbl

Line 868: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

864:
865: PROCEDURE get_instance_hist
866: ( p_api_version IN NUMBER
867: ,p_commit IN VARCHAR2 := fnd_api.g_false
868: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
869: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
870: ,p_transaction_id IN NUMBER
871: ,x_instance_history_tbl OUT NOCOPY csi_datastructures_pub.instance_history_tbl
872: ,x_return_status OUT NOCOPY VARCHAR2

Line 869: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

865: PROCEDURE get_instance_hist
866: ( p_api_version IN NUMBER
867: ,p_commit IN VARCHAR2 := fnd_api.g_false
868: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
869: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
870: ,p_transaction_id IN NUMBER
871: ,x_instance_history_tbl OUT NOCOPY csi_datastructures_pub.instance_history_tbl
872: ,x_return_status OUT NOCOPY VARCHAR2
873: ,x_msg_count OUT NOCOPY NUMBER

Line 892: ,p_transaction_date IN DATE := fnd_api.g_miss_date

888: ,p_vld_org_id IN NUMBER
889: ,p_quantity IN NUMBER
890: ,p_party_account_id1 IN NUMBER
891: ,p_party_account_id2 IN NUMBER
892: ,p_transaction_date IN DATE := fnd_api.g_miss_date
893: ,p_source_transaction_date IN DATE := fnd_api.g_miss_date -- Added by jpwilson
894: ,p_transaction_id IN NUMBER := fnd_api.g_miss_num -- Added by sguthiva for TRF(HTML)
895: ,p_grp_call_contracts IN VARCHAR2 DEFAULT fnd_api.g_false
896: ,p_txn_type_id IN NUMBER DEFAULT fnd_api.g_miss_num

Line 893: ,p_source_transaction_date IN DATE := fnd_api.g_miss_date -- Added by jpwilson

889: ,p_quantity IN NUMBER
890: ,p_party_account_id1 IN NUMBER
891: ,p_party_account_id2 IN NUMBER
892: ,p_transaction_date IN DATE := fnd_api.g_miss_date
893: ,p_source_transaction_date IN DATE := fnd_api.g_miss_date -- Added by jpwilson
894: ,p_transaction_id IN NUMBER := fnd_api.g_miss_num -- Added by sguthiva for TRF(HTML)
895: ,p_grp_call_contracts IN VARCHAR2 DEFAULT fnd_api.g_false
896: ,p_txn_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
897: ,p_system_id IN NUMBER DEFAULT fnd_api.g_miss_num -- OKS Enhancement

Line 894: ,p_transaction_id IN NUMBER := fnd_api.g_miss_num -- Added by sguthiva for TRF(HTML)

890: ,p_party_account_id1 IN NUMBER
891: ,p_party_account_id2 IN NUMBER
892: ,p_transaction_date IN DATE := fnd_api.g_miss_date
893: ,p_source_transaction_date IN DATE := fnd_api.g_miss_date -- Added by jpwilson
894: ,p_transaction_id IN NUMBER := fnd_api.g_miss_num -- Added by sguthiva for TRF(HTML)
895: ,p_grp_call_contracts IN VARCHAR2 DEFAULT fnd_api.g_false
896: ,p_txn_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
897: ,p_system_id IN NUMBER DEFAULT fnd_api.g_miss_num -- OKS Enhancement
898: ,p_order_line_id IN NUMBER DEFAULT fnd_api.g_miss_num -- should be passed only when un-expiring an Instance

Line 895: ,p_grp_call_contracts IN VARCHAR2 DEFAULT fnd_api.g_false

891: ,p_party_account_id2 IN NUMBER
892: ,p_transaction_date IN DATE := fnd_api.g_miss_date
893: ,p_source_transaction_date IN DATE := fnd_api.g_miss_date -- Added by jpwilson
894: ,p_transaction_id IN NUMBER := fnd_api.g_miss_num -- Added by sguthiva for TRF(HTML)
895: ,p_grp_call_contracts IN VARCHAR2 DEFAULT fnd_api.g_false
896: ,p_txn_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
897: ,p_system_id IN NUMBER DEFAULT fnd_api.g_miss_num -- OKS Enhancement
898: ,p_order_line_id IN NUMBER DEFAULT fnd_api.g_miss_num -- should be passed only when un-expiring an Instance
899: ,p_call_from_bom_expl IN VARCHAR2 DEFAULT fnd_api.g_false

Line 896: ,p_txn_type_id IN NUMBER DEFAULT fnd_api.g_miss_num

892: ,p_transaction_date IN DATE := fnd_api.g_miss_date
893: ,p_source_transaction_date IN DATE := fnd_api.g_miss_date -- Added by jpwilson
894: ,p_transaction_id IN NUMBER := fnd_api.g_miss_num -- Added by sguthiva for TRF(HTML)
895: ,p_grp_call_contracts IN VARCHAR2 DEFAULT fnd_api.g_false
896: ,p_txn_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
897: ,p_system_id IN NUMBER DEFAULT fnd_api.g_miss_num -- OKS Enhancement
898: ,p_order_line_id IN NUMBER DEFAULT fnd_api.g_miss_num -- should be passed only when un-expiring an Instance
899: ,p_call_from_bom_expl IN VARCHAR2 DEFAULT fnd_api.g_false
900: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl

Line 897: ,p_system_id IN NUMBER DEFAULT fnd_api.g_miss_num -- OKS Enhancement

893: ,p_source_transaction_date IN DATE := fnd_api.g_miss_date -- Added by jpwilson
894: ,p_transaction_id IN NUMBER := fnd_api.g_miss_num -- Added by sguthiva for TRF(HTML)
895: ,p_grp_call_contracts IN VARCHAR2 DEFAULT fnd_api.g_false
896: ,p_txn_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
897: ,p_system_id IN NUMBER DEFAULT fnd_api.g_miss_num -- OKS Enhancement
898: ,p_order_line_id IN NUMBER DEFAULT fnd_api.g_miss_num -- should be passed only when un-expiring an Instance
899: ,p_call_from_bom_expl IN VARCHAR2 DEFAULT fnd_api.g_false
900: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
901: ,x_return_status OUT NOCOPY VARCHAR2

Line 898: ,p_order_line_id IN NUMBER DEFAULT fnd_api.g_miss_num -- should be passed only when un-expiring an Instance

894: ,p_transaction_id IN NUMBER := fnd_api.g_miss_num -- Added by sguthiva for TRF(HTML)
895: ,p_grp_call_contracts IN VARCHAR2 DEFAULT fnd_api.g_false
896: ,p_txn_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
897: ,p_system_id IN NUMBER DEFAULT fnd_api.g_miss_num -- OKS Enhancement
898: ,p_order_line_id IN NUMBER DEFAULT fnd_api.g_miss_num -- should be passed only when un-expiring an Instance
899: ,p_call_from_bom_expl IN VARCHAR2 DEFAULT fnd_api.g_false
900: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
901: ,x_return_status OUT NOCOPY VARCHAR2
902: ,x_msg_count OUT NOCOPY NUMBER

Line 899: ,p_call_from_bom_expl IN VARCHAR2 DEFAULT fnd_api.g_false

895: ,p_grp_call_contracts IN VARCHAR2 DEFAULT fnd_api.g_false
896: ,p_txn_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
897: ,p_system_id IN NUMBER DEFAULT fnd_api.g_miss_num -- OKS Enhancement
898: ,p_order_line_id IN NUMBER DEFAULT fnd_api.g_miss_num -- should be passed only when un-expiring an Instance
899: ,p_call_from_bom_expl IN VARCHAR2 DEFAULT fnd_api.g_false
900: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
901: ,x_return_status OUT NOCOPY VARCHAR2
902: ,x_msg_count OUT NOCOPY NUMBER
903: ,x_msg_data OUT NOCOPY VARCHAR2

Line 914: ,p_commit IN VARCHAR2 := fnd_api.g_false

910: /*---------------------------------------------------*/
911:
912: PROCEDURE get_ext_attrib_val_hist
913: ( p_api_version IN NUMBER
914: ,p_commit IN VARCHAR2 := fnd_api.g_false
915: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
916: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
917: ,p_transaction_id IN NUMBER
918: ,x_ext_attrib_val_hist_tbl OUT NOCOPY csi_datastructures_pub.ext_attrib_val_history_tbl

Line 915: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

911:
912: PROCEDURE get_ext_attrib_val_hist
913: ( p_api_version IN NUMBER
914: ,p_commit IN VARCHAR2 := fnd_api.g_false
915: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
916: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
917: ,p_transaction_id IN NUMBER
918: ,x_ext_attrib_val_hist_tbl OUT NOCOPY csi_datastructures_pub.ext_attrib_val_history_tbl
919: ,x_return_status OUT NOCOPY VARCHAR2

Line 916: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

912: PROCEDURE get_ext_attrib_val_hist
913: ( p_api_version IN NUMBER
914: ,p_commit IN VARCHAR2 := fnd_api.g_false
915: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
916: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
917: ,p_transaction_id IN NUMBER
918: ,x_ext_attrib_val_hist_tbl OUT NOCOPY csi_datastructures_pub.ext_attrib_val_history_tbl
919: ,x_return_status OUT NOCOPY VARCHAR2
920: ,x_msg_count OUT NOCOPY NUMBER

Line 933: ,p_commit IN VARCHAR2 := fnd_api.g_false

929:
930:
931: PROCEDURE copy_item_instance
932: ( p_api_version IN NUMBER
933: ,p_commit IN VARCHAR2 := fnd_api.g_false
934: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
935: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
936: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
937: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false

Line 934: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

930:
931: PROCEDURE copy_item_instance
932: ( p_api_version IN NUMBER
933: ,p_commit IN VARCHAR2 := fnd_api.g_false
934: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
935: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
936: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
937: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
938: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false

Line 935: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

931: PROCEDURE copy_item_instance
932: ( p_api_version IN NUMBER
933: ,p_commit IN VARCHAR2 := fnd_api.g_false
934: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
935: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
936: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
937: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
938: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
939: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false

Line 937: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false

933: ,p_commit IN VARCHAR2 := fnd_api.g_false
934: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
935: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
936: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
937: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
938: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
939: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
940: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false
941: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false

Line 938: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false

934: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
935: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
936: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
937: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
938: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
939: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
940: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false
941: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
942: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false

Line 939: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false

935: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
936: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
937: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
938: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
939: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
940: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false
941: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
942: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
943: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false

Line 940: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false

936: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
937: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
938: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
939: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
940: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false
941: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
942: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
943: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
944: ,p_copy_inst_children IN VARCHAR2 := fnd_api.g_false

Line 941: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false

937: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
938: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
939: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
940: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false
941: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
942: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
943: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
944: ,p_copy_inst_children IN VARCHAR2 := fnd_api.g_false
945: ,p_call_from_split IN VARCHAR2 := fnd_api.g_false

Line 942: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false

938: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
939: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
940: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false
941: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
942: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
943: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
944: ,p_copy_inst_children IN VARCHAR2 := fnd_api.g_false
945: ,p_call_from_split IN VARCHAR2 := fnd_api.g_false
946: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

Line 943: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false

939: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
940: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false
941: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
942: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
943: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
944: ,p_copy_inst_children IN VARCHAR2 := fnd_api.g_false
945: ,p_call_from_split IN VARCHAR2 := fnd_api.g_false
946: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
947: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl

Line 944: ,p_copy_inst_children IN VARCHAR2 := fnd_api.g_false

940: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false
941: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
942: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
943: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
944: ,p_copy_inst_children IN VARCHAR2 := fnd_api.g_false
945: ,p_call_from_split IN VARCHAR2 := fnd_api.g_false
946: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
947: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
948: ,x_return_status OUT NOCOPY VARCHAR2

Line 945: ,p_call_from_split IN VARCHAR2 := fnd_api.g_false

941: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
942: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
943: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
944: ,p_copy_inst_children IN VARCHAR2 := fnd_api.g_false
945: ,p_call_from_split IN VARCHAR2 := fnd_api.g_false
946: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
947: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
948: ,x_return_status OUT NOCOPY VARCHAR2
949: ,x_msg_count OUT NOCOPY NUMBER

Line 963: ,p_commit IN VARCHAR2 := fnd_api.g_false

959: /*------------------------------------------------------------*/
960:
961: PROCEDURE get_version_label_history
962: ( p_api_version IN NUMBER
963: ,p_commit IN VARCHAR2 := fnd_api.g_false
964: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
965: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
966: ,p_transaction_id IN NUMBER
967: ,x_version_label_hist_tbl OUT NOCOPY csi_datastructures_pub.version_label_history_tbl

Line 964: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

960:
961: PROCEDURE get_version_label_history
962: ( p_api_version IN NUMBER
963: ,p_commit IN VARCHAR2 := fnd_api.g_false
964: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
965: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
966: ,p_transaction_id IN NUMBER
967: ,x_version_label_hist_tbl OUT NOCOPY csi_datastructures_pub.version_label_history_tbl
968: ,x_return_status OUT NOCOPY VARCHAR2

Line 965: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

961: PROCEDURE get_version_label_history
962: ( p_api_version IN NUMBER
963: ,p_commit IN VARCHAR2 := fnd_api.g_false
964: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
965: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
966: ,p_transaction_id IN NUMBER
967: ,x_version_label_hist_tbl OUT NOCOPY csi_datastructures_pub.version_label_history_tbl
968: ,x_return_status OUT NOCOPY VARCHAR2
969: ,x_msg_count OUT NOCOPY NUMBER

Line 982: ,p_commit IN VARCHAR2 := fnd_api.g_false

978:
979: PROCEDURE get_instance_link_locations
980: (
981: p_api_version IN NUMBER
982: ,p_commit IN VARCHAR2 := fnd_api.g_false
983: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
984: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
985: ,p_instance_id IN NUMBER
986: ,x_instance_link_rec OUT NOCOPY csi_datastructures_pub.instance_link_rec

Line 983: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

979: PROCEDURE get_instance_link_locations
980: (
981: p_api_version IN NUMBER
982: ,p_commit IN VARCHAR2 := fnd_api.g_false
983: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
984: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
985: ,p_instance_id IN NUMBER
986: ,x_instance_link_rec OUT NOCOPY csi_datastructures_pub.instance_link_rec
987: ,x_return_status OUT NOCOPY VARCHAR2

Line 984: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

980: (
981: p_api_version IN NUMBER
982: ,p_commit IN VARCHAR2 := fnd_api.g_false
983: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
984: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
985: ,p_instance_id IN NUMBER
986: ,x_instance_link_rec OUT NOCOPY csi_datastructures_pub.instance_link_rec
987: ,x_return_status OUT NOCOPY VARCHAR2
988: ,x_msg_count OUT NOCOPY NUMBER

Line 995: ,p_commit IN VARCHAR2 := fnd_api.g_false

991:
992: PROCEDURE Update_version_time
993: (
994: p_api_version IN NUMBER
995: ,p_commit IN VARCHAR2 := fnd_api.g_false
996: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
997: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
998: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
999: ,x_return_status OUT NOCOPY VARCHAR2

Line 996: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

992: PROCEDURE Update_version_time
993: (
994: p_api_version IN NUMBER
995: ,p_commit IN VARCHAR2 := fnd_api.g_false
996: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
997: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
998: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
999: ,x_return_status OUT NOCOPY VARCHAR2
1000: ,x_msg_count OUT NOCOPY NUMBER

Line 997: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

993: (
994: p_api_version IN NUMBER
995: ,p_commit IN VARCHAR2 := fnd_api.g_false
996: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
997: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
998: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
999: ,x_return_status OUT NOCOPY VARCHAR2
1000: ,x_msg_count OUT NOCOPY NUMBER
1001: ,x_msg_data OUT NOCOPY VARCHAR2);