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.AMV_CATEGORY_PVT_W dependencies on AMV_CATEGORY_PVT

Line 1: package body amv_category_pvt_w as

1: package body amv_category_pvt_w as
2: /* $Header: amvwcatb.pls 120.2 2005/06/30 07:45 appldev 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_p2(t out nocopy amv_category_pvt.amv_char_varray_type, a0 JTF_VARCHAR2_TABLE_4000) as

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy amv_category_pvt.amv_char_varray_type, a0 JTF_VARCHAR2_TABLE_4000) as
23: ddindx binary_integer; indx binary_integer;
24: begin
25: if a0 is null then
26: t := null;

Line 28: t := amv_category_pvt.amv_char_varray_type();

24: begin
25: if a0 is null then
26: t := null;
27: elsif a0.count = 0 then
28: t := amv_category_pvt.amv_char_varray_type();
29: else
30: if a0.count > 0 then
31: t := amv_category_pvt.amv_char_varray_type();
32: t.extend(a0.count);

Line 31: t := amv_category_pvt.amv_char_varray_type();

27: elsif a0.count = 0 then
28: t := amv_category_pvt.amv_char_varray_type();
29: else
30: if a0.count > 0 then
31: t := amv_category_pvt.amv_char_varray_type();
32: t.extend(a0.count);
33: indx := a0.first;
34: ddindx := 1;
35: while true loop

Line 46: procedure rosetta_table_copy_out_p2(t amv_category_pvt.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_4000) as

42: end loop;
43: end if;
44: end if;
45: end rosetta_table_copy_in_p2;
46: procedure rosetta_table_copy_out_p2(t amv_category_pvt.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_4000) as
47: ddindx binary_integer; indx binary_integer;
48: begin
49: if t is null then
50: a0 := null;

Line 71: procedure rosetta_table_copy_in_p3(t out nocopy amv_category_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE) as

67: end if;
68: end if;
69: end rosetta_table_copy_out_p2;
70:
71: procedure rosetta_table_copy_in_p3(t out nocopy amv_category_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE) as
72: ddindx binary_integer; indx binary_integer;
73: begin
74: if a0 is null then
75: t := null;

Line 77: t := amv_category_pvt.amv_number_varray_type();

73: begin
74: if a0 is null then
75: t := null;
76: elsif a0.count = 0 then
77: t := amv_category_pvt.amv_number_varray_type();
78: else
79: if a0.count > 0 then
80: t := amv_category_pvt.amv_number_varray_type();
81: t.extend(a0.count);

Line 80: t := amv_category_pvt.amv_number_varray_type();

76: elsif a0.count = 0 then
77: t := amv_category_pvt.amv_number_varray_type();
78: else
79: if a0.count > 0 then
80: t := amv_category_pvt.amv_number_varray_type();
81: t.extend(a0.count);
82: indx := a0.first;
83: ddindx := 1;
84: while true loop

Line 95: procedure rosetta_table_copy_out_p3(t amv_category_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE) as

91: end loop;
92: end if;
93: end if;
94: end rosetta_table_copy_in_p3;
95: procedure rosetta_table_copy_out_p3(t amv_category_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE) as
96: ddindx binary_integer; indx binary_integer;
97: begin
98: if t is null then
99: a0 := null;

Line 120: procedure rosetta_table_copy_in_p7(t out nocopy amv_category_pvt.amv_category_varray_type, a0 JTF_NUMBER_TABLE

116: end if;
117: end if;
118: end rosetta_table_copy_out_p3;
119:
120: procedure rosetta_table_copy_in_p7(t out nocopy amv_category_pvt.amv_category_varray_type, a0 JTF_NUMBER_TABLE
121: , a1 JTF_NUMBER_TABLE
122: , a2 JTF_NUMBER_TABLE
123: , a3 JTF_NUMBER_TABLE
124: , a4 JTF_NUMBER_TABLE

Line 132: t := amv_category_pvt.amv_category_varray_type();

128: ) as
129: ddindx binary_integer; indx binary_integer;
130: begin
131: if a0 is not null and a0.count=0 then
132: t := amv_category_pvt.amv_category_varray_type();
133: elsif a0 is not null and a0.count > 0 then
134: if a0.count > 0 then
135: t := amv_category_pvt.amv_category_varray_type();
136: t.extend(a0.count);

Line 135: t := amv_category_pvt.amv_category_varray_type();

131: if a0 is not null and a0.count=0 then
132: t := amv_category_pvt.amv_category_varray_type();
133: elsif a0 is not null and a0.count > 0 then
134: if a0.count > 0 then
135: t := amv_category_pvt.amv_category_varray_type();
136: t.extend(a0.count);
137: indx := a0.first;
138: ddindx := 1;
139: while true loop

Line 157: procedure rosetta_table_copy_out_p7(t amv_category_pvt.amv_category_varray_type, a0 out nocopy JTF_NUMBER_TABLE

153: end loop;
154: end if;
155: end if;
156: end rosetta_table_copy_in_p7;
157: procedure rosetta_table_copy_out_p7(t amv_category_pvt.amv_category_varray_type, a0 out nocopy JTF_NUMBER_TABLE
158: , a1 out nocopy JTF_NUMBER_TABLE
159: , a2 out nocopy JTF_NUMBER_TABLE
160: , a3 out nocopy JTF_NUMBER_TABLE
161: , a4 out nocopy JTF_NUMBER_TABLE

Line 225: procedure rosetta_table_copy_in_p10(t out nocopy amv_category_pvt.amv_cat_hierarchy_varray_type, a0 JTF_NUMBER_TABLE

221: end if;
222: end if;
223: end rosetta_table_copy_out_p7;
224:
225: procedure rosetta_table_copy_in_p10(t out nocopy amv_category_pvt.amv_cat_hierarchy_varray_type, a0 JTF_NUMBER_TABLE
226: , a1 JTF_NUMBER_TABLE
227: , a2 JTF_VARCHAR2_TABLE_300
228: ) as
229: ddindx binary_integer; indx binary_integer;

Line 232: t := amv_category_pvt.amv_cat_hierarchy_varray_type();

228: ) as
229: ddindx binary_integer; indx binary_integer;
230: begin
231: if a0 is not null and a0.count=0 then
232: t := amv_category_pvt.amv_cat_hierarchy_varray_type();
233: elsif a0 is not null and a0.count > 0 then
234: if a0.count > 0 then
235: t := amv_category_pvt.amv_cat_hierarchy_varray_type();
236: t.extend(a0.count);

Line 235: t := amv_category_pvt.amv_cat_hierarchy_varray_type();

231: if a0 is not null and a0.count=0 then
232: t := amv_category_pvt.amv_cat_hierarchy_varray_type();
233: elsif a0 is not null and a0.count > 0 then
234: if a0.count > 0 then
235: t := amv_category_pvt.amv_cat_hierarchy_varray_type();
236: t.extend(a0.count);
237: indx := a0.first;
238: ddindx := 1;
239: while true loop

Line 252: procedure rosetta_table_copy_out_p10(t amv_category_pvt.amv_cat_hierarchy_varray_type, a0 out nocopy JTF_NUMBER_TABLE

248: end loop;
249: end if;
250: end if;
251: end rosetta_table_copy_in_p10;
252: procedure rosetta_table_copy_out_p10(t amv_category_pvt.amv_cat_hierarchy_varray_type, a0 out nocopy JTF_NUMBER_TABLE
253: , a1 out nocopy JTF_NUMBER_TABLE
254: , a2 out nocopy JTF_VARCHAR2_TABLE_300
255: ) as
256: ddindx binary_integer; indx binary_integer;

Line 304: ddp_category_id_array amv_category_pvt.amv_number_varray_type;

300: , p_category_new_order JTF_NUMBER_TABLE
301: )
302:
303: as
304: ddp_category_id_array amv_category_pvt.amv_number_varray_type;
305: ddp_category_new_order amv_category_pvt.amv_number_varray_type;
306: ddindx binary_integer; indx binary_integer;
307: begin
308:

Line 305: ddp_category_new_order amv_category_pvt.amv_number_varray_type;

301: )
302:
303: as
304: ddp_category_id_array amv_category_pvt.amv_number_varray_type;
305: ddp_category_new_order amv_category_pvt.amv_number_varray_type;
306: ddindx binary_integer; indx binary_integer;
307: begin
308:
309: -- copy data to the local IN or IN-OUT args, if any

Line 319: amv_category_pvt_w.rosetta_table_copy_in_p3(ddp_category_id_array, p_category_id_array);

315:
316:
317:
318:
319: amv_category_pvt_w.rosetta_table_copy_in_p3(ddp_category_id_array, p_category_id_array);
320:
321: amv_category_pvt_w.rosetta_table_copy_in_p3(ddp_category_new_order, p_category_new_order);
322:
323: -- here's the delegated call to the old PL/SQL routine

Line 321: amv_category_pvt_w.rosetta_table_copy_in_p3(ddp_category_new_order, p_category_new_order);

317:
318:
319: amv_category_pvt_w.rosetta_table_copy_in_p3(ddp_category_id_array, p_category_id_array);
320:
321: amv_category_pvt_w.rosetta_table_copy_in_p3(ddp_category_new_order, p_category_new_order);
322:
323: -- here's the delegated call to the old PL/SQL routine
324: amv_category_pvt.reorder_category(p_api_version,
325: p_init_msg_list,

Line 324: amv_category_pvt.reorder_category(p_api_version,

320:
321: amv_category_pvt_w.rosetta_table_copy_in_p3(ddp_category_new_order, p_category_new_order);
322:
323: -- here's the delegated call to the old PL/SQL routine
324: amv_category_pvt.reorder_category(p_api_version,
325: p_init_msg_list,
326: p_commit,
327: p_validation_level,
328: x_return_status,

Line 378: ddp_request_obj amv_category_pvt.amv_request_obj_type;

374: , p12_a2 VARCHAR2 := fnd_api.g_miss_char
375: )
376:
377: as
378: ddp_request_obj amv_category_pvt.amv_request_obj_type;
379: ddx_return_obj amv_category_pvt.amv_return_obj_type;
380: ddx_chan_category_rec_array amv_category_pvt.amv_category_varray_type;
381: ddindx binary_integer; indx binary_integer;
382: begin

Line 379: ddx_return_obj amv_category_pvt.amv_return_obj_type;

375: )
376:
377: as
378: ddp_request_obj amv_category_pvt.amv_request_obj_type;
379: ddx_return_obj amv_category_pvt.amv_return_obj_type;
380: ddx_chan_category_rec_array amv_category_pvt.amv_category_varray_type;
381: ddindx binary_integer; indx binary_integer;
382: begin
383:

Line 380: ddx_chan_category_rec_array amv_category_pvt.amv_category_varray_type;

376:
377: as
378: ddp_request_obj amv_category_pvt.amv_request_obj_type;
379: ddx_return_obj amv_category_pvt.amv_return_obj_type;
380: ddx_chan_category_rec_array amv_category_pvt.amv_category_varray_type;
381: ddindx binary_integer; indx binary_integer;
382: begin
383:
384: -- copy data to the local IN or IN-OUT args, if any

Line 404: amv_category_pvt.find_categories(p_api_version,

400:
401:
402:
403: -- here's the delegated call to the old PL/SQL routine
404: amv_category_pvt.find_categories(p_api_version,
405: p_init_msg_list,
406: p_validation_level,
407: x_return_status,
408: x_msg_count,

Line 438: amv_category_pvt_w.rosetta_table_copy_out_p7(ddx_chan_category_rec_array, p14_a0

434: p13_a0 := rosetta_g_miss_num_map(ddx_return_obj.returned_record_count);
435: p13_a1 := rosetta_g_miss_num_map(ddx_return_obj.next_record_position);
436: p13_a2 := rosetta_g_miss_num_map(ddx_return_obj.total_record_count);
437:
438: amv_category_pvt_w.rosetta_table_copy_out_p7(ddx_chan_category_rec_array, p14_a0
439: , p14_a1
440: , p14_a2
441: , p14_a3
442: , p14_a4

Line 464: ddx_content_chan_array amv_category_pvt.amv_cat_hierarchy_varray_type;

460: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300
461: )
462:
463: as
464: ddx_content_chan_array amv_category_pvt.amv_cat_hierarchy_varray_type;
465: ddindx binary_integer; indx binary_integer;
466: begin
467:
468: -- copy data to the local IN or IN-OUT args, if any

Line 480: amv_category_pvt.get_channelspercategory(p_api_version,

476:
477:
478:
479: -- here's the delegated call to the old PL/SQL routine
480: amv_category_pvt.get_channelspercategory(p_api_version,
481: p_init_msg_list,
482: p_validation_level,
483: x_return_status,
484: x_msg_count,

Line 501: amv_category_pvt_w.rosetta_table_copy_out_p10(ddx_content_chan_array, p9_a0

497:
498:
499:
500:
501: amv_category_pvt_w.rosetta_table_copy_out_p10(ddx_content_chan_array, p9_a0
502: , p9_a1
503: , p9_a2
504: );
505: end;

Line 522: ddx_items_array amv_category_pvt.amv_cat_hierarchy_varray_type;

518: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300
519: )
520:
521: as
522: ddx_items_array amv_category_pvt.amv_cat_hierarchy_varray_type;
523: ddindx binary_integer; indx binary_integer;
524: begin
525:
526: -- copy data to the local IN or IN-OUT args, if any

Line 538: amv_category_pvt.get_itemspercategory(p_api_version,

534:
535:
536:
537: -- here's the delegated call to the old PL/SQL routine
538: amv_category_pvt.get_itemspercategory(p_api_version,
539: p_init_msg_list,
540: p_validation_level,
541: x_return_status,
542: x_msg_count,

Line 559: amv_category_pvt_w.rosetta_table_copy_out_p10(ddx_items_array, p9_a0

555:
556:
557:
558:
559: amv_category_pvt_w.rosetta_table_copy_out_p10(ddx_items_array, p9_a0
560: , p9_a1
561: , p9_a2
562: );
563: end;

Line 588: ddp_request_obj amv_category_pvt.amv_request_obj_type;

584: , p10_a1 VARCHAR2 := fnd_api.g_miss_char
585: )
586:
587: as
588: ddp_request_obj amv_category_pvt.amv_request_obj_type;
589: ddp_category_sort amv_category_pvt.amv_sort_obj_type;
590: ddx_return_obj amv_category_pvt.amv_return_obj_type;
591: ddx_items_array amv_category_pvt.amv_cat_hierarchy_varray_type;
592: ddindx binary_integer; indx binary_integer;

Line 589: ddp_category_sort amv_category_pvt.amv_sort_obj_type;

585: )
586:
587: as
588: ddp_request_obj amv_category_pvt.amv_request_obj_type;
589: ddp_category_sort amv_category_pvt.amv_sort_obj_type;
590: ddx_return_obj amv_category_pvt.amv_return_obj_type;
591: ddx_items_array amv_category_pvt.amv_cat_hierarchy_varray_type;
592: ddindx binary_integer; indx binary_integer;
593: begin

Line 590: ddx_return_obj amv_category_pvt.amv_return_obj_type;

586:
587: as
588: ddp_request_obj amv_category_pvt.amv_request_obj_type;
589: ddp_category_sort amv_category_pvt.amv_sort_obj_type;
590: ddx_return_obj amv_category_pvt.amv_return_obj_type;
591: ddx_items_array amv_category_pvt.amv_cat_hierarchy_varray_type;
592: ddindx binary_integer; indx binary_integer;
593: begin
594:

Line 591: ddx_items_array amv_category_pvt.amv_cat_hierarchy_varray_type;

587: as
588: ddp_request_obj amv_category_pvt.amv_request_obj_type;
589: ddp_category_sort amv_category_pvt.amv_sort_obj_type;
590: ddx_return_obj amv_category_pvt.amv_return_obj_type;
591: ddx_items_array amv_category_pvt.amv_cat_hierarchy_varray_type;
592: ddindx binary_integer; indx binary_integer;
593: begin
594:
595: -- copy data to the local IN or IN-OUT args, if any

Line 615: amv_category_pvt.get_itemspercategory(p_api_version,

611:
612:
613:
614: -- here's the delegated call to the old PL/SQL routine
615: amv_category_pvt.get_itemspercategory(p_api_version,
616: p_init_msg_list,
617: p_validation_level,
618: x_return_status,
619: x_msg_count,

Line 645: amv_category_pvt_w.rosetta_table_copy_out_p10(ddx_items_array, p12_a0

641: p11_a0 := rosetta_g_miss_num_map(ddx_return_obj.returned_record_count);
642: p11_a1 := rosetta_g_miss_num_map(ddx_return_obj.next_record_position);
643: p11_a2 := rosetta_g_miss_num_map(ddx_return_obj.total_record_count);
644:
645: amv_category_pvt_w.rosetta_table_copy_out_p10(ddx_items_array, p12_a0
646: , p12_a1
647: , p12_a2
648: );
649: end;

Line 665: ddx_category_hierarchy amv_category_pvt.amv_cat_hierarchy_varray_type;

661: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_300
662: )
663:
664: as
665: ddx_category_hierarchy amv_category_pvt.amv_cat_hierarchy_varray_type;
666: ddindx binary_integer; indx binary_integer;
667: begin
668:
669: -- copy data to the local IN or IN-OUT args, if any

Line 680: amv_category_pvt.get_catparentshierarchy(p_api_version,

676:
677:
678:
679: -- here's the delegated call to the old PL/SQL routine
680: amv_category_pvt.get_catparentshierarchy(p_api_version,
681: p_init_msg_list,
682: p_validation_level,
683: x_return_status,
684: x_msg_count,

Line 699: amv_category_pvt_w.rosetta_table_copy_out_p10(ddx_category_hierarchy, p8_a0

695:
696:
697:
698:
699: amv_category_pvt_w.rosetta_table_copy_out_p10(ddx_category_hierarchy, p8_a0
700: , p8_a1
701: , p8_a2
702: );
703: end;

Line 719: ddx_category_hierarchy amv_category_pvt.amv_cat_hierarchy_varray_type;

715: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_300
716: )
717:
718: as
719: ddx_category_hierarchy amv_category_pvt.amv_cat_hierarchy_varray_type;
720: ddindx binary_integer; indx binary_integer;
721: begin
722:
723: -- copy data to the local IN or IN-OUT args, if any

Line 734: amv_category_pvt.get_catchildrenhierarchy(p_api_version,

730:
731:
732:
733: -- here's the delegated call to the old PL/SQL routine
734: amv_category_pvt.get_catchildrenhierarchy(p_api_version,
735: p_init_msg_list,
736: p_validation_level,
737: x_return_status,
738: x_msg_count,

Line 753: amv_category_pvt_w.rosetta_table_copy_out_p10(ddx_category_hierarchy, p8_a0

749:
750:
751:
752:
753: amv_category_pvt_w.rosetta_table_copy_out_p10(ddx_category_hierarchy, p8_a0
754: , p8_a1
755: , p8_a2
756: );
757: end;

Line 774: ddx_category_hierarchy amv_category_pvt.amv_cat_hierarchy_varray_type;

770: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300
771: )
772:
773: as
774: ddx_category_hierarchy amv_category_pvt.amv_cat_hierarchy_varray_type;
775: ddindx binary_integer; indx binary_integer;
776: begin
777:
778: -- copy data to the local IN or IN-OUT args, if any

Line 790: amv_category_pvt.get_chncategoryhierarchy(p_api_version,

786:
787:
788:
789: -- here's the delegated call to the old PL/SQL routine
790: amv_category_pvt.get_chncategoryhierarchy(p_api_version,
791: p_init_msg_list,
792: p_validation_level,
793: x_return_status,
794: x_msg_count,

Line 811: amv_category_pvt_w.rosetta_table_copy_out_p10(ddx_category_hierarchy, p9_a0

807:
808:
809:
810:
811: amv_category_pvt_w.rosetta_table_copy_out_p10(ddx_category_hierarchy, p9_a0
812: , p9_a1
813: , p9_a2
814: );
815: end;

Line 817: end amv_category_pvt_w;

813: , p9_a2
814: );
815: end;
816:
817: end amv_category_pvt_w;