DBA Data[Home] [Help]

APPS.CSI_RMA_RECEIPT_PUB dependencies on FND_API

Line 15: transaction_id number := fnd_api.g_miss_num,

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,

Line 16: oe_line_id number := fnd_api.g_miss_num,

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,

Line 17: inventory_item_id number := fnd_api.g_miss_num,

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,

Line 18: organization_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,

Line 19: revision varchar2(3) := 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,

Line 20: subinventory_code varchar2(10) := 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,

Line 21: locator_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,

Line 22: lot_number varchar2(80) := 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,

Line 23: serial_number varchar2(30) := fnd_api.g_miss_char,

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,

Line 24: inv_location_id 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,

Line 25: primary_uom_code varchar2(3) := 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,
29: transaction_uom varchar2(3) := fnd_api.g_miss_char,

Line 26: mmt_primary_quantity 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,
30: transaction_date date := fnd_api.g_miss_date,

Line 27: lot_primary_quantity number := fnd_api.g_miss_num,

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,

Line 28: transaction_quantity 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,

Line 29: transaction_uom varchar2(3) := fnd_api.g_miss_char,

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,

Line 30: transaction_date date := fnd_api.g_miss_date,

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,

Line 31: last_updated_by 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,

Line 32: transaction_type_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,

Line 34: instance_quantity 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,

Line 35: original_order_line_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,

Line 36: customer_location_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,

Line 37: customer_account_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',

Line 38: party_id number := fnd_api.g_miss_num,

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',

Line 39: txn_line_detail_id 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',
43: mtl_txn_creation_date date := fnd_api.g_miss_date);--bug 4026148

Line 40: sub_type_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
44:

Line 43: mtl_txn_creation_date date := fnd_api.g_miss_date);--bug 4026148

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:

Line 49: inventory_item_id number := fnd_api.g_miss_num,

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,

Line 50: organization_id 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,

Line 51: serial_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,

Line 52: lot_control_code number := fnd_api.g_miss_num,

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,

Line 53: revision_control_code number := fnd_api.g_miss_num,

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,

Line 54: locator_control_code 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,

Line 55: ib_trackable_flag varchar2(1) := fnd_api.g_miss_char,

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,

Line 56: primary_uom_code varchar2(3) := 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);

Line 57: bom_item_type 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);
61:

Line 58: model_item_id 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:
62: TYPE inst_pa_rec IS RECORD (

Line 59: pick_components_flag varchar2(1) := fnd_api.g_miss_char,

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,

Line 60: mult_srl_control_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,
64: internal_party_id number := fnd_api.g_miss_num,

Line 63: instance_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,

Line 64: internal_party_id number := fnd_api.g_miss_num,

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,

Line 65: src_txn_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,

Line 66: src_txn_acct_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,

Line 67: ownership_ovr_flag varchar2(1) := fnd_api.g_miss_char,

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,

Line 68: instance_party_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,
72: ip_account_id number := fnd_api.g_miss_num,

Line 69: 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,
73: account_id number := fnd_api.g_miss_num,

Line 70: pty_obj_version 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,

Line 71: party_rltnshp_code varchar2(30) := fnd_api.g_miss_char,

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);

Line 72: ip_account_id number := fnd_api.g_miss_num,

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:

Line 73: account_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:
77: TYPE tld_inst_rec IS RECORD (

Line 74: acct_obj_version 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 (
78: txn_line_detail_id number := fnd_api.g_miss_num,

Line 75: acct_rltnshp_code varchar2(30) := fnd_api.g_miss_char);

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,

Line 78: txn_line_detail_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,

Line 79: sub_type_id 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,
83: quantity number := fnd_api.g_miss_num,

Line 80: inventory_item_id 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,

Line 81: lot_number varchar2(80) := fnd_api.g_miss_char,

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',

Line 82: serial_number varchar2(30) := fnd_api.g_miss_char,

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',

Line 83: quantity 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',
87: mtl_txn_creation_date date := fnd_api.g_miss_date);--bug 4026148

Line 84: instance_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
88:

Line 87: mtl_txn_creation_date date := fnd_api.g_miss_date);--bug 4026148

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 (

Line 92: transaction_id number := fnd_api.g_miss_num,

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,

Line 93: rma_line_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,

Line 94: original_order_line_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);

Line 95: original_order_qty 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:

Line 96: customer_location_id number := fnd_api.g_miss_num,

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(

Line 97: party_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(
101: transaction_id number,

Line 98: customer_account_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,
102: transaction_date date,