eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMW_SCOPE_PVT_W dependencies on JTF_NUMBER_TABLE

Line 46: procedure rosetta_table_copy_in_p3(t out nocopy amw_scope_pvt.sub_new_tbl_type, a0 JTF_NUMBER_TABLE

42: end if;
43: end if;
44: end rosetta_table_copy_out_p1;
45:
46: procedure rosetta_table_copy_in_p3(t out nocopy amw_scope_pvt.sub_new_tbl_type, a0 JTF_NUMBER_TABLE
47: ) as
48: ddindx binary_integer; indx binary_integer;
49: begin
50: if a0 is not null and a0.count > 0 then

Line 65: procedure rosetta_table_copy_out_p3(t amw_scope_pvt.sub_new_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

61: end loop;
62: end if;
63: end if;
64: end rosetta_table_copy_in_p3;
65: procedure rosetta_table_copy_out_p3(t amw_scope_pvt.sub_new_tbl_type, a0 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: else
72: a0 := JTF_NUMBER_TABLE();
73: if t.count > 0 then
74: a0.extend(t.count);

Line 72: a0 := JTF_NUMBER_TABLE();

68: begin
69: if t is null or t.count = 0 then
70: a0 := JTF_NUMBER_TABLE();
71: else
72: a0 := JTF_NUMBER_TABLE();
73: if t.count > 0 then
74: a0.extend(t.count);
75: ddindx := t.first;
76: indx := 1;

Line 132: procedure rosetta_table_copy_in_p7(t out nocopy amw_scope_pvt.lob_new_tbl_type, a0 JTF_NUMBER_TABLE

128: end if;
129: end if;
130: end rosetta_table_copy_out_p5;
131:
132: procedure rosetta_table_copy_in_p7(t out nocopy amw_scope_pvt.lob_new_tbl_type, a0 JTF_NUMBER_TABLE
133: ) as
134: ddindx binary_integer; indx binary_integer;
135: begin
136: if a0 is not null and a0.count > 0 then

Line 151: procedure rosetta_table_copy_out_p7(t amw_scope_pvt.lob_new_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

147: end loop;
148: end if;
149: end if;
150: end rosetta_table_copy_in_p7;
151: procedure rosetta_table_copy_out_p7(t amw_scope_pvt.lob_new_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
152: ) as
153: ddindx binary_integer; indx binary_integer;
154: begin
155: if t is null or t.count = 0 then

Line 156: a0 := JTF_NUMBER_TABLE();

152: ) as
153: ddindx binary_integer; indx binary_integer;
154: begin
155: if t is null or t.count = 0 then
156: a0 := JTF_NUMBER_TABLE();
157: else
158: a0 := JTF_NUMBER_TABLE();
159: if t.count > 0 then
160: a0.extend(t.count);

Line 158: a0 := JTF_NUMBER_TABLE();

154: begin
155: if t is null or t.count = 0 then
156: a0 := JTF_NUMBER_TABLE();
157: else
158: a0 := JTF_NUMBER_TABLE();
159: if t.count > 0 then
160: a0.extend(t.count);
161: ddindx := t.first;
162: indx := 1;

Line 175: procedure rosetta_table_copy_in_p9(t out nocopy amw_scope_pvt.org_tbl_type, a0 JTF_NUMBER_TABLE

171: end if;
172: end if;
173: end rosetta_table_copy_out_p7;
174:
175: procedure rosetta_table_copy_in_p9(t out nocopy amw_scope_pvt.org_tbl_type, a0 JTF_NUMBER_TABLE
176: ) as
177: ddindx binary_integer; indx binary_integer;
178: begin
179: if a0 is not null and a0.count > 0 then

Line 194: procedure rosetta_table_copy_out_p9(t amw_scope_pvt.org_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

190: end loop;
191: end if;
192: end if;
193: end rosetta_table_copy_in_p9;
194: procedure rosetta_table_copy_out_p9(t amw_scope_pvt.org_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
195: ) as
196: ddindx binary_integer; indx binary_integer;
197: begin
198: if t is null or t.count = 0 then

Line 199: a0 := JTF_NUMBER_TABLE();

195: ) as
196: ddindx binary_integer; indx binary_integer;
197: begin
198: if t is null or t.count = 0 then
199: a0 := JTF_NUMBER_TABLE();
200: else
201: a0 := JTF_NUMBER_TABLE();
202: if t.count > 0 then
203: a0.extend(t.count);

Line 201: a0 := JTF_NUMBER_TABLE();

197: begin
198: if t is null or t.count = 0 then
199: a0 := JTF_NUMBER_TABLE();
200: else
201: a0 := JTF_NUMBER_TABLE();
202: if t.count > 0 then
203: a0.extend(t.count);
204: ddindx := t.first;
205: indx := 1;

Line 218: procedure rosetta_table_copy_in_p11(t out nocopy amw_scope_pvt.process_tbl_type, a0 JTF_NUMBER_TABLE

214: end if;
215: end if;
216: end rosetta_table_copy_out_p9;
217:
218: procedure rosetta_table_copy_in_p11(t out nocopy amw_scope_pvt.process_tbl_type, a0 JTF_NUMBER_TABLE
219: ) as
220: ddindx binary_integer; indx binary_integer;
221: begin
222: if a0 is not null and a0.count > 0 then

Line 237: procedure rosetta_table_copy_out_p11(t amw_scope_pvt.process_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

233: end loop;
234: end if;
235: end if;
236: end rosetta_table_copy_in_p11;
237: procedure rosetta_table_copy_out_p11(t amw_scope_pvt.process_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
238: ) as
239: ddindx binary_integer; indx binary_integer;
240: begin
241: if t is null or t.count = 0 then

Line 242: a0 := JTF_NUMBER_TABLE();

238: ) as
239: ddindx binary_integer; indx binary_integer;
240: begin
241: if t is null or t.count = 0 then
242: a0 := JTF_NUMBER_TABLE();
243: else
244: a0 := JTF_NUMBER_TABLE();
245: if t.count > 0 then
246: a0.extend(t.count);

Line 244: a0 := JTF_NUMBER_TABLE();

240: begin
241: if t is null or t.count = 0 then
242: a0 := JTF_NUMBER_TABLE();
243: else
244: a0 := JTF_NUMBER_TABLE();
245: if t.count > 0 then
246: a0.extend(t.count);
247: ddindx := t.first;
248: indx := 1;

Line 261: procedure rosetta_table_copy_in_p13(t out nocopy amw_scope_pvt.proc_hier_tbl_type, a0 JTF_NUMBER_TABLE

257: end if;
258: end if;
259: end rosetta_table_copy_out_p11;
260:
261: procedure rosetta_table_copy_in_p13(t out nocopy amw_scope_pvt.proc_hier_tbl_type, a0 JTF_NUMBER_TABLE
262: , a1 JTF_NUMBER_TABLE
263: , a2 JTF_NUMBER_TABLE
264: , a3 JTF_NUMBER_TABLE
265: ) as

Line 262: , a1 JTF_NUMBER_TABLE

258: end if;
259: end rosetta_table_copy_out_p11;
260:
261: procedure rosetta_table_copy_in_p13(t out nocopy amw_scope_pvt.proc_hier_tbl_type, a0 JTF_NUMBER_TABLE
262: , a1 JTF_NUMBER_TABLE
263: , a2 JTF_NUMBER_TABLE
264: , a3 JTF_NUMBER_TABLE
265: ) as
266: ddindx binary_integer; indx binary_integer;

Line 263: , a2 JTF_NUMBER_TABLE

259: end rosetta_table_copy_out_p11;
260:
261: procedure rosetta_table_copy_in_p13(t out nocopy amw_scope_pvt.proc_hier_tbl_type, a0 JTF_NUMBER_TABLE
262: , a1 JTF_NUMBER_TABLE
263: , a2 JTF_NUMBER_TABLE
264: , a3 JTF_NUMBER_TABLE
265: ) as
266: ddindx binary_integer; indx binary_integer;
267: begin

Line 264: , a3 JTF_NUMBER_TABLE

260:
261: procedure rosetta_table_copy_in_p13(t out nocopy amw_scope_pvt.proc_hier_tbl_type, a0 JTF_NUMBER_TABLE
262: , a1 JTF_NUMBER_TABLE
263: , a2 JTF_NUMBER_TABLE
264: , a3 JTF_NUMBER_TABLE
265: ) as
266: ddindx binary_integer; indx binary_integer;
267: begin
268: if a0 is not null and a0.count > 0 then

Line 286: procedure rosetta_table_copy_out_p13(t amw_scope_pvt.proc_hier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

282: end loop;
283: end if;
284: end if;
285: end rosetta_table_copy_in_p13;
286: procedure rosetta_table_copy_out_p13(t amw_scope_pvt.proc_hier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
287: , a1 out nocopy JTF_NUMBER_TABLE
288: , a2 out nocopy JTF_NUMBER_TABLE
289: , a3 out nocopy JTF_NUMBER_TABLE
290: ) as

Line 287: , a1 out nocopy JTF_NUMBER_TABLE

283: end if;
284: end if;
285: end rosetta_table_copy_in_p13;
286: procedure rosetta_table_copy_out_p13(t amw_scope_pvt.proc_hier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
287: , a1 out nocopy JTF_NUMBER_TABLE
288: , a2 out nocopy JTF_NUMBER_TABLE
289: , a3 out nocopy JTF_NUMBER_TABLE
290: ) as
291: ddindx binary_integer; indx binary_integer;

Line 288: , a2 out nocopy JTF_NUMBER_TABLE

284: end if;
285: end rosetta_table_copy_in_p13;
286: procedure rosetta_table_copy_out_p13(t amw_scope_pvt.proc_hier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
287: , a1 out nocopy JTF_NUMBER_TABLE
288: , a2 out nocopy JTF_NUMBER_TABLE
289: , a3 out nocopy JTF_NUMBER_TABLE
290: ) as
291: ddindx binary_integer; indx binary_integer;
292: begin

Line 289: , a3 out nocopy JTF_NUMBER_TABLE

285: end rosetta_table_copy_in_p13;
286: procedure rosetta_table_copy_out_p13(t amw_scope_pvt.proc_hier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
287: , a1 out nocopy JTF_NUMBER_TABLE
288: , a2 out nocopy JTF_NUMBER_TABLE
289: , a3 out nocopy JTF_NUMBER_TABLE
290: ) as
291: ddindx binary_integer; indx binary_integer;
292: begin
293: if t is null or t.count = 0 then

Line 294: a0 := JTF_NUMBER_TABLE();

290: ) as
291: ddindx binary_integer; indx binary_integer;
292: begin
293: if t is null or t.count = 0 then
294: a0 := JTF_NUMBER_TABLE();
295: a1 := JTF_NUMBER_TABLE();
296: a2 := JTF_NUMBER_TABLE();
297: a3 := JTF_NUMBER_TABLE();
298: else

Line 295: a1 := JTF_NUMBER_TABLE();

291: ddindx binary_integer; indx binary_integer;
292: begin
293: if t is null or t.count = 0 then
294: a0 := JTF_NUMBER_TABLE();
295: a1 := JTF_NUMBER_TABLE();
296: a2 := JTF_NUMBER_TABLE();
297: a3 := JTF_NUMBER_TABLE();
298: else
299: a0 := JTF_NUMBER_TABLE();

Line 296: a2 := JTF_NUMBER_TABLE();

292: begin
293: if t is null or t.count = 0 then
294: a0 := JTF_NUMBER_TABLE();
295: a1 := JTF_NUMBER_TABLE();
296: a2 := JTF_NUMBER_TABLE();
297: a3 := JTF_NUMBER_TABLE();
298: else
299: a0 := JTF_NUMBER_TABLE();
300: a1 := JTF_NUMBER_TABLE();

Line 297: a3 := JTF_NUMBER_TABLE();

293: if t is null or t.count = 0 then
294: a0 := JTF_NUMBER_TABLE();
295: a1 := JTF_NUMBER_TABLE();
296: a2 := JTF_NUMBER_TABLE();
297: a3 := JTF_NUMBER_TABLE();
298: else
299: a0 := JTF_NUMBER_TABLE();
300: a1 := JTF_NUMBER_TABLE();
301: a2 := JTF_NUMBER_TABLE();

Line 299: a0 := JTF_NUMBER_TABLE();

295: a1 := JTF_NUMBER_TABLE();
296: a2 := JTF_NUMBER_TABLE();
297: a3 := JTF_NUMBER_TABLE();
298: else
299: a0 := JTF_NUMBER_TABLE();
300: a1 := JTF_NUMBER_TABLE();
301: a2 := JTF_NUMBER_TABLE();
302: a3 := JTF_NUMBER_TABLE();
303: if t.count > 0 then

Line 300: a1 := JTF_NUMBER_TABLE();

296: a2 := JTF_NUMBER_TABLE();
297: a3 := JTF_NUMBER_TABLE();
298: else
299: a0 := JTF_NUMBER_TABLE();
300: a1 := JTF_NUMBER_TABLE();
301: a2 := JTF_NUMBER_TABLE();
302: a3 := JTF_NUMBER_TABLE();
303: if t.count > 0 then
304: a0.extend(t.count);

Line 301: a2 := JTF_NUMBER_TABLE();

297: a3 := JTF_NUMBER_TABLE();
298: else
299: a0 := JTF_NUMBER_TABLE();
300: a1 := JTF_NUMBER_TABLE();
301: a2 := JTF_NUMBER_TABLE();
302: a3 := JTF_NUMBER_TABLE();
303: if t.count > 0 then
304: a0.extend(t.count);
305: a1.extend(t.count);

Line 302: a3 := JTF_NUMBER_TABLE();

298: else
299: a0 := JTF_NUMBER_TABLE();
300: a1 := JTF_NUMBER_TABLE();
301: a2 := JTF_NUMBER_TABLE();
302: a3 := JTF_NUMBER_TABLE();
303: if t.count > 0 then
304: a0.extend(t.count);
305: a1.extend(t.count);
306: a2.extend(t.count);

Line 335: , p10_a0 JTF_NUMBER_TABLE

331: , p_sub_vs VARCHAR2
332: , p_lob_vs VARCHAR2
333: , p8_a0 JTF_VARCHAR2_TABLE_200
334: , p9_a0 JTF_VARCHAR2_TABLE_200
335: , p10_a0 JTF_NUMBER_TABLE
336: , p11_a0 JTF_NUMBER_TABLE
337: , x_return_status out nocopy VARCHAR2
338: , x_msg_count out nocopy NUMBER
339: , x_msg_data out nocopy VARCHAR2

Line 336: , p11_a0 JTF_NUMBER_TABLE

332: , p_lob_vs VARCHAR2
333: , p8_a0 JTF_VARCHAR2_TABLE_200
334: , p9_a0 JTF_VARCHAR2_TABLE_200
335: , p10_a0 JTF_NUMBER_TABLE
336: , p11_a0 JTF_NUMBER_TABLE
337: , x_return_status out nocopy VARCHAR2
338: , x_msg_count out nocopy NUMBER
339: , x_msg_data out nocopy VARCHAR2
340: )

Line 408: procedure populate_custom_hierarchy(p0_a0 JTF_NUMBER_TABLE

404:
405:
406: end;
407:
408: procedure populate_custom_hierarchy(p0_a0 JTF_NUMBER_TABLE
409: , p_entity_id NUMBER
410: , p_entity_type VARCHAR2
411: )
412:

Line 436: , p2_a0 JTF_NUMBER_TABLE

432: end;
433:
434: procedure generate_organization_list(p_entity_id NUMBER
435: , p_entity_type VARCHAR2
436: , p2_a0 JTF_NUMBER_TABLE
437: , p3_a0 out nocopy JTF_NUMBER_TABLE
438: )
439:
440: as

Line 437: , p3_a0 out nocopy JTF_NUMBER_TABLE

433:
434: procedure generate_organization_list(p_entity_id NUMBER
435: , p_entity_type VARCHAR2
436: , p2_a0 JTF_NUMBER_TABLE
437: , p3_a0 out nocopy JTF_NUMBER_TABLE
438: )
439:
440: as
441: ddp_org_tbl amw_scope_pvt.org_tbl_type;

Line 469: , p2_a0 JTF_NUMBER_TABLE

465: end;
466:
467: procedure generate_subsidiary_list(p_entity_id NUMBER
468: , p_entity_type VARCHAR2
469: , p2_a0 JTF_NUMBER_TABLE
470: , p3_a0 JTF_VARCHAR2_TABLE_200
471: , p_sub_vs VARCHAR2
472: , p5_a0 out nocopy JTF_NUMBER_TABLE
473: )

Line 472: , p5_a0 out nocopy JTF_NUMBER_TABLE

468: , p_entity_type VARCHAR2
469: , p2_a0 JTF_NUMBER_TABLE
470: , p3_a0 JTF_VARCHAR2_TABLE_200
471: , p_sub_vs VARCHAR2
472: , p5_a0 out nocopy JTF_NUMBER_TABLE
473: )
474:
475: as
476: ddp_org_new_tbl amw_scope_pvt.org_tbl_type;

Line 513: , p2_a0 JTF_NUMBER_TABLE

509: end;
510:
511: procedure generate_lob_list(p_entity_id NUMBER
512: , p_entity_type VARCHAR2
513: , p2_a0 JTF_NUMBER_TABLE
514: , p3_a0 JTF_VARCHAR2_TABLE_200
515: , p_sub_vs VARCHAR2
516: , p5_a0 JTF_VARCHAR2_TABLE_200
517: , p_lob_vs VARCHAR2

Line 518: , p7_a0 out nocopy JTF_NUMBER_TABLE

514: , p3_a0 JTF_VARCHAR2_TABLE_200
515: , p_sub_vs VARCHAR2
516: , p5_a0 JTF_VARCHAR2_TABLE_200
517: , p_lob_vs VARCHAR2
518: , p7_a0 out nocopy JTF_NUMBER_TABLE
519: )
520:
521: as
522: ddp_org_new_tbl amw_scope_pvt.org_tbl_type;

Line 572: , p6_a0 JTF_NUMBER_TABLE

568: , p_commit VARCHAR2
569: , p_validation_level NUMBER
570: , p_entity_type VARCHAR2
571: , p_entity_id NUMBER
572: , p6_a0 JTF_NUMBER_TABLE
573: , p7_a0 JTF_NUMBER_TABLE
574: , x_return_status out nocopy VARCHAR2
575: , x_msg_count out nocopy NUMBER
576: , x_msg_data out nocopy VARCHAR2

Line 573: , p7_a0 JTF_NUMBER_TABLE

569: , p_validation_level NUMBER
570: , p_entity_type VARCHAR2
571: , p_entity_id NUMBER
572: , p6_a0 JTF_NUMBER_TABLE
573: , p7_a0 JTF_NUMBER_TABLE
574: , x_return_status out nocopy VARCHAR2
575: , x_msg_count out nocopy NUMBER
576: , x_msg_data out nocopy VARCHAR2
577: )

Line 629: , p2_a0 JTF_NUMBER_TABLE

625: end;
626:
627: procedure populate_denormalized_tables(p_entity_type VARCHAR2
628: , p_entity_id NUMBER
629: , p2_a0 JTF_NUMBER_TABLE
630: , p3_a0 JTF_NUMBER_TABLE
631: , p_mode VARCHAR2
632: )
633:

Line 630: , p3_a0 JTF_NUMBER_TABLE

626:
627: procedure populate_denormalized_tables(p_entity_type VARCHAR2
628: , p_entity_id NUMBER
629: , p2_a0 JTF_NUMBER_TABLE
630: , p3_a0 JTF_NUMBER_TABLE
631: , p_mode VARCHAR2
632: )
633:
634: as

Line 671: , p7_a0 JTF_NUMBER_TABLE

667: , p_validation_level NUMBER
668: , p_entity_type VARCHAR2
669: , p_entity_id NUMBER
670: , p_organization_id NUMBER
671: , p7_a0 JTF_NUMBER_TABLE
672: , p7_a1 JTF_NUMBER_TABLE
673: , p7_a2 JTF_NUMBER_TABLE
674: , p7_a3 JTF_NUMBER_TABLE
675: , x_return_status out nocopy VARCHAR2

Line 672: , p7_a1 JTF_NUMBER_TABLE

668: , p_entity_type VARCHAR2
669: , p_entity_id NUMBER
670: , p_organization_id NUMBER
671: , p7_a0 JTF_NUMBER_TABLE
672: , p7_a1 JTF_NUMBER_TABLE
673: , p7_a2 JTF_NUMBER_TABLE
674: , p7_a3 JTF_NUMBER_TABLE
675: , x_return_status out nocopy VARCHAR2
676: , x_msg_count out nocopy NUMBER

Line 673: , p7_a2 JTF_NUMBER_TABLE

669: , p_entity_id NUMBER
670: , p_organization_id NUMBER
671: , p7_a0 JTF_NUMBER_TABLE
672: , p7_a1 JTF_NUMBER_TABLE
673: , p7_a2 JTF_NUMBER_TABLE
674: , p7_a3 JTF_NUMBER_TABLE
675: , x_return_status out nocopy VARCHAR2
676: , x_msg_count out nocopy NUMBER
677: , x_msg_data out nocopy VARCHAR2

Line 674: , p7_a3 JTF_NUMBER_TABLE

670: , p_organization_id NUMBER
671: , p7_a0 JTF_NUMBER_TABLE
672: , p7_a1 JTF_NUMBER_TABLE
673: , p7_a2 JTF_NUMBER_TABLE
674: , p7_a3 JTF_NUMBER_TABLE
675: , x_return_status out nocopy VARCHAR2
676: , x_msg_count out nocopy NUMBER
677: , x_msg_data out nocopy VARCHAR2
678: )