1008: IF (x_return_status =FND_API.G_RET_STS_SUCCESS) THEN
1009: UPDATE HZ_CUST_ACCOUNTS
1010: SET
1011: selling_party_id = p_to_fk_id,
1012: last_update_date = hz_utility_pub.last_update_date,
1013: last_updated_by = hz_utility_pub.user_id,
1014: last_update_login = hz_utility_pub.last_update_login,
1015: request_id = hz_utility_pub.request_id,
1016: program_application_id = hz_utility_pub.program_application_id,
1009: UPDATE HZ_CUST_ACCOUNTS
1010: SET
1011: selling_party_id = p_to_fk_id,
1012: last_update_date = hz_utility_pub.last_update_date,
1013: last_updated_by = hz_utility_pub.user_id,
1014: last_update_login = hz_utility_pub.last_update_login,
1015: request_id = hz_utility_pub.request_id,
1016: program_application_id = hz_utility_pub.program_application_id,
1017: program_id = hz_utility_pub.program_id,
1010: SET
1011: selling_party_id = p_to_fk_id,
1012: last_update_date = hz_utility_pub.last_update_date,
1013: last_updated_by = hz_utility_pub.user_id,
1014: last_update_login = hz_utility_pub.last_update_login,
1015: request_id = hz_utility_pub.request_id,
1016: program_application_id = hz_utility_pub.program_application_id,
1017: program_id = hz_utility_pub.program_id,
1018: program_update_date = sysdate
1011: selling_party_id = p_to_fk_id,
1012: last_update_date = hz_utility_pub.last_update_date,
1013: last_updated_by = hz_utility_pub.user_id,
1014: last_update_login = hz_utility_pub.last_update_login,
1015: request_id = hz_utility_pub.request_id,
1016: program_application_id = hz_utility_pub.program_application_id,
1017: program_id = hz_utility_pub.program_id,
1018: program_update_date = sysdate
1019: WHERE cust_account_id = p_from_id;
1012: last_update_date = hz_utility_pub.last_update_date,
1013: last_updated_by = hz_utility_pub.user_id,
1014: last_update_login = hz_utility_pub.last_update_login,
1015: request_id = hz_utility_pub.request_id,
1016: program_application_id = hz_utility_pub.program_application_id,
1017: program_id = hz_utility_pub.program_id,
1018: program_update_date = sysdate
1019: WHERE cust_account_id = p_from_id;
1020: END IF;
1013: last_updated_by = hz_utility_pub.user_id,
1014: last_update_login = hz_utility_pub.last_update_login,
1015: request_id = hz_utility_pub.request_id,
1016: program_application_id = hz_utility_pub.program_application_id,
1017: program_id = hz_utility_pub.program_id,
1018: program_update_date = sysdate
1019: WHERE cust_account_id = p_from_id;
1020: END IF;
1021:
2752: x_to_id <> p_from_id) THEN
2753: UPDATE HZ_CUST_ACCOUNTS
2754: SET
2755: STATUS = 'M',
2756: last_update_date = hz_utility_pub.last_update_date,
2757: last_updated_by = hz_utility_pub.user_id,
2758: last_update_login = hz_utility_pub.last_update_login,
2759: request_id = hz_utility_pub.request_id,
2760: program_application_id = hz_utility_pub.program_application_id,
2753: UPDATE HZ_CUST_ACCOUNTS
2754: SET
2755: STATUS = 'M',
2756: last_update_date = hz_utility_pub.last_update_date,
2757: last_updated_by = hz_utility_pub.user_id,
2758: last_update_login = hz_utility_pub.last_update_login,
2759: request_id = hz_utility_pub.request_id,
2760: program_application_id = hz_utility_pub.program_application_id,
2761: program_id = hz_utility_pub.program_id,
2754: SET
2755: STATUS = 'M',
2756: last_update_date = hz_utility_pub.last_update_date,
2757: last_updated_by = hz_utility_pub.user_id,
2758: last_update_login = hz_utility_pub.last_update_login,
2759: request_id = hz_utility_pub.request_id,
2760: program_application_id = hz_utility_pub.program_application_id,
2761: program_id = hz_utility_pub.program_id,
2762: program_update_date = sysdate
2755: STATUS = 'M',
2756: last_update_date = hz_utility_pub.last_update_date,
2757: last_updated_by = hz_utility_pub.user_id,
2758: last_update_login = hz_utility_pub.last_update_login,
2759: request_id = hz_utility_pub.request_id,
2760: program_application_id = hz_utility_pub.program_application_id,
2761: program_id = hz_utility_pub.program_id,
2762: program_update_date = sysdate
2763: WHERE cust_account_id = p_from_id;
2756: last_update_date = hz_utility_pub.last_update_date,
2757: last_updated_by = hz_utility_pub.user_id,
2758: last_update_login = hz_utility_pub.last_update_login,
2759: request_id = hz_utility_pub.request_id,
2760: program_application_id = hz_utility_pub.program_application_id,
2761: program_id = hz_utility_pub.program_id,
2762: program_update_date = sysdate
2763: WHERE cust_account_id = p_from_id;
2764: HZ_ORIG_SYSTEM_REF_PVT.remap_internal_identifier(
2757: last_updated_by = hz_utility_pub.user_id,
2758: last_update_login = hz_utility_pub.last_update_login,
2759: request_id = hz_utility_pub.request_id,
2760: program_application_id = hz_utility_pub.program_application_id,
2761: program_id = hz_utility_pub.program_id,
2762: program_update_date = sysdate
2763: WHERE cust_account_id = p_from_id;
2764: HZ_ORIG_SYSTEM_REF_PVT.remap_internal_identifier(
2765: p_init_msg_list => FND_API.G_FALSE,
2784: -- Update and set party_id = p_to_fk_id where pk = from_id
2785: UPDATE HZ_CUST_ACCOUNTS
2786: SET
2787: party_id = p_to_fk_id,
2788: last_update_date = hz_utility_pub.last_update_date,
2789: last_updated_by = hz_utility_pub.user_id,
2790: last_update_login = hz_utility_pub.last_update_login,
2791: request_id = hz_utility_pub.request_id,
2792: program_application_id = hz_utility_pub.program_application_id,
2785: UPDATE HZ_CUST_ACCOUNTS
2786: SET
2787: party_id = p_to_fk_id,
2788: last_update_date = hz_utility_pub.last_update_date,
2789: last_updated_by = hz_utility_pub.user_id,
2790: last_update_login = hz_utility_pub.last_update_login,
2791: request_id = hz_utility_pub.request_id,
2792: program_application_id = hz_utility_pub.program_application_id,
2793: program_id = hz_utility_pub.program_id,
2786: SET
2787: party_id = p_to_fk_id,
2788: last_update_date = hz_utility_pub.last_update_date,
2789: last_updated_by = hz_utility_pub.user_id,
2790: last_update_login = hz_utility_pub.last_update_login,
2791: request_id = hz_utility_pub.request_id,
2792: program_application_id = hz_utility_pub.program_application_id,
2793: program_id = hz_utility_pub.program_id,
2794: program_update_date = sysdate
2787: party_id = p_to_fk_id,
2788: last_update_date = hz_utility_pub.last_update_date,
2789: last_updated_by = hz_utility_pub.user_id,
2790: last_update_login = hz_utility_pub.last_update_login,
2791: request_id = hz_utility_pub.request_id,
2792: program_application_id = hz_utility_pub.program_application_id,
2793: program_id = hz_utility_pub.program_id,
2794: program_update_date = sysdate
2795: WHERE cust_account_id = p_from_id;
2788: last_update_date = hz_utility_pub.last_update_date,
2789: last_updated_by = hz_utility_pub.user_id,
2790: last_update_login = hz_utility_pub.last_update_login,
2791: request_id = hz_utility_pub.request_id,
2792: program_application_id = hz_utility_pub.program_application_id,
2793: program_id = hz_utility_pub.program_id,
2794: program_update_date = sysdate
2795: WHERE cust_account_id = p_from_id;
2796: END IF;
2789: last_updated_by = hz_utility_pub.user_id,
2790: last_update_login = hz_utility_pub.last_update_login,
2791: request_id = hz_utility_pub.request_id,
2792: program_application_id = hz_utility_pub.program_application_id,
2793: program_id = hz_utility_pub.program_id,
2794: program_update_date = sysdate
2795: WHERE cust_account_id = p_from_id;
2796: END IF;
2797:
2843: x_to_id <> p_from_id) THEN
2844: UPDATE HZ_CUST_ACCOUNT_ROLES
2845: SET
2846: STATUS = 'M',
2847: last_update_date = hz_utility_pub.last_update_date,
2848: last_updated_by = hz_utility_pub.user_id,
2849: last_update_login = hz_utility_pub.last_update_login,
2850: request_id = hz_utility_pub.request_id,
2851: program_application_id = hz_utility_pub.program_application_id,
2844: UPDATE HZ_CUST_ACCOUNT_ROLES
2845: SET
2846: STATUS = 'M',
2847: last_update_date = hz_utility_pub.last_update_date,
2848: last_updated_by = hz_utility_pub.user_id,
2849: last_update_login = hz_utility_pub.last_update_login,
2850: request_id = hz_utility_pub.request_id,
2851: program_application_id = hz_utility_pub.program_application_id,
2852: program_id = hz_utility_pub.program_id,
2845: SET
2846: STATUS = 'M',
2847: last_update_date = hz_utility_pub.last_update_date,
2848: last_updated_by = hz_utility_pub.user_id,
2849: last_update_login = hz_utility_pub.last_update_login,
2850: request_id = hz_utility_pub.request_id,
2851: program_application_id = hz_utility_pub.program_application_id,
2852: program_id = hz_utility_pub.program_id,
2853: program_update_date = sysdate
2846: STATUS = 'M',
2847: last_update_date = hz_utility_pub.last_update_date,
2848: last_updated_by = hz_utility_pub.user_id,
2849: last_update_login = hz_utility_pub.last_update_login,
2850: request_id = hz_utility_pub.request_id,
2851: program_application_id = hz_utility_pub.program_application_id,
2852: program_id = hz_utility_pub.program_id,
2853: program_update_date = sysdate
2854: WHERE cust_account_role_id = p_from_id;
2847: last_update_date = hz_utility_pub.last_update_date,
2848: last_updated_by = hz_utility_pub.user_id,
2849: last_update_login = hz_utility_pub.last_update_login,
2850: request_id = hz_utility_pub.request_id,
2851: program_application_id = hz_utility_pub.program_application_id,
2852: program_id = hz_utility_pub.program_id,
2853: program_update_date = sysdate
2854: WHERE cust_account_role_id = p_from_id;
2855:
2848: last_updated_by = hz_utility_pub.user_id,
2849: last_update_login = hz_utility_pub.last_update_login,
2850: request_id = hz_utility_pub.request_id,
2851: program_application_id = hz_utility_pub.program_application_id,
2852: program_id = hz_utility_pub.program_id,
2853: program_update_date = sysdate
2854: WHERE cust_account_role_id = p_from_id;
2855:
2856: HZ_ORIG_SYSTEM_REF_PVT.remap_internal_identifier(
2896: UPDATE HZ_CUST_ACCOUNT_ROLES
2897: SET
2898: party_id = p_to_fk_id,
2899: status = l_status,
2900: last_update_date = hz_utility_pub.last_update_date,
2901: last_updated_by = hz_utility_pub.user_id,
2902: last_update_login = hz_utility_pub.last_update_login,
2903: request_id = hz_utility_pub.request_id,
2904: program_application_id = hz_utility_pub.program_application_id,
2897: SET
2898: party_id = p_to_fk_id,
2899: status = l_status,
2900: last_update_date = hz_utility_pub.last_update_date,
2901: last_updated_by = hz_utility_pub.user_id,
2902: last_update_login = hz_utility_pub.last_update_login,
2903: request_id = hz_utility_pub.request_id,
2904: program_application_id = hz_utility_pub.program_application_id,
2905: program_id = hz_utility_pub.program_id,
2898: party_id = p_to_fk_id,
2899: status = l_status,
2900: last_update_date = hz_utility_pub.last_update_date,
2901: last_updated_by = hz_utility_pub.user_id,
2902: last_update_login = hz_utility_pub.last_update_login,
2903: request_id = hz_utility_pub.request_id,
2904: program_application_id = hz_utility_pub.program_application_id,
2905: program_id = hz_utility_pub.program_id,
2906: program_update_date = sysdate
2899: status = l_status,
2900: last_update_date = hz_utility_pub.last_update_date,
2901: last_updated_by = hz_utility_pub.user_id,
2902: last_update_login = hz_utility_pub.last_update_login,
2903: request_id = hz_utility_pub.request_id,
2904: program_application_id = hz_utility_pub.program_application_id,
2905: program_id = hz_utility_pub.program_id,
2906: program_update_date = sysdate
2907: WHERE cust_account_role_id = p_from_id;
2900: last_update_date = hz_utility_pub.last_update_date,
2901: last_updated_by = hz_utility_pub.user_id,
2902: last_update_login = hz_utility_pub.last_update_login,
2903: request_id = hz_utility_pub.request_id,
2904: program_application_id = hz_utility_pub.program_application_id,
2905: program_id = hz_utility_pub.program_id,
2906: program_update_date = sysdate
2907: WHERE cust_account_role_id = p_from_id;
2908:
2901: last_updated_by = hz_utility_pub.user_id,
2902: last_update_login = hz_utility_pub.last_update_login,
2903: request_id = hz_utility_pub.request_id,
2904: program_application_id = hz_utility_pub.program_application_id,
2905: program_id = hz_utility_pub.program_id,
2906: program_update_date = sysdate
2907: WHERE cust_account_role_id = p_from_id;
2908:
2909: END IF;
2930: x_to_id <> p_from_id) THEN
2931: UPDATE HZ_FINANCIAL_PROFILE
2932: SET
2933: STATUS = 'M',
2934: last_update_date = hz_utility_pub.last_update_date,
2935: last_updated_by = hz_utility_pub.user_id,
2936: last_update_login = hz_utility_pub.last_update_login,
2937: request_id = hz_utility_pub.request_id,
2938: program_application_id = hz_utility_pub.program_application_id,
2931: UPDATE HZ_FINANCIAL_PROFILE
2932: SET
2933: STATUS = 'M',
2934: last_update_date = hz_utility_pub.last_update_date,
2935: last_updated_by = hz_utility_pub.user_id,
2936: last_update_login = hz_utility_pub.last_update_login,
2937: request_id = hz_utility_pub.request_id,
2938: program_application_id = hz_utility_pub.program_application_id,
2939: program_id = hz_utility_pub.program_id,
2932: SET
2933: STATUS = 'M',
2934: last_update_date = hz_utility_pub.last_update_date,
2935: last_updated_by = hz_utility_pub.user_id,
2936: last_update_login = hz_utility_pub.last_update_login,
2937: request_id = hz_utility_pub.request_id,
2938: program_application_id = hz_utility_pub.program_application_id,
2939: program_id = hz_utility_pub.program_id,
2940: program_update_date = sysdate
2933: STATUS = 'M',
2934: last_update_date = hz_utility_pub.last_update_date,
2935: last_updated_by = hz_utility_pub.user_id,
2936: last_update_login = hz_utility_pub.last_update_login,
2937: request_id = hz_utility_pub.request_id,
2938: program_application_id = hz_utility_pub.program_application_id,
2939: program_id = hz_utility_pub.program_id,
2940: program_update_date = sysdate
2941: WHERE financial_profile_id = p_from_id;
2934: last_update_date = hz_utility_pub.last_update_date,
2935: last_updated_by = hz_utility_pub.user_id,
2936: last_update_login = hz_utility_pub.last_update_login,
2937: request_id = hz_utility_pub.request_id,
2938: program_application_id = hz_utility_pub.program_application_id,
2939: program_id = hz_utility_pub.program_id,
2940: program_update_date = sysdate
2941: WHERE financial_profile_id = p_from_id;
2942: ELSE
2935: last_updated_by = hz_utility_pub.user_id,
2936: last_update_login = hz_utility_pub.last_update_login,
2937: request_id = hz_utility_pub.request_id,
2938: program_application_id = hz_utility_pub.program_application_id,
2939: program_id = hz_utility_pub.program_id,
2940: program_update_date = sysdate
2941: WHERE financial_profile_id = p_from_id;
2942: ELSE
2943: -- Update and set party_id = p_to_fk_id where pk = from_id
2943: -- Update and set party_id = p_to_fk_id where pk = from_id
2944: UPDATE HZ_FINANCIAL_PROFILE
2945: SET
2946: party_id = p_to_fk_id,
2947: last_update_date = hz_utility_pub.last_update_date,
2948: last_updated_by = hz_utility_pub.user_id,
2949: last_update_login = hz_utility_pub.last_update_login,
2950: request_id = hz_utility_pub.request_id,
2951: program_application_id = hz_utility_pub.program_application_id,
2944: UPDATE HZ_FINANCIAL_PROFILE
2945: SET
2946: party_id = p_to_fk_id,
2947: last_update_date = hz_utility_pub.last_update_date,
2948: last_updated_by = hz_utility_pub.user_id,
2949: last_update_login = hz_utility_pub.last_update_login,
2950: request_id = hz_utility_pub.request_id,
2951: program_application_id = hz_utility_pub.program_application_id,
2952: program_id = hz_utility_pub.program_id,
2945: SET
2946: party_id = p_to_fk_id,
2947: last_update_date = hz_utility_pub.last_update_date,
2948: last_updated_by = hz_utility_pub.user_id,
2949: last_update_login = hz_utility_pub.last_update_login,
2950: request_id = hz_utility_pub.request_id,
2951: program_application_id = hz_utility_pub.program_application_id,
2952: program_id = hz_utility_pub.program_id,
2953: program_update_date = sysdate
2946: party_id = p_to_fk_id,
2947: last_update_date = hz_utility_pub.last_update_date,
2948: last_updated_by = hz_utility_pub.user_id,
2949: last_update_login = hz_utility_pub.last_update_login,
2950: request_id = hz_utility_pub.request_id,
2951: program_application_id = hz_utility_pub.program_application_id,
2952: program_id = hz_utility_pub.program_id,
2953: program_update_date = sysdate
2954: WHERE financial_profile_id = p_from_id;
2947: last_update_date = hz_utility_pub.last_update_date,
2948: last_updated_by = hz_utility_pub.user_id,
2949: last_update_login = hz_utility_pub.last_update_login,
2950: request_id = hz_utility_pub.request_id,
2951: program_application_id = hz_utility_pub.program_application_id,
2952: program_id = hz_utility_pub.program_id,
2953: program_update_date = sysdate
2954: WHERE financial_profile_id = p_from_id;
2955:
2948: last_updated_by = hz_utility_pub.user_id,
2949: last_update_login = hz_utility_pub.last_update_login,
2950: request_id = hz_utility_pub.request_id,
2951: program_application_id = hz_utility_pub.program_application_id,
2952: program_id = hz_utility_pub.program_id,
2953: program_update_date = sysdate
2954: WHERE financial_profile_id = p_from_id;
2955:
2956: END IF;
3009: x_to_id <> p_from_id) THEN
3010: UPDATE HZ_CONTACT_POINTS
3011: SET
3012: STATUS = 'M',
3013: last_update_date = hz_utility_pub.last_update_date,
3014: last_updated_by = hz_utility_pub.user_id,
3015: last_update_login = hz_utility_pub.last_update_login,
3016: request_id = hz_utility_pub.request_id,
3017: program_application_id = hz_utility_pub.program_application_id,
3010: UPDATE HZ_CONTACT_POINTS
3011: SET
3012: STATUS = 'M',
3013: last_update_date = hz_utility_pub.last_update_date,
3014: last_updated_by = hz_utility_pub.user_id,
3015: last_update_login = hz_utility_pub.last_update_login,
3016: request_id = hz_utility_pub.request_id,
3017: program_application_id = hz_utility_pub.program_application_id,
3018: program_id = hz_utility_pub.program_id,
3011: SET
3012: STATUS = 'M',
3013: last_update_date = hz_utility_pub.last_update_date,
3014: last_updated_by = hz_utility_pub.user_id,
3015: last_update_login = hz_utility_pub.last_update_login,
3016: request_id = hz_utility_pub.request_id,
3017: program_application_id = hz_utility_pub.program_application_id,
3018: program_id = hz_utility_pub.program_id,
3019: program_update_date = sysdate
3012: STATUS = 'M',
3013: last_update_date = hz_utility_pub.last_update_date,
3014: last_updated_by = hz_utility_pub.user_id,
3015: last_update_login = hz_utility_pub.last_update_login,
3016: request_id = hz_utility_pub.request_id,
3017: program_application_id = hz_utility_pub.program_application_id,
3018: program_id = hz_utility_pub.program_id,
3019: program_update_date = sysdate
3020: WHERE contact_point_id = p_from_id;
3013: last_update_date = hz_utility_pub.last_update_date,
3014: last_updated_by = hz_utility_pub.user_id,
3015: last_update_login = hz_utility_pub.last_update_login,
3016: request_id = hz_utility_pub.request_id,
3017: program_application_id = hz_utility_pub.program_application_id,
3018: program_id = hz_utility_pub.program_id,
3019: program_update_date = sysdate
3020: WHERE contact_point_id = p_from_id;
3021:
3014: last_updated_by = hz_utility_pub.user_id,
3015: last_update_login = hz_utility_pub.last_update_login,
3016: request_id = hz_utility_pub.request_id,
3017: program_application_id = hz_utility_pub.program_application_id,
3018: program_id = hz_utility_pub.program_id,
3019: program_update_date = sysdate
3020: WHERE contact_point_id = p_from_id;
3021:
3022: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE STAGED_FLAG='N'
3114: SET
3115: owner_table_id = p_to_fk_id,
3116: primary_flag = l_primary_flag,
3117: primary_by_purpose = l_pri_purpose_flag,
3118: last_update_date = hz_utility_pub.last_update_date,
3119: last_updated_by = hz_utility_pub.user_id,
3120: last_update_login = hz_utility_pub.last_update_login,
3121: request_id = hz_utility_pub.request_id,
3122: program_application_id = hz_utility_pub.program_application_id,
3115: owner_table_id = p_to_fk_id,
3116: primary_flag = l_primary_flag,
3117: primary_by_purpose = l_pri_purpose_flag,
3118: last_update_date = hz_utility_pub.last_update_date,
3119: last_updated_by = hz_utility_pub.user_id,
3120: last_update_login = hz_utility_pub.last_update_login,
3121: request_id = hz_utility_pub.request_id,
3122: program_application_id = hz_utility_pub.program_application_id,
3123: program_id = hz_utility_pub.program_id,
3116: primary_flag = l_primary_flag,
3117: primary_by_purpose = l_pri_purpose_flag,
3118: last_update_date = hz_utility_pub.last_update_date,
3119: last_updated_by = hz_utility_pub.user_id,
3120: last_update_login = hz_utility_pub.last_update_login,
3121: request_id = hz_utility_pub.request_id,
3122: program_application_id = hz_utility_pub.program_application_id,
3123: program_id = hz_utility_pub.program_id,
3124: program_update_date = sysdate
3117: primary_by_purpose = l_pri_purpose_flag,
3118: last_update_date = hz_utility_pub.last_update_date,
3119: last_updated_by = hz_utility_pub.user_id,
3120: last_update_login = hz_utility_pub.last_update_login,
3121: request_id = hz_utility_pub.request_id,
3122: program_application_id = hz_utility_pub.program_application_id,
3123: program_id = hz_utility_pub.program_id,
3124: program_update_date = sysdate
3125: WHERE contact_point_id = p_from_id;
3118: last_update_date = hz_utility_pub.last_update_date,
3119: last_updated_by = hz_utility_pub.user_id,
3120: last_update_login = hz_utility_pub.last_update_login,
3121: request_id = hz_utility_pub.request_id,
3122: program_application_id = hz_utility_pub.program_application_id,
3123: program_id = hz_utility_pub.program_id,
3124: program_update_date = sysdate
3125: WHERE contact_point_id = p_from_id;
3126:
3119: last_updated_by = hz_utility_pub.user_id,
3120: last_update_login = hz_utility_pub.last_update_login,
3121: request_id = hz_utility_pub.request_id,
3122: program_application_id = hz_utility_pub.program_application_id,
3123: program_id = hz_utility_pub.program_id,
3124: program_update_date = sysdate
3125: WHERE contact_point_id = p_from_id;
3126:
3127: END IF;
3167: -- Update and set status to merged
3168: UPDATE HZ_CONTACT_POINTS
3169: SET
3170: STATUS = 'M',
3171: last_update_date = hz_utility_pub.last_update_date,
3172: last_updated_by = hz_utility_pub.user_id,
3173: last_update_login = hz_utility_pub.last_update_login,
3174: request_id = hz_utility_pub.request_id,
3175: program_application_id = hz_utility_pub.program_application_id,
3168: UPDATE HZ_CONTACT_POINTS
3169: SET
3170: STATUS = 'M',
3171: last_update_date = hz_utility_pub.last_update_date,
3172: last_updated_by = hz_utility_pub.user_id,
3173: last_update_login = hz_utility_pub.last_update_login,
3174: request_id = hz_utility_pub.request_id,
3175: program_application_id = hz_utility_pub.program_application_id,
3176: program_id = hz_utility_pub.program_id,
3169: SET
3170: STATUS = 'M',
3171: last_update_date = hz_utility_pub.last_update_date,
3172: last_updated_by = hz_utility_pub.user_id,
3173: last_update_login = hz_utility_pub.last_update_login,
3174: request_id = hz_utility_pub.request_id,
3175: program_application_id = hz_utility_pub.program_application_id,
3176: program_id = hz_utility_pub.program_id,
3177: program_update_date = sysdate
3170: STATUS = 'M',
3171: last_update_date = hz_utility_pub.last_update_date,
3172: last_updated_by = hz_utility_pub.user_id,
3173: last_update_login = hz_utility_pub.last_update_login,
3174: request_id = hz_utility_pub.request_id,
3175: program_application_id = hz_utility_pub.program_application_id,
3176: program_id = hz_utility_pub.program_id,
3177: program_update_date = sysdate
3178: WHERE contact_point_id = p_from_id;
3171: last_update_date = hz_utility_pub.last_update_date,
3172: last_updated_by = hz_utility_pub.user_id,
3173: last_update_login = hz_utility_pub.last_update_login,
3174: request_id = hz_utility_pub.request_id,
3175: program_application_id = hz_utility_pub.program_application_id,
3176: program_id = hz_utility_pub.program_id,
3177: program_update_date = sysdate
3178: WHERE contact_point_id = p_from_id;
3179:
3172: last_updated_by = hz_utility_pub.user_id,
3173: last_update_login = hz_utility_pub.last_update_login,
3174: request_id = hz_utility_pub.request_id,
3175: program_application_id = hz_utility_pub.program_application_id,
3176: program_id = hz_utility_pub.program_id,
3177: program_update_date = sysdate
3178: WHERE contact_point_id = p_from_id;
3179:
3180: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE STAGED_FLAG='N'
3246: SET
3247: owner_table_id = p_to_fk_id,
3248: primary_flag = l_primary_flag,
3249: primary_by_purpose = l_pri_purpose_flag,
3250: last_update_date = hz_utility_pub.last_update_date,
3251: last_updated_by = hz_utility_pub.user_id,
3252: last_update_login = hz_utility_pub.last_update_login,
3253: request_id = hz_utility_pub.request_id,
3254: program_application_id = hz_utility_pub.program_application_id,
3247: owner_table_id = p_to_fk_id,
3248: primary_flag = l_primary_flag,
3249: primary_by_purpose = l_pri_purpose_flag,
3250: last_update_date = hz_utility_pub.last_update_date,
3251: last_updated_by = hz_utility_pub.user_id,
3252: last_update_login = hz_utility_pub.last_update_login,
3253: request_id = hz_utility_pub.request_id,
3254: program_application_id = hz_utility_pub.program_application_id,
3255: program_id = hz_utility_pub.program_id,
3248: primary_flag = l_primary_flag,
3249: primary_by_purpose = l_pri_purpose_flag,
3250: last_update_date = hz_utility_pub.last_update_date,
3251: last_updated_by = hz_utility_pub.user_id,
3252: last_update_login = hz_utility_pub.last_update_login,
3253: request_id = hz_utility_pub.request_id,
3254: program_application_id = hz_utility_pub.program_application_id,
3255: program_id = hz_utility_pub.program_id,
3256: program_update_date = sysdate
3249: primary_by_purpose = l_pri_purpose_flag,
3250: last_update_date = hz_utility_pub.last_update_date,
3251: last_updated_by = hz_utility_pub.user_id,
3252: last_update_login = hz_utility_pub.last_update_login,
3253: request_id = hz_utility_pub.request_id,
3254: program_application_id = hz_utility_pub.program_application_id,
3255: program_id = hz_utility_pub.program_id,
3256: program_update_date = sysdate
3257: WHERE contact_point_id = p_from_id;
3250: last_update_date = hz_utility_pub.last_update_date,
3251: last_updated_by = hz_utility_pub.user_id,
3252: last_update_login = hz_utility_pub.last_update_login,
3253: request_id = hz_utility_pub.request_id,
3254: program_application_id = hz_utility_pub.program_application_id,
3255: program_id = hz_utility_pub.program_id,
3256: program_update_date = sysdate
3257: WHERE contact_point_id = p_from_id;
3258:
3251: last_updated_by = hz_utility_pub.user_id,
3252: last_update_login = hz_utility_pub.last_update_login,
3253: request_id = hz_utility_pub.request_id,
3254: program_application_id = hz_utility_pub.program_application_id,
3255: program_id = hz_utility_pub.program_id,
3256: program_update_date = sysdate
3257: WHERE contact_point_id = p_from_id;
3258:
3259: END IF;
3279: x_to_id <> p_from_id) THEN
3280: UPDATE HZ_CONTACT_PREFERENCES
3281: SET
3282: status = 'M',
3283: last_update_date = hz_utility_pub.last_update_date,
3284: last_updated_by = hz_utility_pub.user_id,
3285: last_update_login = hz_utility_pub.last_update_login,
3286: request_id = hz_utility_pub.request_id,
3287: program_application_id = hz_utility_pub.program_application_id,
3280: UPDATE HZ_CONTACT_PREFERENCES
3281: SET
3282: status = 'M',
3283: last_update_date = hz_utility_pub.last_update_date,
3284: last_updated_by = hz_utility_pub.user_id,
3285: last_update_login = hz_utility_pub.last_update_login,
3286: request_id = hz_utility_pub.request_id,
3287: program_application_id = hz_utility_pub.program_application_id,
3288: program_id = hz_utility_pub.program_id,
3281: SET
3282: status = 'M',
3283: last_update_date = hz_utility_pub.last_update_date,
3284: last_updated_by = hz_utility_pub.user_id,
3285: last_update_login = hz_utility_pub.last_update_login,
3286: request_id = hz_utility_pub.request_id,
3287: program_application_id = hz_utility_pub.program_application_id,
3288: program_id = hz_utility_pub.program_id,
3289: program_update_date = sysdate
3282: status = 'M',
3283: last_update_date = hz_utility_pub.last_update_date,
3284: last_updated_by = hz_utility_pub.user_id,
3285: last_update_login = hz_utility_pub.last_update_login,
3286: request_id = hz_utility_pub.request_id,
3287: program_application_id = hz_utility_pub.program_application_id,
3288: program_id = hz_utility_pub.program_id,
3289: program_update_date = sysdate
3290: WHERE contact_preference_id = p_from_id;
3283: last_update_date = hz_utility_pub.last_update_date,
3284: last_updated_by = hz_utility_pub.user_id,
3285: last_update_login = hz_utility_pub.last_update_login,
3286: request_id = hz_utility_pub.request_id,
3287: program_application_id = hz_utility_pub.program_application_id,
3288: program_id = hz_utility_pub.program_id,
3289: program_update_date = sysdate
3290: WHERE contact_preference_id = p_from_id;
3291: ELSE
3284: last_updated_by = hz_utility_pub.user_id,
3285: last_update_login = hz_utility_pub.last_update_login,
3286: request_id = hz_utility_pub.request_id,
3287: program_application_id = hz_utility_pub.program_application_id,
3288: program_id = hz_utility_pub.program_id,
3289: program_update_date = sysdate
3290: WHERE contact_preference_id = p_from_id;
3291: ELSE
3292: -- Update and set contact_level_table_id = p_to_fk_id where pk = from_id
3292: -- Update and set contact_level_table_id = p_to_fk_id where pk = from_id
3293: UPDATE HZ_CONTACT_PREFERENCES
3294: SET
3295: contact_level_table_id = p_to_fk_id,
3296: last_update_date = hz_utility_pub.last_update_date,
3297: last_updated_by = hz_utility_pub.user_id,
3298: last_update_login = hz_utility_pub.last_update_login,
3299: request_id = hz_utility_pub.request_id,
3300: program_application_id = hz_utility_pub.program_application_id,
3293: UPDATE HZ_CONTACT_PREFERENCES
3294: SET
3295: contact_level_table_id = p_to_fk_id,
3296: last_update_date = hz_utility_pub.last_update_date,
3297: last_updated_by = hz_utility_pub.user_id,
3298: last_update_login = hz_utility_pub.last_update_login,
3299: request_id = hz_utility_pub.request_id,
3300: program_application_id = hz_utility_pub.program_application_id,
3301: program_id = hz_utility_pub.program_id,
3294: SET
3295: contact_level_table_id = p_to_fk_id,
3296: last_update_date = hz_utility_pub.last_update_date,
3297: last_updated_by = hz_utility_pub.user_id,
3298: last_update_login = hz_utility_pub.last_update_login,
3299: request_id = hz_utility_pub.request_id,
3300: program_application_id = hz_utility_pub.program_application_id,
3301: program_id = hz_utility_pub.program_id,
3302: program_update_date = sysdate
3295: contact_level_table_id = p_to_fk_id,
3296: last_update_date = hz_utility_pub.last_update_date,
3297: last_updated_by = hz_utility_pub.user_id,
3298: last_update_login = hz_utility_pub.last_update_login,
3299: request_id = hz_utility_pub.request_id,
3300: program_application_id = hz_utility_pub.program_application_id,
3301: program_id = hz_utility_pub.program_id,
3302: program_update_date = sysdate
3303: WHERE contact_preference_id = p_from_id;
3296: last_update_date = hz_utility_pub.last_update_date,
3297: last_updated_by = hz_utility_pub.user_id,
3298: last_update_login = hz_utility_pub.last_update_login,
3299: request_id = hz_utility_pub.request_id,
3300: program_application_id = hz_utility_pub.program_application_id,
3301: program_id = hz_utility_pub.program_id,
3302: program_update_date = sysdate
3303: WHERE contact_preference_id = p_from_id;
3304:
3297: last_updated_by = hz_utility_pub.user_id,
3298: last_update_login = hz_utility_pub.last_update_login,
3299: request_id = hz_utility_pub.request_id,
3300: program_application_id = hz_utility_pub.program_application_id,
3301: program_id = hz_utility_pub.program_id,
3302: program_update_date = sysdate
3303: WHERE contact_preference_id = p_from_id;
3304:
3305: END IF;
3326: x_to_id <> p_from_id) THEN
3327: UPDATE HZ_REFERENCES
3328: SET
3329: status = 'M',
3330: last_update_date = hz_utility_pub.last_update_date,
3331: last_updated_by = hz_utility_pub.user_id,
3332: last_update_login = hz_utility_pub.last_update_login,
3333: request_id = hz_utility_pub.request_id,
3334: program_application_id = hz_utility_pub.program_application_id,
3327: UPDATE HZ_REFERENCES
3328: SET
3329: status = 'M',
3330: last_update_date = hz_utility_pub.last_update_date,
3331: last_updated_by = hz_utility_pub.user_id,
3332: last_update_login = hz_utility_pub.last_update_login,
3333: request_id = hz_utility_pub.request_id,
3334: program_application_id = hz_utility_pub.program_application_id,
3335: program_id = hz_utility_pub.program_id,
3328: SET
3329: status = 'M',
3330: last_update_date = hz_utility_pub.last_update_date,
3331: last_updated_by = hz_utility_pub.user_id,
3332: last_update_login = hz_utility_pub.last_update_login,
3333: request_id = hz_utility_pub.request_id,
3334: program_application_id = hz_utility_pub.program_application_id,
3335: program_id = hz_utility_pub.program_id,
3336: program_update_date = sysdate
3329: status = 'M',
3330: last_update_date = hz_utility_pub.last_update_date,
3331: last_updated_by = hz_utility_pub.user_id,
3332: last_update_login = hz_utility_pub.last_update_login,
3333: request_id = hz_utility_pub.request_id,
3334: program_application_id = hz_utility_pub.program_application_id,
3335: program_id = hz_utility_pub.program_id,
3336: program_update_date = sysdate
3337: WHERE reference_id = p_from_id;
3330: last_update_date = hz_utility_pub.last_update_date,
3331: last_updated_by = hz_utility_pub.user_id,
3332: last_update_login = hz_utility_pub.last_update_login,
3333: request_id = hz_utility_pub.request_id,
3334: program_application_id = hz_utility_pub.program_application_id,
3335: program_id = hz_utility_pub.program_id,
3336: program_update_date = sysdate
3337: WHERE reference_id = p_from_id;
3338: ELSE
3331: last_updated_by = hz_utility_pub.user_id,
3332: last_update_login = hz_utility_pub.last_update_login,
3333: request_id = hz_utility_pub.request_id,
3334: program_application_id = hz_utility_pub.program_application_id,
3335: program_id = hz_utility_pub.program_id,
3336: program_update_date = sysdate
3337: WHERE reference_id = p_from_id;
3338: ELSE
3339: -- Update and set party_id = p_to_fk_id where pk = from_id
3339: -- Update and set party_id = p_to_fk_id where pk = from_id
3340: UPDATE HZ_REFERENCES
3341: SET
3342: referenced_party_id = p_to_fk_id,
3343: last_update_date = hz_utility_pub.last_update_date,
3344: last_updated_by = hz_utility_pub.user_id,
3345: last_update_login = hz_utility_pub.last_update_login,
3346: request_id = hz_utility_pub.request_id,
3347: program_application_id = hz_utility_pub.program_application_id,
3340: UPDATE HZ_REFERENCES
3341: SET
3342: referenced_party_id = p_to_fk_id,
3343: last_update_date = hz_utility_pub.last_update_date,
3344: last_updated_by = hz_utility_pub.user_id,
3345: last_update_login = hz_utility_pub.last_update_login,
3346: request_id = hz_utility_pub.request_id,
3347: program_application_id = hz_utility_pub.program_application_id,
3348: program_id = hz_utility_pub.program_id,
3341: SET
3342: referenced_party_id = p_to_fk_id,
3343: last_update_date = hz_utility_pub.last_update_date,
3344: last_updated_by = hz_utility_pub.user_id,
3345: last_update_login = hz_utility_pub.last_update_login,
3346: request_id = hz_utility_pub.request_id,
3347: program_application_id = hz_utility_pub.program_application_id,
3348: program_id = hz_utility_pub.program_id,
3349: program_update_date = sysdate
3342: referenced_party_id = p_to_fk_id,
3343: last_update_date = hz_utility_pub.last_update_date,
3344: last_updated_by = hz_utility_pub.user_id,
3345: last_update_login = hz_utility_pub.last_update_login,
3346: request_id = hz_utility_pub.request_id,
3347: program_application_id = hz_utility_pub.program_application_id,
3348: program_id = hz_utility_pub.program_id,
3349: program_update_date = sysdate
3350: WHERE reference_id = p_from_id;
3343: last_update_date = hz_utility_pub.last_update_date,
3344: last_updated_by = hz_utility_pub.user_id,
3345: last_update_login = hz_utility_pub.last_update_login,
3346: request_id = hz_utility_pub.request_id,
3347: program_application_id = hz_utility_pub.program_application_id,
3348: program_id = hz_utility_pub.program_id,
3349: program_update_date = sysdate
3350: WHERE reference_id = p_from_id;
3351:
3344: last_updated_by = hz_utility_pub.user_id,
3345: last_update_login = hz_utility_pub.last_update_login,
3346: request_id = hz_utility_pub.request_id,
3347: program_application_id = hz_utility_pub.program_application_id,
3348: program_id = hz_utility_pub.program_id,
3349: program_update_date = sysdate
3350: WHERE reference_id = p_from_id;
3351:
3352: END IF;
3373: x_to_id <> p_from_id) THEN
3374: UPDATE HZ_CERTIFICATIONS
3375: SET
3376: STATUS = 'M',
3377: last_update_date = hz_utility_pub.last_update_date,
3378: last_updated_by = hz_utility_pub.user_id,
3379: last_update_login = hz_utility_pub.last_update_login,
3380: request_id = hz_utility_pub.request_id,
3381: program_application_id = hz_utility_pub.program_application_id,
3374: UPDATE HZ_CERTIFICATIONS
3375: SET
3376: STATUS = 'M',
3377: last_update_date = hz_utility_pub.last_update_date,
3378: last_updated_by = hz_utility_pub.user_id,
3379: last_update_login = hz_utility_pub.last_update_login,
3380: request_id = hz_utility_pub.request_id,
3381: program_application_id = hz_utility_pub.program_application_id,
3382: program_id = hz_utility_pub.program_id,
3375: SET
3376: STATUS = 'M',
3377: last_update_date = hz_utility_pub.last_update_date,
3378: last_updated_by = hz_utility_pub.user_id,
3379: last_update_login = hz_utility_pub.last_update_login,
3380: request_id = hz_utility_pub.request_id,
3381: program_application_id = hz_utility_pub.program_application_id,
3382: program_id = hz_utility_pub.program_id,
3383: program_update_date = sysdate
3376: STATUS = 'M',
3377: last_update_date = hz_utility_pub.last_update_date,
3378: last_updated_by = hz_utility_pub.user_id,
3379: last_update_login = hz_utility_pub.last_update_login,
3380: request_id = hz_utility_pub.request_id,
3381: program_application_id = hz_utility_pub.program_application_id,
3382: program_id = hz_utility_pub.program_id,
3383: program_update_date = sysdate
3384: WHERE certification_id = p_from_id;
3377: last_update_date = hz_utility_pub.last_update_date,
3378: last_updated_by = hz_utility_pub.user_id,
3379: last_update_login = hz_utility_pub.last_update_login,
3380: request_id = hz_utility_pub.request_id,
3381: program_application_id = hz_utility_pub.program_application_id,
3382: program_id = hz_utility_pub.program_id,
3383: program_update_date = sysdate
3384: WHERE certification_id = p_from_id;
3385: ELSE
3378: last_updated_by = hz_utility_pub.user_id,
3379: last_update_login = hz_utility_pub.last_update_login,
3380: request_id = hz_utility_pub.request_id,
3381: program_application_id = hz_utility_pub.program_application_id,
3382: program_id = hz_utility_pub.program_id,
3383: program_update_date = sysdate
3384: WHERE certification_id = p_from_id;
3385: ELSE
3386: -- Update and set party_id = p_to_fk_id where pk = from_id
3386: -- Update and set party_id = p_to_fk_id where pk = from_id
3387: UPDATE HZ_CERTIFICATIONS
3388: SET
3389: party_id = p_to_fk_id,
3390: last_update_date = hz_utility_pub.last_update_date,
3391: last_updated_by = hz_utility_pub.user_id,
3392: last_update_login = hz_utility_pub.last_update_login,
3393: request_id = hz_utility_pub.request_id,
3394: program_application_id = hz_utility_pub.program_application_id,
3387: UPDATE HZ_CERTIFICATIONS
3388: SET
3389: party_id = p_to_fk_id,
3390: last_update_date = hz_utility_pub.last_update_date,
3391: last_updated_by = hz_utility_pub.user_id,
3392: last_update_login = hz_utility_pub.last_update_login,
3393: request_id = hz_utility_pub.request_id,
3394: program_application_id = hz_utility_pub.program_application_id,
3395: program_id = hz_utility_pub.program_id,
3388: SET
3389: party_id = p_to_fk_id,
3390: last_update_date = hz_utility_pub.last_update_date,
3391: last_updated_by = hz_utility_pub.user_id,
3392: last_update_login = hz_utility_pub.last_update_login,
3393: request_id = hz_utility_pub.request_id,
3394: program_application_id = hz_utility_pub.program_application_id,
3395: program_id = hz_utility_pub.program_id,
3396: program_update_date = sysdate
3389: party_id = p_to_fk_id,
3390: last_update_date = hz_utility_pub.last_update_date,
3391: last_updated_by = hz_utility_pub.user_id,
3392: last_update_login = hz_utility_pub.last_update_login,
3393: request_id = hz_utility_pub.request_id,
3394: program_application_id = hz_utility_pub.program_application_id,
3395: program_id = hz_utility_pub.program_id,
3396: program_update_date = sysdate
3397: WHERE certification_id = p_from_id;
3390: last_update_date = hz_utility_pub.last_update_date,
3391: last_updated_by = hz_utility_pub.user_id,
3392: last_update_login = hz_utility_pub.last_update_login,
3393: request_id = hz_utility_pub.request_id,
3394: program_application_id = hz_utility_pub.program_application_id,
3395: program_id = hz_utility_pub.program_id,
3396: program_update_date = sysdate
3397: WHERE certification_id = p_from_id;
3398:
3391: last_updated_by = hz_utility_pub.user_id,
3392: last_update_login = hz_utility_pub.last_update_login,
3393: request_id = hz_utility_pub.request_id,
3394: program_application_id = hz_utility_pub.program_application_id,
3395: program_id = hz_utility_pub.program_id,
3396: program_update_date = sysdate
3397: WHERE certification_id = p_from_id;
3398:
3399: END IF;
3420: x_to_id <> p_from_id) THEN
3421: UPDATE HZ_CREDIT_RATINGS
3422: SET
3423: STATUS = 'M',
3424: last_update_date = hz_utility_pub.last_update_date,
3425: last_updated_by = hz_utility_pub.user_id,
3426: last_update_login = hz_utility_pub.last_update_login,
3427: request_id = hz_utility_pub.request_id,
3428: program_application_id = hz_utility_pub.program_application_id,
3421: UPDATE HZ_CREDIT_RATINGS
3422: SET
3423: STATUS = 'M',
3424: last_update_date = hz_utility_pub.last_update_date,
3425: last_updated_by = hz_utility_pub.user_id,
3426: last_update_login = hz_utility_pub.last_update_login,
3427: request_id = hz_utility_pub.request_id,
3428: program_application_id = hz_utility_pub.program_application_id,
3429: program_id = hz_utility_pub.program_id,
3422: SET
3423: STATUS = 'M',
3424: last_update_date = hz_utility_pub.last_update_date,
3425: last_updated_by = hz_utility_pub.user_id,
3426: last_update_login = hz_utility_pub.last_update_login,
3427: request_id = hz_utility_pub.request_id,
3428: program_application_id = hz_utility_pub.program_application_id,
3429: program_id = hz_utility_pub.program_id,
3430: program_update_date = sysdate
3423: STATUS = 'M',
3424: last_update_date = hz_utility_pub.last_update_date,
3425: last_updated_by = hz_utility_pub.user_id,
3426: last_update_login = hz_utility_pub.last_update_login,
3427: request_id = hz_utility_pub.request_id,
3428: program_application_id = hz_utility_pub.program_application_id,
3429: program_id = hz_utility_pub.program_id,
3430: program_update_date = sysdate
3431: WHERE credit_rating_id = p_from_id;
3424: last_update_date = hz_utility_pub.last_update_date,
3425: last_updated_by = hz_utility_pub.user_id,
3426: last_update_login = hz_utility_pub.last_update_login,
3427: request_id = hz_utility_pub.request_id,
3428: program_application_id = hz_utility_pub.program_application_id,
3429: program_id = hz_utility_pub.program_id,
3430: program_update_date = sysdate
3431: WHERE credit_rating_id = p_from_id;
3432: ELSE
3425: last_updated_by = hz_utility_pub.user_id,
3426: last_update_login = hz_utility_pub.last_update_login,
3427: request_id = hz_utility_pub.request_id,
3428: program_application_id = hz_utility_pub.program_application_id,
3429: program_id = hz_utility_pub.program_id,
3430: program_update_date = sysdate
3431: WHERE credit_rating_id = p_from_id;
3432: ELSE
3433: -- Update and set party_id = p_to_fk_id where pk = from_id
3433: -- Update and set party_id = p_to_fk_id where pk = from_id
3434: UPDATE HZ_CREDIT_RATINGS
3435: SET
3436: party_id = p_to_fk_id,
3437: last_update_date = hz_utility_pub.last_update_date,
3438: last_updated_by = hz_utility_pub.user_id,
3439: last_update_login = hz_utility_pub.last_update_login,
3440: request_id = hz_utility_pub.request_id,
3441: program_application_id = hz_utility_pub.program_application_id,
3434: UPDATE HZ_CREDIT_RATINGS
3435: SET
3436: party_id = p_to_fk_id,
3437: last_update_date = hz_utility_pub.last_update_date,
3438: last_updated_by = hz_utility_pub.user_id,
3439: last_update_login = hz_utility_pub.last_update_login,
3440: request_id = hz_utility_pub.request_id,
3441: program_application_id = hz_utility_pub.program_application_id,
3442: program_id = hz_utility_pub.program_id,
3435: SET
3436: party_id = p_to_fk_id,
3437: last_update_date = hz_utility_pub.last_update_date,
3438: last_updated_by = hz_utility_pub.user_id,
3439: last_update_login = hz_utility_pub.last_update_login,
3440: request_id = hz_utility_pub.request_id,
3441: program_application_id = hz_utility_pub.program_application_id,
3442: program_id = hz_utility_pub.program_id,
3443: program_update_date = sysdate
3436: party_id = p_to_fk_id,
3437: last_update_date = hz_utility_pub.last_update_date,
3438: last_updated_by = hz_utility_pub.user_id,
3439: last_update_login = hz_utility_pub.last_update_login,
3440: request_id = hz_utility_pub.request_id,
3441: program_application_id = hz_utility_pub.program_application_id,
3442: program_id = hz_utility_pub.program_id,
3443: program_update_date = sysdate
3444: WHERE credit_rating_id = p_from_id;
3437: last_update_date = hz_utility_pub.last_update_date,
3438: last_updated_by = hz_utility_pub.user_id,
3439: last_update_login = hz_utility_pub.last_update_login,
3440: request_id = hz_utility_pub.request_id,
3441: program_application_id = hz_utility_pub.program_application_id,
3442: program_id = hz_utility_pub.program_id,
3443: program_update_date = sysdate
3444: WHERE credit_rating_id = p_from_id;
3445:
3438: last_updated_by = hz_utility_pub.user_id,
3439: last_update_login = hz_utility_pub.last_update_login,
3440: request_id = hz_utility_pub.request_id,
3441: program_application_id = hz_utility_pub.program_application_id,
3442: program_id = hz_utility_pub.program_id,
3443: program_update_date = sysdate
3444: WHERE credit_rating_id = p_from_id;
3445:
3446: END IF;
3467: x_to_id <> p_from_id) THEN
3468: UPDATE HZ_SECURITY_ISSUED
3469: SET
3470: STATUS = 'M',
3471: last_update_date = hz_utility_pub.last_update_date,
3472: last_updated_by = hz_utility_pub.user_id,
3473: last_update_login = hz_utility_pub.last_update_login,
3474: request_id = hz_utility_pub.request_id,
3475: program_application_id = hz_utility_pub.program_application_id,
3468: UPDATE HZ_SECURITY_ISSUED
3469: SET
3470: STATUS = 'M',
3471: last_update_date = hz_utility_pub.last_update_date,
3472: last_updated_by = hz_utility_pub.user_id,
3473: last_update_login = hz_utility_pub.last_update_login,
3474: request_id = hz_utility_pub.request_id,
3475: program_application_id = hz_utility_pub.program_application_id,
3476: program_id = hz_utility_pub.program_id,
3469: SET
3470: STATUS = 'M',
3471: last_update_date = hz_utility_pub.last_update_date,
3472: last_updated_by = hz_utility_pub.user_id,
3473: last_update_login = hz_utility_pub.last_update_login,
3474: request_id = hz_utility_pub.request_id,
3475: program_application_id = hz_utility_pub.program_application_id,
3476: program_id = hz_utility_pub.program_id,
3477: program_update_date = sysdate
3470: STATUS = 'M',
3471: last_update_date = hz_utility_pub.last_update_date,
3472: last_updated_by = hz_utility_pub.user_id,
3473: last_update_login = hz_utility_pub.last_update_login,
3474: request_id = hz_utility_pub.request_id,
3475: program_application_id = hz_utility_pub.program_application_id,
3476: program_id = hz_utility_pub.program_id,
3477: program_update_date = sysdate
3478: WHERE security_issued_id = p_from_id;
3471: last_update_date = hz_utility_pub.last_update_date,
3472: last_updated_by = hz_utility_pub.user_id,
3473: last_update_login = hz_utility_pub.last_update_login,
3474: request_id = hz_utility_pub.request_id,
3475: program_application_id = hz_utility_pub.program_application_id,
3476: program_id = hz_utility_pub.program_id,
3477: program_update_date = sysdate
3478: WHERE security_issued_id = p_from_id;
3479: ELSE
3472: last_updated_by = hz_utility_pub.user_id,
3473: last_update_login = hz_utility_pub.last_update_login,
3474: request_id = hz_utility_pub.request_id,
3475: program_application_id = hz_utility_pub.program_application_id,
3476: program_id = hz_utility_pub.program_id,
3477: program_update_date = sysdate
3478: WHERE security_issued_id = p_from_id;
3479: ELSE
3480: -- Update and set party_id = p_to_fk_id where pk = from_id
3480: -- Update and set party_id = p_to_fk_id where pk = from_id
3481: UPDATE HZ_SECURITY_ISSUED
3482: SET
3483: party_id = p_to_fk_id,
3484: last_update_date = hz_utility_pub.last_update_date,
3485: last_updated_by = hz_utility_pub.user_id,
3486: last_update_login = hz_utility_pub.last_update_login,
3487: request_id = hz_utility_pub.request_id,
3488: program_application_id = hz_utility_pub.program_application_id,
3481: UPDATE HZ_SECURITY_ISSUED
3482: SET
3483: party_id = p_to_fk_id,
3484: last_update_date = hz_utility_pub.last_update_date,
3485: last_updated_by = hz_utility_pub.user_id,
3486: last_update_login = hz_utility_pub.last_update_login,
3487: request_id = hz_utility_pub.request_id,
3488: program_application_id = hz_utility_pub.program_application_id,
3489: program_id = hz_utility_pub.program_id,
3482: SET
3483: party_id = p_to_fk_id,
3484: last_update_date = hz_utility_pub.last_update_date,
3485: last_updated_by = hz_utility_pub.user_id,
3486: last_update_login = hz_utility_pub.last_update_login,
3487: request_id = hz_utility_pub.request_id,
3488: program_application_id = hz_utility_pub.program_application_id,
3489: program_id = hz_utility_pub.program_id,
3490: program_update_date = sysdate
3483: party_id = p_to_fk_id,
3484: last_update_date = hz_utility_pub.last_update_date,
3485: last_updated_by = hz_utility_pub.user_id,
3486: last_update_login = hz_utility_pub.last_update_login,
3487: request_id = hz_utility_pub.request_id,
3488: program_application_id = hz_utility_pub.program_application_id,
3489: program_id = hz_utility_pub.program_id,
3490: program_update_date = sysdate
3491: WHERE security_issued_id = p_from_id;
3484: last_update_date = hz_utility_pub.last_update_date,
3485: last_updated_by = hz_utility_pub.user_id,
3486: last_update_login = hz_utility_pub.last_update_login,
3487: request_id = hz_utility_pub.request_id,
3488: program_application_id = hz_utility_pub.program_application_id,
3489: program_id = hz_utility_pub.program_id,
3490: program_update_date = sysdate
3491: WHERE security_issued_id = p_from_id;
3492:
3485: last_updated_by = hz_utility_pub.user_id,
3486: last_update_login = hz_utility_pub.last_update_login,
3487: request_id = hz_utility_pub.request_id,
3488: program_application_id = hz_utility_pub.program_application_id,
3489: program_id = hz_utility_pub.program_id,
3490: program_update_date = sysdate
3491: WHERE security_issued_id = p_from_id;
3492:
3493: END IF;
3514: x_to_id <> p_from_id) THEN
3515: UPDATE HZ_FINANCIAL_REPORTS
3516: SET
3517: STATUS = 'M',
3518: last_update_date = hz_utility_pub.last_update_date,
3519: last_updated_by = hz_utility_pub.user_id,
3520: last_update_login = hz_utility_pub.last_update_login,
3521: request_id = hz_utility_pub.request_id,
3522: program_application_id = hz_utility_pub.program_application_id,
3515: UPDATE HZ_FINANCIAL_REPORTS
3516: SET
3517: STATUS = 'M',
3518: last_update_date = hz_utility_pub.last_update_date,
3519: last_updated_by = hz_utility_pub.user_id,
3520: last_update_login = hz_utility_pub.last_update_login,
3521: request_id = hz_utility_pub.request_id,
3522: program_application_id = hz_utility_pub.program_application_id,
3523: program_id = hz_utility_pub.program_id,
3516: SET
3517: STATUS = 'M',
3518: last_update_date = hz_utility_pub.last_update_date,
3519: last_updated_by = hz_utility_pub.user_id,
3520: last_update_login = hz_utility_pub.last_update_login,
3521: request_id = hz_utility_pub.request_id,
3522: program_application_id = hz_utility_pub.program_application_id,
3523: program_id = hz_utility_pub.program_id,
3524: program_update_date = sysdate
3517: STATUS = 'M',
3518: last_update_date = hz_utility_pub.last_update_date,
3519: last_updated_by = hz_utility_pub.user_id,
3520: last_update_login = hz_utility_pub.last_update_login,
3521: request_id = hz_utility_pub.request_id,
3522: program_application_id = hz_utility_pub.program_application_id,
3523: program_id = hz_utility_pub.program_id,
3524: program_update_date = sysdate
3525: WHERE financial_report_id = p_from_id;
3518: last_update_date = hz_utility_pub.last_update_date,
3519: last_updated_by = hz_utility_pub.user_id,
3520: last_update_login = hz_utility_pub.last_update_login,
3521: request_id = hz_utility_pub.request_id,
3522: program_application_id = hz_utility_pub.program_application_id,
3523: program_id = hz_utility_pub.program_id,
3524: program_update_date = sysdate
3525: WHERE financial_report_id = p_from_id;
3526: ELSE
3519: last_updated_by = hz_utility_pub.user_id,
3520: last_update_login = hz_utility_pub.last_update_login,
3521: request_id = hz_utility_pub.request_id,
3522: program_application_id = hz_utility_pub.program_application_id,
3523: program_id = hz_utility_pub.program_id,
3524: program_update_date = sysdate
3525: WHERE financial_report_id = p_from_id;
3526: ELSE
3527: -- Update and set party_id = p_to_fk_id where pk = from_id
3527: -- Update and set party_id = p_to_fk_id where pk = from_id
3528: UPDATE HZ_FINANCIAL_REPORTS
3529: SET
3530: party_id = p_to_fk_id,
3531: last_update_date = hz_utility_pub.last_update_date,
3532: last_updated_by = hz_utility_pub.user_id,
3533: last_update_login = hz_utility_pub.last_update_login,
3534: request_id = hz_utility_pub.request_id,
3535: program_application_id = hz_utility_pub.program_application_id,
3528: UPDATE HZ_FINANCIAL_REPORTS
3529: SET
3530: party_id = p_to_fk_id,
3531: last_update_date = hz_utility_pub.last_update_date,
3532: last_updated_by = hz_utility_pub.user_id,
3533: last_update_login = hz_utility_pub.last_update_login,
3534: request_id = hz_utility_pub.request_id,
3535: program_application_id = hz_utility_pub.program_application_id,
3536: program_id = hz_utility_pub.program_id,
3529: SET
3530: party_id = p_to_fk_id,
3531: last_update_date = hz_utility_pub.last_update_date,
3532: last_updated_by = hz_utility_pub.user_id,
3533: last_update_login = hz_utility_pub.last_update_login,
3534: request_id = hz_utility_pub.request_id,
3535: program_application_id = hz_utility_pub.program_application_id,
3536: program_id = hz_utility_pub.program_id,
3537: program_update_date = sysdate
3530: party_id = p_to_fk_id,
3531: last_update_date = hz_utility_pub.last_update_date,
3532: last_updated_by = hz_utility_pub.user_id,
3533: last_update_login = hz_utility_pub.last_update_login,
3534: request_id = hz_utility_pub.request_id,
3535: program_application_id = hz_utility_pub.program_application_id,
3536: program_id = hz_utility_pub.program_id,
3537: program_update_date = sysdate
3538: WHERE financial_report_id = p_from_id;
3531: last_update_date = hz_utility_pub.last_update_date,
3532: last_updated_by = hz_utility_pub.user_id,
3533: last_update_login = hz_utility_pub.last_update_login,
3534: request_id = hz_utility_pub.request_id,
3535: program_application_id = hz_utility_pub.program_application_id,
3536: program_id = hz_utility_pub.program_id,
3537: program_update_date = sysdate
3538: WHERE financial_report_id = p_from_id;
3539:
3532: last_updated_by = hz_utility_pub.user_id,
3533: last_update_login = hz_utility_pub.last_update_login,
3534: request_id = hz_utility_pub.request_id,
3535: program_application_id = hz_utility_pub.program_application_id,
3536: program_id = hz_utility_pub.program_id,
3537: program_update_date = sysdate
3538: WHERE financial_report_id = p_from_id;
3539:
3540: END IF;
3561: x_to_id <> p_from_id) THEN
3562: UPDATE HZ_ORGANIZATION_INDICATORS
3563: SET
3564: STATUS = 'M',
3565: last_update_date = hz_utility_pub.last_update_date,
3566: last_updated_by = hz_utility_pub.user_id,
3567: last_update_login = hz_utility_pub.last_update_login,
3568: request_id = hz_utility_pub.request_id,
3569: program_application_id = hz_utility_pub.program_application_id,
3562: UPDATE HZ_ORGANIZATION_INDICATORS
3563: SET
3564: STATUS = 'M',
3565: last_update_date = hz_utility_pub.last_update_date,
3566: last_updated_by = hz_utility_pub.user_id,
3567: last_update_login = hz_utility_pub.last_update_login,
3568: request_id = hz_utility_pub.request_id,
3569: program_application_id = hz_utility_pub.program_application_id,
3570: program_id = hz_utility_pub.program_id,
3563: SET
3564: STATUS = 'M',
3565: last_update_date = hz_utility_pub.last_update_date,
3566: last_updated_by = hz_utility_pub.user_id,
3567: last_update_login = hz_utility_pub.last_update_login,
3568: request_id = hz_utility_pub.request_id,
3569: program_application_id = hz_utility_pub.program_application_id,
3570: program_id = hz_utility_pub.program_id,
3571: program_update_date = sysdate
3564: STATUS = 'M',
3565: last_update_date = hz_utility_pub.last_update_date,
3566: last_updated_by = hz_utility_pub.user_id,
3567: last_update_login = hz_utility_pub.last_update_login,
3568: request_id = hz_utility_pub.request_id,
3569: program_application_id = hz_utility_pub.program_application_id,
3570: program_id = hz_utility_pub.program_id,
3571: program_update_date = sysdate
3572: WHERE organization_indicator_id = p_from_id;
3565: last_update_date = hz_utility_pub.last_update_date,
3566: last_updated_by = hz_utility_pub.user_id,
3567: last_update_login = hz_utility_pub.last_update_login,
3568: request_id = hz_utility_pub.request_id,
3569: program_application_id = hz_utility_pub.program_application_id,
3570: program_id = hz_utility_pub.program_id,
3571: program_update_date = sysdate
3572: WHERE organization_indicator_id = p_from_id;
3573: ELSE
3566: last_updated_by = hz_utility_pub.user_id,
3567: last_update_login = hz_utility_pub.last_update_login,
3568: request_id = hz_utility_pub.request_id,
3569: program_application_id = hz_utility_pub.program_application_id,
3570: program_id = hz_utility_pub.program_id,
3571: program_update_date = sysdate
3572: WHERE organization_indicator_id = p_from_id;
3573: ELSE
3574: -- Update and set party_id = p_to_fk_id where pk = from_id
3574: -- Update and set party_id = p_to_fk_id where pk = from_id
3575: UPDATE HZ_ORGANIZATION_INDICATORS
3576: SET
3577: party_id = p_to_fk_id,
3578: last_update_date = hz_utility_pub.last_update_date,
3579: last_updated_by = hz_utility_pub.user_id,
3580: last_update_login = hz_utility_pub.last_update_login,
3581: request_id = hz_utility_pub.request_id,
3582: program_application_id = hz_utility_pub.program_application_id,
3575: UPDATE HZ_ORGANIZATION_INDICATORS
3576: SET
3577: party_id = p_to_fk_id,
3578: last_update_date = hz_utility_pub.last_update_date,
3579: last_updated_by = hz_utility_pub.user_id,
3580: last_update_login = hz_utility_pub.last_update_login,
3581: request_id = hz_utility_pub.request_id,
3582: program_application_id = hz_utility_pub.program_application_id,
3583: program_id = hz_utility_pub.program_id,
3576: SET
3577: party_id = p_to_fk_id,
3578: last_update_date = hz_utility_pub.last_update_date,
3579: last_updated_by = hz_utility_pub.user_id,
3580: last_update_login = hz_utility_pub.last_update_login,
3581: request_id = hz_utility_pub.request_id,
3582: program_application_id = hz_utility_pub.program_application_id,
3583: program_id = hz_utility_pub.program_id,
3584: program_update_date = sysdate
3577: party_id = p_to_fk_id,
3578: last_update_date = hz_utility_pub.last_update_date,
3579: last_updated_by = hz_utility_pub.user_id,
3580: last_update_login = hz_utility_pub.last_update_login,
3581: request_id = hz_utility_pub.request_id,
3582: program_application_id = hz_utility_pub.program_application_id,
3583: program_id = hz_utility_pub.program_id,
3584: program_update_date = sysdate
3585: WHERE organization_indicator_id = p_from_id;
3578: last_update_date = hz_utility_pub.last_update_date,
3579: last_updated_by = hz_utility_pub.user_id,
3580: last_update_login = hz_utility_pub.last_update_login,
3581: request_id = hz_utility_pub.request_id,
3582: program_application_id = hz_utility_pub.program_application_id,
3583: program_id = hz_utility_pub.program_id,
3584: program_update_date = sysdate
3585: WHERE organization_indicator_id = p_from_id;
3586:
3579: last_updated_by = hz_utility_pub.user_id,
3580: last_update_login = hz_utility_pub.last_update_login,
3581: request_id = hz_utility_pub.request_id,
3582: program_application_id = hz_utility_pub.program_application_id,
3583: program_id = hz_utility_pub.program_id,
3584: program_update_date = sysdate
3585: WHERE organization_indicator_id = p_from_id;
3586:
3587: END IF;
3608: x_to_id <> p_from_id) THEN
3609: UPDATE HZ_INDUSTRIAL_REFERENCE
3610: SET
3611: STATUS = 'M',
3612: last_update_date = hz_utility_pub.last_update_date,
3613: last_updated_by = hz_utility_pub.user_id,
3614: last_update_login = hz_utility_pub.last_update_login,
3615: request_id = hz_utility_pub.request_id,
3616: program_application_id = hz_utility_pub.program_application_id,
3609: UPDATE HZ_INDUSTRIAL_REFERENCE
3610: SET
3611: STATUS = 'M',
3612: last_update_date = hz_utility_pub.last_update_date,
3613: last_updated_by = hz_utility_pub.user_id,
3614: last_update_login = hz_utility_pub.last_update_login,
3615: request_id = hz_utility_pub.request_id,
3616: program_application_id = hz_utility_pub.program_application_id,
3617: program_id = hz_utility_pub.program_id,
3610: SET
3611: STATUS = 'M',
3612: last_update_date = hz_utility_pub.last_update_date,
3613: last_updated_by = hz_utility_pub.user_id,
3614: last_update_login = hz_utility_pub.last_update_login,
3615: request_id = hz_utility_pub.request_id,
3616: program_application_id = hz_utility_pub.program_application_id,
3617: program_id = hz_utility_pub.program_id,
3618: program_update_date = sysdate
3611: STATUS = 'M',
3612: last_update_date = hz_utility_pub.last_update_date,
3613: last_updated_by = hz_utility_pub.user_id,
3614: last_update_login = hz_utility_pub.last_update_login,
3615: request_id = hz_utility_pub.request_id,
3616: program_application_id = hz_utility_pub.program_application_id,
3617: program_id = hz_utility_pub.program_id,
3618: program_update_date = sysdate
3619: WHERE industry_reference_id = p_from_id;
3612: last_update_date = hz_utility_pub.last_update_date,
3613: last_updated_by = hz_utility_pub.user_id,
3614: last_update_login = hz_utility_pub.last_update_login,
3615: request_id = hz_utility_pub.request_id,
3616: program_application_id = hz_utility_pub.program_application_id,
3617: program_id = hz_utility_pub.program_id,
3618: program_update_date = sysdate
3619: WHERE industry_reference_id = p_from_id;
3620: ELSE
3613: last_updated_by = hz_utility_pub.user_id,
3614: last_update_login = hz_utility_pub.last_update_login,
3615: request_id = hz_utility_pub.request_id,
3616: program_application_id = hz_utility_pub.program_application_id,
3617: program_id = hz_utility_pub.program_id,
3618: program_update_date = sysdate
3619: WHERE industry_reference_id = p_from_id;
3620: ELSE
3621: -- Update and set party_id = p_to_fk_id where pk = from_id
3621: -- Update and set party_id = p_to_fk_id where pk = from_id
3622: UPDATE HZ_INDUSTRIAL_REFERENCE
3623: SET
3624: party_id = p_to_fk_id,
3625: last_update_date = hz_utility_pub.last_update_date,
3626: last_updated_by = hz_utility_pub.user_id,
3627: last_update_login = hz_utility_pub.last_update_login,
3628: request_id = hz_utility_pub.request_id,
3629: program_application_id = hz_utility_pub.program_application_id,
3622: UPDATE HZ_INDUSTRIAL_REFERENCE
3623: SET
3624: party_id = p_to_fk_id,
3625: last_update_date = hz_utility_pub.last_update_date,
3626: last_updated_by = hz_utility_pub.user_id,
3627: last_update_login = hz_utility_pub.last_update_login,
3628: request_id = hz_utility_pub.request_id,
3629: program_application_id = hz_utility_pub.program_application_id,
3630: program_id = hz_utility_pub.program_id,
3623: SET
3624: party_id = p_to_fk_id,
3625: last_update_date = hz_utility_pub.last_update_date,
3626: last_updated_by = hz_utility_pub.user_id,
3627: last_update_login = hz_utility_pub.last_update_login,
3628: request_id = hz_utility_pub.request_id,
3629: program_application_id = hz_utility_pub.program_application_id,
3630: program_id = hz_utility_pub.program_id,
3631: program_update_date = sysdate
3624: party_id = p_to_fk_id,
3625: last_update_date = hz_utility_pub.last_update_date,
3626: last_updated_by = hz_utility_pub.user_id,
3627: last_update_login = hz_utility_pub.last_update_login,
3628: request_id = hz_utility_pub.request_id,
3629: program_application_id = hz_utility_pub.program_application_id,
3630: program_id = hz_utility_pub.program_id,
3631: program_update_date = sysdate
3632: WHERE industry_reference_id = p_from_id;
3625: last_update_date = hz_utility_pub.last_update_date,
3626: last_updated_by = hz_utility_pub.user_id,
3627: last_update_login = hz_utility_pub.last_update_login,
3628: request_id = hz_utility_pub.request_id,
3629: program_application_id = hz_utility_pub.program_application_id,
3630: program_id = hz_utility_pub.program_id,
3631: program_update_date = sysdate
3632: WHERE industry_reference_id = p_from_id;
3633:
3626: last_updated_by = hz_utility_pub.user_id,
3627: last_update_login = hz_utility_pub.last_update_login,
3628: request_id = hz_utility_pub.request_id,
3629: program_application_id = hz_utility_pub.program_application_id,
3630: program_id = hz_utility_pub.program_id,
3631: program_update_date = sysdate
3632: WHERE industry_reference_id = p_from_id;
3633:
3634: END IF;
3655: x_to_id <> p_from_id) THEN
3656: UPDATE HZ_PERSON_INTEREST
3657: SET
3658: STATUS = 'M',
3659: last_update_date = hz_utility_pub.last_update_date,
3660: last_updated_by = hz_utility_pub.user_id,
3661: last_update_login = hz_utility_pub.last_update_login,
3662: request_id = hz_utility_pub.request_id,
3663: program_application_id = hz_utility_pub.program_application_id,
3656: UPDATE HZ_PERSON_INTEREST
3657: SET
3658: STATUS = 'M',
3659: last_update_date = hz_utility_pub.last_update_date,
3660: last_updated_by = hz_utility_pub.user_id,
3661: last_update_login = hz_utility_pub.last_update_login,
3662: request_id = hz_utility_pub.request_id,
3663: program_application_id = hz_utility_pub.program_application_id,
3664: program_id = hz_utility_pub.program_id,
3657: SET
3658: STATUS = 'M',
3659: last_update_date = hz_utility_pub.last_update_date,
3660: last_updated_by = hz_utility_pub.user_id,
3661: last_update_login = hz_utility_pub.last_update_login,
3662: request_id = hz_utility_pub.request_id,
3663: program_application_id = hz_utility_pub.program_application_id,
3664: program_id = hz_utility_pub.program_id,
3665: program_update_date = sysdate
3658: STATUS = 'M',
3659: last_update_date = hz_utility_pub.last_update_date,
3660: last_updated_by = hz_utility_pub.user_id,
3661: last_update_login = hz_utility_pub.last_update_login,
3662: request_id = hz_utility_pub.request_id,
3663: program_application_id = hz_utility_pub.program_application_id,
3664: program_id = hz_utility_pub.program_id,
3665: program_update_date = sysdate
3666: WHERE person_interest_id = p_from_id;
3659: last_update_date = hz_utility_pub.last_update_date,
3660: last_updated_by = hz_utility_pub.user_id,
3661: last_update_login = hz_utility_pub.last_update_login,
3662: request_id = hz_utility_pub.request_id,
3663: program_application_id = hz_utility_pub.program_application_id,
3664: program_id = hz_utility_pub.program_id,
3665: program_update_date = sysdate
3666: WHERE person_interest_id = p_from_id;
3667: ELSE
3660: last_updated_by = hz_utility_pub.user_id,
3661: last_update_login = hz_utility_pub.last_update_login,
3662: request_id = hz_utility_pub.request_id,
3663: program_application_id = hz_utility_pub.program_application_id,
3664: program_id = hz_utility_pub.program_id,
3665: program_update_date = sysdate
3666: WHERE person_interest_id = p_from_id;
3667: ELSE
3668: -- Update and set party_id = p_to_fk_id where pk = from_id
3668: -- Update and set party_id = p_to_fk_id where pk = from_id
3669: UPDATE HZ_PERSON_INTEREST
3670: SET
3671: party_id = p_to_fk_id,
3672: last_update_date = hz_utility_pub.last_update_date,
3673: last_updated_by = hz_utility_pub.user_id,
3674: last_update_login = hz_utility_pub.last_update_login,
3675: request_id = hz_utility_pub.request_id,
3676: program_application_id = hz_utility_pub.program_application_id,
3669: UPDATE HZ_PERSON_INTEREST
3670: SET
3671: party_id = p_to_fk_id,
3672: last_update_date = hz_utility_pub.last_update_date,
3673: last_updated_by = hz_utility_pub.user_id,
3674: last_update_login = hz_utility_pub.last_update_login,
3675: request_id = hz_utility_pub.request_id,
3676: program_application_id = hz_utility_pub.program_application_id,
3677: program_id = hz_utility_pub.program_id,
3670: SET
3671: party_id = p_to_fk_id,
3672: last_update_date = hz_utility_pub.last_update_date,
3673: last_updated_by = hz_utility_pub.user_id,
3674: last_update_login = hz_utility_pub.last_update_login,
3675: request_id = hz_utility_pub.request_id,
3676: program_application_id = hz_utility_pub.program_application_id,
3677: program_id = hz_utility_pub.program_id,
3678: program_update_date = sysdate
3671: party_id = p_to_fk_id,
3672: last_update_date = hz_utility_pub.last_update_date,
3673: last_updated_by = hz_utility_pub.user_id,
3674: last_update_login = hz_utility_pub.last_update_login,
3675: request_id = hz_utility_pub.request_id,
3676: program_application_id = hz_utility_pub.program_application_id,
3677: program_id = hz_utility_pub.program_id,
3678: program_update_date = sysdate
3679: WHERE person_interest_id = p_from_id;
3672: last_update_date = hz_utility_pub.last_update_date,
3673: last_updated_by = hz_utility_pub.user_id,
3674: last_update_login = hz_utility_pub.last_update_login,
3675: request_id = hz_utility_pub.request_id,
3676: program_application_id = hz_utility_pub.program_application_id,
3677: program_id = hz_utility_pub.program_id,
3678: program_update_date = sysdate
3679: WHERE person_interest_id = p_from_id;
3680:
3673: last_updated_by = hz_utility_pub.user_id,
3674: last_update_login = hz_utility_pub.last_update_login,
3675: request_id = hz_utility_pub.request_id,
3676: program_application_id = hz_utility_pub.program_application_id,
3677: program_id = hz_utility_pub.program_id,
3678: program_update_date = sysdate
3679: WHERE person_interest_id = p_from_id;
3680:
3681: END IF;
3702: x_to_id <> p_from_id) THEN
3703: UPDATE HZ_CITIZENSHIP
3704: SET
3705: STATUS = 'M',
3706: last_update_date = hz_utility_pub.last_update_date,
3707: last_updated_by = hz_utility_pub.user_id,
3708: last_update_login = hz_utility_pub.last_update_login,
3709: request_id = hz_utility_pub.request_id,
3710: program_application_id = hz_utility_pub.program_application_id,
3703: UPDATE HZ_CITIZENSHIP
3704: SET
3705: STATUS = 'M',
3706: last_update_date = hz_utility_pub.last_update_date,
3707: last_updated_by = hz_utility_pub.user_id,
3708: last_update_login = hz_utility_pub.last_update_login,
3709: request_id = hz_utility_pub.request_id,
3710: program_application_id = hz_utility_pub.program_application_id,
3711: program_id = hz_utility_pub.program_id,
3704: SET
3705: STATUS = 'M',
3706: last_update_date = hz_utility_pub.last_update_date,
3707: last_updated_by = hz_utility_pub.user_id,
3708: last_update_login = hz_utility_pub.last_update_login,
3709: request_id = hz_utility_pub.request_id,
3710: program_application_id = hz_utility_pub.program_application_id,
3711: program_id = hz_utility_pub.program_id,
3712: program_update_date = sysdate
3705: STATUS = 'M',
3706: last_update_date = hz_utility_pub.last_update_date,
3707: last_updated_by = hz_utility_pub.user_id,
3708: last_update_login = hz_utility_pub.last_update_login,
3709: request_id = hz_utility_pub.request_id,
3710: program_application_id = hz_utility_pub.program_application_id,
3711: program_id = hz_utility_pub.program_id,
3712: program_update_date = sysdate
3713: WHERE citizenship_id = p_from_id;
3706: last_update_date = hz_utility_pub.last_update_date,
3707: last_updated_by = hz_utility_pub.user_id,
3708: last_update_login = hz_utility_pub.last_update_login,
3709: request_id = hz_utility_pub.request_id,
3710: program_application_id = hz_utility_pub.program_application_id,
3711: program_id = hz_utility_pub.program_id,
3712: program_update_date = sysdate
3713: WHERE citizenship_id = p_from_id;
3714: ELSE
3707: last_updated_by = hz_utility_pub.user_id,
3708: last_update_login = hz_utility_pub.last_update_login,
3709: request_id = hz_utility_pub.request_id,
3710: program_application_id = hz_utility_pub.program_application_id,
3711: program_id = hz_utility_pub.program_id,
3712: program_update_date = sysdate
3713: WHERE citizenship_id = p_from_id;
3714: ELSE
3715: -- Update and set party_id = p_to_fk_id where pk = from_id
3715: -- Update and set party_id = p_to_fk_id where pk = from_id
3716: UPDATE HZ_CITIZENSHIP
3717: SET
3718: party_id = p_to_fk_id,
3719: last_update_date = hz_utility_pub.last_update_date,
3720: last_updated_by = hz_utility_pub.user_id,
3721: last_update_login = hz_utility_pub.last_update_login,
3722: request_id = hz_utility_pub.request_id,
3723: program_application_id = hz_utility_pub.program_application_id,
3716: UPDATE HZ_CITIZENSHIP
3717: SET
3718: party_id = p_to_fk_id,
3719: last_update_date = hz_utility_pub.last_update_date,
3720: last_updated_by = hz_utility_pub.user_id,
3721: last_update_login = hz_utility_pub.last_update_login,
3722: request_id = hz_utility_pub.request_id,
3723: program_application_id = hz_utility_pub.program_application_id,
3724: program_id = hz_utility_pub.program_id,
3717: SET
3718: party_id = p_to_fk_id,
3719: last_update_date = hz_utility_pub.last_update_date,
3720: last_updated_by = hz_utility_pub.user_id,
3721: last_update_login = hz_utility_pub.last_update_login,
3722: request_id = hz_utility_pub.request_id,
3723: program_application_id = hz_utility_pub.program_application_id,
3724: program_id = hz_utility_pub.program_id,
3725: program_update_date = sysdate
3718: party_id = p_to_fk_id,
3719: last_update_date = hz_utility_pub.last_update_date,
3720: last_updated_by = hz_utility_pub.user_id,
3721: last_update_login = hz_utility_pub.last_update_login,
3722: request_id = hz_utility_pub.request_id,
3723: program_application_id = hz_utility_pub.program_application_id,
3724: program_id = hz_utility_pub.program_id,
3725: program_update_date = sysdate
3726: WHERE citizenship_id = p_from_id;
3719: last_update_date = hz_utility_pub.last_update_date,
3720: last_updated_by = hz_utility_pub.user_id,
3721: last_update_login = hz_utility_pub.last_update_login,
3722: request_id = hz_utility_pub.request_id,
3723: program_application_id = hz_utility_pub.program_application_id,
3724: program_id = hz_utility_pub.program_id,
3725: program_update_date = sysdate
3726: WHERE citizenship_id = p_from_id;
3727:
3720: last_updated_by = hz_utility_pub.user_id,
3721: last_update_login = hz_utility_pub.last_update_login,
3722: request_id = hz_utility_pub.request_id,
3723: program_application_id = hz_utility_pub.program_application_id,
3724: program_id = hz_utility_pub.program_id,
3725: program_update_date = sysdate
3726: WHERE citizenship_id = p_from_id;
3727:
3728: END IF;
3749: x_to_id <> p_from_id) THEN
3750: UPDATE HZ_EDUCATION
3751: SET
3752: STATUS = 'M',
3753: last_update_date = hz_utility_pub.last_update_date,
3754: last_updated_by = hz_utility_pub.user_id,
3755: last_update_login = hz_utility_pub.last_update_login,
3756: request_id = hz_utility_pub.request_id,
3757: program_application_id = hz_utility_pub.program_application_id,
3750: UPDATE HZ_EDUCATION
3751: SET
3752: STATUS = 'M',
3753: last_update_date = hz_utility_pub.last_update_date,
3754: last_updated_by = hz_utility_pub.user_id,
3755: last_update_login = hz_utility_pub.last_update_login,
3756: request_id = hz_utility_pub.request_id,
3757: program_application_id = hz_utility_pub.program_application_id,
3758: program_id = hz_utility_pub.program_id,
3751: SET
3752: STATUS = 'M',
3753: last_update_date = hz_utility_pub.last_update_date,
3754: last_updated_by = hz_utility_pub.user_id,
3755: last_update_login = hz_utility_pub.last_update_login,
3756: request_id = hz_utility_pub.request_id,
3757: program_application_id = hz_utility_pub.program_application_id,
3758: program_id = hz_utility_pub.program_id,
3759: program_update_date = sysdate
3752: STATUS = 'M',
3753: last_update_date = hz_utility_pub.last_update_date,
3754: last_updated_by = hz_utility_pub.user_id,
3755: last_update_login = hz_utility_pub.last_update_login,
3756: request_id = hz_utility_pub.request_id,
3757: program_application_id = hz_utility_pub.program_application_id,
3758: program_id = hz_utility_pub.program_id,
3759: program_update_date = sysdate
3760: WHERE education_id = p_from_id;
3753: last_update_date = hz_utility_pub.last_update_date,
3754: last_updated_by = hz_utility_pub.user_id,
3755: last_update_login = hz_utility_pub.last_update_login,
3756: request_id = hz_utility_pub.request_id,
3757: program_application_id = hz_utility_pub.program_application_id,
3758: program_id = hz_utility_pub.program_id,
3759: program_update_date = sysdate
3760: WHERE education_id = p_from_id;
3761: ELSE
3754: last_updated_by = hz_utility_pub.user_id,
3755: last_update_login = hz_utility_pub.last_update_login,
3756: request_id = hz_utility_pub.request_id,
3757: program_application_id = hz_utility_pub.program_application_id,
3758: program_id = hz_utility_pub.program_id,
3759: program_update_date = sysdate
3760: WHERE education_id = p_from_id;
3761: ELSE
3762: -- Update and set party_id = p_to_fk_id where pk = from_id
3762: -- Update and set party_id = p_to_fk_id where pk = from_id
3763: UPDATE HZ_EDUCATION
3764: SET
3765: party_id = p_to_fk_id,
3766: last_update_date = hz_utility_pub.last_update_date,
3767: last_updated_by = hz_utility_pub.user_id,
3768: last_update_login = hz_utility_pub.last_update_login,
3769: request_id = hz_utility_pub.request_id,
3770: program_application_id = hz_utility_pub.program_application_id,
3763: UPDATE HZ_EDUCATION
3764: SET
3765: party_id = p_to_fk_id,
3766: last_update_date = hz_utility_pub.last_update_date,
3767: last_updated_by = hz_utility_pub.user_id,
3768: last_update_login = hz_utility_pub.last_update_login,
3769: request_id = hz_utility_pub.request_id,
3770: program_application_id = hz_utility_pub.program_application_id,
3771: program_id = hz_utility_pub.program_id,
3764: SET
3765: party_id = p_to_fk_id,
3766: last_update_date = hz_utility_pub.last_update_date,
3767: last_updated_by = hz_utility_pub.user_id,
3768: last_update_login = hz_utility_pub.last_update_login,
3769: request_id = hz_utility_pub.request_id,
3770: program_application_id = hz_utility_pub.program_application_id,
3771: program_id = hz_utility_pub.program_id,
3772: program_update_date = sysdate
3765: party_id = p_to_fk_id,
3766: last_update_date = hz_utility_pub.last_update_date,
3767: last_updated_by = hz_utility_pub.user_id,
3768: last_update_login = hz_utility_pub.last_update_login,
3769: request_id = hz_utility_pub.request_id,
3770: program_application_id = hz_utility_pub.program_application_id,
3771: program_id = hz_utility_pub.program_id,
3772: program_update_date = sysdate
3773: WHERE education_id = p_from_id;
3766: last_update_date = hz_utility_pub.last_update_date,
3767: last_updated_by = hz_utility_pub.user_id,
3768: last_update_login = hz_utility_pub.last_update_login,
3769: request_id = hz_utility_pub.request_id,
3770: program_application_id = hz_utility_pub.program_application_id,
3771: program_id = hz_utility_pub.program_id,
3772: program_update_date = sysdate
3773: WHERE education_id = p_from_id;
3774:
3767: last_updated_by = hz_utility_pub.user_id,
3768: last_update_login = hz_utility_pub.last_update_login,
3769: request_id = hz_utility_pub.request_id,
3770: program_application_id = hz_utility_pub.program_application_id,
3771: program_id = hz_utility_pub.program_id,
3772: program_update_date = sysdate
3773: WHERE education_id = p_from_id;
3774:
3775: END IF;
3796: x_to_id <> p_from_id) THEN
3797: UPDATE HZ_EDUCATION
3798: SET
3799: STATUS = 'M',
3800: last_update_date = hz_utility_pub.last_update_date,
3801: last_updated_by = hz_utility_pub.user_id,
3802: last_update_login = hz_utility_pub.last_update_login,
3803: request_id = hz_utility_pub.request_id,
3804: program_application_id = hz_utility_pub.program_application_id,
3797: UPDATE HZ_EDUCATION
3798: SET
3799: STATUS = 'M',
3800: last_update_date = hz_utility_pub.last_update_date,
3801: last_updated_by = hz_utility_pub.user_id,
3802: last_update_login = hz_utility_pub.last_update_login,
3803: request_id = hz_utility_pub.request_id,
3804: program_application_id = hz_utility_pub.program_application_id,
3805: program_id = hz_utility_pub.program_id,
3798: SET
3799: STATUS = 'M',
3800: last_update_date = hz_utility_pub.last_update_date,
3801: last_updated_by = hz_utility_pub.user_id,
3802: last_update_login = hz_utility_pub.last_update_login,
3803: request_id = hz_utility_pub.request_id,
3804: program_application_id = hz_utility_pub.program_application_id,
3805: program_id = hz_utility_pub.program_id,
3806: program_update_date = sysdate
3799: STATUS = 'M',
3800: last_update_date = hz_utility_pub.last_update_date,
3801: last_updated_by = hz_utility_pub.user_id,
3802: last_update_login = hz_utility_pub.last_update_login,
3803: request_id = hz_utility_pub.request_id,
3804: program_application_id = hz_utility_pub.program_application_id,
3805: program_id = hz_utility_pub.program_id,
3806: program_update_date = sysdate
3807: WHERE education_id = p_from_id;
3800: last_update_date = hz_utility_pub.last_update_date,
3801: last_updated_by = hz_utility_pub.user_id,
3802: last_update_login = hz_utility_pub.last_update_login,
3803: request_id = hz_utility_pub.request_id,
3804: program_application_id = hz_utility_pub.program_application_id,
3805: program_id = hz_utility_pub.program_id,
3806: program_update_date = sysdate
3807: WHERE education_id = p_from_id;
3808: ELSE
3801: last_updated_by = hz_utility_pub.user_id,
3802: last_update_login = hz_utility_pub.last_update_login,
3803: request_id = hz_utility_pub.request_id,
3804: program_application_id = hz_utility_pub.program_application_id,
3805: program_id = hz_utility_pub.program_id,
3806: program_update_date = sysdate
3807: WHERE education_id = p_from_id;
3808: ELSE
3809: -- Update and set party_id = p_to_fk_id where pk = from_id
3809: -- Update and set party_id = p_to_fk_id where pk = from_id
3810: UPDATE HZ_EDUCATION
3811: SET
3812: school_party_id = p_to_fk_id,
3813: last_update_date = hz_utility_pub.last_update_date,
3814: last_updated_by = hz_utility_pub.user_id,
3815: last_update_login = hz_utility_pub.last_update_login,
3816: request_id = hz_utility_pub.request_id,
3817: program_application_id = hz_utility_pub.program_application_id,
3810: UPDATE HZ_EDUCATION
3811: SET
3812: school_party_id = p_to_fk_id,
3813: last_update_date = hz_utility_pub.last_update_date,
3814: last_updated_by = hz_utility_pub.user_id,
3815: last_update_login = hz_utility_pub.last_update_login,
3816: request_id = hz_utility_pub.request_id,
3817: program_application_id = hz_utility_pub.program_application_id,
3818: program_id = hz_utility_pub.program_id,
3811: SET
3812: school_party_id = p_to_fk_id,
3813: last_update_date = hz_utility_pub.last_update_date,
3814: last_updated_by = hz_utility_pub.user_id,
3815: last_update_login = hz_utility_pub.last_update_login,
3816: request_id = hz_utility_pub.request_id,
3817: program_application_id = hz_utility_pub.program_application_id,
3818: program_id = hz_utility_pub.program_id,
3819: program_update_date = sysdate
3812: school_party_id = p_to_fk_id,
3813: last_update_date = hz_utility_pub.last_update_date,
3814: last_updated_by = hz_utility_pub.user_id,
3815: last_update_login = hz_utility_pub.last_update_login,
3816: request_id = hz_utility_pub.request_id,
3817: program_application_id = hz_utility_pub.program_application_id,
3818: program_id = hz_utility_pub.program_id,
3819: program_update_date = sysdate
3820: WHERE education_id = p_from_id;
3813: last_update_date = hz_utility_pub.last_update_date,
3814: last_updated_by = hz_utility_pub.user_id,
3815: last_update_login = hz_utility_pub.last_update_login,
3816: request_id = hz_utility_pub.request_id,
3817: program_application_id = hz_utility_pub.program_application_id,
3818: program_id = hz_utility_pub.program_id,
3819: program_update_date = sysdate
3820: WHERE education_id = p_from_id;
3821:
3814: last_updated_by = hz_utility_pub.user_id,
3815: last_update_login = hz_utility_pub.last_update_login,
3816: request_id = hz_utility_pub.request_id,
3817: program_application_id = hz_utility_pub.program_application_id,
3818: program_id = hz_utility_pub.program_id,
3819: program_update_date = sysdate
3820: WHERE education_id = p_from_id;
3821:
3822: END IF;
3844: x_to_id <> p_from_id) THEN
3845: UPDATE HZ_EMPLOYMENT_HISTORY
3846: SET
3847: STATUS = 'M',
3848: last_update_date = hz_utility_pub.last_update_date,
3849: last_updated_by = hz_utility_pub.user_id,
3850: last_update_login = hz_utility_pub.last_update_login,
3851: request_id = hz_utility_pub.request_id,
3852: program_application_id = hz_utility_pub.program_application_id,
3845: UPDATE HZ_EMPLOYMENT_HISTORY
3846: SET
3847: STATUS = 'M',
3848: last_update_date = hz_utility_pub.last_update_date,
3849: last_updated_by = hz_utility_pub.user_id,
3850: last_update_login = hz_utility_pub.last_update_login,
3851: request_id = hz_utility_pub.request_id,
3852: program_application_id = hz_utility_pub.program_application_id,
3853: program_id = hz_utility_pub.program_id,
3846: SET
3847: STATUS = 'M',
3848: last_update_date = hz_utility_pub.last_update_date,
3849: last_updated_by = hz_utility_pub.user_id,
3850: last_update_login = hz_utility_pub.last_update_login,
3851: request_id = hz_utility_pub.request_id,
3852: program_application_id = hz_utility_pub.program_application_id,
3853: program_id = hz_utility_pub.program_id,
3854: program_update_date = sysdate
3847: STATUS = 'M',
3848: last_update_date = hz_utility_pub.last_update_date,
3849: last_updated_by = hz_utility_pub.user_id,
3850: last_update_login = hz_utility_pub.last_update_login,
3851: request_id = hz_utility_pub.request_id,
3852: program_application_id = hz_utility_pub.program_application_id,
3853: program_id = hz_utility_pub.program_id,
3854: program_update_date = sysdate
3855: WHERE employment_history_id = p_from_id;
3848: last_update_date = hz_utility_pub.last_update_date,
3849: last_updated_by = hz_utility_pub.user_id,
3850: last_update_login = hz_utility_pub.last_update_login,
3851: request_id = hz_utility_pub.request_id,
3852: program_application_id = hz_utility_pub.program_application_id,
3853: program_id = hz_utility_pub.program_id,
3854: program_update_date = sysdate
3855: WHERE employment_history_id = p_from_id;
3856: ELSE
3849: last_updated_by = hz_utility_pub.user_id,
3850: last_update_login = hz_utility_pub.last_update_login,
3851: request_id = hz_utility_pub.request_id,
3852: program_application_id = hz_utility_pub.program_application_id,
3853: program_id = hz_utility_pub.program_id,
3854: program_update_date = sysdate
3855: WHERE employment_history_id = p_from_id;
3856: ELSE
3857: -- Update and set party_id = p_to_fk_id where pk = from_id
3857: -- Update and set party_id = p_to_fk_id where pk = from_id
3858: UPDATE HZ_EMPLOYMENT_HISTORY
3859: SET
3860: party_id = p_to_fk_id,
3861: last_update_date = hz_utility_pub.last_update_date,
3862: last_updated_by = hz_utility_pub.user_id,
3863: last_update_login = hz_utility_pub.last_update_login,
3864: request_id = hz_utility_pub.request_id,
3865: program_application_id = hz_utility_pub.program_application_id,
3858: UPDATE HZ_EMPLOYMENT_HISTORY
3859: SET
3860: party_id = p_to_fk_id,
3861: last_update_date = hz_utility_pub.last_update_date,
3862: last_updated_by = hz_utility_pub.user_id,
3863: last_update_login = hz_utility_pub.last_update_login,
3864: request_id = hz_utility_pub.request_id,
3865: program_application_id = hz_utility_pub.program_application_id,
3866: program_id = hz_utility_pub.program_id,
3859: SET
3860: party_id = p_to_fk_id,
3861: last_update_date = hz_utility_pub.last_update_date,
3862: last_updated_by = hz_utility_pub.user_id,
3863: last_update_login = hz_utility_pub.last_update_login,
3864: request_id = hz_utility_pub.request_id,
3865: program_application_id = hz_utility_pub.program_application_id,
3866: program_id = hz_utility_pub.program_id,
3867: program_update_date = sysdate
3860: party_id = p_to_fk_id,
3861: last_update_date = hz_utility_pub.last_update_date,
3862: last_updated_by = hz_utility_pub.user_id,
3863: last_update_login = hz_utility_pub.last_update_login,
3864: request_id = hz_utility_pub.request_id,
3865: program_application_id = hz_utility_pub.program_application_id,
3866: program_id = hz_utility_pub.program_id,
3867: program_update_date = sysdate
3868: WHERE employment_history_id = p_from_id;
3861: last_update_date = hz_utility_pub.last_update_date,
3862: last_updated_by = hz_utility_pub.user_id,
3863: last_update_login = hz_utility_pub.last_update_login,
3864: request_id = hz_utility_pub.request_id,
3865: program_application_id = hz_utility_pub.program_application_id,
3866: program_id = hz_utility_pub.program_id,
3867: program_update_date = sysdate
3868: WHERE employment_history_id = p_from_id;
3869:
3862: last_updated_by = hz_utility_pub.user_id,
3863: last_update_login = hz_utility_pub.last_update_login,
3864: request_id = hz_utility_pub.request_id,
3865: program_application_id = hz_utility_pub.program_application_id,
3866: program_id = hz_utility_pub.program_id,
3867: program_update_date = sysdate
3868: WHERE employment_history_id = p_from_id;
3869:
3870: END IF;
3891: x_to_id <> p_from_id) THEN
3892: UPDATE HZ_EMPLOYMENT_HISTORY
3893: SET
3894: STATUS = 'M',
3895: last_update_date = hz_utility_pub.last_update_date,
3896: last_updated_by = hz_utility_pub.user_id,
3897: last_update_login = hz_utility_pub.last_update_login,
3898: request_id = hz_utility_pub.request_id,
3899: program_application_id = hz_utility_pub.program_application_id,
3892: UPDATE HZ_EMPLOYMENT_HISTORY
3893: SET
3894: STATUS = 'M',
3895: last_update_date = hz_utility_pub.last_update_date,
3896: last_updated_by = hz_utility_pub.user_id,
3897: last_update_login = hz_utility_pub.last_update_login,
3898: request_id = hz_utility_pub.request_id,
3899: program_application_id = hz_utility_pub.program_application_id,
3900: program_id = hz_utility_pub.program_id,
3893: SET
3894: STATUS = 'M',
3895: last_update_date = hz_utility_pub.last_update_date,
3896: last_updated_by = hz_utility_pub.user_id,
3897: last_update_login = hz_utility_pub.last_update_login,
3898: request_id = hz_utility_pub.request_id,
3899: program_application_id = hz_utility_pub.program_application_id,
3900: program_id = hz_utility_pub.program_id,
3901: program_update_date = sysdate
3894: STATUS = 'M',
3895: last_update_date = hz_utility_pub.last_update_date,
3896: last_updated_by = hz_utility_pub.user_id,
3897: last_update_login = hz_utility_pub.last_update_login,
3898: request_id = hz_utility_pub.request_id,
3899: program_application_id = hz_utility_pub.program_application_id,
3900: program_id = hz_utility_pub.program_id,
3901: program_update_date = sysdate
3902: WHERE employment_history_id = p_from_id;
3895: last_update_date = hz_utility_pub.last_update_date,
3896: last_updated_by = hz_utility_pub.user_id,
3897: last_update_login = hz_utility_pub.last_update_login,
3898: request_id = hz_utility_pub.request_id,
3899: program_application_id = hz_utility_pub.program_application_id,
3900: program_id = hz_utility_pub.program_id,
3901: program_update_date = sysdate
3902: WHERE employment_history_id = p_from_id;
3903: ELSE
3896: last_updated_by = hz_utility_pub.user_id,
3897: last_update_login = hz_utility_pub.last_update_login,
3898: request_id = hz_utility_pub.request_id,
3899: program_application_id = hz_utility_pub.program_application_id,
3900: program_id = hz_utility_pub.program_id,
3901: program_update_date = sysdate
3902: WHERE employment_history_id = p_from_id;
3903: ELSE
3904: -- Update and set party_id = p_to_fk_id where pk = from_id
3904: -- Update and set party_id = p_to_fk_id where pk = from_id
3905: UPDATE HZ_EMPLOYMENT_HISTORY
3906: SET
3907: employed_by_party_id = p_to_fk_id,
3908: last_update_date = hz_utility_pub.last_update_date,
3909: last_updated_by = hz_utility_pub.user_id,
3910: last_update_login = hz_utility_pub.last_update_login,
3911: request_id = hz_utility_pub.request_id,
3912: program_application_id = hz_utility_pub.program_application_id,
3905: UPDATE HZ_EMPLOYMENT_HISTORY
3906: SET
3907: employed_by_party_id = p_to_fk_id,
3908: last_update_date = hz_utility_pub.last_update_date,
3909: last_updated_by = hz_utility_pub.user_id,
3910: last_update_login = hz_utility_pub.last_update_login,
3911: request_id = hz_utility_pub.request_id,
3912: program_application_id = hz_utility_pub.program_application_id,
3913: program_id = hz_utility_pub.program_id,
3906: SET
3907: employed_by_party_id = p_to_fk_id,
3908: last_update_date = hz_utility_pub.last_update_date,
3909: last_updated_by = hz_utility_pub.user_id,
3910: last_update_login = hz_utility_pub.last_update_login,
3911: request_id = hz_utility_pub.request_id,
3912: program_application_id = hz_utility_pub.program_application_id,
3913: program_id = hz_utility_pub.program_id,
3914: program_update_date = sysdate
3907: employed_by_party_id = p_to_fk_id,
3908: last_update_date = hz_utility_pub.last_update_date,
3909: last_updated_by = hz_utility_pub.user_id,
3910: last_update_login = hz_utility_pub.last_update_login,
3911: request_id = hz_utility_pub.request_id,
3912: program_application_id = hz_utility_pub.program_application_id,
3913: program_id = hz_utility_pub.program_id,
3914: program_update_date = sysdate
3915: WHERE employment_history_id = p_from_id;
3908: last_update_date = hz_utility_pub.last_update_date,
3909: last_updated_by = hz_utility_pub.user_id,
3910: last_update_login = hz_utility_pub.last_update_login,
3911: request_id = hz_utility_pub.request_id,
3912: program_application_id = hz_utility_pub.program_application_id,
3913: program_id = hz_utility_pub.program_id,
3914: program_update_date = sysdate
3915: WHERE employment_history_id = p_from_id;
3916:
3909: last_updated_by = hz_utility_pub.user_id,
3910: last_update_login = hz_utility_pub.last_update_login,
3911: request_id = hz_utility_pub.request_id,
3912: program_application_id = hz_utility_pub.program_application_id,
3913: program_id = hz_utility_pub.program_id,
3914: program_update_date = sysdate
3915: WHERE employment_history_id = p_from_id;
3916:
3917: END IF;
3939: x_to_id <> p_from_id) THEN
3940: UPDATE HZ_WORK_CLASS
3941: SET
3942: STATUS = 'M',
3943: last_update_date = hz_utility_pub.last_update_date,
3944: last_updated_by = hz_utility_pub.user_id,
3945: last_update_login = hz_utility_pub.last_update_login,
3946: request_id = hz_utility_pub.request_id,
3947: program_application_id = hz_utility_pub.program_application_id,
3940: UPDATE HZ_WORK_CLASS
3941: SET
3942: STATUS = 'M',
3943: last_update_date = hz_utility_pub.last_update_date,
3944: last_updated_by = hz_utility_pub.user_id,
3945: last_update_login = hz_utility_pub.last_update_login,
3946: request_id = hz_utility_pub.request_id,
3947: program_application_id = hz_utility_pub.program_application_id,
3948: program_id = hz_utility_pub.program_id,
3941: SET
3942: STATUS = 'M',
3943: last_update_date = hz_utility_pub.last_update_date,
3944: last_updated_by = hz_utility_pub.user_id,
3945: last_update_login = hz_utility_pub.last_update_login,
3946: request_id = hz_utility_pub.request_id,
3947: program_application_id = hz_utility_pub.program_application_id,
3948: program_id = hz_utility_pub.program_id,
3949: program_update_date = sysdate
3942: STATUS = 'M',
3943: last_update_date = hz_utility_pub.last_update_date,
3944: last_updated_by = hz_utility_pub.user_id,
3945: last_update_login = hz_utility_pub.last_update_login,
3946: request_id = hz_utility_pub.request_id,
3947: program_application_id = hz_utility_pub.program_application_id,
3948: program_id = hz_utility_pub.program_id,
3949: program_update_date = sysdate
3950: WHERE work_class_id = p_from_id;
3943: last_update_date = hz_utility_pub.last_update_date,
3944: last_updated_by = hz_utility_pub.user_id,
3945: last_update_login = hz_utility_pub.last_update_login,
3946: request_id = hz_utility_pub.request_id,
3947: program_application_id = hz_utility_pub.program_application_id,
3948: program_id = hz_utility_pub.program_id,
3949: program_update_date = sysdate
3950: WHERE work_class_id = p_from_id;
3951: ELSE
3944: last_updated_by = hz_utility_pub.user_id,
3945: last_update_login = hz_utility_pub.last_update_login,
3946: request_id = hz_utility_pub.request_id,
3947: program_application_id = hz_utility_pub.program_application_id,
3948: program_id = hz_utility_pub.program_id,
3949: program_update_date = sysdate
3950: WHERE work_class_id = p_from_id;
3951: ELSE
3952: -- Update and set employment_history_id = p_to_fk_id where pk = from_id
3952: -- Update and set employment_history_id = p_to_fk_id where pk = from_id
3953: UPDATE HZ_WORK_CLASS
3954: SET
3955: employment_history_id = p_to_fk_id,
3956: last_update_date = hz_utility_pub.last_update_date,
3957: last_updated_by = hz_utility_pub.user_id,
3958: last_update_login = hz_utility_pub.last_update_login,
3959: request_id = hz_utility_pub.request_id,
3960: program_application_id = hz_utility_pub.program_application_id,
3953: UPDATE HZ_WORK_CLASS
3954: SET
3955: employment_history_id = p_to_fk_id,
3956: last_update_date = hz_utility_pub.last_update_date,
3957: last_updated_by = hz_utility_pub.user_id,
3958: last_update_login = hz_utility_pub.last_update_login,
3959: request_id = hz_utility_pub.request_id,
3960: program_application_id = hz_utility_pub.program_application_id,
3961: program_id = hz_utility_pub.program_id,
3954: SET
3955: employment_history_id = p_to_fk_id,
3956: last_update_date = hz_utility_pub.last_update_date,
3957: last_updated_by = hz_utility_pub.user_id,
3958: last_update_login = hz_utility_pub.last_update_login,
3959: request_id = hz_utility_pub.request_id,
3960: program_application_id = hz_utility_pub.program_application_id,
3961: program_id = hz_utility_pub.program_id,
3962: program_update_date = sysdate
3955: employment_history_id = p_to_fk_id,
3956: last_update_date = hz_utility_pub.last_update_date,
3957: last_updated_by = hz_utility_pub.user_id,
3958: last_update_login = hz_utility_pub.last_update_login,
3959: request_id = hz_utility_pub.request_id,
3960: program_application_id = hz_utility_pub.program_application_id,
3961: program_id = hz_utility_pub.program_id,
3962: program_update_date = sysdate
3963: WHERE work_class_id = p_from_id;
3956: last_update_date = hz_utility_pub.last_update_date,
3957: last_updated_by = hz_utility_pub.user_id,
3958: last_update_login = hz_utility_pub.last_update_login,
3959: request_id = hz_utility_pub.request_id,
3960: program_application_id = hz_utility_pub.program_application_id,
3961: program_id = hz_utility_pub.program_id,
3962: program_update_date = sysdate
3963: WHERE work_class_id = p_from_id;
3964:
3957: last_updated_by = hz_utility_pub.user_id,
3958: last_update_login = hz_utility_pub.last_update_login,
3959: request_id = hz_utility_pub.request_id,
3960: program_application_id = hz_utility_pub.program_application_id,
3961: program_id = hz_utility_pub.program_id,
3962: program_update_date = sysdate
3963: WHERE work_class_id = p_from_id;
3964:
3965: END IF;
3997: x_to_id <> p_from_id) THEN
3998: UPDATE HZ_ORG_CONTACT_ROLES
3999: SET
4000: STATUS = 'M',
4001: last_update_date = hz_utility_pub.last_update_date,
4002: last_updated_by = hz_utility_pub.user_id,
4003: last_update_login = hz_utility_pub.last_update_login,
4004: request_id = hz_utility_pub.request_id,
4005: program_application_id = hz_utility_pub.program_application_id,
3998: UPDATE HZ_ORG_CONTACT_ROLES
3999: SET
4000: STATUS = 'M',
4001: last_update_date = hz_utility_pub.last_update_date,
4002: last_updated_by = hz_utility_pub.user_id,
4003: last_update_login = hz_utility_pub.last_update_login,
4004: request_id = hz_utility_pub.request_id,
4005: program_application_id = hz_utility_pub.program_application_id,
4006: program_id = hz_utility_pub.program_id,
3999: SET
4000: STATUS = 'M',
4001: last_update_date = hz_utility_pub.last_update_date,
4002: last_updated_by = hz_utility_pub.user_id,
4003: last_update_login = hz_utility_pub.last_update_login,
4004: request_id = hz_utility_pub.request_id,
4005: program_application_id = hz_utility_pub.program_application_id,
4006: program_id = hz_utility_pub.program_id,
4007: program_update_date = sysdate
4000: STATUS = 'M',
4001: last_update_date = hz_utility_pub.last_update_date,
4002: last_updated_by = hz_utility_pub.user_id,
4003: last_update_login = hz_utility_pub.last_update_login,
4004: request_id = hz_utility_pub.request_id,
4005: program_application_id = hz_utility_pub.program_application_id,
4006: program_id = hz_utility_pub.program_id,
4007: program_update_date = sysdate
4008: WHERE org_contact_role_id = p_from_id;
4001: last_update_date = hz_utility_pub.last_update_date,
4002: last_updated_by = hz_utility_pub.user_id,
4003: last_update_login = hz_utility_pub.last_update_login,
4004: request_id = hz_utility_pub.request_id,
4005: program_application_id = hz_utility_pub.program_application_id,
4006: program_id = hz_utility_pub.program_id,
4007: program_update_date = sysdate
4008: WHERE org_contact_role_id = p_from_id;
4009:
4002: last_updated_by = hz_utility_pub.user_id,
4003: last_update_login = hz_utility_pub.last_update_login,
4004: request_id = hz_utility_pub.request_id,
4005: program_application_id = hz_utility_pub.program_application_id,
4006: program_id = hz_utility_pub.program_id,
4007: program_update_date = sysdate
4008: WHERE org_contact_role_id = p_from_id;
4009:
4010: HZ_ORIG_SYSTEM_REF_PVT.remap_internal_identifier(
4082: SET
4083: org_contact_id = p_to_fk_id,
4084: primary_flag = l_primary_flag,
4085: primary_contact_per_role_type = l_primary_role_flag,
4086: last_update_date = hz_utility_pub.last_update_date,
4087: last_updated_by = hz_utility_pub.user_id,
4088: last_update_login = hz_utility_pub.last_update_login,
4089: request_id = hz_utility_pub.request_id,
4090: program_application_id = hz_utility_pub.program_application_id,
4083: org_contact_id = p_to_fk_id,
4084: primary_flag = l_primary_flag,
4085: primary_contact_per_role_type = l_primary_role_flag,
4086: last_update_date = hz_utility_pub.last_update_date,
4087: last_updated_by = hz_utility_pub.user_id,
4088: last_update_login = hz_utility_pub.last_update_login,
4089: request_id = hz_utility_pub.request_id,
4090: program_application_id = hz_utility_pub.program_application_id,
4091: program_id = hz_utility_pub.program_id,
4084: primary_flag = l_primary_flag,
4085: primary_contact_per_role_type = l_primary_role_flag,
4086: last_update_date = hz_utility_pub.last_update_date,
4087: last_updated_by = hz_utility_pub.user_id,
4088: last_update_login = hz_utility_pub.last_update_login,
4089: request_id = hz_utility_pub.request_id,
4090: program_application_id = hz_utility_pub.program_application_id,
4091: program_id = hz_utility_pub.program_id,
4092: program_update_date = sysdate
4085: primary_contact_per_role_type = l_primary_role_flag,
4086: last_update_date = hz_utility_pub.last_update_date,
4087: last_updated_by = hz_utility_pub.user_id,
4088: last_update_login = hz_utility_pub.last_update_login,
4089: request_id = hz_utility_pub.request_id,
4090: program_application_id = hz_utility_pub.program_application_id,
4091: program_id = hz_utility_pub.program_id,
4092: program_update_date = sysdate
4093: WHERE org_contact_role_id = p_from_id;
4086: last_update_date = hz_utility_pub.last_update_date,
4087: last_updated_by = hz_utility_pub.user_id,
4088: last_update_login = hz_utility_pub.last_update_login,
4089: request_id = hz_utility_pub.request_id,
4090: program_application_id = hz_utility_pub.program_application_id,
4091: program_id = hz_utility_pub.program_id,
4092: program_update_date = sysdate
4093: WHERE org_contact_role_id = p_from_id;
4094: END IF;
4087: last_updated_by = hz_utility_pub.user_id,
4088: last_update_login = hz_utility_pub.last_update_login,
4089: request_id = hz_utility_pub.request_id,
4090: program_application_id = hz_utility_pub.program_application_id,
4091: program_id = hz_utility_pub.program_id,
4092: program_update_date = sysdate
4093: WHERE org_contact_role_id = p_from_id;
4094: END IF;
4095:
4115: x_to_id <> p_from_id) THEN
4116: UPDATE HZ_FINANCIAL_NUMBERS
4117: SET
4118: STATUS = 'M',
4119: last_update_date = hz_utility_pub.last_update_date,
4120: last_updated_by = hz_utility_pub.user_id,
4121: last_update_login = hz_utility_pub.last_update_login,
4122: request_id = hz_utility_pub.request_id,
4123: program_application_id = hz_utility_pub.program_application_id,
4116: UPDATE HZ_FINANCIAL_NUMBERS
4117: SET
4118: STATUS = 'M',
4119: last_update_date = hz_utility_pub.last_update_date,
4120: last_updated_by = hz_utility_pub.user_id,
4121: last_update_login = hz_utility_pub.last_update_login,
4122: request_id = hz_utility_pub.request_id,
4123: program_application_id = hz_utility_pub.program_application_id,
4124: program_id = hz_utility_pub.program_id,
4117: SET
4118: STATUS = 'M',
4119: last_update_date = hz_utility_pub.last_update_date,
4120: last_updated_by = hz_utility_pub.user_id,
4121: last_update_login = hz_utility_pub.last_update_login,
4122: request_id = hz_utility_pub.request_id,
4123: program_application_id = hz_utility_pub.program_application_id,
4124: program_id = hz_utility_pub.program_id,
4125: program_update_date = sysdate
4118: STATUS = 'M',
4119: last_update_date = hz_utility_pub.last_update_date,
4120: last_updated_by = hz_utility_pub.user_id,
4121: last_update_login = hz_utility_pub.last_update_login,
4122: request_id = hz_utility_pub.request_id,
4123: program_application_id = hz_utility_pub.program_application_id,
4124: program_id = hz_utility_pub.program_id,
4125: program_update_date = sysdate
4126: WHERE financial_number_id = p_from_id;
4119: last_update_date = hz_utility_pub.last_update_date,
4120: last_updated_by = hz_utility_pub.user_id,
4121: last_update_login = hz_utility_pub.last_update_login,
4122: request_id = hz_utility_pub.request_id,
4123: program_application_id = hz_utility_pub.program_application_id,
4124: program_id = hz_utility_pub.program_id,
4125: program_update_date = sysdate
4126: WHERE financial_number_id = p_from_id;
4127: ELSE
4120: last_updated_by = hz_utility_pub.user_id,
4121: last_update_login = hz_utility_pub.last_update_login,
4122: request_id = hz_utility_pub.request_id,
4123: program_application_id = hz_utility_pub.program_application_id,
4124: program_id = hz_utility_pub.program_id,
4125: program_update_date = sysdate
4126: WHERE financial_number_id = p_from_id;
4127: ELSE
4128: -- Update and set party_id = p_to_fk_id where pk = from_id
4128: -- Update and set party_id = p_to_fk_id where pk = from_id
4129: UPDATE HZ_FINANCIAL_NUMBERS
4130: SET
4131: financial_report_id = p_to_fk_id,
4132: last_update_date = hz_utility_pub.last_update_date,
4133: last_updated_by = hz_utility_pub.user_id,
4134: last_update_login = hz_utility_pub.last_update_login,
4135: request_id = hz_utility_pub.request_id,
4136: program_application_id = hz_utility_pub.program_application_id,
4129: UPDATE HZ_FINANCIAL_NUMBERS
4130: SET
4131: financial_report_id = p_to_fk_id,
4132: last_update_date = hz_utility_pub.last_update_date,
4133: last_updated_by = hz_utility_pub.user_id,
4134: last_update_login = hz_utility_pub.last_update_login,
4135: request_id = hz_utility_pub.request_id,
4136: program_application_id = hz_utility_pub.program_application_id,
4137: program_id = hz_utility_pub.program_id,
4130: SET
4131: financial_report_id = p_to_fk_id,
4132: last_update_date = hz_utility_pub.last_update_date,
4133: last_updated_by = hz_utility_pub.user_id,
4134: last_update_login = hz_utility_pub.last_update_login,
4135: request_id = hz_utility_pub.request_id,
4136: program_application_id = hz_utility_pub.program_application_id,
4137: program_id = hz_utility_pub.program_id,
4138: program_update_date = sysdate
4131: financial_report_id = p_to_fk_id,
4132: last_update_date = hz_utility_pub.last_update_date,
4133: last_updated_by = hz_utility_pub.user_id,
4134: last_update_login = hz_utility_pub.last_update_login,
4135: request_id = hz_utility_pub.request_id,
4136: program_application_id = hz_utility_pub.program_application_id,
4137: program_id = hz_utility_pub.program_id,
4138: program_update_date = sysdate
4139: WHERE financial_number_id = p_from_id;
4132: last_update_date = hz_utility_pub.last_update_date,
4133: last_updated_by = hz_utility_pub.user_id,
4134: last_update_login = hz_utility_pub.last_update_login,
4135: request_id = hz_utility_pub.request_id,
4136: program_application_id = hz_utility_pub.program_application_id,
4137: program_id = hz_utility_pub.program_id,
4138: program_update_date = sysdate
4139: WHERE financial_number_id = p_from_id;
4140: END IF;
4133: last_updated_by = hz_utility_pub.user_id,
4134: last_update_login = hz_utility_pub.last_update_login,
4135: request_id = hz_utility_pub.request_id,
4136: program_application_id = hz_utility_pub.program_application_id,
4137: program_id = hz_utility_pub.program_id,
4138: program_update_date = sysdate
4139: WHERE financial_number_id = p_from_id;
4140: END IF;
4141:
4192: OR (NVL(l_code_exists,'N') = 'Y') THEN
4193: UPDATE HZ_CODE_ASSIGNMENTS
4194: SET
4195: STATUS = 'M',
4196: last_update_date = hz_utility_pub.last_update_date,
4197: last_updated_by = hz_utility_pub.user_id,
4198: last_update_login = hz_utility_pub.last_update_login
4199: -- request_id = hz_utility_pub.request_id,
4200: -- program_application_id = hz_utility_pub.program_application_id,
4193: UPDATE HZ_CODE_ASSIGNMENTS
4194: SET
4195: STATUS = 'M',
4196: last_update_date = hz_utility_pub.last_update_date,
4197: last_updated_by = hz_utility_pub.user_id,
4198: last_update_login = hz_utility_pub.last_update_login
4199: -- request_id = hz_utility_pub.request_id,
4200: -- program_application_id = hz_utility_pub.program_application_id,
4201: -- program_id = hz_utility_pub.program_id,
4194: SET
4195: STATUS = 'M',
4196: last_update_date = hz_utility_pub.last_update_date,
4197: last_updated_by = hz_utility_pub.user_id,
4198: last_update_login = hz_utility_pub.last_update_login
4199: -- request_id = hz_utility_pub.request_id,
4200: -- program_application_id = hz_utility_pub.program_application_id,
4201: -- program_id = hz_utility_pub.program_id,
4202: -- program_update_date = sysdate
4195: STATUS = 'M',
4196: last_update_date = hz_utility_pub.last_update_date,
4197: last_updated_by = hz_utility_pub.user_id,
4198: last_update_login = hz_utility_pub.last_update_login
4199: -- request_id = hz_utility_pub.request_id,
4200: -- program_application_id = hz_utility_pub.program_application_id,
4201: -- program_id = hz_utility_pub.program_id,
4202: -- program_update_date = sysdate
4203: WHERE code_assignment_id = p_from_id;
4196: last_update_date = hz_utility_pub.last_update_date,
4197: last_updated_by = hz_utility_pub.user_id,
4198: last_update_login = hz_utility_pub.last_update_login
4199: -- request_id = hz_utility_pub.request_id,
4200: -- program_application_id = hz_utility_pub.program_application_id,
4201: -- program_id = hz_utility_pub.program_id,
4202: -- program_update_date = sysdate
4203: WHERE code_assignment_id = p_from_id;
4204:
4197: last_updated_by = hz_utility_pub.user_id,
4198: last_update_login = hz_utility_pub.last_update_login
4199: -- request_id = hz_utility_pub.request_id,
4200: -- program_application_id = hz_utility_pub.program_application_id,
4201: -- program_id = hz_utility_pub.program_id,
4202: -- program_update_date = sysdate
4203: WHERE code_assignment_id = p_from_id;
4204:
4205: ELSE
4229: UPDATE HZ_CODE_ASSIGNMENTS
4230: SET
4231: owner_table_id = p_to_fk_id,
4232: primary_flag = l_primary_flag,
4233: last_update_date = hz_utility_pub.last_update_date,
4234: last_updated_by = hz_utility_pub.user_id,
4235: last_update_login = hz_utility_pub.last_update_login
4236: -- request_id = hz_utility_pub.request_id,
4237: -- program_application_id = hz_utility_pub.program_application_id,
4230: SET
4231: owner_table_id = p_to_fk_id,
4232: primary_flag = l_primary_flag,
4233: last_update_date = hz_utility_pub.last_update_date,
4234: last_updated_by = hz_utility_pub.user_id,
4235: last_update_login = hz_utility_pub.last_update_login
4236: -- request_id = hz_utility_pub.request_id,
4237: -- program_application_id = hz_utility_pub.program_application_id,
4238: -- program_id = hz_utility_pub.program_id,
4231: owner_table_id = p_to_fk_id,
4232: primary_flag = l_primary_flag,
4233: last_update_date = hz_utility_pub.last_update_date,
4234: last_updated_by = hz_utility_pub.user_id,
4235: last_update_login = hz_utility_pub.last_update_login
4236: -- request_id = hz_utility_pub.request_id,
4237: -- program_application_id = hz_utility_pub.program_application_id,
4238: -- program_id = hz_utility_pub.program_id,
4239: -- program_update_date = sysdate
4232: primary_flag = l_primary_flag,
4233: last_update_date = hz_utility_pub.last_update_date,
4234: last_updated_by = hz_utility_pub.user_id,
4235: last_update_login = hz_utility_pub.last_update_login
4236: -- request_id = hz_utility_pub.request_id,
4237: -- program_application_id = hz_utility_pub.program_application_id,
4238: -- program_id = hz_utility_pub.program_id,
4239: -- program_update_date = sysdate
4240: WHERE code_assignment_id = p_from_id;
4233: last_update_date = hz_utility_pub.last_update_date,
4234: last_updated_by = hz_utility_pub.user_id,
4235: last_update_login = hz_utility_pub.last_update_login
4236: -- request_id = hz_utility_pub.request_id,
4237: -- program_application_id = hz_utility_pub.program_application_id,
4238: -- program_id = hz_utility_pub.program_id,
4239: -- program_update_date = sysdate
4240: WHERE code_assignment_id = p_from_id;
4241:
4234: last_updated_by = hz_utility_pub.user_id,
4235: last_update_login = hz_utility_pub.last_update_login
4236: -- request_id = hz_utility_pub.request_id,
4237: -- program_application_id = hz_utility_pub.program_application_id,
4238: -- program_id = hz_utility_pub.program_id,
4239: -- program_update_date = sysdate
4240: WHERE code_assignment_id = p_from_id;
4241:
4242: --bug 4582789
4243:
4244: IF l_primary_flag = 'Y' AND l_class_category = 'CUSTOMER_CATEGORY' THEN
4245: UPDATE hz_parties
4246: SET category_code = l_class_code,
4247: last_update_date = hz_utility_pub.last_update_date,
4248: last_updated_by = hz_utility_pub.user_id,
4249: last_update_login = hz_utility_pub.last_update_login
4250: WHERE party_id = p_to_fk_id;
4251: END IF;
4244: IF l_primary_flag = 'Y' AND l_class_category = 'CUSTOMER_CATEGORY' THEN
4245: UPDATE hz_parties
4246: SET category_code = l_class_code,
4247: last_update_date = hz_utility_pub.last_update_date,
4248: last_updated_by = hz_utility_pub.user_id,
4249: last_update_login = hz_utility_pub.last_update_login
4250: WHERE party_id = p_to_fk_id;
4251: END IF;
4252: ---bug 4582789
4245: UPDATE hz_parties
4246: SET category_code = l_class_code,
4247: last_update_date = hz_utility_pub.last_update_date,
4248: last_updated_by = hz_utility_pub.user_id,
4249: last_update_login = hz_utility_pub.last_update_login
4250: WHERE party_id = p_to_fk_id;
4251: END IF;
4252: ---bug 4582789
4253: END IF;
4303: x_to_id <> p_from_id) OR (NVL(l_code_exists,'N') = 'Y') THEN
4304: UPDATE HZ_CODE_ASSIGNMENTS
4305: SET
4306: STATUS = 'M',
4307: last_update_date = hz_utility_pub.last_update_date,
4308: last_updated_by = hz_utility_pub.user_id,
4309: last_update_login = hz_utility_pub.last_update_login
4310: -- request_id = hz_utility_pub.request_id,
4311: -- program_application_id = hz_utility_pub.program_application_id,
4304: UPDATE HZ_CODE_ASSIGNMENTS
4305: SET
4306: STATUS = 'M',
4307: last_update_date = hz_utility_pub.last_update_date,
4308: last_updated_by = hz_utility_pub.user_id,
4309: last_update_login = hz_utility_pub.last_update_login
4310: -- request_id = hz_utility_pub.request_id,
4311: -- program_application_id = hz_utility_pub.program_application_id,
4312: -- program_id = hz_utility_pub.program_id,
4305: SET
4306: STATUS = 'M',
4307: last_update_date = hz_utility_pub.last_update_date,
4308: last_updated_by = hz_utility_pub.user_id,
4309: last_update_login = hz_utility_pub.last_update_login
4310: -- request_id = hz_utility_pub.request_id,
4311: -- program_application_id = hz_utility_pub.program_application_id,
4312: -- program_id = hz_utility_pub.program_id,
4313: -- program_update_date = sysdate
4306: STATUS = 'M',
4307: last_update_date = hz_utility_pub.last_update_date,
4308: last_updated_by = hz_utility_pub.user_id,
4309: last_update_login = hz_utility_pub.last_update_login
4310: -- request_id = hz_utility_pub.request_id,
4311: -- program_application_id = hz_utility_pub.program_application_id,
4312: -- program_id = hz_utility_pub.program_id,
4313: -- program_update_date = sysdate
4314: WHERE code_assignment_id = p_from_id;
4307: last_update_date = hz_utility_pub.last_update_date,
4308: last_updated_by = hz_utility_pub.user_id,
4309: last_update_login = hz_utility_pub.last_update_login
4310: -- request_id = hz_utility_pub.request_id,
4311: -- program_application_id = hz_utility_pub.program_application_id,
4312: -- program_id = hz_utility_pub.program_id,
4313: -- program_update_date = sysdate
4314: WHERE code_assignment_id = p_from_id;
4315: ELSE
4308: last_updated_by = hz_utility_pub.user_id,
4309: last_update_login = hz_utility_pub.last_update_login
4310: -- request_id = hz_utility_pub.request_id,
4311: -- program_application_id = hz_utility_pub.program_application_id,
4312: -- program_id = hz_utility_pub.program_id,
4313: -- program_update_date = sysdate
4314: WHERE code_assignment_id = p_from_id;
4315: ELSE
4316: --- Transfer ---
4339: UPDATE HZ_CODE_ASSIGNMENTS
4340: SET
4341: owner_table_id = p_to_fk_id,
4342: primary_flag = l_primary_flag,
4343: last_update_date = hz_utility_pub.last_update_date,
4344: last_updated_by = hz_utility_pub.user_id,
4345: last_update_login = hz_utility_pub.last_update_login
4346: -- request_id = hz_utility_pub.request_id,
4347: -- program_application_id = hz_utility_pub.program_application_id,
4340: SET
4341: owner_table_id = p_to_fk_id,
4342: primary_flag = l_primary_flag,
4343: last_update_date = hz_utility_pub.last_update_date,
4344: last_updated_by = hz_utility_pub.user_id,
4345: last_update_login = hz_utility_pub.last_update_login
4346: -- request_id = hz_utility_pub.request_id,
4347: -- program_application_id = hz_utility_pub.program_application_id,
4348: -- program_id = hz_utility_pub.program_id,
4341: owner_table_id = p_to_fk_id,
4342: primary_flag = l_primary_flag,
4343: last_update_date = hz_utility_pub.last_update_date,
4344: last_updated_by = hz_utility_pub.user_id,
4345: last_update_login = hz_utility_pub.last_update_login
4346: -- request_id = hz_utility_pub.request_id,
4347: -- program_application_id = hz_utility_pub.program_application_id,
4348: -- program_id = hz_utility_pub.program_id,
4349: -- program_update_date = sysdate
4342: primary_flag = l_primary_flag,
4343: last_update_date = hz_utility_pub.last_update_date,
4344: last_updated_by = hz_utility_pub.user_id,
4345: last_update_login = hz_utility_pub.last_update_login
4346: -- request_id = hz_utility_pub.request_id,
4347: -- program_application_id = hz_utility_pub.program_application_id,
4348: -- program_id = hz_utility_pub.program_id,
4349: -- program_update_date = sysdate
4350: WHERE code_assignment_id = p_from_id;
4343: last_update_date = hz_utility_pub.last_update_date,
4344: last_updated_by = hz_utility_pub.user_id,
4345: last_update_login = hz_utility_pub.last_update_login
4346: -- request_id = hz_utility_pub.request_id,
4347: -- program_application_id = hz_utility_pub.program_application_id,
4348: -- program_id = hz_utility_pub.program_id,
4349: -- program_update_date = sysdate
4350: WHERE code_assignment_id = p_from_id;
4351: END IF;
4344: last_updated_by = hz_utility_pub.user_id,
4345: last_update_login = hz_utility_pub.last_update_login
4346: -- request_id = hz_utility_pub.request_id,
4347: -- program_application_id = hz_utility_pub.program_application_id,
4348: -- program_id = hz_utility_pub.program_id,
4349: -- program_update_date = sysdate
4350: WHERE code_assignment_id = p_from_id;
4351: END IF;
4352:
4382: x_to_id <> p_from_id) THEN
4383: UPDATE HZ_PERSON_LANGUAGE
4384: SET
4385: STATUS = 'M',
4386: last_update_date = hz_utility_pub.last_update_date,
4387: last_updated_by = hz_utility_pub.user_id,
4388: last_update_login = hz_utility_pub.last_update_login,
4389: request_id = hz_utility_pub.request_id,
4390: program_application_id = hz_utility_pub.program_application_id,
4383: UPDATE HZ_PERSON_LANGUAGE
4384: SET
4385: STATUS = 'M',
4386: last_update_date = hz_utility_pub.last_update_date,
4387: last_updated_by = hz_utility_pub.user_id,
4388: last_update_login = hz_utility_pub.last_update_login,
4389: request_id = hz_utility_pub.request_id,
4390: program_application_id = hz_utility_pub.program_application_id,
4391: program_id = hz_utility_pub.program_id,
4384: SET
4385: STATUS = 'M',
4386: last_update_date = hz_utility_pub.last_update_date,
4387: last_updated_by = hz_utility_pub.user_id,
4388: last_update_login = hz_utility_pub.last_update_login,
4389: request_id = hz_utility_pub.request_id,
4390: program_application_id = hz_utility_pub.program_application_id,
4391: program_id = hz_utility_pub.program_id,
4392: program_update_date = sysdate
4385: STATUS = 'M',
4386: last_update_date = hz_utility_pub.last_update_date,
4387: last_updated_by = hz_utility_pub.user_id,
4388: last_update_login = hz_utility_pub.last_update_login,
4389: request_id = hz_utility_pub.request_id,
4390: program_application_id = hz_utility_pub.program_application_id,
4391: program_id = hz_utility_pub.program_id,
4392: program_update_date = sysdate
4393: WHERE language_use_reference_id = p_from_id;
4386: last_update_date = hz_utility_pub.last_update_date,
4387: last_updated_by = hz_utility_pub.user_id,
4388: last_update_login = hz_utility_pub.last_update_login,
4389: request_id = hz_utility_pub.request_id,
4390: program_application_id = hz_utility_pub.program_application_id,
4391: program_id = hz_utility_pub.program_id,
4392: program_update_date = sysdate
4393: WHERE language_use_reference_id = p_from_id;
4394: ELSE
4387: last_updated_by = hz_utility_pub.user_id,
4388: last_update_login = hz_utility_pub.last_update_login,
4389: request_id = hz_utility_pub.request_id,
4390: program_application_id = hz_utility_pub.program_application_id,
4391: program_id = hz_utility_pub.program_id,
4392: program_update_date = sysdate
4393: WHERE language_use_reference_id = p_from_id;
4394: ELSE
4395: --- Transfer ---
4444: SET
4445: party_id = p_to_fk_id,
4446: primary_language_indicator = l_primary_lang_flag,
4447: native_language = l_primary_nav_flag,
4448: last_update_date = hz_utility_pub.last_update_date,
4449: last_updated_by = hz_utility_pub.user_id,
4450: last_update_login = hz_utility_pub.last_update_login,
4451: request_id = hz_utility_pub.request_id,
4452: program_application_id = hz_utility_pub.program_application_id,
4445: party_id = p_to_fk_id,
4446: primary_language_indicator = l_primary_lang_flag,
4447: native_language = l_primary_nav_flag,
4448: last_update_date = hz_utility_pub.last_update_date,
4449: last_updated_by = hz_utility_pub.user_id,
4450: last_update_login = hz_utility_pub.last_update_login,
4451: request_id = hz_utility_pub.request_id,
4452: program_application_id = hz_utility_pub.program_application_id,
4453: program_id = hz_utility_pub.program_id,
4446: primary_language_indicator = l_primary_lang_flag,
4447: native_language = l_primary_nav_flag,
4448: last_update_date = hz_utility_pub.last_update_date,
4449: last_updated_by = hz_utility_pub.user_id,
4450: last_update_login = hz_utility_pub.last_update_login,
4451: request_id = hz_utility_pub.request_id,
4452: program_application_id = hz_utility_pub.program_application_id,
4453: program_id = hz_utility_pub.program_id,
4454: program_update_date = sysdate
4447: native_language = l_primary_nav_flag,
4448: last_update_date = hz_utility_pub.last_update_date,
4449: last_updated_by = hz_utility_pub.user_id,
4450: last_update_login = hz_utility_pub.last_update_login,
4451: request_id = hz_utility_pub.request_id,
4452: program_application_id = hz_utility_pub.program_application_id,
4453: program_id = hz_utility_pub.program_id,
4454: program_update_date = sysdate
4455: WHERE language_use_reference_id = p_from_id;
4448: last_update_date = hz_utility_pub.last_update_date,
4449: last_updated_by = hz_utility_pub.user_id,
4450: last_update_login = hz_utility_pub.last_update_login,
4451: request_id = hz_utility_pub.request_id,
4452: program_application_id = hz_utility_pub.program_application_id,
4453: program_id = hz_utility_pub.program_id,
4454: program_update_date = sysdate
4455: WHERE language_use_reference_id = p_from_id;
4456:
4449: last_updated_by = hz_utility_pub.user_id,
4450: last_update_login = hz_utility_pub.last_update_login,
4451: request_id = hz_utility_pub.request_id,
4452: program_application_id = hz_utility_pub.program_application_id,
4453: program_id = hz_utility_pub.program_id,
4454: program_update_date = sysdate
4455: WHERE language_use_reference_id = p_from_id;
4456:
4457: END IF;
4507: UPDATE HZ_PARTY_SITE_USES
4508: SET
4509: ----Bug: 2619948 added setting status to 'M' here too
4510: STATUS = 'M',
4511: last_update_date = hz_utility_pub.last_update_date,
4512: last_updated_by = hz_utility_pub.user_id,
4513: last_update_login = hz_utility_pub.last_update_login,
4514: request_id = hz_utility_pub.request_id,
4515: program_application_id = hz_utility_pub.program_application_id,
4508: SET
4509: ----Bug: 2619948 added setting status to 'M' here too
4510: STATUS = 'M',
4511: last_update_date = hz_utility_pub.last_update_date,
4512: last_updated_by = hz_utility_pub.user_id,
4513: last_update_login = hz_utility_pub.last_update_login,
4514: request_id = hz_utility_pub.request_id,
4515: program_application_id = hz_utility_pub.program_application_id,
4516: program_id = hz_utility_pub.program_id,
4509: ----Bug: 2619948 added setting status to 'M' here too
4510: STATUS = 'M',
4511: last_update_date = hz_utility_pub.last_update_date,
4512: last_updated_by = hz_utility_pub.user_id,
4513: last_update_login = hz_utility_pub.last_update_login,
4514: request_id = hz_utility_pub.request_id,
4515: program_application_id = hz_utility_pub.program_application_id,
4516: program_id = hz_utility_pub.program_id,
4517: program_update_date = sysdate
4510: STATUS = 'M',
4511: last_update_date = hz_utility_pub.last_update_date,
4512: last_updated_by = hz_utility_pub.user_id,
4513: last_update_login = hz_utility_pub.last_update_login,
4514: request_id = hz_utility_pub.request_id,
4515: program_application_id = hz_utility_pub.program_application_id,
4516: program_id = hz_utility_pub.program_id,
4517: program_update_date = sysdate
4518: WHERE party_site_use_id = p_from_id;
4511: last_update_date = hz_utility_pub.last_update_date,
4512: last_updated_by = hz_utility_pub.user_id,
4513: last_update_login = hz_utility_pub.last_update_login,
4514: request_id = hz_utility_pub.request_id,
4515: program_application_id = hz_utility_pub.program_application_id,
4516: program_id = hz_utility_pub.program_id,
4517: program_update_date = sysdate
4518: WHERE party_site_use_id = p_from_id;
4519: ELSE
4512: last_updated_by = hz_utility_pub.user_id,
4513: last_update_login = hz_utility_pub.last_update_login,
4514: request_id = hz_utility_pub.request_id,
4515: program_application_id = hz_utility_pub.program_application_id,
4516: program_id = hz_utility_pub.program_id,
4517: program_update_date = sysdate
4518: WHERE party_site_use_id = p_from_id;
4519: ELSE
4520:
4543: OPEN c_party_id(p_to_fk_id);
4544: FETCH c_party_id INTO l_party_id;
4545: CLOSE c_party_id;
4546:
4547: OPEN c_prim_site_uses(l_party_id,p_to_fk_id,party_site_use_rec.site_use_type,hz_utility_pub.request_id);
4548: FETCH c_prim_site_uses INTO l_prim_use_exists, l_request_id;
4549: CLOSE c_prim_site_uses;
4550: IF l_prim_use_exists <> 0 THEN
4551: IF l_request_id is null OR l_request_id <> hz_utility_pub.request_id THEN
4547: OPEN c_prim_site_uses(l_party_id,p_to_fk_id,party_site_use_rec.site_use_type,hz_utility_pub.request_id);
4548: FETCH c_prim_site_uses INTO l_prim_use_exists, l_request_id;
4549: CLOSE c_prim_site_uses;
4550: IF l_prim_use_exists <> 0 THEN
4551: IF l_request_id is null OR l_request_id <> hz_utility_pub.request_id THEN
4552: party_site_use_rec.primary_per_type := 'N';
4553: END IF;
4554: END IF;
4555: END IF;
4575: -- Update and set party_id = p_to_fk_id where pk = from_id
4576: UPDATE HZ_PARTY_SITE_USES
4577: SET
4578: STATUS = 'M',
4579: last_update_date = hz_utility_pub.last_update_date,
4580: last_updated_by = hz_utility_pub.user_id,
4581: last_update_login = hz_utility_pub.last_update_login,
4582: request_id = hz_utility_pub.request_id,
4583: program_application_id = hz_utility_pub.program_application_id,
4576: UPDATE HZ_PARTY_SITE_USES
4577: SET
4578: STATUS = 'M',
4579: last_update_date = hz_utility_pub.last_update_date,
4580: last_updated_by = hz_utility_pub.user_id,
4581: last_update_login = hz_utility_pub.last_update_login,
4582: request_id = hz_utility_pub.request_id,
4583: program_application_id = hz_utility_pub.program_application_id,
4584: program_id = hz_utility_pub.program_id,
4577: SET
4578: STATUS = 'M',
4579: last_update_date = hz_utility_pub.last_update_date,
4580: last_updated_by = hz_utility_pub.user_id,
4581: last_update_login = hz_utility_pub.last_update_login,
4582: request_id = hz_utility_pub.request_id,
4583: program_application_id = hz_utility_pub.program_application_id,
4584: program_id = hz_utility_pub.program_id,
4585: program_update_date = sysdate
4578: STATUS = 'M',
4579: last_update_date = hz_utility_pub.last_update_date,
4580: last_updated_by = hz_utility_pub.user_id,
4581: last_update_login = hz_utility_pub.last_update_login,
4582: request_id = hz_utility_pub.request_id,
4583: program_application_id = hz_utility_pub.program_application_id,
4584: program_id = hz_utility_pub.program_id,
4585: program_update_date = sysdate
4586: WHERE party_site_use_id = p_from_id;
4579: last_update_date = hz_utility_pub.last_update_date,
4580: last_updated_by = hz_utility_pub.user_id,
4581: last_update_login = hz_utility_pub.last_update_login,
4582: request_id = hz_utility_pub.request_id,
4583: program_application_id = hz_utility_pub.program_application_id,
4584: program_id = hz_utility_pub.program_id,
4585: program_update_date = sysdate
4586: WHERE party_site_use_id = p_from_id;
4587:
4580: last_updated_by = hz_utility_pub.user_id,
4581: last_update_login = hz_utility_pub.last_update_login,
4582: request_id = hz_utility_pub.request_id,
4583: program_application_id = hz_utility_pub.program_application_id,
4584: program_id = hz_utility_pub.program_id,
4585: program_update_date = sysdate
4586: WHERE party_site_use_id = p_from_id;
4587:
4588: x_return_status := 'N';
4612: x_to_id <> p_from_id) THEN
4613: UPDATE HZ_CUST_ACCT_SITES_ALL
4614: SET
4615: STATUS = 'M',
4616: last_update_date = hz_utility_pub.last_update_date,
4617: last_updated_by = hz_utility_pub.user_id,
4618: last_update_login = hz_utility_pub.last_update_login,
4619: request_id = hz_utility_pub.request_id,
4620: program_application_id = hz_utility_pub.program_application_id,
4613: UPDATE HZ_CUST_ACCT_SITES_ALL
4614: SET
4615: STATUS = 'M',
4616: last_update_date = hz_utility_pub.last_update_date,
4617: last_updated_by = hz_utility_pub.user_id,
4618: last_update_login = hz_utility_pub.last_update_login,
4619: request_id = hz_utility_pub.request_id,
4620: program_application_id = hz_utility_pub.program_application_id,
4621: program_id = hz_utility_pub.program_id,
4614: SET
4615: STATUS = 'M',
4616: last_update_date = hz_utility_pub.last_update_date,
4617: last_updated_by = hz_utility_pub.user_id,
4618: last_update_login = hz_utility_pub.last_update_login,
4619: request_id = hz_utility_pub.request_id,
4620: program_application_id = hz_utility_pub.program_application_id,
4621: program_id = hz_utility_pub.program_id,
4622: program_update_date = sysdate
4615: STATUS = 'M',
4616: last_update_date = hz_utility_pub.last_update_date,
4617: last_updated_by = hz_utility_pub.user_id,
4618: last_update_login = hz_utility_pub.last_update_login,
4619: request_id = hz_utility_pub.request_id,
4620: program_application_id = hz_utility_pub.program_application_id,
4621: program_id = hz_utility_pub.program_id,
4622: program_update_date = sysdate
4623: WHERE cust_acct_site_id = p_from_id;
4616: last_update_date = hz_utility_pub.last_update_date,
4617: last_updated_by = hz_utility_pub.user_id,
4618: last_update_login = hz_utility_pub.last_update_login,
4619: request_id = hz_utility_pub.request_id,
4620: program_application_id = hz_utility_pub.program_application_id,
4621: program_id = hz_utility_pub.program_id,
4622: program_update_date = sysdate
4623: WHERE cust_acct_site_id = p_from_id;
4624:
4617: last_updated_by = hz_utility_pub.user_id,
4618: last_update_login = hz_utility_pub.last_update_login,
4619: request_id = hz_utility_pub.request_id,
4620: program_application_id = hz_utility_pub.program_application_id,
4621: program_id = hz_utility_pub.program_id,
4622: program_update_date = sysdate
4623: WHERE cust_acct_site_id = p_from_id;
4624:
4625: HZ_ORIG_SYSTEM_REF_PVT.remap_internal_identifier(
4645: ELSE
4646: UPDATE HZ_CUST_ACCT_SITES_ALL
4647: SET
4648: party_site_id = p_to_fk_id,
4649: last_update_date = hz_utility_pub.last_update_date,
4650: last_updated_by = hz_utility_pub.user_id,
4651: last_update_login = hz_utility_pub.last_update_login,
4652: request_id = hz_utility_pub.request_id,
4653: program_application_id = hz_utility_pub.program_application_id,
4646: UPDATE HZ_CUST_ACCT_SITES_ALL
4647: SET
4648: party_site_id = p_to_fk_id,
4649: last_update_date = hz_utility_pub.last_update_date,
4650: last_updated_by = hz_utility_pub.user_id,
4651: last_update_login = hz_utility_pub.last_update_login,
4652: request_id = hz_utility_pub.request_id,
4653: program_application_id = hz_utility_pub.program_application_id,
4654: program_id = hz_utility_pub.program_id,
4647: SET
4648: party_site_id = p_to_fk_id,
4649: last_update_date = hz_utility_pub.last_update_date,
4650: last_updated_by = hz_utility_pub.user_id,
4651: last_update_login = hz_utility_pub.last_update_login,
4652: request_id = hz_utility_pub.request_id,
4653: program_application_id = hz_utility_pub.program_application_id,
4654: program_id = hz_utility_pub.program_id,
4655: program_update_date = sysdate
4648: party_site_id = p_to_fk_id,
4649: last_update_date = hz_utility_pub.last_update_date,
4650: last_updated_by = hz_utility_pub.user_id,
4651: last_update_login = hz_utility_pub.last_update_login,
4652: request_id = hz_utility_pub.request_id,
4653: program_application_id = hz_utility_pub.program_application_id,
4654: program_id = hz_utility_pub.program_id,
4655: program_update_date = sysdate
4656: WHERE cust_acct_site_id = p_from_id;
4649: last_update_date = hz_utility_pub.last_update_date,
4650: last_updated_by = hz_utility_pub.user_id,
4651: last_update_login = hz_utility_pub.last_update_login,
4652: request_id = hz_utility_pub.request_id,
4653: program_application_id = hz_utility_pub.program_application_id,
4654: program_id = hz_utility_pub.program_id,
4655: program_update_date = sysdate
4656: WHERE cust_acct_site_id = p_from_id;
4657:
4650: last_updated_by = hz_utility_pub.user_id,
4651: last_update_login = hz_utility_pub.last_update_login,
4652: request_id = hz_utility_pub.request_id,
4653: program_application_id = hz_utility_pub.program_application_id,
4654: program_id = hz_utility_pub.program_id,
4655: program_update_date = sysdate
4656: WHERE cust_acct_site_id = p_from_id;
4657:
4658: END IF;
4680: x_to_id <> p_from_id) THEN
4681: UPDATE HZ_ORG_CONTACTS
4682: SET
4683: STATUS = 'M',
4684: last_update_date = hz_utility_pub.last_update_date,
4685: last_updated_by = hz_utility_pub.user_id,
4686: last_update_login = hz_utility_pub.last_update_login,
4687: request_id = hz_utility_pub.request_id,
4688: program_application_id = hz_utility_pub.program_application_id,
4681: UPDATE HZ_ORG_CONTACTS
4682: SET
4683: STATUS = 'M',
4684: last_update_date = hz_utility_pub.last_update_date,
4685: last_updated_by = hz_utility_pub.user_id,
4686: last_update_login = hz_utility_pub.last_update_login,
4687: request_id = hz_utility_pub.request_id,
4688: program_application_id = hz_utility_pub.program_application_id,
4689: program_id = hz_utility_pub.program_id,
4682: SET
4683: STATUS = 'M',
4684: last_update_date = hz_utility_pub.last_update_date,
4685: last_updated_by = hz_utility_pub.user_id,
4686: last_update_login = hz_utility_pub.last_update_login,
4687: request_id = hz_utility_pub.request_id,
4688: program_application_id = hz_utility_pub.program_application_id,
4689: program_id = hz_utility_pub.program_id,
4690: program_update_date = sysdate
4683: STATUS = 'M',
4684: last_update_date = hz_utility_pub.last_update_date,
4685: last_updated_by = hz_utility_pub.user_id,
4686: last_update_login = hz_utility_pub.last_update_login,
4687: request_id = hz_utility_pub.request_id,
4688: program_application_id = hz_utility_pub.program_application_id,
4689: program_id = hz_utility_pub.program_id,
4690: program_update_date = sysdate
4691: WHERE org_contact_id = p_from_id;
4684: last_update_date = hz_utility_pub.last_update_date,
4685: last_updated_by = hz_utility_pub.user_id,
4686: last_update_login = hz_utility_pub.last_update_login,
4687: request_id = hz_utility_pub.request_id,
4688: program_application_id = hz_utility_pub.program_application_id,
4689: program_id = hz_utility_pub.program_id,
4690: program_update_date = sysdate
4691: WHERE org_contact_id = p_from_id;
4692:
4685: last_updated_by = hz_utility_pub.user_id,
4686: last_update_login = hz_utility_pub.last_update_login,
4687: request_id = hz_utility_pub.request_id,
4688: program_application_id = hz_utility_pub.program_application_id,
4689: program_id = hz_utility_pub.program_id,
4690: program_update_date = sysdate
4691: WHERE org_contact_id = p_from_id;
4692:
4693: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE STAGED_FLAG='N' AND ENTITY='CONTACTS'
4716: ELSE
4717: UPDATE HZ_ORG_CONTACTS
4718: SET
4719: party_site_id = p_to_fk_id,
4720: last_update_date = hz_utility_pub.last_update_date,
4721: last_updated_by = hz_utility_pub.user_id,
4722: last_update_login = hz_utility_pub.last_update_login,
4723: request_id = hz_utility_pub.request_id,
4724: program_application_id = hz_utility_pub.program_application_id,
4717: UPDATE HZ_ORG_CONTACTS
4718: SET
4719: party_site_id = p_to_fk_id,
4720: last_update_date = hz_utility_pub.last_update_date,
4721: last_updated_by = hz_utility_pub.user_id,
4722: last_update_login = hz_utility_pub.last_update_login,
4723: request_id = hz_utility_pub.request_id,
4724: program_application_id = hz_utility_pub.program_application_id,
4725: program_id = hz_utility_pub.program_id,
4718: SET
4719: party_site_id = p_to_fk_id,
4720: last_update_date = hz_utility_pub.last_update_date,
4721: last_updated_by = hz_utility_pub.user_id,
4722: last_update_login = hz_utility_pub.last_update_login,
4723: request_id = hz_utility_pub.request_id,
4724: program_application_id = hz_utility_pub.program_application_id,
4725: program_id = hz_utility_pub.program_id,
4726: program_update_date = sysdate
4719: party_site_id = p_to_fk_id,
4720: last_update_date = hz_utility_pub.last_update_date,
4721: last_updated_by = hz_utility_pub.user_id,
4722: last_update_login = hz_utility_pub.last_update_login,
4723: request_id = hz_utility_pub.request_id,
4724: program_application_id = hz_utility_pub.program_application_id,
4725: program_id = hz_utility_pub.program_id,
4726: program_update_date = sysdate
4727: WHERE org_contact_id = p_from_id;
4720: last_update_date = hz_utility_pub.last_update_date,
4721: last_updated_by = hz_utility_pub.user_id,
4722: last_update_login = hz_utility_pub.last_update_login,
4723: request_id = hz_utility_pub.request_id,
4724: program_application_id = hz_utility_pub.program_application_id,
4725: program_id = hz_utility_pub.program_id,
4726: program_update_date = sysdate
4727: WHERE org_contact_id = p_from_id;
4728:
4721: last_updated_by = hz_utility_pub.user_id,
4722: last_update_login = hz_utility_pub.last_update_login,
4723: request_id = hz_utility_pub.request_id,
4724: program_application_id = hz_utility_pub.program_application_id,
4725: program_id = hz_utility_pub.program_id,
4726: program_update_date = sysdate
4727: WHERE org_contact_id = p_from_id;
4728:
4729: END IF;
4799: CLOSE c_merge_to_org_contact;
4800: UPDATE HZ_ORG_CONTACTS
4801: SET
4802: party_relationship_id = p_to_fk_id,
4803: last_update_date = hz_utility_pub.last_update_date,
4804: last_updated_by = hz_utility_pub.user_id,
4805: last_update_login = hz_utility_pub.last_update_login,
4806: request_id = hz_utility_pub.request_id,
4807: program_application_id = hz_utility_pub.program_application_id,
4800: UPDATE HZ_ORG_CONTACTS
4801: SET
4802: party_relationship_id = p_to_fk_id,
4803: last_update_date = hz_utility_pub.last_update_date,
4804: last_updated_by = hz_utility_pub.user_id,
4805: last_update_login = hz_utility_pub.last_update_login,
4806: request_id = hz_utility_pub.request_id,
4807: program_application_id = hz_utility_pub.program_application_id,
4808: program_id = hz_utility_pub.program_id,
4801: SET
4802: party_relationship_id = p_to_fk_id,
4803: last_update_date = hz_utility_pub.last_update_date,
4804: last_updated_by = hz_utility_pub.user_id,
4805: last_update_login = hz_utility_pub.last_update_login,
4806: request_id = hz_utility_pub.request_id,
4807: program_application_id = hz_utility_pub.program_application_id,
4808: program_id = hz_utility_pub.program_id,
4809: program_update_date = sysdate
4802: party_relationship_id = p_to_fk_id,
4803: last_update_date = hz_utility_pub.last_update_date,
4804: last_updated_by = hz_utility_pub.user_id,
4805: last_update_login = hz_utility_pub.last_update_login,
4806: request_id = hz_utility_pub.request_id,
4807: program_application_id = hz_utility_pub.program_application_id,
4808: program_id = hz_utility_pub.program_id,
4809: program_update_date = sysdate
4810: WHERE org_contact_id = p_from_id;
4803: last_update_date = hz_utility_pub.last_update_date,
4804: last_updated_by = hz_utility_pub.user_id,
4805: last_update_login = hz_utility_pub.last_update_login,
4806: request_id = hz_utility_pub.request_id,
4807: program_application_id = hz_utility_pub.program_application_id,
4808: program_id = hz_utility_pub.program_id,
4809: program_update_date = sysdate
4810: WHERE org_contact_id = p_from_id;
4811: ELSE
4804: last_updated_by = hz_utility_pub.user_id,
4805: last_update_login = hz_utility_pub.last_update_login,
4806: request_id = hz_utility_pub.request_id,
4807: program_application_id = hz_utility_pub.program_application_id,
4808: program_id = hz_utility_pub.program_id,
4809: program_update_date = sysdate
4810: WHERE org_contact_id = p_from_id;
4811: ELSE
4812: CLOSE c_merge_to_org_contact;
4853:
4854: UPDATE HZ_ORG_CONTACTS
4855: SET
4856: STATUS = 'M',
4857: last_update_date = hz_utility_pub.last_update_date,
4858: last_updated_by = hz_utility_pub.user_id,
4859: last_update_login = hz_utility_pub.last_update_login,
4860: request_id = hz_utility_pub.request_id,
4861: program_application_id = hz_utility_pub.program_application_id,
4854: UPDATE HZ_ORG_CONTACTS
4855: SET
4856: STATUS = 'M',
4857: last_update_date = hz_utility_pub.last_update_date,
4858: last_updated_by = hz_utility_pub.user_id,
4859: last_update_login = hz_utility_pub.last_update_login,
4860: request_id = hz_utility_pub.request_id,
4861: program_application_id = hz_utility_pub.program_application_id,
4862: program_id = hz_utility_pub.program_id,
4855: SET
4856: STATUS = 'M',
4857: last_update_date = hz_utility_pub.last_update_date,
4858: last_updated_by = hz_utility_pub.user_id,
4859: last_update_login = hz_utility_pub.last_update_login,
4860: request_id = hz_utility_pub.request_id,
4861: program_application_id = hz_utility_pub.program_application_id,
4862: program_id = hz_utility_pub.program_id,
4863: program_update_date = sysdate
4856: STATUS = 'M',
4857: last_update_date = hz_utility_pub.last_update_date,
4858: last_updated_by = hz_utility_pub.user_id,
4859: last_update_login = hz_utility_pub.last_update_login,
4860: request_id = hz_utility_pub.request_id,
4861: program_application_id = hz_utility_pub.program_application_id,
4862: program_id = hz_utility_pub.program_id,
4863: program_update_date = sysdate
4864: WHERE org_contact_id = p_from_id;
4857: last_update_date = hz_utility_pub.last_update_date,
4858: last_updated_by = hz_utility_pub.user_id,
4859: last_update_login = hz_utility_pub.last_update_login,
4860: request_id = hz_utility_pub.request_id,
4861: program_application_id = hz_utility_pub.program_application_id,
4862: program_id = hz_utility_pub.program_id,
4863: program_update_date = sysdate
4864: WHERE org_contact_id = p_from_id;
4865:
4858: last_updated_by = hz_utility_pub.user_id,
4859: last_update_login = hz_utility_pub.last_update_login,
4860: request_id = hz_utility_pub.request_id,
4861: program_application_id = hz_utility_pub.program_application_id,
4862: program_id = hz_utility_pub.program_id,
4863: program_update_date = sysdate
4864: WHERE org_contact_id = p_from_id;
4865:
4866: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE STAGED_FLAG='N' AND ENTITY='CONTACTS'
5159: OPEN c_to_party_reln;
5160: UPDATE HZ_RELATIONSHIPS
5161: SET
5162: party_id = l_from_party_id,
5163: last_update_date = hz_utility_pub.last_update_date,
5164: last_updated_by = hz_utility_pub.user_id,
5165: last_update_login = hz_utility_pub.last_update_login,
5166: request_id = hz_utility_pub.request_id,
5167: program_application_id = hz_utility_pub.program_application_id,
5160: UPDATE HZ_RELATIONSHIPS
5161: SET
5162: party_id = l_from_party_id,
5163: last_update_date = hz_utility_pub.last_update_date,
5164: last_updated_by = hz_utility_pub.user_id,
5165: last_update_login = hz_utility_pub.last_update_login,
5166: request_id = hz_utility_pub.request_id,
5167: program_application_id = hz_utility_pub.program_application_id,
5168: program_id = hz_utility_pub.program_id,
5161: SET
5162: party_id = l_from_party_id,
5163: last_update_date = hz_utility_pub.last_update_date,
5164: last_updated_by = hz_utility_pub.user_id,
5165: last_update_login = hz_utility_pub.last_update_login,
5166: request_id = hz_utility_pub.request_id,
5167: program_application_id = hz_utility_pub.program_application_id,
5168: program_id = hz_utility_pub.program_id,
5169: program_update_date = sysdate
5162: party_id = l_from_party_id,
5163: last_update_date = hz_utility_pub.last_update_date,
5164: last_updated_by = hz_utility_pub.user_id,
5165: last_update_login = hz_utility_pub.last_update_login,
5166: request_id = hz_utility_pub.request_id,
5167: program_application_id = hz_utility_pub.program_application_id,
5168: program_id = hz_utility_pub.program_id,
5169: program_update_date = sysdate
5170: WHERE relationship_id = x_to_id;
5163: last_update_date = hz_utility_pub.last_update_date,
5164: last_updated_by = hz_utility_pub.user_id,
5165: last_update_login = hz_utility_pub.last_update_login,
5166: request_id = hz_utility_pub.request_id,
5167: program_application_id = hz_utility_pub.program_application_id,
5168: program_id = hz_utility_pub.program_id,
5169: program_update_date = sysdate
5170: WHERE relationship_id = x_to_id;
5171: CLOSE c_to_party_reln;
5164: last_updated_by = hz_utility_pub.user_id,
5165: last_update_login = hz_utility_pub.last_update_login,
5166: request_id = hz_utility_pub.request_id,
5167: program_application_id = hz_utility_pub.program_application_id,
5168: program_id = hz_utility_pub.program_id,
5169: program_update_date = sysdate
5170: WHERE relationship_id = x_to_id;
5171: CLOSE c_to_party_reln;
5172: END IF;
5174: UPDATE HZ_RELATIONSHIPS
5175: SET
5176: STATUS = 'M',
5177: end_date = sysdate,
5178: last_update_date = hz_utility_pub.last_update_date,
5179: last_updated_by = hz_utility_pub.user_id,
5180: last_update_login = hz_utility_pub.last_update_login,
5181: request_id = hz_utility_pub.request_id,
5182: program_application_id = hz_utility_pub.program_application_id,
5175: SET
5176: STATUS = 'M',
5177: end_date = sysdate,
5178: last_update_date = hz_utility_pub.last_update_date,
5179: last_updated_by = hz_utility_pub.user_id,
5180: last_update_login = hz_utility_pub.last_update_login,
5181: request_id = hz_utility_pub.request_id,
5182: program_application_id = hz_utility_pub.program_application_id,
5183: program_id = hz_utility_pub.program_id,
5176: STATUS = 'M',
5177: end_date = sysdate,
5178: last_update_date = hz_utility_pub.last_update_date,
5179: last_updated_by = hz_utility_pub.user_id,
5180: last_update_login = hz_utility_pub.last_update_login,
5181: request_id = hz_utility_pub.request_id,
5182: program_application_id = hz_utility_pub.program_application_id,
5183: program_id = hz_utility_pub.program_id,
5184: program_update_date = sysdate
5177: end_date = sysdate,
5178: last_update_date = hz_utility_pub.last_update_date,
5179: last_updated_by = hz_utility_pub.user_id,
5180: last_update_login = hz_utility_pub.last_update_login,
5181: request_id = hz_utility_pub.request_id,
5182: program_application_id = hz_utility_pub.program_application_id,
5183: program_id = hz_utility_pub.program_id,
5184: program_update_date = sysdate
5185: WHERE relationship_id = p_from_id;
5178: last_update_date = hz_utility_pub.last_update_date,
5179: last_updated_by = hz_utility_pub.user_id,
5180: last_update_login = hz_utility_pub.last_update_login,
5181: request_id = hz_utility_pub.request_id,
5182: program_application_id = hz_utility_pub.program_application_id,
5183: program_id = hz_utility_pub.program_id,
5184: program_update_date = sysdate
5185: WHERE relationship_id = p_from_id;
5186:
5179: last_updated_by = hz_utility_pub.user_id,
5180: last_update_login = hz_utility_pub.last_update_login,
5181: request_id = hz_utility_pub.request_id,
5182: program_application_id = hz_utility_pub.program_application_id,
5183: program_id = hz_utility_pub.program_id,
5184: program_update_date = sysdate
5185: WHERE relationship_id = p_from_id;
5186:
5187: --4307667 merge usages with owner_table_name 'HZ_RELATIONSHIPS'
5206: open c_start_end_date;
5207: fetch c_start_end_date into from_start_date,from_end_date,from_cont_source,l_from_request_id, l_from_rel_status;
5208: close c_start_end_date;
5209:
5210: IF (l_from_request_id <> hz_utility_pub.request_id) THEN
5211:
5212: SELECT orig_system_type INTO from_cont_source_type --5404244
5213: FROM HZ_ORIG_SYSTEMS_B
5214: WHERE orig_system = from_cont_source;
5214: WHERE orig_system = from_cont_source;
5215: OPEN c_check_valid_merge(from_start_date, from_end_date, from_cont_source_type,from_cont_source);
5216: FETCH c_check_valid_merge INTO l_dup_reln_id, l_request_id, l_to_rel_status;
5217: IF ((c_check_valid_merge%FOUND) AND
5218: (l_request_id <> hz_utility_pub.request_id) AND
5219: (l_to_rel_status = 'A' OR (l_to_rel_status = 'I' AND l_from_rel_status = 'I'))
5220: AND (HZ_PARTY_MERGE.g_automerge_flag = 'N') ) THEN
5221: CLOSE c_check_valid_merge;
5222: FND_MESSAGE.SET_NAME('AR', 'HZ_RELN_TRANSFER_NOT_ALLOWED');
5243: SET
5244: object_id = p_to_fk_id,
5245: status = 'I',
5246: end_date = sysdate,
5247: last_update_date = hz_utility_pub.last_update_date,
5248: last_updated_by = hz_utility_pub.user_id,
5249: last_update_login = hz_utility_pub.last_update_login,
5250: request_id = hz_utility_pub.request_id,
5251: program_application_id = hz_utility_pub.program_application_id,
5244: object_id = p_to_fk_id,
5245: status = 'I',
5246: end_date = sysdate,
5247: last_update_date = hz_utility_pub.last_update_date,
5248: last_updated_by = hz_utility_pub.user_id,
5249: last_update_login = hz_utility_pub.last_update_login,
5250: request_id = hz_utility_pub.request_id,
5251: program_application_id = hz_utility_pub.program_application_id,
5252: program_id = hz_utility_pub.program_id,
5245: status = 'I',
5246: end_date = sysdate,
5247: last_update_date = hz_utility_pub.last_update_date,
5248: last_updated_by = hz_utility_pub.user_id,
5249: last_update_login = hz_utility_pub.last_update_login,
5250: request_id = hz_utility_pub.request_id,
5251: program_application_id = hz_utility_pub.program_application_id,
5252: program_id = hz_utility_pub.program_id,
5253: program_update_date = sysdate
5246: end_date = sysdate,
5247: last_update_date = hz_utility_pub.last_update_date,
5248: last_updated_by = hz_utility_pub.user_id,
5249: last_update_login = hz_utility_pub.last_update_login,
5250: request_id = hz_utility_pub.request_id,
5251: program_application_id = hz_utility_pub.program_application_id,
5252: program_id = hz_utility_pub.program_id,
5253: program_update_date = sysdate
5254: WHERE relationship_id = p_from_id
5247: last_update_date = hz_utility_pub.last_update_date,
5248: last_updated_by = hz_utility_pub.user_id,
5249: last_update_login = hz_utility_pub.last_update_login,
5250: request_id = hz_utility_pub.request_id,
5251: program_application_id = hz_utility_pub.program_application_id,
5252: program_id = hz_utility_pub.program_id,
5253: program_update_date = sysdate
5254: WHERE relationship_id = p_from_id
5255: AND DIRECTIONAL_FLAG = 'F'
5248: last_updated_by = hz_utility_pub.user_id,
5249: last_update_login = hz_utility_pub.last_update_login,
5250: request_id = hz_utility_pub.request_id,
5251: program_application_id = hz_utility_pub.program_application_id,
5252: program_id = hz_utility_pub.program_id,
5253: program_update_date = sysdate
5254: WHERE relationship_id = p_from_id
5255: AND DIRECTIONAL_FLAG = 'F'
5256: RETURNING subject_id, relationship_type, relationship_code,
5262: SET
5263: subject_id = p_to_fk_id,
5264: status = 'I',
5265: end_date = sysdate,
5266: last_update_date = hz_utility_pub.last_update_date,
5267: last_updated_by = hz_utility_pub.user_id,
5268: last_update_login = hz_utility_pub.last_update_login,
5269: request_id = hz_utility_pub.request_id,
5270: program_application_id = hz_utility_pub.program_application_id,
5263: subject_id = p_to_fk_id,
5264: status = 'I',
5265: end_date = sysdate,
5266: last_update_date = hz_utility_pub.last_update_date,
5267: last_updated_by = hz_utility_pub.user_id,
5268: last_update_login = hz_utility_pub.last_update_login,
5269: request_id = hz_utility_pub.request_id,
5270: program_application_id = hz_utility_pub.program_application_id,
5271: program_id = hz_utility_pub.program_id,
5264: status = 'I',
5265: end_date = sysdate,
5266: last_update_date = hz_utility_pub.last_update_date,
5267: last_updated_by = hz_utility_pub.user_id,
5268: last_update_login = hz_utility_pub.last_update_login,
5269: request_id = hz_utility_pub.request_id,
5270: program_application_id = hz_utility_pub.program_application_id,
5271: program_id = hz_utility_pub.program_id,
5272: program_update_date = sysdate
5265: end_date = sysdate,
5266: last_update_date = hz_utility_pub.last_update_date,
5267: last_updated_by = hz_utility_pub.user_id,
5268: last_update_login = hz_utility_pub.last_update_login,
5269: request_id = hz_utility_pub.request_id,
5270: program_application_id = hz_utility_pub.program_application_id,
5271: program_id = hz_utility_pub.program_id,
5272: program_update_date = sysdate
5273: WHERE relationship_id = p_from_id
5266: last_update_date = hz_utility_pub.last_update_date,
5267: last_updated_by = hz_utility_pub.user_id,
5268: last_update_login = hz_utility_pub.last_update_login,
5269: request_id = hz_utility_pub.request_id,
5270: program_application_id = hz_utility_pub.program_application_id,
5271: program_id = hz_utility_pub.program_id,
5272: program_update_date = sysdate
5273: WHERE relationship_id = p_from_id
5274: AND DIRECTIONAL_FLAG = 'B';
5267: last_updated_by = hz_utility_pub.user_id,
5268: last_update_login = hz_utility_pub.last_update_login,
5269: request_id = hz_utility_pub.request_id,
5270: program_application_id = hz_utility_pub.program_application_id,
5271: program_id = hz_utility_pub.program_id,
5272: program_update_date = sysdate
5273: WHERE relationship_id = p_from_id
5274: AND DIRECTIONAL_FLAG = 'B';
5275:
5345: ----End of DlProject Phase2--------------------
5346: UPDATE HZ_RELATIONSHIPS
5347: SET
5348: object_id = p_to_fk_id,
5349: last_update_date = hz_utility_pub.last_update_date,
5350: last_updated_by = hz_utility_pub.user_id,
5351: last_update_login = hz_utility_pub.last_update_login,
5352: request_id = hz_utility_pub.request_id,
5353: program_application_id = hz_utility_pub.program_application_id,
5346: UPDATE HZ_RELATIONSHIPS
5347: SET
5348: object_id = p_to_fk_id,
5349: last_update_date = hz_utility_pub.last_update_date,
5350: last_updated_by = hz_utility_pub.user_id,
5351: last_update_login = hz_utility_pub.last_update_login,
5352: request_id = hz_utility_pub.request_id,
5353: program_application_id = hz_utility_pub.program_application_id,
5354: program_id = hz_utility_pub.program_id,
5347: SET
5348: object_id = p_to_fk_id,
5349: last_update_date = hz_utility_pub.last_update_date,
5350: last_updated_by = hz_utility_pub.user_id,
5351: last_update_login = hz_utility_pub.last_update_login,
5352: request_id = hz_utility_pub.request_id,
5353: program_application_id = hz_utility_pub.program_application_id,
5354: program_id = hz_utility_pub.program_id,
5355: program_update_date = sysdate
5348: object_id = p_to_fk_id,
5349: last_update_date = hz_utility_pub.last_update_date,
5350: last_updated_by = hz_utility_pub.user_id,
5351: last_update_login = hz_utility_pub.last_update_login,
5352: request_id = hz_utility_pub.request_id,
5353: program_application_id = hz_utility_pub.program_application_id,
5354: program_id = hz_utility_pub.program_id,
5355: program_update_date = sysdate
5356: WHERE relationship_id = p_from_id
5349: last_update_date = hz_utility_pub.last_update_date,
5350: last_updated_by = hz_utility_pub.user_id,
5351: last_update_login = hz_utility_pub.last_update_login,
5352: request_id = hz_utility_pub.request_id,
5353: program_application_id = hz_utility_pub.program_application_id,
5354: program_id = hz_utility_pub.program_id,
5355: program_update_date = sysdate
5356: WHERE relationship_id = p_from_id
5357: AND DIRECTIONAL_FLAG = 'F'
5350: last_updated_by = hz_utility_pub.user_id,
5351: last_update_login = hz_utility_pub.last_update_login,
5352: request_id = hz_utility_pub.request_id,
5353: program_application_id = hz_utility_pub.program_application_id,
5354: program_id = hz_utility_pub.program_id,
5355: program_update_date = sysdate
5356: WHERE relationship_id = p_from_id
5357: AND DIRECTIONAL_FLAG = 'F'
5358: RETURNING subject_id, relationship_type, relationship_code,
5362:
5363: UPDATE HZ_RELATIONSHIPS
5364: SET
5365: subject_id = p_to_fk_id,
5366: last_update_date = hz_utility_pub.last_update_date,
5367: last_updated_by = hz_utility_pub.user_id,
5368: last_update_login = hz_utility_pub.last_update_login,
5369: request_id = hz_utility_pub.request_id,
5370: program_application_id = hz_utility_pub.program_application_id,
5363: UPDATE HZ_RELATIONSHIPS
5364: SET
5365: subject_id = p_to_fk_id,
5366: last_update_date = hz_utility_pub.last_update_date,
5367: last_updated_by = hz_utility_pub.user_id,
5368: last_update_login = hz_utility_pub.last_update_login,
5369: request_id = hz_utility_pub.request_id,
5370: program_application_id = hz_utility_pub.program_application_id,
5371: program_id = hz_utility_pub.program_id,
5364: SET
5365: subject_id = p_to_fk_id,
5366: last_update_date = hz_utility_pub.last_update_date,
5367: last_updated_by = hz_utility_pub.user_id,
5368: last_update_login = hz_utility_pub.last_update_login,
5369: request_id = hz_utility_pub.request_id,
5370: program_application_id = hz_utility_pub.program_application_id,
5371: program_id = hz_utility_pub.program_id,
5372: program_update_date = sysdate
5365: subject_id = p_to_fk_id,
5366: last_update_date = hz_utility_pub.last_update_date,
5367: last_updated_by = hz_utility_pub.user_id,
5368: last_update_login = hz_utility_pub.last_update_login,
5369: request_id = hz_utility_pub.request_id,
5370: program_application_id = hz_utility_pub.program_application_id,
5371: program_id = hz_utility_pub.program_id,
5372: program_update_date = sysdate
5373: WHERE relationship_id = p_from_id
5366: last_update_date = hz_utility_pub.last_update_date,
5367: last_updated_by = hz_utility_pub.user_id,
5368: last_update_login = hz_utility_pub.last_update_login,
5369: request_id = hz_utility_pub.request_id,
5370: program_application_id = hz_utility_pub.program_application_id,
5371: program_id = hz_utility_pub.program_id,
5372: program_update_date = sysdate
5373: WHERE relationship_id = p_from_id
5374: AND DIRECTIONAL_FLAG = 'B';
5367: last_updated_by = hz_utility_pub.user_id,
5368: last_update_login = hz_utility_pub.last_update_login,
5369: request_id = hz_utility_pub.request_id,
5370: program_application_id = hz_utility_pub.program_application_id,
5371: program_id = hz_utility_pub.program_id,
5372: program_update_date = sysdate
5373: WHERE relationship_id = p_from_id
5374: AND DIRECTIONAL_FLAG = 'B';
5375:
5401: UPDATE HZ_RELATIONSHIPS
5402: SET
5403: STATUS = 'I',
5404: END_DATE = sysdate,
5405: last_update_date = hz_utility_pub.last_update_date,
5406: last_updated_by = hz_utility_pub.user_id,
5407: last_update_login = hz_utility_pub.last_update_login,
5408: request_id = hz_utility_pub.request_id,
5409: program_application_id = hz_utility_pub.program_application_id,
5402: SET
5403: STATUS = 'I',
5404: END_DATE = sysdate,
5405: last_update_date = hz_utility_pub.last_update_date,
5406: last_updated_by = hz_utility_pub.user_id,
5407: last_update_login = hz_utility_pub.last_update_login,
5408: request_id = hz_utility_pub.request_id,
5409: program_application_id = hz_utility_pub.program_application_id,
5410: program_id = hz_utility_pub.program_id,
5403: STATUS = 'I',
5404: END_DATE = sysdate,
5405: last_update_date = hz_utility_pub.last_update_date,
5406: last_updated_by = hz_utility_pub.user_id,
5407: last_update_login = hz_utility_pub.last_update_login,
5408: request_id = hz_utility_pub.request_id,
5409: program_application_id = hz_utility_pub.program_application_id,
5410: program_id = hz_utility_pub.program_id,
5411: program_update_date = sysdate
5404: END_DATE = sysdate,
5405: last_update_date = hz_utility_pub.last_update_date,
5406: last_updated_by = hz_utility_pub.user_id,
5407: last_update_login = hz_utility_pub.last_update_login,
5408: request_id = hz_utility_pub.request_id,
5409: program_application_id = hz_utility_pub.program_application_id,
5410: program_id = hz_utility_pub.program_id,
5411: program_update_date = sysdate
5412: WHERE relationship_id = p_from_id;
5405: last_update_date = hz_utility_pub.last_update_date,
5406: last_updated_by = hz_utility_pub.user_id,
5407: last_update_login = hz_utility_pub.last_update_login,
5408: request_id = hz_utility_pub.request_id,
5409: program_application_id = hz_utility_pub.program_application_id,
5410: program_id = hz_utility_pub.program_id,
5411: program_update_date = sysdate
5412: WHERE relationship_id = p_from_id;
5413: ---Start of Bug:3880218----
5406: last_updated_by = hz_utility_pub.user_id,
5407: last_update_login = hz_utility_pub.last_update_login,
5408: request_id = hz_utility_pub.request_id,
5409: program_application_id = hz_utility_pub.program_application_id,
5410: program_id = hz_utility_pub.program_id,
5411: program_update_date = sysdate
5412: WHERE relationship_id = p_from_id;
5413: ---Start of Bug:3880218----
5414: IF l_rel_party_id is not null THEN
5413: ---Start of Bug:3880218----
5414: IF l_rel_party_id is not null THEN
5415: UPDATE HZ_PARTIES
5416: SET STATUS = 'I',
5417: last_update_date = hz_utility_pub.last_update_date,
5418: last_updated_by = hz_utility_pub.user_id,
5419: last_update_login = hz_utility_pub.last_update_login,
5420: request_id = hz_utility_pub.request_id,
5421: program_application_id = hz_utility_pub.program_application_id,
5414: IF l_rel_party_id is not null THEN
5415: UPDATE HZ_PARTIES
5416: SET STATUS = 'I',
5417: last_update_date = hz_utility_pub.last_update_date,
5418: last_updated_by = hz_utility_pub.user_id,
5419: last_update_login = hz_utility_pub.last_update_login,
5420: request_id = hz_utility_pub.request_id,
5421: program_application_id = hz_utility_pub.program_application_id,
5422: program_id = hz_utility_pub.program_id,
5415: UPDATE HZ_PARTIES
5416: SET STATUS = 'I',
5417: last_update_date = hz_utility_pub.last_update_date,
5418: last_updated_by = hz_utility_pub.user_id,
5419: last_update_login = hz_utility_pub.last_update_login,
5420: request_id = hz_utility_pub.request_id,
5421: program_application_id = hz_utility_pub.program_application_id,
5422: program_id = hz_utility_pub.program_id,
5423: program_update_date = sysdate
5416: SET STATUS = 'I',
5417: last_update_date = hz_utility_pub.last_update_date,
5418: last_updated_by = hz_utility_pub.user_id,
5419: last_update_login = hz_utility_pub.last_update_login,
5420: request_id = hz_utility_pub.request_id,
5421: program_application_id = hz_utility_pub.program_application_id,
5422: program_id = hz_utility_pub.program_id,
5423: program_update_date = sysdate
5424: WHERE PARTY_ID = l_rel_party_id;
5417: last_update_date = hz_utility_pub.last_update_date,
5418: last_updated_by = hz_utility_pub.user_id,
5419: last_update_login = hz_utility_pub.last_update_login,
5420: request_id = hz_utility_pub.request_id,
5421: program_application_id = hz_utility_pub.program_application_id,
5422: program_id = hz_utility_pub.program_id,
5423: program_update_date = sysdate
5424: WHERE PARTY_ID = l_rel_party_id;
5425: END IF;
5418: last_updated_by = hz_utility_pub.user_id,
5419: last_update_login = hz_utility_pub.last_update_login,
5420: request_id = hz_utility_pub.request_id,
5421: program_application_id = hz_utility_pub.program_application_id,
5422: program_id = hz_utility_pub.program_id,
5423: program_update_date = sysdate
5424: WHERE PARTY_ID = l_rel_party_id;
5425: END IF;
5426: ----End of Bug:3880218----
5437: --bug 4867151--start
5438: IF l_rel_party_id is not null THEN
5439: UPDATE HZ_PARTIES
5440: SET STATUS = 'M',
5441: last_update_date = hz_utility_pub.last_update_date,
5442: last_updated_by = hz_utility_pub.user_id,
5443: last_update_login = hz_utility_pub.last_update_login,
5444: request_id = hz_utility_pub.request_id,
5445: program_application_id = hz_utility_pub.program_application_id,
5438: IF l_rel_party_id is not null THEN
5439: UPDATE HZ_PARTIES
5440: SET STATUS = 'M',
5441: last_update_date = hz_utility_pub.last_update_date,
5442: last_updated_by = hz_utility_pub.user_id,
5443: last_update_login = hz_utility_pub.last_update_login,
5444: request_id = hz_utility_pub.request_id,
5445: program_application_id = hz_utility_pub.program_application_id,
5446: program_id = hz_utility_pub.program_id,
5439: UPDATE HZ_PARTIES
5440: SET STATUS = 'M',
5441: last_update_date = hz_utility_pub.last_update_date,
5442: last_updated_by = hz_utility_pub.user_id,
5443: last_update_login = hz_utility_pub.last_update_login,
5444: request_id = hz_utility_pub.request_id,
5445: program_application_id = hz_utility_pub.program_application_id,
5446: program_id = hz_utility_pub.program_id,
5447: program_update_date = sysdate
5440: SET STATUS = 'M',
5441: last_update_date = hz_utility_pub.last_update_date,
5442: last_updated_by = hz_utility_pub.user_id,
5443: last_update_login = hz_utility_pub.last_update_login,
5444: request_id = hz_utility_pub.request_id,
5445: program_application_id = hz_utility_pub.program_application_id,
5446: program_id = hz_utility_pub.program_id,
5447: program_update_date = sysdate
5448: WHERE PARTY_ID in (select party_id from hz_relationships where subject_id=p_to_fk_id
5441: last_update_date = hz_utility_pub.last_update_date,
5442: last_updated_by = hz_utility_pub.user_id,
5443: last_update_login = hz_utility_pub.last_update_login,
5444: request_id = hz_utility_pub.request_id,
5445: program_application_id = hz_utility_pub.program_application_id,
5446: program_id = hz_utility_pub.program_id,
5447: program_update_date = sysdate
5448: WHERE PARTY_ID in (select party_id from hz_relationships where subject_id=p_to_fk_id
5449: and object_id=p_to_fk_id and relationship_id <>p_from_id and status='A'
5442: last_updated_by = hz_utility_pub.user_id,
5443: last_update_login = hz_utility_pub.last_update_login,
5444: request_id = hz_utility_pub.request_id,
5445: program_application_id = hz_utility_pub.program_application_id,
5446: program_id = hz_utility_pub.program_id,
5447: program_update_date = sysdate
5448: WHERE PARTY_ID in (select party_id from hz_relationships where subject_id=p_to_fk_id
5449: and object_id=p_to_fk_id and relationship_id <>p_from_id and status='A'
5450: AND ((start_date between from_start_date and from_end_date)
5455: UPDATE HZ_RELATIONSHIPS
5456: SET
5457: STATUS = 'M',
5458: END_DATE = sysdate,
5459: last_update_date = hz_utility_pub.last_update_date,
5460: last_updated_by = hz_utility_pub.user_id,
5461: last_update_login = hz_utility_pub.last_update_login,
5462: request_id = hz_utility_pub.request_id,
5463: program_application_id = hz_utility_pub.program_application_id,
5456: SET
5457: STATUS = 'M',
5458: END_DATE = sysdate,
5459: last_update_date = hz_utility_pub.last_update_date,
5460: last_updated_by = hz_utility_pub.user_id,
5461: last_update_login = hz_utility_pub.last_update_login,
5462: request_id = hz_utility_pub.request_id,
5463: program_application_id = hz_utility_pub.program_application_id,
5464: program_id = hz_utility_pub.program_id,
5457: STATUS = 'M',
5458: END_DATE = sysdate,
5459: last_update_date = hz_utility_pub.last_update_date,
5460: last_updated_by = hz_utility_pub.user_id,
5461: last_update_login = hz_utility_pub.last_update_login,
5462: request_id = hz_utility_pub.request_id,
5463: program_application_id = hz_utility_pub.program_application_id,
5464: program_id = hz_utility_pub.program_id,
5465: program_update_date = sysdate
5458: END_DATE = sysdate,
5459: last_update_date = hz_utility_pub.last_update_date,
5460: last_updated_by = hz_utility_pub.user_id,
5461: last_update_login = hz_utility_pub.last_update_login,
5462: request_id = hz_utility_pub.request_id,
5463: program_application_id = hz_utility_pub.program_application_id,
5464: program_id = hz_utility_pub.program_id,
5465: program_update_date = sysdate
5466: WHERE relationship_id in (select relationship_id from hz_relationships where subject_id=p_to_fk_id
5459: last_update_date = hz_utility_pub.last_update_date,
5460: last_updated_by = hz_utility_pub.user_id,
5461: last_update_login = hz_utility_pub.last_update_login,
5462: request_id = hz_utility_pub.request_id,
5463: program_application_id = hz_utility_pub.program_application_id,
5464: program_id = hz_utility_pub.program_id,
5465: program_update_date = sysdate
5466: WHERE relationship_id in (select relationship_id from hz_relationships where subject_id=p_to_fk_id
5467: and object_id=p_to_fk_id and relationship_id <>p_from_id and status='A'
5460: last_updated_by = hz_utility_pub.user_id,
5461: last_update_login = hz_utility_pub.last_update_login,
5462: request_id = hz_utility_pub.request_id,
5463: program_application_id = hz_utility_pub.program_application_id,
5464: program_id = hz_utility_pub.program_id,
5465: program_update_date = sysdate
5466: WHERE relationship_id in (select relationship_id from hz_relationships where subject_id=p_to_fk_id
5467: and object_id=p_to_fk_id and relationship_id <>p_from_id and status='A'
5468: AND ((start_date between from_start_date and from_end_date)
5618: OPEN c_to_party_reln;
5619: UPDATE HZ_RELATIONSHIPS
5620: SET
5621: party_id = l_from_party_id,
5622: last_update_date = hz_utility_pub.last_update_date,
5623: last_updated_by = hz_utility_pub.user_id,
5624: last_update_login = hz_utility_pub.last_update_login,
5625: request_id = hz_utility_pub.request_id,
5626: program_application_id = hz_utility_pub.program_application_id,
5619: UPDATE HZ_RELATIONSHIPS
5620: SET
5621: party_id = l_from_party_id,
5622: last_update_date = hz_utility_pub.last_update_date,
5623: last_updated_by = hz_utility_pub.user_id,
5624: last_update_login = hz_utility_pub.last_update_login,
5625: request_id = hz_utility_pub.request_id,
5626: program_application_id = hz_utility_pub.program_application_id,
5627: program_id = hz_utility_pub.program_id,
5620: SET
5621: party_id = l_from_party_id,
5622: last_update_date = hz_utility_pub.last_update_date,
5623: last_updated_by = hz_utility_pub.user_id,
5624: last_update_login = hz_utility_pub.last_update_login,
5625: request_id = hz_utility_pub.request_id,
5626: program_application_id = hz_utility_pub.program_application_id,
5627: program_id = hz_utility_pub.program_id,
5628: program_update_date = sysdate
5621: party_id = l_from_party_id,
5622: last_update_date = hz_utility_pub.last_update_date,
5623: last_updated_by = hz_utility_pub.user_id,
5624: last_update_login = hz_utility_pub.last_update_login,
5625: request_id = hz_utility_pub.request_id,
5626: program_application_id = hz_utility_pub.program_application_id,
5627: program_id = hz_utility_pub.program_id,
5628: program_update_date = sysdate
5629: WHERE relationship_id = x_to_id;
5622: last_update_date = hz_utility_pub.last_update_date,
5623: last_updated_by = hz_utility_pub.user_id,
5624: last_update_login = hz_utility_pub.last_update_login,
5625: request_id = hz_utility_pub.request_id,
5626: program_application_id = hz_utility_pub.program_application_id,
5627: program_id = hz_utility_pub.program_id,
5628: program_update_date = sysdate
5629: WHERE relationship_id = x_to_id;
5630: CLOSE c_to_party_reln;
5623: last_updated_by = hz_utility_pub.user_id,
5624: last_update_login = hz_utility_pub.last_update_login,
5625: request_id = hz_utility_pub.request_id,
5626: program_application_id = hz_utility_pub.program_application_id,
5627: program_id = hz_utility_pub.program_id,
5628: program_update_date = sysdate
5629: WHERE relationship_id = x_to_id;
5630: CLOSE c_to_party_reln;
5631: END IF;
5633: UPDATE HZ_RELATIONSHIPS
5634: SET
5635: STATUS = 'M',
5636: end_date = sysdate,
5637: last_update_date = hz_utility_pub.last_update_date,
5638: last_updated_by = hz_utility_pub.user_id,
5639: last_update_login = hz_utility_pub.last_update_login,
5640: request_id = hz_utility_pub.request_id,
5641: program_application_id = hz_utility_pub.program_application_id,
5634: SET
5635: STATUS = 'M',
5636: end_date = sysdate,
5637: last_update_date = hz_utility_pub.last_update_date,
5638: last_updated_by = hz_utility_pub.user_id,
5639: last_update_login = hz_utility_pub.last_update_login,
5640: request_id = hz_utility_pub.request_id,
5641: program_application_id = hz_utility_pub.program_application_id,
5642: program_id = hz_utility_pub.program_id,
5635: STATUS = 'M',
5636: end_date = sysdate,
5637: last_update_date = hz_utility_pub.last_update_date,
5638: last_updated_by = hz_utility_pub.user_id,
5639: last_update_login = hz_utility_pub.last_update_login,
5640: request_id = hz_utility_pub.request_id,
5641: program_application_id = hz_utility_pub.program_application_id,
5642: program_id = hz_utility_pub.program_id,
5643: program_update_date = sysdate
5636: end_date = sysdate,
5637: last_update_date = hz_utility_pub.last_update_date,
5638: last_updated_by = hz_utility_pub.user_id,
5639: last_update_login = hz_utility_pub.last_update_login,
5640: request_id = hz_utility_pub.request_id,
5641: program_application_id = hz_utility_pub.program_application_id,
5642: program_id = hz_utility_pub.program_id,
5643: program_update_date = sysdate
5644: WHERE relationship_id = p_from_id;
5637: last_update_date = hz_utility_pub.last_update_date,
5638: last_updated_by = hz_utility_pub.user_id,
5639: last_update_login = hz_utility_pub.last_update_login,
5640: request_id = hz_utility_pub.request_id,
5641: program_application_id = hz_utility_pub.program_application_id,
5642: program_id = hz_utility_pub.program_id,
5643: program_update_date = sysdate
5644: WHERE relationship_id = p_from_id;
5645:
5638: last_updated_by = hz_utility_pub.user_id,
5639: last_update_login = hz_utility_pub.last_update_login,
5640: request_id = hz_utility_pub.request_id,
5641: program_application_id = hz_utility_pub.program_application_id,
5642: program_id = hz_utility_pub.program_id,
5643: program_update_date = sysdate
5644: WHERE relationship_id = p_from_id;
5645:
5646:
5666: open c_start_end_date;
5667: fetch c_start_end_date into from_start_date,from_end_date,from_cont_source, l_from_request_id, l_from_rel_status;
5668: close c_start_end_date;
5669:
5670: IF (l_from_request_id <> hz_utility_pub.request_id) THEN
5671:
5672: SELECT orig_system_type INTO from_cont_source_type --5404244
5673: FROM HZ_ORIG_SYSTEMS_B
5674: WHERE orig_system = from_cont_source;
5676: OPEN c_check_valid_merge(from_start_date,from_end_date,from_cont_source_type,from_cont_source);
5677:
5678: FETCH c_check_valid_merge INTO l_dup_reln_id, l_request_id, l_to_rel_status;
5679: IF ((c_check_valid_merge%FOUND) AND
5680: (l_request_id <> hz_utility_pub.request_id) AND
5681: (l_to_rel_status = 'A' OR (l_to_rel_status = 'I' AND l_from_rel_status = 'I'))
5682: AND (HZ_PARTY_MERGE.g_automerge_flag = 'N')) THEN
5683:
5684: FND_MESSAGE.SET_NAME('AR', 'HZ_RELN_TRANSFER_NOT_ALLOWED');
5705: SET
5706: subject_id = p_to_fk_id,
5707: status = 'I',
5708: end_date = sysdate,
5709: last_update_date = hz_utility_pub.last_update_date,
5710: last_updated_by = hz_utility_pub.user_id,
5711: last_update_login = hz_utility_pub.last_update_login,
5712: request_id = hz_utility_pub.request_id,
5713: program_application_id = hz_utility_pub.program_application_id,
5706: subject_id = p_to_fk_id,
5707: status = 'I',
5708: end_date = sysdate,
5709: last_update_date = hz_utility_pub.last_update_date,
5710: last_updated_by = hz_utility_pub.user_id,
5711: last_update_login = hz_utility_pub.last_update_login,
5712: request_id = hz_utility_pub.request_id,
5713: program_application_id = hz_utility_pub.program_application_id,
5714: program_id = hz_utility_pub.program_id,
5707: status = 'I',
5708: end_date = sysdate,
5709: last_update_date = hz_utility_pub.last_update_date,
5710: last_updated_by = hz_utility_pub.user_id,
5711: last_update_login = hz_utility_pub.last_update_login,
5712: request_id = hz_utility_pub.request_id,
5713: program_application_id = hz_utility_pub.program_application_id,
5714: program_id = hz_utility_pub.program_id,
5715: program_update_date = sysdate
5708: end_date = sysdate,
5709: last_update_date = hz_utility_pub.last_update_date,
5710: last_updated_by = hz_utility_pub.user_id,
5711: last_update_login = hz_utility_pub.last_update_login,
5712: request_id = hz_utility_pub.request_id,
5713: program_application_id = hz_utility_pub.program_application_id,
5714: program_id = hz_utility_pub.program_id,
5715: program_update_date = sysdate
5716: WHERE relationship_id = p_from_id
5709: last_update_date = hz_utility_pub.last_update_date,
5710: last_updated_by = hz_utility_pub.user_id,
5711: last_update_login = hz_utility_pub.last_update_login,
5712: request_id = hz_utility_pub.request_id,
5713: program_application_id = hz_utility_pub.program_application_id,
5714: program_id = hz_utility_pub.program_id,
5715: program_update_date = sysdate
5716: WHERE relationship_id = p_from_id
5717: AND DIRECTIONAL_FLAG = 'F'
5710: last_updated_by = hz_utility_pub.user_id,
5711: last_update_login = hz_utility_pub.last_update_login,
5712: request_id = hz_utility_pub.request_id,
5713: program_application_id = hz_utility_pub.program_application_id,
5714: program_id = hz_utility_pub.program_id,
5715: program_update_date = sysdate
5716: WHERE relationship_id = p_from_id
5717: AND DIRECTIONAL_FLAG = 'F'
5718: RETURNING object_id, relationship_type, relationship_code ,
5724: SET
5725: object_id = p_to_fk_id,
5726: status = 'I',
5727: end_date = sysdate,
5728: last_update_date = hz_utility_pub.last_update_date,
5729: last_updated_by = hz_utility_pub.user_id,
5730: last_update_login = hz_utility_pub.last_update_login,
5731: request_id = hz_utility_pub.request_id,
5732: program_application_id = hz_utility_pub.program_application_id,
5725: object_id = p_to_fk_id,
5726: status = 'I',
5727: end_date = sysdate,
5728: last_update_date = hz_utility_pub.last_update_date,
5729: last_updated_by = hz_utility_pub.user_id,
5730: last_update_login = hz_utility_pub.last_update_login,
5731: request_id = hz_utility_pub.request_id,
5732: program_application_id = hz_utility_pub.program_application_id,
5733: program_id = hz_utility_pub.program_id,
5726: status = 'I',
5727: end_date = sysdate,
5728: last_update_date = hz_utility_pub.last_update_date,
5729: last_updated_by = hz_utility_pub.user_id,
5730: last_update_login = hz_utility_pub.last_update_login,
5731: request_id = hz_utility_pub.request_id,
5732: program_application_id = hz_utility_pub.program_application_id,
5733: program_id = hz_utility_pub.program_id,
5734: program_update_date = sysdate
5727: end_date = sysdate,
5728: last_update_date = hz_utility_pub.last_update_date,
5729: last_updated_by = hz_utility_pub.user_id,
5730: last_update_login = hz_utility_pub.last_update_login,
5731: request_id = hz_utility_pub.request_id,
5732: program_application_id = hz_utility_pub.program_application_id,
5733: program_id = hz_utility_pub.program_id,
5734: program_update_date = sysdate
5735: WHERE relationship_id = p_from_id
5728: last_update_date = hz_utility_pub.last_update_date,
5729: last_updated_by = hz_utility_pub.user_id,
5730: last_update_login = hz_utility_pub.last_update_login,
5731: request_id = hz_utility_pub.request_id,
5732: program_application_id = hz_utility_pub.program_application_id,
5733: program_id = hz_utility_pub.program_id,
5734: program_update_date = sysdate
5735: WHERE relationship_id = p_from_id
5736: AND DIRECTIONAL_FLAG = 'B';
5729: last_updated_by = hz_utility_pub.user_id,
5730: last_update_login = hz_utility_pub.last_update_login,
5731: request_id = hz_utility_pub.request_id,
5732: program_application_id = hz_utility_pub.program_application_id,
5733: program_id = hz_utility_pub.program_id,
5734: program_update_date = sysdate
5735: WHERE relationship_id = p_from_id
5736: AND DIRECTIONAL_FLAG = 'B';
5737:
5804:
5805: UPDATE HZ_RELATIONSHIPS
5806: SET
5807: subject_id = p_to_fk_id,
5808: last_update_date = hz_utility_pub.last_update_date,
5809: last_updated_by = hz_utility_pub.user_id,
5810: last_update_login = hz_utility_pub.last_update_login,
5811: request_id = hz_utility_pub.request_id,
5812: program_application_id = hz_utility_pub.program_application_id,
5805: UPDATE HZ_RELATIONSHIPS
5806: SET
5807: subject_id = p_to_fk_id,
5808: last_update_date = hz_utility_pub.last_update_date,
5809: last_updated_by = hz_utility_pub.user_id,
5810: last_update_login = hz_utility_pub.last_update_login,
5811: request_id = hz_utility_pub.request_id,
5812: program_application_id = hz_utility_pub.program_application_id,
5813: program_id = hz_utility_pub.program_id,
5806: SET
5807: subject_id = p_to_fk_id,
5808: last_update_date = hz_utility_pub.last_update_date,
5809: last_updated_by = hz_utility_pub.user_id,
5810: last_update_login = hz_utility_pub.last_update_login,
5811: request_id = hz_utility_pub.request_id,
5812: program_application_id = hz_utility_pub.program_application_id,
5813: program_id = hz_utility_pub.program_id,
5814: program_update_date = sysdate
5807: subject_id = p_to_fk_id,
5808: last_update_date = hz_utility_pub.last_update_date,
5809: last_updated_by = hz_utility_pub.user_id,
5810: last_update_login = hz_utility_pub.last_update_login,
5811: request_id = hz_utility_pub.request_id,
5812: program_application_id = hz_utility_pub.program_application_id,
5813: program_id = hz_utility_pub.program_id,
5814: program_update_date = sysdate
5815: WHERE relationship_id = p_from_id
5808: last_update_date = hz_utility_pub.last_update_date,
5809: last_updated_by = hz_utility_pub.user_id,
5810: last_update_login = hz_utility_pub.last_update_login,
5811: request_id = hz_utility_pub.request_id,
5812: program_application_id = hz_utility_pub.program_application_id,
5813: program_id = hz_utility_pub.program_id,
5814: program_update_date = sysdate
5815: WHERE relationship_id = p_from_id
5816: AND DIRECTIONAL_FLAG = 'F'
5809: last_updated_by = hz_utility_pub.user_id,
5810: last_update_login = hz_utility_pub.last_update_login,
5811: request_id = hz_utility_pub.request_id,
5812: program_application_id = hz_utility_pub.program_application_id,
5813: program_id = hz_utility_pub.program_id,
5814: program_update_date = sysdate
5815: WHERE relationship_id = p_from_id
5816: AND DIRECTIONAL_FLAG = 'F'
5817: RETURNING object_id, relationship_type, relationship_code ,
5821:
5822: UPDATE HZ_RELATIONSHIPS
5823: SET
5824: object_id = p_to_fk_id,
5825: last_update_date = hz_utility_pub.last_update_date,
5826: last_updated_by = hz_utility_pub.user_id,
5827: last_update_login = hz_utility_pub.last_update_login,
5828: request_id = hz_utility_pub.request_id,
5829: program_application_id = hz_utility_pub.program_application_id,
5822: UPDATE HZ_RELATIONSHIPS
5823: SET
5824: object_id = p_to_fk_id,
5825: last_update_date = hz_utility_pub.last_update_date,
5826: last_updated_by = hz_utility_pub.user_id,
5827: last_update_login = hz_utility_pub.last_update_login,
5828: request_id = hz_utility_pub.request_id,
5829: program_application_id = hz_utility_pub.program_application_id,
5830: program_id = hz_utility_pub.program_id,
5823: SET
5824: object_id = p_to_fk_id,
5825: last_update_date = hz_utility_pub.last_update_date,
5826: last_updated_by = hz_utility_pub.user_id,
5827: last_update_login = hz_utility_pub.last_update_login,
5828: request_id = hz_utility_pub.request_id,
5829: program_application_id = hz_utility_pub.program_application_id,
5830: program_id = hz_utility_pub.program_id,
5831: program_update_date = sysdate
5824: object_id = p_to_fk_id,
5825: last_update_date = hz_utility_pub.last_update_date,
5826: last_updated_by = hz_utility_pub.user_id,
5827: last_update_login = hz_utility_pub.last_update_login,
5828: request_id = hz_utility_pub.request_id,
5829: program_application_id = hz_utility_pub.program_application_id,
5830: program_id = hz_utility_pub.program_id,
5831: program_update_date = sysdate
5832: WHERE relationship_id = p_from_id
5825: last_update_date = hz_utility_pub.last_update_date,
5826: last_updated_by = hz_utility_pub.user_id,
5827: last_update_login = hz_utility_pub.last_update_login,
5828: request_id = hz_utility_pub.request_id,
5829: program_application_id = hz_utility_pub.program_application_id,
5830: program_id = hz_utility_pub.program_id,
5831: program_update_date = sysdate
5832: WHERE relationship_id = p_from_id
5833: AND DIRECTIONAL_FLAG = 'B';
5826: last_updated_by = hz_utility_pub.user_id,
5827: last_update_login = hz_utility_pub.last_update_login,
5828: request_id = hz_utility_pub.request_id,
5829: program_application_id = hz_utility_pub.program_application_id,
5830: program_id = hz_utility_pub.program_id,
5831: program_update_date = sysdate
5832: WHERE relationship_id = p_from_id
5833: AND DIRECTIONAL_FLAG = 'B';
5834:
5860: UPDATE HZ_RELATIONSHIPS
5861: SET
5862: STATUS = 'I',
5863: END_DATE = sysdate,
5864: last_update_date = hz_utility_pub.last_update_date,
5865: last_updated_by = hz_utility_pub.user_id,
5866: last_update_login = hz_utility_pub.last_update_login,
5867: request_id = hz_utility_pub.request_id,
5868: program_application_id = hz_utility_pub.program_application_id,
5861: SET
5862: STATUS = 'I',
5863: END_DATE = sysdate,
5864: last_update_date = hz_utility_pub.last_update_date,
5865: last_updated_by = hz_utility_pub.user_id,
5866: last_update_login = hz_utility_pub.last_update_login,
5867: request_id = hz_utility_pub.request_id,
5868: program_application_id = hz_utility_pub.program_application_id,
5869: program_id = hz_utility_pub.program_id,
5862: STATUS = 'I',
5863: END_DATE = sysdate,
5864: last_update_date = hz_utility_pub.last_update_date,
5865: last_updated_by = hz_utility_pub.user_id,
5866: last_update_login = hz_utility_pub.last_update_login,
5867: request_id = hz_utility_pub.request_id,
5868: program_application_id = hz_utility_pub.program_application_id,
5869: program_id = hz_utility_pub.program_id,
5870: program_update_date = sysdate
5863: END_DATE = sysdate,
5864: last_update_date = hz_utility_pub.last_update_date,
5865: last_updated_by = hz_utility_pub.user_id,
5866: last_update_login = hz_utility_pub.last_update_login,
5867: request_id = hz_utility_pub.request_id,
5868: program_application_id = hz_utility_pub.program_application_id,
5869: program_id = hz_utility_pub.program_id,
5870: program_update_date = sysdate
5871: WHERE relationship_id = p_from_id;
5864: last_update_date = hz_utility_pub.last_update_date,
5865: last_updated_by = hz_utility_pub.user_id,
5866: last_update_login = hz_utility_pub.last_update_login,
5867: request_id = hz_utility_pub.request_id,
5868: program_application_id = hz_utility_pub.program_application_id,
5869: program_id = hz_utility_pub.program_id,
5870: program_update_date = sysdate
5871: WHERE relationship_id = p_from_id;
5872:
5865: last_updated_by = hz_utility_pub.user_id,
5866: last_update_login = hz_utility_pub.last_update_login,
5867: request_id = hz_utility_pub.request_id,
5868: program_application_id = hz_utility_pub.program_application_id,
5869: program_id = hz_utility_pub.program_id,
5870: program_update_date = sysdate
5871: WHERE relationship_id = p_from_id;
5872:
5873: ---Start of Bug:3880218----
5873: ---Start of Bug:3880218----
5874: IF l_rel_party_id is not null THEN
5875: UPDATE HZ_PARTIES
5876: SET STATUS = 'I',
5877: last_update_date = hz_utility_pub.last_update_date,
5878: last_updated_by = hz_utility_pub.user_id,
5879: last_update_login = hz_utility_pub.last_update_login,
5880: request_id = hz_utility_pub.request_id,
5881: program_application_id = hz_utility_pub.program_application_id,
5874: IF l_rel_party_id is not null THEN
5875: UPDATE HZ_PARTIES
5876: SET STATUS = 'I',
5877: last_update_date = hz_utility_pub.last_update_date,
5878: last_updated_by = hz_utility_pub.user_id,
5879: last_update_login = hz_utility_pub.last_update_login,
5880: request_id = hz_utility_pub.request_id,
5881: program_application_id = hz_utility_pub.program_application_id,
5882: program_id = hz_utility_pub.program_id,
5875: UPDATE HZ_PARTIES
5876: SET STATUS = 'I',
5877: last_update_date = hz_utility_pub.last_update_date,
5878: last_updated_by = hz_utility_pub.user_id,
5879: last_update_login = hz_utility_pub.last_update_login,
5880: request_id = hz_utility_pub.request_id,
5881: program_application_id = hz_utility_pub.program_application_id,
5882: program_id = hz_utility_pub.program_id,
5883: program_update_date = sysdate
5876: SET STATUS = 'I',
5877: last_update_date = hz_utility_pub.last_update_date,
5878: last_updated_by = hz_utility_pub.user_id,
5879: last_update_login = hz_utility_pub.last_update_login,
5880: request_id = hz_utility_pub.request_id,
5881: program_application_id = hz_utility_pub.program_application_id,
5882: program_id = hz_utility_pub.program_id,
5883: program_update_date = sysdate
5884: WHERE PARTY_ID = l_rel_party_id;
5877: last_update_date = hz_utility_pub.last_update_date,
5878: last_updated_by = hz_utility_pub.user_id,
5879: last_update_login = hz_utility_pub.last_update_login,
5880: request_id = hz_utility_pub.request_id,
5881: program_application_id = hz_utility_pub.program_application_id,
5882: program_id = hz_utility_pub.program_id,
5883: program_update_date = sysdate
5884: WHERE PARTY_ID = l_rel_party_id;
5885: END IF;
5878: last_updated_by = hz_utility_pub.user_id,
5879: last_update_login = hz_utility_pub.last_update_login,
5880: request_id = hz_utility_pub.request_id,
5881: program_application_id = hz_utility_pub.program_application_id,
5882: program_id = hz_utility_pub.program_id,
5883: program_update_date = sysdate
5884: WHERE PARTY_ID = l_rel_party_id;
5885: END IF;
5886: ----End of Bug:3880218----
5897: ELSE
5898: IF l_rel_party_id is not null THEN
5899: UPDATE HZ_PARTIES
5900: SET STATUS = 'M',
5901: last_update_date = hz_utility_pub.last_update_date,
5902: last_updated_by = hz_utility_pub.user_id,
5903: last_update_login = hz_utility_pub.last_update_login,
5904: request_id = hz_utility_pub.request_id,
5905: program_application_id = hz_utility_pub.program_application_id,
5898: IF l_rel_party_id is not null THEN
5899: UPDATE HZ_PARTIES
5900: SET STATUS = 'M',
5901: last_update_date = hz_utility_pub.last_update_date,
5902: last_updated_by = hz_utility_pub.user_id,
5903: last_update_login = hz_utility_pub.last_update_login,
5904: request_id = hz_utility_pub.request_id,
5905: program_application_id = hz_utility_pub.program_application_id,
5906: program_id = hz_utility_pub.program_id,
5899: UPDATE HZ_PARTIES
5900: SET STATUS = 'M',
5901: last_update_date = hz_utility_pub.last_update_date,
5902: last_updated_by = hz_utility_pub.user_id,
5903: last_update_login = hz_utility_pub.last_update_login,
5904: request_id = hz_utility_pub.request_id,
5905: program_application_id = hz_utility_pub.program_application_id,
5906: program_id = hz_utility_pub.program_id,
5907: program_update_date = sysdate
5900: SET STATUS = 'M',
5901: last_update_date = hz_utility_pub.last_update_date,
5902: last_updated_by = hz_utility_pub.user_id,
5903: last_update_login = hz_utility_pub.last_update_login,
5904: request_id = hz_utility_pub.request_id,
5905: program_application_id = hz_utility_pub.program_application_id,
5906: program_id = hz_utility_pub.program_id,
5907: program_update_date = sysdate
5908: WHERE PARTY_ID IN (select party_id from hz_relationships where subject_id=p_to_fk_id
5901: last_update_date = hz_utility_pub.last_update_date,
5902: last_updated_by = hz_utility_pub.user_id,
5903: last_update_login = hz_utility_pub.last_update_login,
5904: request_id = hz_utility_pub.request_id,
5905: program_application_id = hz_utility_pub.program_application_id,
5906: program_id = hz_utility_pub.program_id,
5907: program_update_date = sysdate
5908: WHERE PARTY_ID IN (select party_id from hz_relationships where subject_id=p_to_fk_id
5909: and object_id=p_to_fk_id and relationship_id <>p_from_id and status='A'
5902: last_updated_by = hz_utility_pub.user_id,
5903: last_update_login = hz_utility_pub.last_update_login,
5904: request_id = hz_utility_pub.request_id,
5905: program_application_id = hz_utility_pub.program_application_id,
5906: program_id = hz_utility_pub.program_id,
5907: program_update_date = sysdate
5908: WHERE PARTY_ID IN (select party_id from hz_relationships where subject_id=p_to_fk_id
5909: and object_id=p_to_fk_id and relationship_id <>p_from_id and status='A'
5910: AND ((start_date between from_start_date and from_end_date)
5914: UPDATE HZ_RELATIONSHIPS
5915: SET
5916: STATUS = 'M',
5917: END_DATE = sysdate,
5918: last_update_date = hz_utility_pub.last_update_date,
5919: last_updated_by = hz_utility_pub.user_id,
5920: last_update_login = hz_utility_pub.last_update_login,
5921: request_id = hz_utility_pub.request_id,
5922: program_application_id = hz_utility_pub.program_application_id,
5915: SET
5916: STATUS = 'M',
5917: END_DATE = sysdate,
5918: last_update_date = hz_utility_pub.last_update_date,
5919: last_updated_by = hz_utility_pub.user_id,
5920: last_update_login = hz_utility_pub.last_update_login,
5921: request_id = hz_utility_pub.request_id,
5922: program_application_id = hz_utility_pub.program_application_id,
5923: program_id = hz_utility_pub.program_id,
5916: STATUS = 'M',
5917: END_DATE = sysdate,
5918: last_update_date = hz_utility_pub.last_update_date,
5919: last_updated_by = hz_utility_pub.user_id,
5920: last_update_login = hz_utility_pub.last_update_login,
5921: request_id = hz_utility_pub.request_id,
5922: program_application_id = hz_utility_pub.program_application_id,
5923: program_id = hz_utility_pub.program_id,
5924: program_update_date = sysdate
5917: END_DATE = sysdate,
5918: last_update_date = hz_utility_pub.last_update_date,
5919: last_updated_by = hz_utility_pub.user_id,
5920: last_update_login = hz_utility_pub.last_update_login,
5921: request_id = hz_utility_pub.request_id,
5922: program_application_id = hz_utility_pub.program_application_id,
5923: program_id = hz_utility_pub.program_id,
5924: program_update_date = sysdate
5925: WHERE relationship_id in (select relationship_id from hz_relationships where subject_id=p_to_fk_id
5918: last_update_date = hz_utility_pub.last_update_date,
5919: last_updated_by = hz_utility_pub.user_id,
5920: last_update_login = hz_utility_pub.last_update_login,
5921: request_id = hz_utility_pub.request_id,
5922: program_application_id = hz_utility_pub.program_application_id,
5923: program_id = hz_utility_pub.program_id,
5924: program_update_date = sysdate
5925: WHERE relationship_id in (select relationship_id from hz_relationships where subject_id=p_to_fk_id
5926: and object_id=p_to_fk_id and relationship_id <>p_from_id and status='A'
5919: last_updated_by = hz_utility_pub.user_id,
5920: last_update_login = hz_utility_pub.last_update_login,
5921: request_id = hz_utility_pub.request_id,
5922: program_application_id = hz_utility_pub.program_application_id,
5923: program_id = hz_utility_pub.program_id,
5924: program_update_date = sysdate
5925: WHERE relationship_id in (select relationship_id from hz_relationships where subject_id=p_to_fk_id
5926: and object_id=p_to_fk_id and relationship_id <>p_from_id and status='A'
5927: AND ((start_date between from_start_date and from_end_date)
5985: UPDATE HZ_RELATIONSHIPS
5986: SET
5987: STATUS = 'M',
5988: end_date = sysdate,
5989: last_update_date = hz_utility_pub.last_update_date,
5990: last_updated_by = hz_utility_pub.user_id,
5991: last_update_login = hz_utility_pub.last_update_login,
5992: request_id = hz_utility_pub.request_id,
5993: program_application_id = hz_utility_pub.program_application_id,
5986: SET
5987: STATUS = 'M',
5988: end_date = sysdate,
5989: last_update_date = hz_utility_pub.last_update_date,
5990: last_updated_by = hz_utility_pub.user_id,
5991: last_update_login = hz_utility_pub.last_update_login,
5992: request_id = hz_utility_pub.request_id,
5993: program_application_id = hz_utility_pub.program_application_id,
5994: program_id = hz_utility_pub.program_id,
5987: STATUS = 'M',
5988: end_date = sysdate,
5989: last_update_date = hz_utility_pub.last_update_date,
5990: last_updated_by = hz_utility_pub.user_id,
5991: last_update_login = hz_utility_pub.last_update_login,
5992: request_id = hz_utility_pub.request_id,
5993: program_application_id = hz_utility_pub.program_application_id,
5994: program_id = hz_utility_pub.program_id,
5995: program_update_date = sysdate
5988: end_date = sysdate,
5989: last_update_date = hz_utility_pub.last_update_date,
5990: last_updated_by = hz_utility_pub.user_id,
5991: last_update_login = hz_utility_pub.last_update_login,
5992: request_id = hz_utility_pub.request_id,
5993: program_application_id = hz_utility_pub.program_application_id,
5994: program_id = hz_utility_pub.program_id,
5995: program_update_date = sysdate
5996: WHERE relationship_id = p_from_id;
5989: last_update_date = hz_utility_pub.last_update_date,
5990: last_updated_by = hz_utility_pub.user_id,
5991: last_update_login = hz_utility_pub.last_update_login,
5992: request_id = hz_utility_pub.request_id,
5993: program_application_id = hz_utility_pub.program_application_id,
5994: program_id = hz_utility_pub.program_id,
5995: program_update_date = sysdate
5996: WHERE relationship_id = p_from_id;
5997: ----Start of DlProject Phase2--------------------
5990: last_updated_by = hz_utility_pub.user_id,
5991: last_update_login = hz_utility_pub.last_update_login,
5992: request_id = hz_utility_pub.request_id,
5993: program_application_id = hz_utility_pub.program_application_id,
5994: program_id = hz_utility_pub.program_id,
5995: program_update_date = sysdate
5996: WHERE relationship_id = p_from_id;
5997: ----Start of DlProject Phase2--------------------
5998: do_hierarchy_nodes_merge(p_from_id => p_from_id,
6136: UPDATE HZ_ORGANIZATION_PROFILES
6137: SET
6138: STATUS = 'M',
6139: effective_end_date = trunc(SYSDATE-1),
6140: last_update_date = hz_utility_pub.last_update_date,
6141: last_updated_by = hz_utility_pub.user_id,
6142: last_update_login = hz_utility_pub.last_update_login,
6143: request_id = hz_utility_pub.request_id,
6144: program_application_id = hz_utility_pub.program_application_id,
6137: SET
6138: STATUS = 'M',
6139: effective_end_date = trunc(SYSDATE-1),
6140: last_update_date = hz_utility_pub.last_update_date,
6141: last_updated_by = hz_utility_pub.user_id,
6142: last_update_login = hz_utility_pub.last_update_login,
6143: request_id = hz_utility_pub.request_id,
6144: program_application_id = hz_utility_pub.program_application_id,
6145: program_id = hz_utility_pub.program_id,
6138: STATUS = 'M',
6139: effective_end_date = trunc(SYSDATE-1),
6140: last_update_date = hz_utility_pub.last_update_date,
6141: last_updated_by = hz_utility_pub.user_id,
6142: last_update_login = hz_utility_pub.last_update_login,
6143: request_id = hz_utility_pub.request_id,
6144: program_application_id = hz_utility_pub.program_application_id,
6145: program_id = hz_utility_pub.program_id,
6146: program_update_date = sysdate
6139: effective_end_date = trunc(SYSDATE-1),
6140: last_update_date = hz_utility_pub.last_update_date,
6141: last_updated_by = hz_utility_pub.user_id,
6142: last_update_login = hz_utility_pub.last_update_login,
6143: request_id = hz_utility_pub.request_id,
6144: program_application_id = hz_utility_pub.program_application_id,
6145: program_id = hz_utility_pub.program_id,
6146: program_update_date = sysdate
6147: WHERE organization_profile_id = p_from_id;
6140: last_update_date = hz_utility_pub.last_update_date,
6141: last_updated_by = hz_utility_pub.user_id,
6142: last_update_login = hz_utility_pub.last_update_login,
6143: request_id = hz_utility_pub.request_id,
6144: program_application_id = hz_utility_pub.program_application_id,
6145: program_id = hz_utility_pub.program_id,
6146: program_update_date = sysdate
6147: WHERE organization_profile_id = p_from_id;
6148:
6141: last_updated_by = hz_utility_pub.user_id,
6142: last_update_login = hz_utility_pub.last_update_login,
6143: request_id = hz_utility_pub.request_id,
6144: program_application_id = hz_utility_pub.program_application_id,
6145: program_id = hz_utility_pub.program_id,
6146: program_update_date = sysdate
6147: WHERE organization_profile_id = p_from_id;
6148:
6149: EXCEPTION
6195: ELSE
6196: UPDATE HZ_PERSON_PROFILES
6197: SET
6198: party_id = p_to_fk_id,
6199: last_update_date = hz_utility_pub.last_update_date,
6200: last_updated_by = hz_utility_pub.user_id,
6201: last_update_login = hz_utility_pub.last_update_login,
6202: request_id = hz_utility_pub.request_id,
6203: program_application_id = hz_utility_pub.program_application_id,
6196: UPDATE HZ_PERSON_PROFILES
6197: SET
6198: party_id = p_to_fk_id,
6199: last_update_date = hz_utility_pub.last_update_date,
6200: last_updated_by = hz_utility_pub.user_id,
6201: last_update_login = hz_utility_pub.last_update_login,
6202: request_id = hz_utility_pub.request_id,
6203: program_application_id = hz_utility_pub.program_application_id,
6204: program_id = hz_utility_pub.program_id,
6197: SET
6198: party_id = p_to_fk_id,
6199: last_update_date = hz_utility_pub.last_update_date,
6200: last_updated_by = hz_utility_pub.user_id,
6201: last_update_login = hz_utility_pub.last_update_login,
6202: request_id = hz_utility_pub.request_id,
6203: program_application_id = hz_utility_pub.program_application_id,
6204: program_id = hz_utility_pub.program_id,
6205: program_update_date = sysdate
6198: party_id = p_to_fk_id,
6199: last_update_date = hz_utility_pub.last_update_date,
6200: last_updated_by = hz_utility_pub.user_id,
6201: last_update_login = hz_utility_pub.last_update_login,
6202: request_id = hz_utility_pub.request_id,
6203: program_application_id = hz_utility_pub.program_application_id,
6204: program_id = hz_utility_pub.program_id,
6205: program_update_date = sysdate
6206: WHERE person_profile_id = p_from_id;
6199: last_update_date = hz_utility_pub.last_update_date,
6200: last_updated_by = hz_utility_pub.user_id,
6201: last_update_login = hz_utility_pub.last_update_login,
6202: request_id = hz_utility_pub.request_id,
6203: program_application_id = hz_utility_pub.program_application_id,
6204: program_id = hz_utility_pub.program_id,
6205: program_update_date = sysdate
6206: WHERE person_profile_id = p_from_id;
6207: END IF;
6200: last_updated_by = hz_utility_pub.user_id,
6201: last_update_login = hz_utility_pub.last_update_login,
6202: request_id = hz_utility_pub.request_id,
6203: program_application_id = hz_utility_pub.program_application_id,
6204: program_id = hz_utility_pub.program_id,
6205: program_update_date = sysdate
6206: WHERE person_profile_id = p_from_id;
6207: END IF;
6208: ELSE
6211: UPDATE HZ_PERSON_PROFILES
6212: SET
6213: STATUS = 'M',
6214: effective_end_date = trunc(SYSDATE-1),
6215: last_update_date = hz_utility_pub.last_update_date,
6216: last_updated_by = hz_utility_pub.user_id,
6217: last_update_login = hz_utility_pub.last_update_login,
6218: request_id = hz_utility_pub.request_id,
6219: program_application_id = hz_utility_pub.program_application_id,
6212: SET
6213: STATUS = 'M',
6214: effective_end_date = trunc(SYSDATE-1),
6215: last_update_date = hz_utility_pub.last_update_date,
6216: last_updated_by = hz_utility_pub.user_id,
6217: last_update_login = hz_utility_pub.last_update_login,
6218: request_id = hz_utility_pub.request_id,
6219: program_application_id = hz_utility_pub.program_application_id,
6220: program_id = hz_utility_pub.program_id,
6213: STATUS = 'M',
6214: effective_end_date = trunc(SYSDATE-1),
6215: last_update_date = hz_utility_pub.last_update_date,
6216: last_updated_by = hz_utility_pub.user_id,
6217: last_update_login = hz_utility_pub.last_update_login,
6218: request_id = hz_utility_pub.request_id,
6219: program_application_id = hz_utility_pub.program_application_id,
6220: program_id = hz_utility_pub.program_id,
6221: program_update_date = sysdate
6214: effective_end_date = trunc(SYSDATE-1),
6215: last_update_date = hz_utility_pub.last_update_date,
6216: last_updated_by = hz_utility_pub.user_id,
6217: last_update_login = hz_utility_pub.last_update_login,
6218: request_id = hz_utility_pub.request_id,
6219: program_application_id = hz_utility_pub.program_application_id,
6220: program_id = hz_utility_pub.program_id,
6221: program_update_date = sysdate
6222: WHERE person_profile_id = p_from_id;
6215: last_update_date = hz_utility_pub.last_update_date,
6216: last_updated_by = hz_utility_pub.user_id,
6217: last_update_login = hz_utility_pub.last_update_login,
6218: request_id = hz_utility_pub.request_id,
6219: program_application_id = hz_utility_pub.program_application_id,
6220: program_id = hz_utility_pub.program_id,
6221: program_update_date = sysdate
6222: WHERE person_profile_id = p_from_id;
6223:
6216: last_updated_by = hz_utility_pub.user_id,
6217: last_update_login = hz_utility_pub.last_update_login,
6218: request_id = hz_utility_pub.request_id,
6219: program_application_id = hz_utility_pub.program_application_id,
6220: program_id = hz_utility_pub.program_id,
6221: program_update_date = sysdate
6222: WHERE person_profile_id = p_from_id;
6223:
6224: --For NOCOPY fix
6513:
6514: UPDATE HZ_PARTY_SITES
6515: SET
6516: STATUS = 'M',
6517: last_update_date = hz_utility_pub.last_update_date,
6518: last_updated_by = hz_utility_pub.user_id,
6519: last_update_login = hz_utility_pub.last_update_login,
6520: request_id = hz_utility_pub.request_id,
6521: program_application_id = hz_utility_pub.program_application_id,
6514: UPDATE HZ_PARTY_SITES
6515: SET
6516: STATUS = 'M',
6517: last_update_date = hz_utility_pub.last_update_date,
6518: last_updated_by = hz_utility_pub.user_id,
6519: last_update_login = hz_utility_pub.last_update_login,
6520: request_id = hz_utility_pub.request_id,
6521: program_application_id = hz_utility_pub.program_application_id,
6522: program_id = hz_utility_pub.program_id,
6515: SET
6516: STATUS = 'M',
6517: last_update_date = hz_utility_pub.last_update_date,
6518: last_updated_by = hz_utility_pub.user_id,
6519: last_update_login = hz_utility_pub.last_update_login,
6520: request_id = hz_utility_pub.request_id,
6521: program_application_id = hz_utility_pub.program_application_id,
6522: program_id = hz_utility_pub.program_id,
6523: program_update_date = sysdate
6516: STATUS = 'M',
6517: last_update_date = hz_utility_pub.last_update_date,
6518: last_updated_by = hz_utility_pub.user_id,
6519: last_update_login = hz_utility_pub.last_update_login,
6520: request_id = hz_utility_pub.request_id,
6521: program_application_id = hz_utility_pub.program_application_id,
6522: program_id = hz_utility_pub.program_id,
6523: program_update_date = sysdate
6524: WHERE party_site_id = p_from_id;
6517: last_update_date = hz_utility_pub.last_update_date,
6518: last_updated_by = hz_utility_pub.user_id,
6519: last_update_login = hz_utility_pub.last_update_login,
6520: request_id = hz_utility_pub.request_id,
6521: program_application_id = hz_utility_pub.program_application_id,
6522: program_id = hz_utility_pub.program_id,
6523: program_update_date = sysdate
6524: WHERE party_site_id = p_from_id;
6525: /* Bug 3892399
6518: last_updated_by = hz_utility_pub.user_id,
6519: last_update_login = hz_utility_pub.last_update_login,
6520: request_id = hz_utility_pub.request_id,
6521: program_application_id = hz_utility_pub.program_application_id,
6522: program_id = hz_utility_pub.program_id,
6523: program_update_date = sysdate
6524: WHERE party_site_id = p_from_id;
6525: /* Bug 3892399
6526: UPDATE HZ_ORIG_SYS_REFERENCES
6525: /* Bug 3892399
6526: UPDATE HZ_ORIG_SYS_REFERENCES
6527: SET
6528: STATUS = 'I',
6529: last_update_date = hz_utility_pub.last_update_date,
6530: last_updated_by = hz_utility_pub.user_id,
6531: last_update_login = hz_utility_pub.last_update_login
6532: WHERE owner_table_id = p_from_id and owner_table_name='HZ_PARTY_SITES';
6533: */
6526: UPDATE HZ_ORIG_SYS_REFERENCES
6527: SET
6528: STATUS = 'I',
6529: last_update_date = hz_utility_pub.last_update_date,
6530: last_updated_by = hz_utility_pub.user_id,
6531: last_update_login = hz_utility_pub.last_update_login
6532: WHERE owner_table_id = p_from_id and owner_table_name='HZ_PARTY_SITES';
6533: */
6534: HZ_ORIG_SYSTEM_REF_PVT.remap_internal_identifier(
6527: SET
6528: STATUS = 'I',
6529: last_update_date = hz_utility_pub.last_update_date,
6530: last_updated_by = hz_utility_pub.user_id,
6531: last_update_login = hz_utility_pub.last_update_login
6532: WHERE owner_table_id = p_from_id and owner_table_name='HZ_PARTY_SITES';
6533: */
6534: HZ_ORIG_SYSTEM_REF_PVT.remap_internal_identifier(
6535: p_init_msg_list => FND_API.G_FALSE,
6592: UPDATE HZ_PARTY_SITES
6593: SET
6594: STATUS = 'M',
6595: party_site_number = l_party_site_number,
6596: last_update_date = hz_utility_pub.last_update_date,
6597: last_updated_by = hz_utility_pub.user_id,
6598: last_update_login = hz_utility_pub.last_update_login,
6599: request_id = hz_utility_pub.request_id,
6600: program_application_id = hz_utility_pub.program_application_id,
6593: SET
6594: STATUS = 'M',
6595: party_site_number = l_party_site_number,
6596: last_update_date = hz_utility_pub.last_update_date,
6597: last_updated_by = hz_utility_pub.user_id,
6598: last_update_login = hz_utility_pub.last_update_login,
6599: request_id = hz_utility_pub.request_id,
6600: program_application_id = hz_utility_pub.program_application_id,
6601: program_id = hz_utility_pub.program_id,
6594: STATUS = 'M',
6595: party_site_number = l_party_site_number,
6596: last_update_date = hz_utility_pub.last_update_date,
6597: last_updated_by = hz_utility_pub.user_id,
6598: last_update_login = hz_utility_pub.last_update_login,
6599: request_id = hz_utility_pub.request_id,
6600: program_application_id = hz_utility_pub.program_application_id,
6601: program_id = hz_utility_pub.program_id,
6602: program_update_date = sysdate
6595: party_site_number = l_party_site_number,
6596: last_update_date = hz_utility_pub.last_update_date,
6597: last_updated_by = hz_utility_pub.user_id,
6598: last_update_login = hz_utility_pub.last_update_login,
6599: request_id = hz_utility_pub.request_id,
6600: program_application_id = hz_utility_pub.program_application_id,
6601: program_id = hz_utility_pub.program_id,
6602: program_update_date = sysdate
6603: WHERE party_site_id = p_from_id;
6596: last_update_date = hz_utility_pub.last_update_date,
6597: last_updated_by = hz_utility_pub.user_id,
6598: last_update_login = hz_utility_pub.last_update_login,
6599: request_id = hz_utility_pub.request_id,
6600: program_application_id = hz_utility_pub.program_application_id,
6601: program_id = hz_utility_pub.program_id,
6602: program_update_date = sysdate
6603: WHERE party_site_id = p_from_id;
6604: EXCEPTION
6597: last_updated_by = hz_utility_pub.user_id,
6598: last_update_login = hz_utility_pub.last_update_login,
6599: request_id = hz_utility_pub.request_id,
6600: program_application_id = hz_utility_pub.program_application_id,
6601: program_id = hz_utility_pub.program_id,
6602: program_update_date = sysdate
6603: WHERE party_site_id = p_from_id;
6604: EXCEPTION
6605: WHEN DUP_VAL_ON_INDEX THEN
6805: -- Update and set status to merged
6806: UPDATE HZ_PARTIES
6807: SET
6808: STATUS = 'M',
6809: last_update_date = hz_utility_pub.last_update_date,
6810: last_updated_by = hz_utility_pub.user_id,
6811: last_update_login = hz_utility_pub.last_update_login,
6812: request_id = hz_utility_pub.request_id,
6813: program_application_id = hz_utility_pub.program_application_id,
6806: UPDATE HZ_PARTIES
6807: SET
6808: STATUS = 'M',
6809: last_update_date = hz_utility_pub.last_update_date,
6810: last_updated_by = hz_utility_pub.user_id,
6811: last_update_login = hz_utility_pub.last_update_login,
6812: request_id = hz_utility_pub.request_id,
6813: program_application_id = hz_utility_pub.program_application_id,
6814: program_id = hz_utility_pub.program_id,
6807: SET
6808: STATUS = 'M',
6809: last_update_date = hz_utility_pub.last_update_date,
6810: last_updated_by = hz_utility_pub.user_id,
6811: last_update_login = hz_utility_pub.last_update_login,
6812: request_id = hz_utility_pub.request_id,
6813: program_application_id = hz_utility_pub.program_application_id,
6814: program_id = hz_utility_pub.program_id,
6815: program_update_date = sysdate
6808: STATUS = 'M',
6809: last_update_date = hz_utility_pub.last_update_date,
6810: last_updated_by = hz_utility_pub.user_id,
6811: last_update_login = hz_utility_pub.last_update_login,
6812: request_id = hz_utility_pub.request_id,
6813: program_application_id = hz_utility_pub.program_application_id,
6814: program_id = hz_utility_pub.program_id,
6815: program_update_date = sysdate
6816: WHERE party_id = p_from_id;
6809: last_update_date = hz_utility_pub.last_update_date,
6810: last_updated_by = hz_utility_pub.user_id,
6811: last_update_login = hz_utility_pub.last_update_login,
6812: request_id = hz_utility_pub.request_id,
6813: program_application_id = hz_utility_pub.program_application_id,
6814: program_id = hz_utility_pub.program_id,
6815: program_update_date = sysdate
6816: WHERE party_id = p_from_id;
6817:
6810: last_updated_by = hz_utility_pub.user_id,
6811: last_update_login = hz_utility_pub.last_update_login,
6812: request_id = hz_utility_pub.request_id,
6813: program_application_id = hz_utility_pub.program_application_id,
6814: program_id = hz_utility_pub.program_id,
6815: program_update_date = sysdate
6816: WHERE party_id = p_from_id;
6817:
6818: UPDATE HZ_DQM_SYNC_INTERFACE
6860:
6861: UPDATE HZ_ORGANIZATION_PROFILES
6862: SET
6863: displayed_duns_party_id = p_to_fk_id,
6864: last_update_date = hz_utility_pub.last_update_date,
6865: last_updated_by = hz_utility_pub.user_id,
6866: last_update_login = hz_utility_pub.last_update_login,
6867: request_id = hz_utility_pub.request_id,
6868: program_application_id = hz_utility_pub.program_application_id,
6861: UPDATE HZ_ORGANIZATION_PROFILES
6862: SET
6863: displayed_duns_party_id = p_to_fk_id,
6864: last_update_date = hz_utility_pub.last_update_date,
6865: last_updated_by = hz_utility_pub.user_id,
6866: last_update_login = hz_utility_pub.last_update_login,
6867: request_id = hz_utility_pub.request_id,
6868: program_application_id = hz_utility_pub.program_application_id,
6869: program_id = hz_utility_pub.program_id,
6862: SET
6863: displayed_duns_party_id = p_to_fk_id,
6864: last_update_date = hz_utility_pub.last_update_date,
6865: last_updated_by = hz_utility_pub.user_id,
6866: last_update_login = hz_utility_pub.last_update_login,
6867: request_id = hz_utility_pub.request_id,
6868: program_application_id = hz_utility_pub.program_application_id,
6869: program_id = hz_utility_pub.program_id,
6870: program_update_date = sysdate
6863: displayed_duns_party_id = p_to_fk_id,
6864: last_update_date = hz_utility_pub.last_update_date,
6865: last_updated_by = hz_utility_pub.user_id,
6866: last_update_login = hz_utility_pub.last_update_login,
6867: request_id = hz_utility_pub.request_id,
6868: program_application_id = hz_utility_pub.program_application_id,
6869: program_id = hz_utility_pub.program_id,
6870: program_update_date = sysdate
6871: WHERE organization_profile_id = p_from_id;
6864: last_update_date = hz_utility_pub.last_update_date,
6865: last_updated_by = hz_utility_pub.user_id,
6866: last_update_login = hz_utility_pub.last_update_login,
6867: request_id = hz_utility_pub.request_id,
6868: program_application_id = hz_utility_pub.program_application_id,
6869: program_id = hz_utility_pub.program_id,
6870: program_update_date = sysdate
6871: WHERE organization_profile_id = p_from_id;
6872:
6865: last_updated_by = hz_utility_pub.user_id,
6866: last_update_login = hz_utility_pub.last_update_login,
6867: request_id = hz_utility_pub.request_id,
6868: program_application_id = hz_utility_pub.program_application_id,
6869: program_id = hz_utility_pub.program_id,
6870: program_update_date = sysdate
6871: WHERE organization_profile_id = p_from_id;
6872:
6873:
6918: p_destination_party_id,
6919: l_requested_product,
6920: l_duns_number,
6921: 'S',
6922: hz_utility_pub.CREATED_BY,
6923: hz_utility_pub.CREATION_DATE,
6924: hz_utility_pub.LAST_UPDATED_BY,
6925: hz_utility_pub.LAST_UPDATE_DATE,
6926: hz_utility_pub.LAST_UPDATE_LOGIN,
6919: l_requested_product,
6920: l_duns_number,
6921: 'S',
6922: hz_utility_pub.CREATED_BY,
6923: hz_utility_pub.CREATION_DATE,
6924: hz_utility_pub.LAST_UPDATED_BY,
6925: hz_utility_pub.LAST_UPDATE_DATE,
6926: hz_utility_pub.LAST_UPDATE_LOGIN,
6927: p_source_party_id );
6920: l_duns_number,
6921: 'S',
6922: hz_utility_pub.CREATED_BY,
6923: hz_utility_pub.CREATION_DATE,
6924: hz_utility_pub.LAST_UPDATED_BY,
6925: hz_utility_pub.LAST_UPDATE_DATE,
6926: hz_utility_pub.LAST_UPDATE_LOGIN,
6927: p_source_party_id );
6928: EXCEPTION
6921: 'S',
6922: hz_utility_pub.CREATED_BY,
6923: hz_utility_pub.CREATION_DATE,
6924: hz_utility_pub.LAST_UPDATED_BY,
6925: hz_utility_pub.LAST_UPDATE_DATE,
6926: hz_utility_pub.LAST_UPDATE_LOGIN,
6927: p_source_party_id );
6928: EXCEPTION
6929: WHEN NO_DATA_FOUND THEN
6922: hz_utility_pub.CREATED_BY,
6923: hz_utility_pub.CREATION_DATE,
6924: hz_utility_pub.LAST_UPDATED_BY,
6925: hz_utility_pub.LAST_UPDATE_DATE,
6926: hz_utility_pub.LAST_UPDATE_LOGIN,
6927: p_source_party_id );
6928: EXCEPTION
6929: WHEN NO_DATA_FOUND THEN
6930: null;