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.IBE_ADDRESS_V2PVT dependencies on HZ_PARTY_SITE_V2PUB

Line 16: p_party_site IN HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE,

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,
20: p_shipto IN VARCHAR2 := FND_API.G_FALSE,

Line 47: p_party_site IN HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE

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
48: ) RETURN BOOLEAN;
49:
50: FUNCTION is_party_site_use_changed(
51: p_party_site_use IN OUT NOCOPY HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE

Line 51: p_party_site_use IN OUT NOCOPY HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE

47: p_party_site IN HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE
48: ) RETURN BOOLEAN;
49:
50: FUNCTION is_party_site_use_changed(
51: p_party_site_use IN OUT NOCOPY HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE
52: ) RETURN VARCHAR;
53:
54: -----------------------public procedures -------------------------------------
55:

Line 61: p_party_site IN HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE,

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,
65: p_shipto IN VARCHAR2 := FND_API.G_FALSE,

Line 77: l_party_site HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE := p_party_site;

73:
74: l_api_name CONSTANT VARCHAR2(30) := 'create_address';
75: l_api_version CONSTANT NUMBER := 1.0;
76:
77: l_party_site HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE := p_party_site;
78:
79: l_count NUMBER;
80: l_gen_party_site_number VARCHAR2(1);
81: l_party_site_number VARCHAR2(30) := p_party_site.party_site_number;

Line 82: l_party_site_use HZ_PARTY_SITE_V2PUB.party_site_use_rec_type;

78:
79: l_count NUMBER;
80: l_gen_party_site_number VARCHAR2(1);
81: l_party_site_number VARCHAR2(30) := p_party_site.party_site_number;
82: l_party_site_use HZ_PARTY_SITE_V2PUB.party_site_use_rec_type;
83: l_party_site_use_id NUMBER;
84: l_loc_id NUMBER;
85:
86: BEGIN

Line 243: p_party_site IN HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE,

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,
247: p_shipto IN VARCHAR2 := NULL,

Line 263: l_chk_ps HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE := p_party_site;

259:
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;

Line 265: l_chk_psu HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE;

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;
269: l_loc_object_version_number NUMBER := 1;

Line 353: HZ_PARTY_SITE_V2PUB.update_party_site(

349: --
350: if l_ps_changed = true then
351: -- l_chk_ps.party_id := FND_API.G_MISS_NUM;
352:
353: HZ_PARTY_SITE_V2PUB.update_party_site(
354: p_init_msg_list,
355: l_chk_ps,
356: l_ps_object_version_number,
357: x_return_status,

Line 387: HZ_PARTY_SITE_V2PUB.update_party_site_use(

383: -- if BILL _TO PSU is changed, update PSU record
384: if l_psu_changed = 'T' THEN
385: OPEN c_party_site_use(l_chk_psu.party_site_use_id);
386: FETCH c_party_site_use INTO l_bill_object_version_number;
387: HZ_PARTY_SITE_V2PUB.update_party_site_use(
388: p_init_msg_list,
389: l_chk_psu,
390: l_bill_object_version_number,
391: x_return_status,

Line 404: HZ_PARTY_SITE_V2PUB.create_party_site_use(

400: if l_chk_psu.created_by_module is NULL then
401: l_chk_psu.created_by_module := 'USER MANAGEMENT';
402: end if;
403: l_chk_psu.application_id := 671;
404: HZ_PARTY_SITE_V2PUB.create_party_site_use(
405: p_init_msg_list,
406: l_chk_psu,
407: l_party_site_use_id,
408: x_return_status,

Line 439: HZ_PARTY_SITE_V2PUB.update_party_site_use(

435: if l_psu_changed = 'T' THEN
436: l_chk_psu.created_by_module := NULL;
437: OPEN c_party_site_use(l_chk_psu.party_site_use_id);
438: FETCH c_party_site_use INTO l_ship_object_version_number;
439: HZ_PARTY_SITE_V2PUB.update_party_site_use(
440: p_init_msg_list,
441: l_chk_psu,
442: l_ship_object_version_number,
443: x_return_status,

Line 456: HZ_PARTY_SITE_V2PUB.create_party_site_use(

452: if l_chk_psu.created_by_module is NULL then
453: l_chk_psu.created_by_module := 'USER MANAGEMENT';
454: end if;
455: l_chk_psu.application_id := 671;
456: HZ_PARTY_SITE_V2PUB.create_party_site_use(
457: p_init_msg_list,
458: l_chk_psu,
459: l_party_site_use_id,
460: x_return_status,

Line 540: HZ_PARTY_SITE_V2PUB.update_party_site_use(

536: -- if BILL _TO PSU is changed, update PSU record
537: if l_psu_changed = 'T' THEN
538: OPEN c_party_site_use(l_chk_psu.party_site_use_id);
539: FETCH c_party_site_use INTO l_bill_object_version_number;
540: HZ_PARTY_SITE_V2PUB.update_party_site_use(
541: p_init_msg_list,
542: l_chk_psu,
543: l_bill_object_version_number,
544: x_return_status,

Line 557: HZ_PARTY_SITE_V2PUB.create_party_site_use(

553: if l_chk_psu.created_by_module is NULL then
554: l_chk_psu.created_by_module := 'USER MANAGEMENT';
555: end if;
556: l_chk_psu.application_id := 671;
557: HZ_PARTY_SITE_V2PUB.create_party_site_use(
558: p_init_msg_list,
559: l_chk_psu,
560: l_party_site_use_id,
561: x_return_status,

Line 592: HZ_PARTY_SITE_V2PUB.update_party_site_use(

588: if l_psu_changed = 'T' THEN
589: l_chk_psu.created_by_module := NULL;
590: OPEN c_party_site_use(l_chk_psu.party_site_use_id);
591: FETCH c_party_site_use INTO l_ship_object_version_number;
592: HZ_PARTY_SITE_V2PUB.update_party_site_use(
593: p_init_msg_list,
594: l_chk_psu,
595: l_ship_object_version_number,
596: x_return_status,

Line 609: HZ_PARTY_SITE_V2PUB.create_party_site_use(

605: if l_chk_psu.created_by_module is NULL then
606: l_chk_psu.created_by_module := 'USER MANAGEMENT';
607: end if;
608: l_chk_psu.application_id := 671;
609: HZ_PARTY_SITE_V2PUB.create_party_site_use(
610: p_init_msg_list,
611: l_chk_psu,
612: l_party_site_use_id,
613: x_return_status,

Line 826: l_party_site HZ_PARTY_SITE_V2PUB.party_site_rec_type;

822: IS
823:
824: l_api_name CONSTANT VARCHAR2(30) := 'delete_address';
825: l_api_version CONSTANT NUMBER := 1.0;
826: l_party_site HZ_PARTY_SITE_V2PUB.party_site_rec_type;
827: l_ps_object_version_number NUMBER := p_ps_object_version_number;
828: l_bill_object_version_number NUMBER := p_bill_object_version_number;
829: l_ship_object_version_number NUMBER := p_ship_object_version_number;
830:

Line 1012: l_party_site_use HZ_PARTY_SITE_V2PUB.party_site_use_rec_type;

1008:
1009: l_api_version NUMBER := 1.0;
1010: l_api_name VARCHAR2(30) := 'set_primary_address';
1011:
1012: l_party_site_use HZ_PARTY_SITE_V2PUB.party_site_use_rec_type;
1013: l_party_site_use_id NUMBER;
1014: --V2
1015: l_object_version_number NUMBER;
1016: --l_last_update_date DATE;

Line 1070: HZ_PARTY_SITE_V2PUB.update_party_site_use (

1066: -- update an existing party site use
1067: l_party_site_use.party_site_use_id := l_party_site_use_id;
1068: l_party_site_use.status := 'A';
1069:
1070: HZ_PARTY_SITE_V2PUB.update_party_site_use (
1071: p_init_msg_list,
1072: l_party_site_use,
1073: l_object_version_number,
1074: x_return_status,

Line 1093: HZ_PARTY_SITE_V2PUB.create_party_site_use (

1089: -- l_party_site_use.begin_date := sysdate;
1090: l_party_site_use.status := 'A';
1091:
1092:
1093: HZ_PARTY_SITE_V2PUB.create_party_site_use (
1094: p_init_msg_list,
1095: l_party_site_use,
1096: x_party_site_use_id,
1097: x_return_status,

Line 1621: p_party_site IN HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE,

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,
1625: p_shipto IN VARCHAR2 := FND_API.G_FALSE,

Line 1635: l_party_site HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE := p_party_site;

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);
1639: l_party_site_use HZ_PARTY_SITE_V2PUB.party_site_use_rec_type;

Line 1639: l_party_site_use HZ_PARTY_SITE_V2PUB.party_site_use_rec_type;

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);
1639: l_party_site_use HZ_PARTY_SITE_V2PUB.party_site_use_rec_type;
1640: l_party_site_number VARCHAR2(30) := p_party_site.party_site_number;
1641: l_party_site_use_id NUMBER;
1642: l_loc_id NUMBER;
1643: l_prim_site_id NUMBER;

Line 1773: HZ_PARTY_SITE_V2PUB.create_party_site (

1769: l_party_site_number
1770: );
1771: */
1772:
1773: HZ_PARTY_SITE_V2PUB.create_party_site (
1774: p_init_msg_list,
1775: l_party_site,
1776: x_party_site_id,
1777: l_party_site_number,

Line 1790: IBE_UTIL.debug('hz_party_site_v2pub.create_party_site(-)');

1786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1787: END IF;
1788:
1789: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1790: IBE_UTIL.debug('hz_party_site_v2pub.create_party_site(-)');
1791: IBE_UTIL.debug('party_site_id = ' || x_party_site_id);
1792: END IF;
1793:
1794: --

Line 2032: l_party_site HZ_PARTY_SITE_V2PUB.party_site_rec_type;

2028: for update nowait;
2029:
2030: l_api_name CONSTANT VARCHAR2(30) := 'delete_address';
2031: l_api_version CONSTANT NUMBER := 1.0;
2032: l_party_site HZ_PARTY_SITE_V2PUB.party_site_rec_type;
2033: l_party_site_use HZ_PARTY_SITE_V2PUB.party_site_use_rec_type;
2034: l_party_site_use_id NUMBER;
2035: l_site_use_type VARCHAR(30);
2036: l_ps_object_version_number NUMBER := p_ps_object_version_number;

Line 2033: l_party_site_use HZ_PARTY_SITE_V2PUB.party_site_use_rec_type;

2029:
2030: l_api_name CONSTANT VARCHAR2(30) := 'delete_address';
2031: l_api_version CONSTANT NUMBER := 1.0;
2032: l_party_site HZ_PARTY_SITE_V2PUB.party_site_rec_type;
2033: l_party_site_use HZ_PARTY_SITE_V2PUB.party_site_use_rec_type;
2034: l_party_site_use_id NUMBER;
2035: l_site_use_type VARCHAR(30);
2036: l_ps_object_version_number NUMBER := p_ps_object_version_number;
2037: l_psu_object_version_number NUMBER;

Line 2059: HZ_PARTY_SITE_V2PUB.update_party_site (

2055: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2056: IBE_UTIL.debug('hz_party_v2pub.update_party_site(+)');
2057: END IF;
2058:
2059: HZ_PARTY_SITE_V2PUB.update_party_site (
2060: p_init_msg_list,
2061: l_party_site,
2062: l_ps_object_version_number,
2063: x_return_status,

Line 2083: HZ_PARTY_SITE_V2PUB.update_party_site_use(

2079: elsif l_site_use_type = 'SHIP_TO' then
2080: l_psu_object_version_number := p_ship_object_version_number;
2081: end if;
2082: */
2083: HZ_PARTY_SITE_V2PUB.update_party_site_use(
2084: p_init_msg_list,
2085: l_party_site_use,
2086: l_psu_object_version_number,
2087: x_return_status,

Line 2178: p_party_site IN HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE

2174: --
2175: -- Check if the user input has changed from the database
2176: --
2177: FUNCTION is_party_site_changed(
2178: p_party_site IN HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE
2179: ) RETURN BOOLEAN
2180: IS
2181: l_changed BOOLEAN := false;
2182: l_dummy NUMBER;

Line 2225: p_party_site_use IN OUT NOCOPY HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE

2221: -- Check if update is necessary for party_site_use
2222: --
2223:
2224: FUNCTION is_party_site_use_changed(
2225: p_party_site_use IN OUT NOCOPY HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE
2226: ) RETURN VARCHAR
2227: IS
2228: l_psu_id NUMBER := NULL;
2229: --T is changed, F is not changed, N is not found

Line 2460: p_party_site IN HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE,

2456: PROCEDURE copy_party_site (
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,

Line 2489: HZ_PARTY_SITE_V2PUB.create_party_site (

2485: x_msg_data OUT NOCOPY VARCHAR2
2486: );
2487: */
2488:
2489: HZ_PARTY_SITE_V2PUB.create_party_site (
2490: p_init_msg_list => p_init_msg_list,
2491: p_party_site_rec => p_party_site,
2492: x_party_site_id => l_party_site_id,
2493: x_party_site_number => l_party_site_number,