APPS.EAM_WORKORDER_UTIL_PKG_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

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

Line 9: , a6 JTF_VARCHAR2_TABLE_100

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

Line 11: , a8 JTF_VARCHAR2_TABLE_100

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

Line 12: , a9 JTF_VARCHAR2_TABLE_100

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

Line 16: , a2 out nocopy 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

Line 20: , a6 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 22: , a8 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 23: , a9 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 26: procedure rosetta_table_copy_in_p5(t out nocopy eam_workorder_util_pkg.t_component_table, a0 JTF_VARCHAR2_TABLE_100

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

Line 32: , a6 JTF_VARCHAR2_TABLE_100

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

Line 34: , a8 JTF_VARCHAR2_TABLE_100

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

Line 36: procedure rosetta_table_copy_out_p5(t eam_workorder_util_pkg.t_component_table, a0 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 42: , a6 out nocopy JTF_VARCHAR2_TABLE_100

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:

Line 44: , a8 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 56: , a2 JTF_VARCHAR2_TABLE_100

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

Line 59: , a5 JTF_VARCHAR2_TABLE_100

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

Line 64: , a2 out nocopy 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

Line 67: , a5 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 82: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 86: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 88: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 89: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 96: , p4_a0 JTF_VARCHAR2_TABLE_100

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

Line 102: , p4_a6 JTF_VARCHAR2_TABLE_100

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

Line 104: , p4_a8 JTF_VARCHAR2_TABLE_100

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

Line 118: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 121: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100

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