DBA Data[Home] [Help]

APPS.AHL_RA_NR_PROFILE_PVT_W dependencies on AHL_RA_NR_PROFILE_PVT

Line 1: package body ahl_ra_nr_profile_pvt_w as

1: package body ahl_ra_nr_profile_pvt_w as
2: /* $Header: AHLWNRPB.pls 120.0.12020000.2 2012/12/13 06:28:19 shnatu noship $ */
3: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ra_nr_profile_pvt.nr_prof_est_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_DATE_TABLE

Line 3: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ra_nr_profile_pvt.nr_prof_est_tbl_type, a0 JTF_NUMBER_TABLE

1: package body ahl_ra_nr_profile_pvt_w as
2: /* $Header: AHLWNRPB.pls 120.0.12020000.2 2012/12/13 06:28:19 shnatu noship $ */
3: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ra_nr_profile_pvt.nr_prof_est_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE

Line 80: procedure rosetta_table_copy_out_p4(t ahl_ra_nr_profile_pvt.nr_prof_est_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

76: end loop;
77: end if;
78: end if;
79: end rosetta_table_copy_in_p4;
80: procedure rosetta_table_copy_out_p4(t ahl_ra_nr_profile_pvt.nr_prof_est_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
81: , a1 out nocopy JTF_NUMBER_TABLE
82: , a2 out nocopy JTF_DATE_TABLE
83: , a3 out nocopy JTF_NUMBER_TABLE
84: , a4 out nocopy JTF_DATE_TABLE

Line 249: procedure rosetta_table_copy_in_p6(t out nocopy ahl_ra_nr_profile_pvt.nrp_res_req_tbl_type, a0 JTF_NUMBER_TABLE

245: end if;
246: end if;
247: end rosetta_table_copy_out_p4;
248:
249: procedure rosetta_table_copy_in_p6(t out nocopy ahl_ra_nr_profile_pvt.nrp_res_req_tbl_type, a0 JTF_NUMBER_TABLE
250: , a1 JTF_NUMBER_TABLE
251: , a2 JTF_NUMBER_TABLE
252: , a3 JTF_VARCHAR2_TABLE_100
253: ) as

Line 274: procedure rosetta_table_copy_out_p6(t ahl_ra_nr_profile_pvt.nrp_res_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

270: end loop;
271: end if;
272: end if;
273: end rosetta_table_copy_in_p6;
274: procedure rosetta_table_copy_out_p6(t ahl_ra_nr_profile_pvt.nrp_res_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
275: , a1 out nocopy JTF_NUMBER_TABLE
276: , a2 out nocopy JTF_NUMBER_TABLE
277: , a3 out nocopy JTF_VARCHAR2_TABLE_100
278: ) as

Line 313: procedure rosetta_table_copy_in_p8(t out nocopy ahl_ra_nr_profile_pvt.nrp_mat_req_tbl_type, a0 JTF_NUMBER_TABLE

309: end if;
310: end if;
311: end rosetta_table_copy_out_p6;
312:
313: procedure rosetta_table_copy_in_p8(t out nocopy ahl_ra_nr_profile_pvt.nrp_mat_req_tbl_type, a0 JTF_NUMBER_TABLE
314: , a1 JTF_NUMBER_TABLE
315: , a2 JTF_NUMBER_TABLE
316: , a3 JTF_VARCHAR2_TABLE_100
317: , a4 JTF_VARCHAR2_TABLE_100

Line 340: procedure rosetta_table_copy_out_p8(t ahl_ra_nr_profile_pvt.nrp_mat_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

336: end loop;
337: end if;
338: end if;
339: end rosetta_table_copy_in_p8;
340: procedure rosetta_table_copy_out_p8(t ahl_ra_nr_profile_pvt.nrp_mat_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
341: , a1 out nocopy JTF_NUMBER_TABLE
342: , a2 out nocopy JTF_NUMBER_TABLE
343: , a3 out nocopy JTF_VARCHAR2_TABLE_100
344: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 398: ddx_prof_res_req_tbl ahl_ra_nr_profile_pvt.nrp_res_req_tbl_type;

394: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
395: )
396:
397: as
398: ddx_prof_res_req_tbl ahl_ra_nr_profile_pvt.nrp_res_req_tbl_type;
399: ddindx binary_integer; indx binary_integer;
400: begin
401:
402: -- copy data to the local IN or IN-OUT args, if any

Line 412: ahl_ra_nr_profile_pvt.populate_prof_res_req(p_mr_header_id,

408:
409:
410:
411: -- here's the delegated call to the old PL/SQL routine
412: ahl_ra_nr_profile_pvt.populate_prof_res_req(p_mr_header_id,
413: p_instance_id,
414: p_ue_id,
415: p_plan_id,
416: x_return_status,

Line 429: ahl_ra_nr_profile_pvt_w.rosetta_table_copy_out_p6(ddx_prof_res_req_tbl, p7_a0

425:
426:
427:
428:
429: ahl_ra_nr_profile_pvt_w.rosetta_table_copy_out_p6(ddx_prof_res_req_tbl, p7_a0
430: , p7_a1
431: , p7_a2
432: , p7_a3
433: );

Line 451: ddx_prof_mat_req_tbl ahl_ra_nr_profile_pvt.nrp_mat_req_tbl_type;

447: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
448: )
449:
450: as
451: ddx_prof_mat_req_tbl ahl_ra_nr_profile_pvt.nrp_mat_req_tbl_type;
452: ddindx binary_integer; indx binary_integer;
453: begin
454:
455: -- copy data to the local IN or IN-OUT args, if any

Line 465: ahl_ra_nr_profile_pvt.populate_prof_mat_req(p_mr_header_id,

461:
462:
463:
464: -- here's the delegated call to the old PL/SQL routine
465: ahl_ra_nr_profile_pvt.populate_prof_mat_req(p_mr_header_id,
466: p_instance_id,
467: p_ue_id,
468: p_plan_id,
469: x_return_status,

Line 482: ahl_ra_nr_profile_pvt_w.rosetta_table_copy_out_p8(ddx_prof_mat_req_tbl, p7_a0

478:
479:
480:
481:
482: ahl_ra_nr_profile_pvt_w.rosetta_table_copy_out_p8(ddx_prof_mat_req_tbl, p7_a0
483: , p7_a1
484: , p7_a2
485: , p7_a3
486: , p7_a4

Line 529: ddp_x_nr_profile_header_rec ahl_ra_nr_profile_pvt.nr_prof_header_rec_type;

525: , p7_a28 in out nocopy VARCHAR2
526: )
527:
528: as
529: ddp_x_nr_profile_header_rec ahl_ra_nr_profile_pvt.nr_prof_header_rec_type;
530: ddindx binary_integer; indx binary_integer;
531: begin
532:
533: -- copy data to the local IN or IN-OUT args, if any

Line 572: ahl_ra_nr_profile_pvt.process_nr_profile(p_api_version,

568: ddp_x_nr_profile_header_rec.attribute15 := p7_a27;
569: ddp_x_nr_profile_header_rec.dml_operation := p7_a28;
570:
571: -- here's the delegated call to the old PL/SQL routine
572: ahl_ra_nr_profile_pvt.process_nr_profile(p_api_version,
573: p_init_msg_list,
574: p_commit,
575: p_validation_level,
576: x_return_status,

Line 660: ddp_x_nr_prof_est_tbl ahl_ra_nr_profile_pvt.nr_prof_est_tbl_type;

656: , p7_a29 in out nocopy JTF_VARCHAR2_TABLE_100
657: )
658:
659: as
660: ddp_x_nr_prof_est_tbl ahl_ra_nr_profile_pvt.nr_prof_est_tbl_type;
661: ddindx binary_integer; indx binary_integer;
662: begin
663:
664: -- copy data to the local IN or IN-OUT args, if any

Line 672: ahl_ra_nr_profile_pvt_w.rosetta_table_copy_in_p4(ddp_x_nr_prof_est_tbl, p7_a0

668:
669:
670:
671:
672: ahl_ra_nr_profile_pvt_w.rosetta_table_copy_in_p4(ddp_x_nr_prof_est_tbl, p7_a0
673: , p7_a1
674: , p7_a2
675: , p7_a3
676: , p7_a4

Line 705: ahl_ra_nr_profile_pvt.add_details_to_prof(p_api_version,

701: , p7_a29
702: );
703:
704: -- here's the delegated call to the old PL/SQL routine
705: ahl_ra_nr_profile_pvt.add_details_to_prof(p_api_version,
706: p_init_msg_list,
707: p_commit,
708: p_validation_level,
709: x_return_status,

Line 722: ahl_ra_nr_profile_pvt_w.rosetta_table_copy_out_p4(ddp_x_nr_prof_est_tbl, p7_a0

718:
719:
720:
721:
722: ahl_ra_nr_profile_pvt_w.rosetta_table_copy_out_p4(ddp_x_nr_prof_est_tbl, p7_a0
723: , p7_a1
724: , p7_a2
725: , p7_a3
726: , p7_a4

Line 755: end ahl_ra_nr_profile_pvt_w;

751: , p7_a29
752: );
753: end;
754:
755: end ahl_ra_nr_profile_pvt_w;