DBA Data[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;