DBA Data[Home] [Help]

APPS.HZ_MERGE_PKG dependencies on HZ_ORGANIZATION_INDICATORS

Line 1633: 'HZ_ORGANIZATION_INDICATORS','HZ_PARTIES',

1629:
1630: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1631: p_to_fk_id, p_par_entity_name,
1632: 'HZ_MERGE_PKG.org_indicators_merge',
1633: 'HZ_ORGANIZATION_INDICATORS','HZ_PARTIES',
1634: 'ORGANIZATION_INDICATOR_ID', 'PARTY_ID',x_return_status);
1635:
1636: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1637: l_dup_exists := HZ_MERGE_DUP_CHECK.check_org_indicators_dup(

Line 3560: UPDATE HZ_ORGANIZATION_INDICATORS

3556: BEGIN
3557:
3558: IF (x_to_id <> FND_API.G_MISS_NUM AND
3559: x_to_id <> p_from_id) THEN
3560: UPDATE HZ_ORGANIZATION_INDICATORS
3561: SET
3562: STATUS = 'M',
3563: last_update_date = hz_utility_pub.last_update_date,
3564: last_updated_by = hz_utility_pub.user_id,

Line 3573: UPDATE HZ_ORGANIZATION_INDICATORS

3569: program_update_date = sysdate
3570: WHERE organization_indicator_id = p_from_id;
3571: ELSE
3572: -- Update and set party_id = p_to_fk_id where pk = from_id
3573: UPDATE HZ_ORGANIZATION_INDICATORS
3574: SET
3575: party_id = p_to_fk_id,
3576: last_update_date = hz_utility_pub.last_update_date,
3577: last_updated_by = hz_utility_pub.user_id,