DBA Data[Home] [Help]

APPS.EAM_COPY_BOM_PKG_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy eam_copy_bom_pkg.t_bom_table, a0 JTF_NUMBER_TABLE

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

Line 5: , a2 JTF_NUMBER_TABLE

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

Line 7: , a4 JTF_NUMBER_TABLE

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

Line 9: procedure rosetta_table_copy_out_p2(t eam_copy_bom_pkg.t_bom_table, a0 out nocopy JTF_NUMBER_TABLE

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

Line 11: , a2 out nocopy JTF_NUMBER_TABLE

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:

Line 13: , a4 out nocopy JTF_NUMBER_TABLE

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

Line 17: , a1 JTF_NUMBER_TABLE

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

Line 18: , a2 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

Line 19: , a3 JTF_NUMBER_TABLE

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

Line 20: , a4 JTF_NUMBER_TABLE

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

Line 22: , a6 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

Line 26: , a1 out nocopy JTF_NUMBER_TABLE

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

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

Line 28: , a3 out nocopy JTF_NUMBER_TABLE

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

Line 29: , a4 out nocopy JTF_NUMBER_TABLE

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

Line 31: , a6 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

Line 40: , p4_a1 JTF_NUMBER_TABLE

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

Line 41: , p4_a2 JTF_NUMBER_TABLE

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

Line 42: , p4_a3 JTF_NUMBER_TABLE

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

Line 43: , p4_a4 JTF_NUMBER_TABLE

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

Line 45: , p4_a6 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

Line 53: , p4_a0 JTF_NUMBER_TABLE

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

Line 55: , p4_a2 JTF_NUMBER_TABLE

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

Line 57: , p4_a4 JTF_NUMBER_TABLE

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;