DBA Data[Home] [Help]

APPS.IBE_ADDRESS_V2PVT dependencies on HZ_LOCATION_V2PUB

Line 15: p_location IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,

11: PROCEDURE do_create_address(
12: p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15: p_location IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,
16: p_party_site IN HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE,
17: p_primary_billto IN VARCHAR2 := FND_API.G_FALSE,
18: p_primary_shipto IN VARCHAR2 := FND_API.G_FALSE,
19: p_billto IN VARCHAR2 := FND_API.G_FALSE,

Line 43: p_location IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE

39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2);
41:
42: FUNCTION is_location_changed(
43: p_location IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE
44: ) RETURN BOOLEAN;
45:
46: FUNCTION is_party_site_changed(
47: p_party_site IN HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE

Line 60: p_location IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,

56: PROCEDURE create_address(
57: p_api_version IN NUMBER,
58: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
59: p_commit IN VARCHAR2 := FND_API.G_FALSE,
60: p_location IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,
61: p_party_site IN HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE,
62: p_primary_billto IN VARCHAR2 := FND_API.G_FALSE,
63: p_primary_shipto IN VARCHAR2 := FND_API.G_FALSE,
64: p_billto IN VARCHAR2 := FND_API.G_FALSE,

Line 242: p_location IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,

238: p_party_site_id IN NUMBER,
239: p_ps_object_version_number IN NUMBER,
240: p_bill_object_version_number IN NUMBER,
241: p_ship_object_version_number IN NUMBER,
242: p_location IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,
243: p_party_site IN HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE,
244: p_primary_billto IN VARCHAR2 := NULL,
245: p_primary_shipto IN VARCHAR2 := NULL,
246: p_billto IN VARCHAR2 := NULL,

Line 264: l_chk_loc HZ_LOCATION_V2PUB.LOCATION_REC_TYPE := p_location;

260: l_loc_changed BOOLEAN := false;
261: l_ps_changed BOOLEAN := false;
262: l_psu_changed VARCHAR(1);
263: l_chk_ps HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE := p_party_site;
264: l_chk_loc HZ_LOCATION_V2PUB.LOCATION_REC_TYPE := p_location;
265: l_chk_psu HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE;
266: l_ps_object_version_number NUMBER := p_ps_object_version_number;
267: l_bill_object_version_number NUMBER := p_bill_object_version_number;
268: l_ship_object_version_number NUMBER := p_ship_object_version_number;

Line 500: HZ_LOCATION_V2PUB.update_location(

496: l_chk_loc.province := nvl(l_chk_loc.province,FND_API.G_MISS_CHAR);
497: l_chk_loc.county := nvl(l_chk_loc.county,FND_API.G_MISS_CHAR);
498: l_chk_loc.address_lines_phonetic := nvl(l_chk_loc.address_lines_phonetic,FND_API.G_MISS_CHAR);
499: --End conversion
500: HZ_LOCATION_V2PUB.update_location(
501: p_init_msg_list,
502: l_chk_loc,
503: l_loc_object_version_number,
504: x_return_status,

Line 1620: p_location IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,

1616: PROCEDURE do_create_address(
1617: p_api_version IN NUMBER,
1618: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1619: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1620: p_location IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,
1621: p_party_site IN HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE,
1622: p_primary_billto IN VARCHAR2 := FND_API.G_FALSE,
1623: p_primary_shipto IN VARCHAR2 := FND_API.G_FALSE,
1624: p_billto IN VARCHAR2 := FND_API.G_FALSE,

Line 1634: l_location HZ_LOCATION_V2PUB.LOCATION_REC_TYPE := p_location;

1630: x_location_id OUT NOCOPY NUMBER,
1631: x_party_site_id OUT NOCOPY NUMBER)
1632: IS
1633:
1634: l_location HZ_LOCATION_V2PUB.LOCATION_REC_TYPE := p_location;
1635: l_party_site HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE := p_party_site;
1636:
1637: l_count NUMBER;
1638: l_gen_party_site_number VARCHAR2(1);

Line 1666: IBE_UTIL.debug('hz_location_v2pub.create_location(+)');

1662: l_location.location_id := FND_API.G_MISS_NUM;
1663: l_location.address_effective_date := sysdate;
1664:
1665: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1666: IBE_UTIL.debug('hz_location_v2pub.create_location(+)');
1667: END IF;
1668:
1669: --V2
1670: /* HZ_location_v2pub.create_location(

Line 1670: /* HZ_location_v2pub.create_location(

1666: IBE_UTIL.debug('hz_location_v2pub.create_location(+)');
1667: END IF;
1668:
1669: --V2
1670: /* HZ_location_v2pub.create_location(
1671: p_api_version,
1672: p_init_msg_list,
1673: p_commit,
1674: l_location,

Line 1681: HZ_LOCATION_V2PUB.create_location (

1677: x_msg_data,
1678: x_location_id
1679: );*/
1680:
1681: HZ_LOCATION_V2PUB.create_location (
1682: p_init_msg_list,
1683: l_location,
1684: x_location_id,
1685: x_return_status,

Line 1698: IBE_UTIL.debug('hz_location_v2pub.create_location(-)');

1694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1695: END IF;
1696:
1697: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1698: IBE_UTIL.debug('hz_location_v2pub.create_location(-)');
1699: IBE_UTIL.debug('locaiton_id = ' || x_location_id);
1700: END IF;
1701:
1702:

Line 2115: p_location IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE

2111: --
2112: -- Check if the user input has changed from the database
2113: --
2114: FUNCTION is_location_changed(
2115: p_location IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE
2116: ) RETURN BOOLEAN
2117: IS
2118: l_changed BOOLEAN := false;
2119: l_dummy NUMBER;

Line 2461: p_location IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,

2457: p_api_version IN NUMBER,
2458: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2459: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2460: p_party_site IN HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE,
2461: p_location IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,
2462: x_party_site_id OUT NOCOPY NUMBER,
2463: x_return_status OUT NOCOPY VARCHAR2,
2464: x_msg_count OUT NOCOPY NUMBER,
2465: x_msg_data OUT NOCOPY VARCHAR2)