APPS.JTF_UM_APPROVAL_REQUESTS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a1 JTF_VARCHAR2_TABLE_100

1: package jtf_um_approval_requests_pvt_w AUTHID CURRENT_USER as
2: /* $Header: JTFWAPRS.pls 120.4 2009/06/15 11:38:32 kkasibha ship $ */
3:
4: procedure rosetta_table_copy_in_p1(t out nocopy jtf_um_approval_requests_pvt.approval_request_table_type, a0 JTF_DATE_TABLE
5: , a1 JTF_VARCHAR2_TABLE_100
6: , a2 JTF_VARCHAR2_TABLE_400
7: , a3 JTF_VARCHAR2_TABLE_100
8: , a4 JTF_VARCHAR2_TABLE_1000
9: , a5 JTF_VARCHAR2_TABLE_100

Line 7: , a3 JTF_VARCHAR2_TABLE_100

3:
4: procedure rosetta_table_copy_in_p1(t out nocopy jtf_um_approval_requests_pvt.approval_request_table_type, a0 JTF_DATE_TABLE
5: , a1 JTF_VARCHAR2_TABLE_100
6: , a2 JTF_VARCHAR2_TABLE_400
7: , a3 JTF_VARCHAR2_TABLE_100
8: , a4 JTF_VARCHAR2_TABLE_1000
9: , a5 JTF_VARCHAR2_TABLE_100
10: , a6 JTF_NUMBER_TABLE
11: , a7 JTF_VARCHAR2_TABLE_100

Line 8: , a4 JTF_VARCHAR2_TABLE_1000

4: procedure rosetta_table_copy_in_p1(t out nocopy jtf_um_approval_requests_pvt.approval_request_table_type, a0 JTF_DATE_TABLE
5: , a1 JTF_VARCHAR2_TABLE_100
6: , a2 JTF_VARCHAR2_TABLE_400
7: , a3 JTF_VARCHAR2_TABLE_100
8: , a4 JTF_VARCHAR2_TABLE_1000
9: , a5 JTF_VARCHAR2_TABLE_100
10: , a6 JTF_NUMBER_TABLE
11: , a7 JTF_VARCHAR2_TABLE_100
12: , a8 JTF_NUMBER_TABLE

Line 9: , a5 JTF_VARCHAR2_TABLE_100

5: , a1 JTF_VARCHAR2_TABLE_100
6: , a2 JTF_VARCHAR2_TABLE_400
7: , a3 JTF_VARCHAR2_TABLE_100
8: , a4 JTF_VARCHAR2_TABLE_1000
9: , a5 JTF_VARCHAR2_TABLE_100
10: , a6 JTF_NUMBER_TABLE
11: , a7 JTF_VARCHAR2_TABLE_100
12: , a8 JTF_NUMBER_TABLE
13: );

Line 11: , a7 JTF_VARCHAR2_TABLE_100

7: , a3 JTF_VARCHAR2_TABLE_100
8: , a4 JTF_VARCHAR2_TABLE_1000
9: , a5 JTF_VARCHAR2_TABLE_100
10: , a6 JTF_NUMBER_TABLE
11: , a7 JTF_VARCHAR2_TABLE_100
12: , a8 JTF_NUMBER_TABLE
13: );
14:
15: procedure rosetta_table_copy_out_p1(t jtf_um_approval_requests_pvt.approval_request_table_type, a0 out nocopy JTF_DATE_TABLE

Line 16: , a1 out nocopy JTF_VARCHAR2_TABLE_100

12: , a8 JTF_NUMBER_TABLE
13: );
14:
15: procedure rosetta_table_copy_out_p1(t jtf_um_approval_requests_pvt.approval_request_table_type, a0 out nocopy JTF_DATE_TABLE
16: , a1 out nocopy JTF_VARCHAR2_TABLE_100
17: , a2 out nocopy JTF_VARCHAR2_TABLE_400
18: , a3 out nocopy JTF_VARCHAR2_TABLE_100
19: , a4 out nocopy JTF_VARCHAR2_TABLE_1000
20: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 18: , a3 out nocopy JTF_VARCHAR2_TABLE_100

14:
15: procedure rosetta_table_copy_out_p1(t jtf_um_approval_requests_pvt.approval_request_table_type, a0 out nocopy JTF_DATE_TABLE
16: , a1 out nocopy JTF_VARCHAR2_TABLE_100
17: , a2 out nocopy JTF_VARCHAR2_TABLE_400
18: , a3 out nocopy JTF_VARCHAR2_TABLE_100
19: , a4 out nocopy JTF_VARCHAR2_TABLE_1000
20: , a5 out nocopy JTF_VARCHAR2_TABLE_100
21: , a6 out nocopy JTF_NUMBER_TABLE
22: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 19: , a4 out nocopy JTF_VARCHAR2_TABLE_1000

15: procedure rosetta_table_copy_out_p1(t jtf_um_approval_requests_pvt.approval_request_table_type, a0 out nocopy JTF_DATE_TABLE
16: , a1 out nocopy JTF_VARCHAR2_TABLE_100
17: , a2 out nocopy JTF_VARCHAR2_TABLE_400
18: , a3 out nocopy JTF_VARCHAR2_TABLE_100
19: , a4 out nocopy JTF_VARCHAR2_TABLE_1000
20: , a5 out nocopy JTF_VARCHAR2_TABLE_100
21: , a6 out nocopy JTF_NUMBER_TABLE
22: , a7 out nocopy JTF_VARCHAR2_TABLE_100
23: , a8 out nocopy JTF_NUMBER_TABLE

Line 20: , a5 out nocopy JTF_VARCHAR2_TABLE_100

16: , a1 out nocopy JTF_VARCHAR2_TABLE_100
17: , a2 out nocopy JTF_VARCHAR2_TABLE_400
18: , a3 out nocopy JTF_VARCHAR2_TABLE_100
19: , a4 out nocopy JTF_VARCHAR2_TABLE_1000
20: , a5 out nocopy JTF_VARCHAR2_TABLE_100
21: , a6 out nocopy JTF_NUMBER_TABLE
22: , a7 out nocopy JTF_VARCHAR2_TABLE_100
23: , a8 out nocopy JTF_NUMBER_TABLE
24: );

Line 22: , a7 out nocopy JTF_VARCHAR2_TABLE_100

18: , a3 out nocopy JTF_VARCHAR2_TABLE_100
19: , a4 out nocopy JTF_VARCHAR2_TABLE_1000
20: , a5 out nocopy JTF_VARCHAR2_TABLE_100
21: , a6 out nocopy JTF_NUMBER_TABLE
22: , a7 out nocopy JTF_VARCHAR2_TABLE_100
23: , a8 out nocopy JTF_NUMBER_TABLE
24: );
25:
26: procedure pending_approval_sysadmin(p_sort_order VARCHAR2

Line 29: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100

25:
26: procedure pending_approval_sysadmin(p_sort_order VARCHAR2
27: , p_number_of_records NUMBER
28: , p2_a0 out nocopy JTF_DATE_TABLE
29: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
30: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_400
31: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
32: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_1000
33: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 31: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100

27: , p_number_of_records NUMBER
28: , p2_a0 out nocopy JTF_DATE_TABLE
29: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
30: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_400
31: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
32: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_1000
33: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
34: , p2_a6 out nocopy JTF_NUMBER_TABLE
35: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 32: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_1000

28: , p2_a0 out nocopy JTF_DATE_TABLE
29: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
30: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_400
31: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
32: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_1000
33: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
34: , p2_a6 out nocopy JTF_NUMBER_TABLE
35: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_100
36: , p2_a8 out nocopy JTF_NUMBER_TABLE

Line 33: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100

29: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
30: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_400
31: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
32: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_1000
33: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
34: , p2_a6 out nocopy JTF_NUMBER_TABLE
35: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_100
36: , p2_a8 out nocopy JTF_NUMBER_TABLE
37: );

Line 35: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_100

31: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
32: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_1000
33: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
34: , p2_a6 out nocopy JTF_NUMBER_TABLE
35: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_100
36: , p2_a8 out nocopy JTF_NUMBER_TABLE
37: );
38: procedure pending_approval_primary(p_sort_order VARCHAR2
39: , p_number_of_records NUMBER

Line 42: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100

38: procedure pending_approval_primary(p_sort_order VARCHAR2
39: , p_number_of_records NUMBER
40: , p_approver_user_id NUMBER
41: , p3_a0 out nocopy JTF_DATE_TABLE
42: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
43: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_400
44: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
45: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000
46: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 44: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100

40: , p_approver_user_id NUMBER
41: , p3_a0 out nocopy JTF_DATE_TABLE
42: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
43: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_400
44: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
45: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000
46: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
47: , p3_a6 out nocopy JTF_NUMBER_TABLE
48: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 45: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000

41: , p3_a0 out nocopy JTF_DATE_TABLE
42: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
43: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_400
44: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
45: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000
46: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
47: , p3_a6 out nocopy JTF_NUMBER_TABLE
48: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
49: , p3_a8 out nocopy JTF_NUMBER_TABLE

Line 46: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100

42: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
43: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_400
44: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
45: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000
46: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
47: , p3_a6 out nocopy JTF_NUMBER_TABLE
48: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
49: , p3_a8 out nocopy JTF_NUMBER_TABLE
50: );

Line 48: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100

44: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
45: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000
46: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
47: , p3_a6 out nocopy JTF_NUMBER_TABLE
48: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
49: , p3_a8 out nocopy JTF_NUMBER_TABLE
50: );
51: procedure pending_approval_owner(p_sort_order VARCHAR2
52: , p_number_of_records NUMBER

Line 55: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100

51: procedure pending_approval_owner(p_sort_order VARCHAR2
52: , p_number_of_records NUMBER
53: , p_approver_user_id NUMBER
54: , p3_a0 out nocopy JTF_DATE_TABLE
55: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
56: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_400
57: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
58: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000
59: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 57: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100

53: , p_approver_user_id NUMBER
54: , p3_a0 out nocopy JTF_DATE_TABLE
55: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
56: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_400
57: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
58: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000
59: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
60: , p3_a6 out nocopy JTF_NUMBER_TABLE
61: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 58: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000

54: , p3_a0 out nocopy JTF_DATE_TABLE
55: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
56: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_400
57: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
58: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000
59: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
60: , p3_a6 out nocopy JTF_NUMBER_TABLE
61: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
62: , p3_a8 out nocopy JTF_NUMBER_TABLE

Line 59: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100

55: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
56: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_400
57: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
58: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000
59: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
60: , p3_a6 out nocopy JTF_NUMBER_TABLE
61: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
62: , p3_a8 out nocopy JTF_NUMBER_TABLE
63: );

Line 61: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100

57: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
58: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000
59: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
60: , p3_a6 out nocopy JTF_NUMBER_TABLE
61: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
62: , p3_a8 out nocopy JTF_NUMBER_TABLE
63: );
64: end jtf_um_approval_requests_pvt_w;