11: /* get_mtl_txn_rec routine populates this data structure */
12: /* ---------------------------------------------------------------------- */
13:
14: TYPE mtl_txn_rec IS RECORD (
15: transaction_id number := fnd_api.g_miss_num,
16: oe_line_id number := fnd_api.g_miss_num,
17: inventory_item_id number := fnd_api.g_miss_num,
18: organization_id number := fnd_api.g_miss_num,
19: revision varchar2(3) := fnd_api.g_miss_char,
12: /* ---------------------------------------------------------------------- */
13:
14: TYPE mtl_txn_rec IS RECORD (
15: transaction_id number := fnd_api.g_miss_num,
16: oe_line_id number := fnd_api.g_miss_num,
17: inventory_item_id number := fnd_api.g_miss_num,
18: organization_id number := fnd_api.g_miss_num,
19: revision varchar2(3) := fnd_api.g_miss_char,
20: subinventory_code varchar2(10) := fnd_api.g_miss_char,
13:
14: TYPE mtl_txn_rec IS RECORD (
15: transaction_id number := fnd_api.g_miss_num,
16: oe_line_id number := fnd_api.g_miss_num,
17: inventory_item_id number := fnd_api.g_miss_num,
18: organization_id number := fnd_api.g_miss_num,
19: revision varchar2(3) := fnd_api.g_miss_char,
20: subinventory_code varchar2(10) := fnd_api.g_miss_char,
21: locator_id number := fnd_api.g_miss_num,
14: TYPE mtl_txn_rec IS RECORD (
15: transaction_id number := fnd_api.g_miss_num,
16: oe_line_id number := fnd_api.g_miss_num,
17: inventory_item_id number := fnd_api.g_miss_num,
18: organization_id number := fnd_api.g_miss_num,
19: revision varchar2(3) := fnd_api.g_miss_char,
20: subinventory_code varchar2(10) := fnd_api.g_miss_char,
21: locator_id number := fnd_api.g_miss_num,
22: lot_number varchar2(80) := fnd_api.g_miss_char,
15: transaction_id number := fnd_api.g_miss_num,
16: oe_line_id number := fnd_api.g_miss_num,
17: inventory_item_id number := fnd_api.g_miss_num,
18: organization_id number := fnd_api.g_miss_num,
19: revision varchar2(3) := fnd_api.g_miss_char,
20: subinventory_code varchar2(10) := fnd_api.g_miss_char,
21: locator_id number := fnd_api.g_miss_num,
22: lot_number varchar2(80) := fnd_api.g_miss_char,
23: serial_number varchar2(30) := fnd_api.g_miss_char,
16: oe_line_id number := fnd_api.g_miss_num,
17: inventory_item_id number := fnd_api.g_miss_num,
18: organization_id number := fnd_api.g_miss_num,
19: revision varchar2(3) := fnd_api.g_miss_char,
20: subinventory_code varchar2(10) := fnd_api.g_miss_char,
21: locator_id number := fnd_api.g_miss_num,
22: lot_number varchar2(80) := fnd_api.g_miss_char,
23: serial_number varchar2(30) := fnd_api.g_miss_char,
24: inv_location_id number := fnd_api.g_miss_num,
17: inventory_item_id number := fnd_api.g_miss_num,
18: organization_id number := fnd_api.g_miss_num,
19: revision varchar2(3) := fnd_api.g_miss_char,
20: subinventory_code varchar2(10) := fnd_api.g_miss_char,
21: locator_id number := fnd_api.g_miss_num,
22: lot_number varchar2(80) := fnd_api.g_miss_char,
23: serial_number varchar2(30) := fnd_api.g_miss_char,
24: inv_location_id number := fnd_api.g_miss_num,
25: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
18: organization_id number := fnd_api.g_miss_num,
19: revision varchar2(3) := fnd_api.g_miss_char,
20: subinventory_code varchar2(10) := fnd_api.g_miss_char,
21: locator_id number := fnd_api.g_miss_num,
22: lot_number varchar2(80) := fnd_api.g_miss_char,
23: serial_number varchar2(30) := fnd_api.g_miss_char,
24: inv_location_id number := fnd_api.g_miss_num,
25: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
26: mmt_primary_quantity number := fnd_api.g_miss_num,
19: revision varchar2(3) := fnd_api.g_miss_char,
20: subinventory_code varchar2(10) := fnd_api.g_miss_char,
21: locator_id number := fnd_api.g_miss_num,
22: lot_number varchar2(80) := fnd_api.g_miss_char,
23: serial_number varchar2(30) := fnd_api.g_miss_char,
24: inv_location_id number := fnd_api.g_miss_num,
25: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
26: mmt_primary_quantity number := fnd_api.g_miss_num,
27: lot_primary_quantity number := fnd_api.g_miss_num,
20: subinventory_code varchar2(10) := fnd_api.g_miss_char,
21: locator_id number := fnd_api.g_miss_num,
22: lot_number varchar2(80) := fnd_api.g_miss_char,
23: serial_number varchar2(30) := fnd_api.g_miss_char,
24: inv_location_id number := fnd_api.g_miss_num,
25: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
26: mmt_primary_quantity number := fnd_api.g_miss_num,
27: lot_primary_quantity number := fnd_api.g_miss_num,
28: transaction_quantity number := fnd_api.g_miss_num,
21: locator_id number := fnd_api.g_miss_num,
22: lot_number varchar2(80) := fnd_api.g_miss_char,
23: serial_number varchar2(30) := fnd_api.g_miss_char,
24: inv_location_id number := fnd_api.g_miss_num,
25: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
26: mmt_primary_quantity number := fnd_api.g_miss_num,
27: lot_primary_quantity number := fnd_api.g_miss_num,
28: transaction_quantity number := fnd_api.g_miss_num,
29: transaction_uom varchar2(3) := fnd_api.g_miss_char,
22: lot_number varchar2(80) := fnd_api.g_miss_char,
23: serial_number varchar2(30) := fnd_api.g_miss_char,
24: inv_location_id number := fnd_api.g_miss_num,
25: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
26: mmt_primary_quantity number := fnd_api.g_miss_num,
27: lot_primary_quantity number := fnd_api.g_miss_num,
28: transaction_quantity number := fnd_api.g_miss_num,
29: transaction_uom varchar2(3) := fnd_api.g_miss_char,
30: transaction_date date := fnd_api.g_miss_date,
23: serial_number varchar2(30) := fnd_api.g_miss_char,
24: inv_location_id number := fnd_api.g_miss_num,
25: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
26: mmt_primary_quantity number := fnd_api.g_miss_num,
27: lot_primary_quantity number := fnd_api.g_miss_num,
28: transaction_quantity number := fnd_api.g_miss_num,
29: transaction_uom varchar2(3) := fnd_api.g_miss_char,
30: transaction_date date := fnd_api.g_miss_date,
31: last_updated_by number := fnd_api.g_miss_num,
24: inv_location_id number := fnd_api.g_miss_num,
25: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
26: mmt_primary_quantity number := fnd_api.g_miss_num,
27: lot_primary_quantity number := fnd_api.g_miss_num,
28: transaction_quantity number := fnd_api.g_miss_num,
29: transaction_uom varchar2(3) := fnd_api.g_miss_char,
30: transaction_date date := fnd_api.g_miss_date,
31: last_updated_by number := fnd_api.g_miss_num,
32: transaction_type_id number := fnd_api.g_miss_num,
25: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
26: mmt_primary_quantity number := fnd_api.g_miss_num,
27: lot_primary_quantity number := fnd_api.g_miss_num,
28: transaction_quantity number := fnd_api.g_miss_num,
29: transaction_uom varchar2(3) := fnd_api.g_miss_char,
30: transaction_date date := fnd_api.g_miss_date,
31: last_updated_by number := fnd_api.g_miss_num,
32: transaction_type_id number := fnd_api.g_miss_num,
33: instance_id number := null,
26: mmt_primary_quantity number := fnd_api.g_miss_num,
27: lot_primary_quantity number := fnd_api.g_miss_num,
28: transaction_quantity number := fnd_api.g_miss_num,
29: transaction_uom varchar2(3) := fnd_api.g_miss_char,
30: transaction_date date := fnd_api.g_miss_date,
31: last_updated_by number := fnd_api.g_miss_num,
32: transaction_type_id number := fnd_api.g_miss_num,
33: instance_id number := null,
34: instance_quantity number := fnd_api.g_miss_num,
27: lot_primary_quantity number := fnd_api.g_miss_num,
28: transaction_quantity number := fnd_api.g_miss_num,
29: transaction_uom varchar2(3) := fnd_api.g_miss_char,
30: transaction_date date := fnd_api.g_miss_date,
31: last_updated_by number := fnd_api.g_miss_num,
32: transaction_type_id number := fnd_api.g_miss_num,
33: instance_id number := null,
34: instance_quantity number := fnd_api.g_miss_num,
35: original_order_line_id number := fnd_api.g_miss_num,
28: transaction_quantity number := fnd_api.g_miss_num,
29: transaction_uom varchar2(3) := fnd_api.g_miss_char,
30: transaction_date date := fnd_api.g_miss_date,
31: last_updated_by number := fnd_api.g_miss_num,
32: transaction_type_id number := fnd_api.g_miss_num,
33: instance_id number := null,
34: instance_quantity number := fnd_api.g_miss_num,
35: original_order_line_id number := fnd_api.g_miss_num,
36: customer_location_id number := fnd_api.g_miss_num,
30: transaction_date date := fnd_api.g_miss_date,
31: last_updated_by number := fnd_api.g_miss_num,
32: transaction_type_id number := fnd_api.g_miss_num,
33: instance_id number := null,
34: instance_quantity number := fnd_api.g_miss_num,
35: original_order_line_id number := fnd_api.g_miss_num,
36: customer_location_id number := fnd_api.g_miss_num,
37: customer_account_id number := fnd_api.g_miss_num,
38: party_id number := fnd_api.g_miss_num,
31: last_updated_by number := fnd_api.g_miss_num,
32: transaction_type_id number := fnd_api.g_miss_num,
33: instance_id number := null,
34: instance_quantity number := fnd_api.g_miss_num,
35: original_order_line_id number := fnd_api.g_miss_num,
36: customer_location_id number := fnd_api.g_miss_num,
37: customer_account_id number := fnd_api.g_miss_num,
38: party_id number := fnd_api.g_miss_num,
39: txn_line_detail_id number := fnd_api.g_miss_num,
32: transaction_type_id number := fnd_api.g_miss_num,
33: instance_id number := null,
34: instance_quantity number := fnd_api.g_miss_num,
35: original_order_line_id number := fnd_api.g_miss_num,
36: customer_location_id number := fnd_api.g_miss_num,
37: customer_account_id number := fnd_api.g_miss_num,
38: party_id number := fnd_api.g_miss_num,
39: txn_line_detail_id number := fnd_api.g_miss_num,
40: sub_type_id number := fnd_api.g_miss_num,
33: instance_id number := null,
34: instance_quantity number := fnd_api.g_miss_num,
35: original_order_line_id number := fnd_api.g_miss_num,
36: customer_location_id number := fnd_api.g_miss_num,
37: customer_account_id number := fnd_api.g_miss_num,
38: party_id number := fnd_api.g_miss_num,
39: txn_line_detail_id number := fnd_api.g_miss_num,
40: sub_type_id number := fnd_api.g_miss_num,
41: verified_flag varchar2(1) := 'N',
34: instance_quantity number := fnd_api.g_miss_num,
35: original_order_line_id number := fnd_api.g_miss_num,
36: customer_location_id number := fnd_api.g_miss_num,
37: customer_account_id number := fnd_api.g_miss_num,
38: party_id number := fnd_api.g_miss_num,
39: txn_line_detail_id number := fnd_api.g_miss_num,
40: sub_type_id number := fnd_api.g_miss_num,
41: verified_flag varchar2(1) := 'N',
42: processed_flag varchar2(1) := 'N',
35: original_order_line_id number := fnd_api.g_miss_num,
36: customer_location_id number := fnd_api.g_miss_num,
37: customer_account_id number := fnd_api.g_miss_num,
38: party_id number := fnd_api.g_miss_num,
39: txn_line_detail_id number := fnd_api.g_miss_num,
40: sub_type_id number := fnd_api.g_miss_num,
41: verified_flag varchar2(1) := 'N',
42: processed_flag varchar2(1) := 'N',
43: mtl_txn_creation_date date := fnd_api.g_miss_date);--bug 4026148
36: customer_location_id number := fnd_api.g_miss_num,
37: customer_account_id number := fnd_api.g_miss_num,
38: party_id number := fnd_api.g_miss_num,
39: txn_line_detail_id number := fnd_api.g_miss_num,
40: sub_type_id number := fnd_api.g_miss_num,
41: verified_flag varchar2(1) := 'N',
42: processed_flag varchar2(1) := 'N',
43: mtl_txn_creation_date date := fnd_api.g_miss_date);--bug 4026148
44:
39: txn_line_detail_id number := fnd_api.g_miss_num,
40: sub_type_id number := fnd_api.g_miss_num,
41: verified_flag varchar2(1) := 'N',
42: processed_flag varchar2(1) := 'N',
43: mtl_txn_creation_date date := fnd_api.g_miss_date);--bug 4026148
44:
45:
46: TYPE mtl_txn_tbl IS TABLE OF mtl_txn_rec INDEX BY BINARY_INTEGER;
47:
45:
46: TYPE mtl_txn_tbl IS TABLE OF mtl_txn_rec INDEX BY BINARY_INTEGER;
47:
48: TYPE item_control_rec IS RECORD (
49: inventory_item_id number := fnd_api.g_miss_num,
50: organization_id number := fnd_api.g_miss_num,
51: serial_control_code number := fnd_api.g_miss_num,
52: lot_control_code number := fnd_api.g_miss_num,
53: revision_control_code number := fnd_api.g_miss_num,
46: TYPE mtl_txn_tbl IS TABLE OF mtl_txn_rec INDEX BY BINARY_INTEGER;
47:
48: TYPE item_control_rec IS RECORD (
49: inventory_item_id number := fnd_api.g_miss_num,
50: organization_id number := fnd_api.g_miss_num,
51: serial_control_code number := fnd_api.g_miss_num,
52: lot_control_code number := fnd_api.g_miss_num,
53: revision_control_code number := fnd_api.g_miss_num,
54: locator_control_code number := fnd_api.g_miss_num,
47:
48: TYPE item_control_rec IS RECORD (
49: inventory_item_id number := fnd_api.g_miss_num,
50: organization_id number := fnd_api.g_miss_num,
51: serial_control_code number := fnd_api.g_miss_num,
52: lot_control_code number := fnd_api.g_miss_num,
53: revision_control_code number := fnd_api.g_miss_num,
54: locator_control_code number := fnd_api.g_miss_num,
55: ib_trackable_flag varchar2(1) := fnd_api.g_miss_char,
48: TYPE item_control_rec IS RECORD (
49: inventory_item_id number := fnd_api.g_miss_num,
50: organization_id number := fnd_api.g_miss_num,
51: serial_control_code number := fnd_api.g_miss_num,
52: lot_control_code number := fnd_api.g_miss_num,
53: revision_control_code number := fnd_api.g_miss_num,
54: locator_control_code number := fnd_api.g_miss_num,
55: ib_trackable_flag varchar2(1) := fnd_api.g_miss_char,
56: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
49: inventory_item_id number := fnd_api.g_miss_num,
50: organization_id number := fnd_api.g_miss_num,
51: serial_control_code number := fnd_api.g_miss_num,
52: lot_control_code number := fnd_api.g_miss_num,
53: revision_control_code number := fnd_api.g_miss_num,
54: locator_control_code number := fnd_api.g_miss_num,
55: ib_trackable_flag varchar2(1) := fnd_api.g_miss_char,
56: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
57: bom_item_type number := fnd_api.g_miss_num,
50: organization_id number := fnd_api.g_miss_num,
51: serial_control_code number := fnd_api.g_miss_num,
52: lot_control_code number := fnd_api.g_miss_num,
53: revision_control_code number := fnd_api.g_miss_num,
54: locator_control_code number := fnd_api.g_miss_num,
55: ib_trackable_flag varchar2(1) := fnd_api.g_miss_char,
56: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
57: bom_item_type number := fnd_api.g_miss_num,
58: model_item_id number := fnd_api.g_miss_num,
51: serial_control_code number := fnd_api.g_miss_num,
52: lot_control_code number := fnd_api.g_miss_num,
53: revision_control_code number := fnd_api.g_miss_num,
54: locator_control_code number := fnd_api.g_miss_num,
55: ib_trackable_flag varchar2(1) := fnd_api.g_miss_char,
56: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
57: bom_item_type number := fnd_api.g_miss_num,
58: model_item_id number := fnd_api.g_miss_num,
59: pick_components_flag varchar2(1) := fnd_api.g_miss_char,
52: lot_control_code number := fnd_api.g_miss_num,
53: revision_control_code number := fnd_api.g_miss_num,
54: locator_control_code number := fnd_api.g_miss_num,
55: ib_trackable_flag varchar2(1) := fnd_api.g_miss_char,
56: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
57: bom_item_type number := fnd_api.g_miss_num,
58: model_item_id number := fnd_api.g_miss_num,
59: pick_components_flag varchar2(1) := fnd_api.g_miss_char,
60: mult_srl_control_flag varchar2(1) := fnd_api.g_miss_char);
53: revision_control_code number := fnd_api.g_miss_num,
54: locator_control_code number := fnd_api.g_miss_num,
55: ib_trackable_flag varchar2(1) := fnd_api.g_miss_char,
56: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
57: bom_item_type number := fnd_api.g_miss_num,
58: model_item_id number := fnd_api.g_miss_num,
59: pick_components_flag varchar2(1) := fnd_api.g_miss_char,
60: mult_srl_control_flag varchar2(1) := fnd_api.g_miss_char);
61:
54: locator_control_code number := fnd_api.g_miss_num,
55: ib_trackable_flag varchar2(1) := fnd_api.g_miss_char,
56: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
57: bom_item_type number := fnd_api.g_miss_num,
58: model_item_id number := fnd_api.g_miss_num,
59: pick_components_flag varchar2(1) := fnd_api.g_miss_char,
60: mult_srl_control_flag varchar2(1) := fnd_api.g_miss_char);
61:
62: TYPE inst_pa_rec IS RECORD (
55: ib_trackable_flag varchar2(1) := fnd_api.g_miss_char,
56: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
57: bom_item_type number := fnd_api.g_miss_num,
58: model_item_id number := fnd_api.g_miss_num,
59: pick_components_flag varchar2(1) := fnd_api.g_miss_char,
60: mult_srl_control_flag varchar2(1) := fnd_api.g_miss_char);
61:
62: TYPE inst_pa_rec IS RECORD (
63: instance_id number := fnd_api.g_miss_num,
56: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
57: bom_item_type number := fnd_api.g_miss_num,
58: model_item_id number := fnd_api.g_miss_num,
59: pick_components_flag varchar2(1) := fnd_api.g_miss_char,
60: mult_srl_control_flag varchar2(1) := fnd_api.g_miss_char);
61:
62: TYPE inst_pa_rec IS RECORD (
63: instance_id number := fnd_api.g_miss_num,
64: internal_party_id number := fnd_api.g_miss_num,
59: pick_components_flag varchar2(1) := fnd_api.g_miss_char,
60: mult_srl_control_flag varchar2(1) := fnd_api.g_miss_char);
61:
62: TYPE inst_pa_rec IS RECORD (
63: instance_id number := fnd_api.g_miss_num,
64: internal_party_id number := fnd_api.g_miss_num,
65: src_txn_party_id number := fnd_api.g_miss_num,
66: src_txn_acct_id number := fnd_api.g_miss_num,
67: ownership_ovr_flag varchar2(1) := fnd_api.g_miss_char,
60: mult_srl_control_flag varchar2(1) := fnd_api.g_miss_char);
61:
62: TYPE inst_pa_rec IS RECORD (
63: instance_id number := fnd_api.g_miss_num,
64: internal_party_id number := fnd_api.g_miss_num,
65: src_txn_party_id number := fnd_api.g_miss_num,
66: src_txn_acct_id number := fnd_api.g_miss_num,
67: ownership_ovr_flag varchar2(1) := fnd_api.g_miss_char,
68: instance_party_id number := fnd_api.g_miss_num,
61:
62: TYPE inst_pa_rec IS RECORD (
63: instance_id number := fnd_api.g_miss_num,
64: internal_party_id number := fnd_api.g_miss_num,
65: src_txn_party_id number := fnd_api.g_miss_num,
66: src_txn_acct_id number := fnd_api.g_miss_num,
67: ownership_ovr_flag varchar2(1) := fnd_api.g_miss_char,
68: instance_party_id number := fnd_api.g_miss_num,
69: party_id number := fnd_api.g_miss_num,
62: TYPE inst_pa_rec IS RECORD (
63: instance_id number := fnd_api.g_miss_num,
64: internal_party_id number := fnd_api.g_miss_num,
65: src_txn_party_id number := fnd_api.g_miss_num,
66: src_txn_acct_id number := fnd_api.g_miss_num,
67: ownership_ovr_flag varchar2(1) := fnd_api.g_miss_char,
68: instance_party_id number := fnd_api.g_miss_num,
69: party_id number := fnd_api.g_miss_num,
70: pty_obj_version number := fnd_api.g_miss_num,
63: instance_id number := fnd_api.g_miss_num,
64: internal_party_id number := fnd_api.g_miss_num,
65: src_txn_party_id number := fnd_api.g_miss_num,
66: src_txn_acct_id number := fnd_api.g_miss_num,
67: ownership_ovr_flag varchar2(1) := fnd_api.g_miss_char,
68: instance_party_id number := fnd_api.g_miss_num,
69: party_id number := fnd_api.g_miss_num,
70: pty_obj_version number := fnd_api.g_miss_num,
71: party_rltnshp_code varchar2(30) := fnd_api.g_miss_char,
64: internal_party_id number := fnd_api.g_miss_num,
65: src_txn_party_id number := fnd_api.g_miss_num,
66: src_txn_acct_id number := fnd_api.g_miss_num,
67: ownership_ovr_flag varchar2(1) := fnd_api.g_miss_char,
68: instance_party_id number := fnd_api.g_miss_num,
69: party_id number := fnd_api.g_miss_num,
70: pty_obj_version number := fnd_api.g_miss_num,
71: party_rltnshp_code varchar2(30) := fnd_api.g_miss_char,
72: ip_account_id number := fnd_api.g_miss_num,
65: src_txn_party_id number := fnd_api.g_miss_num,
66: src_txn_acct_id number := fnd_api.g_miss_num,
67: ownership_ovr_flag varchar2(1) := fnd_api.g_miss_char,
68: instance_party_id number := fnd_api.g_miss_num,
69: party_id number := fnd_api.g_miss_num,
70: pty_obj_version number := fnd_api.g_miss_num,
71: party_rltnshp_code varchar2(30) := fnd_api.g_miss_char,
72: ip_account_id number := fnd_api.g_miss_num,
73: account_id number := fnd_api.g_miss_num,
66: src_txn_acct_id number := fnd_api.g_miss_num,
67: ownership_ovr_flag varchar2(1) := fnd_api.g_miss_char,
68: instance_party_id number := fnd_api.g_miss_num,
69: party_id number := fnd_api.g_miss_num,
70: pty_obj_version number := fnd_api.g_miss_num,
71: party_rltnshp_code varchar2(30) := fnd_api.g_miss_char,
72: ip_account_id number := fnd_api.g_miss_num,
73: account_id number := fnd_api.g_miss_num,
74: acct_obj_version number := fnd_api.g_miss_num,
67: ownership_ovr_flag varchar2(1) := fnd_api.g_miss_char,
68: instance_party_id number := fnd_api.g_miss_num,
69: party_id number := fnd_api.g_miss_num,
70: pty_obj_version number := fnd_api.g_miss_num,
71: party_rltnshp_code varchar2(30) := fnd_api.g_miss_char,
72: ip_account_id number := fnd_api.g_miss_num,
73: account_id number := fnd_api.g_miss_num,
74: acct_obj_version number := fnd_api.g_miss_num,
75: acct_rltnshp_code varchar2(30) := fnd_api.g_miss_char);
68: instance_party_id number := fnd_api.g_miss_num,
69: party_id number := fnd_api.g_miss_num,
70: pty_obj_version number := fnd_api.g_miss_num,
71: party_rltnshp_code varchar2(30) := fnd_api.g_miss_char,
72: ip_account_id number := fnd_api.g_miss_num,
73: account_id number := fnd_api.g_miss_num,
74: acct_obj_version number := fnd_api.g_miss_num,
75: acct_rltnshp_code varchar2(30) := fnd_api.g_miss_char);
76:
69: party_id number := fnd_api.g_miss_num,
70: pty_obj_version number := fnd_api.g_miss_num,
71: party_rltnshp_code varchar2(30) := fnd_api.g_miss_char,
72: ip_account_id number := fnd_api.g_miss_num,
73: account_id number := fnd_api.g_miss_num,
74: acct_obj_version number := fnd_api.g_miss_num,
75: acct_rltnshp_code varchar2(30) := fnd_api.g_miss_char);
76:
77: TYPE tld_inst_rec IS RECORD (
70: pty_obj_version number := fnd_api.g_miss_num,
71: party_rltnshp_code varchar2(30) := fnd_api.g_miss_char,
72: ip_account_id number := fnd_api.g_miss_num,
73: account_id number := fnd_api.g_miss_num,
74: acct_obj_version number := fnd_api.g_miss_num,
75: acct_rltnshp_code varchar2(30) := fnd_api.g_miss_char);
76:
77: TYPE tld_inst_rec IS RECORD (
78: txn_line_detail_id number := fnd_api.g_miss_num,
71: party_rltnshp_code varchar2(30) := fnd_api.g_miss_char,
72: ip_account_id number := fnd_api.g_miss_num,
73: account_id number := fnd_api.g_miss_num,
74: acct_obj_version number := fnd_api.g_miss_num,
75: acct_rltnshp_code varchar2(30) := fnd_api.g_miss_char);
76:
77: TYPE tld_inst_rec IS RECORD (
78: txn_line_detail_id number := fnd_api.g_miss_num,
79: sub_type_id number := fnd_api.g_miss_num,
74: acct_obj_version number := fnd_api.g_miss_num,
75: acct_rltnshp_code varchar2(30) := fnd_api.g_miss_char);
76:
77: TYPE tld_inst_rec IS RECORD (
78: txn_line_detail_id number := fnd_api.g_miss_num,
79: sub_type_id number := fnd_api.g_miss_num,
80: inventory_item_id number := fnd_api.g_miss_num,
81: lot_number varchar2(80) := fnd_api.g_miss_char,
82: serial_number varchar2(30) := fnd_api.g_miss_char,
75: acct_rltnshp_code varchar2(30) := fnd_api.g_miss_char);
76:
77: TYPE tld_inst_rec IS RECORD (
78: txn_line_detail_id number := fnd_api.g_miss_num,
79: sub_type_id number := fnd_api.g_miss_num,
80: inventory_item_id number := fnd_api.g_miss_num,
81: lot_number varchar2(80) := fnd_api.g_miss_char,
82: serial_number varchar2(30) := fnd_api.g_miss_char,
83: quantity number := fnd_api.g_miss_num,
76:
77: TYPE tld_inst_rec IS RECORD (
78: txn_line_detail_id number := fnd_api.g_miss_num,
79: sub_type_id number := fnd_api.g_miss_num,
80: inventory_item_id number := fnd_api.g_miss_num,
81: lot_number varchar2(80) := fnd_api.g_miss_char,
82: serial_number varchar2(30) := fnd_api.g_miss_char,
83: quantity number := fnd_api.g_miss_num,
84: instance_id number := fnd_api.g_miss_num,
77: TYPE tld_inst_rec IS RECORD (
78: txn_line_detail_id number := fnd_api.g_miss_num,
79: sub_type_id number := fnd_api.g_miss_num,
80: inventory_item_id number := fnd_api.g_miss_num,
81: lot_number varchar2(80) := fnd_api.g_miss_char,
82: serial_number varchar2(30) := fnd_api.g_miss_char,
83: quantity number := fnd_api.g_miss_num,
84: instance_id number := fnd_api.g_miss_num,
85: verified_flag varchar2(1) := 'N',
78: txn_line_detail_id number := fnd_api.g_miss_num,
79: sub_type_id number := fnd_api.g_miss_num,
80: inventory_item_id number := fnd_api.g_miss_num,
81: lot_number varchar2(80) := fnd_api.g_miss_char,
82: serial_number varchar2(30) := fnd_api.g_miss_char,
83: quantity number := fnd_api.g_miss_num,
84: instance_id number := fnd_api.g_miss_num,
85: verified_flag varchar2(1) := 'N',
86: processed_flag varchar2(1) := 'N',
79: sub_type_id number := fnd_api.g_miss_num,
80: inventory_item_id number := fnd_api.g_miss_num,
81: lot_number varchar2(80) := fnd_api.g_miss_char,
82: serial_number varchar2(30) := fnd_api.g_miss_char,
83: quantity number := fnd_api.g_miss_num,
84: instance_id number := fnd_api.g_miss_num,
85: verified_flag varchar2(1) := 'N',
86: processed_flag varchar2(1) := 'N',
87: mtl_txn_creation_date date := fnd_api.g_miss_date);--bug 4026148
80: inventory_item_id number := fnd_api.g_miss_num,
81: lot_number varchar2(80) := fnd_api.g_miss_char,
82: serial_number varchar2(30) := fnd_api.g_miss_char,
83: quantity number := fnd_api.g_miss_num,
84: instance_id number := fnd_api.g_miss_num,
85: verified_flag varchar2(1) := 'N',
86: processed_flag varchar2(1) := 'N',
87: mtl_txn_creation_date date := fnd_api.g_miss_date);--bug 4026148
88:
83: quantity number := fnd_api.g_miss_num,
84: instance_id number := fnd_api.g_miss_num,
85: verified_flag varchar2(1) := 'N',
86: processed_flag varchar2(1) := 'N',
87: mtl_txn_creation_date date := fnd_api.g_miss_date);--bug 4026148
88:
89: TYPE tld_inst_tbl IS TABLE OF tld_inst_rec INDEX BY BINARY_INTEGER;
90:
91: TYPE source_order_rec IS RECORD (
88:
89: TYPE tld_inst_tbl IS TABLE OF tld_inst_rec INDEX BY BINARY_INTEGER;
90:
91: TYPE source_order_rec IS RECORD (
92: transaction_id number := fnd_api.g_miss_num,
93: rma_line_id number := fnd_api.g_miss_num,
94: original_order_line_id number := fnd_api.g_miss_num,
95: original_order_qty number := fnd_api.g_miss_num,
96: customer_location_id number := fnd_api.g_miss_num,
89: TYPE tld_inst_tbl IS TABLE OF tld_inst_rec INDEX BY BINARY_INTEGER;
90:
91: TYPE source_order_rec IS RECORD (
92: transaction_id number := fnd_api.g_miss_num,
93: rma_line_id number := fnd_api.g_miss_num,
94: original_order_line_id number := fnd_api.g_miss_num,
95: original_order_qty number := fnd_api.g_miss_num,
96: customer_location_id number := fnd_api.g_miss_num,
97: party_id number := fnd_api.g_miss_num,
90:
91: TYPE source_order_rec IS RECORD (
92: transaction_id number := fnd_api.g_miss_num,
93: rma_line_id number := fnd_api.g_miss_num,
94: original_order_line_id number := fnd_api.g_miss_num,
95: original_order_qty number := fnd_api.g_miss_num,
96: customer_location_id number := fnd_api.g_miss_num,
97: party_id number := fnd_api.g_miss_num,
98: customer_account_id number := fnd_api.g_miss_num);
91: TYPE source_order_rec IS RECORD (
92: transaction_id number := fnd_api.g_miss_num,
93: rma_line_id number := fnd_api.g_miss_num,
94: original_order_line_id number := fnd_api.g_miss_num,
95: original_order_qty number := fnd_api.g_miss_num,
96: customer_location_id number := fnd_api.g_miss_num,
97: party_id number := fnd_api.g_miss_num,
98: customer_account_id number := fnd_api.g_miss_num);
99:
92: transaction_id number := fnd_api.g_miss_num,
93: rma_line_id number := fnd_api.g_miss_num,
94: original_order_line_id number := fnd_api.g_miss_num,
95: original_order_qty number := fnd_api.g_miss_num,
96: customer_location_id number := fnd_api.g_miss_num,
97: party_id number := fnd_api.g_miss_num,
98: customer_account_id number := fnd_api.g_miss_num);
99:
100: TYPE mtl_trx_type IS RECORD(
93: rma_line_id number := fnd_api.g_miss_num,
94: original_order_line_id number := fnd_api.g_miss_num,
95: original_order_qty number := fnd_api.g_miss_num,
96: customer_location_id number := fnd_api.g_miss_num,
97: party_id number := fnd_api.g_miss_num,
98: customer_account_id number := fnd_api.g_miss_num);
99:
100: TYPE mtl_trx_type IS RECORD(
101: transaction_id number,
94: original_order_line_id number := fnd_api.g_miss_num,
95: original_order_qty number := fnd_api.g_miss_num,
96: customer_location_id number := fnd_api.g_miss_num,
97: party_id number := fnd_api.g_miss_num,
98: customer_account_id number := fnd_api.g_miss_num);
99:
100: TYPE mtl_trx_type IS RECORD(
101: transaction_id number,
102: transaction_date date,