eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_SALES_LEADS_PUB_W dependencies on AS_SALES_LEADS_PUB

Line 1: package body as_sales_leads_pub_w as

1: package body as_sales_leads_pub_w as
2: /* $Header: asxwslmb.pls 115.14 2003/09/18 22:44:07 ckapoor 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:

Line 22: procedure rosetta_table_copy_in_p3(t out nocopy as_sales_leads_pub.sales_lead_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_p3(t out nocopy as_sales_leads_pub.sales_lead_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_DATE_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 225: procedure rosetta_table_copy_out_p3(t as_sales_leads_pub.sales_lead_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

221: end loop;
222: end if;
223: end if;
224: end rosetta_table_copy_in_p3;
225: procedure rosetta_table_copy_out_p3(t as_sales_leads_pub.sales_lead_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
226: , a1 out nocopy JTF_DATE_TABLE
227: , a2 out nocopy JTF_NUMBER_TABLE
228: , a3 out nocopy JTF_DATE_TABLE
229: , a4 out nocopy JTF_NUMBER_TABLE

Line 709: procedure rosetta_table_copy_in_p7(t out nocopy as_sales_leads_pub.sales_lead_line_tbl_type, a0 JTF_NUMBER_TABLE

705: end if;
706: end if;
707: end rosetta_table_copy_out_p3;
708:
709: procedure rosetta_table_copy_in_p7(t out nocopy as_sales_leads_pub.sales_lead_line_tbl_type, a0 JTF_NUMBER_TABLE
710: , a1 JTF_DATE_TABLE
711: , a2 JTF_NUMBER_TABLE
712: , a3 JTF_DATE_TABLE
713: , a4 JTF_NUMBER_TABLE

Line 800: procedure rosetta_table_copy_out_p7(t as_sales_leads_pub.sales_lead_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

796: end loop;
797: end if;
798: end if;
799: end rosetta_table_copy_in_p7;
800: procedure rosetta_table_copy_out_p7(t as_sales_leads_pub.sales_lead_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
801: , a1 out nocopy JTF_DATE_TABLE
802: , a2 out nocopy JTF_NUMBER_TABLE
803: , a3 out nocopy JTF_DATE_TABLE
804: , a4 out nocopy JTF_NUMBER_TABLE

Line 1004: procedure rosetta_table_copy_in_p10(t out nocopy as_sales_leads_pub.sales_lead_line_out_tbl_type, a0 JTF_NUMBER_TABLE

1000: end if;
1001: end if;
1002: end rosetta_table_copy_out_p7;
1003:
1004: procedure rosetta_table_copy_in_p10(t out nocopy as_sales_leads_pub.sales_lead_line_out_tbl_type, a0 JTF_NUMBER_TABLE
1005: , a1 JTF_VARCHAR2_TABLE_100
1006: ) as
1007: ddindx binary_integer; indx binary_integer;
1008: begin

Line 1025: procedure rosetta_table_copy_out_p10(t as_sales_leads_pub.sales_lead_line_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

1021: end loop;
1022: end if;
1023: end if;
1024: end rosetta_table_copy_in_p10;
1025: procedure rosetta_table_copy_out_p10(t as_sales_leads_pub.sales_lead_line_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1026: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1027: ) as
1028: ddindx binary_integer; indx binary_integer;
1029: begin

Line 1054: procedure rosetta_table_copy_in_p13(t out nocopy as_sales_leads_pub.sales_lead_contact_tbl_type, a0 JTF_NUMBER_TABLE

1050: end if;
1051: end if;
1052: end rosetta_table_copy_out_p10;
1053:
1054: procedure rosetta_table_copy_in_p13(t out nocopy as_sales_leads_pub.sales_lead_contact_tbl_type, a0 JTF_NUMBER_TABLE
1055: , a1 JTF_NUMBER_TABLE
1056: , a2 JTF_NUMBER_TABLE
1057: , a3 JTF_DATE_TABLE
1058: , a4 JTF_NUMBER_TABLE

Line 1143: procedure rosetta_table_copy_out_p13(t as_sales_leads_pub.sales_lead_contact_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

1139: end loop;
1140: end if;
1141: end if;
1142: end rosetta_table_copy_in_p13;
1143: procedure rosetta_table_copy_out_p13(t as_sales_leads_pub.sales_lead_contact_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1144: , a1 out nocopy JTF_NUMBER_TABLE
1145: , a2 out nocopy JTF_NUMBER_TABLE
1146: , a3 out nocopy JTF_DATE_TABLE
1147: , a4 out nocopy JTF_NUMBER_TABLE

Line 1342: procedure rosetta_table_copy_in_p16(t out nocopy as_sales_leads_pub.sales_lead_cnt_out_tbl_type, a0 JTF_NUMBER_TABLE

1338: end if;
1339: end if;
1340: end rosetta_table_copy_out_p13;
1341:
1342: procedure rosetta_table_copy_in_p16(t out nocopy as_sales_leads_pub.sales_lead_cnt_out_tbl_type, a0 JTF_NUMBER_TABLE
1343: , a1 JTF_VARCHAR2_TABLE_100
1344: ) as
1345: ddindx binary_integer; indx binary_integer;
1346: begin

Line 1363: procedure rosetta_table_copy_out_p16(t as_sales_leads_pub.sales_lead_cnt_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

1359: end loop;
1360: end if;
1361: end if;
1362: end rosetta_table_copy_in_p16;
1363: procedure rosetta_table_copy_out_p16(t as_sales_leads_pub.sales_lead_cnt_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1364: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1365: ) as
1366: ddindx binary_integer; indx binary_integer;
1367: begin

Line 1392: procedure rosetta_table_copy_in_p19(t out nocopy as_sales_leads_pub.assign_id_tbl_type, a0 JTF_NUMBER_TABLE

1388: end if;
1389: end if;
1390: end rosetta_table_copy_out_p16;
1391:
1392: procedure rosetta_table_copy_in_p19(t out nocopy as_sales_leads_pub.assign_id_tbl_type, a0 JTF_NUMBER_TABLE
1393: , a1 JTF_NUMBER_TABLE
1394: ) as
1395: ddindx binary_integer; indx binary_integer;
1396: begin

Line 1413: procedure rosetta_table_copy_out_p19(t as_sales_leads_pub.assign_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

1409: end loop;
1410: end if;
1411: end if;
1412: end rosetta_table_copy_in_p19;
1413: procedure rosetta_table_copy_out_p19(t as_sales_leads_pub.assign_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1414: , a1 out nocopy JTF_NUMBER_TABLE
1415: ) as
1416: ddindx binary_integer; indx binary_integer;
1417: begin

Line 1630: ddp_sales_lead_rec as_sales_leads_pub.sales_lead_rec_type;

1626: )
1627:
1628: as
1629: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
1630: ddp_sales_lead_rec as_sales_leads_pub.sales_lead_rec_type;
1631: ddp_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
1632: ddp_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
1633: ddx_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
1634: ddx_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;

Line 1631: ddp_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;

1627:
1628: as
1629: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
1630: ddp_sales_lead_rec as_sales_leads_pub.sales_lead_rec_type;
1631: ddp_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
1632: ddp_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
1633: ddx_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
1634: ddx_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;
1635: ddindx binary_integer; indx binary_integer;

Line 1632: ddp_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;

1628: as
1629: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
1630: ddp_sales_lead_rec as_sales_leads_pub.sales_lead_rec_type;
1631: ddp_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
1632: ddp_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
1633: ddx_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
1634: ddx_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;
1635: ddindx binary_integer; indx binary_integer;
1636: begin

Line 1633: ddx_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;

1629: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
1630: ddp_sales_lead_rec as_sales_leads_pub.sales_lead_rec_type;
1631: ddp_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
1632: ddp_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
1633: ddx_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
1634: ddx_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;
1635: ddindx binary_integer; indx binary_integer;
1636: begin
1637:

Line 1634: ddx_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;

1630: ddp_sales_lead_rec as_sales_leads_pub.sales_lead_rec_type;
1631: ddp_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
1632: ddp_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
1633: ddx_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
1634: ddx_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;
1635: ddindx binary_integer; indx binary_integer;
1636: begin
1637:
1638: -- copy data to the local IN or IN-OUT args, if any

Line 1745: as_sales_leads_pub_w.rosetta_table_copy_in_p7(ddp_sales_lead_line_tbl, p10_a0

1741: ddp_sales_lead_rec.source_secondary_reference := p9_a90;
1742: ddp_sales_lead_rec.sales_methodology_id := rosetta_g_miss_num_map(p9_a91);
1743: ddp_sales_lead_rec.sales_stage_id := rosetta_g_miss_num_map(p9_a92);
1744:
1745: as_sales_leads_pub_w.rosetta_table_copy_in_p7(ddp_sales_lead_line_tbl, p10_a0
1746: , p10_a1
1747: , p10_a2
1748: , p10_a3
1749: , p10_a4

Line 1784: as_sales_leads_pub_w.rosetta_table_copy_in_p13(ddp_sales_lead_contact_tbl, p11_a0

1780: , p10_a35
1781: , p10_a36
1782: );
1783:
1784: as_sales_leads_pub_w.rosetta_table_copy_in_p13(ddp_sales_lead_contact_tbl, p11_a0
1785: , p11_a1
1786: , p11_a2
1787: , p11_a3
1788: , p11_a4

Line 1829: as_sales_leads_pub.create_sales_lead(p_api_version_number,

1825:
1826:
1827:
1828: -- here's the delegated call to the old PL/SQL routine
1829: as_sales_leads_pub.create_sales_lead(p_api_version_number,
1830: p_init_msg_list,
1831: p_commit,
1832: p_validation_level,
1833: p_check_access_flag,

Line 1862: as_sales_leads_pub_w.rosetta_table_copy_out_p10(ddx_sales_lead_line_out_tbl, p13_a0

1858:
1859:
1860:
1861:
1862: as_sales_leads_pub_w.rosetta_table_copy_out_p10(ddx_sales_lead_line_out_tbl, p13_a0
1863: , p13_a1
1864: );
1865:
1866: as_sales_leads_pub_w.rosetta_table_copy_out_p16(ddx_sales_lead_cnt_out_tbl, p14_a0

Line 1866: as_sales_leads_pub_w.rosetta_table_copy_out_p16(ddx_sales_lead_cnt_out_tbl, p14_a0

1862: as_sales_leads_pub_w.rosetta_table_copy_out_p10(ddx_sales_lead_line_out_tbl, p13_a0
1863: , p13_a1
1864: );
1865:
1866: as_sales_leads_pub_w.rosetta_table_copy_out_p16(ddx_sales_lead_cnt_out_tbl, p14_a0
1867: , p14_a1
1868: );
1869:
1870:

Line 1984: ddp_sales_lead_rec as_sales_leads_pub.sales_lead_rec_type;

1980: )
1981:
1982: as
1983: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
1984: ddp_sales_lead_rec as_sales_leads_pub.sales_lead_rec_type;
1985: ddindx binary_integer; indx binary_integer;
1986: begin
1987:
1988: -- copy data to the local IN or IN-OUT args, if any

Line 2099: as_sales_leads_pub.update_sales_lead(p_api_version_number,

2095:
2096:
2097:
2098: -- here's the delegated call to the old PL/SQL routine
2099: as_sales_leads_pub.update_sales_lead(p_api_version_number,
2100: p_init_msg_list,
2101: p_commit,
2102: p_validation_level,
2103: p_check_access_flag,

Line 2185: ddp_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;

2181: )
2182:
2183: as
2184: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
2185: ddp_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
2186: ddx_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
2187: ddindx binary_integer; indx binary_integer;
2188: begin
2189:

Line 2186: ddx_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;

2182:
2183: as
2184: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
2185: ddp_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
2186: ddx_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
2187: ddindx binary_integer; indx binary_integer;
2188: begin
2189:
2190: -- copy data to the local IN or IN-OUT args, if any

Line 2203: as_sales_leads_pub_w.rosetta_table_copy_in_p7(ddp_sales_lead_line_tbl, p9_a0

2199: as_utility_pub_w.rosetta_table_copy_in_p6(ddp_sales_lead_profile_tbl, p8_a0
2200: , p8_a1
2201: );
2202:
2203: as_sales_leads_pub_w.rosetta_table_copy_in_p7(ddp_sales_lead_line_tbl, p9_a0
2204: , p9_a1
2205: , p9_a2
2206: , p9_a3
2207: , p9_a4

Line 2248: as_sales_leads_pub.create_sales_lead_lines(p_api_version_number,

2244:
2245:
2246:
2247: -- here's the delegated call to the old PL/SQL routine
2248: as_sales_leads_pub.create_sales_lead_lines(p_api_version_number,
2249: p_init_msg_list,
2250: p_commit,
2251: p_validation_level,
2252: p_check_access_flag,

Line 2276: as_sales_leads_pub_w.rosetta_table_copy_out_p10(ddx_sales_lead_line_out_tbl, p11_a0

2272:
2273:
2274:
2275:
2276: as_sales_leads_pub_w.rosetta_table_copy_out_p10(ddx_sales_lead_line_out_tbl, p11_a0
2277: , p11_a1
2278: );
2279:
2280:

Line 2340: ddp_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;

2336: )
2337:
2338: as
2339: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
2340: ddp_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
2341: ddx_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
2342: ddindx binary_integer; indx binary_integer;
2343: begin
2344:

Line 2341: ddx_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;

2337:
2338: as
2339: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
2340: ddp_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
2341: ddx_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
2342: ddindx binary_integer; indx binary_integer;
2343: begin
2344:
2345: -- copy data to the local IN or IN-OUT args, if any

Line 2358: as_sales_leads_pub_w.rosetta_table_copy_in_p7(ddp_sales_lead_line_tbl, p9_a0

2354: as_utility_pub_w.rosetta_table_copy_in_p6(ddp_sales_lead_profile_tbl, p8_a0
2355: , p8_a1
2356: );
2357:
2358: as_sales_leads_pub_w.rosetta_table_copy_in_p7(ddp_sales_lead_line_tbl, p9_a0
2359: , p9_a1
2360: , p9_a2
2361: , p9_a3
2362: , p9_a4

Line 2402: as_sales_leads_pub.update_sales_lead_lines(p_api_version_number,

2398:
2399:
2400:
2401: -- here's the delegated call to the old PL/SQL routine
2402: as_sales_leads_pub.update_sales_lead_lines(p_api_version_number,
2403: p_init_msg_list,
2404: p_commit,
2405: p_validation_level,
2406: p_check_access_flag,

Line 2428: as_sales_leads_pub_w.rosetta_table_copy_out_p10(ddx_sales_lead_line_out_tbl, p10_a0

2424:
2425:
2426:
2427:
2428: as_sales_leads_pub_w.rosetta_table_copy_out_p10(ddx_sales_lead_line_out_tbl, p10_a0
2429: , p10_a1
2430: );
2431:
2432:

Line 2492: ddp_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;

2488: )
2489:
2490: as
2491: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
2492: ddp_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
2493: ddx_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
2494: ddindx binary_integer; indx binary_integer;
2495: begin
2496:

Line 2493: ddx_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;

2489:
2490: as
2491: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
2492: ddp_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
2493: ddx_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
2494: ddindx binary_integer; indx binary_integer;
2495: begin
2496:
2497: -- copy data to the local IN or IN-OUT args, if any

Line 2510: as_sales_leads_pub_w.rosetta_table_copy_in_p7(ddp_sales_lead_line_tbl, p9_a0

2506: as_utility_pub_w.rosetta_table_copy_in_p6(ddp_sales_lead_profile_tbl, p8_a0
2507: , p8_a1
2508: );
2509:
2510: as_sales_leads_pub_w.rosetta_table_copy_in_p7(ddp_sales_lead_line_tbl, p9_a0
2511: , p9_a1
2512: , p9_a2
2513: , p9_a3
2514: , p9_a4

Line 2554: as_sales_leads_pub.delete_sales_lead_lines(p_api_version_number,

2550:
2551:
2552:
2553: -- here's the delegated call to the old PL/SQL routine
2554: as_sales_leads_pub.delete_sales_lead_lines(p_api_version_number,
2555: p_init_msg_list,
2556: p_commit,
2557: p_validation_level,
2558: p_check_access_flag,

Line 2580: as_sales_leads_pub_w.rosetta_table_copy_out_p10(ddx_sales_lead_line_out_tbl, p10_a0

2576:
2577:
2578:
2579:
2580: as_sales_leads_pub_w.rosetta_table_copy_out_p10(ddx_sales_lead_line_out_tbl, p10_a0
2581: , p10_a1
2582: );
2583:
2584:

Line 2644: ddp_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;

2640: )
2641:
2642: as
2643: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
2644: ddp_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
2645: ddx_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;
2646: ddindx binary_integer; indx binary_integer;
2647: begin
2648:

Line 2645: ddx_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;

2641:
2642: as
2643: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
2644: ddp_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
2645: ddx_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;
2646: ddindx binary_integer; indx binary_integer;
2647: begin
2648:
2649: -- copy data to the local IN or IN-OUT args, if any

Line 2662: as_sales_leads_pub_w.rosetta_table_copy_in_p13(ddp_sales_lead_contact_tbl, p9_a0

2658: as_utility_pub_w.rosetta_table_copy_in_p6(ddp_sales_lead_profile_tbl, p8_a0
2659: , p8_a1
2660: );
2661:
2662: as_sales_leads_pub_w.rosetta_table_copy_in_p13(ddp_sales_lead_contact_tbl, p9_a0
2663: , p9_a1
2664: , p9_a2
2665: , p9_a3
2666: , p9_a4

Line 2706: as_sales_leads_pub.create_sales_lead_contacts(p_api_version_number,

2702:
2703:
2704:
2705: -- here's the delegated call to the old PL/SQL routine
2706: as_sales_leads_pub.create_sales_lead_contacts(p_api_version_number,
2707: p_init_msg_list,
2708: p_commit,
2709: p_validation_level,
2710: p_check_access_flag,

Line 2734: as_sales_leads_pub_w.rosetta_table_copy_out_p16(ddx_sales_lead_cnt_out_tbl, p11_a0

2730:
2731:
2732:
2733:
2734: as_sales_leads_pub_w.rosetta_table_copy_out_p16(ddx_sales_lead_cnt_out_tbl, p11_a0
2735: , p11_a1
2736: );
2737:
2738:

Line 2797: ddp_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;

2793: )
2794:
2795: as
2796: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
2797: ddp_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
2798: ddx_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;
2799: ddindx binary_integer; indx binary_integer;
2800: begin
2801:

Line 2798: ddx_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;

2794:
2795: as
2796: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
2797: ddp_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
2798: ddx_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;
2799: ddindx binary_integer; indx binary_integer;
2800: begin
2801:
2802: -- copy data to the local IN or IN-OUT args, if any

Line 2815: as_sales_leads_pub_w.rosetta_table_copy_in_p13(ddp_sales_lead_contact_tbl, p9_a0

2811: as_utility_pub_w.rosetta_table_copy_in_p6(ddp_sales_lead_profile_tbl, p8_a0
2812: , p8_a1
2813: );
2814:
2815: as_sales_leads_pub_w.rosetta_table_copy_in_p13(ddp_sales_lead_contact_tbl, p9_a0
2816: , p9_a1
2817: , p9_a2
2818: , p9_a3
2819: , p9_a4

Line 2858: as_sales_leads_pub.update_sales_lead_contacts(p_api_version_number,

2854:
2855:
2856:
2857: -- here's the delegated call to the old PL/SQL routine
2858: as_sales_leads_pub.update_sales_lead_contacts(p_api_version_number,
2859: p_init_msg_list,
2860: p_commit,
2861: p_validation_level,
2862: p_check_access_flag,

Line 2884: as_sales_leads_pub_w.rosetta_table_copy_out_p16(ddx_sales_lead_cnt_out_tbl, p10_a0

2880:
2881:
2882:
2883:
2884: as_sales_leads_pub_w.rosetta_table_copy_out_p16(ddx_sales_lead_cnt_out_tbl, p10_a0
2885: , p10_a1
2886: );
2887:
2888:

Line 2947: ddp_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;

2943: )
2944:
2945: as
2946: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
2947: ddp_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
2948: ddx_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;
2949: ddindx binary_integer; indx binary_integer;
2950: begin
2951:

Line 2948: ddx_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;

2944:
2945: as
2946: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
2947: ddp_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
2948: ddx_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;
2949: ddindx binary_integer; indx binary_integer;
2950: begin
2951:
2952: -- copy data to the local IN or IN-OUT args, if any

Line 2965: as_sales_leads_pub_w.rosetta_table_copy_in_p13(ddp_sales_lead_contact_tbl, p9_a0

2961: as_utility_pub_w.rosetta_table_copy_in_p6(ddp_sales_lead_profile_tbl, p8_a0
2962: , p8_a1
2963: );
2964:
2965: as_sales_leads_pub_w.rosetta_table_copy_in_p13(ddp_sales_lead_contact_tbl, p9_a0
2966: , p9_a1
2967: , p9_a2
2968: , p9_a3
2969: , p9_a4

Line 3008: as_sales_leads_pub.delete_sales_lead_contacts(p_api_version_number,

3004:
3005:
3006:
3007: -- here's the delegated call to the old PL/SQL routine
3008: as_sales_leads_pub.delete_sales_lead_contacts(p_api_version_number,
3009: p_init_msg_list,
3010: p_commit,
3011: p_validation_level,
3012: p_check_access_flag,

Line 3034: as_sales_leads_pub_w.rosetta_table_copy_out_p16(ddx_sales_lead_cnt_out_tbl, p10_a0

3030:
3031:
3032:
3033:
3034: as_sales_leads_pub_w.rosetta_table_copy_out_p16(ddx_sales_lead_cnt_out_tbl, p10_a0
3035: , p10_a1
3036: );
3037:
3038:

Line 3042: end as_sales_leads_pub_w;

3038:
3039:
3040: end;
3041:
3042: end as_sales_leads_pub_w;