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.HZ_MAP_PARTY_PUB dependencies on HZ_ORIG_SYSTEM_REF_PUB

Line 1850: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.orig_sys_reference_rec_type;

1846: x_return_status IN OUT NOCOPY VARCHAR2,
1847: x_msg_count OUT NOCOPY NUMBER,
1848: x_msg_data OUT NOCOPY VARCHAR2
1849: ) IS
1850: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.orig_sys_reference_rec_type;
1851: l_orig_system_ref_id NUMBER;
1852: l_object_version_number NUMBER;
1853: l_start_date_active date;
1854: l_orig_system HZ_ORIG_SYS_REFERENCES.orig_system%type;

Line 1938: HZ_ORIG_SYSTEM_REF_PUB.update_orig_system_reference(

1934: l_orig_sys_reference_rec.start_date_active := l_start_date_active;
1935: l_orig_sys_reference_rec.END_DATE_ACTIVE := sysdate;
1936: l_orig_sys_reference_rec.status := 'I';
1937:
1938: HZ_ORIG_SYSTEM_REF_PUB.update_orig_system_reference(
1939: p_init_msg_list => 'T',
1940: p_orig_sys_reference_rec => l_orig_sys_reference_rec,
1941: p_object_version_number => l_object_version_number,
1942: x_return_status => x_return_status,

Line 1982: HZ_ORIG_SYSTEM_REF_PUB.update_orig_system_reference(

1978: l_orig_sys_reference_rec.start_date_active := l_start_date_active;
1979: l_orig_sys_reference_rec.END_DATE_ACTIVE := sysdate;
1980: l_orig_sys_reference_rec.status := 'I';
1981:
1982: HZ_ORIG_SYSTEM_REF_PUB.update_orig_system_reference(
1983: p_init_msg_list => 'T',
1984: p_orig_sys_reference_rec => l_orig_sys_reference_rec,
1985: p_object_version_number => l_object_version_number,
1986: x_return_status => x_return_status,

Line 2025: HZ_ORIG_SYSTEM_REF_PUB.update_orig_system_reference(

2021: l_orig_sys_reference_rec.start_date_active := l_start_date_active;
2022: l_orig_sys_reference_rec.END_DATE_ACTIVE := sysdate;
2023: l_orig_sys_reference_rec.status := 'I';
2024:
2025: HZ_ORIG_SYSTEM_REF_PUB.update_orig_system_reference(
2026: p_init_msg_list => 'T',
2027: p_orig_sys_reference_rec => l_orig_sys_reference_rec,
2028: p_object_version_number => l_object_version_number,
2029: x_return_status => x_return_status,

Line 2061: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.orig_sys_reference_rec_type;

2057: p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
2058: x_return_status OUT NOCOPY VARCHAR2
2059: ) IS
2060:
2061: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.orig_sys_reference_rec_type;
2062: l_orig_system_ref_id NUMBER;
2063: l_object_version_number NUMBER;
2064: l_start_date_active date;
2065: l_orig_system HZ_ORIG_SYS_REFERENCES.orig_system%type;

Line 2163: hz_orig_system_ref_pub.create_orig_system_reference(

2159: l_orig_sys_reference_rec.status := 'A';
2160: l_orig_sys_reference_rec.created_by_module := 'TCA_DNB_MAPPING';
2161: l_orig_sys_reference_rec.old_orig_system_reference := l_orig_system_reference_p;
2162:
2163: hz_orig_system_ref_pub.create_orig_system_reference(
2164: FND_API.G_FALSE,
2165: l_orig_sys_reference_rec,
2166: x_return_status,
2167: l_msg_count,

Line 2195: hz_orig_system_ref_pub.create_orig_system_reference(

2191: l_orig_sys_reference_rec.status := 'A';
2192: l_orig_sys_reference_rec.created_by_module := 'TCA_DNB_MAPPING';
2193:
2194: l_orig_sys_reference_rec.old_orig_system_reference := l_orig_system_reference;
2195: hz_orig_system_ref_pub.create_orig_system_reference(
2196: FND_API.G_FALSE,
2197: l_orig_sys_reference_rec,
2198: x_return_status,
2199: l_msg_count,

Line 2235: hz_orig_system_ref_pub.create_orig_system_reference(

2231: l_orig_sys_reference_rec.party_id := p_organization_rec.party_rec.party_id;
2232: l_orig_sys_reference_rec.status := 'A';
2233: l_orig_sys_reference_rec.created_by_module := 'TCA_DNB_MAPPING';
2234: l_orig_sys_reference_rec.old_orig_system_reference := l_orig_system_reference;
2235: hz_orig_system_ref_pub.create_orig_system_reference(
2236: FND_API.G_FALSE,
2237: l_orig_sys_reference_rec,
2238: x_return_status,
2239: l_msg_count,

Line 2324: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.orig_sys_reference_rec_type;

2320: -- Bug 3223595 : Added local variable
2321: l_exist VARCHAR2(1);
2322:
2323: -- Bug 3492084 : Added orig_sys_reference_rec
2324: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.orig_sys_reference_rec_type;
2325: l_msg_count NUMBER;
2326: l_msg_data VARCHAR2(2000);
2327: l_orig_sys_ref_id NUMBER;
2328:

Line 2397: hz_orig_system_ref_pub.create_orig_system_reference(

2393: l_orig_sys_reference_rec.status := 'A';
2394: l_orig_sys_reference_rec.created_by_module := 'TCA_DNB_MAPPING';
2395:
2396:
2397: hz_orig_system_ref_pub.create_orig_system_reference(
2398: FND_API.G_FALSE,
2399: l_orig_sys_reference_rec,
2400: x_return_status,
2401: l_msg_count,

Line 4017: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.orig_sys_reference_rec_type;

4013:
4014: l_address1 VARCHAR2(240);
4015: --4227564
4016: l_duns_number_c hz_organization_profiles.duns_number_c%type;
4017: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.orig_sys_reference_rec_type;
4018: l_count NUMBER;
4019: l_orig_sys_ref_id NUMBER;
4020: BEGIN
4021: --4227564

Line 4132: hz_orig_system_ref_pub.create_orig_system_reference(

4128: l_orig_sys_reference_rec.party_id := p_party_id;
4129: l_orig_sys_reference_rec.status := 'A';
4130: l_orig_sys_reference_rec.created_by_module := 'TCA_DNB_MAPPING';
4131:
4132: hz_orig_system_ref_pub.create_orig_system_reference(
4133: FND_API.G_FALSE,
4134: l_orig_sys_reference_rec,
4135: x_return_status,
4136: l_msg_count,

Line 4440: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.orig_sys_reference_rec_type;

4436: l_count NUMBER;
4437: l_orig_system_reference hz_orig_sys_references.orig_system_reference%TYPE;
4438: l_duns_number_c hz_organization_profiles.duns_number_c%TYPE;
4439: --4227564
4440: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.orig_sys_reference_rec_type;
4441: l_orig_sys_ref_id NUMBER;
4442:
4443: CURSOR check_cont_point_mosr_mapping (p_orig_system IN VARCHAR2,
4444: p_orig_system_ref IN VARCHAR2,

Line 4549: hz_orig_system_ref_pub.create_orig_system_reference(

4545: l_orig_sys_reference_rec.status := 'A';
4546: l_orig_sys_reference_rec.created_by_module := 'TCA_DNB_MAPPING';
4547:
4548:
4549: hz_orig_system_ref_pub.create_orig_system_reference(
4550: FND_API.G_FALSE,
4551: l_orig_sys_reference_rec,
4552: x_return_status,
4553: l_msg_count,