DBA Data[Home] [Help]

APPS.AMV_MATCH_PVT_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p3(t out nocopy amv_match_pvt.terr_id_tbl_type, a0 JTF_NUMBER_TABLE) as

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p3(t out nocopy amv_match_pvt.terr_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_p3(t amv_match_pvt.terr_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

36: end loop;
37: end if;
38: end if;
39: end rosetta_table_copy_in_p3;
40: procedure rosetta_table_copy_out_p3(t amv_match_pvt.terr_id_tbl_type, a0 out nocopy 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_p3(t amv_match_pvt.terr_id_tbl_type, a0 out nocopy 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 118: , p_territory_tbl JTF_NUMBER_TABLE

114: , p_channel_id NUMBER
115: , p_item_id NUMBER
116: , p_table_name_code VARCHAR2
117: , p_match_type VARCHAR2
118: , p_territory_tbl JTF_NUMBER_TABLE
119: )
120:
121: as
122: ddp_territory_tbl amv_match_pvt.terr_id_tbl_type;

Line 185: , x_terr_id_tbl out nocopy JTF_NUMBER_TABLE

181: , x_msg_data out nocopy VARCHAR2
182: , p_check_login_user VARCHAR2
183: , p_resource_id NUMBER
184: , p_resource_type VARCHAR2
185: , x_terr_id_tbl out nocopy JTF_NUMBER_TABLE
186: , x_terr_name_tbl out nocopy JTF_VARCHAR2_TABLE_4000
187: )
188:
189: as

Line 240: , x_item_id_tbl out nocopy JTF_NUMBER_TABLE

236: , x_msg_data out nocopy VARCHAR2
237: , p_check_login_user VARCHAR2
238: , p_terr_id NUMBER
239: , p_table_name_code VARCHAR2
240: , x_item_id_tbl out nocopy JTF_NUMBER_TABLE
241: )
242:
243: as
244: ddx_item_id_tbl amv_match_pvt.terr_id_tbl_type;