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.JTF_DELIVERABLE_GRP_W dependencies on JTF_DELIVERABLE_GRP

Line 1: package body jtf_deliverable_grp_w as

1: package body jtf_deliverable_grp_w as
2: /* $Header: JTFGRDLB.pls 115.8 2004/07/09 18:50:36 applrt ship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:

Line 22: procedure rosetta_table_copy_in_p1(t out jtf_deliverable_grp.deliverable_tbl_type, a0 JTF_NUMBER_TABLE

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_p1(t out jtf_deliverable_grp.deliverable_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100

Line 57: procedure rosetta_table_copy_out_p1(t jtf_deliverable_grp.deliverable_tbl_type, a0 out JTF_NUMBER_TABLE

53: end loop;
54: end if;
55: end if;
56: end rosetta_table_copy_in_p1;
57: procedure rosetta_table_copy_out_p1(t jtf_deliverable_grp.deliverable_tbl_type, a0 out JTF_NUMBER_TABLE
58: , a1 out JTF_VARCHAR2_TABLE_100
59: , a2 out JTF_VARCHAR2_TABLE_300
60: , a3 out JTF_VARCHAR2_TABLE_100
61: , a4 out JTF_VARCHAR2_TABLE_100

Line 121: procedure rosetta_table_copy_in_p3(t out jtf_deliverable_grp.dlv_ath_tbl_type, a0 JTF_NUMBER_TABLE

117: end if;
118: end if;
119: end rosetta_table_copy_out_p1;
120:
121: procedure rosetta_table_copy_in_p3(t out jtf_deliverable_grp.dlv_ath_tbl_type, a0 JTF_NUMBER_TABLE
122: , a1 JTF_VARCHAR2_TABLE_100
123: , a2 JTF_VARCHAR2_TABLE_300
124: , a3 JTF_VARCHAR2_TABLE_100
125: , a4 JTF_VARCHAR2_TABLE_100

Line 162: procedure rosetta_table_copy_out_p3(t jtf_deliverable_grp.dlv_ath_tbl_type, a0 out JTF_NUMBER_TABLE

158: end loop;
159: end if;
160: end if;
161: end rosetta_table_copy_in_p3;
162: procedure rosetta_table_copy_out_p3(t jtf_deliverable_grp.dlv_ath_tbl_type, a0 out JTF_NUMBER_TABLE
163: , a1 out JTF_VARCHAR2_TABLE_100
164: , a2 out JTF_VARCHAR2_TABLE_300
165: , a3 out JTF_VARCHAR2_TABLE_100
166: , a4 out JTF_VARCHAR2_TABLE_100

Line 241: procedure rosetta_table_copy_in_p5(t out jtf_deliverable_grp.dlv_id_ver_tbl_type, a0 JTF_NUMBER_TABLE

237: end if;
238: end if;
239: end rosetta_table_copy_out_p3;
240:
241: procedure rosetta_table_copy_in_p5(t out jtf_deliverable_grp.dlv_id_ver_tbl_type, a0 JTF_NUMBER_TABLE
242: , a1 JTF_VARCHAR2_TABLE_300
243: , a2 JTF_NUMBER_TABLE
244: , a3 JTF_VARCHAR2_TABLE_100
245: ) as

Line 266: procedure rosetta_table_copy_out_p5(t jtf_deliverable_grp.dlv_id_ver_tbl_type, a0 out JTF_NUMBER_TABLE

262: end loop;
263: end if;
264: end if;
265: end rosetta_table_copy_in_p5;
266: procedure rosetta_table_copy_out_p5(t jtf_deliverable_grp.dlv_id_ver_tbl_type, a0 out JTF_NUMBER_TABLE
267: , a1 out JTF_VARCHAR2_TABLE_300
268: , a2 out JTF_NUMBER_TABLE
269: , a3 out JTF_VARCHAR2_TABLE_100
270: ) as

Line 305: procedure rosetta_table_copy_in_p6(t out jtf_deliverable_grp.number_table, a0 JTF_NUMBER_TABLE) as

301: end if;
302: end if;
303: end rosetta_table_copy_out_p5;
304:
305: procedure rosetta_table_copy_in_p6(t out jtf_deliverable_grp.number_table, a0 JTF_NUMBER_TABLE) as
306: ddindx binary_integer; indx binary_integer;
307: begin
308: if a0 is null then
309: t := null;

Line 311: t := jtf_deliverable_grp.number_table();

307: begin
308: if a0 is null then
309: t := null;
310: elsif a0.count = 0 then
311: t := jtf_deliverable_grp.number_table();
312: else
313: if a0.count > 0 then
314: t := jtf_deliverable_grp.number_table();
315: t.extend(a0.count);

Line 314: t := jtf_deliverable_grp.number_table();

310: elsif a0.count = 0 then
311: t := jtf_deliverable_grp.number_table();
312: else
313: if a0.count > 0 then
314: t := jtf_deliverable_grp.number_table();
315: t.extend(a0.count);
316: indx := a0.first;
317: ddindx := 1;
318: while true loop

Line 329: procedure rosetta_table_copy_out_p6(t jtf_deliverable_grp.number_table, a0 out JTF_NUMBER_TABLE) as

325: end loop;
326: end if;
327: end if;
328: end rosetta_table_copy_in_p6;
329: procedure rosetta_table_copy_out_p6(t jtf_deliverable_grp.number_table, a0 out JTF_NUMBER_TABLE) as
330: ddindx binary_integer; indx binary_integer;
331: begin
332: if t is null then
333: a0 := null;

Line 354: procedure rosetta_table_copy_in_p7(t out jtf_deliverable_grp.varchar2_table_100, a0 JTF_VARCHAR2_TABLE_100) as

350: end if;
351: end if;
352: end rosetta_table_copy_out_p6;
353:
354: procedure rosetta_table_copy_in_p7(t out jtf_deliverable_grp.varchar2_table_100, a0 JTF_VARCHAR2_TABLE_100) as
355: ddindx binary_integer; indx binary_integer;
356: begin
357: if a0 is null then
358: t := null;

Line 360: t := jtf_deliverable_grp.varchar2_table_100();

356: begin
357: if a0 is null then
358: t := null;
359: elsif a0.count = 0 then
360: t := jtf_deliverable_grp.varchar2_table_100();
361: else
362: if a0.count > 0 then
363: t := jtf_deliverable_grp.varchar2_table_100();
364: t.extend(a0.count);

Line 363: t := jtf_deliverable_grp.varchar2_table_100();

359: elsif a0.count = 0 then
360: t := jtf_deliverable_grp.varchar2_table_100();
361: else
362: if a0.count > 0 then
363: t := jtf_deliverable_grp.varchar2_table_100();
364: t.extend(a0.count);
365: indx := a0.first;
366: ddindx := 1;
367: while true loop

Line 378: procedure rosetta_table_copy_out_p7(t jtf_deliverable_grp.varchar2_table_100, a0 out JTF_VARCHAR2_TABLE_100) as

374: end loop;
375: end if;
376: end if;
377: end rosetta_table_copy_in_p7;
378: procedure rosetta_table_copy_out_p7(t jtf_deliverable_grp.varchar2_table_100, a0 out JTF_VARCHAR2_TABLE_100) as
379: ddindx binary_integer; indx binary_integer;
380: begin
381: if t is null then
382: a0 := null;

Line 403: procedure rosetta_table_copy_in_p8(t out jtf_deliverable_grp.varchar2_table_300, a0 JTF_VARCHAR2_TABLE_300) as

399: end if;
400: end if;
401: end rosetta_table_copy_out_p7;
402:
403: procedure rosetta_table_copy_in_p8(t out jtf_deliverable_grp.varchar2_table_300, a0 JTF_VARCHAR2_TABLE_300) as
404: ddindx binary_integer; indx binary_integer;
405: begin
406: if a0 is null then
407: t := null;

Line 409: t := jtf_deliverable_grp.varchar2_table_300();

405: begin
406: if a0 is null then
407: t := null;
408: elsif a0.count = 0 then
409: t := jtf_deliverable_grp.varchar2_table_300();
410: else
411: if a0.count > 0 then
412: t := jtf_deliverable_grp.varchar2_table_300();
413: t.extend(a0.count);

Line 412: t := jtf_deliverable_grp.varchar2_table_300();

408: elsif a0.count = 0 then
409: t := jtf_deliverable_grp.varchar2_table_300();
410: else
411: if a0.count > 0 then
412: t := jtf_deliverable_grp.varchar2_table_300();
413: t.extend(a0.count);
414: indx := a0.first;
415: ddindx := 1;
416: while true loop

Line 427: procedure rosetta_table_copy_out_p8(t jtf_deliverable_grp.varchar2_table_300, a0 out JTF_VARCHAR2_TABLE_300) as

423: end loop;
424: end if;
425: end if;
426: end rosetta_table_copy_in_p8;
427: procedure rosetta_table_copy_out_p8(t jtf_deliverable_grp.varchar2_table_300, a0 out JTF_VARCHAR2_TABLE_300) as
428: ddindx binary_integer; indx binary_integer;
429: begin
430: if t is null then
431: a0 := null;

Line 452: procedure rosetta_table_copy_in_p9(t out jtf_deliverable_grp.varchar2_table_2000, a0 JTF_VARCHAR2_TABLE_2000) as

448: end if;
449: end if;
450: end rosetta_table_copy_out_p8;
451:
452: procedure rosetta_table_copy_in_p9(t out jtf_deliverable_grp.varchar2_table_2000, a0 JTF_VARCHAR2_TABLE_2000) as
453: ddindx binary_integer; indx binary_integer;
454: begin
455: if a0 is null then
456: t := null;

Line 458: t := jtf_deliverable_grp.varchar2_table_2000();

454: begin
455: if a0 is null then
456: t := null;
457: elsif a0.count = 0 then
458: t := jtf_deliverable_grp.varchar2_table_2000();
459: else
460: if a0.count > 0 then
461: t := jtf_deliverable_grp.varchar2_table_2000();
462: t.extend(a0.count);

Line 461: t := jtf_deliverable_grp.varchar2_table_2000();

457: elsif a0.count = 0 then
458: t := jtf_deliverable_grp.varchar2_table_2000();
459: else
460: if a0.count > 0 then
461: t := jtf_deliverable_grp.varchar2_table_2000();
462: t.extend(a0.count);
463: indx := a0.first;
464: ddindx := 1;
465: while true loop

Line 476: procedure rosetta_table_copy_out_p9(t jtf_deliverable_grp.varchar2_table_2000, a0 out JTF_VARCHAR2_TABLE_2000) as

472: end loop;
473: end if;
474: end if;
475: end rosetta_table_copy_in_p9;
476: procedure rosetta_table_copy_out_p9(t jtf_deliverable_grp.varchar2_table_2000, a0 out JTF_VARCHAR2_TABLE_2000) as
477: ddindx binary_integer; indx binary_integer;
478: begin
479: if t is null then
480: a0 := null;

Line 525: ddx_dlv_id_tbl jtf_deliverable_grp.number_table;

521: , x_file_name_tbl out JTF_VARCHAR2_TABLE_300
522: , x_file_id_tbl out JTF_NUMBER_TABLE
523: )
524: as
525: ddx_dlv_id_tbl jtf_deliverable_grp.number_table;
526: ddx_acc_name_tbl jtf_deliverable_grp.varchar2_table_100;
527: ddx_dsp_name_tbl jtf_deliverable_grp.varchar2_table_300;
528: ddx_item_type_tbl jtf_deliverable_grp.varchar2_table_100;
529: ddx_appl_to_tbl jtf_deliverable_grp.varchar2_table_100;

Line 526: ddx_acc_name_tbl jtf_deliverable_grp.varchar2_table_100;

522: , x_file_id_tbl out JTF_NUMBER_TABLE
523: )
524: as
525: ddx_dlv_id_tbl jtf_deliverable_grp.number_table;
526: ddx_acc_name_tbl jtf_deliverable_grp.varchar2_table_100;
527: ddx_dsp_name_tbl jtf_deliverable_grp.varchar2_table_300;
528: ddx_item_type_tbl jtf_deliverable_grp.varchar2_table_100;
529: ddx_appl_to_tbl jtf_deliverable_grp.varchar2_table_100;
530: ddx_keyword_tbl jtf_deliverable_grp.varchar2_table_300;

Line 527: ddx_dsp_name_tbl jtf_deliverable_grp.varchar2_table_300;

523: )
524: as
525: ddx_dlv_id_tbl jtf_deliverable_grp.number_table;
526: ddx_acc_name_tbl jtf_deliverable_grp.varchar2_table_100;
527: ddx_dsp_name_tbl jtf_deliverable_grp.varchar2_table_300;
528: ddx_item_type_tbl jtf_deliverable_grp.varchar2_table_100;
529: ddx_appl_to_tbl jtf_deliverable_grp.varchar2_table_100;
530: ddx_keyword_tbl jtf_deliverable_grp.varchar2_table_300;
531: ddx_desc_tbl jtf_deliverable_grp.varchar2_table_2000;

Line 528: ddx_item_type_tbl jtf_deliverable_grp.varchar2_table_100;

524: as
525: ddx_dlv_id_tbl jtf_deliverable_grp.number_table;
526: ddx_acc_name_tbl jtf_deliverable_grp.varchar2_table_100;
527: ddx_dsp_name_tbl jtf_deliverable_grp.varchar2_table_300;
528: ddx_item_type_tbl jtf_deliverable_grp.varchar2_table_100;
529: ddx_appl_to_tbl jtf_deliverable_grp.varchar2_table_100;
530: ddx_keyword_tbl jtf_deliverable_grp.varchar2_table_300;
531: ddx_desc_tbl jtf_deliverable_grp.varchar2_table_2000;
532: ddx_version_tbl jtf_deliverable_grp.number_table;

Line 529: ddx_appl_to_tbl jtf_deliverable_grp.varchar2_table_100;

525: ddx_dlv_id_tbl jtf_deliverable_grp.number_table;
526: ddx_acc_name_tbl jtf_deliverable_grp.varchar2_table_100;
527: ddx_dsp_name_tbl jtf_deliverable_grp.varchar2_table_300;
528: ddx_item_type_tbl jtf_deliverable_grp.varchar2_table_100;
529: ddx_appl_to_tbl jtf_deliverable_grp.varchar2_table_100;
530: ddx_keyword_tbl jtf_deliverable_grp.varchar2_table_300;
531: ddx_desc_tbl jtf_deliverable_grp.varchar2_table_2000;
532: ddx_version_tbl jtf_deliverable_grp.number_table;
533: ddx_file_name_tbl jtf_deliverable_grp.varchar2_table_300;

Line 530: ddx_keyword_tbl jtf_deliverable_grp.varchar2_table_300;

526: ddx_acc_name_tbl jtf_deliverable_grp.varchar2_table_100;
527: ddx_dsp_name_tbl jtf_deliverable_grp.varchar2_table_300;
528: ddx_item_type_tbl jtf_deliverable_grp.varchar2_table_100;
529: ddx_appl_to_tbl jtf_deliverable_grp.varchar2_table_100;
530: ddx_keyword_tbl jtf_deliverable_grp.varchar2_table_300;
531: ddx_desc_tbl jtf_deliverable_grp.varchar2_table_2000;
532: ddx_version_tbl jtf_deliverable_grp.number_table;
533: ddx_file_name_tbl jtf_deliverable_grp.varchar2_table_300;
534: ddx_file_id_tbl jtf_deliverable_grp.number_table;

Line 531: ddx_desc_tbl jtf_deliverable_grp.varchar2_table_2000;

527: ddx_dsp_name_tbl jtf_deliverable_grp.varchar2_table_300;
528: ddx_item_type_tbl jtf_deliverable_grp.varchar2_table_100;
529: ddx_appl_to_tbl jtf_deliverable_grp.varchar2_table_100;
530: ddx_keyword_tbl jtf_deliverable_grp.varchar2_table_300;
531: ddx_desc_tbl jtf_deliverable_grp.varchar2_table_2000;
532: ddx_version_tbl jtf_deliverable_grp.number_table;
533: ddx_file_name_tbl jtf_deliverable_grp.varchar2_table_300;
534: ddx_file_id_tbl jtf_deliverable_grp.number_table;
535: ddindx binary_integer; indx binary_integer;

Line 532: ddx_version_tbl jtf_deliverable_grp.number_table;

528: ddx_item_type_tbl jtf_deliverable_grp.varchar2_table_100;
529: ddx_appl_to_tbl jtf_deliverable_grp.varchar2_table_100;
530: ddx_keyword_tbl jtf_deliverable_grp.varchar2_table_300;
531: ddx_desc_tbl jtf_deliverable_grp.varchar2_table_2000;
532: ddx_version_tbl jtf_deliverable_grp.number_table;
533: ddx_file_name_tbl jtf_deliverable_grp.varchar2_table_300;
534: ddx_file_id_tbl jtf_deliverable_grp.number_table;
535: ddindx binary_integer; indx binary_integer;
536: begin

Line 533: ddx_file_name_tbl jtf_deliverable_grp.varchar2_table_300;

529: ddx_appl_to_tbl jtf_deliverable_grp.varchar2_table_100;
530: ddx_keyword_tbl jtf_deliverable_grp.varchar2_table_300;
531: ddx_desc_tbl jtf_deliverable_grp.varchar2_table_2000;
532: ddx_version_tbl jtf_deliverable_grp.number_table;
533: ddx_file_name_tbl jtf_deliverable_grp.varchar2_table_300;
534: ddx_file_id_tbl jtf_deliverable_grp.number_table;
535: ddindx binary_integer; indx binary_integer;
536: begin
537:

Line 534: ddx_file_id_tbl jtf_deliverable_grp.number_table;

530: ddx_keyword_tbl jtf_deliverable_grp.varchar2_table_300;
531: ddx_desc_tbl jtf_deliverable_grp.varchar2_table_2000;
532: ddx_version_tbl jtf_deliverable_grp.number_table;
533: ddx_file_name_tbl jtf_deliverable_grp.varchar2_table_300;
534: ddx_file_id_tbl jtf_deliverable_grp.number_table;
535: ddindx binary_integer; indx binary_integer;
536: begin
537:
538: -- copy data to the local IN or IN-OUT args, if any

Line 562: jtf_deliverable_grp.list_deliverable(p_api_version,

558:
559:
560:
561: -- here's the delegated call to the old PL/SQL routine
562: jtf_deliverable_grp.list_deliverable(p_api_version,
563: p_init_msg_list,
564: x_return_status,
565: x_msg_count,
566: x_msg_data,

Line 598: jtf_deliverable_grp_w.rosetta_table_copy_out_p6(ddx_dlv_id_tbl, x_dlv_id_tbl);

594:
595:
596:
597:
598: jtf_deliverable_grp_w.rosetta_table_copy_out_p6(ddx_dlv_id_tbl, x_dlv_id_tbl);
599:
600: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_acc_name_tbl, x_acc_name_tbl);
601:
602: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_dsp_name_tbl, x_dsp_name_tbl);

Line 600: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_acc_name_tbl, x_acc_name_tbl);

596:
597:
598: jtf_deliverable_grp_w.rosetta_table_copy_out_p6(ddx_dlv_id_tbl, x_dlv_id_tbl);
599:
600: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_acc_name_tbl, x_acc_name_tbl);
601:
602: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_dsp_name_tbl, x_dsp_name_tbl);
603:
604: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_item_type_tbl, x_item_type_tbl);

Line 602: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_dsp_name_tbl, x_dsp_name_tbl);

598: jtf_deliverable_grp_w.rosetta_table_copy_out_p6(ddx_dlv_id_tbl, x_dlv_id_tbl);
599:
600: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_acc_name_tbl, x_acc_name_tbl);
601:
602: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_dsp_name_tbl, x_dsp_name_tbl);
603:
604: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_item_type_tbl, x_item_type_tbl);
605:
606: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_appl_to_tbl, x_appl_to_tbl);

Line 604: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_item_type_tbl, x_item_type_tbl);

600: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_acc_name_tbl, x_acc_name_tbl);
601:
602: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_dsp_name_tbl, x_dsp_name_tbl);
603:
604: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_item_type_tbl, x_item_type_tbl);
605:
606: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_appl_to_tbl, x_appl_to_tbl);
607:
608: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_keyword_tbl, x_keyword_tbl);

Line 606: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_appl_to_tbl, x_appl_to_tbl);

602: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_dsp_name_tbl, x_dsp_name_tbl);
603:
604: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_item_type_tbl, x_item_type_tbl);
605:
606: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_appl_to_tbl, x_appl_to_tbl);
607:
608: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_keyword_tbl, x_keyword_tbl);
609:
610: jtf_deliverable_grp_w.rosetta_table_copy_out_p9(ddx_desc_tbl, x_desc_tbl);

Line 608: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_keyword_tbl, x_keyword_tbl);

604: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_item_type_tbl, x_item_type_tbl);
605:
606: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_appl_to_tbl, x_appl_to_tbl);
607:
608: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_keyword_tbl, x_keyword_tbl);
609:
610: jtf_deliverable_grp_w.rosetta_table_copy_out_p9(ddx_desc_tbl, x_desc_tbl);
611:
612: jtf_deliverable_grp_w.rosetta_table_copy_out_p6(ddx_version_tbl, x_version_tbl);

Line 610: jtf_deliverable_grp_w.rosetta_table_copy_out_p9(ddx_desc_tbl, x_desc_tbl);

606: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_appl_to_tbl, x_appl_to_tbl);
607:
608: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_keyword_tbl, x_keyword_tbl);
609:
610: jtf_deliverable_grp_w.rosetta_table_copy_out_p9(ddx_desc_tbl, x_desc_tbl);
611:
612: jtf_deliverable_grp_w.rosetta_table_copy_out_p6(ddx_version_tbl, x_version_tbl);
613:
614: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_file_name_tbl, x_file_name_tbl);

Line 612: jtf_deliverable_grp_w.rosetta_table_copy_out_p6(ddx_version_tbl, x_version_tbl);

608: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_keyword_tbl, x_keyword_tbl);
609:
610: jtf_deliverable_grp_w.rosetta_table_copy_out_p9(ddx_desc_tbl, x_desc_tbl);
611:
612: jtf_deliverable_grp_w.rosetta_table_copy_out_p6(ddx_version_tbl, x_version_tbl);
613:
614: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_file_name_tbl, x_file_name_tbl);
615:
616: jtf_deliverable_grp_w.rosetta_table_copy_out_p6(ddx_file_id_tbl, x_file_id_tbl);

Line 614: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_file_name_tbl, x_file_name_tbl);

610: jtf_deliverable_grp_w.rosetta_table_copy_out_p9(ddx_desc_tbl, x_desc_tbl);
611:
612: jtf_deliverable_grp_w.rosetta_table_copy_out_p6(ddx_version_tbl, x_version_tbl);
613:
614: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_file_name_tbl, x_file_name_tbl);
615:
616: jtf_deliverable_grp_w.rosetta_table_copy_out_p6(ddx_file_id_tbl, x_file_id_tbl);
617: end;
618:

Line 616: jtf_deliverable_grp_w.rosetta_table_copy_out_p6(ddx_file_id_tbl, x_file_id_tbl);

612: jtf_deliverable_grp_w.rosetta_table_copy_out_p6(ddx_version_tbl, x_version_tbl);
613:
614: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_file_name_tbl, x_file_name_tbl);
615:
616: jtf_deliverable_grp_w.rosetta_table_copy_out_p6(ddx_file_id_tbl, x_file_id_tbl);
617: end;
618:
619: procedure list_deliverable(p_api_version NUMBER
620: , p_init_msg_list VARCHAR2

Line 644: ddx_dlv_id_tbl jtf_deliverable_grp.number_table;

640: , x_file_name_tbl out JTF_VARCHAR2_TABLE_300
641: , x_file_id_tbl out JTF_NUMBER_TABLE
642: )
643: as
644: ddx_dlv_id_tbl jtf_deliverable_grp.number_table;
645: ddx_acc_name_tbl jtf_deliverable_grp.varchar2_table_100;
646: ddx_dsp_name_tbl jtf_deliverable_grp.varchar2_table_300;
647: ddx_item_type_tbl jtf_deliverable_grp.varchar2_table_100;
648: ddx_appl_to_tbl jtf_deliverable_grp.varchar2_table_100;

Line 645: ddx_acc_name_tbl jtf_deliverable_grp.varchar2_table_100;

641: , x_file_id_tbl out JTF_NUMBER_TABLE
642: )
643: as
644: ddx_dlv_id_tbl jtf_deliverable_grp.number_table;
645: ddx_acc_name_tbl jtf_deliverable_grp.varchar2_table_100;
646: ddx_dsp_name_tbl jtf_deliverable_grp.varchar2_table_300;
647: ddx_item_type_tbl jtf_deliverable_grp.varchar2_table_100;
648: ddx_appl_to_tbl jtf_deliverable_grp.varchar2_table_100;
649: ddx_keyword_tbl jtf_deliverable_grp.varchar2_table_300;

Line 646: ddx_dsp_name_tbl jtf_deliverable_grp.varchar2_table_300;

642: )
643: as
644: ddx_dlv_id_tbl jtf_deliverable_grp.number_table;
645: ddx_acc_name_tbl jtf_deliverable_grp.varchar2_table_100;
646: ddx_dsp_name_tbl jtf_deliverable_grp.varchar2_table_300;
647: ddx_item_type_tbl jtf_deliverable_grp.varchar2_table_100;
648: ddx_appl_to_tbl jtf_deliverable_grp.varchar2_table_100;
649: ddx_keyword_tbl jtf_deliverable_grp.varchar2_table_300;
650: ddx_desc_tbl jtf_deliverable_grp.varchar2_table_2000;

Line 647: ddx_item_type_tbl jtf_deliverable_grp.varchar2_table_100;

643: as
644: ddx_dlv_id_tbl jtf_deliverable_grp.number_table;
645: ddx_acc_name_tbl jtf_deliverable_grp.varchar2_table_100;
646: ddx_dsp_name_tbl jtf_deliverable_grp.varchar2_table_300;
647: ddx_item_type_tbl jtf_deliverable_grp.varchar2_table_100;
648: ddx_appl_to_tbl jtf_deliverable_grp.varchar2_table_100;
649: ddx_keyword_tbl jtf_deliverable_grp.varchar2_table_300;
650: ddx_desc_tbl jtf_deliverable_grp.varchar2_table_2000;
651: ddx_version_tbl jtf_deliverable_grp.number_table;

Line 648: ddx_appl_to_tbl jtf_deliverable_grp.varchar2_table_100;

644: ddx_dlv_id_tbl jtf_deliverable_grp.number_table;
645: ddx_acc_name_tbl jtf_deliverable_grp.varchar2_table_100;
646: ddx_dsp_name_tbl jtf_deliverable_grp.varchar2_table_300;
647: ddx_item_type_tbl jtf_deliverable_grp.varchar2_table_100;
648: ddx_appl_to_tbl jtf_deliverable_grp.varchar2_table_100;
649: ddx_keyword_tbl jtf_deliverable_grp.varchar2_table_300;
650: ddx_desc_tbl jtf_deliverable_grp.varchar2_table_2000;
651: ddx_version_tbl jtf_deliverable_grp.number_table;
652: ddx_file_name_tbl jtf_deliverable_grp.varchar2_table_300;

Line 649: ddx_keyword_tbl jtf_deliverable_grp.varchar2_table_300;

645: ddx_acc_name_tbl jtf_deliverable_grp.varchar2_table_100;
646: ddx_dsp_name_tbl jtf_deliverable_grp.varchar2_table_300;
647: ddx_item_type_tbl jtf_deliverable_grp.varchar2_table_100;
648: ddx_appl_to_tbl jtf_deliverable_grp.varchar2_table_100;
649: ddx_keyword_tbl jtf_deliverable_grp.varchar2_table_300;
650: ddx_desc_tbl jtf_deliverable_grp.varchar2_table_2000;
651: ddx_version_tbl jtf_deliverable_grp.number_table;
652: ddx_file_name_tbl jtf_deliverable_grp.varchar2_table_300;
653: ddx_file_id_tbl jtf_deliverable_grp.number_table;

Line 650: ddx_desc_tbl jtf_deliverable_grp.varchar2_table_2000;

646: ddx_dsp_name_tbl jtf_deliverable_grp.varchar2_table_300;
647: ddx_item_type_tbl jtf_deliverable_grp.varchar2_table_100;
648: ddx_appl_to_tbl jtf_deliverable_grp.varchar2_table_100;
649: ddx_keyword_tbl jtf_deliverable_grp.varchar2_table_300;
650: ddx_desc_tbl jtf_deliverable_grp.varchar2_table_2000;
651: ddx_version_tbl jtf_deliverable_grp.number_table;
652: ddx_file_name_tbl jtf_deliverable_grp.varchar2_table_300;
653: ddx_file_id_tbl jtf_deliverable_grp.number_table;
654: ddindx binary_integer; indx binary_integer;

Line 651: ddx_version_tbl jtf_deliverable_grp.number_table;

647: ddx_item_type_tbl jtf_deliverable_grp.varchar2_table_100;
648: ddx_appl_to_tbl jtf_deliverable_grp.varchar2_table_100;
649: ddx_keyword_tbl jtf_deliverable_grp.varchar2_table_300;
650: ddx_desc_tbl jtf_deliverable_grp.varchar2_table_2000;
651: ddx_version_tbl jtf_deliverable_grp.number_table;
652: ddx_file_name_tbl jtf_deliverable_grp.varchar2_table_300;
653: ddx_file_id_tbl jtf_deliverable_grp.number_table;
654: ddindx binary_integer; indx binary_integer;
655: begin

Line 652: ddx_file_name_tbl jtf_deliverable_grp.varchar2_table_300;

648: ddx_appl_to_tbl jtf_deliverable_grp.varchar2_table_100;
649: ddx_keyword_tbl jtf_deliverable_grp.varchar2_table_300;
650: ddx_desc_tbl jtf_deliverable_grp.varchar2_table_2000;
651: ddx_version_tbl jtf_deliverable_grp.number_table;
652: ddx_file_name_tbl jtf_deliverable_grp.varchar2_table_300;
653: ddx_file_id_tbl jtf_deliverable_grp.number_table;
654: ddindx binary_integer; indx binary_integer;
655: begin
656:

Line 653: ddx_file_id_tbl jtf_deliverable_grp.number_table;

649: ddx_keyword_tbl jtf_deliverable_grp.varchar2_table_300;
650: ddx_desc_tbl jtf_deliverable_grp.varchar2_table_2000;
651: ddx_version_tbl jtf_deliverable_grp.number_table;
652: ddx_file_name_tbl jtf_deliverable_grp.varchar2_table_300;
653: ddx_file_id_tbl jtf_deliverable_grp.number_table;
654: ddindx binary_integer; indx binary_integer;
655: begin
656:
657: -- copy data to the local IN or IN-OUT args, if any

Line 682: jtf_deliverable_grp.list_deliverable(p_api_version,

678:
679:
680:
681: -- here's the delegated call to the old PL/SQL routine
682: jtf_deliverable_grp.list_deliverable(p_api_version,
683: p_init_msg_list,
684: x_return_status,
685: x_msg_count,
686: x_msg_data,

Line 720: jtf_deliverable_grp_w.rosetta_table_copy_out_p6(ddx_dlv_id_tbl, x_dlv_id_tbl);

716:
717:
718:
719:
720: jtf_deliverable_grp_w.rosetta_table_copy_out_p6(ddx_dlv_id_tbl, x_dlv_id_tbl);
721:
722: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_acc_name_tbl, x_acc_name_tbl);
723:
724: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_dsp_name_tbl, x_dsp_name_tbl);

Line 722: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_acc_name_tbl, x_acc_name_tbl);

718:
719:
720: jtf_deliverable_grp_w.rosetta_table_copy_out_p6(ddx_dlv_id_tbl, x_dlv_id_tbl);
721:
722: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_acc_name_tbl, x_acc_name_tbl);
723:
724: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_dsp_name_tbl, x_dsp_name_tbl);
725:
726: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_item_type_tbl, x_item_type_tbl);

Line 724: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_dsp_name_tbl, x_dsp_name_tbl);

720: jtf_deliverable_grp_w.rosetta_table_copy_out_p6(ddx_dlv_id_tbl, x_dlv_id_tbl);
721:
722: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_acc_name_tbl, x_acc_name_tbl);
723:
724: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_dsp_name_tbl, x_dsp_name_tbl);
725:
726: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_item_type_tbl, x_item_type_tbl);
727:
728: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_appl_to_tbl, x_appl_to_tbl);

Line 726: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_item_type_tbl, x_item_type_tbl);

722: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_acc_name_tbl, x_acc_name_tbl);
723:
724: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_dsp_name_tbl, x_dsp_name_tbl);
725:
726: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_item_type_tbl, x_item_type_tbl);
727:
728: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_appl_to_tbl, x_appl_to_tbl);
729:
730: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_keyword_tbl, x_keyword_tbl);

Line 728: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_appl_to_tbl, x_appl_to_tbl);

724: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_dsp_name_tbl, x_dsp_name_tbl);
725:
726: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_item_type_tbl, x_item_type_tbl);
727:
728: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_appl_to_tbl, x_appl_to_tbl);
729:
730: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_keyword_tbl, x_keyword_tbl);
731:
732: jtf_deliverable_grp_w.rosetta_table_copy_out_p9(ddx_desc_tbl, x_desc_tbl);

Line 730: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_keyword_tbl, x_keyword_tbl);

726: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_item_type_tbl, x_item_type_tbl);
727:
728: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_appl_to_tbl, x_appl_to_tbl);
729:
730: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_keyword_tbl, x_keyword_tbl);
731:
732: jtf_deliverable_grp_w.rosetta_table_copy_out_p9(ddx_desc_tbl, x_desc_tbl);
733:
734: jtf_deliverable_grp_w.rosetta_table_copy_out_p6(ddx_version_tbl, x_version_tbl);

Line 732: jtf_deliverable_grp_w.rosetta_table_copy_out_p9(ddx_desc_tbl, x_desc_tbl);

728: jtf_deliverable_grp_w.rosetta_table_copy_out_p7(ddx_appl_to_tbl, x_appl_to_tbl);
729:
730: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_keyword_tbl, x_keyword_tbl);
731:
732: jtf_deliverable_grp_w.rosetta_table_copy_out_p9(ddx_desc_tbl, x_desc_tbl);
733:
734: jtf_deliverable_grp_w.rosetta_table_copy_out_p6(ddx_version_tbl, x_version_tbl);
735:
736: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_file_name_tbl, x_file_name_tbl);

Line 734: jtf_deliverable_grp_w.rosetta_table_copy_out_p6(ddx_version_tbl, x_version_tbl);

730: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_keyword_tbl, x_keyword_tbl);
731:
732: jtf_deliverable_grp_w.rosetta_table_copy_out_p9(ddx_desc_tbl, x_desc_tbl);
733:
734: jtf_deliverable_grp_w.rosetta_table_copy_out_p6(ddx_version_tbl, x_version_tbl);
735:
736: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_file_name_tbl, x_file_name_tbl);
737:
738: jtf_deliverable_grp_w.rosetta_table_copy_out_p6(ddx_file_id_tbl, x_file_id_tbl);

Line 736: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_file_name_tbl, x_file_name_tbl);

732: jtf_deliverable_grp_w.rosetta_table_copy_out_p9(ddx_desc_tbl, x_desc_tbl);
733:
734: jtf_deliverable_grp_w.rosetta_table_copy_out_p6(ddx_version_tbl, x_version_tbl);
735:
736: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_file_name_tbl, x_file_name_tbl);
737:
738: jtf_deliverable_grp_w.rosetta_table_copy_out_p6(ddx_file_id_tbl, x_file_id_tbl);
739: end;
740:

Line 738: jtf_deliverable_grp_w.rosetta_table_copy_out_p6(ddx_file_id_tbl, x_file_id_tbl);

734: jtf_deliverable_grp_w.rosetta_table_copy_out_p6(ddx_version_tbl, x_version_tbl);
735:
736: jtf_deliverable_grp_w.rosetta_table_copy_out_p8(ddx_file_name_tbl, x_file_name_tbl);
737:
738: jtf_deliverable_grp_w.rosetta_table_copy_out_p6(ddx_file_id_tbl, x_file_id_tbl);
739: end;
740:
741: procedure save_deliverable(p_api_version NUMBER
742: , p_init_msg_list VARCHAR2

Line 758: ddp_deliverable_rec jtf_deliverable_grp.deliverable_rec_type;

754: , p6_a7 in out NUMBER
755: , p6_a8 in out VARCHAR2
756: )
757: as
758: ddp_deliverable_rec jtf_deliverable_grp.deliverable_rec_type;
759: ddindx binary_integer; indx binary_integer;
760: begin
761:
762: -- copy data to the local IN or IN-OUT args, if any

Line 780: jtf_deliverable_grp.save_deliverable(p_api_version,

776: ddp_deliverable_rec.object_version_number := rosetta_g_miss_num_map(p6_a7);
777: ddp_deliverable_rec.x_action_status := p6_a8;
778:
779: -- here's the delegated call to the old PL/SQL routine
780: jtf_deliverable_grp.save_deliverable(p_api_version,
781: p_init_msg_list,
782: p_commit,
783: x_return_status,
784: x_msg_count,

Line 823: ddp_deliverable_tbl jtf_deliverable_grp.deliverable_tbl_type;

819: , p6_a7 in out JTF_NUMBER_TABLE
820: , p6_a8 in out JTF_VARCHAR2_TABLE_100
821: )
822: as
823: ddp_deliverable_tbl jtf_deliverable_grp.deliverable_tbl_type;
824: ddindx binary_integer; indx binary_integer;
825: begin
826:
827: -- copy data to the local IN or IN-OUT args, if any

Line 834: jtf_deliverable_grp_w.rosetta_table_copy_in_p1(ddp_deliverable_tbl, p6_a0

830:
831:
832:
833:
834: jtf_deliverable_grp_w.rosetta_table_copy_in_p1(ddp_deliverable_tbl, p6_a0
835: , p6_a1
836: , p6_a2
837: , p6_a3
838: , p6_a4

Line 846: jtf_deliverable_grp.save_deliverable(p_api_version,

842: , p6_a8
843: );
844:
845: -- here's the delegated call to the old PL/SQL routine
846: jtf_deliverable_grp.save_deliverable(p_api_version,
847: p_init_msg_list,
848: p_commit,
849: x_return_status,
850: x_msg_count,

Line 861: jtf_deliverable_grp_w.rosetta_table_copy_out_p1(ddp_deliverable_tbl, p6_a0

857:
858:
859:
860:
861: jtf_deliverable_grp_w.rosetta_table_copy_out_p1(ddp_deliverable_tbl, p6_a0
862: , p6_a1
863: , p6_a2
864: , p6_a3
865: , p6_a4

Line 893: ddp_dlv_ath_rec jtf_deliverable_grp.dlv_ath_rec_type;

889: , p6_a10 in out NUMBER
890: , p6_a11 in out VARCHAR2
891: )
892: as
893: ddp_dlv_ath_rec jtf_deliverable_grp.dlv_ath_rec_type;
894: ddindx binary_integer; indx binary_integer;
895: begin
896:
897: -- copy data to the local IN or IN-OUT args, if any

Line 918: jtf_deliverable_grp.save_deliverable(p_api_version,

914: ddp_dlv_ath_rec.ath_file_id := rosetta_g_miss_num_map(p6_a10);
915: ddp_dlv_ath_rec.x_ath_action_status := p6_a11;
916:
917: -- here's the delegated call to the old PL/SQL routine
918: jtf_deliverable_grp.save_deliverable(p_api_version,
919: p_init_msg_list,
920: p_commit,
921: x_return_status,
922: x_msg_count,

Line 967: ddp_dlv_ath_tbl jtf_deliverable_grp.dlv_ath_tbl_type;

963: , p6_a10 in out JTF_NUMBER_TABLE
964: , p6_a11 in out JTF_VARCHAR2_TABLE_100
965: )
966: as
967: ddp_dlv_ath_tbl jtf_deliverable_grp.dlv_ath_tbl_type;
968: ddindx binary_integer; indx binary_integer;
969: begin
970:
971: -- copy data to the local IN or IN-OUT args, if any

Line 978: jtf_deliverable_grp_w.rosetta_table_copy_in_p3(ddp_dlv_ath_tbl, p6_a0

974:
975:
976:
977:
978: jtf_deliverable_grp_w.rosetta_table_copy_in_p3(ddp_dlv_ath_tbl, p6_a0
979: , p6_a1
980: , p6_a2
981: , p6_a3
982: , p6_a4

Line 993: jtf_deliverable_grp.save_deliverable(p_api_version,

989: , p6_a11
990: );
991:
992: -- here's the delegated call to the old PL/SQL routine
993: jtf_deliverable_grp.save_deliverable(p_api_version,
994: p_init_msg_list,
995: p_commit,
996: x_return_status,
997: x_msg_count,

Line 1008: jtf_deliverable_grp_w.rosetta_table_copy_out_p3(ddp_dlv_ath_tbl, p6_a0

1004:
1005:
1006:
1007:
1008: jtf_deliverable_grp_w.rosetta_table_copy_out_p3(ddp_dlv_ath_tbl, p6_a0
1009: , p6_a1
1010: , p6_a2
1011: , p6_a3
1012: , p6_a4

Line 1035: ddp_dlv_id_ver_tbl jtf_deliverable_grp.dlv_id_ver_tbl_type;

1031: , p6_a2 in out JTF_NUMBER_TABLE
1032: , p6_a3 in out JTF_VARCHAR2_TABLE_100
1033: )
1034: as
1035: ddp_dlv_id_ver_tbl jtf_deliverable_grp.dlv_id_ver_tbl_type;
1036: ddindx binary_integer; indx binary_integer;
1037: begin
1038:
1039: -- copy data to the local IN or IN-OUT args, if any

Line 1046: jtf_deliverable_grp_w.rosetta_table_copy_in_p5(ddp_dlv_id_ver_tbl, p6_a0

1042:
1043:
1044:
1045:
1046: jtf_deliverable_grp_w.rosetta_table_copy_in_p5(ddp_dlv_id_ver_tbl, p6_a0
1047: , p6_a1
1048: , p6_a2
1049: , p6_a3
1050: );

Line 1053: jtf_deliverable_grp.delete_deliverable(p_api_version,

1049: , p6_a3
1050: );
1051:
1052: -- here's the delegated call to the old PL/SQL routine
1053: jtf_deliverable_grp.delete_deliverable(p_api_version,
1054: p_init_msg_list,
1055: p_commit,
1056: x_return_status,
1057: x_msg_count,

Line 1068: jtf_deliverable_grp_w.rosetta_table_copy_out_p5(ddp_dlv_id_ver_tbl, p6_a0

1064:
1065:
1066:
1067:
1068: jtf_deliverable_grp_w.rosetta_table_copy_out_p5(ddp_dlv_id_ver_tbl, p6_a0
1069: , p6_a1
1070: , p6_a2
1071: , p6_a3
1072: );

Line 1075: end jtf_deliverable_grp_w;

1071: , p6_a3
1072: );
1073: end;
1074:
1075: end jtf_deliverable_grp_w;