DBA Data[Home] [Help]

APPS.CN_SFP_GROUP_UTIL_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package cn_sfp_group_util_pvt_w AUTHID CURRENT_USER as
2: /* $Header: cnwsfgrs.pls 115.0 2003/08/19 20:47:36 sbadami noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_sfp_group_util_pvt.srprole_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: );
7: procedure rosetta_table_copy_out_p1(t cn_sfp_group_util_pvt.srprole_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
8: , a1 out nocopy JTF_NUMBER_TABLE
9: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 9: , a2 out nocopy JTF_VARCHAR2_TABLE_100

5: , a2 JTF_VARCHAR2_TABLE_100
6: );
7: procedure rosetta_table_copy_out_p1(t cn_sfp_group_util_pvt.srprole_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
8: , a1 out nocopy JTF_NUMBER_TABLE
9: , a2 out nocopy JTF_VARCHAR2_TABLE_100
10: );
11:
12: procedure rosetta_table_copy_in_p3(t out nocopy cn_sfp_group_util_pvt.grporg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
13: , a1 JTF_VARCHAR2_TABLE_100

Line 12: procedure rosetta_table_copy_in_p3(t out nocopy cn_sfp_group_util_pvt.grporg_tbl_type, a0 JTF_VARCHAR2_TABLE_100

8: , a1 out nocopy JTF_NUMBER_TABLE
9: , a2 out nocopy JTF_VARCHAR2_TABLE_100
10: );
11:
12: procedure rosetta_table_copy_in_p3(t out nocopy cn_sfp_group_util_pvt.grporg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
13: , a1 JTF_VARCHAR2_TABLE_100
14: );
15: procedure rosetta_table_copy_out_p3(t cn_sfp_group_util_pvt.grporg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
16: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 13: , a1 JTF_VARCHAR2_TABLE_100

9: , a2 out nocopy JTF_VARCHAR2_TABLE_100
10: );
11:
12: procedure rosetta_table_copy_in_p3(t out nocopy cn_sfp_group_util_pvt.grporg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
13: , a1 JTF_VARCHAR2_TABLE_100
14: );
15: procedure rosetta_table_copy_out_p3(t cn_sfp_group_util_pvt.grporg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
16: , a1 out nocopy JTF_VARCHAR2_TABLE_100
17: );

Line 15: procedure rosetta_table_copy_out_p3(t cn_sfp_group_util_pvt.grporg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

11:
12: procedure rosetta_table_copy_in_p3(t out nocopy cn_sfp_group_util_pvt.grporg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
13: , a1 JTF_VARCHAR2_TABLE_100
14: );
15: procedure rosetta_table_copy_out_p3(t cn_sfp_group_util_pvt.grporg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
16: , a1 out nocopy JTF_VARCHAR2_TABLE_100
17: );
18:
19: procedure rosetta_table_copy_in_p4(t out nocopy cn_sfp_group_util_pvt.grpnum_tbl_type, a0 JTF_NUMBER_TABLE);

Line 16: , a1 out nocopy JTF_VARCHAR2_TABLE_100

12: procedure rosetta_table_copy_in_p3(t out nocopy cn_sfp_group_util_pvt.grporg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
13: , a1 JTF_VARCHAR2_TABLE_100
14: );
15: procedure rosetta_table_copy_out_p3(t cn_sfp_group_util_pvt.grporg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
16: , a1 out nocopy JTF_VARCHAR2_TABLE_100
17: );
18:
19: procedure rosetta_table_copy_in_p4(t out nocopy cn_sfp_group_util_pvt.grpnum_tbl_type, a0 JTF_NUMBER_TABLE);
20: procedure rosetta_table_copy_out_p4(t cn_sfp_group_util_pvt.grpnum_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);

Line 42: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100

38: , p_status VARCHAR2
39: , p_effective_date date
40: , p7_a0 out nocopy JTF_NUMBER_TABLE
41: , p7_a1 out nocopy JTF_NUMBER_TABLE
42: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
43: , x_return_status out nocopy VARCHAR2
44: , x_msg_count out nocopy NUMBER
45: , x_msg_data out nocopy VARCHAR2
46: );

Line 53: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100

49: , p_commit VARCHAR2
50: , p_validation_level NUMBER
51: , p_comp_group_id NUMBER
52: , p_effective_date date
53: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
54: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
55: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
56: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
57: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100

Line 54: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

50: , p_validation_level NUMBER
51: , p_comp_group_id NUMBER
52: , p_effective_date date
53: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
54: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
55: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
56: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
57: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
58: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 55: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100

51: , p_comp_group_id NUMBER
52: , p_effective_date date
53: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
54: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
55: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
56: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
57: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
58: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
59: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100

Line 56: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100

52: , p_effective_date date
53: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
54: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
55: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
56: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
57: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
58: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
59: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
60: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 57: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100

53: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
54: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
55: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
56: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
57: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
58: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
59: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
60: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
61: , x_return_status out nocopy VARCHAR2

Line 58: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100

54: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
55: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
56: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
57: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
58: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
59: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
60: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
61: , x_return_status out nocopy VARCHAR2
62: , x_msg_count out nocopy NUMBER

Line 59: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100

55: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
56: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
57: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
58: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
59: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
60: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
61: , x_return_status out nocopy VARCHAR2
62: , x_msg_count out nocopy NUMBER
63: , x_msg_data out nocopy VARCHAR2

Line 60: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100

56: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
57: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
58: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
59: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
60: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
61: , x_return_status out nocopy VARCHAR2
62: , x_msg_count out nocopy NUMBER
63: , x_msg_data out nocopy VARCHAR2
64: );