[Home] [Help]
PACKAGE: APPS.EAM_COPY_BOM_PKG_W
Source
1 package eam_copy_bom_pkg_w as
2 /* $Header: EAMCPMRS.pls 120.2 2008/01/26 01:53:33 devijay ship $ */
3 procedure rosetta_table_copy_in_p2(t out nocopy eam_copy_bom_pkg.t_bom_table, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_300
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_VARCHAR2_TABLE_100
7 , a4 JTF_NUMBER_TABLE
8 );
9 procedure rosetta_table_copy_out_p2(t eam_copy_bom_pkg.t_bom_table, a0 out nocopy JTF_NUMBER_TABLE
10 , a1 out nocopy JTF_VARCHAR2_TABLE_300
11 , a2 out nocopy JTF_NUMBER_TABLE
12 , a3 out nocopy JTF_VARCHAR2_TABLE_100
13 , a4 out nocopy JTF_NUMBER_TABLE
14 );
15
16 procedure rosetta_table_copy_in_p3(t out nocopy eam_copy_bom_pkg.t_component_table, a0 JTF_VARCHAR2_TABLE_100
17 , a1 JTF_NUMBER_TABLE
18 , a2 JTF_NUMBER_TABLE
19 , a3 JTF_NUMBER_TABLE
20 , a4 JTF_NUMBER_TABLE
21 , a5 JTF_VARCHAR2_TABLE_100
22 , a6 JTF_NUMBER_TABLE
23 , a7 JTF_VARCHAR2_TABLE_100
24 );
25 procedure rosetta_table_copy_out_p3(t eam_copy_bom_pkg.t_component_table, a0 out nocopy JTF_VARCHAR2_TABLE_100
26 , a1 out nocopy JTF_NUMBER_TABLE
27 , a2 out nocopy JTF_NUMBER_TABLE
28 , a3 out nocopy JTF_NUMBER_TABLE
29 , a4 out nocopy JTF_NUMBER_TABLE
30 , a5 out nocopy JTF_VARCHAR2_TABLE_100
31 , a6 out nocopy JTF_NUMBER_TABLE
32 , a7 out nocopy JTF_VARCHAR2_TABLE_100
33 );
34
35 procedure copy_to_bom(p_organization_id NUMBER
36 , p_organization_code VARCHAR2
37 , p_asset_number VARCHAR2
38 , p_asset_group_id NUMBER
39 , p4_a0 JTF_VARCHAR2_TABLE_100
40 , p4_a1 JTF_NUMBER_TABLE
41 , p4_a2 JTF_NUMBER_TABLE
42 , p4_a3 JTF_NUMBER_TABLE
43 , p4_a4 JTF_NUMBER_TABLE
44 , p4_a5 JTF_VARCHAR2_TABLE_100
45 , p4_a6 JTF_NUMBER_TABLE
46 , p4_a7 JTF_VARCHAR2_TABLE_100
47 , x_error_code out nocopy NUMBER
48 );
49 procedure retrieve_asset_bom(p_organization_id NUMBER
50 , p_wip_entity_id NUMBER
51 , p_operation_seq_num NUMBER
52 , p_department_id NUMBER
53 , p4_a0 JTF_NUMBER_TABLE
54 , p4_a1 JTF_VARCHAR2_TABLE_300
55 , p4_a2 JTF_NUMBER_TABLE
56 , p4_a3 JTF_VARCHAR2_TABLE_100
57 , p4_a4 JTF_NUMBER_TABLE
58 , x_error_code out nocopy VARCHAR2
59 );
60 end eam_copy_bom_pkg_w;