DBA Data[Home] [Help]

APPS.CN_GET_COMM_SUMM_DATA_W dependencies on JTF_VARCHAR2_TABLE_300

Line 23: , a1 JTF_VARCHAR2_TABLE_300

19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out cn_get_comm_summ_data.comm_summ_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_300
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_300

Line 27: , a5 JTF_VARCHAR2_TABLE_300

23: , a1 JTF_VARCHAR2_TABLE_300
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_300
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE

Line 62: , a1 out JTF_VARCHAR2_TABLE_300

58: end if;
59: end if;
60: end rosetta_table_copy_in_p1;
61: procedure rosetta_table_copy_out_p1(t cn_get_comm_summ_data.comm_summ_tbl_type, a0 out JTF_NUMBER_TABLE
62: , a1 out JTF_VARCHAR2_TABLE_300
63: , a2 out JTF_VARCHAR2_TABLE_100
64: , a3 out JTF_VARCHAR2_TABLE_100
65: , a4 out JTF_VARCHAR2_TABLE_100
66: , a5 out JTF_VARCHAR2_TABLE_300

Line 66: , a5 out JTF_VARCHAR2_TABLE_300

62: , a1 out JTF_VARCHAR2_TABLE_300
63: , a2 out JTF_VARCHAR2_TABLE_100
64: , a3 out JTF_VARCHAR2_TABLE_100
65: , a4 out JTF_VARCHAR2_TABLE_100
66: , a5 out JTF_VARCHAR2_TABLE_300
67: , a6 out JTF_VARCHAR2_TABLE_100
68: , a7 out JTF_VARCHAR2_TABLE_100
69: , a8 out JTF_NUMBER_TABLE
70: , a9 out JTF_NUMBER_TABLE

Line 77: a1 := JTF_VARCHAR2_TABLE_300();

73: ddindx binary_integer; indx binary_integer;
74: begin
75: if t is null or t.count = 0 then
76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_VARCHAR2_TABLE_300();
78: a2 := JTF_VARCHAR2_TABLE_100();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_VARCHAR2_TABLE_100();
81: a5 := JTF_VARCHAR2_TABLE_300();

Line 81: a5 := JTF_VARCHAR2_TABLE_300();

77: a1 := JTF_VARCHAR2_TABLE_300();
78: a2 := JTF_VARCHAR2_TABLE_100();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_VARCHAR2_TABLE_100();
81: a5 := JTF_VARCHAR2_TABLE_300();
82: a6 := JTF_VARCHAR2_TABLE_100();
83: a7 := JTF_VARCHAR2_TABLE_100();
84: a8 := JTF_NUMBER_TABLE();
85: a9 := JTF_NUMBER_TABLE();

Line 89: a1 := JTF_VARCHAR2_TABLE_300();

85: a9 := JTF_NUMBER_TABLE();
86: a10 := JTF_NUMBER_TABLE();
87: else
88: a0 := JTF_NUMBER_TABLE();
89: a1 := JTF_VARCHAR2_TABLE_300();
90: a2 := JTF_VARCHAR2_TABLE_100();
91: a3 := JTF_VARCHAR2_TABLE_100();
92: a4 := JTF_VARCHAR2_TABLE_100();
93: a5 := JTF_VARCHAR2_TABLE_300();

Line 93: a5 := JTF_VARCHAR2_TABLE_300();

89: a1 := JTF_VARCHAR2_TABLE_300();
90: a2 := JTF_VARCHAR2_TABLE_100();
91: a3 := JTF_VARCHAR2_TABLE_100();
92: a4 := JTF_VARCHAR2_TABLE_100();
93: a5 := JTF_VARCHAR2_TABLE_300();
94: a6 := JTF_VARCHAR2_TABLE_100();
95: a7 := JTF_VARCHAR2_TABLE_100();
96: a8 := JTF_NUMBER_TABLE();
97: a9 := JTF_NUMBER_TABLE();

Line 220: , p6_a1 out JTF_VARCHAR2_TABLE_300

216: , p_user_id NUMBER
217: , p_credit_type_id NUMBER
218: , x_total_rows out NUMBER
219: , p6_a0 out JTF_NUMBER_TABLE
220: , p6_a1 out JTF_VARCHAR2_TABLE_300
221: , p6_a2 out JTF_VARCHAR2_TABLE_100
222: , p6_a3 out JTF_VARCHAR2_TABLE_100
223: , p6_a4 out JTF_VARCHAR2_TABLE_100
224: , p6_a5 out JTF_VARCHAR2_TABLE_300

Line 224: , p6_a5 out JTF_VARCHAR2_TABLE_300

220: , p6_a1 out JTF_VARCHAR2_TABLE_300
221: , p6_a2 out JTF_VARCHAR2_TABLE_100
222: , p6_a3 out JTF_VARCHAR2_TABLE_100
223: , p6_a4 out JTF_VARCHAR2_TABLE_100
224: , p6_a5 out JTF_VARCHAR2_TABLE_300
225: , p6_a6 out JTF_VARCHAR2_TABLE_100
226: , p6_a7 out JTF_VARCHAR2_TABLE_100
227: , p6_a8 out JTF_NUMBER_TABLE
228: , p6_a9 out JTF_NUMBER_TABLE