DBA Data[Home] [Help]

APPS.AHL_VWP_VISIT_MR_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_vwp_visit_mr_pvt.visit_mr_tbl_type, a0 JTF_NUMBER_TABLE

1: package ahl_vwp_visit_mr_pvt_w as
2: /* $Header: AHLWVMRS.pls 120.0 2005/05/26 02:20:27 appldev noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_vwp_visit_mr_pvt.visit_mr_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_200
7: , a4 JTF_VARCHAR2_TABLE_200

Line 4: , a1 JTF_NUMBER_TABLE

1: package ahl_vwp_visit_mr_pvt_w as
2: /* $Header: AHLWVMRS.pls 120.0 2005/05/26 02:20:27 appldev noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_vwp_visit_mr_pvt.visit_mr_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_200
7: , a4 JTF_VARCHAR2_TABLE_200
8: , a5 JTF_VARCHAR2_TABLE_200

Line 22: , a19 JTF_NUMBER_TABLE

18: , a15 JTF_VARCHAR2_TABLE_200
19: , a16 JTF_VARCHAR2_TABLE_200
20: , a17 JTF_VARCHAR2_TABLE_200
21: , a18 JTF_DATE_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_DATE_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_VARCHAR2_TABLE_100

Line 24: , a21 JTF_NUMBER_TABLE

20: , a17 JTF_VARCHAR2_TABLE_200
21: , a18 JTF_DATE_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_DATE_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_VARCHAR2_TABLE_100
27: );
28: procedure rosetta_table_copy_out_p1(t ahl_vwp_visit_mr_pvt.visit_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 25: , a22 JTF_NUMBER_TABLE

21: , a18 JTF_DATE_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_DATE_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_VARCHAR2_TABLE_100
27: );
28: procedure rosetta_table_copy_out_p1(t ahl_vwp_visit_mr_pvt.visit_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
29: , a1 out nocopy JTF_NUMBER_TABLE

Line 28: procedure rosetta_table_copy_out_p1(t ahl_vwp_visit_mr_pvt.visit_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_VARCHAR2_TABLE_100
27: );
28: procedure rosetta_table_copy_out_p1(t ahl_vwp_visit_mr_pvt.visit_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
29: , a1 out nocopy JTF_NUMBER_TABLE
30: , a2 out nocopy JTF_VARCHAR2_TABLE_100
31: , a3 out nocopy JTF_VARCHAR2_TABLE_200
32: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 29: , a1 out nocopy JTF_NUMBER_TABLE

25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_VARCHAR2_TABLE_100
27: );
28: procedure rosetta_table_copy_out_p1(t ahl_vwp_visit_mr_pvt.visit_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
29: , a1 out nocopy JTF_NUMBER_TABLE
30: , a2 out nocopy JTF_VARCHAR2_TABLE_100
31: , a3 out nocopy JTF_VARCHAR2_TABLE_200
32: , a4 out nocopy JTF_VARCHAR2_TABLE_200
33: , a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 47: , a19 out nocopy JTF_NUMBER_TABLE

43: , a15 out nocopy JTF_VARCHAR2_TABLE_200
44: , a16 out nocopy JTF_VARCHAR2_TABLE_200
45: , a17 out nocopy JTF_VARCHAR2_TABLE_200
46: , a18 out nocopy JTF_DATE_TABLE
47: , a19 out nocopy JTF_NUMBER_TABLE
48: , a20 out nocopy JTF_DATE_TABLE
49: , a21 out nocopy JTF_NUMBER_TABLE
50: , a22 out nocopy JTF_NUMBER_TABLE
51: , a23 out nocopy JTF_VARCHAR2_TABLE_100

Line 49: , a21 out nocopy JTF_NUMBER_TABLE

45: , a17 out nocopy JTF_VARCHAR2_TABLE_200
46: , a18 out nocopy JTF_DATE_TABLE
47: , a19 out nocopy JTF_NUMBER_TABLE
48: , a20 out nocopy JTF_DATE_TABLE
49: , a21 out nocopy JTF_NUMBER_TABLE
50: , a22 out nocopy JTF_NUMBER_TABLE
51: , a23 out nocopy JTF_VARCHAR2_TABLE_100
52: );
53:

Line 50: , a22 out nocopy JTF_NUMBER_TABLE

46: , a18 out nocopy JTF_DATE_TABLE
47: , a19 out nocopy JTF_NUMBER_TABLE
48: , a20 out nocopy JTF_DATE_TABLE
49: , a21 out nocopy JTF_NUMBER_TABLE
50: , a22 out nocopy JTF_NUMBER_TABLE
51: , a23 out nocopy JTF_VARCHAR2_TABLE_100
52: );
53:
54: procedure process_visit_mrs(p_api_version NUMBER

Line 59: , p5_a0 JTF_NUMBER_TABLE

55: , p_init_msg_list VARCHAR2
56: , p_commit VARCHAR2
57: , p_validation_level NUMBER
58: , p_module_type VARCHAR2
59: , p5_a0 JTF_NUMBER_TABLE
60: , p5_a1 JTF_NUMBER_TABLE
61: , p5_a2 JTF_VARCHAR2_TABLE_100
62: , p5_a3 JTF_VARCHAR2_TABLE_200
63: , p5_a4 JTF_VARCHAR2_TABLE_200

Line 60: , p5_a1 JTF_NUMBER_TABLE

56: , p_commit VARCHAR2
57: , p_validation_level NUMBER
58: , p_module_type VARCHAR2
59: , p5_a0 JTF_NUMBER_TABLE
60: , p5_a1 JTF_NUMBER_TABLE
61: , p5_a2 JTF_VARCHAR2_TABLE_100
62: , p5_a3 JTF_VARCHAR2_TABLE_200
63: , p5_a4 JTF_VARCHAR2_TABLE_200
64: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 78: , p5_a19 JTF_NUMBER_TABLE

74: , p5_a15 JTF_VARCHAR2_TABLE_200
75: , p5_a16 JTF_VARCHAR2_TABLE_200
76: , p5_a17 JTF_VARCHAR2_TABLE_200
77: , p5_a18 JTF_DATE_TABLE
78: , p5_a19 JTF_NUMBER_TABLE
79: , p5_a20 JTF_DATE_TABLE
80: , p5_a21 JTF_NUMBER_TABLE
81: , p5_a22 JTF_NUMBER_TABLE
82: , p5_a23 JTF_VARCHAR2_TABLE_100

Line 80: , p5_a21 JTF_NUMBER_TABLE

76: , p5_a17 JTF_VARCHAR2_TABLE_200
77: , p5_a18 JTF_DATE_TABLE
78: , p5_a19 JTF_NUMBER_TABLE
79: , p5_a20 JTF_DATE_TABLE
80: , p5_a21 JTF_NUMBER_TABLE
81: , p5_a22 JTF_NUMBER_TABLE
82: , p5_a23 JTF_VARCHAR2_TABLE_100
83: , x_return_status out nocopy VARCHAR2
84: , x_msg_count out nocopy NUMBER

Line 81: , p5_a22 JTF_NUMBER_TABLE

77: , p5_a18 JTF_DATE_TABLE
78: , p5_a19 JTF_NUMBER_TABLE
79: , p5_a20 JTF_DATE_TABLE
80: , p5_a21 JTF_NUMBER_TABLE
81: , p5_a22 JTF_NUMBER_TABLE
82: , p5_a23 JTF_VARCHAR2_TABLE_100
83: , x_return_status out nocopy VARCHAR2
84: , x_msg_count out nocopy NUMBER
85: , x_msg_data out nocopy VARCHAR2