DBA Data[Home] [Help]

APPS.CSE_DEPLOYMENT_GRP dependencies on FND_API

Line 5: instance_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 6: serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,

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,

Line 7: lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR,

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,

Line 8: inventory_revision VARCHAR2(3) := FND_API.G_MISS_CHAR,

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,

Line 9: last_pa_project_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 10: last_pa_project_task_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,
14: active_end_date DATE := FND_API.G_MISS_DATE,

Line 11: inventory_item_id NUMBER := FND_API.G_MISS_NUM,

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 ,

Line 12: unit_of_measure VARCHAR2(3) := 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 ,
16: operational_status_code VARCHAR2(30) := fnd_api.g_miss_char,

Line 13: active_start_date DATE := FND_API.G_MISS_DATE,

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

Line 14: active_end_date DATE := FND_API.G_MISS_DATE,

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:

Line 15: instance_status_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:
19: TYPE txn_instances_tbl IS TABLE OF txn_instance_rec INDEX BY BINARY_INTEGER ;

Line 16: operational_status_code VARCHAR2(30) := fnd_api.g_miss_char,

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:

Line 17: asset_id number := fnd_api.g_miss_num);

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 (

Line 22: parent_tbl_index 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 (
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,

Line 23: location_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

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,

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

Line 25: instance_usage_code 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,

Line 26: last_pa_project_id NUMBER := fnd_api.g_miss_num,

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,

Line 27: last_pa_project_task_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);

Line 28: external_reference 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);
32:

Line 29: operational_status_code VARCHAR2(30) := fnd_api.g_miss_char,

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 ;

Line 30: pa_project_id number := fnd_api.g_miss_num,

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:

Line 31: pa_project_task_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:
35:

Line 37: attribute_value_id NUMBER := FND_API.G_MISS_NUM,

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 ,

Line 38: parent_tbl_index NUMBER := FND_API.G_MISS_NUM,

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,

Line 39: instance_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 40: attribute_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 41: attribute_code VARCHAR2(30) := fnd_api.g_miss_char ,

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

Line 42: attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR,

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:

Line 43: active_start_date DATE := FND_API.G_MISS_DATE,

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;

Line 44: active_end_date DATE := FND_API.G_MISS_DATE,

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:

Line 45: object_version_number 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:
49: TYPE transaction_rec IS RECORD (

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

Line 51: transaction_date DATE := FND_API.G_MISS_DATE,

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 ,

Line 52: source_transaction_date DATE := FND_API.G_MISS_DATE,

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,

Line 53: transaction_type_id NUMBER := FND_API.G_MISS_NUM ,

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 ,

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

Line 55: source_group_ref_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,
59: transacted_by NUMBER := FND_API.G_MISS_NUM,

Line 56: source_group_ref VARCHAR2(50) := FND_API.G_MISS_CHAR,

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,

Line 57: source_header_ref_id 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,

Line 58: source_header_ref VARCHAR2(50) := FND_API.G_MISS_CHAR,

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,

Line 59: transacted_by 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,

Line 60: transaction_quantity 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,
64: financial_flag varchar2(1) := fnd_api.g_miss_char);

Line 61: proceeds_of_sale number := fnd_api.g_miss_num,

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:

Line 62: cost_of_removal 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:
66: TYPE transaction_tbl IS TABLE OF transaction_rec INDEX BY BINARY_INTEGER ;

Line 63: operational_flag varchar2(1) := 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 ;
67:

Line 64: financial_flag varchar2(1) := fnd_api.g_miss_char);

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