DBA Data[Home] [Help]

APPS.OKL_PAM_PVT_W dependencies on OKL_PAM_PVT

Line 1: package body okl_pam_pvt_w as

1: package body okl_pam_pvt_w as
2: /* $Header: OKLIPAMB.pls 120.0 2005/07/07 10:40:11 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_pam_pvt.okl_pamv_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_pam_pvt.okl_pamv_tbl, a0 JTF_NUMBER_TABLE

1: package body okl_pam_pvt_w as
2: /* $Header: OKLIPAMB.pls 120.0 2005/07/07 10:40:11 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_pam_pvt.okl_pamv_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 84: procedure rosetta_table_copy_out_p1(t okl_pam_pvt.okl_pamv_tbl, a0 out nocopy JTF_NUMBER_TABLE

80: end loop;
81: end if;
82: end if;
83: end rosetta_table_copy_in_p1;
84: procedure rosetta_table_copy_out_p1(t okl_pam_pvt.okl_pamv_tbl, a0 out nocopy JTF_NUMBER_TABLE
85: , a1 out nocopy JTF_NUMBER_TABLE
86: , a2 out nocopy JTF_NUMBER_TABLE
87: , a3 out nocopy JTF_VARCHAR2_TABLE_100
88: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 263: procedure rosetta_table_copy_in_p3(t out nocopy okl_pam_pvt.okl_pamb_tbl, a0 JTF_NUMBER_TABLE

259: end if;
260: end if;
261: end rosetta_table_copy_out_p1;
262:
263: procedure rosetta_table_copy_in_p3(t out nocopy okl_pam_pvt.okl_pamb_tbl, a0 JTF_NUMBER_TABLE
264: , a1 JTF_VARCHAR2_TABLE_300
265: , a2 JTF_NUMBER_TABLE
266: , a3 JTF_NUMBER_TABLE
267: , a4 JTF_VARCHAR2_TABLE_100

Line 342: procedure rosetta_table_copy_out_p3(t okl_pam_pvt.okl_pamb_tbl, a0 out nocopy JTF_NUMBER_TABLE

338: end loop;
339: end if;
340: end if;
341: end rosetta_table_copy_in_p3;
342: procedure rosetta_table_copy_out_p3(t okl_pam_pvt.okl_pamb_tbl, a0 out nocopy JTF_NUMBER_TABLE
343: , a1 out nocopy JTF_VARCHAR2_TABLE_300
344: , a2 out nocopy JTF_NUMBER_TABLE
345: , a3 out nocopy JTF_NUMBER_TABLE
346: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 516: procedure rosetta_table_copy_in_p5(t out nocopy okl_pam_pvt.okl_pamtl_tbl, a0 JTF_NUMBER_TABLE

512: end if;
513: end if;
514: end rosetta_table_copy_out_p3;
515:
516: procedure rosetta_table_copy_in_p5(t out nocopy okl_pam_pvt.okl_pamtl_tbl, a0 JTF_NUMBER_TABLE
517: , a1 JTF_VARCHAR2_TABLE_2000
518: , a2 JTF_VARCHAR2_TABLE_100
519: , a3 JTF_VARCHAR2_TABLE_100
520: , a4 JTF_VARCHAR2_TABLE_100

Line 553: procedure rosetta_table_copy_out_p5(t okl_pam_pvt.okl_pamtl_tbl, a0 out nocopy JTF_NUMBER_TABLE

549: end loop;
550: end if;
551: end if;
552: end rosetta_table_copy_in_p5;
553: procedure rosetta_table_copy_out_p5(t okl_pam_pvt.okl_pamtl_tbl, a0 out nocopy JTF_NUMBER_TABLE
554: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
555: , a2 out nocopy JTF_VARCHAR2_TABLE_100
556: , a3 out nocopy JTF_VARCHAR2_TABLE_100
557: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 694: ddp_pamv_rec okl_pam_pvt.okl_pamv_rec;

690: , p6_a31 out nocopy VARCHAR2
691: )
692:
693: as
694: ddp_pamv_rec okl_pam_pvt.okl_pamv_rec;
695: ddx_pamv_rec okl_pam_pvt.okl_pamv_rec;
696: ddindx binary_integer; indx binary_integer;
697: begin
698:

Line 695: ddx_pamv_rec okl_pam_pvt.okl_pamv_rec;

691: )
692:
693: as
694: ddp_pamv_rec okl_pam_pvt.okl_pamv_rec;
695: ddx_pamv_rec okl_pam_pvt.okl_pamv_rec;
696: ddindx binary_integer; indx binary_integer;
697: begin
698:
699: -- copy data to the local IN or IN-OUT args, if any

Line 740: okl_pam_pvt.insert_row(p_api_version,

736: ddp_pamv_rec.adj_mat_desc := p5_a31;
737:
738:
739: -- here's the delegated call to the old PL/SQL routine
740: okl_pam_pvt.insert_row(p_api_version,
741: p_init_msg_list,
742: x_return_status,
743: x_msg_count,
744: x_msg_data,

Line 861: ddp_pamv_tbl okl_pam_pvt.okl_pamv_tbl;

857: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_2000
858: )
859:
860: as
861: ddp_pamv_tbl okl_pam_pvt.okl_pamv_tbl;
862: ddx_pamv_tbl okl_pam_pvt.okl_pamv_tbl;
863: ddindx binary_integer; indx binary_integer;
864: begin
865:

Line 862: ddx_pamv_tbl okl_pam_pvt.okl_pamv_tbl;

858: )
859:
860: as
861: ddp_pamv_tbl okl_pam_pvt.okl_pamv_tbl;
862: ddx_pamv_tbl okl_pam_pvt.okl_pamv_tbl;
863: ddindx binary_integer; indx binary_integer;
864: begin
865:
866: -- copy data to the local IN or IN-OUT args, if any

Line 872: okl_pam_pvt_w.rosetta_table_copy_in_p1(ddp_pamv_tbl, p5_a0

868:
869:
870:
871:
872: okl_pam_pvt_w.rosetta_table_copy_in_p1(ddp_pamv_tbl, p5_a0
873: , p5_a1
874: , p5_a2
875: , p5_a3
876: , p5_a4

Line 908: okl_pam_pvt.insert_row(p_api_version,

904: );
905:
906:
907: -- here's the delegated call to the old PL/SQL routine
908: okl_pam_pvt.insert_row(p_api_version,
909: p_init_msg_list,
910: x_return_status,
911: x_msg_count,
912: x_msg_data,

Line 923: okl_pam_pvt_w.rosetta_table_copy_out_p1(ddx_pamv_tbl, p6_a0

919:
920:
921:
922:
923: okl_pam_pvt_w.rosetta_table_copy_out_p1(ddx_pamv_tbl, p6_a0
924: , p6_a1
925: , p6_a2
926: , p6_a3
927: , p6_a4

Line 1030: ddp_pamv_rec okl_pam_pvt.okl_pamv_rec;

1026: , p6_a31 out nocopy VARCHAR2
1027: )
1028:
1029: as
1030: ddp_pamv_rec okl_pam_pvt.okl_pamv_rec;
1031: ddx_pamv_rec okl_pam_pvt.okl_pamv_rec;
1032: ddindx binary_integer; indx binary_integer;
1033: begin
1034:

Line 1031: ddx_pamv_rec okl_pam_pvt.okl_pamv_rec;

1027: )
1028:
1029: as
1030: ddp_pamv_rec okl_pam_pvt.okl_pamv_rec;
1031: ddx_pamv_rec okl_pam_pvt.okl_pamv_rec;
1032: ddindx binary_integer; indx binary_integer;
1033: begin
1034:
1035: -- copy data to the local IN or IN-OUT args, if any

Line 1076: okl_pam_pvt.update_row(p_api_version,

1072: ddp_pamv_rec.adj_mat_desc := p5_a31;
1073:
1074:
1075: -- here's the delegated call to the old PL/SQL routine
1076: okl_pam_pvt.update_row(p_api_version,
1077: p_init_msg_list,
1078: x_return_status,
1079: x_msg_count,
1080: x_msg_data,

Line 1197: ddp_pamv_tbl okl_pam_pvt.okl_pamv_tbl;

1193: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1194: )
1195:
1196: as
1197: ddp_pamv_tbl okl_pam_pvt.okl_pamv_tbl;
1198: ddx_pamv_tbl okl_pam_pvt.okl_pamv_tbl;
1199: ddindx binary_integer; indx binary_integer;
1200: begin
1201:

Line 1198: ddx_pamv_tbl okl_pam_pvt.okl_pamv_tbl;

1194: )
1195:
1196: as
1197: ddp_pamv_tbl okl_pam_pvt.okl_pamv_tbl;
1198: ddx_pamv_tbl okl_pam_pvt.okl_pamv_tbl;
1199: ddindx binary_integer; indx binary_integer;
1200: begin
1201:
1202: -- copy data to the local IN or IN-OUT args, if any

Line 1208: okl_pam_pvt_w.rosetta_table_copy_in_p1(ddp_pamv_tbl, p5_a0

1204:
1205:
1206:
1207:
1208: okl_pam_pvt_w.rosetta_table_copy_in_p1(ddp_pamv_tbl, p5_a0
1209: , p5_a1
1210: , p5_a2
1211: , p5_a3
1212: , p5_a4

Line 1244: okl_pam_pvt.update_row(p_api_version,

1240: );
1241:
1242:
1243: -- here's the delegated call to the old PL/SQL routine
1244: okl_pam_pvt.update_row(p_api_version,
1245: p_init_msg_list,
1246: x_return_status,
1247: x_msg_count,
1248: x_msg_data,

Line 1259: okl_pam_pvt_w.rosetta_table_copy_out_p1(ddx_pamv_tbl, p6_a0

1255:
1256:
1257:
1258:
1259: okl_pam_pvt_w.rosetta_table_copy_out_p1(ddx_pamv_tbl, p6_a0
1260: , p6_a1
1261: , p6_a2
1262: , p6_a3
1263: , p6_a4

Line 1334: ddp_pamv_rec okl_pam_pvt.okl_pamv_rec;

1330: , p5_a31 VARCHAR2
1331: )
1332:
1333: as
1334: ddp_pamv_rec okl_pam_pvt.okl_pamv_rec;
1335: ddindx binary_integer; indx binary_integer;
1336: begin
1337:
1338: -- copy data to the local IN or IN-OUT args, if any

Line 1378: okl_pam_pvt.delete_row(p_api_version,

1374: ddp_pamv_rec.adj_mat_name := p5_a30;
1375: ddp_pamv_rec.adj_mat_desc := p5_a31;
1376:
1377: -- here's the delegated call to the old PL/SQL routine
1378: okl_pam_pvt.delete_row(p_api_version,
1379: p_init_msg_list,
1380: x_return_status,
1381: x_msg_count,
1382: x_msg_data,

Line 1433: ddp_pamv_tbl okl_pam_pvt.okl_pamv_tbl;

1429: , p5_a31 JTF_VARCHAR2_TABLE_2000
1430: )
1431:
1432: as
1433: ddp_pamv_tbl okl_pam_pvt.okl_pamv_tbl;
1434: ddindx binary_integer; indx binary_integer;
1435: begin
1436:
1437: -- copy data to the local IN or IN-OUT args, if any

Line 1443: okl_pam_pvt_w.rosetta_table_copy_in_p1(ddp_pamv_tbl, p5_a0

1439:
1440:
1441:
1442:
1443: okl_pam_pvt_w.rosetta_table_copy_in_p1(ddp_pamv_tbl, p5_a0
1444: , p5_a1
1445: , p5_a2
1446: , p5_a3
1447: , p5_a4

Line 1478: okl_pam_pvt.delete_row(p_api_version,

1474: , p5_a31
1475: );
1476:
1477: -- here's the delegated call to the old PL/SQL routine
1478: okl_pam_pvt.delete_row(p_api_version,
1479: p_init_msg_list,
1480: x_return_status,
1481: x_msg_count,
1482: x_msg_data,

Line 1493: end okl_pam_pvt_w;

1489:
1490:
1491: end;
1492:
1493: end okl_pam_pvt_w;