APPS.UMX_PARTY_MERGE dependencies on UMX_REG_REQUESTS

Line 17: CURSOR GET_STATUS IS SELECT STATUS_CODE FROM UMX_REG_REQUESTS

13: p_batch_party_id IN NUMBER,
14: p_return_status out NOCOPY Varchar2
15: ) IS
16:
17: CURSOR GET_STATUS IS SELECT STATUS_CODE FROM UMX_REG_REQUESTS
18: WHERE REQUESTED_FOR_PARTY_ID = p_from_fk_id
19: and status_code = 'PENDING';
20: l_status_code UMX_REG_REQUESTS.STATUS_CODE%TYPE;
21:

Line 20: l_status_code UMX_REG_REQUESTS.STATUS_CODE%TYPE;

16:
17: CURSOR GET_STATUS IS SELECT STATUS_CODE FROM UMX_REG_REQUESTS
18: WHERE REQUESTED_FOR_PARTY_ID = p_from_fk_id
19: and status_code = 'PENDING';
20: l_status_code UMX_REG_REQUESTS.STATUS_CODE%TYPE;
21:
22: BEGIN
23:
24: -- Set the return status to success unless an error occurs

Line 50: update umx_reg_requests set requested_for_party_id = p_To_FK_id,

46: else
47:
48: if p_parent_entity_name = 'HZ_PARTIES' then
49: -- Update the table with the new party_id
50: update umx_reg_requests set requested_for_party_id = p_To_FK_id,
51: last_update_date = hz_utility_pub.last_update_date,
52: last_updated_by = hz_utility_pub.user_id,
53: last_update_login = hz_utility_pub.last_update_login
54: where requested_for_party_id = p_From_FK_id;