APPS.AHL_PARTY_MERGE_PKG dependencies on AHL_OSP_ORDERS_B

Line 1140: -- Merge AHL_OSP_ORDERS_B.CUSTOMER_ID

1136: end if;
1137: END AHL_RM_ROUTE_H_OPERATOR_PARTY;
1138: */
1139:
1140: -- Merge AHL_OSP_ORDERS_B.CUSTOMER_ID
1141:
1142: PROCEDURE AHL_OSP_CUSTOMER (
1143: p_entity_name IN VARCHAR2,
1144: p_from_id IN NUMBER,

Line 1155: from ahl_osp_orders_b

1151: x_return_status OUT NOCOPY VARCHAR2)
1152: IS
1153: cursor c1 is
1154: select 1
1155: from ahl_osp_orders_b
1156: where customer_id = p_from_fk_id
1157: for update nowait;
1158:
1159:

Line 1200: -- In the case of AHL_OSP_ORDERS_B table, if customer id 1000 got merged to customer id 2000

1196: -- dependent record exists on the new parent. If a duplicate exists then do
1197: -- not transfer and return the id of the duplicate record as the Merged To Id
1198:
1199:
1200: -- In the case of AHL_OSP_ORDERS_B table, if customer id 1000 got merged to customer id 2000
1201: -- then, we have to update all records with customer_id = 1000 to 2000
1202:
1203: if p_from_fk_id <> p_to_fk_id then
1204: begin

Line 1207: arp_message.set_token('TABLE_NAME', 'AHL_OSP_ORDERS_B', FALSE);

1203: if p_from_fk_id <> p_to_fk_id then
1204: begin
1205: -- obtain lock on records to be updated.
1206: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1207: arp_message.set_token('TABLE_NAME', 'AHL_OSP_ORDERS_B', FALSE);
1208:
1209: open c1;
1210: close c1;
1211:

Line 1212: update ahl_osp_orders_b

1208:
1209: open c1;
1210: close c1;
1211:
1212: update ahl_osp_orders_b
1213: set customer_id = p_to_fk_id,
1214: last_update_date = SYSDATE,
1215: last_updated_by = G_USER_ID,
1216: last_update_login = G_LOGIN_ID

Line 1228: 'AHL_OSP_ORDERS_B for customer_id = ' || p_from_fk_id );

1224: exception
1225: when resource_busy then
1226: arp_message.set_line(g_proc_name || '.' || l_api_name ||
1227: '; Could not obtain lock for records in table ' ||
1228: 'AHL_OSP_ORDERS_B for customer_id = ' || p_from_fk_id );
1229: x_return_status := FND_API.G_RET_STS_ERROR;
1230: raise;
1231:
1232: when others then