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_IMPORT_SL_PVT dependencies on AS_SALES_LEADS_PUB

Line 530: pAsslRec in OUT NOCOPY as_sales_leads_pub.sales_lead_rec_type,

526: pHzcpRec in OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
527: pHzpsRec in OUT NOCOPY hz_party_site_v2pub.party_site_rec_type,
528: pHzocRec in OUT NOCOPY hz_party_contact_v2pub.org_contact_rec_type,
529: -- pHocrRec in out hz_party_pub.org_contact_role_rec_type,
530: pAsslRec in OUT NOCOPY as_sales_leads_pub.sales_lead_rec_type,
531: pAssllTbl in OUT NOCOPY as_sales_leads_pub.sales_lead_line_tbl_type,
532: pAsslcTbl in OUT NOCOPY as_sales_leads_pub.sales_lead_contact_tbl_type,
533: pEntity in varchar2,
534: pIId in Number,

Line 531: pAssllTbl in OUT NOCOPY as_sales_leads_pub.sales_lead_line_tbl_type,

527: pHzpsRec in OUT NOCOPY hz_party_site_v2pub.party_site_rec_type,
528: pHzocRec in OUT NOCOPY hz_party_contact_v2pub.org_contact_rec_type,
529: -- pHocrRec in out hz_party_pub.org_contact_role_rec_type,
530: pAsslRec in OUT NOCOPY as_sales_leads_pub.sales_lead_rec_type,
531: pAssllTbl in OUT NOCOPY as_sales_leads_pub.sales_lead_line_tbl_type,
532: pAsslcTbl in OUT NOCOPY as_sales_leads_pub.sales_lead_contact_tbl_type,
533: pEntity in varchar2,
534: pIId in Number,
535: G_return_status OUT NOCOPY varchar2)

Line 532: pAsslcTbl in OUT NOCOPY as_sales_leads_pub.sales_lead_contact_tbl_type,

528: pHzocRec in OUT NOCOPY hz_party_contact_v2pub.org_contact_rec_type,
529: -- pHocrRec in out hz_party_pub.org_contact_role_rec_type,
530: pAsslRec in OUT NOCOPY as_sales_leads_pub.sales_lead_rec_type,
531: pAssllTbl in OUT NOCOPY as_sales_leads_pub.sales_lead_line_tbl_type,
532: pAsslcTbl in OUT NOCOPY as_sales_leads_pub.sales_lead_contact_tbl_type,
533: pEntity in varchar2,
534: pIId in Number,
535: G_return_status OUT NOCOPY varchar2)
536: IS

Line 896: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;

892: l_dummy_rec2 hz_location_v2pub.location_rec_type;
893: l_dummy_rec3 hz_contact_point_v2pub.contact_point_rec_type;
894: l_dummy_rec4 hz_party_site_v2pub.party_site_rec_type;
895: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_type;
896: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;
897: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;
898: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;
899:
900: Begin

Line 897: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;

893: l_dummy_rec3 hz_contact_point_v2pub.contact_point_rec_type;
894: l_dummy_rec4 hz_party_site_v2pub.party_site_rec_type;
895: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_type;
896: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;
897: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;
898: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;
899:
900: Begin
901: -- Assigning HZ_PARTY_V2PUB.person_rec_type

Line 898: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;

894: l_dummy_rec4 hz_party_site_v2pub.party_site_rec_type;
895: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_type;
896: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;
897: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;
898: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;
899:
900: Begin
901: -- Assigning HZ_PARTY_V2PUB.person_rec_type
902: -- Srikanth March 13th 2001: Per Mrinal, OSO and OTS UI

Line 1295: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;

1291: l_dummy_rec3 hz_contact_point_v2pub.contact_point_rec_type;
1292: l_dummy_rec4 hz_party_site_v2pub.party_site_rec_type;
1293: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_type;
1294: --l_dummy_rec6 hz_party_pub.org_contact_role_rec_type;
1295: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;
1296: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;
1297: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;
1298:
1299: Begin

Line 1296: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;

1292: l_dummy_rec4 hz_party_site_v2pub.party_site_rec_type;
1293: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_type;
1294: --l_dummy_rec6 hz_party_pub.org_contact_role_rec_type;
1295: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;
1296: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;
1297: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;
1298:
1299: Begin
1300: -- swkhanna 8/13 - check for duplicate contact_points

Line 1297: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;

1293: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_type;
1294: --l_dummy_rec6 hz_party_pub.org_contact_role_rec_type;
1295: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;
1296: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;
1297: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;
1298:
1299: Begin
1300: -- swkhanna 8/13 - check for duplicate contact_points
1301: -- cont_pnt_dedupe(pI,l_dup_phone,l_dup_email, l_dup_fax, l_dup_url ) ;

Line 1726: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;

1722: l_dummy_rec3 hz_contact_point_v2pub.contact_point_rec_type;
1723: l_dummy_rec4 hz_party_site_v2pub.party_site_rec_type;
1724: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_type;
1725: l_dummy_rec6 hz_party_contact_v2pub.org_contact_role_rec_type;
1726: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;
1727: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;
1728: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;
1729:
1730: Begin

Line 1727: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;

1723: l_dummy_rec4 hz_party_site_v2pub.party_site_rec_type;
1724: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_type;
1725: l_dummy_rec6 hz_party_contact_v2pub.org_contact_role_rec_type;
1726: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;
1727: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;
1728: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;
1729:
1730: Begin
1731:

Line 1728: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;

1724: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_type;
1725: l_dummy_rec6 hz_party_contact_v2pub.org_contact_role_rec_type;
1726: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;
1727: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;
1728: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;
1729:
1730: Begin
1731:
1732: -- Assigning the HZ_LOCATION_PUB.LOCATION_REC_TYPE

Line 1838: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;

1834: l_dummy_rec3 hz_contact_point_v2pub.contact_point_rec_type;
1835: l_dummy_rec4 hz_party_site_v2pub.party_site_rec_type;
1836: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_type;
1837: l_dummy_rec6 hz_party_contact_v2pub.org_contact_role_rec_type;
1838: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;
1839: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;
1840: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;
1841:
1842: Begin

Line 1839: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;

1835: l_dummy_rec4 hz_party_site_v2pub.party_site_rec_type;
1836: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_type;
1837: l_dummy_rec6 hz_party_contact_v2pub.org_contact_role_rec_type;
1838: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;
1839: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;
1840: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;
1841:
1842: Begin
1843: -- Assining HZ_PARTY_V2PUB.organization_rec_type

Line 1840: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;

1836: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_type;
1837: l_dummy_rec6 hz_party_contact_v2pub.org_contact_role_rec_type;
1838: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;
1839: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;
1840: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;
1841:
1842: Begin
1843: -- Assining HZ_PARTY_V2PUB.organization_rec_type
1844: l_org_rec.organization_name := pI.customer_name;

Line 1951: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;

1947: l_dummy_rec3 hz_contact_point_v2pub.contact_point_rec_type;
1948: --l_dummy_rec4 hz_party_pub.party_site_rec_type;
1949: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_type;
1950: l_dummy_rec6 hz_party_contact_v2pub.org_contact_role_rec_type;
1951: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;
1952: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;
1953: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;
1954:
1955: Begin

Line 1952: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;

1948: --l_dummy_rec4 hz_party_pub.party_site_rec_type;
1949: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_type;
1950: l_dummy_rec6 hz_party_contact_v2pub.org_contact_role_rec_type;
1951: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;
1952: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;
1953: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;
1954:
1955: Begin
1956: -- l_ps_rec.party_id := pI.party_id;

Line 1953: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;

1949: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_type;
1950: l_dummy_rec6 hz_party_contact_v2pub.org_contact_role_rec_type;
1951: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;
1952: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;
1953: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;
1954:
1955: Begin
1956: -- l_ps_rec.party_id := pI.party_id;
1957: l_ps_rec.party_id := p_party_id;

Line 2081: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;

2077: l_dummy_rec3 hz_contact_point_v2pub.contact_point_rec_type;
2078: l_dummy_rec4 hz_party_site_v2pub.party_site_rec_type;
2079: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_type;
2080: l_dummy_rec6 hz_party_contact_v2pub.org_contact_role_rec_type;
2081: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;
2082: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;
2083: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;
2084:
2085: cursor c_cnt_role (c_import_interface_id NUMBER) is

Line 2082: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;

2078: l_dummy_rec4 hz_party_site_v2pub.party_site_rec_type;
2079: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_type;
2080: l_dummy_rec6 hz_party_contact_v2pub.org_contact_role_rec_type;
2081: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;
2082: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;
2083: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;
2084:
2085: cursor c_cnt_role (c_import_interface_id NUMBER) is
2086: select * from AS_IMP_CNT_ROL_INTERFACE

Line 2083: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;

2079: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_type;
2080: l_dummy_rec6 hz_party_contact_v2pub.org_contact_role_rec_type;
2081: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;
2082: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;
2083: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;
2084:
2085: cursor c_cnt_role (c_import_interface_id NUMBER) is
2086: select * from AS_IMP_CNT_ROL_INTERFACE
2087: where import_interface_id = c_import_interface_id;

Line 2329: -- calls as_sales_leads_pub.create_sales_lead

2325:
2326: ----------------------------------------------------------
2327: -- name: do_create_saleslead
2328: -- scope: private
2329: -- calls as_sales_leads_pub.create_sales_lead
2330: -- inserts sales lead header and lines
2331: ----------------------------------------------------------
2332: procedure do_create_saleslead( pI IN OUT NOCOPY leadImpType,
2333: G_return_status OUT NOCOPY varchar2)

Line 2335: l_sales_lead_rec as_sales_leads_pub.sales_lead_rec_type;

2331: ----------------------------------------------------------
2332: procedure do_create_saleslead( pI IN OUT NOCOPY leadImpType,
2333: G_return_status OUT NOCOPY varchar2)
2334: IS
2335: l_sales_lead_rec as_sales_leads_pub.sales_lead_rec_type;
2336: l_sales_lead_line_rec as_sales_leads_pub.sales_lead_line_rec_type;
2337: l_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
2338: l_sales_lead_contact_rec as_sales_leads_pub.sales_lead_contact_rec_type;
2339: l_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;

Line 2336: l_sales_lead_line_rec as_sales_leads_pub.sales_lead_line_rec_type;

2332: procedure do_create_saleslead( pI IN OUT NOCOPY leadImpType,
2333: G_return_status OUT NOCOPY varchar2)
2334: IS
2335: l_sales_lead_rec as_sales_leads_pub.sales_lead_rec_type;
2336: l_sales_lead_line_rec as_sales_leads_pub.sales_lead_line_rec_type;
2337: l_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
2338: l_sales_lead_contact_rec as_sales_leads_pub.sales_lead_contact_rec_type;
2339: l_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
2340: l_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;

Line 2337: l_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;

2333: G_return_status OUT NOCOPY varchar2)
2334: IS
2335: l_sales_lead_rec as_sales_leads_pub.sales_lead_rec_type;
2336: l_sales_lead_line_rec as_sales_leads_pub.sales_lead_line_rec_type;
2337: l_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
2338: l_sales_lead_contact_rec as_sales_leads_pub.sales_lead_contact_rec_type;
2339: l_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
2340: l_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
2341: l_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;

Line 2338: l_sales_lead_contact_rec as_sales_leads_pub.sales_lead_contact_rec_type;

2334: IS
2335: l_sales_lead_rec as_sales_leads_pub.sales_lead_rec_type;
2336: l_sales_lead_line_rec as_sales_leads_pub.sales_lead_line_rec_type;
2337: l_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
2338: l_sales_lead_contact_rec as_sales_leads_pub.sales_lead_contact_rec_type;
2339: l_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
2340: l_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
2341: l_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;
2342: l_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;

Line 2339: l_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;

2335: l_sales_lead_rec as_sales_leads_pub.sales_lead_rec_type;
2336: l_sales_lead_line_rec as_sales_leads_pub.sales_lead_line_rec_type;
2337: l_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
2338: l_sales_lead_contact_rec as_sales_leads_pub.sales_lead_contact_rec_type;
2339: l_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
2340: l_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
2341: l_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;
2342: l_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
2343: l_sales_lead_id NUMBER;

Line 2340: l_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;

2336: l_sales_lead_line_rec as_sales_leads_pub.sales_lead_line_rec_type;
2337: l_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
2338: l_sales_lead_contact_rec as_sales_leads_pub.sales_lead_contact_rec_type;
2339: l_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
2340: l_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
2341: l_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;
2342: l_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
2343: l_sales_lead_id NUMBER;
2344: l_msg_data VARCHAR2(2000) := NULL;

Line 2341: l_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;

2337: l_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
2338: l_sales_lead_contact_rec as_sales_leads_pub.sales_lead_contact_rec_type;
2339: l_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
2340: l_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
2341: l_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;
2342: l_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
2343: l_sales_lead_id NUMBER;
2344: l_msg_data VARCHAR2(2000) := NULL;
2345: l_api_message VARCHAR2(2000);

Line 2364: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;

2360: l_dummy_rec3 hz_contact_point_v2pub.contact_point_rec_type;
2361: l_dummy_rec4 hz_party_site_v2pub.party_site_rec_type;
2362: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_type;
2363: l_dummy_rec6 hz_party_contact_v2pub.org_contact_role_rec_type;
2364: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;
2365: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;
2366: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;
2367:
2368: CURSOR c_get_source_code (c_promotion_id number) IS

Line 2365: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;

2361: l_dummy_rec4 hz_party_site_v2pub.party_site_rec_type;
2362: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_type;
2363: l_dummy_rec6 hz_party_contact_v2pub.org_contact_role_rec_type;
2364: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;
2365: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;
2366: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;
2367:
2368: CURSOR c_get_source_code (c_promotion_id number) IS
2369: SELECT source_code_id, source_code

Line 2366: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;

2362: l_dummy_rec5 hz_party_contact_v2pub.org_contact_rec_type;
2363: l_dummy_rec6 hz_party_contact_v2pub.org_contact_role_rec_type;
2364: l_dummy_rec7 as_sales_leads_pub.sales_lead_rec_type;
2365: l_dummy_tbl8 as_sales_leads_pub.sales_lead_line_tbl_type;
2366: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;
2367:
2368: CURSOR c_get_source_code (c_promotion_id number) IS
2369: SELECT source_code_id, source_code
2370: FROM ams_p_source_codes_v

Line 4055: l_lead_engines_out_rec AS_SALES_LEADS_PUB.LEAD_ENGINES_OUT_Rec_Type;

4051: p_dup_email varchar2(1):= 'N';
4052: p_dup_fax varchar2(1):= 'N';
4053: p_dup_url varchar2(1):= 'N';
4054:
4055: l_lead_engines_out_rec AS_SALES_LEADS_PUB.LEAD_ENGINES_OUT_Rec_Type;
4056: l_error_type varchar2(100);
4057: l_group_id number;
4058:
4059: -- Bugfix for concurrency control

Line 4134: l_sales_lead_rec as_sales_leads_pub.sales_lead_rec_type;

4130: AND ROWNUM < 2;
4131:
4132: l_currency_code VARCHAR2(15);
4133: l_isQualified VARCHAR2(1);
4134: l_sales_lead_rec as_sales_leads_pub.sales_lead_rec_type;
4135: l_sales_lead_log_id NUMBER;
4136: x_sales_team_flag VARCHAR2(1);
4137: l_curr_time VARCHAR2(15);
4138: