APPS.OKL_SPM_PVT_W dependencies on OKL_SPM_PVT

Line 1: package body okl_spm_pvt_w as

1: package body okl_spm_pvt_w as
2: /* $Header: OKLISPMB.pls 120.2 2005/10/30 04:01:02 appldev noship $ */
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 okl_spm_pvt.spm_tbl_type, a0 JTF_NUMBER_TABLE

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 okl_spm_pvt.spm_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_200

Line 71: procedure rosetta_table_copy_out_p2(t okl_spm_pvt.spm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

67: end loop;
68: end if;
69: end if;
70: end rosetta_table_copy_in_p2;
71: procedure rosetta_table_copy_out_p2(t okl_spm_pvt.spm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
72: , a1 out nocopy JTF_NUMBER_TABLE
73: , a2 out nocopy JTF_NUMBER_TABLE
74: , a3 out nocopy JTF_NUMBER_TABLE
75: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 170: procedure rosetta_table_copy_in_p5(t out nocopy okl_spm_pvt.spmv_tbl_type, a0 JTF_NUMBER_TABLE

166: end if;
167: end if;
168: end rosetta_table_copy_out_p2;
169:
170: procedure rosetta_table_copy_in_p5(t out nocopy okl_spm_pvt.spmv_tbl_type, a0 JTF_NUMBER_TABLE
171: , a1 JTF_NUMBER_TABLE
172: , a2 JTF_NUMBER_TABLE
173: , a3 JTF_NUMBER_TABLE
174: , a4 JTF_VARCHAR2_TABLE_200

Line 219: procedure rosetta_table_copy_out_p5(t okl_spm_pvt.spmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

215: end loop;
216: end if;
217: end if;
218: end rosetta_table_copy_in_p5;
219: procedure rosetta_table_copy_out_p5(t okl_spm_pvt.spmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
220: , a1 out nocopy JTF_NUMBER_TABLE
221: , a2 out nocopy JTF_NUMBER_TABLE
222: , a3 out nocopy JTF_NUMBER_TABLE
223: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 342: ddp_spmv_rec okl_spm_pvt.spmv_rec_type;

338: , p5_a15 NUMBER := 0-1962.0724
339: )
340:
341: as
342: ddp_spmv_rec okl_spm_pvt.spmv_rec_type;
343: ddindx binary_integer; indx binary_integer;
344: begin
345:
346: -- copy data to the local IN or IN-OUT args, if any

Line 370: okl_spm_pvt.insert_row(p_api_version,

366: ddp_spmv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a14);
367: ddp_spmv_rec.last_update_login := rosetta_g_miss_num_map(p5_a15);
368:
369: -- here's the delegated call to the old PL/SQL routine
370: okl_spm_pvt.insert_row(p_api_version,
371: p_init_msg_list,
372: x_return_status,
373: x_msg_count,
374: x_msg_data,

Line 409: ddp_spmv_tbl okl_spm_pvt.spmv_tbl_type;

405: , p5_a15 JTF_NUMBER_TABLE
406: )
407:
408: as
409: ddp_spmv_tbl okl_spm_pvt.spmv_tbl_type;
410: ddindx binary_integer; indx binary_integer;
411: begin
412:
413: -- copy data to the local IN or IN-OUT args, if any

Line 419: okl_spm_pvt_w.rosetta_table_copy_in_p5(ddp_spmv_tbl, p5_a0

415:
416:
417:
418:
419: okl_spm_pvt_w.rosetta_table_copy_in_p5(ddp_spmv_tbl, p5_a0
420: , p5_a1
421: , p5_a2
422: , p5_a3
423: , p5_a4

Line 438: okl_spm_pvt.insert_row(p_api_version,

434: , p5_a15
435: );
436:
437: -- here's the delegated call to the old PL/SQL routine
438: okl_spm_pvt.insert_row(p_api_version,
439: p_init_msg_list,
440: x_return_status,
441: x_msg_count,
442: x_msg_data,

Line 477: ddp_spmv_rec okl_spm_pvt.spmv_rec_type;

473: , p5_a15 NUMBER := 0-1962.0724
474: )
475:
476: as
477: ddp_spmv_rec okl_spm_pvt.spmv_rec_type;
478: ddindx binary_integer; indx binary_integer;
479: begin
480:
481: -- copy data to the local IN or IN-OUT args, if any

Line 505: okl_spm_pvt.update_row(p_api_version,

501: ddp_spmv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a14);
502: ddp_spmv_rec.last_update_login := rosetta_g_miss_num_map(p5_a15);
503:
504: -- here's the delegated call to the old PL/SQL routine
505: okl_spm_pvt.update_row(p_api_version,
506: p_init_msg_list,
507: x_return_status,
508: x_msg_count,
509: x_msg_data,

Line 544: ddp_spmv_tbl okl_spm_pvt.spmv_tbl_type;

540: , p5_a15 JTF_NUMBER_TABLE
541: )
542:
543: as
544: ddp_spmv_tbl okl_spm_pvt.spmv_tbl_type;
545: ddindx binary_integer; indx binary_integer;
546: begin
547:
548: -- copy data to the local IN or IN-OUT args, if any

Line 554: okl_spm_pvt_w.rosetta_table_copy_in_p5(ddp_spmv_tbl, p5_a0

550:
551:
552:
553:
554: okl_spm_pvt_w.rosetta_table_copy_in_p5(ddp_spmv_tbl, p5_a0
555: , p5_a1
556: , p5_a2
557: , p5_a3
558: , p5_a4

Line 573: okl_spm_pvt.update_row(p_api_version,

569: , p5_a15
570: );
571:
572: -- here's the delegated call to the old PL/SQL routine
573: okl_spm_pvt.update_row(p_api_version,
574: p_init_msg_list,
575: x_return_status,
576: x_msg_count,
577: x_msg_data,

Line 588: end okl_spm_pvt_w;

584:
585:
586: end;
587:
588: end okl_spm_pvt_w;