DBA Data[Home] [Help]

APPS.OKL_MISC_TRANS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p14(t out nocopy okl_misc_trans_pvt.jrnl_line_tbl_type, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p14(t out nocopy okl_misc_trans_pvt.jrnl_line_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_2000

Line 23: , a1 JTF_NUMBER_TABLE

19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p14(t out nocopy okl_misc_trans_pvt.jrnl_line_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_2000
27: , a5 JTF_NUMBER_TABLE

Line 24: , a2 JTF_NUMBER_TABLE

20: end;
21:
22: procedure rosetta_table_copy_in_p14(t out nocopy okl_misc_trans_pvt.jrnl_line_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_2000
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE

Line 25: , a3 JTF_NUMBER_TABLE

21:
22: procedure rosetta_table_copy_in_p14(t out nocopy okl_misc_trans_pvt.jrnl_line_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_2000
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_200

Line 27: , a5 JTF_NUMBER_TABLE

23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_2000
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_200
30: , a8 JTF_NUMBER_TABLE
31: ) as

Line 28: , a6 JTF_NUMBER_TABLE

24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_2000
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_200
30: , a8 JTF_NUMBER_TABLE
31: ) as
32: ddindx binary_integer; indx binary_integer;

Line 30: , a8 JTF_NUMBER_TABLE

26: , a4 JTF_VARCHAR2_TABLE_2000
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_200
30: , a8 JTF_NUMBER_TABLE
31: ) as
32: ddindx binary_integer; indx binary_integer;
33: begin
34: if a0 is not null and a0.count > 0 then

Line 57: procedure rosetta_table_copy_out_p14(t okl_misc_trans_pvt.jrnl_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

53: end loop;
54: end if;
55: end if;
56: end rosetta_table_copy_in_p14;
57: procedure rosetta_table_copy_out_p14(t okl_misc_trans_pvt.jrnl_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
58: , a1 out nocopy JTF_NUMBER_TABLE
59: , a2 out nocopy JTF_NUMBER_TABLE
60: , a3 out nocopy JTF_NUMBER_TABLE
61: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 58: , a1 out nocopy JTF_NUMBER_TABLE

54: end if;
55: end if;
56: end rosetta_table_copy_in_p14;
57: procedure rosetta_table_copy_out_p14(t okl_misc_trans_pvt.jrnl_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
58: , a1 out nocopy JTF_NUMBER_TABLE
59: , a2 out nocopy JTF_NUMBER_TABLE
60: , a3 out nocopy JTF_NUMBER_TABLE
61: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
62: , a5 out nocopy JTF_NUMBER_TABLE

Line 59: , a2 out nocopy JTF_NUMBER_TABLE

55: end if;
56: end rosetta_table_copy_in_p14;
57: procedure rosetta_table_copy_out_p14(t okl_misc_trans_pvt.jrnl_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
58: , a1 out nocopy JTF_NUMBER_TABLE
59: , a2 out nocopy JTF_NUMBER_TABLE
60: , a3 out nocopy JTF_NUMBER_TABLE
61: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
62: , a5 out nocopy JTF_NUMBER_TABLE
63: , a6 out nocopy JTF_NUMBER_TABLE

Line 60: , a3 out nocopy JTF_NUMBER_TABLE

56: end rosetta_table_copy_in_p14;
57: procedure rosetta_table_copy_out_p14(t okl_misc_trans_pvt.jrnl_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
58: , a1 out nocopy JTF_NUMBER_TABLE
59: , a2 out nocopy JTF_NUMBER_TABLE
60: , a3 out nocopy JTF_NUMBER_TABLE
61: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
62: , a5 out nocopy JTF_NUMBER_TABLE
63: , a6 out nocopy JTF_NUMBER_TABLE
64: , a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 62: , a5 out nocopy JTF_NUMBER_TABLE

58: , a1 out nocopy JTF_NUMBER_TABLE
59: , a2 out nocopy JTF_NUMBER_TABLE
60: , a3 out nocopy JTF_NUMBER_TABLE
61: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
62: , a5 out nocopy JTF_NUMBER_TABLE
63: , a6 out nocopy JTF_NUMBER_TABLE
64: , a7 out nocopy JTF_VARCHAR2_TABLE_200
65: , a8 out nocopy JTF_NUMBER_TABLE
66: ) as

Line 63: , a6 out nocopy JTF_NUMBER_TABLE

59: , a2 out nocopy JTF_NUMBER_TABLE
60: , a3 out nocopy JTF_NUMBER_TABLE
61: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
62: , a5 out nocopy JTF_NUMBER_TABLE
63: , a6 out nocopy JTF_NUMBER_TABLE
64: , a7 out nocopy JTF_VARCHAR2_TABLE_200
65: , a8 out nocopy JTF_NUMBER_TABLE
66: ) as
67: ddindx binary_integer; indx binary_integer;

Line 65: , a8 out nocopy JTF_NUMBER_TABLE

61: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
62: , a5 out nocopy JTF_NUMBER_TABLE
63: , a6 out nocopy JTF_NUMBER_TABLE
64: , a7 out nocopy JTF_VARCHAR2_TABLE_200
65: , a8 out nocopy JTF_NUMBER_TABLE
66: ) as
67: ddindx binary_integer; indx binary_integer;
68: begin
69: if t is null or t.count = 0 then

Line 70: a0 := JTF_NUMBER_TABLE();

66: ) as
67: ddindx binary_integer; indx binary_integer;
68: begin
69: if t is null or t.count = 0 then
70: a0 := JTF_NUMBER_TABLE();
71: a1 := JTF_NUMBER_TABLE();
72: a2 := JTF_NUMBER_TABLE();
73: a3 := JTF_NUMBER_TABLE();
74: a4 := JTF_VARCHAR2_TABLE_2000();

Line 71: a1 := JTF_NUMBER_TABLE();

67: ddindx binary_integer; indx binary_integer;
68: begin
69: if t is null or t.count = 0 then
70: a0 := JTF_NUMBER_TABLE();
71: a1 := JTF_NUMBER_TABLE();
72: a2 := JTF_NUMBER_TABLE();
73: a3 := JTF_NUMBER_TABLE();
74: a4 := JTF_VARCHAR2_TABLE_2000();
75: a5 := JTF_NUMBER_TABLE();

Line 72: a2 := JTF_NUMBER_TABLE();

68: begin
69: if t is null or t.count = 0 then
70: a0 := JTF_NUMBER_TABLE();
71: a1 := JTF_NUMBER_TABLE();
72: a2 := JTF_NUMBER_TABLE();
73: a3 := JTF_NUMBER_TABLE();
74: a4 := JTF_VARCHAR2_TABLE_2000();
75: a5 := JTF_NUMBER_TABLE();
76: a6 := JTF_NUMBER_TABLE();

Line 73: a3 := JTF_NUMBER_TABLE();

69: if t is null or t.count = 0 then
70: a0 := JTF_NUMBER_TABLE();
71: a1 := JTF_NUMBER_TABLE();
72: a2 := JTF_NUMBER_TABLE();
73: a3 := JTF_NUMBER_TABLE();
74: a4 := JTF_VARCHAR2_TABLE_2000();
75: a5 := JTF_NUMBER_TABLE();
76: a6 := JTF_NUMBER_TABLE();
77: a7 := JTF_VARCHAR2_TABLE_200();

Line 75: a5 := JTF_NUMBER_TABLE();

71: a1 := JTF_NUMBER_TABLE();
72: a2 := JTF_NUMBER_TABLE();
73: a3 := JTF_NUMBER_TABLE();
74: a4 := JTF_VARCHAR2_TABLE_2000();
75: a5 := JTF_NUMBER_TABLE();
76: a6 := JTF_NUMBER_TABLE();
77: a7 := JTF_VARCHAR2_TABLE_200();
78: a8 := JTF_NUMBER_TABLE();
79: else

Line 76: a6 := JTF_NUMBER_TABLE();

72: a2 := JTF_NUMBER_TABLE();
73: a3 := JTF_NUMBER_TABLE();
74: a4 := JTF_VARCHAR2_TABLE_2000();
75: a5 := JTF_NUMBER_TABLE();
76: a6 := JTF_NUMBER_TABLE();
77: a7 := JTF_VARCHAR2_TABLE_200();
78: a8 := JTF_NUMBER_TABLE();
79: else
80: a0 := JTF_NUMBER_TABLE();

Line 78: a8 := JTF_NUMBER_TABLE();

74: a4 := JTF_VARCHAR2_TABLE_2000();
75: a5 := JTF_NUMBER_TABLE();
76: a6 := JTF_NUMBER_TABLE();
77: a7 := JTF_VARCHAR2_TABLE_200();
78: a8 := JTF_NUMBER_TABLE();
79: else
80: a0 := JTF_NUMBER_TABLE();
81: a1 := JTF_NUMBER_TABLE();
82: a2 := JTF_NUMBER_TABLE();

Line 80: a0 := JTF_NUMBER_TABLE();

76: a6 := JTF_NUMBER_TABLE();
77: a7 := JTF_VARCHAR2_TABLE_200();
78: a8 := JTF_NUMBER_TABLE();
79: else
80: a0 := JTF_NUMBER_TABLE();
81: a1 := JTF_NUMBER_TABLE();
82: a2 := JTF_NUMBER_TABLE();
83: a3 := JTF_NUMBER_TABLE();
84: a4 := JTF_VARCHAR2_TABLE_2000();

Line 81: a1 := JTF_NUMBER_TABLE();

77: a7 := JTF_VARCHAR2_TABLE_200();
78: a8 := JTF_NUMBER_TABLE();
79: else
80: a0 := JTF_NUMBER_TABLE();
81: a1 := JTF_NUMBER_TABLE();
82: a2 := JTF_NUMBER_TABLE();
83: a3 := JTF_NUMBER_TABLE();
84: a4 := JTF_VARCHAR2_TABLE_2000();
85: a5 := JTF_NUMBER_TABLE();

Line 82: a2 := JTF_NUMBER_TABLE();

78: a8 := JTF_NUMBER_TABLE();
79: else
80: a0 := JTF_NUMBER_TABLE();
81: a1 := JTF_NUMBER_TABLE();
82: a2 := JTF_NUMBER_TABLE();
83: a3 := JTF_NUMBER_TABLE();
84: a4 := JTF_VARCHAR2_TABLE_2000();
85: a5 := JTF_NUMBER_TABLE();
86: a6 := JTF_NUMBER_TABLE();

Line 83: a3 := JTF_NUMBER_TABLE();

79: else
80: a0 := JTF_NUMBER_TABLE();
81: a1 := JTF_NUMBER_TABLE();
82: a2 := JTF_NUMBER_TABLE();
83: a3 := JTF_NUMBER_TABLE();
84: a4 := JTF_VARCHAR2_TABLE_2000();
85: a5 := JTF_NUMBER_TABLE();
86: a6 := JTF_NUMBER_TABLE();
87: a7 := JTF_VARCHAR2_TABLE_200();

Line 85: a5 := JTF_NUMBER_TABLE();

81: a1 := JTF_NUMBER_TABLE();
82: a2 := JTF_NUMBER_TABLE();
83: a3 := JTF_NUMBER_TABLE();
84: a4 := JTF_VARCHAR2_TABLE_2000();
85: a5 := JTF_NUMBER_TABLE();
86: a6 := JTF_NUMBER_TABLE();
87: a7 := JTF_VARCHAR2_TABLE_200();
88: a8 := JTF_NUMBER_TABLE();
89: if t.count > 0 then

Line 86: a6 := JTF_NUMBER_TABLE();

82: a2 := JTF_NUMBER_TABLE();
83: a3 := JTF_NUMBER_TABLE();
84: a4 := JTF_VARCHAR2_TABLE_2000();
85: a5 := JTF_NUMBER_TABLE();
86: a6 := JTF_NUMBER_TABLE();
87: a7 := JTF_VARCHAR2_TABLE_200();
88: a8 := JTF_NUMBER_TABLE();
89: if t.count > 0 then
90: a0.extend(t.count);

Line 88: a8 := JTF_NUMBER_TABLE();

84: a4 := JTF_VARCHAR2_TABLE_2000();
85: a5 := JTF_NUMBER_TABLE();
86: a6 := JTF_NUMBER_TABLE();
87: a7 := JTF_VARCHAR2_TABLE_200();
88: a8 := JTF_NUMBER_TABLE();
89: if t.count > 0 then
90: a0.extend(t.count);
91: a1.extend(t.count);
92: a2.extend(t.count);

Line 460: , p6_a0 JTF_NUMBER_TABLE

456: , p_init_msg_list VARCHAR2
457: , x_return_status out nocopy VARCHAR2
458: , x_msg_count out nocopy NUMBER
459: , x_msg_data out nocopy VARCHAR2
460: , p6_a0 JTF_NUMBER_TABLE
461: , p6_a1 JTF_NUMBER_TABLE
462: , p6_a2 JTF_NUMBER_TABLE
463: , p6_a3 JTF_NUMBER_TABLE
464: , p6_a4 JTF_VARCHAR2_TABLE_2000

Line 461: , p6_a1 JTF_NUMBER_TABLE

457: , x_return_status out nocopy VARCHAR2
458: , x_msg_count out nocopy NUMBER
459: , x_msg_data out nocopy VARCHAR2
460: , p6_a0 JTF_NUMBER_TABLE
461: , p6_a1 JTF_NUMBER_TABLE
462: , p6_a2 JTF_NUMBER_TABLE
463: , p6_a3 JTF_NUMBER_TABLE
464: , p6_a4 JTF_VARCHAR2_TABLE_2000
465: , p6_a5 JTF_NUMBER_TABLE

Line 462: , p6_a2 JTF_NUMBER_TABLE

458: , x_msg_count out nocopy NUMBER
459: , x_msg_data out nocopy VARCHAR2
460: , p6_a0 JTF_NUMBER_TABLE
461: , p6_a1 JTF_NUMBER_TABLE
462: , p6_a2 JTF_NUMBER_TABLE
463: , p6_a3 JTF_NUMBER_TABLE
464: , p6_a4 JTF_VARCHAR2_TABLE_2000
465: , p6_a5 JTF_NUMBER_TABLE
466: , p6_a6 JTF_NUMBER_TABLE

Line 463: , p6_a3 JTF_NUMBER_TABLE

459: , x_msg_data out nocopy VARCHAR2
460: , p6_a0 JTF_NUMBER_TABLE
461: , p6_a1 JTF_NUMBER_TABLE
462: , p6_a2 JTF_NUMBER_TABLE
463: , p6_a3 JTF_NUMBER_TABLE
464: , p6_a4 JTF_VARCHAR2_TABLE_2000
465: , p6_a5 JTF_NUMBER_TABLE
466: , p6_a6 JTF_NUMBER_TABLE
467: , p6_a7 JTF_VARCHAR2_TABLE_200

Line 465: , p6_a5 JTF_NUMBER_TABLE

461: , p6_a1 JTF_NUMBER_TABLE
462: , p6_a2 JTF_NUMBER_TABLE
463: , p6_a3 JTF_NUMBER_TABLE
464: , p6_a4 JTF_VARCHAR2_TABLE_2000
465: , p6_a5 JTF_NUMBER_TABLE
466: , p6_a6 JTF_NUMBER_TABLE
467: , p6_a7 JTF_VARCHAR2_TABLE_200
468: , p6_a8 JTF_NUMBER_TABLE
469: , p7_a0 out nocopy NUMBER

Line 466: , p6_a6 JTF_NUMBER_TABLE

462: , p6_a2 JTF_NUMBER_TABLE
463: , p6_a3 JTF_NUMBER_TABLE
464: , p6_a4 JTF_VARCHAR2_TABLE_2000
465: , p6_a5 JTF_NUMBER_TABLE
466: , p6_a6 JTF_NUMBER_TABLE
467: , p6_a7 JTF_VARCHAR2_TABLE_200
468: , p6_a8 JTF_NUMBER_TABLE
469: , p7_a0 out nocopy NUMBER
470: , p7_a1 out nocopy NUMBER

Line 468: , p6_a8 JTF_NUMBER_TABLE

464: , p6_a4 JTF_VARCHAR2_TABLE_2000
465: , p6_a5 JTF_NUMBER_TABLE
466: , p6_a6 JTF_NUMBER_TABLE
467: , p6_a7 JTF_VARCHAR2_TABLE_200
468: , p6_a8 JTF_NUMBER_TABLE
469: , p7_a0 out nocopy NUMBER
470: , p7_a1 out nocopy NUMBER
471: , p7_a2 out nocopy NUMBER
472: , p7_a3 out nocopy NUMBER

Line 558: , p6_a0 JTF_NUMBER_TABLE

554: , p_init_msg_list VARCHAR2
555: , x_return_status out nocopy VARCHAR2
556: , x_msg_count out nocopy NUMBER
557: , x_msg_data out nocopy VARCHAR2
558: , p6_a0 JTF_NUMBER_TABLE
559: , p6_a1 JTF_NUMBER_TABLE
560: , p6_a2 JTF_NUMBER_TABLE
561: , p6_a3 JTF_NUMBER_TABLE
562: , p6_a4 JTF_VARCHAR2_TABLE_2000

Line 559: , p6_a1 JTF_NUMBER_TABLE

555: , x_return_status out nocopy VARCHAR2
556: , x_msg_count out nocopy NUMBER
557: , x_msg_data out nocopy VARCHAR2
558: , p6_a0 JTF_NUMBER_TABLE
559: , p6_a1 JTF_NUMBER_TABLE
560: , p6_a2 JTF_NUMBER_TABLE
561: , p6_a3 JTF_NUMBER_TABLE
562: , p6_a4 JTF_VARCHAR2_TABLE_2000
563: , p6_a5 JTF_NUMBER_TABLE

Line 560: , p6_a2 JTF_NUMBER_TABLE

556: , x_msg_count out nocopy NUMBER
557: , x_msg_data out nocopy VARCHAR2
558: , p6_a0 JTF_NUMBER_TABLE
559: , p6_a1 JTF_NUMBER_TABLE
560: , p6_a2 JTF_NUMBER_TABLE
561: , p6_a3 JTF_NUMBER_TABLE
562: , p6_a4 JTF_VARCHAR2_TABLE_2000
563: , p6_a5 JTF_NUMBER_TABLE
564: , p6_a6 JTF_NUMBER_TABLE

Line 561: , p6_a3 JTF_NUMBER_TABLE

557: , x_msg_data out nocopy VARCHAR2
558: , p6_a0 JTF_NUMBER_TABLE
559: , p6_a1 JTF_NUMBER_TABLE
560: , p6_a2 JTF_NUMBER_TABLE
561: , p6_a3 JTF_NUMBER_TABLE
562: , p6_a4 JTF_VARCHAR2_TABLE_2000
563: , p6_a5 JTF_NUMBER_TABLE
564: , p6_a6 JTF_NUMBER_TABLE
565: , p6_a7 JTF_VARCHAR2_TABLE_200

Line 563: , p6_a5 JTF_NUMBER_TABLE

559: , p6_a1 JTF_NUMBER_TABLE
560: , p6_a2 JTF_NUMBER_TABLE
561: , p6_a3 JTF_NUMBER_TABLE
562: , p6_a4 JTF_VARCHAR2_TABLE_2000
563: , p6_a5 JTF_NUMBER_TABLE
564: , p6_a6 JTF_NUMBER_TABLE
565: , p6_a7 JTF_VARCHAR2_TABLE_200
566: , p6_a8 JTF_NUMBER_TABLE
567: , p5_a0 NUMBER := 0-1962.0724

Line 564: , p6_a6 JTF_NUMBER_TABLE

560: , p6_a2 JTF_NUMBER_TABLE
561: , p6_a3 JTF_NUMBER_TABLE
562: , p6_a4 JTF_VARCHAR2_TABLE_2000
563: , p6_a5 JTF_NUMBER_TABLE
564: , p6_a6 JTF_NUMBER_TABLE
565: , p6_a7 JTF_VARCHAR2_TABLE_200
566: , p6_a8 JTF_NUMBER_TABLE
567: , p5_a0 NUMBER := 0-1962.0724
568: , p5_a1 NUMBER := 0-1962.0724

Line 566: , p6_a8 JTF_NUMBER_TABLE

562: , p6_a4 JTF_VARCHAR2_TABLE_2000
563: , p6_a5 JTF_NUMBER_TABLE
564: , p6_a6 JTF_NUMBER_TABLE
565: , p6_a7 JTF_VARCHAR2_TABLE_200
566: , p6_a8 JTF_NUMBER_TABLE
567: , p5_a0 NUMBER := 0-1962.0724
568: , p5_a1 NUMBER := 0-1962.0724
569: , p5_a2 NUMBER := 0-1962.0724
570: , p5_a3 NUMBER := 0-1962.0724