DBA Data[Home] [Help]

APPS.IBE_PARTY_V2PVT dependencies on HZ_PERSON_INFO_V2PUB

Line 1837: | - Create Person Language preference in HZ_PERSON_INFO_V2PUB

1833: | it creates a new one and makrs it primary
1834: |
1835: | USAGE
1836: |
1837: | - Create Person Language preference in HZ_PERSON_INFO_V2PUB
1838: |
1839: |
1840: | REFERENCED APIS
1841: | This API calls the following APIs

Line 1842: | - HZ_PERSON_INFO_V2PUB.create_person_language if no row exists

1838: |
1839: |
1840: | REFERENCED APIS
1841: | This API calls the following APIs
1842: | - HZ_PERSON_INFO_V2PUB.create_person_language if no row exists
1843: | - HZ_PERSON_INFO_V2PUB.update_person_language if row exists
1844: +======================================================================*/
1845: PROCEDURE Update_Person_Language(
1846: p_party_id IN NUMBER,

Line 1843: | - HZ_PERSON_INFO_V2PUB.update_person_language if row exists

1839: |
1840: | REFERENCED APIS
1841: | This API calls the following APIs
1842: | - HZ_PERSON_INFO_V2PUB.create_person_language if no row exists
1843: | - HZ_PERSON_INFO_V2PUB.update_person_language if row exists
1844: +======================================================================*/
1845: PROCEDURE Update_Person_Language(
1846: p_party_id IN NUMBER,
1847: p_language_name IN VARCHAR2,

Line 1854: l_per_language_rec hz_person_info_v2pub.person_language_rec_type;

1850: x_msg_count OUT NOCOPY NUMBER,
1851: x_msg_data OUT NOCOPY VARCHAR2
1852: )
1853: IS
1854: l_per_language_rec hz_person_info_v2pub.person_language_rec_type;
1855: l_id NUMBER;
1856: l_per_language_rec2 hz_person_info_v2pub.person_language_rec_type;
1857: l_language_use_reference_id number;
1858: l_object_version_number NUMBER;

Line 1856: l_per_language_rec2 hz_person_info_v2pub.person_language_rec_type;

1852: )
1853: IS
1854: l_per_language_rec hz_person_info_v2pub.person_language_rec_type;
1855: l_id NUMBER;
1856: l_per_language_rec2 hz_person_info_v2pub.person_language_rec_type;
1857: l_language_use_reference_id number;
1858: l_object_version_number NUMBER;
1859:
1860: BEGIN

Line 1880: IBE_UTIL.debug('Call HZ_PERSON_INFO_V2PUB.update_person_language API to unset primary');

1876: l_per_language_rec.primary_language_indicator := 'N';
1877: l_per_language_rec.language_use_reference_id := l_id;
1878:
1879: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1880: IBE_UTIL.debug('Call HZ_PERSON_INFO_V2PUB.update_person_language API to unset primary');
1881: END IF;
1882: hz_person_info_v2pub.update_person_language(
1883: p_person_language_rec => l_per_language_rec,
1884: p_object_version_number => l_object_version_number,

Line 1882: hz_person_info_v2pub.update_person_language(

1878:
1879: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1880: IBE_UTIL.debug('Call HZ_PERSON_INFO_V2PUB.update_person_language API to unset primary');
1881: END IF;
1882: hz_person_info_v2pub.update_person_language(
1883: p_person_language_rec => l_per_language_rec,
1884: p_object_version_number => l_object_version_number,
1885: x_return_status => x_return_status,
1886: x_msg_count => x_msg_count,

Line 1889: IBE_UTIL.debug(' After Call HZ_PERSON_INFO_V2PUB.update_person_language APIto unset primary');

1885: x_return_status => x_return_status,
1886: x_msg_count => x_msg_count,
1887: x_msg_data => x_msg_data);
1888: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1889: IBE_UTIL.debug(' After Call HZ_PERSON_INFO_V2PUB.update_person_language APIto unset primary');
1890: END IF;
1891: EXCEPTION WHEN NO_DATA_FOUND THEN
1892: NULL;
1893: END;

Line 1910: IBE_UTIL.debug('Call HZ_PERSON_INFO_V2PUB.update_person_language API to set primary');

1906: l_per_language_rec2.language_use_reference_id := l_id;
1907:
1908:
1909: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1910: IBE_UTIL.debug('Call HZ_PERSON_INFO_V2PUB.update_person_language API to set primary');
1911: END IF;
1912: hz_person_info_v2pub.update_person_language(
1913: p_person_language_rec => l_per_language_rec2,
1914: p_object_version_number => l_object_version_number,

Line 1912: hz_person_info_v2pub.update_person_language(

1908:
1909: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1910: IBE_UTIL.debug('Call HZ_PERSON_INFO_V2PUB.update_person_language API to set primary');
1911: END IF;
1912: hz_person_info_v2pub.update_person_language(
1913: p_person_language_rec => l_per_language_rec2,
1914: p_object_version_number => l_object_version_number,
1915: x_return_status => x_return_status,
1916: x_msg_count => x_msg_count,

Line 1920: IBE_UTIL.debug('After Call HZ_PERSON_INFO_V2PUB.update_person_language API to set primary');

1916: x_msg_count => x_msg_count,
1917: x_msg_data => x_msg_data);
1918:
1919: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1920: IBE_UTIL.debug('After Call HZ_PERSON_INFO_V2PUB.update_person_language API to set primary');
1921: END IF;
1922: EXCEPTION WHEN NO_DATA_FOUND THEN
1923: l_per_language_rec2.primary_language_indicator := 'Y';
1924: l_per_language_rec2.party_id := p_party_id;

Line 1929: IBE_UTIL.debug('Call HZ_PERSON_INFO_V2PUB.create_person_language API to set primary');

1925: l_per_language_rec2.language_name := p_language_name;
1926: l_per_language_rec2.created_by_module := p_created_by_module;
1927:
1928: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1929: IBE_UTIL.debug('Call HZ_PERSON_INFO_V2PUB.create_person_language API to set primary');
1930: END IF;
1931: hz_person_info_v2pub.create_person_language(
1932: p_person_language_rec => l_per_language_rec2,
1933: x_language_use_reference_id => l_language_use_reference_id,

Line 1931: hz_person_info_v2pub.create_person_language(

1927:
1928: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1929: IBE_UTIL.debug('Call HZ_PERSON_INFO_V2PUB.create_person_language API to set primary');
1930: END IF;
1931: hz_person_info_v2pub.create_person_language(
1932: p_person_language_rec => l_per_language_rec2,
1933: x_language_use_reference_id => l_language_use_reference_id,
1934: x_return_status => x_return_status,
1935: x_msg_count => x_msg_count,

Line 1938: IBE_UTIL.debug('Call HZ_PERSON_INFO_V2PUB.create_person_language API to set primary');

1934: x_return_status => x_return_status,
1935: x_msg_count => x_msg_count,
1936: x_msg_data => x_msg_data);
1937: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1938: IBE_UTIL.debug('Call HZ_PERSON_INFO_V2PUB.create_person_language API to set primary');
1939: END IF;
1940:
1941: END;
1942: --end set primary language indicator