[Home] [Help]
1: package body ams_listheader_pvt_w as
2: /* $Header: amswlshb.pls 115.20 2004/02/04 01:34:45 vbhandar 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:
138: , p7_a108 VARCHAR2 := fnd_api.g_miss_char
139: )
140:
141: as
142: ddp_listheader_rec ams_listheader_pvt.list_header_rec_type;
143: ddindx binary_integer; indx binary_integer;
144: begin
145:
146: -- copy data to the local IN or IN-OUT args, if any
262: ddp_listheader_rec.apply_traffic_cop := p7_a108;
263:
264:
265: -- here's the delegated call to the old PL/SQL routine
266: ams_listheader_pvt.create_listheader(p_api_version,
267: p_init_msg_list,
268: p_commit,
269: p_validation_level,
270: x_return_status,
402: , p7_a108 VARCHAR2 := fnd_api.g_miss_char
403: )
404:
405: as
406: ddp_listheader_rec ams_listheader_pvt.list_header_rec_type;
407: ddindx binary_integer; indx binary_integer;
408: begin
409:
410: -- copy data to the local IN or IN-OUT args, if any
525: ddp_listheader_rec.no_of_rows_prev_contacted := rosetta_g_miss_num_map(p7_a107);
526: ddp_listheader_rec.apply_traffic_cop := p7_a108;
527:
528: -- here's the delegated call to the old PL/SQL routine
529: ams_listheader_pvt.update_listheader(p_api_version,
530: p_init_msg_list,
531: p_commit,
532: p_validation_level,
533: x_return_status,
662: , p6_a108 VARCHAR2 := fnd_api.g_miss_char
663: )
664:
665: as
666: ddp_listheader_rec ams_listheader_pvt.list_header_rec_type;
667: ddindx binary_integer; indx binary_integer;
668: begin
669:
670: -- copy data to the local IN or IN-OUT args, if any
784: ddp_listheader_rec.no_of_rows_prev_contacted := rosetta_g_miss_num_map(p6_a107);
785: ddp_listheader_rec.apply_traffic_cop := p6_a108;
786:
787: -- here's the delegated call to the old PL/SQL routine
788: ams_listheader_pvt.validate_listheader(p_api_version,
789: p_init_msg_list,
790: p_validation_level,
791: x_return_status,
792: x_msg_count,
915: , p0_a108 VARCHAR2 := fnd_api.g_miss_char
916: )
917:
918: as
919: ddp_listheader_rec ams_listheader_pvt.list_header_rec_type;
920: ddindx binary_integer; indx binary_integer;
921: begin
922:
923: -- copy data to the local IN or IN-OUT args, if any
1033:
1034:
1035:
1036: -- here's the delegated call to the old PL/SQL routine
1037: ams_listheader_pvt.validate_list_items(ddp_listheader_rec,
1038: p_validation_mode,
1039: x_return_status);
1040:
1041: -- copy data back from the local variables to OUT or IN-OUT args, if any
1264: , p1_a108 VARCHAR2 := fnd_api.g_miss_char
1265: )
1266:
1267: as
1268: ddp_listheader_rec ams_listheader_pvt.list_header_rec_type;
1269: ddp_complete_rec ams_listheader_pvt.list_header_rec_type;
1270: ddindx binary_integer; indx binary_integer;
1271: begin
1272:
1265: )
1266:
1267: as
1268: ddp_listheader_rec ams_listheader_pvt.list_header_rec_type;
1269: ddp_complete_rec ams_listheader_pvt.list_header_rec_type;
1270: ddindx binary_integer; indx binary_integer;
1271: begin
1272:
1273: -- copy data to the local IN or IN-OUT args, if any
1492: ddp_complete_rec.apply_traffic_cop := p1_a108;
1493:
1494:
1495: -- here's the delegated call to the old PL/SQL routine
1496: ams_listheader_pvt.validate_list_record(ddp_listheader_rec,
1497: ddp_complete_rec,
1498: x_return_status);
1499:
1500: -- copy data back from the local variables to OUT or IN-OUT args, if any
1613: , p0_a108 out nocopy VARCHAR2
1614: )
1615:
1616: as
1617: ddx_listheader_rec ams_listheader_pvt.list_header_rec_type;
1618: ddindx binary_integer; indx binary_integer;
1619: begin
1620:
1621: -- copy data to the local IN or IN-OUT args, if any
1620:
1621: -- copy data to the local IN or IN-OUT args, if any
1622:
1623: -- here's the delegated call to the old PL/SQL routine
1624: ams_listheader_pvt.init_listheader_rec(ddx_listheader_rec);
1625:
1626: -- copy data back from the local variables to OUT or IN-OUT args, if any
1627: p0_a0 := rosetta_g_miss_num_map(ddx_listheader_rec.list_header_id);
1628: p0_a1 := ddx_listheader_rec.last_update_date;
1955: , p0_a108 VARCHAR2 := fnd_api.g_miss_char
1956: )
1957:
1958: as
1959: ddp_listheader_rec ams_listheader_pvt.list_header_rec_type;
1960: ddx_complete_rec ams_listheader_pvt.list_header_rec_type;
1961: ddindx binary_integer; indx binary_integer;
1962: begin
1963:
1956: )
1957:
1958: as
1959: ddp_listheader_rec ams_listheader_pvt.list_header_rec_type;
1960: ddx_complete_rec ams_listheader_pvt.list_header_rec_type;
1961: ddindx binary_integer; indx binary_integer;
1962: begin
1963:
1964: -- copy data to the local IN or IN-OUT args, if any
2073: ddp_listheader_rec.apply_traffic_cop := p0_a108;
2074:
2075:
2076: -- here's the delegated call to the old PL/SQL routine
2077: ams_listheader_pvt.complete_listheader_rec(ddp_listheader_rec,
2078: ddx_complete_rec);
2079:
2080: -- copy data back from the local variables to OUT or IN-OUT args, if any
2081:
2215:
2216:
2217:
2218: -- here's the delegated call to the old PL/SQL routine
2219: ams_listheader_pvt.update_prev_contacted_count(p_used_by_id,
2220: p_used_by,
2221: ddp_last_contacted_date,
2222: p_init_msg_list,
2223: p_commit,
2358: , p8_a108 VARCHAR2 := fnd_api.g_miss_char
2359: )
2360:
2361: as
2362: ddp_listheader_rec ams_listheader_pvt.list_header_rec_type;
2363: ddindx binary_integer; indx binary_integer;
2364: begin
2365:
2366: -- copy data to the local IN or IN-OUT args, if any
2486:
2487:
2488:
2489: -- here's the delegated call to the old PL/SQL routine
2490: ams_listheader_pvt.copy_list(p_api_version,
2491: p_init_msg_list,
2492: p_commit,
2493: p_validation_level,
2494: x_return_status,
2515:
2516:
2517: end;
2518:
2519: end ams_listheader_pvt_w;