DBA Data[Home] [Help]

APPS.JTF_TPLCATEGORY_GRP_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p2(t out jtf_tplcategory_grp.category_id_tbl_type, a0 JTF_NUMBER_TABLE) as

18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out jtf_tplcategory_grp.category_id_tbl_type, a0 JTF_NUMBER_TABLE) as
23: ddindx binary_integer; indx binary_integer;
24: begin
25: if a0 is not null and a0.count > 0 then
26: if a0.count > 0 then

Line 40: procedure rosetta_table_copy_out_p2(t jtf_tplcategory_grp.category_id_tbl_type, a0 out JTF_NUMBER_TABLE) as

36: end loop;
37: end if;
38: end if;
39: end rosetta_table_copy_in_p2;
40: procedure rosetta_table_copy_out_p2(t jtf_tplcategory_grp.category_id_tbl_type, a0 out JTF_NUMBER_TABLE) as
41: ddindx binary_integer; indx binary_integer;
42: begin
43: if t is null or t.count = 0 then
44: a0 := JTF_NUMBER_TABLE();

Line 44: a0 := JTF_NUMBER_TABLE();

40: procedure rosetta_table_copy_out_p2(t jtf_tplcategory_grp.category_id_tbl_type, a0 out JTF_NUMBER_TABLE) as
41: ddindx binary_integer; indx binary_integer;
42: begin
43: if t is null or t.count = 0 then
44: a0 := JTF_NUMBER_TABLE();
45: else
46: a0 := JTF_NUMBER_TABLE();
47: if t.count > 0 then
48: a0.extend(t.count);

Line 46: a0 := JTF_NUMBER_TABLE();

42: begin
43: if t is null or t.count = 0 then
44: a0 := JTF_NUMBER_TABLE();
45: else
46: a0 := JTF_NUMBER_TABLE();
47: if t.count > 0 then
48: a0.extend(t.count);
49: ddindx := t.first;
50: indx := 1;

Line 63: procedure rosetta_table_copy_in_p3(t out jtf_tplcategory_grp.template_id_tbl_type, a0 JTF_NUMBER_TABLE) as

59: end if;
60: end if;
61: end rosetta_table_copy_out_p2;
62:
63: procedure rosetta_table_copy_in_p3(t out jtf_tplcategory_grp.template_id_tbl_type, a0 JTF_NUMBER_TABLE) as
64: ddindx binary_integer; indx binary_integer;
65: begin
66: if a0 is not null and a0.count > 0 then
67: if a0.count > 0 then

Line 81: procedure rosetta_table_copy_out_p3(t jtf_tplcategory_grp.template_id_tbl_type, a0 out JTF_NUMBER_TABLE) as

77: end loop;
78: end if;
79: end if;
80: end rosetta_table_copy_in_p3;
81: procedure rosetta_table_copy_out_p3(t jtf_tplcategory_grp.template_id_tbl_type, a0 out JTF_NUMBER_TABLE) as
82: ddindx binary_integer; indx binary_integer;
83: begin
84: if t is null or t.count = 0 then
85: a0 := JTF_NUMBER_TABLE();

Line 85: a0 := JTF_NUMBER_TABLE();

81: procedure rosetta_table_copy_out_p3(t jtf_tplcategory_grp.template_id_tbl_type, a0 out JTF_NUMBER_TABLE) as
82: ddindx binary_integer; indx binary_integer;
83: begin
84: if t is null or t.count = 0 then
85: a0 := JTF_NUMBER_TABLE();
86: else
87: a0 := JTF_NUMBER_TABLE();
88: if t.count > 0 then
89: a0.extend(t.count);

Line 87: a0 := JTF_NUMBER_TABLE();

83: begin
84: if t is null or t.count = 0 then
85: a0 := JTF_NUMBER_TABLE();
86: else
87: a0 := JTF_NUMBER_TABLE();
88: if t.count > 0 then
89: a0.extend(t.count);
90: ddindx := t.first;
91: indx := 1;

Line 104: procedure rosetta_table_copy_in_p4(t out jtf_tplcategory_grp.tpl_ctg_id_tbl_type, a0 JTF_NUMBER_TABLE) as

100: end if;
101: end if;
102: end rosetta_table_copy_out_p3;
103:
104: procedure rosetta_table_copy_in_p4(t out jtf_tplcategory_grp.tpl_ctg_id_tbl_type, a0 JTF_NUMBER_TABLE) as
105: ddindx binary_integer; indx binary_integer;
106: begin
107: if a0 is not null and a0.count > 0 then
108: if a0.count > 0 then

Line 122: procedure rosetta_table_copy_out_p4(t jtf_tplcategory_grp.tpl_ctg_id_tbl_type, a0 out JTF_NUMBER_TABLE) as

118: end loop;
119: end if;
120: end if;
121: end rosetta_table_copy_in_p4;
122: procedure rosetta_table_copy_out_p4(t jtf_tplcategory_grp.tpl_ctg_id_tbl_type, a0 out JTF_NUMBER_TABLE) as
123: ddindx binary_integer; indx binary_integer;
124: begin
125: if t is null or t.count = 0 then
126: a0 := JTF_NUMBER_TABLE();

Line 126: a0 := JTF_NUMBER_TABLE();

122: procedure rosetta_table_copy_out_p4(t jtf_tplcategory_grp.tpl_ctg_id_tbl_type, a0 out JTF_NUMBER_TABLE) as
123: ddindx binary_integer; indx binary_integer;
124: begin
125: if t is null or t.count = 0 then
126: a0 := JTF_NUMBER_TABLE();
127: else
128: a0 := JTF_NUMBER_TABLE();
129: if t.count > 0 then
130: a0.extend(t.count);

Line 128: a0 := JTF_NUMBER_TABLE();

124: begin
125: if t is null or t.count = 0 then
126: a0 := JTF_NUMBER_TABLE();
127: else
128: a0 := JTF_NUMBER_TABLE();
129: if t.count > 0 then
130: a0.extend(t.count);
131: ddindx := t.first;
132: indx := 1;

Line 152: , p_category_id_tbl JTF_NUMBER_TABLE

148: , x_return_status out VARCHAR2
149: , x_msg_count out NUMBER
150: , x_msg_data out VARCHAR2
151: , p_template_id NUMBER
152: , p_category_id_tbl JTF_NUMBER_TABLE
153: )
154: as
155: ddp_category_id_tbl jtf_tplcategory_grp.category_id_tbl_type;
156: ddindx binary_integer; indx binary_integer;

Line 195: , p_tpl_ctg_id_tbl JTF_NUMBER_TABLE

191: , p_commit VARCHAR2
192: , x_return_status out VARCHAR2
193: , x_msg_count out NUMBER
194: , x_msg_data out VARCHAR2
195: , p_tpl_ctg_id_tbl JTF_NUMBER_TABLE
196: )
197: as
198: ddp_tpl_ctg_id_tbl jtf_tplcategory_grp.tpl_ctg_id_tbl_type;
199: ddindx binary_integer; indx binary_integer;

Line 236: , p_template_id_tbl JTF_NUMBER_TABLE

232: , x_return_status out VARCHAR2
233: , x_msg_count out NUMBER
234: , x_msg_data out VARCHAR2
235: , p_category_id NUMBER
236: , p_template_id_tbl JTF_NUMBER_TABLE
237: )
238: as
239: ddp_template_id_tbl jtf_tplcategory_grp.template_id_tbl_type;
240: ddindx binary_integer; indx binary_integer;