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 HZ_PARTY_V2PUB

Line 524: pHzpRec in OUT NOCOPY hz_party_v2pub.party_rec_type,

520: -- 7. AS_SALES_LEAD_LINES
521: -- 8. AS_SALES_LEAD_CONTACTS
522: --------------------------------------------------------
523: procedure do_assign_flex (
524: pHzpRec in OUT NOCOPY hz_party_v2pub.party_rec_type,
525: pHzlRec in OUT NOCOPY hz_location_v2pub.location_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,

Line 884: l_per_rec HZ_PARTY_V2PUB.person_rec_type;

880: pI IN OUT NOCOPY leadImpType,
881: pType IN varchar2,
882: G_return_status OUT NOCOPY varchar2)
883: IS
884: l_per_rec HZ_PARTY_V2PUB.person_rec_type;
885: l_profile number;
886: l_partyNumber number;
887: l_msg_data VARCHAR2(2000);
888:

Line 891: --l_dummy_rec1 hz_party_v2pub.party_rec_type;

887: l_msg_data VARCHAR2(2000);
888:
889: -- aanjaria enh tcav2
890: -- Dummy
891: --l_dummy_rec1 hz_party_v2pub.party_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;

Line 901: -- Assigning HZ_PARTY_V2PUB.person_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
903: -- The current association is
904: -- person_title -- person_pre_name_adjunct
905: -- second title -- person_academic_title

Line 974: HZ_PARTY_V2PUB.create_person (

970: );
971: if G_return_status = FND_API.G_RET_STS_SUCCESS Then
972: If (pType = 'PERSON') then
973: -- l_per_rec.party_rec.customer_key := pI.customer_key;
974: HZ_PARTY_V2PUB.create_person (
975: p_init_msg_list => FND_API.G_FALSE,
976: p_person_rec => l_per_rec,
977: x_return_status => G_return_status,
978: x_msg_count => G_MESG_COUNT,

Line 986: HZ_PARTY_V2PUB.create_person (

982: x_profile_id => l_profile
983: );
984: Elsif (pType = 'CONTACT') then
985: -- l_per_rec.party_rec.customer_key := pI.contact_key;
986: HZ_PARTY_V2PUB.create_person (
987: p_init_msg_list => FND_API.G_FALSE,
988: p_person_rec => l_per_rec,
989: x_return_status => G_return_status,
990: x_msg_count => G_MESG_COUNT,

Line 1289: l_dummy_rec1 hz_party_v2pub.party_rec_type;

1285: l_msg_data VARCHAR2(2000);
1286: l_cpid number;
1287:
1288: -- Dummy
1289: l_dummy_rec1 hz_party_v2pub.party_rec_type;
1290: l_dummy_rec2 hz_location_v2pub.location_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;

Line 1720: l_dummy_rec1 hz_party_v2pub.party_rec_type;

1716: l_location_rec hz_location_v2pub.location_rec_type;
1717: l_msg_data VARCHAR2(2000);
1718:
1719: -- Dummy
1720: l_dummy_rec1 hz_party_v2pub.party_rec_type;
1721: --l_dummy_rec2 hz_location_pub.location_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;

Line 1826: l_org_rec HZ_PARTY_V2PUB.organization_rec_type;

1822: procedure do_create_organization(
1823: pI IN OUT NOCOPY leadImpType,
1824: G_return_status OUT NOCOPY varchar2)
1825: IS
1826: l_org_rec HZ_PARTY_V2PUB.organization_rec_type;
1827: l_hz_partyNumber number;
1828: l_hz_profile number;
1829: l_msg_data VARCHAR2(2000);
1830:

Line 1843: -- Assining HZ_PARTY_V2PUB.organization_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;
1845: l_org_rec.sic_code := pI.sic_code;
1846: l_org_rec.sic_code_type := pI.sic_code_type;
1847: l_org_rec.hq_branch_ind := pI.hq_branch_ind;

Line 1907: HZ_PARTY_V2PUB.create_organization (

1903: G_return_status
1904: );
1905:
1906: if G_return_status = FND_API.G_RET_STS_SUCCESS Then
1907: HZ_PARTY_V2PUB.create_organization (
1908: p_init_msg_list => FND_API.G_FALSE,
1909: p_organization_rec => l_org_rec,
1910: x_return_status => G_return_status,
1911: x_msg_count => G_MESG_COUNT,

Line 1945: l_dummy_rec1 hz_party_v2pub.party_rec_type;

1941: l_hz_psNumber VARCHAR2(30);
1942: l_hz_psid NUMBER;
1943:
1944: -- Dummy
1945: l_dummy_rec1 hz_party_v2pub.party_rec_type;
1946: l_dummy_rec2 hz_location_v2pub.location_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;

Line 2075: l_dummy_rec1 hz_party_v2pub.party_rec_type;

2071: l_party_number VARCHAR2(30);
2072: l_msg_data VARCHAR2(2000);
2073:
2074: -- Dummy
2075: l_dummy_rec1 hz_party_v2pub.party_rec_type;
2076: l_dummy_rec2 hz_location_v2pub.location_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;

Line 2358: l_dummy_rec1 hz_party_v2pub.party_rec_type;

2354: -- primary contact point id of the primary contact
2355: l_contact_point_id NUMBER;
2356:
2357: -- Dummy
2358: l_dummy_rec1 hz_party_v2pub.party_rec_type;
2359: l_dummy_rec2 hz_location_v2pub.location_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;

Line 3123: l_org_rec HZ_PARTY_V2PUB.organization_rec_type;

3119: procedure do_update_party(
3120: pI IN OUT NOCOPY leadImpType,
3121: G_return_status OUT NOCOPY varchar2)
3122: IS
3123: l_org_rec HZ_PARTY_V2PUB.organization_rec_type;
3124: l_hz_partyNumber number;
3125: l_hz_profile number;
3126: l_msg_data VARCHAR2(2000);
3127: l_per_rec HZ_PARTY_V2PUB.person_rec_type;

Line 3127: l_per_rec HZ_PARTY_V2PUB.person_rec_type;

3123: l_org_rec HZ_PARTY_V2PUB.organization_rec_type;
3124: l_hz_partyNumber number;
3125: l_hz_profile number;
3126: l_msg_data VARCHAR2(2000);
3127: l_per_rec HZ_PARTY_V2PUB.person_rec_type;
3128: l_osysref varchar2(240) := Null;
3129:
3130: Begin
3131:

Line 3404: l_person_rec HZ_PARTY_V2PUB.PERSON_REC_TYPE;

3400: l_activate_flag VARCHAR2(1);
3401: l_status VARCHAR2(1);
3402: l_object_version_number NUMBER;
3403: l_profile_id NUMBER;
3404: l_person_rec HZ_PARTY_V2PUB.PERSON_REC_TYPE;
3405: l_organization_rec HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE;
3406: -- SOLIN, BUG 3528579 end
3407:
3408: --l_restrict_sql VARCHAR2(4000);

Line 3405: l_organization_rec HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE;

3401: l_status VARCHAR2(1);
3402: l_object_version_number NUMBER;
3403: l_profile_id NUMBER;
3404: l_person_rec HZ_PARTY_V2PUB.PERSON_REC_TYPE;
3405: l_organization_rec HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE;
3406: -- SOLIN, BUG 3528579 end
3407:
3408: --l_restrict_sql VARCHAR2(4000);
3409:

Line 3746: HZ_PARTY_V2PUB.update_organization(

3742: IF I.party_type = 'ORGANIZATION'
3743: THEN
3744: l_organization_rec.party_rec.party_id := l_party_id;
3745: l_organization_rec.party_rec.status := 'A';
3746: HZ_PARTY_V2PUB.update_organization(
3747: p_init_msg_list => FND_API.G_FALSE,
3748: p_organization_rec => l_organization_rec,
3749: p_party_object_version_number => l_object_version_number,
3750: x_profile_id => l_profile_id,

Line 3759: HZ_PARTY_V2PUB.update_person(

3755: ELSIF I.party_type = 'PERSON'
3756: THEN
3757: l_person_rec.party_rec.party_id := l_party_id;
3758: l_person_rec.party_rec.status := 'A';
3759: HZ_PARTY_V2PUB.update_person(
3760: p_init_msg_list => FND_API.G_FALSE,
3761: p_person_rec => l_person_rec,
3762: p_party_object_version_number => l_object_version_number,
3763: x_profile_id => l_profile_id,