APPS.AS_SALES_LEADS_PUB_W dependencies on AS_UTILITY_PUB

Line 1629: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;

1625: , p9_a92 NUMBER := 0-1962.0724
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;

Line 1647: as_utility_pub_w.rosetta_table_copy_in_p6(ddp_sales_lead_profile_tbl, p8_a0

1643:
1644:
1645:
1646:
1647: as_utility_pub_w.rosetta_table_copy_in_p6(ddp_sales_lead_profile_tbl, p8_a0
1648: , p8_a1
1649: );
1650:
1651: ddp_sales_lead_rec.sales_lead_id := rosetta_g_miss_num_map(p9_a0);

Line 1983: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;

1979: , p9_a92 NUMBER := 0-1962.0724
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:

Line 1997: as_utility_pub_w.rosetta_table_copy_in_p6(ddp_sales_lead_profile_tbl, p8_a0

1993:
1994:
1995:
1996:
1997: as_utility_pub_w.rosetta_table_copy_in_p6(ddp_sales_lead_profile_tbl, p8_a0
1998: , p8_a1
1999: );
2000:
2001: ddp_sales_lead_rec.sales_lead_id := rosetta_g_miss_num_map(p9_a0);

Line 2184: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;

2180: , x_msg_data out nocopy VARCHAR2
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

Line 2199: as_utility_pub_w.rosetta_table_copy_in_p6(ddp_sales_lead_profile_tbl, p8_a0

2195:
2196:
2197:
2198:
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

Line 2339: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;

2335: , x_msg_data out nocopy VARCHAR2
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

Line 2354: as_utility_pub_w.rosetta_table_copy_in_p6(ddp_sales_lead_profile_tbl, p8_a0

2350:
2351:
2352:
2353:
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

Line 2491: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;

2487: , x_msg_data out nocopy VARCHAR2
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

Line 2506: as_utility_pub_w.rosetta_table_copy_in_p6(ddp_sales_lead_profile_tbl, p8_a0

2502:
2503:
2504:
2505:
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

Line 2643: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;

2639: , x_msg_data out nocopy VARCHAR2
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

Line 2658: as_utility_pub_w.rosetta_table_copy_in_p6(ddp_sales_lead_profile_tbl, p8_a0

2654:
2655:
2656:
2657:
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

Line 2796: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;

2792: , x_msg_data out nocopy VARCHAR2
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

Line 2811: as_utility_pub_w.rosetta_table_copy_in_p6(ddp_sales_lead_profile_tbl, p8_a0

2807:
2808:
2809:
2810:
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

Line 2946: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;

2942: , x_msg_data out nocopy VARCHAR2
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

Line 2961: as_utility_pub_w.rosetta_table_copy_in_p6(ddp_sales_lead_profile_tbl, p8_a0

2957:
2958:
2959:
2960:
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