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 281: ,p_commit IN VARCHAR2 := fnd_api.g_false

277:
278: PROCEDURE expire_item_instance
279: (
280: p_api_version IN NUMBER
281: ,p_commit IN VARCHAR2 := fnd_api.g_false
282: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
283: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
284: ,p_instance_rec IN csi_datastructures_pub.instance_rec
285: ,p_expire_children IN VARCHAR2 := fnd_api.g_false

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

278: PROCEDURE expire_item_instance
279: (
280: p_api_version IN NUMBER
281: ,p_commit IN VARCHAR2 := fnd_api.g_false
282: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
283: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
284: ,p_instance_rec IN csi_datastructures_pub.instance_rec
285: ,p_expire_children IN VARCHAR2 := fnd_api.g_false
286: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

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

279: (
280: p_api_version IN NUMBER
281: ,p_commit IN VARCHAR2 := fnd_api.g_false
282: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
283: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
284: ,p_instance_rec IN csi_datastructures_pub.instance_rec
285: ,p_expire_children IN VARCHAR2 := fnd_api.g_false
286: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
287: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl

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

281: ,p_commit IN VARCHAR2 := fnd_api.g_false
282: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
283: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
284: ,p_instance_rec IN csi_datastructures_pub.instance_rec
285: ,p_expire_children IN VARCHAR2 := fnd_api.g_false
286: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
287: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
288: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
289: ,x_return_status OUT NOCOPY VARCHAR2

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

429: /*----------------------------------------------------*/
430:
431: PROCEDURE get_and_update_acct_class
432: ( p_api_version IN NUMBER
433: ,p_commit IN VARCHAR2 := fnd_api.g_false
434: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
435: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
436: ,p_instance_id IN NUMBER
437: ,p_instance_expiry_flag IN VARCHAR2 := fnd_api.g_true

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

430:
431: PROCEDURE get_and_update_acct_class
432: ( p_api_version IN NUMBER
433: ,p_commit IN VARCHAR2 := fnd_api.g_false
434: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
435: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
436: ,p_instance_id IN NUMBER
437: ,p_instance_expiry_flag IN VARCHAR2 := fnd_api.g_true
438: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

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

431: PROCEDURE get_and_update_acct_class
432: ( p_api_version IN NUMBER
433: ,p_commit IN VARCHAR2 := fnd_api.g_false
434: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
435: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
436: ,p_instance_id IN NUMBER
437: ,p_instance_expiry_flag IN VARCHAR2 := fnd_api.g_true
438: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
439: ,x_acct_class_code OUT NOCOPY VARCHAR2

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

433: ,p_commit IN VARCHAR2 := fnd_api.g_false
434: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
435: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
436: ,p_instance_id IN NUMBER
437: ,p_instance_expiry_flag IN VARCHAR2 := fnd_api.g_true
438: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
439: ,x_acct_class_code OUT NOCOPY VARCHAR2
440: ,x_return_status OUT NOCOPY VARCHAR2
441: ,x_msg_count OUT NOCOPY NUMBER

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

462:
463: PROCEDURE Split_Item_Instance
464: (
465: p_api_version IN NUMBER
466: ,p_commit IN VARCHAR2 := fnd_api.g_false
467: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
468: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
469: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
470: ,p_quantity1 IN NUMBER

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

463: PROCEDURE Split_Item_Instance
464: (
465: p_api_version IN NUMBER
466: ,p_commit IN VARCHAR2 := fnd_api.g_false
467: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
468: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
469: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
470: ,p_quantity1 IN NUMBER
471: ,p_quantity2 IN NUMBER

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

464: (
465: p_api_version IN NUMBER
466: ,p_commit IN VARCHAR2 := fnd_api.g_false
467: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
468: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
469: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
470: ,p_quantity1 IN NUMBER
471: ,p_quantity2 IN NUMBER
472: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true

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

468: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
469: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
470: ,p_quantity1 IN NUMBER
471: ,p_quantity2 IN NUMBER
472: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true
473: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true
474: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true
475: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
476: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true

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

469: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
470: ,p_quantity1 IN NUMBER
471: ,p_quantity2 IN NUMBER
472: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true
473: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true
474: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true
475: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
476: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
477: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true

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

470: ,p_quantity1 IN NUMBER
471: ,p_quantity2 IN NUMBER
472: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true
473: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true
474: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true
475: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
476: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
477: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true
478: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_true

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

471: ,p_quantity2 IN NUMBER
472: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true
473: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true
474: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true
475: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
476: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
477: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true
478: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_true
479: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

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

472: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true
473: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true
474: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true
475: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
476: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
477: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true
478: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_true
479: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
480: ,x_new_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec

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

473: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true
474: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true
475: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
476: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
477: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true
478: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_true
479: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
480: ,x_new_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
481: ,x_return_status OUT NOCOPY VARCHAR2

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

474: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true
475: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
476: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
477: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true
478: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_true
479: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
480: ,x_new_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
481: ,x_return_status OUT NOCOPY VARCHAR2
482: ,x_msg_count OUT NOCOPY NUMBER

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

490: /*---------------------------------------------------*/
491: PROCEDURE Split_Item_Instance_Lines
492: (
493: p_api_version IN NUMBER
494: ,p_commit IN VARCHAR2 := fnd_api.g_false
495: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
496: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
497: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
498: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true

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

491: PROCEDURE Split_Item_Instance_Lines
492: (
493: p_api_version IN NUMBER
494: ,p_commit IN VARCHAR2 := fnd_api.g_false
495: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
496: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
497: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
498: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true
499: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true

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

492: (
493: p_api_version IN NUMBER
494: ,p_commit IN VARCHAR2 := fnd_api.g_false
495: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
496: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
497: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
498: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true
499: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true
500: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true

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

494: ,p_commit IN VARCHAR2 := fnd_api.g_false
495: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
496: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
497: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
498: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true
499: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true
500: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true
501: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
502: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true

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

495: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
496: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
497: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
498: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true
499: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true
500: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true
501: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
502: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
503: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true

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

496: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
497: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
498: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true
499: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true
500: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true
501: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
502: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
503: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true
504: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_true

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

497: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
498: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true
499: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true
500: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true
501: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
502: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
503: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true
504: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_true
505: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

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

498: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true
499: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true
500: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true
501: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
502: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
503: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true
504: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_true
505: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
506: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl

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

499: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true
500: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true
501: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
502: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
503: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true
504: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_true
505: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
506: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
507: ,x_return_status OUT NOCOPY VARCHAR2

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

500: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true
501: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
502: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
503: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true
504: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_true
505: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
506: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
507: ,x_return_status OUT NOCOPY VARCHAR2
508: ,x_msg_count OUT NOCOPY NUMBER

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

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

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

596:
597: PROCEDURE create_version_label
598: ( p_api_version IN NUMBER
599: ,p_commit IN VARCHAR2 := fnd_api.g_false
600: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
601: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
602: ,p_version_label_rec IN OUT NOCOPY csi_datastructures_pub.version_label_rec
603: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
604: ,x_return_status OUT NOCOPY VARCHAR2

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

597: PROCEDURE create_version_label
598: ( p_api_version IN NUMBER
599: ,p_commit IN VARCHAR2 := fnd_api.g_false
600: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
601: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
602: ,p_version_label_rec IN OUT NOCOPY csi_datastructures_pub.version_label_rec
603: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
604: ,x_return_status OUT NOCOPY VARCHAR2
605: ,x_msg_count OUT NOCOPY NUMBER

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

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

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

614:
615: PROCEDURE update_version_label
616: ( p_api_version IN NUMBER
617: ,p_commit IN VARCHAR2 := fnd_api.g_false
618: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
619: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
620: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec
621: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
622: ,p_call_transaction IN VARCHAR2 := fnd_api.g_true

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

615: PROCEDURE update_version_label
616: ( p_api_version IN NUMBER
617: ,p_commit IN VARCHAR2 := fnd_api.g_false
618: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
619: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
620: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec
621: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
622: ,p_call_transaction IN VARCHAR2 := fnd_api.g_true
623: ,x_return_status OUT NOCOPY VARCHAR2

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

618: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
619: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
620: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec
621: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
622: ,p_call_transaction IN VARCHAR2 := fnd_api.g_true
623: ,x_return_status OUT NOCOPY VARCHAR2
624: ,x_msg_count OUT NOCOPY NUMBER
625: ,x_msg_data OUT NOCOPY VARCHAR2 );
626:

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

632: /*---------------------------------------------------*/
633:
634: PROCEDURE expire_version_label
635: ( p_api_version IN NUMBER
636: ,p_commit IN VARCHAR2 := fnd_api.g_false
637: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
638: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
639: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec
640: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

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

633:
634: PROCEDURE expire_version_label
635: ( p_api_version IN NUMBER
636: ,p_commit IN VARCHAR2 := fnd_api.g_false
637: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
638: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
639: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec
640: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
641: ,x_return_status OUT NOCOPY VARCHAR2

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

634: PROCEDURE expire_version_label
635: ( p_api_version IN NUMBER
636: ,p_commit IN VARCHAR2 := fnd_api.g_false
637: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
638: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
639: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec
640: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
641: ,x_return_status OUT NOCOPY VARCHAR2
642: ,x_msg_count OUT NOCOPY NUMBER

Line 648: ext_count NUMBER := FND_API.G_MISS_NUM

644:
645: --
646: TYPE EXT_COUNT_REC IS RECORD
647: (
648: ext_count NUMBER := FND_API.G_MISS_NUM
649: ,ext_attr_count NUMBER := FND_API.G_MISS_NUM
650: ,ext_cat_count NUMBER := FND_API.G_MISS_NUM
651: );
652: --

Line 649: ,ext_attr_count NUMBER := FND_API.G_MISS_NUM

645: --
646: TYPE EXT_COUNT_REC IS RECORD
647: (
648: ext_count NUMBER := FND_API.G_MISS_NUM
649: ,ext_attr_count NUMBER := FND_API.G_MISS_NUM
650: ,ext_cat_count NUMBER := FND_API.G_MISS_NUM
651: );
652: --
653: TYPE EXT_ID_REC IS RECORD

Line 650: ,ext_cat_count NUMBER := FND_API.G_MISS_NUM

646: TYPE EXT_COUNT_REC IS RECORD
647: (
648: ext_count NUMBER := FND_API.G_MISS_NUM
649: ,ext_attr_count NUMBER := FND_API.G_MISS_NUM
650: ,ext_cat_count NUMBER := FND_API.G_MISS_NUM
651: );
652: --
653: TYPE EXT_ID_REC IS RECORD
654: (

Line 655: instance_id NUMBER := FND_API.G_MISS_NUM

651: );
652: --
653: TYPE EXT_ID_REC IS RECORD
654: (
655: instance_id NUMBER := FND_API.G_MISS_NUM
656: ,inv_item_id NUMBER := FND_API.G_MISS_NUM
657: ,inv_mast_org_id NUMBER := FND_API.G_MISS_NUM
658: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
659: );

Line 656: ,inv_item_id NUMBER := FND_API.G_MISS_NUM

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

Line 657: ,inv_mast_org_id NUMBER := FND_API.G_MISS_NUM

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

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

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

Line 664: instance_id NUMBER := FND_API.G_MISS_NUM

660: TYPE EXT_ID_TBL IS TABLE OF EXT_ID_REC INDEX BY BINARY_INTEGER;
661: --
662: TYPE EXT_ATTR_REC IS RECORD
663: (
664: instance_id NUMBER := FND_API.G_MISS_NUM
665: ,inv_item_id NUMBER := FND_API.G_MISS_NUM
666: ,inv_mast_org_id NUMBER := FND_API.G_MISS_NUM
667: ,attribute_id NUMBER := FND_API.G_MISS_NUM
668: ,attribute_level VARCHAR2(15) := FND_API.G_MISS_CHAR

Line 665: ,inv_item_id NUMBER := FND_API.G_MISS_NUM

661: --
662: TYPE EXT_ATTR_REC IS RECORD
663: (
664: instance_id NUMBER := FND_API.G_MISS_NUM
665: ,inv_item_id NUMBER := FND_API.G_MISS_NUM
666: ,inv_mast_org_id NUMBER := FND_API.G_MISS_NUM
667: ,attribute_id NUMBER := FND_API.G_MISS_NUM
668: ,attribute_level VARCHAR2(15) := FND_API.G_MISS_CHAR
669: ,item_category_id NUMBER := FND_API.G_MISS_NUM

Line 666: ,inv_mast_org_id NUMBER := FND_API.G_MISS_NUM

662: TYPE EXT_ATTR_REC IS RECORD
663: (
664: instance_id NUMBER := FND_API.G_MISS_NUM
665: ,inv_item_id NUMBER := FND_API.G_MISS_NUM
666: ,inv_mast_org_id NUMBER := FND_API.G_MISS_NUM
667: ,attribute_id NUMBER := FND_API.G_MISS_NUM
668: ,attribute_level VARCHAR2(15) := FND_API.G_MISS_CHAR
669: ,item_category_id NUMBER := FND_API.G_MISS_NUM
670: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 667: ,attribute_id NUMBER := FND_API.G_MISS_NUM

663: (
664: instance_id NUMBER := FND_API.G_MISS_NUM
665: ,inv_item_id NUMBER := FND_API.G_MISS_NUM
666: ,inv_mast_org_id NUMBER := FND_API.G_MISS_NUM
667: ,attribute_id NUMBER := FND_API.G_MISS_NUM
668: ,attribute_level VARCHAR2(15) := FND_API.G_MISS_CHAR
669: ,item_category_id NUMBER := FND_API.G_MISS_NUM
670: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
671: );

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

664: instance_id NUMBER := FND_API.G_MISS_NUM
665: ,inv_item_id NUMBER := FND_API.G_MISS_NUM
666: ,inv_mast_org_id NUMBER := FND_API.G_MISS_NUM
667: ,attribute_id NUMBER := FND_API.G_MISS_NUM
668: ,attribute_level VARCHAR2(15) := FND_API.G_MISS_CHAR
669: ,item_category_id NUMBER := FND_API.G_MISS_NUM
670: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
671: );
672: TYPE EXT_ATTR_TBL IS TABLE OF EXT_ATTR_REC INDEX BY BINARY_INTEGER;

Line 669: ,item_category_id NUMBER := FND_API.G_MISS_NUM

665: ,inv_item_id NUMBER := FND_API.G_MISS_NUM
666: ,inv_mast_org_id NUMBER := FND_API.G_MISS_NUM
667: ,attribute_id NUMBER := FND_API.G_MISS_NUM
668: ,attribute_level VARCHAR2(15) := FND_API.G_MISS_CHAR
669: ,item_category_id NUMBER := FND_API.G_MISS_NUM
670: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
671: );
672: TYPE EXT_ATTR_TBL IS TABLE OF EXT_ATTR_REC INDEX BY BINARY_INTEGER;
673: --

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

666: ,inv_mast_org_id NUMBER := FND_API.G_MISS_NUM
667: ,attribute_id NUMBER := FND_API.G_MISS_NUM
668: ,attribute_level VARCHAR2(15) := FND_API.G_MISS_CHAR
669: ,item_category_id NUMBER := FND_API.G_MISS_NUM
670: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
671: );
672: TYPE EXT_ATTR_TBL IS TABLE OF EXT_ATTR_REC INDEX BY BINARY_INTEGER;
673: --
674: TYPE EXT_CAT_REC IS RECORD

Line 676: inv_item_id NUMBER := FND_API.G_MISS_NUM

672: TYPE EXT_ATTR_TBL IS TABLE OF EXT_ATTR_REC INDEX BY BINARY_INTEGER;
673: --
674: TYPE EXT_CAT_REC IS RECORD
675: (
676: inv_item_id NUMBER := FND_API.G_MISS_NUM
677: ,inv_mast_org_id NUMBER := FND_API.G_MISS_NUM
678: ,item_cat_id NUMBER := FND_API.G_MISS_NUM
679: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
680: );

Line 677: ,inv_mast_org_id NUMBER := FND_API.G_MISS_NUM

673: --
674: TYPE EXT_CAT_REC IS RECORD
675: (
676: inv_item_id NUMBER := FND_API.G_MISS_NUM
677: ,inv_mast_org_id NUMBER := FND_API.G_MISS_NUM
678: ,item_cat_id NUMBER := FND_API.G_MISS_NUM
679: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
680: );
681: TYPE EXT_CAT_TBL IS TABLE OF EXT_CAT_REC INDEX BY BINARY_INTEGER;

Line 678: ,item_cat_id NUMBER := FND_API.G_MISS_NUM

674: TYPE EXT_CAT_REC IS RECORD
675: (
676: inv_item_id NUMBER := FND_API.G_MISS_NUM
677: ,inv_mast_org_id NUMBER := FND_API.G_MISS_NUM
678: ,item_cat_id NUMBER := FND_API.G_MISS_NUM
679: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
680: );
681: TYPE EXT_CAT_TBL IS TABLE OF EXT_CAT_REC INDEX BY BINARY_INTEGER;
682: --

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

675: (
676: inv_item_id NUMBER := FND_API.G_MISS_NUM
677: ,inv_mast_org_id NUMBER := FND_API.G_MISS_NUM
678: ,item_cat_id NUMBER := FND_API.G_MISS_NUM
679: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
680: );
681: TYPE EXT_CAT_TBL IS TABLE OF EXT_CAT_REC INDEX BY BINARY_INTEGER;
682: --
683:

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

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

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

769:
770: PROCEDURE create_extended_attrib_values
771: ( p_api_version IN NUMBER
772: ,p_commit IN VARCHAR2 := fnd_api.g_false
773: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
774: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
775: ,p_ext_attrib_rec IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_rec
776: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
777: ,x_return_status OUT NOCOPY VARCHAR2

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

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

Line 784: ,p_called_from_grp IN VARCHAR2 DEFAULT fnd_api.g_false

780: ,p_ext_id_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_id_tbl
781: ,p_ext_count_rec IN OUT NOCOPY csi_item_instance_pvt.ext_count_rec
782: ,p_ext_attr_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_attr_tbl
783: ,p_ext_cat_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_cat_tbl
784: ,p_called_from_grp IN VARCHAR2 DEFAULT fnd_api.g_false
785: );
786:
787: /*---------------------------------------------------*/
788: /* procedure name: update_extended_attrib_values */

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

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

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

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

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

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

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

811: /*---------------------------------------------------*/
812:
813: PROCEDURE expire_extended_attrib_values
814: ( p_api_version IN NUMBER
815: ,p_commit IN VARCHAR2 := fnd_api.g_false
816: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
817: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
818: ,p_ext_attrib_rec IN csi_datastructures_pub.extend_attrib_values_rec
819: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

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

812:
813: PROCEDURE expire_extended_attrib_values
814: ( p_api_version IN NUMBER
815: ,p_commit IN VARCHAR2 := fnd_api.g_false
816: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
817: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
818: ,p_ext_attrib_rec IN csi_datastructures_pub.extend_attrib_values_rec
819: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
820: ,x_return_status OUT NOCOPY VARCHAR2

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

813: PROCEDURE expire_extended_attrib_values
814: ( p_api_version IN NUMBER
815: ,p_commit IN VARCHAR2 := fnd_api.g_false
816: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
817: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
818: ,p_ext_attrib_rec IN csi_datastructures_pub.extend_attrib_values_rec
819: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
820: ,x_return_status OUT NOCOPY VARCHAR2
821: ,x_msg_count OUT NOCOPY NUMBER

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

830:
831: PROCEDURE copy_single_item_instance
832: (
833: p_api_version IN NUMBER
834: ,p_commit IN VARCHAR2 := fnd_api.g_false
835: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
836: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
837: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
838: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false

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

831: PROCEDURE copy_single_item_instance
832: (
833: p_api_version IN NUMBER
834: ,p_commit IN VARCHAR2 := fnd_api.g_false
835: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
836: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
837: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
838: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
839: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false

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

832: (
833: p_api_version IN NUMBER
834: ,p_commit IN VARCHAR2 := fnd_api.g_false
835: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
836: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
837: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
838: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
839: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
840: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false

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

834: ,p_commit IN VARCHAR2 := fnd_api.g_false
835: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
836: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
837: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
838: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
839: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
840: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
841: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false
842: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false

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

835: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
836: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
837: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
838: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
839: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
840: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
841: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false
842: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
843: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false

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

836: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
837: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
838: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
839: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
840: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
841: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false
842: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
843: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
844: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false

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

837: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
838: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
839: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
840: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
841: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false
842: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
843: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
844: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
845: ,p_call_from_split IN VARCHAR2 := fnd_api.g_false

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

838: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
839: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
840: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
841: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false
842: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
843: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
844: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
845: ,p_call_from_split IN VARCHAR2 := fnd_api.g_false
846: ,p_call_from_bom_expl IN VARCHAR2 DEFAULT fnd_api.g_false -- should be passed only from Explode BOM

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

839: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
840: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
841: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false
842: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
843: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
844: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
845: ,p_call_from_split IN VARCHAR2 := fnd_api.g_false
846: ,p_call_from_bom_expl IN VARCHAR2 DEFAULT fnd_api.g_false -- should be passed only from Explode BOM
847: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

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

840: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
841: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false
842: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
843: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
844: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
845: ,p_call_from_split IN VARCHAR2 := fnd_api.g_false
846: ,p_call_from_bom_expl IN VARCHAR2 DEFAULT fnd_api.g_false -- should be passed only from Explode BOM
847: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
848: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl

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

841: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false
842: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
843: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
844: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
845: ,p_call_from_split IN VARCHAR2 := fnd_api.g_false
846: ,p_call_from_bom_expl IN VARCHAR2 DEFAULT fnd_api.g_false -- should be passed only from Explode BOM
847: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
848: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
849: ,x_return_status OUT NOCOPY VARCHAR2

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

842: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
843: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
844: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
845: ,p_call_from_split IN VARCHAR2 := fnd_api.g_false
846: ,p_call_from_bom_expl IN VARCHAR2 DEFAULT fnd_api.g_false -- should be passed only from Explode BOM
847: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
848: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
849: ,x_return_status OUT NOCOPY VARCHAR2
850: ,x_msg_count OUT NOCOPY NUMBER

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

862:
863: PROCEDURE Explode_Bom
864: (
865: p_api_version IN NUMBER
866: ,p_commit IN VARCHAR2 := fnd_api.g_false
867: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
868: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
869: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
870: ,p_explosion_level IN NUMBER

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

863: PROCEDURE Explode_Bom
864: (
865: p_api_version IN NUMBER
866: ,p_commit IN VARCHAR2 := fnd_api.g_false
867: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
868: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
869: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
870: ,p_explosion_level IN NUMBER
871: ,p_item_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl

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

864: (
865: p_api_version IN NUMBER
866: ,p_commit IN VARCHAR2 := fnd_api.g_false
867: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
868: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
869: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
870: ,p_explosion_level IN NUMBER
871: ,p_item_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
872: ,p_item_relation_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl

Line 873: ,p_create_instance IN VARCHAR2 DEFAULT FND_API.G_FALSE

869: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
870: ,p_explosion_level IN NUMBER
871: ,p_item_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
872: ,p_item_relation_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
873: ,p_create_instance IN VARCHAR2 DEFAULT FND_API.G_FALSE
874: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
875: ,x_return_status OUT NOCOPY VARCHAR2
876: ,x_msg_count OUT NOCOPY NUMBER
877: ,x_msg_data OUT NOCOPY VARCHAR2

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

884: /*---------------------------------------------------*/
885:
886: PROCEDURE get_instance_hist
887: ( p_api_version IN NUMBER
888: ,p_commit IN VARCHAR2 := fnd_api.g_false
889: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
890: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
891: ,p_transaction_id IN NUMBER
892: ,x_instance_history_tbl OUT NOCOPY csi_datastructures_pub.instance_history_tbl

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

885:
886: PROCEDURE get_instance_hist
887: ( p_api_version IN NUMBER
888: ,p_commit IN VARCHAR2 := fnd_api.g_false
889: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
890: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
891: ,p_transaction_id IN NUMBER
892: ,x_instance_history_tbl OUT NOCOPY csi_datastructures_pub.instance_history_tbl
893: ,x_return_status OUT NOCOPY VARCHAR2

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

886: PROCEDURE get_instance_hist
887: ( p_api_version IN NUMBER
888: ,p_commit IN VARCHAR2 := fnd_api.g_false
889: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
890: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
891: ,p_transaction_id IN NUMBER
892: ,x_instance_history_tbl OUT NOCOPY csi_datastructures_pub.instance_history_tbl
893: ,x_return_status OUT NOCOPY VARCHAR2
894: ,x_msg_count OUT NOCOPY NUMBER

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

909: ,p_vld_org_id IN NUMBER
910: ,p_quantity IN NUMBER
911: ,p_party_account_id1 IN NUMBER
912: ,p_party_account_id2 IN NUMBER
913: ,p_transaction_date IN DATE := fnd_api.g_miss_date
914: ,p_source_transaction_date IN DATE := fnd_api.g_miss_date -- Added by jpwilson
915: ,p_transaction_id IN NUMBER := fnd_api.g_miss_num -- Added by sguthiva for TRF(HTML)
916: ,p_grp_call_contracts IN VARCHAR2 DEFAULT fnd_api.g_false
917: ,p_txn_type_id IN NUMBER DEFAULT fnd_api.g_miss_num

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

910: ,p_quantity IN NUMBER
911: ,p_party_account_id1 IN NUMBER
912: ,p_party_account_id2 IN NUMBER
913: ,p_transaction_date IN DATE := fnd_api.g_miss_date
914: ,p_source_transaction_date IN DATE := fnd_api.g_miss_date -- Added by jpwilson
915: ,p_transaction_id IN NUMBER := fnd_api.g_miss_num -- Added by sguthiva for TRF(HTML)
916: ,p_grp_call_contracts IN VARCHAR2 DEFAULT fnd_api.g_false
917: ,p_txn_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
918: ,p_system_id IN NUMBER DEFAULT fnd_api.g_miss_num -- OKS Enhancement

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

911: ,p_party_account_id1 IN NUMBER
912: ,p_party_account_id2 IN NUMBER
913: ,p_transaction_date IN DATE := fnd_api.g_miss_date
914: ,p_source_transaction_date IN DATE := fnd_api.g_miss_date -- Added by jpwilson
915: ,p_transaction_id IN NUMBER := fnd_api.g_miss_num -- Added by sguthiva for TRF(HTML)
916: ,p_grp_call_contracts IN VARCHAR2 DEFAULT fnd_api.g_false
917: ,p_txn_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
918: ,p_system_id IN NUMBER DEFAULT fnd_api.g_miss_num -- OKS Enhancement
919: ,p_order_line_id IN NUMBER DEFAULT fnd_api.g_miss_num -- should be passed only when un-expiring an Instance

Line 916: ,p_grp_call_contracts IN VARCHAR2 DEFAULT fnd_api.g_false

912: ,p_party_account_id2 IN NUMBER
913: ,p_transaction_date IN DATE := fnd_api.g_miss_date
914: ,p_source_transaction_date IN DATE := fnd_api.g_miss_date -- Added by jpwilson
915: ,p_transaction_id IN NUMBER := fnd_api.g_miss_num -- Added by sguthiva for TRF(HTML)
916: ,p_grp_call_contracts IN VARCHAR2 DEFAULT fnd_api.g_false
917: ,p_txn_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
918: ,p_system_id IN NUMBER DEFAULT fnd_api.g_miss_num -- OKS Enhancement
919: ,p_order_line_id IN NUMBER DEFAULT fnd_api.g_miss_num -- should be passed only when un-expiring an Instance
920: ,p_call_from_bom_expl IN VARCHAR2 DEFAULT fnd_api.g_false

Line 917: ,p_txn_type_id IN NUMBER DEFAULT fnd_api.g_miss_num

913: ,p_transaction_date IN DATE := fnd_api.g_miss_date
914: ,p_source_transaction_date IN DATE := fnd_api.g_miss_date -- Added by jpwilson
915: ,p_transaction_id IN NUMBER := fnd_api.g_miss_num -- Added by sguthiva for TRF(HTML)
916: ,p_grp_call_contracts IN VARCHAR2 DEFAULT fnd_api.g_false
917: ,p_txn_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
918: ,p_system_id IN NUMBER DEFAULT fnd_api.g_miss_num -- OKS Enhancement
919: ,p_order_line_id IN NUMBER DEFAULT fnd_api.g_miss_num -- should be passed only when un-expiring an Instance
920: ,p_call_from_bom_expl IN VARCHAR2 DEFAULT fnd_api.g_false
921: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl

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

914: ,p_source_transaction_date IN DATE := fnd_api.g_miss_date -- Added by jpwilson
915: ,p_transaction_id IN NUMBER := fnd_api.g_miss_num -- Added by sguthiva for TRF(HTML)
916: ,p_grp_call_contracts IN VARCHAR2 DEFAULT fnd_api.g_false
917: ,p_txn_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
918: ,p_system_id IN NUMBER DEFAULT fnd_api.g_miss_num -- OKS Enhancement
919: ,p_order_line_id IN NUMBER DEFAULT fnd_api.g_miss_num -- should be passed only when un-expiring an Instance
920: ,p_call_from_bom_expl IN VARCHAR2 DEFAULT fnd_api.g_false
921: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
922: ,x_return_status OUT NOCOPY VARCHAR2

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

915: ,p_transaction_id IN NUMBER := fnd_api.g_miss_num -- Added by sguthiva for TRF(HTML)
916: ,p_grp_call_contracts IN VARCHAR2 DEFAULT fnd_api.g_false
917: ,p_txn_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
918: ,p_system_id IN NUMBER DEFAULT fnd_api.g_miss_num -- OKS Enhancement
919: ,p_order_line_id IN NUMBER DEFAULT fnd_api.g_miss_num -- should be passed only when un-expiring an Instance
920: ,p_call_from_bom_expl IN VARCHAR2 DEFAULT fnd_api.g_false
921: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
922: ,x_return_status OUT NOCOPY VARCHAR2
923: ,x_msg_count OUT NOCOPY NUMBER

Line 920: ,p_call_from_bom_expl IN VARCHAR2 DEFAULT fnd_api.g_false

916: ,p_grp_call_contracts IN VARCHAR2 DEFAULT fnd_api.g_false
917: ,p_txn_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
918: ,p_system_id IN NUMBER DEFAULT fnd_api.g_miss_num -- OKS Enhancement
919: ,p_order_line_id IN NUMBER DEFAULT fnd_api.g_miss_num -- should be passed only when un-expiring an Instance
920: ,p_call_from_bom_expl IN VARCHAR2 DEFAULT fnd_api.g_false
921: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
922: ,x_return_status OUT NOCOPY VARCHAR2
923: ,x_msg_count OUT NOCOPY NUMBER
924: ,x_msg_data OUT NOCOPY VARCHAR2

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

931: /*---------------------------------------------------*/
932:
933: PROCEDURE get_ext_attrib_val_hist
934: ( p_api_version IN NUMBER
935: ,p_commit IN VARCHAR2 := fnd_api.g_false
936: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
937: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
938: ,p_transaction_id IN NUMBER
939: ,x_ext_attrib_val_hist_tbl OUT NOCOPY csi_datastructures_pub.ext_attrib_val_history_tbl

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

932:
933: PROCEDURE get_ext_attrib_val_hist
934: ( p_api_version IN NUMBER
935: ,p_commit IN VARCHAR2 := fnd_api.g_false
936: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
937: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
938: ,p_transaction_id IN NUMBER
939: ,x_ext_attrib_val_hist_tbl OUT NOCOPY csi_datastructures_pub.ext_attrib_val_history_tbl
940: ,x_return_status OUT NOCOPY VARCHAR2

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

933: PROCEDURE get_ext_attrib_val_hist
934: ( p_api_version IN NUMBER
935: ,p_commit IN VARCHAR2 := fnd_api.g_false
936: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
937: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
938: ,p_transaction_id IN NUMBER
939: ,x_ext_attrib_val_hist_tbl OUT NOCOPY csi_datastructures_pub.ext_attrib_val_history_tbl
940: ,x_return_status OUT NOCOPY VARCHAR2
941: ,x_msg_count OUT NOCOPY NUMBER

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

950:
951:
952: PROCEDURE copy_item_instance
953: ( p_api_version IN NUMBER
954: ,p_commit IN VARCHAR2 := fnd_api.g_false
955: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
956: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
957: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
958: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false

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

951:
952: PROCEDURE copy_item_instance
953: ( p_api_version IN NUMBER
954: ,p_commit IN VARCHAR2 := fnd_api.g_false
955: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
956: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
957: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
958: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
959: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false

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

952: PROCEDURE copy_item_instance
953: ( p_api_version IN NUMBER
954: ,p_commit IN VARCHAR2 := fnd_api.g_false
955: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
956: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
957: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
958: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
959: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
960: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false

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

954: ,p_commit IN VARCHAR2 := fnd_api.g_false
955: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
956: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
957: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
958: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
959: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
960: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
961: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false
962: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false

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

955: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
956: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
957: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
958: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
959: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
960: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
961: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false
962: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
963: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false

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

956: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
957: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
958: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
959: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
960: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
961: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false
962: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
963: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
964: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false

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

957: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
958: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
959: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
960: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
961: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false
962: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
963: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
964: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
965: ,p_copy_inst_children IN VARCHAR2 := fnd_api.g_false

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

958: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
959: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
960: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
961: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false
962: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
963: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
964: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
965: ,p_copy_inst_children IN VARCHAR2 := fnd_api.g_false
966: ,p_call_from_split IN VARCHAR2 := fnd_api.g_false

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

959: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
960: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
961: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false
962: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
963: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
964: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
965: ,p_copy_inst_children IN VARCHAR2 := fnd_api.g_false
966: ,p_call_from_split IN VARCHAR2 := fnd_api.g_false
967: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

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

960: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
961: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false
962: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
963: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
964: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
965: ,p_copy_inst_children IN VARCHAR2 := fnd_api.g_false
966: ,p_call_from_split IN VARCHAR2 := fnd_api.g_false
967: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
968: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl

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

961: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false
962: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
963: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
964: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
965: ,p_copy_inst_children IN VARCHAR2 := fnd_api.g_false
966: ,p_call_from_split IN VARCHAR2 := fnd_api.g_false
967: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
968: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
969: ,x_return_status OUT NOCOPY VARCHAR2

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

962: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
963: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
964: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
965: ,p_copy_inst_children IN VARCHAR2 := fnd_api.g_false
966: ,p_call_from_split IN VARCHAR2 := fnd_api.g_false
967: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
968: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
969: ,x_return_status OUT NOCOPY VARCHAR2
970: ,x_msg_count OUT NOCOPY NUMBER

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

980: /*------------------------------------------------------------*/
981:
982: PROCEDURE get_version_label_history
983: ( p_api_version IN NUMBER
984: ,p_commit IN VARCHAR2 := fnd_api.g_false
985: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
986: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
987: ,p_transaction_id IN NUMBER
988: ,x_version_label_hist_tbl OUT NOCOPY csi_datastructures_pub.version_label_history_tbl

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

981:
982: PROCEDURE get_version_label_history
983: ( p_api_version IN NUMBER
984: ,p_commit IN VARCHAR2 := fnd_api.g_false
985: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
986: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
987: ,p_transaction_id IN NUMBER
988: ,x_version_label_hist_tbl OUT NOCOPY csi_datastructures_pub.version_label_history_tbl
989: ,x_return_status OUT NOCOPY VARCHAR2

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

982: PROCEDURE get_version_label_history
983: ( p_api_version IN NUMBER
984: ,p_commit IN VARCHAR2 := fnd_api.g_false
985: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
986: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
987: ,p_transaction_id IN NUMBER
988: ,x_version_label_hist_tbl OUT NOCOPY csi_datastructures_pub.version_label_history_tbl
989: ,x_return_status OUT NOCOPY VARCHAR2
990: ,x_msg_count OUT NOCOPY NUMBER

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

999:
1000: PROCEDURE get_instance_link_locations
1001: (
1002: p_api_version IN NUMBER
1003: ,p_commit IN VARCHAR2 := fnd_api.g_false
1004: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1005: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1006: ,p_instance_id IN NUMBER
1007: ,x_instance_link_rec OUT NOCOPY csi_datastructures_pub.instance_link_rec

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

1000: PROCEDURE get_instance_link_locations
1001: (
1002: p_api_version IN NUMBER
1003: ,p_commit IN VARCHAR2 := fnd_api.g_false
1004: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1005: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1006: ,p_instance_id IN NUMBER
1007: ,x_instance_link_rec OUT NOCOPY csi_datastructures_pub.instance_link_rec
1008: ,x_return_status OUT NOCOPY VARCHAR2

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

1001: (
1002: p_api_version IN NUMBER
1003: ,p_commit IN VARCHAR2 := fnd_api.g_false
1004: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1005: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1006: ,p_instance_id IN NUMBER
1007: ,x_instance_link_rec OUT NOCOPY csi_datastructures_pub.instance_link_rec
1008: ,x_return_status OUT NOCOPY VARCHAR2
1009: ,x_msg_count OUT NOCOPY NUMBER

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

1012:
1013: PROCEDURE Update_version_time
1014: (
1015: p_api_version IN NUMBER
1016: ,p_commit IN VARCHAR2 := fnd_api.g_false
1017: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1018: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1019: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
1020: ,x_return_status OUT NOCOPY VARCHAR2

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

1013: PROCEDURE Update_version_time
1014: (
1015: p_api_version IN NUMBER
1016: ,p_commit IN VARCHAR2 := fnd_api.g_false
1017: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1018: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1019: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
1020: ,x_return_status OUT NOCOPY VARCHAR2
1021: ,x_msg_count OUT NOCOPY NUMBER

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

1014: (
1015: p_api_version IN NUMBER
1016: ,p_commit IN VARCHAR2 := fnd_api.g_false
1017: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1018: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1019: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
1020: ,x_return_status OUT NOCOPY VARCHAR2
1021: ,x_msg_count OUT NOCOPY NUMBER
1022: ,x_msg_data OUT NOCOPY VARCHAR2);