DBA Data[Home] [Help]

APPS.HZ_LOCATION_BO_PUB dependencies on HZ_LOCATIONS

Line 216: p_obj_type => 'HZ_LOCATIONS',

212: hz_registry_validate_bo_pvt.validate_ssm_id(
213: px_id => x_location_id,
214: px_os => x_location_os,
215: px_osr => x_location_osr,
216: p_obj_type => 'HZ_LOCATIONS',
217: p_create_or_update => 'C',
218: x_return_status => x_return_status,
219: x_msg_count => x_msg_count,
220: x_msg_data => x_msg_data);

Line 476: FROM HZ_LOCATIONS loc

472: l_errorcode NUMBER;
473:
474: CURSOR get_ovn(l_loc_id NUMBER) IS
475: SELECT loc.object_version_number
476: FROM HZ_LOCATIONS loc
477: WHERE loc.location_id = l_loc_id;
478:
479: BEGIN
480: -- Standard start of API savepoint

Line 516: p_obj_type => 'HZ_LOCATIONS',

512: hz_registry_validate_bo_pvt.validate_ssm_id(
513: px_id => x_location_id,
514: px_os => x_location_os,
515: px_osr => x_location_osr,
516: p_obj_type => 'HZ_LOCATIONS',
517: p_create_or_update => 'U',
518: x_return_status => x_return_status,
519: x_msg_count => x_msg_count,
520: x_msg_data => x_msg_data);

Line 805: p_entity_type => 'HZ_LOCATIONS',

801: l_create_update_flag := HZ_REGISTRY_VALIDATE_BO_PVT.check_bo_op(
802: p_entity_id => x_location_id,
803: p_entity_os => x_location_os,
804: p_entity_osr => x_location_osr,
805: p_entity_type => 'HZ_LOCATIONS',
806: p_parent_id => NULL,
807: p_parent_obj_type => NULL);
808:
809: IF(l_create_update_flag = 'E') THEN

Line 1047: Location Y N HZ_LOCATIONS

1043: the Get procedure returns all records for the particular location from these TCA entity tables:
1044:
1045: Embedded TCA Entity Mandatory Multiple TCA Table Entities
1046:
1047: Location Y N HZ_LOCATIONS
1048: */
1049:
1050: PROCEDURE get_location_bo (
1051: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 1118: FROM HZ_LOCATIONS LOC

1114: LOC.GEOMETRY_STATUS_CODE,
1115: LOC.GEOMETRY,
1116: HZ_ORIG_SYS_REF_OBJ_TBL(),
1117: HZ_EXT_ATTRIBUTE_OBJ_TBL())
1118: FROM HZ_LOCATIONS LOC
1119: WHERE LOCATION_ID = l_loc_id;
1120:
1121: BEGIN
1122: -- initialize API return status to success.

Line 1148: p_obj_type => 'HZ_LOCATIONS',

1144: HZ_EXTRACT_BO_UTIL_PVT.validate_ssm_id(
1145: px_id => l_location_id,
1146: px_os => l_location_os,
1147: px_osr => l_location_osr,
1148: p_obj_type => 'HZ_LOCATIONS',
1149: x_return_status => x_return_status,
1150: x_msg_count => x_msg_count,
1151: x_msg_data => x_msg_data);
1152:

Line 1164: p_ext_object_name => 'HZ_LOCATIONS',

1160:
1161: hz_extract_ext_attri_bo_pvt.get_ext_attribute_bos(
1162: p_init_msg_list => fnd_api.g_false,
1163: p_ext_object_id => x_location_obj.location_id,
1164: p_ext_object_name => 'HZ_LOCATIONS',
1165: p_action_type => NULL,
1166: x_ext_attribute_objs => x_location_obj.ext_attributes_objs,
1167: x_return_status => x_return_status,
1168: x_msg_count => x_msg_count,