DBA Data[Home] [Help]

APPS.OKL_ECV_PVT_W dependencies on OKL_ECV_PVT

Line 1: package body okl_ecv_pvt_w as

1: package body okl_ecv_pvt_w as
2: /* $Header: OKLIECVB.pls 120.1 2005/10/30 04:58:45 appldev noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_ecv_pvt.okl_ecv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy okl_ecv_pvt.okl_ecv_tbl, a0 JTF_NUMBER_TABLE

1: package body okl_ecv_pvt_w as
2: /* $Header: OKLIECVB.pls 120.1 2005/10/30 04:58:45 appldev noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_ecv_pvt.okl_ecv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100

Line 92: procedure rosetta_table_copy_out_p1(t okl_ecv_pvt.okl_ecv_tbl, a0 out nocopy JTF_NUMBER_TABLE

88: end loop;
89: end if;
90: end if;
91: end rosetta_table_copy_in_p1;
92: procedure rosetta_table_copy_out_p1(t okl_ecv_pvt.okl_ecv_tbl, a0 out nocopy JTF_NUMBER_TABLE
93: , a1 out nocopy JTF_NUMBER_TABLE
94: , a2 out nocopy JTF_NUMBER_TABLE
95: , a3 out nocopy JTF_VARCHAR2_TABLE_100
96: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 371: ddp_ecv_rec okl_ecv_pvt.okl_ecv_rec;

367: , p6_a35 out nocopy VARCHAR2
368: )
369:
370: as
371: ddp_ecv_rec okl_ecv_pvt.okl_ecv_rec;
372: ddx_ecv_rec okl_ecv_pvt.okl_ecv_rec;
373: ddindx binary_integer; indx binary_integer;
374: begin
375:

Line 372: ddx_ecv_rec okl_ecv_pvt.okl_ecv_rec;

368: )
369:
370: as
371: ddp_ecv_rec okl_ecv_pvt.okl_ecv_rec;
372: ddx_ecv_rec okl_ecv_pvt.okl_ecv_rec;
373: ddindx binary_integer; indx binary_integer;
374: begin
375:
376: -- copy data to the local IN or IN-OUT args, if any

Line 421: okl_ecv_pvt.insert_row(p_api_version,

417: ddp_ecv_rec.attribute15 := p5_a35;
418:
419:
420: -- here's the delegated call to the old PL/SQL routine
421: okl_ecv_pvt.insert_row(p_api_version,
422: p_init_msg_list,
423: x_return_status,
424: x_msg_count,
425: x_msg_data,

Line 554: ddp_ecv_tbl okl_ecv_pvt.okl_ecv_tbl;

550: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
551: )
552:
553: as
554: ddp_ecv_tbl okl_ecv_pvt.okl_ecv_tbl;
555: ddx_ecv_tbl okl_ecv_pvt.okl_ecv_tbl;
556: ddindx binary_integer; indx binary_integer;
557: begin
558:

Line 555: ddx_ecv_tbl okl_ecv_pvt.okl_ecv_tbl;

551: )
552:
553: as
554: ddp_ecv_tbl okl_ecv_pvt.okl_ecv_tbl;
555: ddx_ecv_tbl okl_ecv_pvt.okl_ecv_tbl;
556: ddindx binary_integer; indx binary_integer;
557: begin
558:
559: -- copy data to the local IN or IN-OUT args, if any

Line 565: okl_ecv_pvt_w.rosetta_table_copy_in_p1(ddp_ecv_tbl, p5_a0

561:
562:
563:
564:
565: okl_ecv_pvt_w.rosetta_table_copy_in_p1(ddp_ecv_tbl, p5_a0
566: , p5_a1
567: , p5_a2
568: , p5_a3
569: , p5_a4

Line 605: okl_ecv_pvt.insert_row(p_api_version,

601: );
602:
603:
604: -- here's the delegated call to the old PL/SQL routine
605: okl_ecv_pvt.insert_row(p_api_version,
606: p_init_msg_list,
607: x_return_status,
608: x_msg_count,
609: x_msg_data,

Line 620: okl_ecv_pvt_w.rosetta_table_copy_out_p1(ddx_ecv_tbl, p6_a0

616:
617:
618:
619:
620: okl_ecv_pvt_w.rosetta_table_copy_out_p1(ddx_ecv_tbl, p6_a0
621: , p6_a1
622: , p6_a2
623: , p6_a3
624: , p6_a4

Line 739: ddp_ecv_rec okl_ecv_pvt.okl_ecv_rec;

735: , p6_a35 out nocopy VARCHAR2
736: )
737:
738: as
739: ddp_ecv_rec okl_ecv_pvt.okl_ecv_rec;
740: ddx_ecv_rec okl_ecv_pvt.okl_ecv_rec;
741: ddindx binary_integer; indx binary_integer;
742: begin
743:

Line 740: ddx_ecv_rec okl_ecv_pvt.okl_ecv_rec;

736: )
737:
738: as
739: ddp_ecv_rec okl_ecv_pvt.okl_ecv_rec;
740: ddx_ecv_rec okl_ecv_pvt.okl_ecv_rec;
741: ddindx binary_integer; indx binary_integer;
742: begin
743:
744: -- copy data to the local IN or IN-OUT args, if any

Line 789: okl_ecv_pvt.update_row(p_api_version,

785: ddp_ecv_rec.attribute15 := p5_a35;
786:
787:
788: -- here's the delegated call to the old PL/SQL routine
789: okl_ecv_pvt.update_row(p_api_version,
790: p_init_msg_list,
791: x_return_status,
792: x_msg_count,
793: x_msg_data,

Line 922: ddp_ecv_tbl okl_ecv_pvt.okl_ecv_tbl;

918: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
919: )
920:
921: as
922: ddp_ecv_tbl okl_ecv_pvt.okl_ecv_tbl;
923: ddx_ecv_tbl okl_ecv_pvt.okl_ecv_tbl;
924: ddindx binary_integer; indx binary_integer;
925: begin
926:

Line 923: ddx_ecv_tbl okl_ecv_pvt.okl_ecv_tbl;

919: )
920:
921: as
922: ddp_ecv_tbl okl_ecv_pvt.okl_ecv_tbl;
923: ddx_ecv_tbl okl_ecv_pvt.okl_ecv_tbl;
924: ddindx binary_integer; indx binary_integer;
925: begin
926:
927: -- copy data to the local IN or IN-OUT args, if any

Line 933: okl_ecv_pvt_w.rosetta_table_copy_in_p1(ddp_ecv_tbl, p5_a0

929:
930:
931:
932:
933: okl_ecv_pvt_w.rosetta_table_copy_in_p1(ddp_ecv_tbl, p5_a0
934: , p5_a1
935: , p5_a2
936: , p5_a3
937: , p5_a4

Line 973: okl_ecv_pvt.update_row(p_api_version,

969: );
970:
971:
972: -- here's the delegated call to the old PL/SQL routine
973: okl_ecv_pvt.update_row(p_api_version,
974: p_init_msg_list,
975: x_return_status,
976: x_msg_count,
977: x_msg_data,

Line 988: okl_ecv_pvt_w.rosetta_table_copy_out_p1(ddx_ecv_tbl, p6_a0

984:
985:
986:
987:
988: okl_ecv_pvt_w.rosetta_table_copy_out_p1(ddx_ecv_tbl, p6_a0
989: , p6_a1
990: , p6_a2
991: , p6_a3
992: , p6_a4

Line 1071: ddp_ecv_rec okl_ecv_pvt.okl_ecv_rec;

1067: , p5_a35 VARCHAR2
1068: )
1069:
1070: as
1071: ddp_ecv_rec okl_ecv_pvt.okl_ecv_rec;
1072: ddindx binary_integer; indx binary_integer;
1073: begin
1074:
1075: -- copy data to the local IN or IN-OUT args, if any

Line 1119: okl_ecv_pvt.delete_row(p_api_version,

1115: ddp_ecv_rec.attribute14 := p5_a34;
1116: ddp_ecv_rec.attribute15 := p5_a35;
1117:
1118: -- here's the delegated call to the old PL/SQL routine
1119: okl_ecv_pvt.delete_row(p_api_version,
1120: p_init_msg_list,
1121: x_return_status,
1122: x_msg_count,
1123: x_msg_data,

Line 1178: ddp_ecv_tbl okl_ecv_pvt.okl_ecv_tbl;

1174: , p5_a35 JTF_VARCHAR2_TABLE_500
1175: )
1176:
1177: as
1178: ddp_ecv_tbl okl_ecv_pvt.okl_ecv_tbl;
1179: ddindx binary_integer; indx binary_integer;
1180: begin
1181:
1182: -- copy data to the local IN or IN-OUT args, if any

Line 1188: okl_ecv_pvt_w.rosetta_table_copy_in_p1(ddp_ecv_tbl, p5_a0

1184:
1185:
1186:
1187:
1188: okl_ecv_pvt_w.rosetta_table_copy_in_p1(ddp_ecv_tbl, p5_a0
1189: , p5_a1
1190: , p5_a2
1191: , p5_a3
1192: , p5_a4

Line 1227: okl_ecv_pvt.delete_row(p_api_version,

1223: , p5_a35
1224: );
1225:
1226: -- here's the delegated call to the old PL/SQL routine
1227: okl_ecv_pvt.delete_row(p_api_version,
1228: p_init_msg_list,
1229: x_return_status,
1230: x_msg_count,
1231: x_msg_data,

Line 1281: ddp_ecv_rec okl_ecv_pvt.okl_ecv_rec;

1277: , p0_a35 in out nocopy VARCHAR2
1278: ) return varchar2
1279:
1280: as
1281: ddp_ecv_rec okl_ecv_pvt.okl_ecv_rec;
1282: ddindx binary_integer; indx binary_integer;
1283: ddrosetta_retval varchar2(4000);
1284: begin
1285:

Line 1325: ddrosetta_retval := okl_ecv_pvt.validate_record(ddp_ecv_rec);

1321: ddp_ecv_rec.attribute14 := p0_a34;
1322: ddp_ecv_rec.attribute15 := p0_a35;
1323:
1324: -- here's the delegated call to the old PL/SQL routine
1325: ddrosetta_retval := okl_ecv_pvt.validate_record(ddp_ecv_rec);
1326:
1327: -- copy data back from the local variables to OUT or IN-OUT args, if any
1328: p0_a0 := ddp_ecv_rec.criterion_value_id;
1329: p0_a1 := ddp_ecv_rec.object_version_number;

Line 1368: end okl_ecv_pvt_w;

1364:
1365: return ddrosetta_retval;
1366: end;
1367:
1368: end okl_ecv_pvt_w;