APPS.AMV_STOCK_PVT_W dependencies on AMV_STOCK_PVT

Line 1: package body amv_stock_pvt_w as

1: package body amv_stock_pvt_w as
2: /* $Header: amvwstkb.pls 120.2 2005/06/30 08:26 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_p6(t out nocopy amv_stock_pvt.amv_tkr_varray_type, a0 JTF_VARCHAR2_TABLE_100

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p6(t out nocopy amv_stock_pvt.amv_tkr_varray_type, a0 JTF_VARCHAR2_TABLE_100
23: , a1 JTF_NUMBER_TABLE
24: ) as
25: ddindx binary_integer; indx binary_integer;
26: begin

Line 43: procedure rosetta_table_copy_out_p6(t amv_stock_pvt.amv_tkr_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

39: end loop;
40: end if;
41: end if;
42: end rosetta_table_copy_in_p6;
43: procedure rosetta_table_copy_out_p6(t amv_stock_pvt.amv_tkr_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
44: , a1 out nocopy JTF_NUMBER_TABLE
45: ) as
46: ddindx binary_integer; indx binary_integer;
47: begin

Line 72: procedure rosetta_table_copy_in_p7(t out nocopy amv_stock_pvt.amv_sym_varray_type, a0 JTF_NUMBER_TABLE

68: end if;
69: end if;
70: end rosetta_table_copy_out_p6;
71:
72: procedure rosetta_table_copy_in_p7(t out nocopy amv_stock_pvt.amv_sym_varray_type, a0 JTF_NUMBER_TABLE
73: , a1 JTF_VARCHAR2_TABLE_100
74: , a2 JTF_VARCHAR2_TABLE_100
75: ) as
76: ddindx binary_integer; indx binary_integer;

Line 95: procedure rosetta_table_copy_out_p7(t amv_stock_pvt.amv_sym_varray_type, a0 out nocopy JTF_NUMBER_TABLE

91: end loop;
92: end if;
93: end if;
94: end rosetta_table_copy_in_p7;
95: procedure rosetta_table_copy_out_p7(t amv_stock_pvt.amv_sym_varray_type, a0 out nocopy JTF_NUMBER_TABLE
96: , a1 out nocopy JTF_VARCHAR2_TABLE_100
97: , a2 out nocopy JTF_VARCHAR2_TABLE_100
98: ) as
99: ddindx binary_integer; indx binary_integer;

Line 129: procedure rosetta_table_copy_in_p8(t out nocopy amv_stock_pvt.amv_stk_varray_type, a0 JTF_NUMBER_TABLE

125: end if;
126: end if;
127: end rosetta_table_copy_out_p7;
128:
129: procedure rosetta_table_copy_in_p8(t out nocopy amv_stock_pvt.amv_stk_varray_type, a0 JTF_NUMBER_TABLE
130: , a1 JTF_VARCHAR2_TABLE_100
131: , a2 JTF_VARCHAR2_TABLE_300
132: , a3 JTF_NUMBER_TABLE
133: , a4 JTF_NUMBER_TABLE

Line 156: procedure rosetta_table_copy_out_p8(t amv_stock_pvt.amv_stk_varray_type, a0 out nocopy JTF_NUMBER_TABLE

152: end loop;
153: end if;
154: end if;
155: end rosetta_table_copy_in_p8;
156: procedure rosetta_table_copy_out_p8(t amv_stock_pvt.amv_stk_varray_type, a0 out nocopy JTF_NUMBER_TABLE
157: , a1 out nocopy JTF_VARCHAR2_TABLE_100
158: , a2 out nocopy JTF_VARCHAR2_TABLE_300
159: , a3 out nocopy JTF_NUMBER_TABLE
160: , a4 out nocopy JTF_NUMBER_TABLE

Line 200: procedure rosetta_table_copy_in_p9(t out nocopy amv_stock_pvt.amv_news_varray_type, a0 JTF_VARCHAR2_TABLE_100

196: end if;
197: end if;
198: end rosetta_table_copy_out_p8;
199:
200: procedure rosetta_table_copy_in_p9(t out nocopy amv_stock_pvt.amv_news_varray_type, a0 JTF_VARCHAR2_TABLE_100
201: , a1 JTF_VARCHAR2_TABLE_2000
202: , a2 JTF_VARCHAR2_TABLE_2000
203: , a3 JTF_VARCHAR2_TABLE_300
204: , a4 JTF_DATE_TABLE

Line 227: procedure rosetta_table_copy_out_p9(t amv_stock_pvt.amv_news_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

223: end loop;
224: end if;
225: end if;
226: end rosetta_table_copy_in_p9;
227: procedure rosetta_table_copy_out_p9(t amv_stock_pvt.amv_news_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
228: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
229: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
230: , a3 out nocopy JTF_VARCHAR2_TABLE_300
231: , a4 out nocopy JTF_DATE_TABLE

Line 271: procedure rosetta_table_copy_in_p10(t out nocopy amv_stock_pvt.amv_char_varray_type, a0 JTF_VARCHAR2_TABLE_400) as

267: end if;
268: end if;
269: end rosetta_table_copy_out_p9;
270:
271: procedure rosetta_table_copy_in_p10(t out nocopy amv_stock_pvt.amv_char_varray_type, a0 JTF_VARCHAR2_TABLE_400) as
272: ddindx binary_integer; indx binary_integer;
273: begin
274: if a0 is not null and a0.count > 0 then
275: if a0.count > 0 then

Line 289: procedure rosetta_table_copy_out_p10(t amv_stock_pvt.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_400) as

285: end loop;
286: end if;
287: end if;
288: end rosetta_table_copy_in_p10;
289: procedure rosetta_table_copy_out_p10(t amv_stock_pvt.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_400) as
290: ddindx binary_integer; indx binary_integer;
291: begin
292: if t is null or t.count = 0 then
293: a0 := JTF_VARCHAR2_TABLE_400();

Line 312: procedure rosetta_table_copy_in_p11(t out nocopy amv_stock_pvt.amv_num_varray_type, a0 JTF_NUMBER_TABLE) as

308: end if;
309: end if;
310: end rosetta_table_copy_out_p10;
311:
312: procedure rosetta_table_copy_in_p11(t out nocopy amv_stock_pvt.amv_num_varray_type, a0 JTF_NUMBER_TABLE) as
313: ddindx binary_integer; indx binary_integer;
314: begin
315: if a0 is not null and a0.count > 0 then
316: if a0.count > 0 then

Line 330: procedure rosetta_table_copy_out_p11(t amv_stock_pvt.amv_num_varray_type, a0 out nocopy JTF_NUMBER_TABLE) as

326: end loop;
327: end if;
328: end if;
329: end rosetta_table_copy_in_p11;
330: procedure rosetta_table_copy_out_p11(t amv_stock_pvt.amv_num_varray_type, a0 out nocopy JTF_NUMBER_TABLE) as
331: ddindx binary_integer; indx binary_integer;
332: begin
333: if t is null or t.count = 0 then
334: a0 := JTF_NUMBER_TABLE();

Line 370: ddx_stkpr_array amv_stock_pvt.amv_stk_varray_type;

366: , p9_a4 out nocopy JTF_NUMBER_TABLE
367: )
368:
369: as
370: ddx_stkpr_array amv_stock_pvt.amv_stk_varray_type;
371: ddindx binary_integer; indx binary_integer;
372: begin
373:
374: -- copy data to the local IN or IN-OUT args, if any

Line 386: amv_stock_pvt.get_userticker(p_api_version,

382:
383:
384:
385: -- here's the delegated call to the old PL/SQL routine
386: amv_stock_pvt.get_userticker(p_api_version,
387: p_init_msg_list,
388: p_validation_level,
389: x_return_status,
390: x_msg_count,

Line 407: amv_stock_pvt_w.rosetta_table_copy_out_p8(ddx_stkpr_array, p9_a0

403:
404:
405:
406:
407: amv_stock_pvt_w.rosetta_table_copy_out_p8(ddx_stkpr_array, p9_a0
408: , p9_a1
409: , p9_a2
410: , p9_a3
411: , p9_a4

Line 430: ddx_stkpr_array amv_stock_pvt.amv_stk_varray_type;

426: , p7_a4 out nocopy JTF_NUMBER_TABLE
427: )
428:
429: as
430: ddx_stkpr_array amv_stock_pvt.amv_stk_varray_type;
431: ddindx binary_integer; indx binary_integer;
432: begin
433:
434: -- copy data to the local IN or IN-OUT args, if any

Line 444: amv_stock_pvt.get_stockdetails(p_api_version,

440:
441:
442:
443: -- here's the delegated call to the old PL/SQL routine
444: amv_stock_pvt.get_stockdetails(p_api_version,
445: p_init_msg_list,
446: p_validation_level,
447: x_return_status,
448: x_msg_count,

Line 461: amv_stock_pvt_w.rosetta_table_copy_out_p8(ddx_stkpr_array, p7_a0

457:
458:
459:
460:
461: amv_stock_pvt_w.rosetta_table_copy_out_p8(ddx_stkpr_array, p7_a0
462: , p7_a1
463: , p7_a2
464: , p7_a3
465: , p7_a4

Line 484: ddx_stocks_array amv_stock_pvt.amv_sym_varray_type;

480: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
481: )
482:
483: as
484: ddx_stocks_array amv_stock_pvt.amv_sym_varray_type;
485: ddindx binary_integer; indx binary_integer;
486: begin
487:
488: -- copy data to the local IN or IN-OUT args, if any

Line 500: amv_stock_pvt.get_vendormissedstocks(p_api_version,

496:
497:
498:
499: -- here's the delegated call to the old PL/SQL routine
500: amv_stock_pvt.get_vendormissedstocks(p_api_version,
501: p_init_msg_list,
502: p_validation_level,
503: x_return_status,
504: x_msg_count,

Line 521: amv_stock_pvt_w.rosetta_table_copy_out_p7(ddx_stocks_array, p9_a0

517:
518:
519:
520:
521: amv_stock_pvt_w.rosetta_table_copy_out_p7(ddx_stocks_array, p9_a0
522: , p9_a1
523: , p9_a2
524: );
525: end;

Line 540: ddp_ticker_rec amv_stock_pvt.amv_tkr_obj_type;

536: , p8_a1 NUMBER := 0-1962.0724
537: )
538:
539: as
540: ddp_ticker_rec amv_stock_pvt.amv_tkr_obj_type;
541: ddindx binary_integer; indx binary_integer;
542: begin
543:
544: -- copy data to the local IN or IN-OUT args, if any

Line 557: amv_stock_pvt.insert_stockvendorkeys(p_api_version,

553: ddp_ticker_rec.key_id := p8_a0;
554: ddp_ticker_rec.stock_id := rosetta_g_miss_num_map(p8_a1);
555:
556: -- here's the delegated call to the old PL/SQL routine
557: amv_stock_pvt.insert_stockvendorkeys(p_api_version,
558: p_init_msg_list,
559: p_commit,
560: p_validation_level,
561: x_return_status,

Line 590: ddx_keys_array amv_stock_pvt.amv_char_varray_type;

586: , x_keys_array out nocopy JTF_VARCHAR2_TABLE_400
587: )
588:
589: as
590: ddx_keys_array amv_stock_pvt.amv_char_varray_type;
591: ddindx binary_integer; indx binary_integer;
592: begin
593:
594: -- copy data to the local IN or IN-OUT args, if any

Line 605: amv_stock_pvt.get_userselectedkeys(p_api_version,

601:
602:
603:
604: -- here's the delegated call to the old PL/SQL routine
605: amv_stock_pvt.get_userselectedkeys(p_api_version,
606: p_init_msg_list,
607: p_validation_level,
608: x_return_status,
609: x_msg_count,

Line 624: amv_stock_pvt_w.rosetta_table_copy_out_p10(ddx_keys_array, x_keys_array);

620:
621:
622:
623:
624: amv_stock_pvt_w.rosetta_table_copy_out_p10(ddx_keys_array, x_keys_array);
625: end;
626:
627: procedure insert_vendornews(p_api_version NUMBER
628: , p_init_msg_list VARCHAR2

Line 643: ddp_news_rec amv_stock_pvt.amv_news_obj_type;

639: , p8_a4 DATE := fnd_api.g_miss_date
640: )
641:
642: as
643: ddp_news_rec amv_stock_pvt.amv_news_obj_type;
644: ddindx binary_integer; indx binary_integer;
645: begin
646:
647: -- copy data to the local IN or IN-OUT args, if any

Line 663: amv_stock_pvt.insert_vendornews(p_api_version,

659: ddp_news_rec.provider := p8_a3;
660: ddp_news_rec.date_time := rosetta_g_miss_date_in_map(p8_a4);
661:
662: -- here's the delegated call to the old PL/SQL routine
663: amv_stock_pvt.insert_vendornews(p_api_version,
664: p_init_msg_list,
665: p_commit,
666: p_validation_level,
667: x_return_status,

Line 700: ddx_news_array amv_stock_pvt.amv_news_varray_type;

696: , p8_a4 out nocopy JTF_DATE_TABLE
697: )
698:
699: as
700: ddx_news_array amv_stock_pvt.amv_news_varray_type;
701: ddindx binary_integer; indx binary_integer;
702: begin
703:
704: -- copy data to the local IN or IN-OUT args, if any

Line 715: amv_stock_pvt.get_companynews(p_api_version,

711:
712:
713:
714: -- here's the delegated call to the old PL/SQL routine
715: amv_stock_pvt.get_companynews(p_api_version,
716: p_init_msg_list,
717: p_commit,
718: p_validation_level,
719: x_return_status,

Line 734: amv_stock_pvt_w.rosetta_table_copy_out_p9(ddx_news_array, p8_a0

730:
731:
732:
733:
734: amv_stock_pvt_w.rosetta_table_copy_out_p9(ddx_news_array, p8_a0
735: , p8_a1
736: , p8_a2
737: , p8_a3
738: , p8_a4

Line 742: end amv_stock_pvt_w;

738: , p8_a4
739: );
740: end;
741:
742: end amv_stock_pvt_w;