DBA Data[Home] [Help]

APPS.CSP_REQ_LINE_DETAILS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p3(t out nocopy csp_req_line_details_pvt.req_line_details_tbl_type, a0 JTF_NUMBER_TABLE

1: package csp_req_line_details_pvt_w AUTHID CURRENT_USER as
2: /* $Header: csprqldpvtws.pls 120.1 2010/12/07 06:21:13 hhaugeru noship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy csp_req_line_details_pvt.req_line_details_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package csp_req_line_details_pvt_w AUTHID CURRENT_USER as
2: /* $Header: csprqldpvtws.pls 120.1 2010/12/07 06:21:13 hhaugeru noship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy csp_req_line_details_pvt.req_line_details_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE

Line 5: , a2 JTF_NUMBER_TABLE

1: package csp_req_line_details_pvt_w AUTHID CURRENT_USER as
2: /* $Header: csprqldpvtws.pls 120.1 2010/12/07 06:21:13 hhaugeru noship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy csp_req_line_details_pvt.req_line_details_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE

Line 7: , a4 JTF_NUMBER_TABLE

3: procedure rosetta_table_copy_in_p3(t out nocopy csp_req_line_details_pvt.req_line_details_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE

Line 9: , a6 JTF_NUMBER_TABLE

5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: );
13: procedure rosetta_table_copy_out_p3(t csp_req_line_details_pvt.req_line_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 11: , a8 JTF_NUMBER_TABLE

7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: );
13: procedure rosetta_table_copy_out_p3(t csp_req_line_details_pvt.req_line_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_NUMBER_TABLE

Line 13: procedure rosetta_table_copy_out_p3(t csp_req_line_details_pvt.req_line_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: );
13: procedure rosetta_table_copy_out_p3(t csp_req_line_details_pvt.req_line_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_NUMBER_TABLE
16: , a3 out nocopy JTF_DATE_TABLE
17: , a4 out nocopy JTF_NUMBER_TABLE

Line 14: , a1 out nocopy JTF_NUMBER_TABLE

10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: );
13: procedure rosetta_table_copy_out_p3(t csp_req_line_details_pvt.req_line_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_NUMBER_TABLE
16: , a3 out nocopy JTF_DATE_TABLE
17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_DATE_TABLE

Line 15: , a2 out nocopy JTF_NUMBER_TABLE

11: , a8 JTF_NUMBER_TABLE
12: );
13: procedure rosetta_table_copy_out_p3(t csp_req_line_details_pvt.req_line_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_NUMBER_TABLE
16: , a3 out nocopy JTF_DATE_TABLE
17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_DATE_TABLE
19: , a6 out nocopy JTF_NUMBER_TABLE

Line 17: , a4 out nocopy JTF_NUMBER_TABLE

13: procedure rosetta_table_copy_out_p3(t csp_req_line_details_pvt.req_line_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_NUMBER_TABLE
16: , a3 out nocopy JTF_DATE_TABLE
17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_DATE_TABLE
19: , a6 out nocopy JTF_NUMBER_TABLE
20: , a7 out nocopy JTF_VARCHAR2_TABLE_100
21: , a8 out nocopy JTF_NUMBER_TABLE

Line 19: , a6 out nocopy JTF_NUMBER_TABLE

15: , a2 out nocopy JTF_NUMBER_TABLE
16: , a3 out nocopy JTF_DATE_TABLE
17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_DATE_TABLE
19: , a6 out nocopy JTF_NUMBER_TABLE
20: , a7 out nocopy JTF_VARCHAR2_TABLE_100
21: , a8 out nocopy JTF_NUMBER_TABLE
22: );
23:

Line 21: , a8 out nocopy JTF_NUMBER_TABLE

17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_DATE_TABLE
19: , a6 out nocopy JTF_NUMBER_TABLE
20: , a7 out nocopy JTF_VARCHAR2_TABLE_100
21: , a8 out nocopy JTF_NUMBER_TABLE
22: );
23:
24: procedure create_req_line_details(p_api_version_number NUMBER
25: , p_init_msg_list VARCHAR2

Line 28: , p4_a0 JTF_NUMBER_TABLE

24: procedure create_req_line_details(p_api_version_number NUMBER
25: , p_init_msg_list VARCHAR2
26: , p_commit VARCHAR2
27: , p_validation_level NUMBER
28: , p4_a0 JTF_NUMBER_TABLE
29: , p4_a1 JTF_NUMBER_TABLE
30: , p4_a2 JTF_NUMBER_TABLE
31: , p4_a3 JTF_DATE_TABLE
32: , p4_a4 JTF_NUMBER_TABLE

Line 29: , p4_a1 JTF_NUMBER_TABLE

25: , p_init_msg_list VARCHAR2
26: , p_commit VARCHAR2
27: , p_validation_level NUMBER
28: , p4_a0 JTF_NUMBER_TABLE
29: , p4_a1 JTF_NUMBER_TABLE
30: , p4_a2 JTF_NUMBER_TABLE
31: , p4_a3 JTF_DATE_TABLE
32: , p4_a4 JTF_NUMBER_TABLE
33: , p4_a5 JTF_DATE_TABLE

Line 30: , p4_a2 JTF_NUMBER_TABLE

26: , p_commit VARCHAR2
27: , p_validation_level NUMBER
28: , p4_a0 JTF_NUMBER_TABLE
29: , p4_a1 JTF_NUMBER_TABLE
30: , p4_a2 JTF_NUMBER_TABLE
31: , p4_a3 JTF_DATE_TABLE
32: , p4_a4 JTF_NUMBER_TABLE
33: , p4_a5 JTF_DATE_TABLE
34: , p4_a6 JTF_NUMBER_TABLE

Line 32: , p4_a4 JTF_NUMBER_TABLE

28: , p4_a0 JTF_NUMBER_TABLE
29: , p4_a1 JTF_NUMBER_TABLE
30: , p4_a2 JTF_NUMBER_TABLE
31: , p4_a3 JTF_DATE_TABLE
32: , p4_a4 JTF_NUMBER_TABLE
33: , p4_a5 JTF_DATE_TABLE
34: , p4_a6 JTF_NUMBER_TABLE
35: , p4_a7 JTF_VARCHAR2_TABLE_100
36: , p4_a8 JTF_NUMBER_TABLE

Line 34: , p4_a6 JTF_NUMBER_TABLE

30: , p4_a2 JTF_NUMBER_TABLE
31: , p4_a3 JTF_DATE_TABLE
32: , p4_a4 JTF_NUMBER_TABLE
33: , p4_a5 JTF_DATE_TABLE
34: , p4_a6 JTF_NUMBER_TABLE
35: , p4_a7 JTF_VARCHAR2_TABLE_100
36: , p4_a8 JTF_NUMBER_TABLE
37: , p5_a0 out nocopy JTF_NUMBER_TABLE
38: , p5_a1 out nocopy JTF_NUMBER_TABLE

Line 36: , p4_a8 JTF_NUMBER_TABLE

32: , p4_a4 JTF_NUMBER_TABLE
33: , p4_a5 JTF_DATE_TABLE
34: , p4_a6 JTF_NUMBER_TABLE
35: , p4_a7 JTF_VARCHAR2_TABLE_100
36: , p4_a8 JTF_NUMBER_TABLE
37: , p5_a0 out nocopy JTF_NUMBER_TABLE
38: , p5_a1 out nocopy JTF_NUMBER_TABLE
39: , p5_a2 out nocopy JTF_NUMBER_TABLE
40: , p5_a3 out nocopy JTF_DATE_TABLE

Line 37: , p5_a0 out nocopy JTF_NUMBER_TABLE

33: , p4_a5 JTF_DATE_TABLE
34: , p4_a6 JTF_NUMBER_TABLE
35: , p4_a7 JTF_VARCHAR2_TABLE_100
36: , p4_a8 JTF_NUMBER_TABLE
37: , p5_a0 out nocopy JTF_NUMBER_TABLE
38: , p5_a1 out nocopy JTF_NUMBER_TABLE
39: , p5_a2 out nocopy JTF_NUMBER_TABLE
40: , p5_a3 out nocopy JTF_DATE_TABLE
41: , p5_a4 out nocopy JTF_NUMBER_TABLE

Line 38: , p5_a1 out nocopy JTF_NUMBER_TABLE

34: , p4_a6 JTF_NUMBER_TABLE
35: , p4_a7 JTF_VARCHAR2_TABLE_100
36: , p4_a8 JTF_NUMBER_TABLE
37: , p5_a0 out nocopy JTF_NUMBER_TABLE
38: , p5_a1 out nocopy JTF_NUMBER_TABLE
39: , p5_a2 out nocopy JTF_NUMBER_TABLE
40: , p5_a3 out nocopy JTF_DATE_TABLE
41: , p5_a4 out nocopy JTF_NUMBER_TABLE
42: , p5_a5 out nocopy JTF_DATE_TABLE

Line 39: , p5_a2 out nocopy JTF_NUMBER_TABLE

35: , p4_a7 JTF_VARCHAR2_TABLE_100
36: , p4_a8 JTF_NUMBER_TABLE
37: , p5_a0 out nocopy JTF_NUMBER_TABLE
38: , p5_a1 out nocopy JTF_NUMBER_TABLE
39: , p5_a2 out nocopy JTF_NUMBER_TABLE
40: , p5_a3 out nocopy JTF_DATE_TABLE
41: , p5_a4 out nocopy JTF_NUMBER_TABLE
42: , p5_a5 out nocopy JTF_DATE_TABLE
43: , p5_a6 out nocopy JTF_NUMBER_TABLE

Line 41: , p5_a4 out nocopy JTF_NUMBER_TABLE

37: , p5_a0 out nocopy JTF_NUMBER_TABLE
38: , p5_a1 out nocopy JTF_NUMBER_TABLE
39: , p5_a2 out nocopy JTF_NUMBER_TABLE
40: , p5_a3 out nocopy JTF_DATE_TABLE
41: , p5_a4 out nocopy JTF_NUMBER_TABLE
42: , p5_a5 out nocopy JTF_DATE_TABLE
43: , p5_a6 out nocopy JTF_NUMBER_TABLE
44: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
45: , p5_a8 out nocopy JTF_NUMBER_TABLE

Line 43: , p5_a6 out nocopy JTF_NUMBER_TABLE

39: , p5_a2 out nocopy JTF_NUMBER_TABLE
40: , p5_a3 out nocopy JTF_DATE_TABLE
41: , p5_a4 out nocopy JTF_NUMBER_TABLE
42: , p5_a5 out nocopy JTF_DATE_TABLE
43: , p5_a6 out nocopy JTF_NUMBER_TABLE
44: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
45: , p5_a8 out nocopy JTF_NUMBER_TABLE
46: , x_return_status out nocopy VARCHAR2
47: , x_msg_count out nocopy NUMBER

Line 45: , p5_a8 out nocopy JTF_NUMBER_TABLE

41: , p5_a4 out nocopy JTF_NUMBER_TABLE
42: , p5_a5 out nocopy JTF_DATE_TABLE
43: , p5_a6 out nocopy JTF_NUMBER_TABLE
44: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
45: , p5_a8 out nocopy JTF_NUMBER_TABLE
46: , x_return_status out nocopy VARCHAR2
47: , x_msg_count out nocopy NUMBER
48: , x_msg_data out nocopy VARCHAR2
49: );

Line 54: , p4_a0 JTF_NUMBER_TABLE

50: procedure update_req_line_details(p_api_version_number NUMBER
51: , p_init_msg_list VARCHAR2
52: , p_commit VARCHAR2
53: , p_validation_level NUMBER
54: , p4_a0 JTF_NUMBER_TABLE
55: , p4_a1 JTF_NUMBER_TABLE
56: , p4_a2 JTF_NUMBER_TABLE
57: , p4_a3 JTF_DATE_TABLE
58: , p4_a4 JTF_NUMBER_TABLE

Line 55: , p4_a1 JTF_NUMBER_TABLE

51: , p_init_msg_list VARCHAR2
52: , p_commit VARCHAR2
53: , p_validation_level NUMBER
54: , p4_a0 JTF_NUMBER_TABLE
55: , p4_a1 JTF_NUMBER_TABLE
56: , p4_a2 JTF_NUMBER_TABLE
57: , p4_a3 JTF_DATE_TABLE
58: , p4_a4 JTF_NUMBER_TABLE
59: , p4_a5 JTF_DATE_TABLE

Line 56: , p4_a2 JTF_NUMBER_TABLE

52: , p_commit VARCHAR2
53: , p_validation_level NUMBER
54: , p4_a0 JTF_NUMBER_TABLE
55: , p4_a1 JTF_NUMBER_TABLE
56: , p4_a2 JTF_NUMBER_TABLE
57: , p4_a3 JTF_DATE_TABLE
58: , p4_a4 JTF_NUMBER_TABLE
59: , p4_a5 JTF_DATE_TABLE
60: , p4_a6 JTF_NUMBER_TABLE

Line 58: , p4_a4 JTF_NUMBER_TABLE

54: , p4_a0 JTF_NUMBER_TABLE
55: , p4_a1 JTF_NUMBER_TABLE
56: , p4_a2 JTF_NUMBER_TABLE
57: , p4_a3 JTF_DATE_TABLE
58: , p4_a4 JTF_NUMBER_TABLE
59: , p4_a5 JTF_DATE_TABLE
60: , p4_a6 JTF_NUMBER_TABLE
61: , p4_a7 JTF_VARCHAR2_TABLE_100
62: , p4_a8 JTF_NUMBER_TABLE

Line 60: , p4_a6 JTF_NUMBER_TABLE

56: , p4_a2 JTF_NUMBER_TABLE
57: , p4_a3 JTF_DATE_TABLE
58: , p4_a4 JTF_NUMBER_TABLE
59: , p4_a5 JTF_DATE_TABLE
60: , p4_a6 JTF_NUMBER_TABLE
61: , p4_a7 JTF_VARCHAR2_TABLE_100
62: , p4_a8 JTF_NUMBER_TABLE
63: , x_return_status out nocopy VARCHAR2
64: , x_msg_count out nocopy NUMBER

Line 62: , p4_a8 JTF_NUMBER_TABLE

58: , p4_a4 JTF_NUMBER_TABLE
59: , p4_a5 JTF_DATE_TABLE
60: , p4_a6 JTF_NUMBER_TABLE
61: , p4_a7 JTF_VARCHAR2_TABLE_100
62: , p4_a8 JTF_NUMBER_TABLE
63: , x_return_status out nocopy VARCHAR2
64: , x_msg_count out nocopy NUMBER
65: , x_msg_data out nocopy VARCHAR2
66: );

Line 71: , p4_a0 JTF_NUMBER_TABLE

67: procedure delete_req_line_details(p_api_version_number NUMBER
68: , p_init_msg_list VARCHAR2
69: , p_commit VARCHAR2
70: , p_validation_level NUMBER
71: , p4_a0 JTF_NUMBER_TABLE
72: , p4_a1 JTF_NUMBER_TABLE
73: , p4_a2 JTF_NUMBER_TABLE
74: , p4_a3 JTF_DATE_TABLE
75: , p4_a4 JTF_NUMBER_TABLE

Line 72: , p4_a1 JTF_NUMBER_TABLE

68: , p_init_msg_list VARCHAR2
69: , p_commit VARCHAR2
70: , p_validation_level NUMBER
71: , p4_a0 JTF_NUMBER_TABLE
72: , p4_a1 JTF_NUMBER_TABLE
73: , p4_a2 JTF_NUMBER_TABLE
74: , p4_a3 JTF_DATE_TABLE
75: , p4_a4 JTF_NUMBER_TABLE
76: , p4_a5 JTF_DATE_TABLE

Line 73: , p4_a2 JTF_NUMBER_TABLE

69: , p_commit VARCHAR2
70: , p_validation_level NUMBER
71: , p4_a0 JTF_NUMBER_TABLE
72: , p4_a1 JTF_NUMBER_TABLE
73: , p4_a2 JTF_NUMBER_TABLE
74: , p4_a3 JTF_DATE_TABLE
75: , p4_a4 JTF_NUMBER_TABLE
76: , p4_a5 JTF_DATE_TABLE
77: , p4_a6 JTF_NUMBER_TABLE

Line 75: , p4_a4 JTF_NUMBER_TABLE

71: , p4_a0 JTF_NUMBER_TABLE
72: , p4_a1 JTF_NUMBER_TABLE
73: , p4_a2 JTF_NUMBER_TABLE
74: , p4_a3 JTF_DATE_TABLE
75: , p4_a4 JTF_NUMBER_TABLE
76: , p4_a5 JTF_DATE_TABLE
77: , p4_a6 JTF_NUMBER_TABLE
78: , p4_a7 JTF_VARCHAR2_TABLE_100
79: , p4_a8 JTF_NUMBER_TABLE

Line 77: , p4_a6 JTF_NUMBER_TABLE

73: , p4_a2 JTF_NUMBER_TABLE
74: , p4_a3 JTF_DATE_TABLE
75: , p4_a4 JTF_NUMBER_TABLE
76: , p4_a5 JTF_DATE_TABLE
77: , p4_a6 JTF_NUMBER_TABLE
78: , p4_a7 JTF_VARCHAR2_TABLE_100
79: , p4_a8 JTF_NUMBER_TABLE
80: , x_return_status out nocopy VARCHAR2
81: , x_msg_count out nocopy NUMBER

Line 79: , p4_a8 JTF_NUMBER_TABLE

75: , p4_a4 JTF_NUMBER_TABLE
76: , p4_a5 JTF_DATE_TABLE
77: , p4_a6 JTF_NUMBER_TABLE
78: , p4_a7 JTF_VARCHAR2_TABLE_100
79: , p4_a8 JTF_NUMBER_TABLE
80: , x_return_status out nocopy VARCHAR2
81: , x_msg_count out nocopy NUMBER
82: , x_msg_data out nocopy VARCHAR2
83: );