1: PACKAGE cse_deployment_grp AUTHID CURRENT_USER AS
2: /* $Header: CSEDPLGS.pls 120.4.12010000.2 2009/07/09 08:26:24 aradhakr ship $ */
3:
4: TYPE txn_instance_rec is RECORD (
5: instance_id NUMBER := FND_API.G_MISS_NUM,
6: serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
7: lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR,
8: inventory_revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
9: last_pa_project_id NUMBER := FND_API.G_MISS_NUM,
2: /* $Header: CSEDPLGS.pls 120.4.12010000.2 2009/07/09 08:26:24 aradhakr ship $ */
3:
4: TYPE txn_instance_rec is RECORD (
5: instance_id NUMBER := FND_API.G_MISS_NUM,
6: serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
7: lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR,
8: inventory_revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
9: last_pa_project_id NUMBER := FND_API.G_MISS_NUM,
10: last_pa_project_task_id NUMBER := FND_API.G_MISS_NUM,
3:
4: TYPE txn_instance_rec is RECORD (
5: instance_id NUMBER := FND_API.G_MISS_NUM,
6: serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
7: lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR,
8: inventory_revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
9: last_pa_project_id NUMBER := FND_API.G_MISS_NUM,
10: last_pa_project_task_id NUMBER := FND_API.G_MISS_NUM,
11: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
4: TYPE txn_instance_rec is RECORD (
5: instance_id NUMBER := FND_API.G_MISS_NUM,
6: serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
7: lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR,
8: inventory_revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
9: last_pa_project_id NUMBER := FND_API.G_MISS_NUM,
10: last_pa_project_task_id NUMBER := FND_API.G_MISS_NUM,
11: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
12: unit_of_measure VARCHAR2(3) := FND_API.G_MISS_CHAR,
5: instance_id NUMBER := FND_API.G_MISS_NUM,
6: serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
7: lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR,
8: inventory_revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
9: last_pa_project_id NUMBER := FND_API.G_MISS_NUM,
10: last_pa_project_task_id NUMBER := FND_API.G_MISS_NUM,
11: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
12: unit_of_measure VARCHAR2(3) := FND_API.G_MISS_CHAR,
13: active_start_date DATE := FND_API.G_MISS_DATE,
6: serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
7: lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR,
8: inventory_revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
9: last_pa_project_id NUMBER := FND_API.G_MISS_NUM,
10: last_pa_project_task_id NUMBER := FND_API.G_MISS_NUM,
11: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
12: unit_of_measure VARCHAR2(3) := FND_API.G_MISS_CHAR,
13: active_start_date DATE := FND_API.G_MISS_DATE,
14: active_end_date DATE := FND_API.G_MISS_DATE,
7: lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR,
8: inventory_revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
9: last_pa_project_id NUMBER := FND_API.G_MISS_NUM,
10: last_pa_project_task_id NUMBER := FND_API.G_MISS_NUM,
11: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
12: unit_of_measure VARCHAR2(3) := FND_API.G_MISS_CHAR,
13: active_start_date DATE := FND_API.G_MISS_DATE,
14: active_end_date DATE := FND_API.G_MISS_DATE,
15: instance_status_id NUMBER := FND_API.G_MISS_NUM ,
8: inventory_revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
9: last_pa_project_id NUMBER := FND_API.G_MISS_NUM,
10: last_pa_project_task_id NUMBER := FND_API.G_MISS_NUM,
11: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
12: unit_of_measure VARCHAR2(3) := FND_API.G_MISS_CHAR,
13: active_start_date DATE := FND_API.G_MISS_DATE,
14: active_end_date DATE := FND_API.G_MISS_DATE,
15: instance_status_id NUMBER := FND_API.G_MISS_NUM ,
16: operational_status_code VARCHAR2(30) := fnd_api.g_miss_char,
9: last_pa_project_id NUMBER := FND_API.G_MISS_NUM,
10: last_pa_project_task_id NUMBER := FND_API.G_MISS_NUM,
11: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
12: unit_of_measure VARCHAR2(3) := FND_API.G_MISS_CHAR,
13: active_start_date DATE := FND_API.G_MISS_DATE,
14: active_end_date DATE := FND_API.G_MISS_DATE,
15: instance_status_id NUMBER := FND_API.G_MISS_NUM ,
16: operational_status_code VARCHAR2(30) := fnd_api.g_miss_char,
17: asset_id number := fnd_api.g_miss_num);
10: last_pa_project_task_id NUMBER := FND_API.G_MISS_NUM,
11: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
12: unit_of_measure VARCHAR2(3) := FND_API.G_MISS_CHAR,
13: active_start_date DATE := FND_API.G_MISS_DATE,
14: active_end_date DATE := FND_API.G_MISS_DATE,
15: instance_status_id NUMBER := FND_API.G_MISS_NUM ,
16: operational_status_code VARCHAR2(30) := fnd_api.g_miss_char,
17: asset_id number := fnd_api.g_miss_num);
18:
11: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
12: unit_of_measure VARCHAR2(3) := FND_API.G_MISS_CHAR,
13: active_start_date DATE := FND_API.G_MISS_DATE,
14: active_end_date DATE := FND_API.G_MISS_DATE,
15: instance_status_id NUMBER := FND_API.G_MISS_NUM ,
16: operational_status_code VARCHAR2(30) := fnd_api.g_miss_char,
17: asset_id number := fnd_api.g_miss_num);
18:
19: TYPE txn_instances_tbl IS TABLE OF txn_instance_rec INDEX BY BINARY_INTEGER ;
12: unit_of_measure VARCHAR2(3) := FND_API.G_MISS_CHAR,
13: active_start_date DATE := FND_API.G_MISS_DATE,
14: active_end_date DATE := FND_API.G_MISS_DATE,
15: instance_status_id NUMBER := FND_API.G_MISS_NUM ,
16: operational_status_code VARCHAR2(30) := fnd_api.g_miss_char,
17: asset_id number := fnd_api.g_miss_num);
18:
19: TYPE txn_instances_tbl IS TABLE OF txn_instance_rec INDEX BY BINARY_INTEGER ;
20:
13: active_start_date DATE := FND_API.G_MISS_DATE,
14: active_end_date DATE := FND_API.G_MISS_DATE,
15: instance_status_id NUMBER := FND_API.G_MISS_NUM ,
16: operational_status_code VARCHAR2(30) := fnd_api.g_miss_char,
17: asset_id number := fnd_api.g_miss_num);
18:
19: TYPE txn_instances_tbl IS TABLE OF txn_instance_rec INDEX BY BINARY_INTEGER ;
20:
21: TYPE dest_location_rec IS RECORD (
18:
19: TYPE txn_instances_tbl IS TABLE OF txn_instance_rec INDEX BY BINARY_INTEGER ;
20:
21: TYPE dest_location_rec IS RECORD (
22: parent_tbl_index NUMBER := fnd_api.g_miss_num,
23: location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
24: location_id NUMBER := FND_API.G_MISS_NUM,
25: instance_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
26: last_pa_project_id NUMBER := fnd_api.g_miss_num,
19: TYPE txn_instances_tbl IS TABLE OF txn_instance_rec INDEX BY BINARY_INTEGER ;
20:
21: TYPE dest_location_rec IS RECORD (
22: parent_tbl_index NUMBER := fnd_api.g_miss_num,
23: location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
24: location_id NUMBER := FND_API.G_MISS_NUM,
25: instance_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
26: last_pa_project_id NUMBER := fnd_api.g_miss_num,
27: last_pa_project_task_id NUMBER := fnd_api.g_miss_num,
20:
21: TYPE dest_location_rec IS RECORD (
22: parent_tbl_index NUMBER := fnd_api.g_miss_num,
23: location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
24: location_id NUMBER := FND_API.G_MISS_NUM,
25: instance_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
26: last_pa_project_id NUMBER := fnd_api.g_miss_num,
27: last_pa_project_task_id NUMBER := fnd_api.g_miss_num,
28: external_reference VARCHAR2(30) := fnd_api.g_miss_char,
21: TYPE dest_location_rec IS RECORD (
22: parent_tbl_index NUMBER := fnd_api.g_miss_num,
23: location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
24: location_id NUMBER := FND_API.G_MISS_NUM,
25: instance_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
26: last_pa_project_id NUMBER := fnd_api.g_miss_num,
27: last_pa_project_task_id NUMBER := fnd_api.g_miss_num,
28: external_reference VARCHAR2(30) := fnd_api.g_miss_char,
29: operational_status_code VARCHAR2(30) := fnd_api.g_miss_char,
22: parent_tbl_index NUMBER := fnd_api.g_miss_num,
23: location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
24: location_id NUMBER := FND_API.G_MISS_NUM,
25: instance_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
26: last_pa_project_id NUMBER := fnd_api.g_miss_num,
27: last_pa_project_task_id NUMBER := fnd_api.g_miss_num,
28: external_reference VARCHAR2(30) := fnd_api.g_miss_char,
29: operational_status_code VARCHAR2(30) := fnd_api.g_miss_char,
30: pa_project_id number := fnd_api.g_miss_num,
23: location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
24: location_id NUMBER := FND_API.G_MISS_NUM,
25: instance_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
26: last_pa_project_id NUMBER := fnd_api.g_miss_num,
27: last_pa_project_task_id NUMBER := fnd_api.g_miss_num,
28: external_reference VARCHAR2(30) := fnd_api.g_miss_char,
29: operational_status_code VARCHAR2(30) := fnd_api.g_miss_char,
30: pa_project_id number := fnd_api.g_miss_num,
31: pa_project_task_id number := fnd_api.g_miss_num);
24: location_id NUMBER := FND_API.G_MISS_NUM,
25: instance_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
26: last_pa_project_id NUMBER := fnd_api.g_miss_num,
27: last_pa_project_task_id NUMBER := fnd_api.g_miss_num,
28: external_reference VARCHAR2(30) := fnd_api.g_miss_char,
29: operational_status_code VARCHAR2(30) := fnd_api.g_miss_char,
30: pa_project_id number := fnd_api.g_miss_num,
31: pa_project_task_id number := fnd_api.g_miss_num);
32:
25: instance_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
26: last_pa_project_id NUMBER := fnd_api.g_miss_num,
27: last_pa_project_task_id NUMBER := fnd_api.g_miss_num,
28: external_reference VARCHAR2(30) := fnd_api.g_miss_char,
29: operational_status_code VARCHAR2(30) := fnd_api.g_miss_char,
30: pa_project_id number := fnd_api.g_miss_num,
31: pa_project_task_id number := fnd_api.g_miss_num);
32:
33: TYPE dest_location_tbl IS TABLE OF dest_location_rec INDEX BY BINARY_INTEGER ;
26: last_pa_project_id NUMBER := fnd_api.g_miss_num,
27: last_pa_project_task_id NUMBER := fnd_api.g_miss_num,
28: external_reference VARCHAR2(30) := fnd_api.g_miss_char,
29: operational_status_code VARCHAR2(30) := fnd_api.g_miss_char,
30: pa_project_id number := fnd_api.g_miss_num,
31: pa_project_task_id number := fnd_api.g_miss_num);
32:
33: TYPE dest_location_tbl IS TABLE OF dest_location_rec INDEX BY BINARY_INTEGER ;
34:
27: last_pa_project_task_id NUMBER := fnd_api.g_miss_num,
28: external_reference VARCHAR2(30) := fnd_api.g_miss_char,
29: operational_status_code VARCHAR2(30) := fnd_api.g_miss_char,
30: pa_project_id number := fnd_api.g_miss_num,
31: pa_project_task_id number := fnd_api.g_miss_num);
32:
33: TYPE dest_location_tbl IS TABLE OF dest_location_rec INDEX BY BINARY_INTEGER ;
34:
35:
33: TYPE dest_location_tbl IS TABLE OF dest_location_rec INDEX BY BINARY_INTEGER ;
34:
35:
36: TYPE txn_ext_attrib_value_rec IS RECORD (
37: attribute_value_id NUMBER := FND_API.G_MISS_NUM,
38: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
39: instance_id NUMBER := FND_API.G_MISS_NUM,
40: attribute_id NUMBER := FND_API.G_MISS_NUM,
41: attribute_code VARCHAR2(30) := fnd_api.g_miss_char ,
34:
35:
36: TYPE txn_ext_attrib_value_rec IS RECORD (
37: attribute_value_id NUMBER := FND_API.G_MISS_NUM,
38: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
39: instance_id NUMBER := FND_API.G_MISS_NUM,
40: attribute_id NUMBER := FND_API.G_MISS_NUM,
41: attribute_code VARCHAR2(30) := fnd_api.g_miss_char ,
42: attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
35:
36: TYPE txn_ext_attrib_value_rec IS RECORD (
37: attribute_value_id NUMBER := FND_API.G_MISS_NUM,
38: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
39: instance_id NUMBER := FND_API.G_MISS_NUM,
40: attribute_id NUMBER := FND_API.G_MISS_NUM,
41: attribute_code VARCHAR2(30) := fnd_api.g_miss_char ,
42: attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: active_start_date DATE := FND_API.G_MISS_DATE,
36: TYPE txn_ext_attrib_value_rec IS RECORD (
37: attribute_value_id NUMBER := FND_API.G_MISS_NUM,
38: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
39: instance_id NUMBER := FND_API.G_MISS_NUM,
40: attribute_id NUMBER := FND_API.G_MISS_NUM,
41: attribute_code VARCHAR2(30) := fnd_api.g_miss_char ,
42: attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: active_start_date DATE := FND_API.G_MISS_DATE,
44: active_end_date DATE := FND_API.G_MISS_DATE,
37: attribute_value_id NUMBER := FND_API.G_MISS_NUM,
38: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
39: instance_id NUMBER := FND_API.G_MISS_NUM,
40: attribute_id NUMBER := FND_API.G_MISS_NUM,
41: attribute_code VARCHAR2(30) := fnd_api.g_miss_char ,
42: attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: active_start_date DATE := FND_API.G_MISS_DATE,
44: active_end_date DATE := FND_API.G_MISS_DATE,
45: object_version_number NUMBER := FND_API.G_MISS_NUM);
38: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,
39: instance_id NUMBER := FND_API.G_MISS_NUM,
40: attribute_id NUMBER := FND_API.G_MISS_NUM,
41: attribute_code VARCHAR2(30) := fnd_api.g_miss_char ,
42: attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: active_start_date DATE := FND_API.G_MISS_DATE,
44: active_end_date DATE := FND_API.G_MISS_DATE,
45: object_version_number NUMBER := FND_API.G_MISS_NUM);
46:
39: instance_id NUMBER := FND_API.G_MISS_NUM,
40: attribute_id NUMBER := FND_API.G_MISS_NUM,
41: attribute_code VARCHAR2(30) := fnd_api.g_miss_char ,
42: attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: active_start_date DATE := FND_API.G_MISS_DATE,
44: active_end_date DATE := FND_API.G_MISS_DATE,
45: object_version_number NUMBER := FND_API.G_MISS_NUM);
46:
47: TYPE txn_ext_attrib_values_tbl IS table of txn_ext_attrib_value_rec INDEX BY BINARY_INTEGER;
40: attribute_id NUMBER := FND_API.G_MISS_NUM,
41: attribute_code VARCHAR2(30) := fnd_api.g_miss_char ,
42: attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: active_start_date DATE := FND_API.G_MISS_DATE,
44: active_end_date DATE := FND_API.G_MISS_DATE,
45: object_version_number NUMBER := FND_API.G_MISS_NUM);
46:
47: TYPE txn_ext_attrib_values_tbl IS table of txn_ext_attrib_value_rec INDEX BY BINARY_INTEGER;
48:
41: attribute_code VARCHAR2(30) := fnd_api.g_miss_char ,
42: attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: active_start_date DATE := FND_API.G_MISS_DATE,
44: active_end_date DATE := FND_API.G_MISS_DATE,
45: object_version_number NUMBER := FND_API.G_MISS_NUM);
46:
47: TYPE txn_ext_attrib_values_tbl IS table of txn_ext_attrib_value_rec INDEX BY BINARY_INTEGER;
48:
49: TYPE transaction_rec IS RECORD (
46:
47: TYPE txn_ext_attrib_values_tbl IS table of txn_ext_attrib_value_rec INDEX BY BINARY_INTEGER;
48:
49: TYPE transaction_rec IS RECORD (
50: transaction_id NUMBER := FND_API.G_MISS_NUM ,
51: transaction_date DATE := FND_API.G_MISS_DATE,
52: source_transaction_date DATE := FND_API.G_MISS_DATE,
53: transaction_type_id NUMBER := FND_API.G_MISS_NUM ,
54: txn_sub_type_id NUMBER := FND_API.G_MISS_NUM ,
47: TYPE txn_ext_attrib_values_tbl IS table of txn_ext_attrib_value_rec INDEX BY BINARY_INTEGER;
48:
49: TYPE transaction_rec IS RECORD (
50: transaction_id NUMBER := FND_API.G_MISS_NUM ,
51: transaction_date DATE := FND_API.G_MISS_DATE,
52: source_transaction_date DATE := FND_API.G_MISS_DATE,
53: transaction_type_id NUMBER := FND_API.G_MISS_NUM ,
54: txn_sub_type_id NUMBER := FND_API.G_MISS_NUM ,
55: source_group_ref_id NUMBER := FND_API.G_MISS_NUM ,
48:
49: TYPE transaction_rec IS RECORD (
50: transaction_id NUMBER := FND_API.G_MISS_NUM ,
51: transaction_date DATE := FND_API.G_MISS_DATE,
52: source_transaction_date DATE := FND_API.G_MISS_DATE,
53: transaction_type_id NUMBER := FND_API.G_MISS_NUM ,
54: txn_sub_type_id NUMBER := FND_API.G_MISS_NUM ,
55: source_group_ref_id NUMBER := FND_API.G_MISS_NUM ,
56: source_group_ref VARCHAR2(50) := FND_API.G_MISS_CHAR,
49: TYPE transaction_rec IS RECORD (
50: transaction_id NUMBER := FND_API.G_MISS_NUM ,
51: transaction_date DATE := FND_API.G_MISS_DATE,
52: source_transaction_date DATE := FND_API.G_MISS_DATE,
53: transaction_type_id NUMBER := FND_API.G_MISS_NUM ,
54: txn_sub_type_id NUMBER := FND_API.G_MISS_NUM ,
55: source_group_ref_id NUMBER := FND_API.G_MISS_NUM ,
56: source_group_ref VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: source_header_ref_id NUMBER := FND_API.G_MISS_NUM ,
50: transaction_id NUMBER := FND_API.G_MISS_NUM ,
51: transaction_date DATE := FND_API.G_MISS_DATE,
52: source_transaction_date DATE := FND_API.G_MISS_DATE,
53: transaction_type_id NUMBER := FND_API.G_MISS_NUM ,
54: txn_sub_type_id NUMBER := FND_API.G_MISS_NUM ,
55: source_group_ref_id NUMBER := FND_API.G_MISS_NUM ,
56: source_group_ref VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: source_header_ref_id NUMBER := FND_API.G_MISS_NUM ,
58: source_header_ref VARCHAR2(50) := FND_API.G_MISS_CHAR,
51: transaction_date DATE := FND_API.G_MISS_DATE,
52: source_transaction_date DATE := FND_API.G_MISS_DATE,
53: transaction_type_id NUMBER := FND_API.G_MISS_NUM ,
54: txn_sub_type_id NUMBER := FND_API.G_MISS_NUM ,
55: source_group_ref_id NUMBER := FND_API.G_MISS_NUM ,
56: source_group_ref VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: source_header_ref_id NUMBER := FND_API.G_MISS_NUM ,
58: source_header_ref VARCHAR2(50) := FND_API.G_MISS_CHAR,
59: transacted_by NUMBER := FND_API.G_MISS_NUM,
52: source_transaction_date DATE := FND_API.G_MISS_DATE,
53: transaction_type_id NUMBER := FND_API.G_MISS_NUM ,
54: txn_sub_type_id NUMBER := FND_API.G_MISS_NUM ,
55: source_group_ref_id NUMBER := FND_API.G_MISS_NUM ,
56: source_group_ref VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: source_header_ref_id NUMBER := FND_API.G_MISS_NUM ,
58: source_header_ref VARCHAR2(50) := FND_API.G_MISS_CHAR,
59: transacted_by NUMBER := FND_API.G_MISS_NUM,
60: transaction_quantity NUMBER := FND_API.G_MISS_NUM,
53: transaction_type_id NUMBER := FND_API.G_MISS_NUM ,
54: txn_sub_type_id NUMBER := FND_API.G_MISS_NUM ,
55: source_group_ref_id NUMBER := FND_API.G_MISS_NUM ,
56: source_group_ref VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: source_header_ref_id NUMBER := FND_API.G_MISS_NUM ,
58: source_header_ref VARCHAR2(50) := FND_API.G_MISS_CHAR,
59: transacted_by NUMBER := FND_API.G_MISS_NUM,
60: transaction_quantity NUMBER := FND_API.G_MISS_NUM,
61: proceeds_of_sale number := fnd_api.g_miss_num,
54: txn_sub_type_id NUMBER := FND_API.G_MISS_NUM ,
55: source_group_ref_id NUMBER := FND_API.G_MISS_NUM ,
56: source_group_ref VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: source_header_ref_id NUMBER := FND_API.G_MISS_NUM ,
58: source_header_ref VARCHAR2(50) := FND_API.G_MISS_CHAR,
59: transacted_by NUMBER := FND_API.G_MISS_NUM,
60: transaction_quantity NUMBER := FND_API.G_MISS_NUM,
61: proceeds_of_sale number := fnd_api.g_miss_num,
62: cost_of_removal number := fnd_api.g_miss_num,
55: source_group_ref_id NUMBER := FND_API.G_MISS_NUM ,
56: source_group_ref VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: source_header_ref_id NUMBER := FND_API.G_MISS_NUM ,
58: source_header_ref VARCHAR2(50) := FND_API.G_MISS_CHAR,
59: transacted_by NUMBER := FND_API.G_MISS_NUM,
60: transaction_quantity NUMBER := FND_API.G_MISS_NUM,
61: proceeds_of_sale number := fnd_api.g_miss_num,
62: cost_of_removal number := fnd_api.g_miss_num,
63: operational_flag varchar2(1) := fnd_api.g_miss_char,
56: source_group_ref VARCHAR2(50) := FND_API.G_MISS_CHAR,
57: source_header_ref_id NUMBER := FND_API.G_MISS_NUM ,
58: source_header_ref VARCHAR2(50) := FND_API.G_MISS_CHAR,
59: transacted_by NUMBER := FND_API.G_MISS_NUM,
60: transaction_quantity NUMBER := FND_API.G_MISS_NUM,
61: proceeds_of_sale number := fnd_api.g_miss_num,
62: cost_of_removal number := fnd_api.g_miss_num,
63: operational_flag varchar2(1) := fnd_api.g_miss_char,
64: financial_flag varchar2(1) := fnd_api.g_miss_char);
57: source_header_ref_id NUMBER := FND_API.G_MISS_NUM ,
58: source_header_ref VARCHAR2(50) := FND_API.G_MISS_CHAR,
59: transacted_by NUMBER := FND_API.G_MISS_NUM,
60: transaction_quantity NUMBER := FND_API.G_MISS_NUM,
61: proceeds_of_sale number := fnd_api.g_miss_num,
62: cost_of_removal number := fnd_api.g_miss_num,
63: operational_flag varchar2(1) := fnd_api.g_miss_char,
64: financial_flag varchar2(1) := fnd_api.g_miss_char);
65:
58: source_header_ref VARCHAR2(50) := FND_API.G_MISS_CHAR,
59: transacted_by NUMBER := FND_API.G_MISS_NUM,
60: transaction_quantity NUMBER := FND_API.G_MISS_NUM,
61: proceeds_of_sale number := fnd_api.g_miss_num,
62: cost_of_removal number := fnd_api.g_miss_num,
63: operational_flag varchar2(1) := fnd_api.g_miss_char,
64: financial_flag varchar2(1) := fnd_api.g_miss_char);
65:
66: TYPE transaction_tbl IS TABLE OF transaction_rec INDEX BY BINARY_INTEGER ;
59: transacted_by NUMBER := FND_API.G_MISS_NUM,
60: transaction_quantity NUMBER := FND_API.G_MISS_NUM,
61: proceeds_of_sale number := fnd_api.g_miss_num,
62: cost_of_removal number := fnd_api.g_miss_num,
63: operational_flag varchar2(1) := fnd_api.g_miss_char,
64: financial_flag varchar2(1) := fnd_api.g_miss_char);
65:
66: TYPE transaction_tbl IS TABLE OF transaction_rec INDEX BY BINARY_INTEGER ;
67:
60: transaction_quantity NUMBER := FND_API.G_MISS_NUM,
61: proceeds_of_sale number := fnd_api.g_miss_num,
62: cost_of_removal number := fnd_api.g_miss_num,
63: operational_flag varchar2(1) := fnd_api.g_miss_char,
64: financial_flag varchar2(1) := fnd_api.g_miss_char);
65:
66: TYPE transaction_tbl IS TABLE OF transaction_rec INDEX BY BINARY_INTEGER ;
67:
68: -- Added for bug 8670632