eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.EAM_WORKORDER_UTIL_PKG_W

Source


1 package eam_workorder_util_pkg_w AUTHID CURRENT_USER as
2   /* $Header: EAMVWUPS.pls 120.0.12020000.2 2012/11/07 12:58:49 rsandepo ship $ */
3   procedure rosetta_table_copy_in_p4(t out nocopy eam_workorder_util_pkg.t_bom_table, a0 JTF_NUMBER_TABLE
4     , a1 JTF_NUMBER_TABLE
5     , a2 JTF_VARCHAR2_TABLE_100
6     , a3 JTF_VARCHAR2_TABLE_300
7     , a4 JTF_NUMBER_TABLE
8     , a5 JTF_NUMBER_TABLE
9     , a6 JTF_VARCHAR2_TABLE_100
10     , a7 JTF_NUMBER_TABLE
11     , a8 JTF_VARCHAR2_TABLE_100
12     , a9 JTF_VARCHAR2_TABLE_100
13     );
14   procedure rosetta_table_copy_out_p4(t eam_workorder_util_pkg.t_bom_table, a0 out nocopy JTF_NUMBER_TABLE
15     , a1 out nocopy JTF_NUMBER_TABLE
16     , a2 out nocopy JTF_VARCHAR2_TABLE_100
17     , a3 out nocopy JTF_VARCHAR2_TABLE_300
18     , a4 out nocopy JTF_NUMBER_TABLE
19     , a5 out nocopy JTF_NUMBER_TABLE
20     , a6 out nocopy JTF_VARCHAR2_TABLE_100
21     , a7 out nocopy JTF_NUMBER_TABLE
22     , a8 out nocopy JTF_VARCHAR2_TABLE_100
23     , a9 out nocopy JTF_VARCHAR2_TABLE_100
24     );
25 
26   procedure rosetta_table_copy_in_p5(t out nocopy eam_workorder_util_pkg.t_component_table, a0 JTF_VARCHAR2_TABLE_100
27     , a1 JTF_NUMBER_TABLE
28     , a2 JTF_DATE_TABLE
29     , a3 JTF_NUMBER_TABLE
30     , a4 JTF_NUMBER_TABLE
31     , a5 JTF_NUMBER_TABLE
32     , a6 JTF_VARCHAR2_TABLE_100
33     , a7 JTF_NUMBER_TABLE
34     , a8 JTF_VARCHAR2_TABLE_100
35     );
36   procedure rosetta_table_copy_out_p5(t eam_workorder_util_pkg.t_component_table, a0 out nocopy JTF_VARCHAR2_TABLE_100
37     , a1 out nocopy JTF_NUMBER_TABLE
38     , a2 out nocopy JTF_DATE_TABLE
39     , a3 out nocopy JTF_NUMBER_TABLE
40     , a4 out nocopy JTF_NUMBER_TABLE
41     , a5 out nocopy JTF_NUMBER_TABLE
42     , a6 out nocopy JTF_VARCHAR2_TABLE_100
43     , a7 out nocopy JTF_NUMBER_TABLE
44     , a8 out nocopy JTF_VARCHAR2_TABLE_100
45     );
46 
47   procedure rosetta_table_copy_in_p6(t out nocopy eam_workorder_util_pkg.t_optime_table, a0 JTF_NUMBER_TABLE
48     , a1 JTF_NUMBER_TABLE
49     );
50   procedure rosetta_table_copy_out_p6(t eam_workorder_util_pkg.t_optime_table, a0 out nocopy JTF_NUMBER_TABLE
51     , a1 out nocopy JTF_NUMBER_TABLE
52     );
53 
54   procedure rosetta_table_copy_in_p7(t out nocopy eam_workorder_util_pkg.t_workflow_table, a0 JTF_NUMBER_TABLE
55     , a1 JTF_VARCHAR2_TABLE_400
56     , a2 JTF_VARCHAR2_TABLE_100
57     , a3 JTF_DATE_TABLE
58     , a4 JTF_VARCHAR2_TABLE_300
59     , a5 JTF_VARCHAR2_TABLE_100
60     , a6 JTF_VARCHAR2_TABLE_4000
61     );
62   procedure rosetta_table_copy_out_p7(t eam_workorder_util_pkg.t_workflow_table, a0 out nocopy JTF_NUMBER_TABLE
63     , a1 out nocopy JTF_VARCHAR2_TABLE_400
64     , a2 out nocopy JTF_VARCHAR2_TABLE_100
65     , a3 out nocopy JTF_DATE_TABLE
66     , a4 out nocopy JTF_VARCHAR2_TABLE_300
67     , a5 out nocopy JTF_VARCHAR2_TABLE_100
68     , a6 out nocopy JTF_VARCHAR2_TABLE_4000
69     );
70 
71   procedure rosetta_table_copy_in_p30(t out nocopy eam_workorder_util_pkg.replace_rebuild_tbl_type, a0 JTF_NUMBER_TABLE
72     );
73   procedure rosetta_table_copy_out_p30(t eam_workorder_util_pkg.replace_rebuild_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
74     );
75 
76   procedure retrieve_asset_bom(i_organization_id  NUMBER
77     , i_asset_number  VARCHAR2
78     , i_asset_group_id  NUMBER
79     , p_context  VARCHAR2
80     , p4_a0 out nocopy JTF_NUMBER_TABLE
81     , p4_a1 out nocopy JTF_NUMBER_TABLE
82     , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
83     , p4_a3 out nocopy JTF_VARCHAR2_TABLE_300
84     , p4_a4 out nocopy JTF_NUMBER_TABLE
85     , p4_a5 out nocopy JTF_NUMBER_TABLE
86     , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
87     , p4_a7 out nocopy JTF_NUMBER_TABLE
88     , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
89     , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
90     , o_error_code out nocopy  NUMBER
91   );
92   procedure copy_to_bom(i_organization_id  NUMBER
93     , i_organization_code  VARCHAR2
94     , i_asset_number  VARCHAR2
95     , i_asset_group_id  NUMBER
96     , p4_a0 JTF_VARCHAR2_TABLE_100
97     , p4_a1 JTF_NUMBER_TABLE
98     , p4_a2 JTF_DATE_TABLE
99     , p4_a3 JTF_NUMBER_TABLE
100     , p4_a4 JTF_NUMBER_TABLE
101     , p4_a5 JTF_NUMBER_TABLE
102     , p4_a6 JTF_VARCHAR2_TABLE_100
103     , p4_a7 JTF_NUMBER_TABLE
104     , p4_a8 JTF_VARCHAR2_TABLE_100
105     , o_error_code out nocopy  NUMBER
106   );
107   procedure adjust_operations(i_wip_entity_id  NUMBER
108     , p1_a0 JTF_NUMBER_TABLE
109     , p1_a1 JTF_NUMBER_TABLE
110   );
111   procedure dependency_violated(i_wip_entity_id  NUMBER
112     , ddrosetta_retval_bool OUT NOCOPY NUMBER
113   );
114   procedure get_workflow_details(p_item_type  VARCHAR2
115     , p_item_key  VARCHAR2
116     , p2_a0 out nocopy JTF_NUMBER_TABLE
117     , p2_a1 out nocopy JTF_VARCHAR2_TABLE_400
118     , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
119     , p2_a3 out nocopy JTF_DATE_TABLE
120     , p2_a4 out nocopy JTF_VARCHAR2_TABLE_300
121     , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
122     , p2_a6 out nocopy JTF_VARCHAR2_TABLE_4000
123   );
124   procedure get_replaced_rebuilds(p_wip_entity_id  NUMBER
125     , p_organization_id  NUMBER
126     , p2_a0 out nocopy JTF_NUMBER_TABLE
127     , x_return_status out nocopy  VARCHAR2
128     , x_error_message out nocopy  VARCHAR2
129   );
130 end eam_workorder_util_pkg_w;