DBA Data[Home] [Help]

APPS.POS_SBD_IBY_PKG dependencies on HZ_LOCATION_V2PUB

Line 105: l_bank_location_rec hz_location_v2pub.LOCATION_REC_TYPE;

101: , x_exception_msg out nocopy VARCHAR2
102: )
103: IS
104: l_step NUMBER;
105: l_bank_location_rec hz_location_v2pub.LOCATION_REC_TYPE;
106: l_branch_location_rec hz_location_v2pub.LOCATION_REC_TYPE;
107: l_bank_location_id number;
108: l_branch_location_id number;
109: l_msg_count NUMBER;

Line 106: l_branch_location_rec hz_location_v2pub.LOCATION_REC_TYPE;

102: )
103: IS
104: l_step NUMBER;
105: l_bank_location_rec hz_location_v2pub.LOCATION_REC_TYPE;
106: l_branch_location_rec hz_location_v2pub.LOCATION_REC_TYPE;
107: l_bank_location_id number;
108: l_branch_location_id number;
109: l_msg_count NUMBER;
110:

Line 585: l_location_rec hz_location_v2pub.LOCATION_REC_TYPE;

581: IS
582:
583: l_step number;
584: l_msg_count number;
585: l_location_rec hz_location_v2pub.LOCATION_REC_TYPE;
586:
587: BEGIN
588:
589: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 610: hz_location_v2pub.create_location (

606:
607: l_location_rec.created_by_module := 'POS_SUPPLIER_MGMT';
608: l_location_rec.application_id := 177;
609:
610: hz_location_v2pub.create_location (
611: p_init_msg_list => fnd_api.g_true,
612: p_location_rec => l_location_rec,
613: x_location_id => x_location_id,
614: x_return_status => x_status,

Line 658: l_location_rec hz_location_v2pub.LOCATION_REC_TYPE;

654: l_step number;
655: l_msg_count number;
656: l_obj_ver HZ_LOCATIONS.object_version_number%TYPE;
657: l_created_by_module HZ_PARTY_SITES.created_by_module%TYPE;
658: l_location_rec hz_location_v2pub.LOCATION_REC_TYPE;
659:
660: BEGIN
661:
662: l_step := 0;

Line 714: hz_location_v2pub.update_location (

710: end if;
711:
712: l_location_rec.created_by_module := l_created_by_module;
713: l_location_rec.application_id := 177;
714: hz_location_v2pub.update_location (
715: p_init_msg_list => fnd_api.g_true,
716: p_location_rec => l_location_rec,
717: p_object_version_number => l_obj_ver,
718: x_return_status => x_status,