1: package ams_met_tpl_dtl_pvt_w as
2: /* $Header: amswmtds.pls 120.0 2005/06/01 01:45:16 appldev noship $ */
3: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_met_tpl_dtl_pvt.met_tpl_dtl_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
1: package ams_met_tpl_dtl_pvt_w as
2: /* $Header: amswmtds.pls 120.0 2005/06/01 01:45:16 appldev noship $ */
3: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_met_tpl_dtl_pvt.met_tpl_dtl_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
3: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_met_tpl_dtl_pvt.met_tpl_dtl_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: );
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: );
14: procedure rosetta_table_copy_out_p3(t ams_met_tpl_dtl_pvt.met_tpl_dtl_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: );
14: procedure rosetta_table_copy_out_p3(t ams_met_tpl_dtl_pvt.met_tpl_dtl_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
15: , a1 OUT NOCOPY JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: );
14: procedure rosetta_table_copy_out_p3(t ams_met_tpl_dtl_pvt.met_tpl_dtl_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
15: , a1 OUT NOCOPY JTF_DATE_TABLE
16: , a2 OUT NOCOPY JTF_NUMBER_TABLE
17: , a3 OUT NOCOPY JTF_DATE_TABLE
18: , a4 OUT NOCOPY JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: );
14: procedure rosetta_table_copy_out_p3(t ams_met_tpl_dtl_pvt.met_tpl_dtl_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
15: , a1 OUT NOCOPY JTF_DATE_TABLE
16: , a2 OUT NOCOPY JTF_NUMBER_TABLE
17: , a3 OUT NOCOPY JTF_DATE_TABLE
18: , a4 OUT NOCOPY JTF_NUMBER_TABLE
19: , a5 OUT NOCOPY JTF_NUMBER_TABLE
20: , a6 OUT NOCOPY JTF_NUMBER_TABLE
14: procedure rosetta_table_copy_out_p3(t ams_met_tpl_dtl_pvt.met_tpl_dtl_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
15: , a1 OUT NOCOPY JTF_DATE_TABLE
16: , a2 OUT NOCOPY JTF_NUMBER_TABLE
17: , a3 OUT NOCOPY JTF_DATE_TABLE
18: , a4 OUT NOCOPY JTF_NUMBER_TABLE
19: , a5 OUT NOCOPY JTF_NUMBER_TABLE
20: , a6 OUT NOCOPY JTF_NUMBER_TABLE
21: , a7 OUT NOCOPY JTF_NUMBER_TABLE
22: , a8 OUT NOCOPY JTF_NUMBER_TABLE
15: , a1 OUT NOCOPY JTF_DATE_TABLE
16: , a2 OUT NOCOPY JTF_NUMBER_TABLE
17: , a3 OUT NOCOPY JTF_DATE_TABLE
18: , a4 OUT NOCOPY JTF_NUMBER_TABLE
19: , a5 OUT NOCOPY JTF_NUMBER_TABLE
20: , a6 OUT NOCOPY JTF_NUMBER_TABLE
21: , a7 OUT NOCOPY JTF_NUMBER_TABLE
22: , a8 OUT NOCOPY JTF_NUMBER_TABLE
23: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
16: , a2 OUT NOCOPY JTF_NUMBER_TABLE
17: , a3 OUT NOCOPY JTF_DATE_TABLE
18: , a4 OUT NOCOPY JTF_NUMBER_TABLE
19: , a5 OUT NOCOPY JTF_NUMBER_TABLE
20: , a6 OUT NOCOPY JTF_NUMBER_TABLE
21: , a7 OUT NOCOPY JTF_NUMBER_TABLE
22: , a8 OUT NOCOPY JTF_NUMBER_TABLE
23: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
24: );
17: , a3 OUT NOCOPY JTF_DATE_TABLE
18: , a4 OUT NOCOPY JTF_NUMBER_TABLE
19: , a5 OUT NOCOPY JTF_NUMBER_TABLE
20: , a6 OUT NOCOPY JTF_NUMBER_TABLE
21: , a7 OUT NOCOPY JTF_NUMBER_TABLE
22: , a8 OUT NOCOPY JTF_NUMBER_TABLE
23: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
24: );
25:
18: , a4 OUT NOCOPY JTF_NUMBER_TABLE
19: , a5 OUT NOCOPY JTF_NUMBER_TABLE
20: , a6 OUT NOCOPY JTF_NUMBER_TABLE
21: , a7 OUT NOCOPY JTF_NUMBER_TABLE
22: , a8 OUT NOCOPY JTF_NUMBER_TABLE
23: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
24: );
25:
26: procedure create_met_tpl_dtl(p_api_version_number NUMBER