4: g_pkg_name varchar2(30) := 'csi_wip_trxs_pkg';
5: g_api_name varchar2(80) := 'csi_wip_trxs_pkg';
6:
7: TYPE txn_ref IS RECORD (
8: transaction_id number := fnd_api.g_miss_num,
9: transaction_date date := fnd_api.g_miss_date,
10: creation_date date := fnd_api.g_miss_date,
11: transaction_type_id number := fnd_api.g_miss_num,
12: transaction_source_type_id number := fnd_api.g_miss_num,
5: g_api_name varchar2(80) := 'csi_wip_trxs_pkg';
6:
7: TYPE txn_ref IS RECORD (
8: transaction_id number := fnd_api.g_miss_num,
9: transaction_date date := fnd_api.g_miss_date,
10: creation_date date := fnd_api.g_miss_date,
11: transaction_type_id number := fnd_api.g_miss_num,
12: transaction_source_type_id number := fnd_api.g_miss_num,
13: transaction_action_id number := fnd_api.g_miss_num,
6:
7: TYPE txn_ref IS RECORD (
8: transaction_id number := fnd_api.g_miss_num,
9: transaction_date date := fnd_api.g_miss_date,
10: creation_date date := fnd_api.g_miss_date,
11: transaction_type_id number := fnd_api.g_miss_num,
12: transaction_source_type_id number := fnd_api.g_miss_num,
13: transaction_action_id number := fnd_api.g_miss_num,
14: inventory_item_id number := fnd_api.g_miss_num,
7: TYPE txn_ref IS RECORD (
8: transaction_id number := fnd_api.g_miss_num,
9: transaction_date date := fnd_api.g_miss_date,
10: creation_date date := fnd_api.g_miss_date,
11: transaction_type_id number := fnd_api.g_miss_num,
12: transaction_source_type_id number := fnd_api.g_miss_num,
13: transaction_action_id number := fnd_api.g_miss_num,
14: inventory_item_id number := fnd_api.g_miss_num,
15: organization_id number := fnd_api.g_miss_num,
8: transaction_id number := fnd_api.g_miss_num,
9: transaction_date date := fnd_api.g_miss_date,
10: creation_date date := fnd_api.g_miss_date,
11: transaction_type_id number := fnd_api.g_miss_num,
12: transaction_source_type_id number := fnd_api.g_miss_num,
13: transaction_action_id number := fnd_api.g_miss_num,
14: inventory_item_id number := fnd_api.g_miss_num,
15: organization_id number := fnd_api.g_miss_num,
16: primary_quantity number := fnd_api.g_miss_num,
9: transaction_date date := fnd_api.g_miss_date,
10: creation_date date := fnd_api.g_miss_date,
11: transaction_type_id number := fnd_api.g_miss_num,
12: transaction_source_type_id number := fnd_api.g_miss_num,
13: transaction_action_id number := fnd_api.g_miss_num,
14: inventory_item_id number := fnd_api.g_miss_num,
15: organization_id number := fnd_api.g_miss_num,
16: primary_quantity number := fnd_api.g_miss_num,
17: master_organization_id number := fnd_api.g_miss_num,
10: creation_date date := fnd_api.g_miss_date,
11: transaction_type_id number := fnd_api.g_miss_num,
12: transaction_source_type_id number := fnd_api.g_miss_num,
13: transaction_action_id number := fnd_api.g_miss_num,
14: inventory_item_id number := fnd_api.g_miss_num,
15: organization_id number := fnd_api.g_miss_num,
16: primary_quantity number := fnd_api.g_miss_num,
17: master_organization_id number := fnd_api.g_miss_num,
18: item varchar2(40) := fnd_api.g_miss_char,
11: transaction_type_id number := fnd_api.g_miss_num,
12: transaction_source_type_id number := fnd_api.g_miss_num,
13: transaction_action_id number := fnd_api.g_miss_num,
14: inventory_item_id number := fnd_api.g_miss_num,
15: organization_id number := fnd_api.g_miss_num,
16: primary_quantity number := fnd_api.g_miss_num,
17: master_organization_id number := fnd_api.g_miss_num,
18: item varchar2(40) := fnd_api.g_miss_char,
19: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
12: transaction_source_type_id number := fnd_api.g_miss_num,
13: transaction_action_id number := fnd_api.g_miss_num,
14: inventory_item_id number := fnd_api.g_miss_num,
15: organization_id number := fnd_api.g_miss_num,
16: primary_quantity number := fnd_api.g_miss_num,
17: master_organization_id number := fnd_api.g_miss_num,
18: item varchar2(40) := fnd_api.g_miss_char,
19: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
20: srl_control_code number := fnd_api.g_miss_num,
13: transaction_action_id number := fnd_api.g_miss_num,
14: inventory_item_id number := fnd_api.g_miss_num,
15: organization_id number := fnd_api.g_miss_num,
16: primary_quantity number := fnd_api.g_miss_num,
17: master_organization_id number := fnd_api.g_miss_num,
18: item varchar2(40) := fnd_api.g_miss_char,
19: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
20: srl_control_code number := fnd_api.g_miss_num,
21: lot_control_code number := fnd_api.g_miss_num,
14: inventory_item_id number := fnd_api.g_miss_num,
15: organization_id number := fnd_api.g_miss_num,
16: primary_quantity number := fnd_api.g_miss_num,
17: master_organization_id number := fnd_api.g_miss_num,
18: item varchar2(40) := fnd_api.g_miss_char,
19: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
20: srl_control_code number := fnd_api.g_miss_num,
21: lot_control_code number := fnd_api.g_miss_num,
22: rev_control_code number := fnd_api.g_miss_num,
15: organization_id number := fnd_api.g_miss_num,
16: primary_quantity number := fnd_api.g_miss_num,
17: master_organization_id number := fnd_api.g_miss_num,
18: item varchar2(40) := fnd_api.g_miss_char,
19: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
20: srl_control_code number := fnd_api.g_miss_num,
21: lot_control_code number := fnd_api.g_miss_num,
22: rev_control_code number := fnd_api.g_miss_num,
23: loc_control_code number := fnd_api.g_miss_num,
16: primary_quantity number := fnd_api.g_miss_num,
17: master_organization_id number := fnd_api.g_miss_num,
18: item varchar2(40) := fnd_api.g_miss_char,
19: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
20: srl_control_code number := fnd_api.g_miss_num,
21: lot_control_code number := fnd_api.g_miss_num,
22: rev_control_code number := fnd_api.g_miss_num,
23: loc_control_code number := fnd_api.g_miss_num,
24: ib_trackable_flag varchar2(1) := fnd_api.g_miss_char,
17: master_organization_id number := fnd_api.g_miss_num,
18: item varchar2(40) := fnd_api.g_miss_char,
19: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
20: srl_control_code number := fnd_api.g_miss_num,
21: lot_control_code number := fnd_api.g_miss_num,
22: rev_control_code number := fnd_api.g_miss_num,
23: loc_control_code number := fnd_api.g_miss_num,
24: ib_trackable_flag varchar2(1) := fnd_api.g_miss_char,
25: eam_item_type number := fnd_api.g_miss_num,
18: item varchar2(40) := fnd_api.g_miss_char,
19: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
20: srl_control_code number := fnd_api.g_miss_num,
21: lot_control_code number := fnd_api.g_miss_num,
22: rev_control_code number := fnd_api.g_miss_num,
23: loc_control_code number := fnd_api.g_miss_num,
24: ib_trackable_flag varchar2(1) := fnd_api.g_miss_char,
25: eam_item_type number := fnd_api.g_miss_num,
26: bom_item_type number := fnd_api.g_miss_num,
19: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
20: srl_control_code number := fnd_api.g_miss_num,
21: lot_control_code number := fnd_api.g_miss_num,
22: rev_control_code number := fnd_api.g_miss_num,
23: loc_control_code number := fnd_api.g_miss_num,
24: ib_trackable_flag varchar2(1) := fnd_api.g_miss_char,
25: eam_item_type number := fnd_api.g_miss_num,
26: bom_item_type number := fnd_api.g_miss_num,
27: wip_entity_id number := fnd_api.g_miss_num,
20: srl_control_code number := fnd_api.g_miss_num,
21: lot_control_code number := fnd_api.g_miss_num,
22: rev_control_code number := fnd_api.g_miss_num,
23: loc_control_code number := fnd_api.g_miss_num,
24: ib_trackable_flag varchar2(1) := fnd_api.g_miss_char,
25: eam_item_type number := fnd_api.g_miss_num,
26: bom_item_type number := fnd_api.g_miss_num,
27: wip_entity_id number := fnd_api.g_miss_num,
28: wip_entity_name varchar2(240) := fnd_api.g_miss_char,
21: lot_control_code number := fnd_api.g_miss_num,
22: rev_control_code number := fnd_api.g_miss_num,
23: loc_control_code number := fnd_api.g_miss_num,
24: ib_trackable_flag varchar2(1) := fnd_api.g_miss_char,
25: eam_item_type number := fnd_api.g_miss_num,
26: bom_item_type number := fnd_api.g_miss_num,
27: wip_entity_id number := fnd_api.g_miss_num,
28: wip_entity_name varchar2(240) := fnd_api.g_miss_char,
29: wip_entity_type number := fnd_api.g_miss_num,
22: rev_control_code number := fnd_api.g_miss_num,
23: loc_control_code number := fnd_api.g_miss_num,
24: ib_trackable_flag varchar2(1) := fnd_api.g_miss_char,
25: eam_item_type number := fnd_api.g_miss_num,
26: bom_item_type number := fnd_api.g_miss_num,
27: wip_entity_id number := fnd_api.g_miss_num,
28: wip_entity_name varchar2(240) := fnd_api.g_miss_char,
29: wip_entity_type number := fnd_api.g_miss_num,
30: wip_job_type number := fnd_api.g_miss_num,
23: loc_control_code number := fnd_api.g_miss_num,
24: ib_trackable_flag varchar2(1) := fnd_api.g_miss_char,
25: eam_item_type number := fnd_api.g_miss_num,
26: bom_item_type number := fnd_api.g_miss_num,
27: wip_entity_id number := fnd_api.g_miss_num,
28: wip_entity_name varchar2(240) := fnd_api.g_miss_char,
29: wip_entity_type number := fnd_api.g_miss_num,
30: wip_job_type number := fnd_api.g_miss_num,
31: wip_status_type number := fnd_api.g_miss_num,
24: ib_trackable_flag varchar2(1) := fnd_api.g_miss_char,
25: eam_item_type number := fnd_api.g_miss_num,
26: bom_item_type number := fnd_api.g_miss_num,
27: wip_entity_id number := fnd_api.g_miss_num,
28: wip_entity_name varchar2(240) := fnd_api.g_miss_char,
29: wip_entity_type number := fnd_api.g_miss_num,
30: wip_job_type number := fnd_api.g_miss_num,
31: wip_status_type number := fnd_api.g_miss_num,
32: wip_assembly_item_id number := fnd_api.g_miss_num,
25: eam_item_type number := fnd_api.g_miss_num,
26: bom_item_type number := fnd_api.g_miss_num,
27: wip_entity_id number := fnd_api.g_miss_num,
28: wip_entity_name varchar2(240) := fnd_api.g_miss_char,
29: wip_entity_type number := fnd_api.g_miss_num,
30: wip_job_type number := fnd_api.g_miss_num,
31: wip_status_type number := fnd_api.g_miss_num,
32: wip_assembly_item_id number := fnd_api.g_miss_num,
33: wip_start_quantity number := fnd_api.g_miss_num,
26: bom_item_type number := fnd_api.g_miss_num,
27: wip_entity_id number := fnd_api.g_miss_num,
28: wip_entity_name varchar2(240) := fnd_api.g_miss_char,
29: wip_entity_type number := fnd_api.g_miss_num,
30: wip_job_type number := fnd_api.g_miss_num,
31: wip_status_type number := fnd_api.g_miss_num,
32: wip_assembly_item_id number := fnd_api.g_miss_num,
33: wip_start_quantity number := fnd_api.g_miss_num,
34: wip_completed_quantity number := fnd_api.g_miss_num,
27: wip_entity_id number := fnd_api.g_miss_num,
28: wip_entity_name varchar2(240) := fnd_api.g_miss_char,
29: wip_entity_type number := fnd_api.g_miss_num,
30: wip_job_type number := fnd_api.g_miss_num,
31: wip_status_type number := fnd_api.g_miss_num,
32: wip_assembly_item_id number := fnd_api.g_miss_num,
33: wip_start_quantity number := fnd_api.g_miss_num,
34: wip_completed_quantity number := fnd_api.g_miss_num,
35: wip_maint_source_code number := fnd_api.g_miss_num,
28: wip_entity_name varchar2(240) := fnd_api.g_miss_char,
29: wip_entity_type number := fnd_api.g_miss_num,
30: wip_job_type number := fnd_api.g_miss_num,
31: wip_status_type number := fnd_api.g_miss_num,
32: wip_assembly_item_id number := fnd_api.g_miss_num,
33: wip_start_quantity number := fnd_api.g_miss_num,
34: wip_completed_quantity number := fnd_api.g_miss_num,
35: wip_maint_source_code number := fnd_api.g_miss_num,
36: wip_source_line_id number := fnd_api.g_miss_num,
29: wip_entity_type number := fnd_api.g_miss_num,
30: wip_job_type number := fnd_api.g_miss_num,
31: wip_status_type number := fnd_api.g_miss_num,
32: wip_assembly_item_id number := fnd_api.g_miss_num,
33: wip_start_quantity number := fnd_api.g_miss_num,
34: wip_completed_quantity number := fnd_api.g_miss_num,
35: wip_maint_source_code number := fnd_api.g_miss_num,
36: wip_source_line_id number := fnd_api.g_miss_num,
37: wip_source_code varchar2(30) := fnd_api.g_miss_char,
30: wip_job_type number := fnd_api.g_miss_num,
31: wip_status_type number := fnd_api.g_miss_num,
32: wip_assembly_item_id number := fnd_api.g_miss_num,
33: wip_start_quantity number := fnd_api.g_miss_num,
34: wip_completed_quantity number := fnd_api.g_miss_num,
35: wip_maint_source_code number := fnd_api.g_miss_num,
36: wip_source_line_id number := fnd_api.g_miss_num,
37: wip_source_code varchar2(30) := fnd_api.g_miss_char,
38: wip_maint_obj_type number := fnd_api.g_miss_num,
31: wip_status_type number := fnd_api.g_miss_num,
32: wip_assembly_item_id number := fnd_api.g_miss_num,
33: wip_start_quantity number := fnd_api.g_miss_num,
34: wip_completed_quantity number := fnd_api.g_miss_num,
35: wip_maint_source_code number := fnd_api.g_miss_num,
36: wip_source_line_id number := fnd_api.g_miss_num,
37: wip_source_code varchar2(30) := fnd_api.g_miss_char,
38: wip_maint_obj_type number := fnd_api.g_miss_num,
39: wip_maint_obj_id number := fnd_api.g_miss_num);
32: wip_assembly_item_id number := fnd_api.g_miss_num,
33: wip_start_quantity number := fnd_api.g_miss_num,
34: wip_completed_quantity number := fnd_api.g_miss_num,
35: wip_maint_source_code number := fnd_api.g_miss_num,
36: wip_source_line_id number := fnd_api.g_miss_num,
37: wip_source_code varchar2(30) := fnd_api.g_miss_char,
38: wip_maint_obj_type number := fnd_api.g_miss_num,
39: wip_maint_obj_id number := fnd_api.g_miss_num);
40:
33: wip_start_quantity number := fnd_api.g_miss_num,
34: wip_completed_quantity number := fnd_api.g_miss_num,
35: wip_maint_source_code number := fnd_api.g_miss_num,
36: wip_source_line_id number := fnd_api.g_miss_num,
37: wip_source_code varchar2(30) := fnd_api.g_miss_char,
38: wip_maint_obj_type number := fnd_api.g_miss_num,
39: wip_maint_obj_id number := fnd_api.g_miss_num);
40:
41: TYPE mmt_rec IS RECORD (
34: wip_completed_quantity number := fnd_api.g_miss_num,
35: wip_maint_source_code number := fnd_api.g_miss_num,
36: wip_source_line_id number := fnd_api.g_miss_num,
37: wip_source_code varchar2(30) := fnd_api.g_miss_char,
38: wip_maint_obj_type number := fnd_api.g_miss_num,
39: wip_maint_obj_id number := fnd_api.g_miss_num);
40:
41: TYPE mmt_rec IS RECORD (
42: inventory_item_id number := fnd_api.g_miss_num,
35: wip_maint_source_code number := fnd_api.g_miss_num,
36: wip_source_line_id number := fnd_api.g_miss_num,
37: wip_source_code varchar2(30) := fnd_api.g_miss_char,
38: wip_maint_obj_type number := fnd_api.g_miss_num,
39: wip_maint_obj_id number := fnd_api.g_miss_num);
40:
41: TYPE mmt_rec IS RECORD (
42: inventory_item_id number := fnd_api.g_miss_num,
43: organization_id number := fnd_api.g_miss_num,
38: wip_maint_obj_type number := fnd_api.g_miss_num,
39: wip_maint_obj_id number := fnd_api.g_miss_num);
40:
41: TYPE mmt_rec IS RECORD (
42: inventory_item_id number := fnd_api.g_miss_num,
43: organization_id number := fnd_api.g_miss_num,
44: subinventory_code varchar2(10) := fnd_api.g_miss_char,
45: revision varchar2(3) := fnd_api.g_miss_char,
46: transaction_source_id number := fnd_api.g_miss_num,
39: wip_maint_obj_id number := fnd_api.g_miss_num);
40:
41: TYPE mmt_rec IS RECORD (
42: inventory_item_id number := fnd_api.g_miss_num,
43: organization_id number := fnd_api.g_miss_num,
44: subinventory_code varchar2(10) := fnd_api.g_miss_char,
45: revision varchar2(3) := fnd_api.g_miss_char,
46: transaction_source_id number := fnd_api.g_miss_num,
47: transaction_set_id number := fnd_api.g_miss_num, --bug 5376024
40:
41: TYPE mmt_rec IS RECORD (
42: inventory_item_id number := fnd_api.g_miss_num,
43: organization_id number := fnd_api.g_miss_num,
44: subinventory_code varchar2(10) := fnd_api.g_miss_char,
45: revision varchar2(3) := fnd_api.g_miss_char,
46: transaction_source_id number := fnd_api.g_miss_num,
47: transaction_set_id number := fnd_api.g_miss_num, --bug 5376024
48: transaction_date date := fnd_api.g_miss_date,
41: TYPE mmt_rec IS RECORD (
42: inventory_item_id number := fnd_api.g_miss_num,
43: organization_id number := fnd_api.g_miss_num,
44: subinventory_code varchar2(10) := fnd_api.g_miss_char,
45: revision varchar2(3) := fnd_api.g_miss_char,
46: transaction_source_id number := fnd_api.g_miss_num,
47: transaction_set_id number := fnd_api.g_miss_num, --bug 5376024
48: transaction_date date := fnd_api.g_miss_date,
49: transaction_quantity number := fnd_api.g_miss_num,
42: inventory_item_id number := fnd_api.g_miss_num,
43: organization_id number := fnd_api.g_miss_num,
44: subinventory_code varchar2(10) := fnd_api.g_miss_char,
45: revision varchar2(3) := fnd_api.g_miss_char,
46: transaction_source_id number := fnd_api.g_miss_num,
47: transaction_set_id number := fnd_api.g_miss_num, --bug 5376024
48: transaction_date date := fnd_api.g_miss_date,
49: transaction_quantity number := fnd_api.g_miss_num,
50: transaction_uom varchar2(3) := fnd_api.g_miss_char,
43: organization_id number := fnd_api.g_miss_num,
44: subinventory_code varchar2(10) := fnd_api.g_miss_char,
45: revision varchar2(3) := fnd_api.g_miss_char,
46: transaction_source_id number := fnd_api.g_miss_num,
47: transaction_set_id number := fnd_api.g_miss_num, --bug 5376024
48: transaction_date date := fnd_api.g_miss_date,
49: transaction_quantity number := fnd_api.g_miss_num,
50: transaction_uom varchar2(3) := fnd_api.g_miss_char,
51: locator_id number := fnd_api.g_miss_num,
44: subinventory_code varchar2(10) := fnd_api.g_miss_char,
45: revision varchar2(3) := fnd_api.g_miss_char,
46: transaction_source_id number := fnd_api.g_miss_num,
47: transaction_set_id number := fnd_api.g_miss_num, --bug 5376024
48: transaction_date date := fnd_api.g_miss_date,
49: transaction_quantity number := fnd_api.g_miss_num,
50: transaction_uom varchar2(3) := fnd_api.g_miss_char,
51: locator_id number := fnd_api.g_miss_num,
52: serial_number varchar2(30) := fnd_api.g_miss_char,
45: revision varchar2(3) := fnd_api.g_miss_char,
46: transaction_source_id number := fnd_api.g_miss_num,
47: transaction_set_id number := fnd_api.g_miss_num, --bug 5376024
48: transaction_date date := fnd_api.g_miss_date,
49: transaction_quantity number := fnd_api.g_miss_num,
50: transaction_uom varchar2(3) := fnd_api.g_miss_char,
51: locator_id number := fnd_api.g_miss_num,
52: serial_number varchar2(30) := fnd_api.g_miss_char,
53: lot_number varchar2(80) := fnd_api.g_miss_char,
46: transaction_source_id number := fnd_api.g_miss_num,
47: transaction_set_id number := fnd_api.g_miss_num, --bug 5376024
48: transaction_date date := fnd_api.g_miss_date,
49: transaction_quantity number := fnd_api.g_miss_num,
50: transaction_uom varchar2(3) := fnd_api.g_miss_char,
51: locator_id number := fnd_api.g_miss_num,
52: serial_number varchar2(30) := fnd_api.g_miss_char,
53: lot_number varchar2(80) := fnd_api.g_miss_char,
54: subinv_location_id number := fnd_api.g_miss_num,
47: transaction_set_id number := fnd_api.g_miss_num, --bug 5376024
48: transaction_date date := fnd_api.g_miss_date,
49: transaction_quantity number := fnd_api.g_miss_num,
50: transaction_uom varchar2(3) := fnd_api.g_miss_char,
51: locator_id number := fnd_api.g_miss_num,
52: serial_number varchar2(30) := fnd_api.g_miss_char,
53: lot_number varchar2(80) := fnd_api.g_miss_char,
54: subinv_location_id number := fnd_api.g_miss_num,
55: hr_location_id number := fnd_api.g_miss_num,
48: transaction_date date := fnd_api.g_miss_date,
49: transaction_quantity number := fnd_api.g_miss_num,
50: transaction_uom varchar2(3) := fnd_api.g_miss_char,
51: locator_id number := fnd_api.g_miss_num,
52: serial_number varchar2(30) := fnd_api.g_miss_char,
53: lot_number varchar2(80) := fnd_api.g_miss_char,
54: subinv_location_id number := fnd_api.g_miss_num,
55: hr_location_id number := fnd_api.g_miss_num,
56: mmt_primary_quantity number := fnd_api.g_miss_num,
49: transaction_quantity number := fnd_api.g_miss_num,
50: transaction_uom varchar2(3) := fnd_api.g_miss_char,
51: locator_id number := fnd_api.g_miss_num,
52: serial_number varchar2(30) := fnd_api.g_miss_char,
53: lot_number varchar2(80) := fnd_api.g_miss_char,
54: subinv_location_id number := fnd_api.g_miss_num,
55: hr_location_id number := fnd_api.g_miss_num,
56: mmt_primary_quantity number := fnd_api.g_miss_num,
57: lot_primary_quantity number := fnd_api.g_miss_num,
50: transaction_uom varchar2(3) := fnd_api.g_miss_char,
51: locator_id number := fnd_api.g_miss_num,
52: serial_number varchar2(30) := fnd_api.g_miss_char,
53: lot_number varchar2(80) := fnd_api.g_miss_char,
54: subinv_location_id number := fnd_api.g_miss_num,
55: hr_location_id number := fnd_api.g_miss_num,
56: mmt_primary_quantity number := fnd_api.g_miss_num,
57: lot_primary_quantity number := fnd_api.g_miss_num,
58: instance_quantity number := fnd_api.g_miss_num);
51: locator_id number := fnd_api.g_miss_num,
52: serial_number varchar2(30) := fnd_api.g_miss_char,
53: lot_number varchar2(80) := fnd_api.g_miss_char,
54: subinv_location_id number := fnd_api.g_miss_num,
55: hr_location_id number := fnd_api.g_miss_num,
56: mmt_primary_quantity number := fnd_api.g_miss_num,
57: lot_primary_quantity number := fnd_api.g_miss_num,
58: instance_quantity number := fnd_api.g_miss_num);
59:
52: serial_number varchar2(30) := fnd_api.g_miss_char,
53: lot_number varchar2(80) := fnd_api.g_miss_char,
54: subinv_location_id number := fnd_api.g_miss_num,
55: hr_location_id number := fnd_api.g_miss_num,
56: mmt_primary_quantity number := fnd_api.g_miss_num,
57: lot_primary_quantity number := fnd_api.g_miss_num,
58: instance_quantity number := fnd_api.g_miss_num);
59:
60: TYPE mmt_tbl IS TABLE OF mmt_rec INDEX BY binary_integer;
53: lot_number varchar2(80) := fnd_api.g_miss_char,
54: subinv_location_id number := fnd_api.g_miss_num,
55: hr_location_id number := fnd_api.g_miss_num,
56: mmt_primary_quantity number := fnd_api.g_miss_num,
57: lot_primary_quantity number := fnd_api.g_miss_num,
58: instance_quantity number := fnd_api.g_miss_num);
59:
60: TYPE mmt_tbl IS TABLE OF mmt_rec INDEX BY binary_integer;
61:
54: subinv_location_id number := fnd_api.g_miss_num,
55: hr_location_id number := fnd_api.g_miss_num,
56: mmt_primary_quantity number := fnd_api.g_miss_num,
57: lot_primary_quantity number := fnd_api.g_miss_num,
58: instance_quantity number := fnd_api.g_miss_num);
59:
60: TYPE mmt_tbl IS TABLE OF mmt_rec INDEX BY binary_integer;
61:
62: TYPE requirements_rec IS RECORD(