DBA Data[Home] [Help]

APPS.AHL_MM_MTL_MGT_PVT_W dependencies on AHL_MM_MTL_MGT_PVT

Line 1: package ahl_mm_mtl_mgt_pvt_w AUTHID CURRENT_USER as

1: package ahl_mm_mtl_mgt_pvt_w AUTHID CURRENT_USER as
2: /* $Header: AHLWMMGS.pls 120.0.12020000.2 2012/12/13 06:00:02 shnatu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100, a0 JTF_VARCHAR2_TABLE_100);
4: procedure rosetta_table_copy_out_p2(t ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100, a0 out nocopy JTF_VARCHAR2_TABLE_100);
5:

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100, a0 JTF_VARCHAR2_TABLE_100);

1: package ahl_mm_mtl_mgt_pvt_w AUTHID CURRENT_USER as
2: /* $Header: AHLWMMGS.pls 120.0.12020000.2 2012/12/13 06:00:02 shnatu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100, a0 JTF_VARCHAR2_TABLE_100);
4: procedure rosetta_table_copy_out_p2(t ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100, a0 out nocopy JTF_VARCHAR2_TABLE_100);
5:
6: procedure rosetta_table_copy_in_p3(t out nocopy ahl_mm_mtl_mgt_pvt.oaf_number_table, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p3(t ahl_mm_mtl_mgt_pvt.oaf_number_table, a0 out nocopy JTF_NUMBER_TABLE);

Line 4: procedure rosetta_table_copy_out_p2(t ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100, a0 out nocopy JTF_VARCHAR2_TABLE_100);

1: package ahl_mm_mtl_mgt_pvt_w AUTHID CURRENT_USER as
2: /* $Header: AHLWMMGS.pls 120.0.12020000.2 2012/12/13 06:00:02 shnatu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100, a0 JTF_VARCHAR2_TABLE_100);
4: procedure rosetta_table_copy_out_p2(t ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100, a0 out nocopy JTF_VARCHAR2_TABLE_100);
5:
6: procedure rosetta_table_copy_in_p3(t out nocopy ahl_mm_mtl_mgt_pvt.oaf_number_table, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p3(t ahl_mm_mtl_mgt_pvt.oaf_number_table, a0 out nocopy JTF_NUMBER_TABLE);
8:

Line 6: procedure rosetta_table_copy_in_p3(t out nocopy ahl_mm_mtl_mgt_pvt.oaf_number_table, a0 JTF_NUMBER_TABLE);

2: /* $Header: AHLWMMGS.pls 120.0.12020000.2 2012/12/13 06:00:02 shnatu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100, a0 JTF_VARCHAR2_TABLE_100);
4: procedure rosetta_table_copy_out_p2(t ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100, a0 out nocopy JTF_VARCHAR2_TABLE_100);
5:
6: procedure rosetta_table_copy_in_p3(t out nocopy ahl_mm_mtl_mgt_pvt.oaf_number_table, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p3(t ahl_mm_mtl_mgt_pvt.oaf_number_table, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p10(t out nocopy ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type, a0 JTF_NUMBER_TABLE
10: , a1 JTF_VARCHAR2_TABLE_100

Line 7: procedure rosetta_table_copy_out_p3(t ahl_mm_mtl_mgt_pvt.oaf_number_table, a0 out nocopy JTF_NUMBER_TABLE);

3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100, a0 JTF_VARCHAR2_TABLE_100);
4: procedure rosetta_table_copy_out_p2(t ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100, a0 out nocopy JTF_VARCHAR2_TABLE_100);
5:
6: procedure rosetta_table_copy_in_p3(t out nocopy ahl_mm_mtl_mgt_pvt.oaf_number_table, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p3(t ahl_mm_mtl_mgt_pvt.oaf_number_table, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p10(t out nocopy ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type, a0 JTF_NUMBER_TABLE
10: , a1 JTF_VARCHAR2_TABLE_100
11: , a2 JTF_NUMBER_TABLE

Line 9: procedure rosetta_table_copy_in_p10(t out nocopy ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type, a0 JTF_NUMBER_TABLE

5:
6: procedure rosetta_table_copy_in_p3(t out nocopy ahl_mm_mtl_mgt_pvt.oaf_number_table, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p3(t ahl_mm_mtl_mgt_pvt.oaf_number_table, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p10(t out nocopy ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type, a0 JTF_NUMBER_TABLE
10: , a1 JTF_VARCHAR2_TABLE_100
11: , a2 JTF_NUMBER_TABLE
12: , a3 JTF_VARCHAR2_TABLE_100
13: , a4 JTF_NUMBER_TABLE

Line 23: procedure rosetta_table_copy_out_p10(t ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

19: , a10 JTF_VARCHAR2_TABLE_100
20: , a11 JTF_VARCHAR2_TABLE_100
21: , a12 JTF_VARCHAR2_TABLE_100
22: );
23: procedure rosetta_table_copy_out_p10(t ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
24: , a1 out nocopy JTF_VARCHAR2_TABLE_100
25: , a2 out nocopy JTF_NUMBER_TABLE
26: , a3 out nocopy JTF_VARCHAR2_TABLE_100
27: , a4 out nocopy JTF_NUMBER_TABLE

Line 38: procedure rosetta_table_copy_in_p11(t out nocopy ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl, a0 JTF_NUMBER_TABLE

34: , a11 out nocopy JTF_VARCHAR2_TABLE_100
35: , a12 out nocopy JTF_VARCHAR2_TABLE_100
36: );
37:
38: procedure rosetta_table_copy_in_p11(t out nocopy ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl, a0 JTF_NUMBER_TABLE
39: , a1 JTF_NUMBER_TABLE
40: , a2 JTF_DATE_TABLE
41: , a3 JTF_NUMBER_TABLE
42: , a4 JTF_VARCHAR2_TABLE_2000

Line 44: procedure rosetta_table_copy_out_p11(t ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl, a0 out nocopy JTF_NUMBER_TABLE

40: , a2 JTF_DATE_TABLE
41: , a3 JTF_NUMBER_TABLE
42: , a4 JTF_VARCHAR2_TABLE_2000
43: );
44: procedure rosetta_table_copy_out_p11(t ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_DATE_TABLE
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 51: procedure rosetta_table_copy_in_p12(t out nocopy ahl_mm_mtl_mgt_pvt.number_table_type, a0 JTF_NUMBER_TABLE);

47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
49: );
50:
51: procedure rosetta_table_copy_in_p12(t out nocopy ahl_mm_mtl_mgt_pvt.number_table_type, a0 JTF_NUMBER_TABLE);
52: procedure rosetta_table_copy_out_p12(t ahl_mm_mtl_mgt_pvt.number_table_type, a0 out nocopy JTF_NUMBER_TABLE);
53:
54: procedure rosetta_table_copy_in_p13(t out nocopy ahl_mm_mtl_mgt_pvt.supply_tbl_type, a0 JTF_NUMBER_TABLE
55: , a1 JTF_VARCHAR2_TABLE_100

Line 52: procedure rosetta_table_copy_out_p12(t ahl_mm_mtl_mgt_pvt.number_table_type, a0 out nocopy JTF_NUMBER_TABLE);

48: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
49: );
50:
51: procedure rosetta_table_copy_in_p12(t out nocopy ahl_mm_mtl_mgt_pvt.number_table_type, a0 JTF_NUMBER_TABLE);
52: procedure rosetta_table_copy_out_p12(t ahl_mm_mtl_mgt_pvt.number_table_type, a0 out nocopy JTF_NUMBER_TABLE);
53:
54: procedure rosetta_table_copy_in_p13(t out nocopy ahl_mm_mtl_mgt_pvt.supply_tbl_type, a0 JTF_NUMBER_TABLE
55: , a1 JTF_VARCHAR2_TABLE_100
56: , a2 JTF_NUMBER_TABLE

Line 54: procedure rosetta_table_copy_in_p13(t out nocopy ahl_mm_mtl_mgt_pvt.supply_tbl_type, a0 JTF_NUMBER_TABLE

50:
51: procedure rosetta_table_copy_in_p12(t out nocopy ahl_mm_mtl_mgt_pvt.number_table_type, a0 JTF_NUMBER_TABLE);
52: procedure rosetta_table_copy_out_p12(t ahl_mm_mtl_mgt_pvt.number_table_type, a0 out nocopy JTF_NUMBER_TABLE);
53:
54: procedure rosetta_table_copy_in_p13(t out nocopy ahl_mm_mtl_mgt_pvt.supply_tbl_type, a0 JTF_NUMBER_TABLE
55: , a1 JTF_VARCHAR2_TABLE_100
56: , a2 JTF_NUMBER_TABLE
57: , a3 JTF_VARCHAR2_TABLE_100
58: );

Line 59: procedure rosetta_table_copy_out_p13(t ahl_mm_mtl_mgt_pvt.supply_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

55: , a1 JTF_VARCHAR2_TABLE_100
56: , a2 JTF_NUMBER_TABLE
57: , a3 JTF_VARCHAR2_TABLE_100
58: );
59: procedure rosetta_table_copy_out_p13(t ahl_mm_mtl_mgt_pvt.supply_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
60: , a1 out nocopy JTF_VARCHAR2_TABLE_100
61: , a2 out nocopy JTF_NUMBER_TABLE
62: , a3 out nocopy JTF_VARCHAR2_TABLE_100
63: );

Line 65: procedure rosetta_table_copy_in_p14(t out nocopy ahl_mm_mtl_mgt_pvt.aog_tbl_type, a0 JTF_NUMBER_TABLE

61: , a2 out nocopy JTF_NUMBER_TABLE
62: , a3 out nocopy JTF_VARCHAR2_TABLE_100
63: );
64:
65: procedure rosetta_table_copy_in_p14(t out nocopy ahl_mm_mtl_mgt_pvt.aog_tbl_type, a0 JTF_NUMBER_TABLE
66: , a1 JTF_VARCHAR2_TABLE_100
67: , a2 JTF_NUMBER_TABLE
68: );
69: procedure rosetta_table_copy_out_p14(t ahl_mm_mtl_mgt_pvt.aog_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 69: procedure rosetta_table_copy_out_p14(t ahl_mm_mtl_mgt_pvt.aog_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

65: procedure rosetta_table_copy_in_p14(t out nocopy ahl_mm_mtl_mgt_pvt.aog_tbl_type, a0 JTF_NUMBER_TABLE
66: , a1 JTF_VARCHAR2_TABLE_100
67: , a2 JTF_NUMBER_TABLE
68: );
69: procedure rosetta_table_copy_out_p14(t ahl_mm_mtl_mgt_pvt.aog_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
70: , a1 out nocopy JTF_VARCHAR2_TABLE_100
71: , a2 out nocopy JTF_NUMBER_TABLE
72: );
73:

Line 74: procedure rosetta_table_copy_in_p15(t out nocopy ahl_mm_mtl_mgt_pvt.inv_mtl_avl_tbl, a0 JTF_NUMBER_TABLE

70: , a1 out nocopy JTF_VARCHAR2_TABLE_100
71: , a2 out nocopy JTF_NUMBER_TABLE
72: );
73:
74: procedure rosetta_table_copy_in_p15(t out nocopy ahl_mm_mtl_mgt_pvt.inv_mtl_avl_tbl, a0 JTF_NUMBER_TABLE
75: , a1 JTF_NUMBER_TABLE
76: , a2 JTF_VARCHAR2_TABLE_2000
77: );
78: procedure rosetta_table_copy_out_p15(t ahl_mm_mtl_mgt_pvt.inv_mtl_avl_tbl, a0 out nocopy JTF_NUMBER_TABLE

Line 78: procedure rosetta_table_copy_out_p15(t ahl_mm_mtl_mgt_pvt.inv_mtl_avl_tbl, a0 out nocopy JTF_NUMBER_TABLE

74: procedure rosetta_table_copy_in_p15(t out nocopy ahl_mm_mtl_mgt_pvt.inv_mtl_avl_tbl, a0 JTF_NUMBER_TABLE
75: , a1 JTF_NUMBER_TABLE
76: , a2 JTF_VARCHAR2_TABLE_2000
77: );
78: procedure rosetta_table_copy_out_p15(t ahl_mm_mtl_mgt_pvt.inv_mtl_avl_tbl, a0 out nocopy JTF_NUMBER_TABLE
79: , a1 out nocopy JTF_NUMBER_TABLE
80: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
81: );
82:

Line 83: procedure rosetta_table_copy_in_p34(t out nocopy ahl_mm_mtl_mgt_pvt.visit_ids_tbl, a0 JTF_NUMBER_TABLE);

79: , a1 out nocopy JTF_NUMBER_TABLE
80: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
81: );
82:
83: procedure rosetta_table_copy_in_p34(t out nocopy ahl_mm_mtl_mgt_pvt.visit_ids_tbl, a0 JTF_NUMBER_TABLE);
84: procedure rosetta_table_copy_out_p34(t ahl_mm_mtl_mgt_pvt.visit_ids_tbl, a0 out nocopy JTF_NUMBER_TABLE);
85:
86: procedure check_availability(p_api_version NUMBER
87: , p_init_msg_list VARCHAR2

Line 84: procedure rosetta_table_copy_out_p34(t ahl_mm_mtl_mgt_pvt.visit_ids_tbl, a0 out nocopy JTF_NUMBER_TABLE);

80: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
81: );
82:
83: procedure rosetta_table_copy_in_p34(t out nocopy ahl_mm_mtl_mgt_pvt.visit_ids_tbl, a0 JTF_NUMBER_TABLE);
84: procedure rosetta_table_copy_out_p34(t ahl_mm_mtl_mgt_pvt.visit_ids_tbl, a0 out nocopy JTF_NUMBER_TABLE);
85:
86: procedure check_availability(p_api_version NUMBER
87: , p_init_msg_list VARCHAR2
88: , p_commit VARCHAR2

Line 293: end ahl_mm_mtl_mgt_pvt_w;

289: , x_return_status out nocopy VARCHAR2
290: , x_msg_count out nocopy NUMBER
291: , x_msg_data out nocopy VARCHAR2
292: );
293: end ahl_mm_mtl_mgt_pvt_w;