APPS.AHL_PARTY_MERGE_PKG dependencies on AHL_ROUTES_B

Line 18: -- AHL_ROUTES_B

14: -- AHL_DOC_REVISION_COPIES
15: --
16: -- AHL_OPERATIONS_B
17: -- AHL_OPERATIONS_H_B
18: -- AHL_ROUTES_B
19: -- AHL_ROUTES_H_B
20: --
21: -- History
22: -- MM-DD-YYYY NAME MODIFICATIONS

Line 960: from ahl_routes_b

956: x_return_status OUT NOCOPY VARCHAR2)
957: IS
958: cursor c1 is
959: select 1
960: from ahl_routes_b
961: where operator_party_id = p_from_fk_id
962: for update nowait;
963:
964:

Line 1009: arp_message.set_token('TABLE_NAME', 'AHL_ROUTES_B', FALSE);

1005: if p_from_fk_id <> p_to_fk_id then
1006: begin
1007: -- obtain lock on records to be updated.
1008: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1009: arp_message.set_token('TABLE_NAME', 'AHL_ROUTES_B', FALSE);
1010:
1011: open c1;
1012: close c1;
1013:

Line 1014: update ahl_routes_b

1010:
1011: open c1;
1012: close c1;
1013:
1014: update ahl_routes_b
1015: set operator_party_id = p_to_fk_id,
1016: last_update_date = SYSDATE,
1017: last_updated_by = G_USER_ID,
1018: last_update_login = G_LOGIN_ID

Line 1030: 'AHL_ROUTES_B for operator_party_id = ' || p_from_fk_id );

1026: exception
1027: when resource_busy then
1028: arp_message.set_line(g_proc_name || '.' || l_api_name ||
1029: '; Could not obtain lock for records in table ' ||
1030: 'AHL_ROUTES_B for operator_party_id = ' || p_from_fk_id );
1031: x_return_status := FND_API.G_RET_STS_ERROR;
1032: raise;
1033:
1034: when others then