[Home] [Help]
PACKAGE: APPS.CSE_DEPLOYMENT_GRP
Source
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,
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
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,
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
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,
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 (
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,
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
68 -- Added for bug 8670632
69 PROCEDURE interface_nl_to_pa(
70 p_trf_pa_attr_rec IN cse_datastructures_pub.Proj_Itm_Insv_PA_ATTR_REC_TYPE,
71 p_conc_request_id IN NUMBER ,
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_error_message OUT NOCOPY VARCHAR2);
74
75 PROCEDURE process_transaction (
76 p_instance_tbl IN txn_instances_tbl,
77 p_dest_location_tbl IN dest_location_tbl,
78 p_ext_attrib_values_tbl IN OUT NOCOPY txn_ext_attrib_values_tbl,
79 p_txn_tbl IN OUT NOCOPY transaction_tbl,
80 x_return_status OUT NOCOPY varchar2,
81 x_error_msg OUT NOCOPY varchar2);
82
83 END cse_deployment_grp;