APPS.IEM_SPV_MONITORING_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 14: , a11 JTF_VARCHAR2_TABLE_100

10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: );
17: procedure rosetta_table_copy_out_p1(t iem_spv_monitoring_pvt.email_activity_tbl, a0 out nocopy JTF_NUMBER_TABLE
18: , a1 out nocopy JTF_NUMBER_TABLE

Line 15: , a12 JTF_VARCHAR2_TABLE_100

11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: );
17: procedure rosetta_table_copy_out_p1(t iem_spv_monitoring_pvt.email_activity_tbl, a0 out nocopy JTF_NUMBER_TABLE
18: , a1 out nocopy JTF_NUMBER_TABLE
19: , a2 out nocopy JTF_VARCHAR2_TABLE_300

Line 28: , a11 out nocopy JTF_VARCHAR2_TABLE_100

24: , a7 out nocopy JTF_NUMBER_TABLE
25: , a8 out nocopy JTF_NUMBER_TABLE
26: , a9 out nocopy JTF_NUMBER_TABLE
27: , a10 out nocopy JTF_NUMBER_TABLE
28: , a11 out nocopy JTF_VARCHAR2_TABLE_100
29: , a12 out nocopy JTF_VARCHAR2_TABLE_100
30: );
31:
32: procedure rosetta_table_copy_in_p3(t out nocopy iem_spv_monitoring_pvt.agent_activity_tbl, a0 JTF_NUMBER_TABLE

Line 29: , a12 out nocopy JTF_VARCHAR2_TABLE_100

25: , a8 out nocopy JTF_NUMBER_TABLE
26: , a9 out nocopy JTF_NUMBER_TABLE
27: , a10 out nocopy JTF_NUMBER_TABLE
28: , a11 out nocopy JTF_VARCHAR2_TABLE_100
29: , a12 out nocopy JTF_VARCHAR2_TABLE_100
30: );
31:
32: procedure rosetta_table_copy_in_p3(t out nocopy iem_spv_monitoring_pvt.agent_activity_tbl, a0 JTF_NUMBER_TABLE
33: , a1 JTF_NUMBER_TABLE

Line 41: , a9 JTF_VARCHAR2_TABLE_100

37: , a5 JTF_NUMBER_TABLE
38: , a6 JTF_NUMBER_TABLE
39: , a7 JTF_VARCHAR2_TABLE_500
40: , a8 JTF_NUMBER_TABLE
41: , a9 JTF_VARCHAR2_TABLE_100
42: , a10 JTF_VARCHAR2_TABLE_100
43: );
44: procedure rosetta_table_copy_out_p3(t iem_spv_monitoring_pvt.agent_activity_tbl, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE

Line 42: , a10 JTF_VARCHAR2_TABLE_100

38: , a6 JTF_NUMBER_TABLE
39: , a7 JTF_VARCHAR2_TABLE_500
40: , a8 JTF_NUMBER_TABLE
41: , a9 JTF_VARCHAR2_TABLE_100
42: , a10 JTF_VARCHAR2_TABLE_100
43: );
44: procedure rosetta_table_copy_out_p3(t iem_spv_monitoring_pvt.agent_activity_tbl, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_VARCHAR2_TABLE_800

Line 53: , a9 out nocopy JTF_VARCHAR2_TABLE_100

49: , a5 out nocopy JTF_NUMBER_TABLE
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_VARCHAR2_TABLE_500
52: , a8 out nocopy JTF_NUMBER_TABLE
53: , a9 out nocopy JTF_VARCHAR2_TABLE_100
54: , a10 out nocopy JTF_VARCHAR2_TABLE_100
55: );
56:
57: procedure get_email_activity(p_api_version_number NUMBER

Line 54: , a10 out nocopy JTF_VARCHAR2_TABLE_100

50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_VARCHAR2_TABLE_500
52: , a8 out nocopy JTF_NUMBER_TABLE
53: , a9 out nocopy JTF_VARCHAR2_TABLE_100
54: , a10 out nocopy JTF_VARCHAR2_TABLE_100
55: );
56:
57: procedure get_email_activity(p_api_version_number NUMBER
58: , p_init_msg_list VARCHAR2

Line 71: , p3_a11 out nocopy JTF_VARCHAR2_TABLE_100

67: , p3_a7 out nocopy JTF_NUMBER_TABLE
68: , p3_a8 out nocopy JTF_NUMBER_TABLE
69: , p3_a9 out nocopy JTF_NUMBER_TABLE
70: , p3_a10 out nocopy JTF_NUMBER_TABLE
71: , p3_a11 out nocopy JTF_VARCHAR2_TABLE_100
72: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
73: , x_return_status out nocopy VARCHAR2
74: , x_msg_count out nocopy NUMBER
75: , x_msg_data out nocopy VARCHAR2

Line 72: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100

68: , p3_a8 out nocopy JTF_NUMBER_TABLE
69: , p3_a9 out nocopy JTF_NUMBER_TABLE
70: , p3_a10 out nocopy JTF_NUMBER_TABLE
71: , p3_a11 out nocopy JTF_VARCHAR2_TABLE_100
72: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
73: , x_return_status out nocopy VARCHAR2
74: , x_msg_count out nocopy NUMBER
75: , x_msg_data out nocopy VARCHAR2
76: );

Line 91: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_100

87: , p5_a5 out nocopy JTF_NUMBER_TABLE
88: , p5_a6 out nocopy JTF_NUMBER_TABLE
89: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_500
90: , p5_a8 out nocopy JTF_NUMBER_TABLE
91: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_100
92: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
93: , x_return_status out nocopy VARCHAR2
94: , x_msg_count out nocopy NUMBER
95: , x_msg_data out nocopy VARCHAR2

Line 92: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100

88: , p5_a6 out nocopy JTF_NUMBER_TABLE
89: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_500
90: , p5_a8 out nocopy JTF_NUMBER_TABLE
91: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_100
92: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
93: , x_return_status out nocopy VARCHAR2
94: , x_msg_count out nocopy NUMBER
95: , x_msg_data out nocopy VARCHAR2
96: );