DBA Data[Home] [Help]

APPS.IGS_AD_LOCATION_ADDR_PKG dependencies on HZ_LOCATION_V2PUB

Line 37: p_location_rec_insert HZ_LOCATION_V2PUB.location_rec_type;

33: x_object_version_number IN OUT NOCOPY NUMBER,
34: X_MODE IN VARCHAR2 DEFAULT 'R'
35: ) AS
36:
37: p_location_rec_insert HZ_LOCATION_V2PUB.location_rec_type;
38:
39: l_msg_count NUMBER;
40: l_msg_data VARCHAR2(1000);
41: l_location_id NUMBER;

Line 90: HZ_LOCATION_V2PUB.create_location (

86: p_location_rec_insert.address_expiration_date := x_end_dt;
87: p_location_rec_insert.created_by_module := 'IGS';
88: p_location_rec_insert.application_id := 8405;
89:
90: HZ_LOCATION_V2PUB.create_location (
91: P_INIT_MSG_LIST => FND_API.G_TRUE,
92: P_LOCATION_REC => p_location_rec_insert,
93: P_DO_ADDR_VAL => 'Y',
94: X_LOCATION_ID => l_location_id,

Line 183: p_location_rec_update HZ_LOCATION_V2PUB.location_rec_type;

179: x_object_version_number IN OUT NOCOPY NUMBER,
180: X_MODE IN VARCHAR2 DEFAULT 'R'
181: ) AS
182:
183: p_location_rec_update HZ_LOCATION_V2PUB.location_rec_type;
184:
185: l_msg_count NUMBER;
186: l_msg_data VARCHAR2(1000);
187: l_location_id NUMBER := x_location_id;

Line 238: HZ_LOCATION_V2PUB.update_location(

234: p_location_rec_update.address_lines_phonetic := NVL(x_address_lines_phonetic,FND_API.G_MISS_CHAR);
235: p_location_rec_update.address_effective_date := NVL(x_start_dt,FND_API.G_MISS_DATE);
236: p_location_rec_update.address_expiration_date := NVL(x_end_dt,FND_API.G_MISS_DATE);
237:
238: HZ_LOCATION_V2PUB.update_location(
239: P_INIT_MSG_LIST => FND_API.G_TRUE,
240: P_LOCATION_REC => p_location_rec_update,
241: p_do_addr_val => 'Y',
242: p_object_version_number => x_object_version_number,