[Home] [Help]
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'
3113: SET
3114: owner_table_id = p_to_fk_id,
3115: primary_flag = l_primary_flag,
3116: primary_by_purpose = l_pri_purpose_flag,
3117: last_update_date = hz_utility_pub.last_update_date,
3118: last_updated_by = hz_utility_pub.user_id,
3119: last_update_login = hz_utility_pub.last_update_login,
3120: request_id = hz_utility_pub.request_id,
3121: program_application_id = hz_utility_pub.program_application_id,
3114: owner_table_id = p_to_fk_id,
3115: primary_flag = l_primary_flag,
3116: primary_by_purpose = l_pri_purpose_flag,
3117: last_update_date = hz_utility_pub.last_update_date,
3118: last_updated_by = hz_utility_pub.user_id,
3119: last_update_login = hz_utility_pub.last_update_login,
3120: request_id = hz_utility_pub.request_id,
3121: program_application_id = hz_utility_pub.program_application_id,
3122: program_id = hz_utility_pub.program_id,
3115: primary_flag = l_primary_flag,
3116: primary_by_purpose = l_pri_purpose_flag,
3117: last_update_date = hz_utility_pub.last_update_date,
3118: last_updated_by = hz_utility_pub.user_id,
3119: last_update_login = hz_utility_pub.last_update_login,
3120: request_id = hz_utility_pub.request_id,
3121: program_application_id = hz_utility_pub.program_application_id,
3122: program_id = hz_utility_pub.program_id,
3123: program_update_date = sysdate
3116: primary_by_purpose = l_pri_purpose_flag,
3117: last_update_date = hz_utility_pub.last_update_date,
3118: last_updated_by = hz_utility_pub.user_id,
3119: last_update_login = hz_utility_pub.last_update_login,
3120: request_id = hz_utility_pub.request_id,
3121: program_application_id = hz_utility_pub.program_application_id,
3122: program_id = hz_utility_pub.program_id,
3123: program_update_date = sysdate
3124: WHERE contact_point_id = p_from_id;
3117: last_update_date = hz_utility_pub.last_update_date,
3118: last_updated_by = hz_utility_pub.user_id,
3119: last_update_login = hz_utility_pub.last_update_login,
3120: request_id = hz_utility_pub.request_id,
3121: program_application_id = hz_utility_pub.program_application_id,
3122: program_id = hz_utility_pub.program_id,
3123: program_update_date = sysdate
3124: WHERE contact_point_id = p_from_id;
3125:
3118: last_updated_by = hz_utility_pub.user_id,
3119: last_update_login = hz_utility_pub.last_update_login,
3120: request_id = hz_utility_pub.request_id,
3121: program_application_id = hz_utility_pub.program_application_id,
3122: program_id = hz_utility_pub.program_id,
3123: program_update_date = sysdate
3124: WHERE contact_point_id = p_from_id;
3125:
3126: END IF;
3166: -- Update and set status to merged
3167: UPDATE HZ_CONTACT_POINTS
3168: SET
3169: STATUS = 'M',
3170: last_update_date = hz_utility_pub.last_update_date,
3171: last_updated_by = hz_utility_pub.user_id,
3172: last_update_login = hz_utility_pub.last_update_login,
3173: request_id = hz_utility_pub.request_id,
3174: program_application_id = hz_utility_pub.program_application_id,
3167: UPDATE HZ_CONTACT_POINTS
3168: SET
3169: STATUS = 'M',
3170: last_update_date = hz_utility_pub.last_update_date,
3171: last_updated_by = hz_utility_pub.user_id,
3172: last_update_login = hz_utility_pub.last_update_login,
3173: request_id = hz_utility_pub.request_id,
3174: program_application_id = hz_utility_pub.program_application_id,
3175: program_id = hz_utility_pub.program_id,
3168: SET
3169: STATUS = 'M',
3170: last_update_date = hz_utility_pub.last_update_date,
3171: last_updated_by = hz_utility_pub.user_id,
3172: last_update_login = hz_utility_pub.last_update_login,
3173: request_id = hz_utility_pub.request_id,
3174: program_application_id = hz_utility_pub.program_application_id,
3175: program_id = hz_utility_pub.program_id,
3176: program_update_date = sysdate
3169: STATUS = 'M',
3170: last_update_date = hz_utility_pub.last_update_date,
3171: last_updated_by = hz_utility_pub.user_id,
3172: last_update_login = hz_utility_pub.last_update_login,
3173: request_id = hz_utility_pub.request_id,
3174: program_application_id = hz_utility_pub.program_application_id,
3175: program_id = hz_utility_pub.program_id,
3176: program_update_date = sysdate
3177: WHERE contact_point_id = p_from_id;
3170: last_update_date = hz_utility_pub.last_update_date,
3171: last_updated_by = hz_utility_pub.user_id,
3172: last_update_login = hz_utility_pub.last_update_login,
3173: request_id = hz_utility_pub.request_id,
3174: program_application_id = hz_utility_pub.program_application_id,
3175: program_id = hz_utility_pub.program_id,
3176: program_update_date = sysdate
3177: WHERE contact_point_id = p_from_id;
3178:
3171: last_updated_by = hz_utility_pub.user_id,
3172: last_update_login = hz_utility_pub.last_update_login,
3173: request_id = hz_utility_pub.request_id,
3174: program_application_id = hz_utility_pub.program_application_id,
3175: program_id = hz_utility_pub.program_id,
3176: program_update_date = sysdate
3177: WHERE contact_point_id = p_from_id;
3178:
3179: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE STAGED_FLAG='N'
3244: SET
3245: owner_table_id = p_to_fk_id,
3246: primary_flag = l_primary_flag,
3247: primary_by_purpose = l_pri_purpose_flag,
3248: last_update_date = hz_utility_pub.last_update_date,
3249: last_updated_by = hz_utility_pub.user_id,
3250: last_update_login = hz_utility_pub.last_update_login,
3251: request_id = hz_utility_pub.request_id,
3252: program_application_id = hz_utility_pub.program_application_id,
3245: owner_table_id = p_to_fk_id,
3246: primary_flag = l_primary_flag,
3247: primary_by_purpose = l_pri_purpose_flag,
3248: last_update_date = hz_utility_pub.last_update_date,
3249: last_updated_by = hz_utility_pub.user_id,
3250: last_update_login = hz_utility_pub.last_update_login,
3251: request_id = hz_utility_pub.request_id,
3252: program_application_id = hz_utility_pub.program_application_id,
3253: program_id = hz_utility_pub.program_id,
3246: primary_flag = l_primary_flag,
3247: primary_by_purpose = l_pri_purpose_flag,
3248: last_update_date = hz_utility_pub.last_update_date,
3249: last_updated_by = hz_utility_pub.user_id,
3250: last_update_login = hz_utility_pub.last_update_login,
3251: request_id = hz_utility_pub.request_id,
3252: program_application_id = hz_utility_pub.program_application_id,
3253: program_id = hz_utility_pub.program_id,
3254: program_update_date = sysdate
3247: primary_by_purpose = l_pri_purpose_flag,
3248: last_update_date = hz_utility_pub.last_update_date,
3249: last_updated_by = hz_utility_pub.user_id,
3250: last_update_login = hz_utility_pub.last_update_login,
3251: request_id = hz_utility_pub.request_id,
3252: program_application_id = hz_utility_pub.program_application_id,
3253: program_id = hz_utility_pub.program_id,
3254: program_update_date = sysdate
3255: WHERE contact_point_id = p_from_id;
3248: last_update_date = hz_utility_pub.last_update_date,
3249: last_updated_by = hz_utility_pub.user_id,
3250: last_update_login = hz_utility_pub.last_update_login,
3251: request_id = hz_utility_pub.request_id,
3252: program_application_id = hz_utility_pub.program_application_id,
3253: program_id = hz_utility_pub.program_id,
3254: program_update_date = sysdate
3255: WHERE contact_point_id = p_from_id;
3256:
3249: last_updated_by = hz_utility_pub.user_id,
3250: last_update_login = hz_utility_pub.last_update_login,
3251: request_id = hz_utility_pub.request_id,
3252: program_application_id = hz_utility_pub.program_application_id,
3253: program_id = hz_utility_pub.program_id,
3254: program_update_date = sysdate
3255: WHERE contact_point_id = p_from_id;
3256:
3257: END IF;
3277: x_to_id <> p_from_id) THEN
3278: UPDATE HZ_CONTACT_PREFERENCES
3279: SET
3280: status = 'M',
3281: last_update_date = hz_utility_pub.last_update_date,
3282: last_updated_by = hz_utility_pub.user_id,
3283: last_update_login = hz_utility_pub.last_update_login,
3284: request_id = hz_utility_pub.request_id,
3285: program_application_id = hz_utility_pub.program_application_id,
3278: UPDATE HZ_CONTACT_PREFERENCES
3279: SET
3280: status = 'M',
3281: last_update_date = hz_utility_pub.last_update_date,
3282: last_updated_by = hz_utility_pub.user_id,
3283: last_update_login = hz_utility_pub.last_update_login,
3284: request_id = hz_utility_pub.request_id,
3285: program_application_id = hz_utility_pub.program_application_id,
3286: program_id = hz_utility_pub.program_id,
3279: SET
3280: status = 'M',
3281: last_update_date = hz_utility_pub.last_update_date,
3282: last_updated_by = hz_utility_pub.user_id,
3283: last_update_login = hz_utility_pub.last_update_login,
3284: request_id = hz_utility_pub.request_id,
3285: program_application_id = hz_utility_pub.program_application_id,
3286: program_id = hz_utility_pub.program_id,
3287: program_update_date = sysdate
3280: status = 'M',
3281: last_update_date = hz_utility_pub.last_update_date,
3282: last_updated_by = hz_utility_pub.user_id,
3283: last_update_login = hz_utility_pub.last_update_login,
3284: request_id = hz_utility_pub.request_id,
3285: program_application_id = hz_utility_pub.program_application_id,
3286: program_id = hz_utility_pub.program_id,
3287: program_update_date = sysdate
3288: WHERE contact_preference_id = p_from_id;
3281: last_update_date = hz_utility_pub.last_update_date,
3282: last_updated_by = hz_utility_pub.user_id,
3283: last_update_login = hz_utility_pub.last_update_login,
3284: request_id = hz_utility_pub.request_id,
3285: program_application_id = hz_utility_pub.program_application_id,
3286: program_id = hz_utility_pub.program_id,
3287: program_update_date = sysdate
3288: WHERE contact_preference_id = p_from_id;
3289: ELSE
3282: last_updated_by = hz_utility_pub.user_id,
3283: last_update_login = hz_utility_pub.last_update_login,
3284: request_id = hz_utility_pub.request_id,
3285: program_application_id = hz_utility_pub.program_application_id,
3286: program_id = hz_utility_pub.program_id,
3287: program_update_date = sysdate
3288: WHERE contact_preference_id = p_from_id;
3289: ELSE
3290: -- Update and set contact_level_table_id = p_to_fk_id where pk = from_id
3290: -- Update and set contact_level_table_id = p_to_fk_id where pk = from_id
3291: UPDATE HZ_CONTACT_PREFERENCES
3292: SET
3293: contact_level_table_id = p_to_fk_id,
3294: last_update_date = hz_utility_pub.last_update_date,
3295: last_updated_by = hz_utility_pub.user_id,
3296: last_update_login = hz_utility_pub.last_update_login,
3297: request_id = hz_utility_pub.request_id,
3298: program_application_id = hz_utility_pub.program_application_id,
3291: UPDATE HZ_CONTACT_PREFERENCES
3292: SET
3293: contact_level_table_id = p_to_fk_id,
3294: last_update_date = hz_utility_pub.last_update_date,
3295: last_updated_by = hz_utility_pub.user_id,
3296: last_update_login = hz_utility_pub.last_update_login,
3297: request_id = hz_utility_pub.request_id,
3298: program_application_id = hz_utility_pub.program_application_id,
3299: program_id = hz_utility_pub.program_id,
3292: SET
3293: contact_level_table_id = p_to_fk_id,
3294: last_update_date = hz_utility_pub.last_update_date,
3295: last_updated_by = hz_utility_pub.user_id,
3296: last_update_login = hz_utility_pub.last_update_login,
3297: request_id = hz_utility_pub.request_id,
3298: program_application_id = hz_utility_pub.program_application_id,
3299: program_id = hz_utility_pub.program_id,
3300: program_update_date = sysdate
3293: contact_level_table_id = p_to_fk_id,
3294: last_update_date = hz_utility_pub.last_update_date,
3295: last_updated_by = hz_utility_pub.user_id,
3296: last_update_login = hz_utility_pub.last_update_login,
3297: request_id = hz_utility_pub.request_id,
3298: program_application_id = hz_utility_pub.program_application_id,
3299: program_id = hz_utility_pub.program_id,
3300: program_update_date = sysdate
3301: WHERE contact_preference_id = p_from_id;
3294: last_update_date = hz_utility_pub.last_update_date,
3295: last_updated_by = hz_utility_pub.user_id,
3296: last_update_login = hz_utility_pub.last_update_login,
3297: request_id = hz_utility_pub.request_id,
3298: program_application_id = hz_utility_pub.program_application_id,
3299: program_id = hz_utility_pub.program_id,
3300: program_update_date = sysdate
3301: WHERE contact_preference_id = p_from_id;
3302:
3295: last_updated_by = hz_utility_pub.user_id,
3296: last_update_login = hz_utility_pub.last_update_login,
3297: request_id = hz_utility_pub.request_id,
3298: program_application_id = hz_utility_pub.program_application_id,
3299: program_id = hz_utility_pub.program_id,
3300: program_update_date = sysdate
3301: WHERE contact_preference_id = p_from_id;
3302:
3303: END IF;
3324: x_to_id <> p_from_id) THEN
3325: UPDATE HZ_REFERENCES
3326: SET
3327: status = 'M',
3328: last_update_date = hz_utility_pub.last_update_date,
3329: last_updated_by = hz_utility_pub.user_id,
3330: last_update_login = hz_utility_pub.last_update_login,
3331: request_id = hz_utility_pub.request_id,
3332: program_application_id = hz_utility_pub.program_application_id,
3325: UPDATE HZ_REFERENCES
3326: SET
3327: status = 'M',
3328: last_update_date = hz_utility_pub.last_update_date,
3329: last_updated_by = hz_utility_pub.user_id,
3330: last_update_login = hz_utility_pub.last_update_login,
3331: request_id = hz_utility_pub.request_id,
3332: program_application_id = hz_utility_pub.program_application_id,
3333: program_id = hz_utility_pub.program_id,
3326: SET
3327: status = 'M',
3328: last_update_date = hz_utility_pub.last_update_date,
3329: last_updated_by = hz_utility_pub.user_id,
3330: last_update_login = hz_utility_pub.last_update_login,
3331: request_id = hz_utility_pub.request_id,
3332: program_application_id = hz_utility_pub.program_application_id,
3333: program_id = hz_utility_pub.program_id,
3334: program_update_date = sysdate
3327: status = 'M',
3328: last_update_date = hz_utility_pub.last_update_date,
3329: last_updated_by = hz_utility_pub.user_id,
3330: last_update_login = hz_utility_pub.last_update_login,
3331: request_id = hz_utility_pub.request_id,
3332: program_application_id = hz_utility_pub.program_application_id,
3333: program_id = hz_utility_pub.program_id,
3334: program_update_date = sysdate
3335: WHERE reference_id = p_from_id;
3328: last_update_date = hz_utility_pub.last_update_date,
3329: last_updated_by = hz_utility_pub.user_id,
3330: last_update_login = hz_utility_pub.last_update_login,
3331: request_id = hz_utility_pub.request_id,
3332: program_application_id = hz_utility_pub.program_application_id,
3333: program_id = hz_utility_pub.program_id,
3334: program_update_date = sysdate
3335: WHERE reference_id = p_from_id;
3336: ELSE
3329: last_updated_by = hz_utility_pub.user_id,
3330: last_update_login = hz_utility_pub.last_update_login,
3331: request_id = hz_utility_pub.request_id,
3332: program_application_id = hz_utility_pub.program_application_id,
3333: program_id = hz_utility_pub.program_id,
3334: program_update_date = sysdate
3335: WHERE reference_id = p_from_id;
3336: ELSE
3337: -- Update and set party_id = p_to_fk_id where pk = from_id
3337: -- Update and set party_id = p_to_fk_id where pk = from_id
3338: UPDATE HZ_REFERENCES
3339: SET
3340: referenced_party_id = p_to_fk_id,
3341: last_update_date = hz_utility_pub.last_update_date,
3342: last_updated_by = hz_utility_pub.user_id,
3343: last_update_login = hz_utility_pub.last_update_login,
3344: request_id = hz_utility_pub.request_id,
3345: program_application_id = hz_utility_pub.program_application_id,
3338: UPDATE HZ_REFERENCES
3339: SET
3340: referenced_party_id = p_to_fk_id,
3341: last_update_date = hz_utility_pub.last_update_date,
3342: last_updated_by = hz_utility_pub.user_id,
3343: last_update_login = hz_utility_pub.last_update_login,
3344: request_id = hz_utility_pub.request_id,
3345: program_application_id = hz_utility_pub.program_application_id,
3346: program_id = hz_utility_pub.program_id,
3339: SET
3340: referenced_party_id = p_to_fk_id,
3341: last_update_date = hz_utility_pub.last_update_date,
3342: last_updated_by = hz_utility_pub.user_id,
3343: last_update_login = hz_utility_pub.last_update_login,
3344: request_id = hz_utility_pub.request_id,
3345: program_application_id = hz_utility_pub.program_application_id,
3346: program_id = hz_utility_pub.program_id,
3347: program_update_date = sysdate
3340: referenced_party_id = p_to_fk_id,
3341: last_update_date = hz_utility_pub.last_update_date,
3342: last_updated_by = hz_utility_pub.user_id,
3343: last_update_login = hz_utility_pub.last_update_login,
3344: request_id = hz_utility_pub.request_id,
3345: program_application_id = hz_utility_pub.program_application_id,
3346: program_id = hz_utility_pub.program_id,
3347: program_update_date = sysdate
3348: WHERE reference_id = p_from_id;
3341: last_update_date = hz_utility_pub.last_update_date,
3342: last_updated_by = hz_utility_pub.user_id,
3343: last_update_login = hz_utility_pub.last_update_login,
3344: request_id = hz_utility_pub.request_id,
3345: program_application_id = hz_utility_pub.program_application_id,
3346: program_id = hz_utility_pub.program_id,
3347: program_update_date = sysdate
3348: WHERE reference_id = p_from_id;
3349:
3342: last_updated_by = hz_utility_pub.user_id,
3343: last_update_login = hz_utility_pub.last_update_login,
3344: request_id = hz_utility_pub.request_id,
3345: program_application_id = hz_utility_pub.program_application_id,
3346: program_id = hz_utility_pub.program_id,
3347: program_update_date = sysdate
3348: WHERE reference_id = p_from_id;
3349:
3350: END IF;
3371: x_to_id <> p_from_id) THEN
3372: UPDATE HZ_CERTIFICATIONS
3373: SET
3374: STATUS = 'M',
3375: last_update_date = hz_utility_pub.last_update_date,
3376: last_updated_by = hz_utility_pub.user_id,
3377: last_update_login = hz_utility_pub.last_update_login,
3378: request_id = hz_utility_pub.request_id,
3379: program_application_id = hz_utility_pub.program_application_id,
3372: UPDATE HZ_CERTIFICATIONS
3373: SET
3374: STATUS = 'M',
3375: last_update_date = hz_utility_pub.last_update_date,
3376: last_updated_by = hz_utility_pub.user_id,
3377: last_update_login = hz_utility_pub.last_update_login,
3378: request_id = hz_utility_pub.request_id,
3379: program_application_id = hz_utility_pub.program_application_id,
3380: program_id = hz_utility_pub.program_id,
3373: SET
3374: STATUS = 'M',
3375: last_update_date = hz_utility_pub.last_update_date,
3376: last_updated_by = hz_utility_pub.user_id,
3377: last_update_login = hz_utility_pub.last_update_login,
3378: request_id = hz_utility_pub.request_id,
3379: program_application_id = hz_utility_pub.program_application_id,
3380: program_id = hz_utility_pub.program_id,
3381: program_update_date = sysdate
3374: STATUS = 'M',
3375: last_update_date = hz_utility_pub.last_update_date,
3376: last_updated_by = hz_utility_pub.user_id,
3377: last_update_login = hz_utility_pub.last_update_login,
3378: request_id = hz_utility_pub.request_id,
3379: program_application_id = hz_utility_pub.program_application_id,
3380: program_id = hz_utility_pub.program_id,
3381: program_update_date = sysdate
3382: WHERE certification_id = p_from_id;
3375: last_update_date = hz_utility_pub.last_update_date,
3376: last_updated_by = hz_utility_pub.user_id,
3377: last_update_login = hz_utility_pub.last_update_login,
3378: request_id = hz_utility_pub.request_id,
3379: program_application_id = hz_utility_pub.program_application_id,
3380: program_id = hz_utility_pub.program_id,
3381: program_update_date = sysdate
3382: WHERE certification_id = p_from_id;
3383: ELSE
3376: last_updated_by = hz_utility_pub.user_id,
3377: last_update_login = hz_utility_pub.last_update_login,
3378: request_id = hz_utility_pub.request_id,
3379: program_application_id = hz_utility_pub.program_application_id,
3380: program_id = hz_utility_pub.program_id,
3381: program_update_date = sysdate
3382: WHERE certification_id = p_from_id;
3383: ELSE
3384: -- Update and set party_id = p_to_fk_id where pk = from_id
3384: -- Update and set party_id = p_to_fk_id where pk = from_id
3385: UPDATE HZ_CERTIFICATIONS
3386: SET
3387: party_id = p_to_fk_id,
3388: last_update_date = hz_utility_pub.last_update_date,
3389: last_updated_by = hz_utility_pub.user_id,
3390: last_update_login = hz_utility_pub.last_update_login,
3391: request_id = hz_utility_pub.request_id,
3392: program_application_id = hz_utility_pub.program_application_id,
3385: UPDATE HZ_CERTIFICATIONS
3386: SET
3387: party_id = p_to_fk_id,
3388: last_update_date = hz_utility_pub.last_update_date,
3389: last_updated_by = hz_utility_pub.user_id,
3390: last_update_login = hz_utility_pub.last_update_login,
3391: request_id = hz_utility_pub.request_id,
3392: program_application_id = hz_utility_pub.program_application_id,
3393: program_id = hz_utility_pub.program_id,
3386: SET
3387: party_id = p_to_fk_id,
3388: last_update_date = hz_utility_pub.last_update_date,
3389: last_updated_by = hz_utility_pub.user_id,
3390: last_update_login = hz_utility_pub.last_update_login,
3391: request_id = hz_utility_pub.request_id,
3392: program_application_id = hz_utility_pub.program_application_id,
3393: program_id = hz_utility_pub.program_id,
3394: program_update_date = sysdate
3387: party_id = p_to_fk_id,
3388: last_update_date = hz_utility_pub.last_update_date,
3389: last_updated_by = hz_utility_pub.user_id,
3390: last_update_login = hz_utility_pub.last_update_login,
3391: request_id = hz_utility_pub.request_id,
3392: program_application_id = hz_utility_pub.program_application_id,
3393: program_id = hz_utility_pub.program_id,
3394: program_update_date = sysdate
3395: WHERE certification_id = p_from_id;
3388: last_update_date = hz_utility_pub.last_update_date,
3389: last_updated_by = hz_utility_pub.user_id,
3390: last_update_login = hz_utility_pub.last_update_login,
3391: request_id = hz_utility_pub.request_id,
3392: program_application_id = hz_utility_pub.program_application_id,
3393: program_id = hz_utility_pub.program_id,
3394: program_update_date = sysdate
3395: WHERE certification_id = p_from_id;
3396:
3389: last_updated_by = hz_utility_pub.user_id,
3390: last_update_login = hz_utility_pub.last_update_login,
3391: request_id = hz_utility_pub.request_id,
3392: program_application_id = hz_utility_pub.program_application_id,
3393: program_id = hz_utility_pub.program_id,
3394: program_update_date = sysdate
3395: WHERE certification_id = p_from_id;
3396:
3397: END IF;
3418: x_to_id <> p_from_id) THEN
3419: UPDATE HZ_CREDIT_RATINGS
3420: SET
3421: STATUS = 'M',
3422: last_update_date = hz_utility_pub.last_update_date,
3423: last_updated_by = hz_utility_pub.user_id,
3424: last_update_login = hz_utility_pub.last_update_login,
3425: request_id = hz_utility_pub.request_id,
3426: program_application_id = hz_utility_pub.program_application_id,
3419: UPDATE HZ_CREDIT_RATINGS
3420: SET
3421: STATUS = 'M',
3422: last_update_date = hz_utility_pub.last_update_date,
3423: last_updated_by = hz_utility_pub.user_id,
3424: last_update_login = hz_utility_pub.last_update_login,
3425: request_id = hz_utility_pub.request_id,
3426: program_application_id = hz_utility_pub.program_application_id,
3427: program_id = hz_utility_pub.program_id,
3420: SET
3421: STATUS = 'M',
3422: last_update_date = hz_utility_pub.last_update_date,
3423: last_updated_by = hz_utility_pub.user_id,
3424: last_update_login = hz_utility_pub.last_update_login,
3425: request_id = hz_utility_pub.request_id,
3426: program_application_id = hz_utility_pub.program_application_id,
3427: program_id = hz_utility_pub.program_id,
3428: program_update_date = sysdate
3421: STATUS = 'M',
3422: last_update_date = hz_utility_pub.last_update_date,
3423: last_updated_by = hz_utility_pub.user_id,
3424: last_update_login = hz_utility_pub.last_update_login,
3425: request_id = hz_utility_pub.request_id,
3426: program_application_id = hz_utility_pub.program_application_id,
3427: program_id = hz_utility_pub.program_id,
3428: program_update_date = sysdate
3429: WHERE credit_rating_id = p_from_id;
3422: last_update_date = hz_utility_pub.last_update_date,
3423: last_updated_by = hz_utility_pub.user_id,
3424: last_update_login = hz_utility_pub.last_update_login,
3425: request_id = hz_utility_pub.request_id,
3426: program_application_id = hz_utility_pub.program_application_id,
3427: program_id = hz_utility_pub.program_id,
3428: program_update_date = sysdate
3429: WHERE credit_rating_id = p_from_id;
3430: ELSE
3423: last_updated_by = hz_utility_pub.user_id,
3424: last_update_login = hz_utility_pub.last_update_login,
3425: request_id = hz_utility_pub.request_id,
3426: program_application_id = hz_utility_pub.program_application_id,
3427: program_id = hz_utility_pub.program_id,
3428: program_update_date = sysdate
3429: WHERE credit_rating_id = p_from_id;
3430: ELSE
3431: -- Update and set party_id = p_to_fk_id where pk = from_id
3431: -- Update and set party_id = p_to_fk_id where pk = from_id
3432: UPDATE HZ_CREDIT_RATINGS
3433: SET
3434: party_id = p_to_fk_id,
3435: last_update_date = hz_utility_pub.last_update_date,
3436: last_updated_by = hz_utility_pub.user_id,
3437: last_update_login = hz_utility_pub.last_update_login,
3438: request_id = hz_utility_pub.request_id,
3439: program_application_id = hz_utility_pub.program_application_id,
3432: UPDATE HZ_CREDIT_RATINGS
3433: SET
3434: party_id = p_to_fk_id,
3435: last_update_date = hz_utility_pub.last_update_date,
3436: last_updated_by = hz_utility_pub.user_id,
3437: last_update_login = hz_utility_pub.last_update_login,
3438: request_id = hz_utility_pub.request_id,
3439: program_application_id = hz_utility_pub.program_application_id,
3440: program_id = hz_utility_pub.program_id,
3433: SET
3434: party_id = p_to_fk_id,
3435: last_update_date = hz_utility_pub.last_update_date,
3436: last_updated_by = hz_utility_pub.user_id,
3437: last_update_login = hz_utility_pub.last_update_login,
3438: request_id = hz_utility_pub.request_id,
3439: program_application_id = hz_utility_pub.program_application_id,
3440: program_id = hz_utility_pub.program_id,
3441: program_update_date = sysdate
3434: party_id = p_to_fk_id,
3435: last_update_date = hz_utility_pub.last_update_date,
3436: last_updated_by = hz_utility_pub.user_id,
3437: last_update_login = hz_utility_pub.last_update_login,
3438: request_id = hz_utility_pub.request_id,
3439: program_application_id = hz_utility_pub.program_application_id,
3440: program_id = hz_utility_pub.program_id,
3441: program_update_date = sysdate
3442: WHERE credit_rating_id = p_from_id;
3435: last_update_date = hz_utility_pub.last_update_date,
3436: last_updated_by = hz_utility_pub.user_id,
3437: last_update_login = hz_utility_pub.last_update_login,
3438: request_id = hz_utility_pub.request_id,
3439: program_application_id = hz_utility_pub.program_application_id,
3440: program_id = hz_utility_pub.program_id,
3441: program_update_date = sysdate
3442: WHERE credit_rating_id = p_from_id;
3443:
3436: last_updated_by = hz_utility_pub.user_id,
3437: last_update_login = hz_utility_pub.last_update_login,
3438: request_id = hz_utility_pub.request_id,
3439: program_application_id = hz_utility_pub.program_application_id,
3440: program_id = hz_utility_pub.program_id,
3441: program_update_date = sysdate
3442: WHERE credit_rating_id = p_from_id;
3443:
3444: END IF;
3465: x_to_id <> p_from_id) THEN
3466: UPDATE HZ_SECURITY_ISSUED
3467: SET
3468: STATUS = 'M',
3469: last_update_date = hz_utility_pub.last_update_date,
3470: last_updated_by = hz_utility_pub.user_id,
3471: last_update_login = hz_utility_pub.last_update_login,
3472: request_id = hz_utility_pub.request_id,
3473: program_application_id = hz_utility_pub.program_application_id,
3466: UPDATE HZ_SECURITY_ISSUED
3467: SET
3468: STATUS = 'M',
3469: last_update_date = hz_utility_pub.last_update_date,
3470: last_updated_by = hz_utility_pub.user_id,
3471: last_update_login = hz_utility_pub.last_update_login,
3472: request_id = hz_utility_pub.request_id,
3473: program_application_id = hz_utility_pub.program_application_id,
3474: program_id = hz_utility_pub.program_id,
3467: SET
3468: STATUS = 'M',
3469: last_update_date = hz_utility_pub.last_update_date,
3470: last_updated_by = hz_utility_pub.user_id,
3471: last_update_login = hz_utility_pub.last_update_login,
3472: request_id = hz_utility_pub.request_id,
3473: program_application_id = hz_utility_pub.program_application_id,
3474: program_id = hz_utility_pub.program_id,
3475: program_update_date = sysdate
3468: STATUS = 'M',
3469: last_update_date = hz_utility_pub.last_update_date,
3470: last_updated_by = hz_utility_pub.user_id,
3471: last_update_login = hz_utility_pub.last_update_login,
3472: request_id = hz_utility_pub.request_id,
3473: program_application_id = hz_utility_pub.program_application_id,
3474: program_id = hz_utility_pub.program_id,
3475: program_update_date = sysdate
3476: WHERE security_issued_id = p_from_id;
3469: last_update_date = hz_utility_pub.last_update_date,
3470: last_updated_by = hz_utility_pub.user_id,
3471: last_update_login = hz_utility_pub.last_update_login,
3472: request_id = hz_utility_pub.request_id,
3473: program_application_id = hz_utility_pub.program_application_id,
3474: program_id = hz_utility_pub.program_id,
3475: program_update_date = sysdate
3476: WHERE security_issued_id = p_from_id;
3477: ELSE
3470: last_updated_by = hz_utility_pub.user_id,
3471: last_update_login = hz_utility_pub.last_update_login,
3472: request_id = hz_utility_pub.request_id,
3473: program_application_id = hz_utility_pub.program_application_id,
3474: program_id = hz_utility_pub.program_id,
3475: program_update_date = sysdate
3476: WHERE security_issued_id = p_from_id;
3477: ELSE
3478: -- Update and set party_id = p_to_fk_id where pk = from_id
3478: -- Update and set party_id = p_to_fk_id where pk = from_id
3479: UPDATE HZ_SECURITY_ISSUED
3480: SET
3481: party_id = p_to_fk_id,
3482: last_update_date = hz_utility_pub.last_update_date,
3483: last_updated_by = hz_utility_pub.user_id,
3484: last_update_login = hz_utility_pub.last_update_login,
3485: request_id = hz_utility_pub.request_id,
3486: program_application_id = hz_utility_pub.program_application_id,
3479: UPDATE HZ_SECURITY_ISSUED
3480: SET
3481: party_id = p_to_fk_id,
3482: last_update_date = hz_utility_pub.last_update_date,
3483: last_updated_by = hz_utility_pub.user_id,
3484: last_update_login = hz_utility_pub.last_update_login,
3485: request_id = hz_utility_pub.request_id,
3486: program_application_id = hz_utility_pub.program_application_id,
3487: program_id = hz_utility_pub.program_id,
3480: SET
3481: party_id = p_to_fk_id,
3482: last_update_date = hz_utility_pub.last_update_date,
3483: last_updated_by = hz_utility_pub.user_id,
3484: last_update_login = hz_utility_pub.last_update_login,
3485: request_id = hz_utility_pub.request_id,
3486: program_application_id = hz_utility_pub.program_application_id,
3487: program_id = hz_utility_pub.program_id,
3488: program_update_date = sysdate
3481: party_id = p_to_fk_id,
3482: last_update_date = hz_utility_pub.last_update_date,
3483: last_updated_by = hz_utility_pub.user_id,
3484: last_update_login = hz_utility_pub.last_update_login,
3485: request_id = hz_utility_pub.request_id,
3486: program_application_id = hz_utility_pub.program_application_id,
3487: program_id = hz_utility_pub.program_id,
3488: program_update_date = sysdate
3489: WHERE security_issued_id = p_from_id;
3482: last_update_date = hz_utility_pub.last_update_date,
3483: last_updated_by = hz_utility_pub.user_id,
3484: last_update_login = hz_utility_pub.last_update_login,
3485: request_id = hz_utility_pub.request_id,
3486: program_application_id = hz_utility_pub.program_application_id,
3487: program_id = hz_utility_pub.program_id,
3488: program_update_date = sysdate
3489: WHERE security_issued_id = p_from_id;
3490:
3483: last_updated_by = hz_utility_pub.user_id,
3484: last_update_login = hz_utility_pub.last_update_login,
3485: request_id = hz_utility_pub.request_id,
3486: program_application_id = hz_utility_pub.program_application_id,
3487: program_id = hz_utility_pub.program_id,
3488: program_update_date = sysdate
3489: WHERE security_issued_id = p_from_id;
3490:
3491: END IF;
3512: x_to_id <> p_from_id) THEN
3513: UPDATE HZ_FINANCIAL_REPORTS
3514: SET
3515: STATUS = 'M',
3516: last_update_date = hz_utility_pub.last_update_date,
3517: last_updated_by = hz_utility_pub.user_id,
3518: last_update_login = hz_utility_pub.last_update_login,
3519: request_id = hz_utility_pub.request_id,
3520: program_application_id = hz_utility_pub.program_application_id,
3513: UPDATE HZ_FINANCIAL_REPORTS
3514: SET
3515: STATUS = 'M',
3516: last_update_date = hz_utility_pub.last_update_date,
3517: last_updated_by = hz_utility_pub.user_id,
3518: last_update_login = hz_utility_pub.last_update_login,
3519: request_id = hz_utility_pub.request_id,
3520: program_application_id = hz_utility_pub.program_application_id,
3521: program_id = hz_utility_pub.program_id,
3514: SET
3515: STATUS = 'M',
3516: last_update_date = hz_utility_pub.last_update_date,
3517: last_updated_by = hz_utility_pub.user_id,
3518: last_update_login = hz_utility_pub.last_update_login,
3519: request_id = hz_utility_pub.request_id,
3520: program_application_id = hz_utility_pub.program_application_id,
3521: program_id = hz_utility_pub.program_id,
3522: program_update_date = sysdate
3515: STATUS = 'M',
3516: last_update_date = hz_utility_pub.last_update_date,
3517: last_updated_by = hz_utility_pub.user_id,
3518: last_update_login = hz_utility_pub.last_update_login,
3519: request_id = hz_utility_pub.request_id,
3520: program_application_id = hz_utility_pub.program_application_id,
3521: program_id = hz_utility_pub.program_id,
3522: program_update_date = sysdate
3523: WHERE financial_report_id = p_from_id;
3516: last_update_date = hz_utility_pub.last_update_date,
3517: last_updated_by = hz_utility_pub.user_id,
3518: last_update_login = hz_utility_pub.last_update_login,
3519: request_id = hz_utility_pub.request_id,
3520: program_application_id = hz_utility_pub.program_application_id,
3521: program_id = hz_utility_pub.program_id,
3522: program_update_date = sysdate
3523: WHERE financial_report_id = p_from_id;
3524: ELSE
3517: last_updated_by = hz_utility_pub.user_id,
3518: last_update_login = hz_utility_pub.last_update_login,
3519: request_id = hz_utility_pub.request_id,
3520: program_application_id = hz_utility_pub.program_application_id,
3521: program_id = hz_utility_pub.program_id,
3522: program_update_date = sysdate
3523: WHERE financial_report_id = p_from_id;
3524: ELSE
3525: -- Update and set party_id = p_to_fk_id where pk = from_id
3525: -- Update and set party_id = p_to_fk_id where pk = from_id
3526: UPDATE HZ_FINANCIAL_REPORTS
3527: SET
3528: party_id = p_to_fk_id,
3529: last_update_date = hz_utility_pub.last_update_date,
3530: last_updated_by = hz_utility_pub.user_id,
3531: last_update_login = hz_utility_pub.last_update_login,
3532: request_id = hz_utility_pub.request_id,
3533: program_application_id = hz_utility_pub.program_application_id,
3526: UPDATE HZ_FINANCIAL_REPORTS
3527: SET
3528: party_id = p_to_fk_id,
3529: last_update_date = hz_utility_pub.last_update_date,
3530: last_updated_by = hz_utility_pub.user_id,
3531: last_update_login = hz_utility_pub.last_update_login,
3532: request_id = hz_utility_pub.request_id,
3533: program_application_id = hz_utility_pub.program_application_id,
3534: program_id = hz_utility_pub.program_id,
3527: SET
3528: party_id = p_to_fk_id,
3529: last_update_date = hz_utility_pub.last_update_date,
3530: last_updated_by = hz_utility_pub.user_id,
3531: last_update_login = hz_utility_pub.last_update_login,
3532: request_id = hz_utility_pub.request_id,
3533: program_application_id = hz_utility_pub.program_application_id,
3534: program_id = hz_utility_pub.program_id,
3535: program_update_date = sysdate
3528: party_id = p_to_fk_id,
3529: last_update_date = hz_utility_pub.last_update_date,
3530: last_updated_by = hz_utility_pub.user_id,
3531: last_update_login = hz_utility_pub.last_update_login,
3532: request_id = hz_utility_pub.request_id,
3533: program_application_id = hz_utility_pub.program_application_id,
3534: program_id = hz_utility_pub.program_id,
3535: program_update_date = sysdate
3536: WHERE financial_report_id = p_from_id;
3529: last_update_date = hz_utility_pub.last_update_date,
3530: last_updated_by = hz_utility_pub.user_id,
3531: last_update_login = hz_utility_pub.last_update_login,
3532: request_id = hz_utility_pub.request_id,
3533: program_application_id = hz_utility_pub.program_application_id,
3534: program_id = hz_utility_pub.program_id,
3535: program_update_date = sysdate
3536: WHERE financial_report_id = p_from_id;
3537:
3530: last_updated_by = hz_utility_pub.user_id,
3531: last_update_login = hz_utility_pub.last_update_login,
3532: request_id = hz_utility_pub.request_id,
3533: program_application_id = hz_utility_pub.program_application_id,
3534: program_id = hz_utility_pub.program_id,
3535: program_update_date = sysdate
3536: WHERE financial_report_id = p_from_id;
3537:
3538: END IF;
3559: x_to_id <> p_from_id) THEN
3560: UPDATE HZ_ORGANIZATION_INDICATORS
3561: SET
3562: STATUS = 'M',
3563: last_update_date = hz_utility_pub.last_update_date,
3564: last_updated_by = hz_utility_pub.user_id,
3565: last_update_login = hz_utility_pub.last_update_login,
3566: request_id = hz_utility_pub.request_id,
3567: program_application_id = hz_utility_pub.program_application_id,
3560: UPDATE HZ_ORGANIZATION_INDICATORS
3561: SET
3562: STATUS = 'M',
3563: last_update_date = hz_utility_pub.last_update_date,
3564: last_updated_by = hz_utility_pub.user_id,
3565: last_update_login = hz_utility_pub.last_update_login,
3566: request_id = hz_utility_pub.request_id,
3567: program_application_id = hz_utility_pub.program_application_id,
3568: program_id = hz_utility_pub.program_id,
3561: SET
3562: STATUS = 'M',
3563: last_update_date = hz_utility_pub.last_update_date,
3564: last_updated_by = hz_utility_pub.user_id,
3565: last_update_login = hz_utility_pub.last_update_login,
3566: request_id = hz_utility_pub.request_id,
3567: program_application_id = hz_utility_pub.program_application_id,
3568: program_id = hz_utility_pub.program_id,
3569: program_update_date = sysdate
3562: STATUS = 'M',
3563: last_update_date = hz_utility_pub.last_update_date,
3564: last_updated_by = hz_utility_pub.user_id,
3565: last_update_login = hz_utility_pub.last_update_login,
3566: request_id = hz_utility_pub.request_id,
3567: program_application_id = hz_utility_pub.program_application_id,
3568: program_id = hz_utility_pub.program_id,
3569: program_update_date = sysdate
3570: WHERE organization_indicator_id = p_from_id;
3563: last_update_date = hz_utility_pub.last_update_date,
3564: last_updated_by = hz_utility_pub.user_id,
3565: last_update_login = hz_utility_pub.last_update_login,
3566: request_id = hz_utility_pub.request_id,
3567: program_application_id = hz_utility_pub.program_application_id,
3568: program_id = hz_utility_pub.program_id,
3569: program_update_date = sysdate
3570: WHERE organization_indicator_id = p_from_id;
3571: ELSE
3564: last_updated_by = hz_utility_pub.user_id,
3565: last_update_login = hz_utility_pub.last_update_login,
3566: request_id = hz_utility_pub.request_id,
3567: program_application_id = hz_utility_pub.program_application_id,
3568: program_id = hz_utility_pub.program_id,
3569: program_update_date = sysdate
3570: WHERE organization_indicator_id = p_from_id;
3571: ELSE
3572: -- Update and set party_id = p_to_fk_id where pk = from_id
3572: -- Update and set party_id = p_to_fk_id where pk = from_id
3573: UPDATE HZ_ORGANIZATION_INDICATORS
3574: SET
3575: party_id = p_to_fk_id,
3576: last_update_date = hz_utility_pub.last_update_date,
3577: last_updated_by = hz_utility_pub.user_id,
3578: last_update_login = hz_utility_pub.last_update_login,
3579: request_id = hz_utility_pub.request_id,
3580: program_application_id = hz_utility_pub.program_application_id,
3573: UPDATE HZ_ORGANIZATION_INDICATORS
3574: SET
3575: party_id = p_to_fk_id,
3576: last_update_date = hz_utility_pub.last_update_date,
3577: last_updated_by = hz_utility_pub.user_id,
3578: last_update_login = hz_utility_pub.last_update_login,
3579: request_id = hz_utility_pub.request_id,
3580: program_application_id = hz_utility_pub.program_application_id,
3581: program_id = hz_utility_pub.program_id,
3574: SET
3575: party_id = p_to_fk_id,
3576: last_update_date = hz_utility_pub.last_update_date,
3577: last_updated_by = hz_utility_pub.user_id,
3578: last_update_login = hz_utility_pub.last_update_login,
3579: request_id = hz_utility_pub.request_id,
3580: program_application_id = hz_utility_pub.program_application_id,
3581: program_id = hz_utility_pub.program_id,
3582: program_update_date = sysdate
3575: party_id = p_to_fk_id,
3576: last_update_date = hz_utility_pub.last_update_date,
3577: last_updated_by = hz_utility_pub.user_id,
3578: last_update_login = hz_utility_pub.last_update_login,
3579: request_id = hz_utility_pub.request_id,
3580: program_application_id = hz_utility_pub.program_application_id,
3581: program_id = hz_utility_pub.program_id,
3582: program_update_date = sysdate
3583: WHERE organization_indicator_id = p_from_id;
3576: last_update_date = hz_utility_pub.last_update_date,
3577: last_updated_by = hz_utility_pub.user_id,
3578: last_update_login = hz_utility_pub.last_update_login,
3579: request_id = hz_utility_pub.request_id,
3580: program_application_id = hz_utility_pub.program_application_id,
3581: program_id = hz_utility_pub.program_id,
3582: program_update_date = sysdate
3583: WHERE organization_indicator_id = p_from_id;
3584:
3577: last_updated_by = hz_utility_pub.user_id,
3578: last_update_login = hz_utility_pub.last_update_login,
3579: request_id = hz_utility_pub.request_id,
3580: program_application_id = hz_utility_pub.program_application_id,
3581: program_id = hz_utility_pub.program_id,
3582: program_update_date = sysdate
3583: WHERE organization_indicator_id = p_from_id;
3584:
3585: END IF;
3606: x_to_id <> p_from_id) THEN
3607: UPDATE HZ_INDUSTRIAL_REFERENCE
3608: SET
3609: STATUS = 'M',
3610: last_update_date = hz_utility_pub.last_update_date,
3611: last_updated_by = hz_utility_pub.user_id,
3612: last_update_login = hz_utility_pub.last_update_login,
3613: request_id = hz_utility_pub.request_id,
3614: program_application_id = hz_utility_pub.program_application_id,
3607: UPDATE HZ_INDUSTRIAL_REFERENCE
3608: SET
3609: STATUS = 'M',
3610: last_update_date = hz_utility_pub.last_update_date,
3611: last_updated_by = hz_utility_pub.user_id,
3612: last_update_login = hz_utility_pub.last_update_login,
3613: request_id = hz_utility_pub.request_id,
3614: program_application_id = hz_utility_pub.program_application_id,
3615: program_id = hz_utility_pub.program_id,
3608: SET
3609: STATUS = 'M',
3610: last_update_date = hz_utility_pub.last_update_date,
3611: last_updated_by = hz_utility_pub.user_id,
3612: last_update_login = hz_utility_pub.last_update_login,
3613: request_id = hz_utility_pub.request_id,
3614: program_application_id = hz_utility_pub.program_application_id,
3615: program_id = hz_utility_pub.program_id,
3616: program_update_date = sysdate
3609: STATUS = 'M',
3610: last_update_date = hz_utility_pub.last_update_date,
3611: last_updated_by = hz_utility_pub.user_id,
3612: last_update_login = hz_utility_pub.last_update_login,
3613: request_id = hz_utility_pub.request_id,
3614: program_application_id = hz_utility_pub.program_application_id,
3615: program_id = hz_utility_pub.program_id,
3616: program_update_date = sysdate
3617: WHERE industry_reference_id = p_from_id;
3610: last_update_date = hz_utility_pub.last_update_date,
3611: last_updated_by = hz_utility_pub.user_id,
3612: last_update_login = hz_utility_pub.last_update_login,
3613: request_id = hz_utility_pub.request_id,
3614: program_application_id = hz_utility_pub.program_application_id,
3615: program_id = hz_utility_pub.program_id,
3616: program_update_date = sysdate
3617: WHERE industry_reference_id = p_from_id;
3618: ELSE
3611: last_updated_by = hz_utility_pub.user_id,
3612: last_update_login = hz_utility_pub.last_update_login,
3613: request_id = hz_utility_pub.request_id,
3614: program_application_id = hz_utility_pub.program_application_id,
3615: program_id = hz_utility_pub.program_id,
3616: program_update_date = sysdate
3617: WHERE industry_reference_id = p_from_id;
3618: ELSE
3619: -- Update and set party_id = p_to_fk_id where pk = from_id
3619: -- Update and set party_id = p_to_fk_id where pk = from_id
3620: UPDATE HZ_INDUSTRIAL_REFERENCE
3621: SET
3622: party_id = p_to_fk_id,
3623: last_update_date = hz_utility_pub.last_update_date,
3624: last_updated_by = hz_utility_pub.user_id,
3625: last_update_login = hz_utility_pub.last_update_login,
3626: request_id = hz_utility_pub.request_id,
3627: program_application_id = hz_utility_pub.program_application_id,
3620: UPDATE HZ_INDUSTRIAL_REFERENCE
3621: SET
3622: party_id = p_to_fk_id,
3623: last_update_date = hz_utility_pub.last_update_date,
3624: last_updated_by = hz_utility_pub.user_id,
3625: last_update_login = hz_utility_pub.last_update_login,
3626: request_id = hz_utility_pub.request_id,
3627: program_application_id = hz_utility_pub.program_application_id,
3628: program_id = hz_utility_pub.program_id,
3621: SET
3622: party_id = p_to_fk_id,
3623: last_update_date = hz_utility_pub.last_update_date,
3624: last_updated_by = hz_utility_pub.user_id,
3625: last_update_login = hz_utility_pub.last_update_login,
3626: request_id = hz_utility_pub.request_id,
3627: program_application_id = hz_utility_pub.program_application_id,
3628: program_id = hz_utility_pub.program_id,
3629: program_update_date = sysdate
3622: party_id = p_to_fk_id,
3623: last_update_date = hz_utility_pub.last_update_date,
3624: last_updated_by = hz_utility_pub.user_id,
3625: last_update_login = hz_utility_pub.last_update_login,
3626: request_id = hz_utility_pub.request_id,
3627: program_application_id = hz_utility_pub.program_application_id,
3628: program_id = hz_utility_pub.program_id,
3629: program_update_date = sysdate
3630: WHERE industry_reference_id = p_from_id;
3623: last_update_date = hz_utility_pub.last_update_date,
3624: last_updated_by = hz_utility_pub.user_id,
3625: last_update_login = hz_utility_pub.last_update_login,
3626: request_id = hz_utility_pub.request_id,
3627: program_application_id = hz_utility_pub.program_application_id,
3628: program_id = hz_utility_pub.program_id,
3629: program_update_date = sysdate
3630: WHERE industry_reference_id = p_from_id;
3631:
3624: last_updated_by = hz_utility_pub.user_id,
3625: last_update_login = hz_utility_pub.last_update_login,
3626: request_id = hz_utility_pub.request_id,
3627: program_application_id = hz_utility_pub.program_application_id,
3628: program_id = hz_utility_pub.program_id,
3629: program_update_date = sysdate
3630: WHERE industry_reference_id = p_from_id;
3631:
3632: END IF;
3653: x_to_id <> p_from_id) THEN
3654: UPDATE HZ_PERSON_INTEREST
3655: SET
3656: STATUS = 'M',
3657: last_update_date = hz_utility_pub.last_update_date,
3658: last_updated_by = hz_utility_pub.user_id,
3659: last_update_login = hz_utility_pub.last_update_login,
3660: request_id = hz_utility_pub.request_id,
3661: program_application_id = hz_utility_pub.program_application_id,
3654: UPDATE HZ_PERSON_INTEREST
3655: SET
3656: STATUS = 'M',
3657: last_update_date = hz_utility_pub.last_update_date,
3658: last_updated_by = hz_utility_pub.user_id,
3659: last_update_login = hz_utility_pub.last_update_login,
3660: request_id = hz_utility_pub.request_id,
3661: program_application_id = hz_utility_pub.program_application_id,
3662: program_id = hz_utility_pub.program_id,
3655: SET
3656: STATUS = 'M',
3657: last_update_date = hz_utility_pub.last_update_date,
3658: last_updated_by = hz_utility_pub.user_id,
3659: last_update_login = hz_utility_pub.last_update_login,
3660: request_id = hz_utility_pub.request_id,
3661: program_application_id = hz_utility_pub.program_application_id,
3662: program_id = hz_utility_pub.program_id,
3663: program_update_date = sysdate
3656: STATUS = 'M',
3657: last_update_date = hz_utility_pub.last_update_date,
3658: last_updated_by = hz_utility_pub.user_id,
3659: last_update_login = hz_utility_pub.last_update_login,
3660: request_id = hz_utility_pub.request_id,
3661: program_application_id = hz_utility_pub.program_application_id,
3662: program_id = hz_utility_pub.program_id,
3663: program_update_date = sysdate
3664: WHERE person_interest_id = p_from_id;
3657: last_update_date = hz_utility_pub.last_update_date,
3658: last_updated_by = hz_utility_pub.user_id,
3659: last_update_login = hz_utility_pub.last_update_login,
3660: request_id = hz_utility_pub.request_id,
3661: program_application_id = hz_utility_pub.program_application_id,
3662: program_id = hz_utility_pub.program_id,
3663: program_update_date = sysdate
3664: WHERE person_interest_id = p_from_id;
3665: ELSE
3658: last_updated_by = hz_utility_pub.user_id,
3659: last_update_login = hz_utility_pub.last_update_login,
3660: request_id = hz_utility_pub.request_id,
3661: program_application_id = hz_utility_pub.program_application_id,
3662: program_id = hz_utility_pub.program_id,
3663: program_update_date = sysdate
3664: WHERE person_interest_id = p_from_id;
3665: ELSE
3666: -- Update and set party_id = p_to_fk_id where pk = from_id
3666: -- Update and set party_id = p_to_fk_id where pk = from_id
3667: UPDATE HZ_PERSON_INTEREST
3668: SET
3669: party_id = p_to_fk_id,
3670: last_update_date = hz_utility_pub.last_update_date,
3671: last_updated_by = hz_utility_pub.user_id,
3672: last_update_login = hz_utility_pub.last_update_login,
3673: request_id = hz_utility_pub.request_id,
3674: program_application_id = hz_utility_pub.program_application_id,
3667: UPDATE HZ_PERSON_INTEREST
3668: SET
3669: party_id = p_to_fk_id,
3670: last_update_date = hz_utility_pub.last_update_date,
3671: last_updated_by = hz_utility_pub.user_id,
3672: last_update_login = hz_utility_pub.last_update_login,
3673: request_id = hz_utility_pub.request_id,
3674: program_application_id = hz_utility_pub.program_application_id,
3675: program_id = hz_utility_pub.program_id,
3668: SET
3669: party_id = p_to_fk_id,
3670: last_update_date = hz_utility_pub.last_update_date,
3671: last_updated_by = hz_utility_pub.user_id,
3672: last_update_login = hz_utility_pub.last_update_login,
3673: request_id = hz_utility_pub.request_id,
3674: program_application_id = hz_utility_pub.program_application_id,
3675: program_id = hz_utility_pub.program_id,
3676: program_update_date = sysdate
3669: party_id = p_to_fk_id,
3670: last_update_date = hz_utility_pub.last_update_date,
3671: last_updated_by = hz_utility_pub.user_id,
3672: last_update_login = hz_utility_pub.last_update_login,
3673: request_id = hz_utility_pub.request_id,
3674: program_application_id = hz_utility_pub.program_application_id,
3675: program_id = hz_utility_pub.program_id,
3676: program_update_date = sysdate
3677: WHERE person_interest_id = p_from_id;
3670: last_update_date = hz_utility_pub.last_update_date,
3671: last_updated_by = hz_utility_pub.user_id,
3672: last_update_login = hz_utility_pub.last_update_login,
3673: request_id = hz_utility_pub.request_id,
3674: program_application_id = hz_utility_pub.program_application_id,
3675: program_id = hz_utility_pub.program_id,
3676: program_update_date = sysdate
3677: WHERE person_interest_id = p_from_id;
3678:
3671: last_updated_by = hz_utility_pub.user_id,
3672: last_update_login = hz_utility_pub.last_update_login,
3673: request_id = hz_utility_pub.request_id,
3674: program_application_id = hz_utility_pub.program_application_id,
3675: program_id = hz_utility_pub.program_id,
3676: program_update_date = sysdate
3677: WHERE person_interest_id = p_from_id;
3678:
3679: END IF;
3700: x_to_id <> p_from_id) THEN
3701: UPDATE HZ_CITIZENSHIP
3702: SET
3703: STATUS = 'M',
3704: last_update_date = hz_utility_pub.last_update_date,
3705: last_updated_by = hz_utility_pub.user_id,
3706: last_update_login = hz_utility_pub.last_update_login,
3707: request_id = hz_utility_pub.request_id,
3708: program_application_id = hz_utility_pub.program_application_id,
3701: UPDATE HZ_CITIZENSHIP
3702: SET
3703: STATUS = 'M',
3704: last_update_date = hz_utility_pub.last_update_date,
3705: last_updated_by = hz_utility_pub.user_id,
3706: last_update_login = hz_utility_pub.last_update_login,
3707: request_id = hz_utility_pub.request_id,
3708: program_application_id = hz_utility_pub.program_application_id,
3709: program_id = hz_utility_pub.program_id,
3702: SET
3703: STATUS = 'M',
3704: last_update_date = hz_utility_pub.last_update_date,
3705: last_updated_by = hz_utility_pub.user_id,
3706: last_update_login = hz_utility_pub.last_update_login,
3707: request_id = hz_utility_pub.request_id,
3708: program_application_id = hz_utility_pub.program_application_id,
3709: program_id = hz_utility_pub.program_id,
3710: program_update_date = sysdate
3703: STATUS = 'M',
3704: last_update_date = hz_utility_pub.last_update_date,
3705: last_updated_by = hz_utility_pub.user_id,
3706: last_update_login = hz_utility_pub.last_update_login,
3707: request_id = hz_utility_pub.request_id,
3708: program_application_id = hz_utility_pub.program_application_id,
3709: program_id = hz_utility_pub.program_id,
3710: program_update_date = sysdate
3711: WHERE citizenship_id = p_from_id;
3704: last_update_date = hz_utility_pub.last_update_date,
3705: last_updated_by = hz_utility_pub.user_id,
3706: last_update_login = hz_utility_pub.last_update_login,
3707: request_id = hz_utility_pub.request_id,
3708: program_application_id = hz_utility_pub.program_application_id,
3709: program_id = hz_utility_pub.program_id,
3710: program_update_date = sysdate
3711: WHERE citizenship_id = p_from_id;
3712: ELSE
3705: last_updated_by = hz_utility_pub.user_id,
3706: last_update_login = hz_utility_pub.last_update_login,
3707: request_id = hz_utility_pub.request_id,
3708: program_application_id = hz_utility_pub.program_application_id,
3709: program_id = hz_utility_pub.program_id,
3710: program_update_date = sysdate
3711: WHERE citizenship_id = p_from_id;
3712: ELSE
3713: -- Update and set party_id = p_to_fk_id where pk = from_id
3713: -- Update and set party_id = p_to_fk_id where pk = from_id
3714: UPDATE HZ_CITIZENSHIP
3715: SET
3716: party_id = p_to_fk_id,
3717: last_update_date = hz_utility_pub.last_update_date,
3718: last_updated_by = hz_utility_pub.user_id,
3719: last_update_login = hz_utility_pub.last_update_login,
3720: request_id = hz_utility_pub.request_id,
3721: program_application_id = hz_utility_pub.program_application_id,
3714: UPDATE HZ_CITIZENSHIP
3715: SET
3716: party_id = p_to_fk_id,
3717: last_update_date = hz_utility_pub.last_update_date,
3718: last_updated_by = hz_utility_pub.user_id,
3719: last_update_login = hz_utility_pub.last_update_login,
3720: request_id = hz_utility_pub.request_id,
3721: program_application_id = hz_utility_pub.program_application_id,
3722: program_id = hz_utility_pub.program_id,
3715: SET
3716: party_id = p_to_fk_id,
3717: last_update_date = hz_utility_pub.last_update_date,
3718: last_updated_by = hz_utility_pub.user_id,
3719: last_update_login = hz_utility_pub.last_update_login,
3720: request_id = hz_utility_pub.request_id,
3721: program_application_id = hz_utility_pub.program_application_id,
3722: program_id = hz_utility_pub.program_id,
3723: program_update_date = sysdate
3716: party_id = p_to_fk_id,
3717: last_update_date = hz_utility_pub.last_update_date,
3718: last_updated_by = hz_utility_pub.user_id,
3719: last_update_login = hz_utility_pub.last_update_login,
3720: request_id = hz_utility_pub.request_id,
3721: program_application_id = hz_utility_pub.program_application_id,
3722: program_id = hz_utility_pub.program_id,
3723: program_update_date = sysdate
3724: WHERE citizenship_id = p_from_id;
3717: last_update_date = hz_utility_pub.last_update_date,
3718: last_updated_by = hz_utility_pub.user_id,
3719: last_update_login = hz_utility_pub.last_update_login,
3720: request_id = hz_utility_pub.request_id,
3721: program_application_id = hz_utility_pub.program_application_id,
3722: program_id = hz_utility_pub.program_id,
3723: program_update_date = sysdate
3724: WHERE citizenship_id = p_from_id;
3725:
3718: last_updated_by = hz_utility_pub.user_id,
3719: last_update_login = hz_utility_pub.last_update_login,
3720: request_id = hz_utility_pub.request_id,
3721: program_application_id = hz_utility_pub.program_application_id,
3722: program_id = hz_utility_pub.program_id,
3723: program_update_date = sysdate
3724: WHERE citizenship_id = p_from_id;
3725:
3726: END IF;
3747: x_to_id <> p_from_id) THEN
3748: UPDATE HZ_EDUCATION
3749: SET
3750: STATUS = 'M',
3751: last_update_date = hz_utility_pub.last_update_date,
3752: last_updated_by = hz_utility_pub.user_id,
3753: last_update_login = hz_utility_pub.last_update_login,
3754: request_id = hz_utility_pub.request_id,
3755: program_application_id = hz_utility_pub.program_application_id,
3748: UPDATE HZ_EDUCATION
3749: SET
3750: STATUS = 'M',
3751: last_update_date = hz_utility_pub.last_update_date,
3752: last_updated_by = hz_utility_pub.user_id,
3753: last_update_login = hz_utility_pub.last_update_login,
3754: request_id = hz_utility_pub.request_id,
3755: program_application_id = hz_utility_pub.program_application_id,
3756: program_id = hz_utility_pub.program_id,
3749: SET
3750: STATUS = 'M',
3751: last_update_date = hz_utility_pub.last_update_date,
3752: last_updated_by = hz_utility_pub.user_id,
3753: last_update_login = hz_utility_pub.last_update_login,
3754: request_id = hz_utility_pub.request_id,
3755: program_application_id = hz_utility_pub.program_application_id,
3756: program_id = hz_utility_pub.program_id,
3757: program_update_date = sysdate
3750: STATUS = 'M',
3751: last_update_date = hz_utility_pub.last_update_date,
3752: last_updated_by = hz_utility_pub.user_id,
3753: last_update_login = hz_utility_pub.last_update_login,
3754: request_id = hz_utility_pub.request_id,
3755: program_application_id = hz_utility_pub.program_application_id,
3756: program_id = hz_utility_pub.program_id,
3757: program_update_date = sysdate
3758: WHERE education_id = p_from_id;
3751: last_update_date = hz_utility_pub.last_update_date,
3752: last_updated_by = hz_utility_pub.user_id,
3753: last_update_login = hz_utility_pub.last_update_login,
3754: request_id = hz_utility_pub.request_id,
3755: program_application_id = hz_utility_pub.program_application_id,
3756: program_id = hz_utility_pub.program_id,
3757: program_update_date = sysdate
3758: WHERE education_id = p_from_id;
3759: ELSE
3752: last_updated_by = hz_utility_pub.user_id,
3753: last_update_login = hz_utility_pub.last_update_login,
3754: request_id = hz_utility_pub.request_id,
3755: program_application_id = hz_utility_pub.program_application_id,
3756: program_id = hz_utility_pub.program_id,
3757: program_update_date = sysdate
3758: WHERE education_id = p_from_id;
3759: ELSE
3760: -- Update and set party_id = p_to_fk_id where pk = from_id
3760: -- Update and set party_id = p_to_fk_id where pk = from_id
3761: UPDATE HZ_EDUCATION
3762: SET
3763: party_id = p_to_fk_id,
3764: last_update_date = hz_utility_pub.last_update_date,
3765: last_updated_by = hz_utility_pub.user_id,
3766: last_update_login = hz_utility_pub.last_update_login,
3767: request_id = hz_utility_pub.request_id,
3768: program_application_id = hz_utility_pub.program_application_id,
3761: UPDATE HZ_EDUCATION
3762: SET
3763: party_id = p_to_fk_id,
3764: last_update_date = hz_utility_pub.last_update_date,
3765: last_updated_by = hz_utility_pub.user_id,
3766: last_update_login = hz_utility_pub.last_update_login,
3767: request_id = hz_utility_pub.request_id,
3768: program_application_id = hz_utility_pub.program_application_id,
3769: program_id = hz_utility_pub.program_id,
3762: SET
3763: party_id = p_to_fk_id,
3764: last_update_date = hz_utility_pub.last_update_date,
3765: last_updated_by = hz_utility_pub.user_id,
3766: last_update_login = hz_utility_pub.last_update_login,
3767: request_id = hz_utility_pub.request_id,
3768: program_application_id = hz_utility_pub.program_application_id,
3769: program_id = hz_utility_pub.program_id,
3770: program_update_date = sysdate
3763: party_id = p_to_fk_id,
3764: last_update_date = hz_utility_pub.last_update_date,
3765: last_updated_by = hz_utility_pub.user_id,
3766: last_update_login = hz_utility_pub.last_update_login,
3767: request_id = hz_utility_pub.request_id,
3768: program_application_id = hz_utility_pub.program_application_id,
3769: program_id = hz_utility_pub.program_id,
3770: program_update_date = sysdate
3771: WHERE education_id = p_from_id;
3764: last_update_date = hz_utility_pub.last_update_date,
3765: last_updated_by = hz_utility_pub.user_id,
3766: last_update_login = hz_utility_pub.last_update_login,
3767: request_id = hz_utility_pub.request_id,
3768: program_application_id = hz_utility_pub.program_application_id,
3769: program_id = hz_utility_pub.program_id,
3770: program_update_date = sysdate
3771: WHERE education_id = p_from_id;
3772:
3765: last_updated_by = hz_utility_pub.user_id,
3766: last_update_login = hz_utility_pub.last_update_login,
3767: request_id = hz_utility_pub.request_id,
3768: program_application_id = hz_utility_pub.program_application_id,
3769: program_id = hz_utility_pub.program_id,
3770: program_update_date = sysdate
3771: WHERE education_id = p_from_id;
3772:
3773: END IF;
3794: x_to_id <> p_from_id) THEN
3795: UPDATE HZ_EDUCATION
3796: SET
3797: STATUS = 'M',
3798: last_update_date = hz_utility_pub.last_update_date,
3799: last_updated_by = hz_utility_pub.user_id,
3800: last_update_login = hz_utility_pub.last_update_login,
3801: request_id = hz_utility_pub.request_id,
3802: program_application_id = hz_utility_pub.program_application_id,
3795: UPDATE HZ_EDUCATION
3796: SET
3797: STATUS = 'M',
3798: last_update_date = hz_utility_pub.last_update_date,
3799: last_updated_by = hz_utility_pub.user_id,
3800: last_update_login = hz_utility_pub.last_update_login,
3801: request_id = hz_utility_pub.request_id,
3802: program_application_id = hz_utility_pub.program_application_id,
3803: program_id = hz_utility_pub.program_id,
3796: SET
3797: STATUS = 'M',
3798: last_update_date = hz_utility_pub.last_update_date,
3799: last_updated_by = hz_utility_pub.user_id,
3800: last_update_login = hz_utility_pub.last_update_login,
3801: request_id = hz_utility_pub.request_id,
3802: program_application_id = hz_utility_pub.program_application_id,
3803: program_id = hz_utility_pub.program_id,
3804: program_update_date = sysdate
3797: STATUS = 'M',
3798: last_update_date = hz_utility_pub.last_update_date,
3799: last_updated_by = hz_utility_pub.user_id,
3800: last_update_login = hz_utility_pub.last_update_login,
3801: request_id = hz_utility_pub.request_id,
3802: program_application_id = hz_utility_pub.program_application_id,
3803: program_id = hz_utility_pub.program_id,
3804: program_update_date = sysdate
3805: WHERE education_id = p_from_id;
3798: last_update_date = hz_utility_pub.last_update_date,
3799: last_updated_by = hz_utility_pub.user_id,
3800: last_update_login = hz_utility_pub.last_update_login,
3801: request_id = hz_utility_pub.request_id,
3802: program_application_id = hz_utility_pub.program_application_id,
3803: program_id = hz_utility_pub.program_id,
3804: program_update_date = sysdate
3805: WHERE education_id = p_from_id;
3806: ELSE
3799: last_updated_by = hz_utility_pub.user_id,
3800: last_update_login = hz_utility_pub.last_update_login,
3801: request_id = hz_utility_pub.request_id,
3802: program_application_id = hz_utility_pub.program_application_id,
3803: program_id = hz_utility_pub.program_id,
3804: program_update_date = sysdate
3805: WHERE education_id = p_from_id;
3806: ELSE
3807: -- Update and set party_id = p_to_fk_id where pk = from_id
3807: -- Update and set party_id = p_to_fk_id where pk = from_id
3808: UPDATE HZ_EDUCATION
3809: SET
3810: school_party_id = p_to_fk_id,
3811: last_update_date = hz_utility_pub.last_update_date,
3812: last_updated_by = hz_utility_pub.user_id,
3813: last_update_login = hz_utility_pub.last_update_login,
3814: request_id = hz_utility_pub.request_id,
3815: program_application_id = hz_utility_pub.program_application_id,
3808: UPDATE HZ_EDUCATION
3809: SET
3810: school_party_id = p_to_fk_id,
3811: last_update_date = hz_utility_pub.last_update_date,
3812: last_updated_by = hz_utility_pub.user_id,
3813: last_update_login = hz_utility_pub.last_update_login,
3814: request_id = hz_utility_pub.request_id,
3815: program_application_id = hz_utility_pub.program_application_id,
3816: program_id = hz_utility_pub.program_id,
3809: SET
3810: school_party_id = p_to_fk_id,
3811: last_update_date = hz_utility_pub.last_update_date,
3812: last_updated_by = hz_utility_pub.user_id,
3813: last_update_login = hz_utility_pub.last_update_login,
3814: request_id = hz_utility_pub.request_id,
3815: program_application_id = hz_utility_pub.program_application_id,
3816: program_id = hz_utility_pub.program_id,
3817: program_update_date = sysdate
3810: school_party_id = p_to_fk_id,
3811: last_update_date = hz_utility_pub.last_update_date,
3812: last_updated_by = hz_utility_pub.user_id,
3813: last_update_login = hz_utility_pub.last_update_login,
3814: request_id = hz_utility_pub.request_id,
3815: program_application_id = hz_utility_pub.program_application_id,
3816: program_id = hz_utility_pub.program_id,
3817: program_update_date = sysdate
3818: WHERE education_id = p_from_id;
3811: last_update_date = hz_utility_pub.last_update_date,
3812: last_updated_by = hz_utility_pub.user_id,
3813: last_update_login = hz_utility_pub.last_update_login,
3814: request_id = hz_utility_pub.request_id,
3815: program_application_id = hz_utility_pub.program_application_id,
3816: program_id = hz_utility_pub.program_id,
3817: program_update_date = sysdate
3818: WHERE education_id = p_from_id;
3819:
3812: last_updated_by = hz_utility_pub.user_id,
3813: last_update_login = hz_utility_pub.last_update_login,
3814: request_id = hz_utility_pub.request_id,
3815: program_application_id = hz_utility_pub.program_application_id,
3816: program_id = hz_utility_pub.program_id,
3817: program_update_date = sysdate
3818: WHERE education_id = p_from_id;
3819:
3820: END IF;
3842: x_to_id <> p_from_id) THEN
3843: UPDATE HZ_EMPLOYMENT_HISTORY
3844: SET
3845: STATUS = 'M',
3846: last_update_date = hz_utility_pub.last_update_date,
3847: last_updated_by = hz_utility_pub.user_id,
3848: last_update_login = hz_utility_pub.last_update_login,
3849: request_id = hz_utility_pub.request_id,
3850: program_application_id = hz_utility_pub.program_application_id,
3843: UPDATE HZ_EMPLOYMENT_HISTORY
3844: SET
3845: STATUS = 'M',
3846: last_update_date = hz_utility_pub.last_update_date,
3847: last_updated_by = hz_utility_pub.user_id,
3848: last_update_login = hz_utility_pub.last_update_login,
3849: request_id = hz_utility_pub.request_id,
3850: program_application_id = hz_utility_pub.program_application_id,
3851: program_id = hz_utility_pub.program_id,
3844: SET
3845: STATUS = 'M',
3846: last_update_date = hz_utility_pub.last_update_date,
3847: last_updated_by = hz_utility_pub.user_id,
3848: last_update_login = hz_utility_pub.last_update_login,
3849: request_id = hz_utility_pub.request_id,
3850: program_application_id = hz_utility_pub.program_application_id,
3851: program_id = hz_utility_pub.program_id,
3852: program_update_date = sysdate
3845: STATUS = 'M',
3846: last_update_date = hz_utility_pub.last_update_date,
3847: last_updated_by = hz_utility_pub.user_id,
3848: last_update_login = hz_utility_pub.last_update_login,
3849: request_id = hz_utility_pub.request_id,
3850: program_application_id = hz_utility_pub.program_application_id,
3851: program_id = hz_utility_pub.program_id,
3852: program_update_date = sysdate
3853: WHERE employment_history_id = p_from_id;
3846: last_update_date = hz_utility_pub.last_update_date,
3847: last_updated_by = hz_utility_pub.user_id,
3848: last_update_login = hz_utility_pub.last_update_login,
3849: request_id = hz_utility_pub.request_id,
3850: program_application_id = hz_utility_pub.program_application_id,
3851: program_id = hz_utility_pub.program_id,
3852: program_update_date = sysdate
3853: WHERE employment_history_id = p_from_id;
3854: ELSE
3847: last_updated_by = hz_utility_pub.user_id,
3848: last_update_login = hz_utility_pub.last_update_login,
3849: request_id = hz_utility_pub.request_id,
3850: program_application_id = hz_utility_pub.program_application_id,
3851: program_id = hz_utility_pub.program_id,
3852: program_update_date = sysdate
3853: WHERE employment_history_id = p_from_id;
3854: ELSE
3855: -- Update and set party_id = p_to_fk_id where pk = from_id
3855: -- Update and set party_id = p_to_fk_id where pk = from_id
3856: UPDATE HZ_EMPLOYMENT_HISTORY
3857: SET
3858: party_id = p_to_fk_id,
3859: last_update_date = hz_utility_pub.last_update_date,
3860: last_updated_by = hz_utility_pub.user_id,
3861: last_update_login = hz_utility_pub.last_update_login,
3862: request_id = hz_utility_pub.request_id,
3863: program_application_id = hz_utility_pub.program_application_id,
3856: UPDATE HZ_EMPLOYMENT_HISTORY
3857: SET
3858: party_id = p_to_fk_id,
3859: last_update_date = hz_utility_pub.last_update_date,
3860: last_updated_by = hz_utility_pub.user_id,
3861: last_update_login = hz_utility_pub.last_update_login,
3862: request_id = hz_utility_pub.request_id,
3863: program_application_id = hz_utility_pub.program_application_id,
3864: program_id = hz_utility_pub.program_id,
3857: SET
3858: party_id = p_to_fk_id,
3859: last_update_date = hz_utility_pub.last_update_date,
3860: last_updated_by = hz_utility_pub.user_id,
3861: last_update_login = hz_utility_pub.last_update_login,
3862: request_id = hz_utility_pub.request_id,
3863: program_application_id = hz_utility_pub.program_application_id,
3864: program_id = hz_utility_pub.program_id,
3865: program_update_date = sysdate
3858: party_id = p_to_fk_id,
3859: last_update_date = hz_utility_pub.last_update_date,
3860: last_updated_by = hz_utility_pub.user_id,
3861: last_update_login = hz_utility_pub.last_update_login,
3862: request_id = hz_utility_pub.request_id,
3863: program_application_id = hz_utility_pub.program_application_id,
3864: program_id = hz_utility_pub.program_id,
3865: program_update_date = sysdate
3866: WHERE employment_history_id = p_from_id;
3859: last_update_date = hz_utility_pub.last_update_date,
3860: last_updated_by = hz_utility_pub.user_id,
3861: last_update_login = hz_utility_pub.last_update_login,
3862: request_id = hz_utility_pub.request_id,
3863: program_application_id = hz_utility_pub.program_application_id,
3864: program_id = hz_utility_pub.program_id,
3865: program_update_date = sysdate
3866: WHERE employment_history_id = p_from_id;
3867:
3860: last_updated_by = hz_utility_pub.user_id,
3861: last_update_login = hz_utility_pub.last_update_login,
3862: request_id = hz_utility_pub.request_id,
3863: program_application_id = hz_utility_pub.program_application_id,
3864: program_id = hz_utility_pub.program_id,
3865: program_update_date = sysdate
3866: WHERE employment_history_id = p_from_id;
3867:
3868: END IF;
3889: x_to_id <> p_from_id) THEN
3890: UPDATE HZ_EMPLOYMENT_HISTORY
3891: SET
3892: STATUS = 'M',
3893: last_update_date = hz_utility_pub.last_update_date,
3894: last_updated_by = hz_utility_pub.user_id,
3895: last_update_login = hz_utility_pub.last_update_login,
3896: request_id = hz_utility_pub.request_id,
3897: program_application_id = hz_utility_pub.program_application_id,
3890: UPDATE HZ_EMPLOYMENT_HISTORY
3891: SET
3892: STATUS = 'M',
3893: last_update_date = hz_utility_pub.last_update_date,
3894: last_updated_by = hz_utility_pub.user_id,
3895: last_update_login = hz_utility_pub.last_update_login,
3896: request_id = hz_utility_pub.request_id,
3897: program_application_id = hz_utility_pub.program_application_id,
3898: program_id = hz_utility_pub.program_id,
3891: SET
3892: STATUS = 'M',
3893: last_update_date = hz_utility_pub.last_update_date,
3894: last_updated_by = hz_utility_pub.user_id,
3895: last_update_login = hz_utility_pub.last_update_login,
3896: request_id = hz_utility_pub.request_id,
3897: program_application_id = hz_utility_pub.program_application_id,
3898: program_id = hz_utility_pub.program_id,
3899: program_update_date = sysdate
3892: STATUS = 'M',
3893: last_update_date = hz_utility_pub.last_update_date,
3894: last_updated_by = hz_utility_pub.user_id,
3895: last_update_login = hz_utility_pub.last_update_login,
3896: request_id = hz_utility_pub.request_id,
3897: program_application_id = hz_utility_pub.program_application_id,
3898: program_id = hz_utility_pub.program_id,
3899: program_update_date = sysdate
3900: WHERE employment_history_id = p_from_id;
3893: last_update_date = hz_utility_pub.last_update_date,
3894: last_updated_by = hz_utility_pub.user_id,
3895: last_update_login = hz_utility_pub.last_update_login,
3896: request_id = hz_utility_pub.request_id,
3897: program_application_id = hz_utility_pub.program_application_id,
3898: program_id = hz_utility_pub.program_id,
3899: program_update_date = sysdate
3900: WHERE employment_history_id = p_from_id;
3901: ELSE
3894: last_updated_by = hz_utility_pub.user_id,
3895: last_update_login = hz_utility_pub.last_update_login,
3896: request_id = hz_utility_pub.request_id,
3897: program_application_id = hz_utility_pub.program_application_id,
3898: program_id = hz_utility_pub.program_id,
3899: program_update_date = sysdate
3900: WHERE employment_history_id = p_from_id;
3901: ELSE
3902: -- Update and set party_id = p_to_fk_id where pk = from_id
3902: -- Update and set party_id = p_to_fk_id where pk = from_id
3903: UPDATE HZ_EMPLOYMENT_HISTORY
3904: SET
3905: employed_by_party_id = p_to_fk_id,
3906: last_update_date = hz_utility_pub.last_update_date,
3907: last_updated_by = hz_utility_pub.user_id,
3908: last_update_login = hz_utility_pub.last_update_login,
3909: request_id = hz_utility_pub.request_id,
3910: program_application_id = hz_utility_pub.program_application_id,
3903: UPDATE HZ_EMPLOYMENT_HISTORY
3904: SET
3905: employed_by_party_id = p_to_fk_id,
3906: last_update_date = hz_utility_pub.last_update_date,
3907: last_updated_by = hz_utility_pub.user_id,
3908: last_update_login = hz_utility_pub.last_update_login,
3909: request_id = hz_utility_pub.request_id,
3910: program_application_id = hz_utility_pub.program_application_id,
3911: program_id = hz_utility_pub.program_id,
3904: SET
3905: employed_by_party_id = p_to_fk_id,
3906: last_update_date = hz_utility_pub.last_update_date,
3907: last_updated_by = hz_utility_pub.user_id,
3908: last_update_login = hz_utility_pub.last_update_login,
3909: request_id = hz_utility_pub.request_id,
3910: program_application_id = hz_utility_pub.program_application_id,
3911: program_id = hz_utility_pub.program_id,
3912: program_update_date = sysdate
3905: employed_by_party_id = p_to_fk_id,
3906: last_update_date = hz_utility_pub.last_update_date,
3907: last_updated_by = hz_utility_pub.user_id,
3908: last_update_login = hz_utility_pub.last_update_login,
3909: request_id = hz_utility_pub.request_id,
3910: program_application_id = hz_utility_pub.program_application_id,
3911: program_id = hz_utility_pub.program_id,
3912: program_update_date = sysdate
3913: WHERE employment_history_id = p_from_id;
3906: last_update_date = hz_utility_pub.last_update_date,
3907: last_updated_by = hz_utility_pub.user_id,
3908: last_update_login = hz_utility_pub.last_update_login,
3909: request_id = hz_utility_pub.request_id,
3910: program_application_id = hz_utility_pub.program_application_id,
3911: program_id = hz_utility_pub.program_id,
3912: program_update_date = sysdate
3913: WHERE employment_history_id = p_from_id;
3914:
3907: last_updated_by = hz_utility_pub.user_id,
3908: last_update_login = hz_utility_pub.last_update_login,
3909: request_id = hz_utility_pub.request_id,
3910: program_application_id = hz_utility_pub.program_application_id,
3911: program_id = hz_utility_pub.program_id,
3912: program_update_date = sysdate
3913: WHERE employment_history_id = p_from_id;
3914:
3915: END IF;
3937: x_to_id <> p_from_id) THEN
3938: UPDATE HZ_WORK_CLASS
3939: SET
3940: STATUS = 'M',
3941: last_update_date = hz_utility_pub.last_update_date,
3942: last_updated_by = hz_utility_pub.user_id,
3943: last_update_login = hz_utility_pub.last_update_login,
3944: request_id = hz_utility_pub.request_id,
3945: program_application_id = hz_utility_pub.program_application_id,
3938: UPDATE HZ_WORK_CLASS
3939: SET
3940: STATUS = 'M',
3941: last_update_date = hz_utility_pub.last_update_date,
3942: last_updated_by = hz_utility_pub.user_id,
3943: last_update_login = hz_utility_pub.last_update_login,
3944: request_id = hz_utility_pub.request_id,
3945: program_application_id = hz_utility_pub.program_application_id,
3946: program_id = hz_utility_pub.program_id,
3939: SET
3940: STATUS = 'M',
3941: last_update_date = hz_utility_pub.last_update_date,
3942: last_updated_by = hz_utility_pub.user_id,
3943: last_update_login = hz_utility_pub.last_update_login,
3944: request_id = hz_utility_pub.request_id,
3945: program_application_id = hz_utility_pub.program_application_id,
3946: program_id = hz_utility_pub.program_id,
3947: program_update_date = sysdate
3940: STATUS = 'M',
3941: last_update_date = hz_utility_pub.last_update_date,
3942: last_updated_by = hz_utility_pub.user_id,
3943: last_update_login = hz_utility_pub.last_update_login,
3944: request_id = hz_utility_pub.request_id,
3945: program_application_id = hz_utility_pub.program_application_id,
3946: program_id = hz_utility_pub.program_id,
3947: program_update_date = sysdate
3948: WHERE work_class_id = p_from_id;
3941: last_update_date = hz_utility_pub.last_update_date,
3942: last_updated_by = hz_utility_pub.user_id,
3943: last_update_login = hz_utility_pub.last_update_login,
3944: request_id = hz_utility_pub.request_id,
3945: program_application_id = hz_utility_pub.program_application_id,
3946: program_id = hz_utility_pub.program_id,
3947: program_update_date = sysdate
3948: WHERE work_class_id = p_from_id;
3949: ELSE
3942: last_updated_by = hz_utility_pub.user_id,
3943: last_update_login = hz_utility_pub.last_update_login,
3944: request_id = hz_utility_pub.request_id,
3945: program_application_id = hz_utility_pub.program_application_id,
3946: program_id = hz_utility_pub.program_id,
3947: program_update_date = sysdate
3948: WHERE work_class_id = p_from_id;
3949: ELSE
3950: -- Update and set employment_history_id = p_to_fk_id where pk = from_id
3950: -- Update and set employment_history_id = p_to_fk_id where pk = from_id
3951: UPDATE HZ_WORK_CLASS
3952: SET
3953: employment_history_id = p_to_fk_id,
3954: last_update_date = hz_utility_pub.last_update_date,
3955: last_updated_by = hz_utility_pub.user_id,
3956: last_update_login = hz_utility_pub.last_update_login,
3957: request_id = hz_utility_pub.request_id,
3958: program_application_id = hz_utility_pub.program_application_id,
3951: UPDATE HZ_WORK_CLASS
3952: SET
3953: employment_history_id = p_to_fk_id,
3954: last_update_date = hz_utility_pub.last_update_date,
3955: last_updated_by = hz_utility_pub.user_id,
3956: last_update_login = hz_utility_pub.last_update_login,
3957: request_id = hz_utility_pub.request_id,
3958: program_application_id = hz_utility_pub.program_application_id,
3959: program_id = hz_utility_pub.program_id,
3952: SET
3953: employment_history_id = p_to_fk_id,
3954: last_update_date = hz_utility_pub.last_update_date,
3955: last_updated_by = hz_utility_pub.user_id,
3956: last_update_login = hz_utility_pub.last_update_login,
3957: request_id = hz_utility_pub.request_id,
3958: program_application_id = hz_utility_pub.program_application_id,
3959: program_id = hz_utility_pub.program_id,
3960: program_update_date = sysdate
3953: employment_history_id = p_to_fk_id,
3954: last_update_date = hz_utility_pub.last_update_date,
3955: last_updated_by = hz_utility_pub.user_id,
3956: last_update_login = hz_utility_pub.last_update_login,
3957: request_id = hz_utility_pub.request_id,
3958: program_application_id = hz_utility_pub.program_application_id,
3959: program_id = hz_utility_pub.program_id,
3960: program_update_date = sysdate
3961: WHERE work_class_id = p_from_id;
3954: last_update_date = hz_utility_pub.last_update_date,
3955: last_updated_by = hz_utility_pub.user_id,
3956: last_update_login = hz_utility_pub.last_update_login,
3957: request_id = hz_utility_pub.request_id,
3958: program_application_id = hz_utility_pub.program_application_id,
3959: program_id = hz_utility_pub.program_id,
3960: program_update_date = sysdate
3961: WHERE work_class_id = p_from_id;
3962:
3955: last_updated_by = hz_utility_pub.user_id,
3956: last_update_login = hz_utility_pub.last_update_login,
3957: request_id = hz_utility_pub.request_id,
3958: program_application_id = hz_utility_pub.program_application_id,
3959: program_id = hz_utility_pub.program_id,
3960: program_update_date = sysdate
3961: WHERE work_class_id = p_from_id;
3962:
3963: END IF;
3995: x_to_id <> p_from_id) THEN
3996: UPDATE HZ_ORG_CONTACT_ROLES
3997: SET
3998: STATUS = 'M',
3999: last_update_date = hz_utility_pub.last_update_date,
4000: last_updated_by = hz_utility_pub.user_id,
4001: last_update_login = hz_utility_pub.last_update_login,
4002: request_id = hz_utility_pub.request_id,
4003: program_application_id = hz_utility_pub.program_application_id,
3996: UPDATE HZ_ORG_CONTACT_ROLES
3997: SET
3998: STATUS = 'M',
3999: last_update_date = hz_utility_pub.last_update_date,
4000: last_updated_by = hz_utility_pub.user_id,
4001: last_update_login = hz_utility_pub.last_update_login,
4002: request_id = hz_utility_pub.request_id,
4003: program_application_id = hz_utility_pub.program_application_id,
4004: program_id = hz_utility_pub.program_id,
3997: SET
3998: STATUS = 'M',
3999: last_update_date = hz_utility_pub.last_update_date,
4000: last_updated_by = hz_utility_pub.user_id,
4001: last_update_login = hz_utility_pub.last_update_login,
4002: request_id = hz_utility_pub.request_id,
4003: program_application_id = hz_utility_pub.program_application_id,
4004: program_id = hz_utility_pub.program_id,
4005: program_update_date = sysdate
3998: STATUS = 'M',
3999: last_update_date = hz_utility_pub.last_update_date,
4000: last_updated_by = hz_utility_pub.user_id,
4001: last_update_login = hz_utility_pub.last_update_login,
4002: request_id = hz_utility_pub.request_id,
4003: program_application_id = hz_utility_pub.program_application_id,
4004: program_id = hz_utility_pub.program_id,
4005: program_update_date = sysdate
4006: WHERE org_contact_role_id = p_from_id;
3999: last_update_date = hz_utility_pub.last_update_date,
4000: last_updated_by = hz_utility_pub.user_id,
4001: last_update_login = hz_utility_pub.last_update_login,
4002: request_id = hz_utility_pub.request_id,
4003: program_application_id = hz_utility_pub.program_application_id,
4004: program_id = hz_utility_pub.program_id,
4005: program_update_date = sysdate
4006: WHERE org_contact_role_id = p_from_id;
4007:
4000: last_updated_by = hz_utility_pub.user_id,
4001: last_update_login = hz_utility_pub.last_update_login,
4002: request_id = hz_utility_pub.request_id,
4003: program_application_id = hz_utility_pub.program_application_id,
4004: program_id = hz_utility_pub.program_id,
4005: program_update_date = sysdate
4006: WHERE org_contact_role_id = p_from_id;
4007:
4008: HZ_ORIG_SYSTEM_REF_PVT.remap_internal_identifier(
4080: SET
4081: org_contact_id = p_to_fk_id,
4082: primary_flag = l_primary_flag,
4083: primary_contact_per_role_type = l_primary_role_flag,
4084: last_update_date = hz_utility_pub.last_update_date,
4085: last_updated_by = hz_utility_pub.user_id,
4086: last_update_login = hz_utility_pub.last_update_login,
4087: request_id = hz_utility_pub.request_id,
4088: program_application_id = hz_utility_pub.program_application_id,
4081: org_contact_id = p_to_fk_id,
4082: primary_flag = l_primary_flag,
4083: primary_contact_per_role_type = l_primary_role_flag,
4084: last_update_date = hz_utility_pub.last_update_date,
4085: last_updated_by = hz_utility_pub.user_id,
4086: last_update_login = hz_utility_pub.last_update_login,
4087: request_id = hz_utility_pub.request_id,
4088: program_application_id = hz_utility_pub.program_application_id,
4089: program_id = hz_utility_pub.program_id,
4082: primary_flag = l_primary_flag,
4083: primary_contact_per_role_type = l_primary_role_flag,
4084: last_update_date = hz_utility_pub.last_update_date,
4085: last_updated_by = hz_utility_pub.user_id,
4086: last_update_login = hz_utility_pub.last_update_login,
4087: request_id = hz_utility_pub.request_id,
4088: program_application_id = hz_utility_pub.program_application_id,
4089: program_id = hz_utility_pub.program_id,
4090: program_update_date = sysdate
4083: primary_contact_per_role_type = l_primary_role_flag,
4084: last_update_date = hz_utility_pub.last_update_date,
4085: last_updated_by = hz_utility_pub.user_id,
4086: last_update_login = hz_utility_pub.last_update_login,
4087: request_id = hz_utility_pub.request_id,
4088: program_application_id = hz_utility_pub.program_application_id,
4089: program_id = hz_utility_pub.program_id,
4090: program_update_date = sysdate
4091: WHERE org_contact_role_id = p_from_id;
4084: last_update_date = hz_utility_pub.last_update_date,
4085: last_updated_by = hz_utility_pub.user_id,
4086: last_update_login = hz_utility_pub.last_update_login,
4087: request_id = hz_utility_pub.request_id,
4088: program_application_id = hz_utility_pub.program_application_id,
4089: program_id = hz_utility_pub.program_id,
4090: program_update_date = sysdate
4091: WHERE org_contact_role_id = p_from_id;
4092: END IF;
4085: last_updated_by = hz_utility_pub.user_id,
4086: last_update_login = hz_utility_pub.last_update_login,
4087: request_id = hz_utility_pub.request_id,
4088: program_application_id = hz_utility_pub.program_application_id,
4089: program_id = hz_utility_pub.program_id,
4090: program_update_date = sysdate
4091: WHERE org_contact_role_id = p_from_id;
4092: END IF;
4093:
4113: x_to_id <> p_from_id) THEN
4114: UPDATE HZ_FINANCIAL_NUMBERS
4115: SET
4116: STATUS = 'M',
4117: last_update_date = hz_utility_pub.last_update_date,
4118: last_updated_by = hz_utility_pub.user_id,
4119: last_update_login = hz_utility_pub.last_update_login,
4120: request_id = hz_utility_pub.request_id,
4121: program_application_id = hz_utility_pub.program_application_id,
4114: UPDATE HZ_FINANCIAL_NUMBERS
4115: SET
4116: STATUS = 'M',
4117: last_update_date = hz_utility_pub.last_update_date,
4118: last_updated_by = hz_utility_pub.user_id,
4119: last_update_login = hz_utility_pub.last_update_login,
4120: request_id = hz_utility_pub.request_id,
4121: program_application_id = hz_utility_pub.program_application_id,
4122: program_id = hz_utility_pub.program_id,
4115: SET
4116: STATUS = 'M',
4117: last_update_date = hz_utility_pub.last_update_date,
4118: last_updated_by = hz_utility_pub.user_id,
4119: last_update_login = hz_utility_pub.last_update_login,
4120: request_id = hz_utility_pub.request_id,
4121: program_application_id = hz_utility_pub.program_application_id,
4122: program_id = hz_utility_pub.program_id,
4123: program_update_date = sysdate
4116: STATUS = 'M',
4117: last_update_date = hz_utility_pub.last_update_date,
4118: last_updated_by = hz_utility_pub.user_id,
4119: last_update_login = hz_utility_pub.last_update_login,
4120: request_id = hz_utility_pub.request_id,
4121: program_application_id = hz_utility_pub.program_application_id,
4122: program_id = hz_utility_pub.program_id,
4123: program_update_date = sysdate
4124: WHERE financial_number_id = p_from_id;
4117: last_update_date = hz_utility_pub.last_update_date,
4118: last_updated_by = hz_utility_pub.user_id,
4119: last_update_login = hz_utility_pub.last_update_login,
4120: request_id = hz_utility_pub.request_id,
4121: program_application_id = hz_utility_pub.program_application_id,
4122: program_id = hz_utility_pub.program_id,
4123: program_update_date = sysdate
4124: WHERE financial_number_id = p_from_id;
4125: ELSE
4118: last_updated_by = hz_utility_pub.user_id,
4119: last_update_login = hz_utility_pub.last_update_login,
4120: request_id = hz_utility_pub.request_id,
4121: program_application_id = hz_utility_pub.program_application_id,
4122: program_id = hz_utility_pub.program_id,
4123: program_update_date = sysdate
4124: WHERE financial_number_id = p_from_id;
4125: ELSE
4126: -- Update and set party_id = p_to_fk_id where pk = from_id
4126: -- Update and set party_id = p_to_fk_id where pk = from_id
4127: UPDATE HZ_FINANCIAL_NUMBERS
4128: SET
4129: financial_report_id = p_to_fk_id,
4130: last_update_date = hz_utility_pub.last_update_date,
4131: last_updated_by = hz_utility_pub.user_id,
4132: last_update_login = hz_utility_pub.last_update_login,
4133: request_id = hz_utility_pub.request_id,
4134: program_application_id = hz_utility_pub.program_application_id,
4127: UPDATE HZ_FINANCIAL_NUMBERS
4128: SET
4129: financial_report_id = p_to_fk_id,
4130: last_update_date = hz_utility_pub.last_update_date,
4131: last_updated_by = hz_utility_pub.user_id,
4132: last_update_login = hz_utility_pub.last_update_login,
4133: request_id = hz_utility_pub.request_id,
4134: program_application_id = hz_utility_pub.program_application_id,
4135: program_id = hz_utility_pub.program_id,
4128: SET
4129: financial_report_id = p_to_fk_id,
4130: last_update_date = hz_utility_pub.last_update_date,
4131: last_updated_by = hz_utility_pub.user_id,
4132: last_update_login = hz_utility_pub.last_update_login,
4133: request_id = hz_utility_pub.request_id,
4134: program_application_id = hz_utility_pub.program_application_id,
4135: program_id = hz_utility_pub.program_id,
4136: program_update_date = sysdate
4129: financial_report_id = p_to_fk_id,
4130: last_update_date = hz_utility_pub.last_update_date,
4131: last_updated_by = hz_utility_pub.user_id,
4132: last_update_login = hz_utility_pub.last_update_login,
4133: request_id = hz_utility_pub.request_id,
4134: program_application_id = hz_utility_pub.program_application_id,
4135: program_id = hz_utility_pub.program_id,
4136: program_update_date = sysdate
4137: WHERE financial_number_id = p_from_id;
4130: last_update_date = hz_utility_pub.last_update_date,
4131: last_updated_by = hz_utility_pub.user_id,
4132: last_update_login = hz_utility_pub.last_update_login,
4133: request_id = hz_utility_pub.request_id,
4134: program_application_id = hz_utility_pub.program_application_id,
4135: program_id = hz_utility_pub.program_id,
4136: program_update_date = sysdate
4137: WHERE financial_number_id = p_from_id;
4138: END IF;
4131: last_updated_by = hz_utility_pub.user_id,
4132: last_update_login = hz_utility_pub.last_update_login,
4133: request_id = hz_utility_pub.request_id,
4134: program_application_id = hz_utility_pub.program_application_id,
4135: program_id = hz_utility_pub.program_id,
4136: program_update_date = sysdate
4137: WHERE financial_number_id = p_from_id;
4138: END IF;
4139:
4190: OR (NVL(l_code_exists,'N') = 'Y') THEN
4191: UPDATE HZ_CODE_ASSIGNMENTS
4192: SET
4193: STATUS = 'M',
4194: last_update_date = hz_utility_pub.last_update_date,
4195: last_updated_by = hz_utility_pub.user_id,
4196: last_update_login = hz_utility_pub.last_update_login
4197: -- request_id = hz_utility_pub.request_id,
4198: -- program_application_id = hz_utility_pub.program_application_id,
4191: UPDATE HZ_CODE_ASSIGNMENTS
4192: SET
4193: STATUS = 'M',
4194: last_update_date = hz_utility_pub.last_update_date,
4195: last_updated_by = hz_utility_pub.user_id,
4196: last_update_login = hz_utility_pub.last_update_login
4197: -- request_id = hz_utility_pub.request_id,
4198: -- program_application_id = hz_utility_pub.program_application_id,
4199: -- program_id = hz_utility_pub.program_id,
4192: SET
4193: STATUS = 'M',
4194: last_update_date = hz_utility_pub.last_update_date,
4195: last_updated_by = hz_utility_pub.user_id,
4196: last_update_login = hz_utility_pub.last_update_login
4197: -- request_id = hz_utility_pub.request_id,
4198: -- program_application_id = hz_utility_pub.program_application_id,
4199: -- program_id = hz_utility_pub.program_id,
4200: -- program_update_date = sysdate
4193: STATUS = 'M',
4194: last_update_date = hz_utility_pub.last_update_date,
4195: last_updated_by = hz_utility_pub.user_id,
4196: last_update_login = hz_utility_pub.last_update_login
4197: -- request_id = hz_utility_pub.request_id,
4198: -- program_application_id = hz_utility_pub.program_application_id,
4199: -- program_id = hz_utility_pub.program_id,
4200: -- program_update_date = sysdate
4201: WHERE code_assignment_id = p_from_id;
4194: last_update_date = hz_utility_pub.last_update_date,
4195: last_updated_by = hz_utility_pub.user_id,
4196: last_update_login = hz_utility_pub.last_update_login
4197: -- request_id = hz_utility_pub.request_id,
4198: -- program_application_id = hz_utility_pub.program_application_id,
4199: -- program_id = hz_utility_pub.program_id,
4200: -- program_update_date = sysdate
4201: WHERE code_assignment_id = p_from_id;
4202:
4195: last_updated_by = hz_utility_pub.user_id,
4196: last_update_login = hz_utility_pub.last_update_login
4197: -- request_id = hz_utility_pub.request_id,
4198: -- program_application_id = hz_utility_pub.program_application_id,
4199: -- program_id = hz_utility_pub.program_id,
4200: -- program_update_date = sysdate
4201: WHERE code_assignment_id = p_from_id;
4202:
4203: ELSE
4227: UPDATE HZ_CODE_ASSIGNMENTS
4228: SET
4229: owner_table_id = p_to_fk_id,
4230: primary_flag = l_primary_flag,
4231: last_update_date = hz_utility_pub.last_update_date,
4232: last_updated_by = hz_utility_pub.user_id,
4233: last_update_login = hz_utility_pub.last_update_login
4234: -- request_id = hz_utility_pub.request_id,
4235: -- program_application_id = hz_utility_pub.program_application_id,
4228: SET
4229: owner_table_id = p_to_fk_id,
4230: primary_flag = l_primary_flag,
4231: last_update_date = hz_utility_pub.last_update_date,
4232: last_updated_by = hz_utility_pub.user_id,
4233: last_update_login = hz_utility_pub.last_update_login
4234: -- request_id = hz_utility_pub.request_id,
4235: -- program_application_id = hz_utility_pub.program_application_id,
4236: -- program_id = hz_utility_pub.program_id,
4229: owner_table_id = p_to_fk_id,
4230: primary_flag = l_primary_flag,
4231: last_update_date = hz_utility_pub.last_update_date,
4232: last_updated_by = hz_utility_pub.user_id,
4233: last_update_login = hz_utility_pub.last_update_login
4234: -- request_id = hz_utility_pub.request_id,
4235: -- program_application_id = hz_utility_pub.program_application_id,
4236: -- program_id = hz_utility_pub.program_id,
4237: -- program_update_date = sysdate
4230: primary_flag = l_primary_flag,
4231: last_update_date = hz_utility_pub.last_update_date,
4232: last_updated_by = hz_utility_pub.user_id,
4233: last_update_login = hz_utility_pub.last_update_login
4234: -- request_id = hz_utility_pub.request_id,
4235: -- program_application_id = hz_utility_pub.program_application_id,
4236: -- program_id = hz_utility_pub.program_id,
4237: -- program_update_date = sysdate
4238: WHERE code_assignment_id = p_from_id;
4231: last_update_date = hz_utility_pub.last_update_date,
4232: last_updated_by = hz_utility_pub.user_id,
4233: last_update_login = hz_utility_pub.last_update_login
4234: -- request_id = hz_utility_pub.request_id,
4235: -- program_application_id = hz_utility_pub.program_application_id,
4236: -- program_id = hz_utility_pub.program_id,
4237: -- program_update_date = sysdate
4238: WHERE code_assignment_id = p_from_id;
4239:
4232: last_updated_by = hz_utility_pub.user_id,
4233: last_update_login = hz_utility_pub.last_update_login
4234: -- request_id = hz_utility_pub.request_id,
4235: -- program_application_id = hz_utility_pub.program_application_id,
4236: -- program_id = hz_utility_pub.program_id,
4237: -- program_update_date = sysdate
4238: WHERE code_assignment_id = p_from_id;
4239:
4240: --bug 4582789
4241:
4242: IF l_primary_flag = 'Y' AND l_class_category = 'CUSTOMER_CATEGORY' THEN
4243: UPDATE hz_parties
4244: SET category_code = l_class_code,
4245: last_update_date = hz_utility_pub.last_update_date,
4246: last_updated_by = hz_utility_pub.user_id,
4247: last_update_login = hz_utility_pub.last_update_login
4248: WHERE party_id = p_to_fk_id;
4249: END IF;
4242: IF l_primary_flag = 'Y' AND l_class_category = 'CUSTOMER_CATEGORY' THEN
4243: UPDATE hz_parties
4244: SET category_code = l_class_code,
4245: last_update_date = hz_utility_pub.last_update_date,
4246: last_updated_by = hz_utility_pub.user_id,
4247: last_update_login = hz_utility_pub.last_update_login
4248: WHERE party_id = p_to_fk_id;
4249: END IF;
4250: ---bug 4582789
4243: UPDATE hz_parties
4244: SET category_code = l_class_code,
4245: last_update_date = hz_utility_pub.last_update_date,
4246: last_updated_by = hz_utility_pub.user_id,
4247: last_update_login = hz_utility_pub.last_update_login
4248: WHERE party_id = p_to_fk_id;
4249: END IF;
4250: ---bug 4582789
4251: END IF;
4301: x_to_id <> p_from_id) OR (NVL(l_code_exists,'N') = 'Y') THEN
4302: UPDATE HZ_CODE_ASSIGNMENTS
4303: SET
4304: STATUS = 'M',
4305: last_update_date = hz_utility_pub.last_update_date,
4306: last_updated_by = hz_utility_pub.user_id,
4307: last_update_login = hz_utility_pub.last_update_login
4308: -- request_id = hz_utility_pub.request_id,
4309: -- program_application_id = hz_utility_pub.program_application_id,
4302: UPDATE HZ_CODE_ASSIGNMENTS
4303: SET
4304: STATUS = 'M',
4305: last_update_date = hz_utility_pub.last_update_date,
4306: last_updated_by = hz_utility_pub.user_id,
4307: last_update_login = hz_utility_pub.last_update_login
4308: -- request_id = hz_utility_pub.request_id,
4309: -- program_application_id = hz_utility_pub.program_application_id,
4310: -- program_id = hz_utility_pub.program_id,
4303: SET
4304: STATUS = 'M',
4305: last_update_date = hz_utility_pub.last_update_date,
4306: last_updated_by = hz_utility_pub.user_id,
4307: last_update_login = hz_utility_pub.last_update_login
4308: -- request_id = hz_utility_pub.request_id,
4309: -- program_application_id = hz_utility_pub.program_application_id,
4310: -- program_id = hz_utility_pub.program_id,
4311: -- program_update_date = sysdate
4304: STATUS = 'M',
4305: last_update_date = hz_utility_pub.last_update_date,
4306: last_updated_by = hz_utility_pub.user_id,
4307: last_update_login = hz_utility_pub.last_update_login
4308: -- request_id = hz_utility_pub.request_id,
4309: -- program_application_id = hz_utility_pub.program_application_id,
4310: -- program_id = hz_utility_pub.program_id,
4311: -- program_update_date = sysdate
4312: WHERE code_assignment_id = p_from_id;
4305: last_update_date = hz_utility_pub.last_update_date,
4306: last_updated_by = hz_utility_pub.user_id,
4307: last_update_login = hz_utility_pub.last_update_login
4308: -- request_id = hz_utility_pub.request_id,
4309: -- program_application_id = hz_utility_pub.program_application_id,
4310: -- program_id = hz_utility_pub.program_id,
4311: -- program_update_date = sysdate
4312: WHERE code_assignment_id = p_from_id;
4313: ELSE
4306: last_updated_by = hz_utility_pub.user_id,
4307: last_update_login = hz_utility_pub.last_update_login
4308: -- request_id = hz_utility_pub.request_id,
4309: -- program_application_id = hz_utility_pub.program_application_id,
4310: -- program_id = hz_utility_pub.program_id,
4311: -- program_update_date = sysdate
4312: WHERE code_assignment_id = p_from_id;
4313: ELSE
4314: --- Transfer ---
4337: UPDATE HZ_CODE_ASSIGNMENTS
4338: SET
4339: owner_table_id = p_to_fk_id,
4340: primary_flag = l_primary_flag,
4341: last_update_date = hz_utility_pub.last_update_date,
4342: last_updated_by = hz_utility_pub.user_id,
4343: last_update_login = hz_utility_pub.last_update_login
4344: -- request_id = hz_utility_pub.request_id,
4345: -- program_application_id = hz_utility_pub.program_application_id,
4338: SET
4339: owner_table_id = p_to_fk_id,
4340: primary_flag = l_primary_flag,
4341: last_update_date = hz_utility_pub.last_update_date,
4342: last_updated_by = hz_utility_pub.user_id,
4343: last_update_login = hz_utility_pub.last_update_login
4344: -- request_id = hz_utility_pub.request_id,
4345: -- program_application_id = hz_utility_pub.program_application_id,
4346: -- program_id = hz_utility_pub.program_id,
4339: owner_table_id = p_to_fk_id,
4340: primary_flag = l_primary_flag,
4341: last_update_date = hz_utility_pub.last_update_date,
4342: last_updated_by = hz_utility_pub.user_id,
4343: last_update_login = hz_utility_pub.last_update_login
4344: -- request_id = hz_utility_pub.request_id,
4345: -- program_application_id = hz_utility_pub.program_application_id,
4346: -- program_id = hz_utility_pub.program_id,
4347: -- program_update_date = sysdate
4340: primary_flag = l_primary_flag,
4341: last_update_date = hz_utility_pub.last_update_date,
4342: last_updated_by = hz_utility_pub.user_id,
4343: last_update_login = hz_utility_pub.last_update_login
4344: -- request_id = hz_utility_pub.request_id,
4345: -- program_application_id = hz_utility_pub.program_application_id,
4346: -- program_id = hz_utility_pub.program_id,
4347: -- program_update_date = sysdate
4348: WHERE code_assignment_id = p_from_id;
4341: last_update_date = hz_utility_pub.last_update_date,
4342: last_updated_by = hz_utility_pub.user_id,
4343: last_update_login = hz_utility_pub.last_update_login
4344: -- request_id = hz_utility_pub.request_id,
4345: -- program_application_id = hz_utility_pub.program_application_id,
4346: -- program_id = hz_utility_pub.program_id,
4347: -- program_update_date = sysdate
4348: WHERE code_assignment_id = p_from_id;
4349: END IF;
4342: last_updated_by = hz_utility_pub.user_id,
4343: last_update_login = hz_utility_pub.last_update_login
4344: -- request_id = hz_utility_pub.request_id,
4345: -- program_application_id = hz_utility_pub.program_application_id,
4346: -- program_id = hz_utility_pub.program_id,
4347: -- program_update_date = sysdate
4348: WHERE code_assignment_id = p_from_id;
4349: END IF;
4350:
4380: x_to_id <> p_from_id) THEN
4381: UPDATE HZ_PERSON_LANGUAGE
4382: SET
4383: STATUS = 'M',
4384: last_update_date = hz_utility_pub.last_update_date,
4385: last_updated_by = hz_utility_pub.user_id,
4386: last_update_login = hz_utility_pub.last_update_login,
4387: request_id = hz_utility_pub.request_id,
4388: program_application_id = hz_utility_pub.program_application_id,
4381: UPDATE HZ_PERSON_LANGUAGE
4382: SET
4383: STATUS = 'M',
4384: last_update_date = hz_utility_pub.last_update_date,
4385: last_updated_by = hz_utility_pub.user_id,
4386: last_update_login = hz_utility_pub.last_update_login,
4387: request_id = hz_utility_pub.request_id,
4388: program_application_id = hz_utility_pub.program_application_id,
4389: program_id = hz_utility_pub.program_id,
4382: SET
4383: STATUS = 'M',
4384: last_update_date = hz_utility_pub.last_update_date,
4385: last_updated_by = hz_utility_pub.user_id,
4386: last_update_login = hz_utility_pub.last_update_login,
4387: request_id = hz_utility_pub.request_id,
4388: program_application_id = hz_utility_pub.program_application_id,
4389: program_id = hz_utility_pub.program_id,
4390: program_update_date = sysdate
4383: STATUS = 'M',
4384: last_update_date = hz_utility_pub.last_update_date,
4385: last_updated_by = hz_utility_pub.user_id,
4386: last_update_login = hz_utility_pub.last_update_login,
4387: request_id = hz_utility_pub.request_id,
4388: program_application_id = hz_utility_pub.program_application_id,
4389: program_id = hz_utility_pub.program_id,
4390: program_update_date = sysdate
4391: WHERE language_use_reference_id = p_from_id;
4384: last_update_date = hz_utility_pub.last_update_date,
4385: last_updated_by = hz_utility_pub.user_id,
4386: last_update_login = hz_utility_pub.last_update_login,
4387: request_id = hz_utility_pub.request_id,
4388: program_application_id = hz_utility_pub.program_application_id,
4389: program_id = hz_utility_pub.program_id,
4390: program_update_date = sysdate
4391: WHERE language_use_reference_id = p_from_id;
4392: ELSE
4385: last_updated_by = hz_utility_pub.user_id,
4386: last_update_login = hz_utility_pub.last_update_login,
4387: request_id = hz_utility_pub.request_id,
4388: program_application_id = hz_utility_pub.program_application_id,
4389: program_id = hz_utility_pub.program_id,
4390: program_update_date = sysdate
4391: WHERE language_use_reference_id = p_from_id;
4392: ELSE
4393: --- Transfer ---
4442: SET
4443: party_id = p_to_fk_id,
4444: primary_language_indicator = l_primary_lang_flag,
4445: native_language = l_primary_nav_flag,
4446: last_update_date = hz_utility_pub.last_update_date,
4447: last_updated_by = hz_utility_pub.user_id,
4448: last_update_login = hz_utility_pub.last_update_login,
4449: request_id = hz_utility_pub.request_id,
4450: program_application_id = hz_utility_pub.program_application_id,
4443: party_id = p_to_fk_id,
4444: primary_language_indicator = l_primary_lang_flag,
4445: native_language = l_primary_nav_flag,
4446: last_update_date = hz_utility_pub.last_update_date,
4447: last_updated_by = hz_utility_pub.user_id,
4448: last_update_login = hz_utility_pub.last_update_login,
4449: request_id = hz_utility_pub.request_id,
4450: program_application_id = hz_utility_pub.program_application_id,
4451: program_id = hz_utility_pub.program_id,
4444: primary_language_indicator = l_primary_lang_flag,
4445: native_language = l_primary_nav_flag,
4446: last_update_date = hz_utility_pub.last_update_date,
4447: last_updated_by = hz_utility_pub.user_id,
4448: last_update_login = hz_utility_pub.last_update_login,
4449: request_id = hz_utility_pub.request_id,
4450: program_application_id = hz_utility_pub.program_application_id,
4451: program_id = hz_utility_pub.program_id,
4452: program_update_date = sysdate
4445: native_language = l_primary_nav_flag,
4446: last_update_date = hz_utility_pub.last_update_date,
4447: last_updated_by = hz_utility_pub.user_id,
4448: last_update_login = hz_utility_pub.last_update_login,
4449: request_id = hz_utility_pub.request_id,
4450: program_application_id = hz_utility_pub.program_application_id,
4451: program_id = hz_utility_pub.program_id,
4452: program_update_date = sysdate
4453: WHERE language_use_reference_id = p_from_id;
4446: last_update_date = hz_utility_pub.last_update_date,
4447: last_updated_by = hz_utility_pub.user_id,
4448: last_update_login = hz_utility_pub.last_update_login,
4449: request_id = hz_utility_pub.request_id,
4450: program_application_id = hz_utility_pub.program_application_id,
4451: program_id = hz_utility_pub.program_id,
4452: program_update_date = sysdate
4453: WHERE language_use_reference_id = p_from_id;
4454:
4447: last_updated_by = hz_utility_pub.user_id,
4448: last_update_login = hz_utility_pub.last_update_login,
4449: request_id = hz_utility_pub.request_id,
4450: program_application_id = hz_utility_pub.program_application_id,
4451: program_id = hz_utility_pub.program_id,
4452: program_update_date = sysdate
4453: WHERE language_use_reference_id = p_from_id;
4454:
4455: END IF;
4503: UPDATE HZ_PARTY_SITE_USES
4504: SET
4505: ----Bug: 2619948 added setting status to 'M' here too
4506: STATUS = 'M',
4507: last_update_date = hz_utility_pub.last_update_date,
4508: last_updated_by = hz_utility_pub.user_id,
4509: last_update_login = hz_utility_pub.last_update_login,
4510: request_id = hz_utility_pub.request_id,
4511: program_application_id = hz_utility_pub.program_application_id,
4504: SET
4505: ----Bug: 2619948 added setting status to 'M' here too
4506: STATUS = 'M',
4507: last_update_date = hz_utility_pub.last_update_date,
4508: last_updated_by = hz_utility_pub.user_id,
4509: last_update_login = hz_utility_pub.last_update_login,
4510: request_id = hz_utility_pub.request_id,
4511: program_application_id = hz_utility_pub.program_application_id,
4512: program_id = hz_utility_pub.program_id,
4505: ----Bug: 2619948 added setting status to 'M' here too
4506: STATUS = 'M',
4507: last_update_date = hz_utility_pub.last_update_date,
4508: last_updated_by = hz_utility_pub.user_id,
4509: last_update_login = hz_utility_pub.last_update_login,
4510: request_id = hz_utility_pub.request_id,
4511: program_application_id = hz_utility_pub.program_application_id,
4512: program_id = hz_utility_pub.program_id,
4513: program_update_date = sysdate
4506: STATUS = 'M',
4507: last_update_date = hz_utility_pub.last_update_date,
4508: last_updated_by = hz_utility_pub.user_id,
4509: last_update_login = hz_utility_pub.last_update_login,
4510: request_id = hz_utility_pub.request_id,
4511: program_application_id = hz_utility_pub.program_application_id,
4512: program_id = hz_utility_pub.program_id,
4513: program_update_date = sysdate
4514: WHERE party_site_use_id = p_from_id;
4507: last_update_date = hz_utility_pub.last_update_date,
4508: last_updated_by = hz_utility_pub.user_id,
4509: last_update_login = hz_utility_pub.last_update_login,
4510: request_id = hz_utility_pub.request_id,
4511: program_application_id = hz_utility_pub.program_application_id,
4512: program_id = hz_utility_pub.program_id,
4513: program_update_date = sysdate
4514: WHERE party_site_use_id = p_from_id;
4515: ELSE
4508: last_updated_by = hz_utility_pub.user_id,
4509: last_update_login = hz_utility_pub.last_update_login,
4510: request_id = hz_utility_pub.request_id,
4511: program_application_id = hz_utility_pub.program_application_id,
4512: program_id = hz_utility_pub.program_id,
4513: program_update_date = sysdate
4514: WHERE party_site_use_id = p_from_id;
4515: ELSE
4516:
4539: OPEN c_party_id(p_to_fk_id);
4540: FETCH c_party_id INTO l_party_id;
4541: CLOSE c_party_id;
4542:
4543: OPEN c_prim_site_uses(l_party_id,p_to_fk_id,party_site_use_rec.site_use_type,hz_utility_pub.request_id);
4544: FETCH c_prim_site_uses INTO l_prim_use_exists;
4545: CLOSE c_prim_site_uses;
4546: IF l_prim_use_exists <> 1 THEN
4547: party_site_use_rec.primary_per_type := 'N';
4569: -- Update and set party_id = p_to_fk_id where pk = from_id
4570: UPDATE HZ_PARTY_SITE_USES
4571: SET
4572: STATUS = 'M',
4573: last_update_date = hz_utility_pub.last_update_date,
4574: last_updated_by = hz_utility_pub.user_id,
4575: last_update_login = hz_utility_pub.last_update_login,
4576: request_id = hz_utility_pub.request_id,
4577: program_application_id = hz_utility_pub.program_application_id,
4570: UPDATE HZ_PARTY_SITE_USES
4571: SET
4572: STATUS = 'M',
4573: last_update_date = hz_utility_pub.last_update_date,
4574: last_updated_by = hz_utility_pub.user_id,
4575: last_update_login = hz_utility_pub.last_update_login,
4576: request_id = hz_utility_pub.request_id,
4577: program_application_id = hz_utility_pub.program_application_id,
4578: program_id = hz_utility_pub.program_id,
4571: SET
4572: STATUS = 'M',
4573: last_update_date = hz_utility_pub.last_update_date,
4574: last_updated_by = hz_utility_pub.user_id,
4575: last_update_login = hz_utility_pub.last_update_login,
4576: request_id = hz_utility_pub.request_id,
4577: program_application_id = hz_utility_pub.program_application_id,
4578: program_id = hz_utility_pub.program_id,
4579: program_update_date = sysdate
4572: STATUS = 'M',
4573: last_update_date = hz_utility_pub.last_update_date,
4574: last_updated_by = hz_utility_pub.user_id,
4575: last_update_login = hz_utility_pub.last_update_login,
4576: request_id = hz_utility_pub.request_id,
4577: program_application_id = hz_utility_pub.program_application_id,
4578: program_id = hz_utility_pub.program_id,
4579: program_update_date = sysdate
4580: WHERE party_site_use_id = p_from_id;
4573: last_update_date = hz_utility_pub.last_update_date,
4574: last_updated_by = hz_utility_pub.user_id,
4575: last_update_login = hz_utility_pub.last_update_login,
4576: request_id = hz_utility_pub.request_id,
4577: program_application_id = hz_utility_pub.program_application_id,
4578: program_id = hz_utility_pub.program_id,
4579: program_update_date = sysdate
4580: WHERE party_site_use_id = p_from_id;
4581:
4574: last_updated_by = hz_utility_pub.user_id,
4575: last_update_login = hz_utility_pub.last_update_login,
4576: request_id = hz_utility_pub.request_id,
4577: program_application_id = hz_utility_pub.program_application_id,
4578: program_id = hz_utility_pub.program_id,
4579: program_update_date = sysdate
4580: WHERE party_site_use_id = p_from_id;
4581:
4582: x_return_status := 'N';
4606: x_to_id <> p_from_id) THEN
4607: UPDATE HZ_CUST_ACCT_SITES_ALL
4608: SET
4609: STATUS = 'M',
4610: last_update_date = hz_utility_pub.last_update_date,
4611: last_updated_by = hz_utility_pub.user_id,
4612: last_update_login = hz_utility_pub.last_update_login,
4613: request_id = hz_utility_pub.request_id,
4614: program_application_id = hz_utility_pub.program_application_id,
4607: UPDATE HZ_CUST_ACCT_SITES_ALL
4608: SET
4609: STATUS = 'M',
4610: last_update_date = hz_utility_pub.last_update_date,
4611: last_updated_by = hz_utility_pub.user_id,
4612: last_update_login = hz_utility_pub.last_update_login,
4613: request_id = hz_utility_pub.request_id,
4614: program_application_id = hz_utility_pub.program_application_id,
4615: program_id = hz_utility_pub.program_id,
4608: SET
4609: STATUS = 'M',
4610: last_update_date = hz_utility_pub.last_update_date,
4611: last_updated_by = hz_utility_pub.user_id,
4612: last_update_login = hz_utility_pub.last_update_login,
4613: request_id = hz_utility_pub.request_id,
4614: program_application_id = hz_utility_pub.program_application_id,
4615: program_id = hz_utility_pub.program_id,
4616: program_update_date = sysdate
4609: STATUS = 'M',
4610: last_update_date = hz_utility_pub.last_update_date,
4611: last_updated_by = hz_utility_pub.user_id,
4612: last_update_login = hz_utility_pub.last_update_login,
4613: request_id = hz_utility_pub.request_id,
4614: program_application_id = hz_utility_pub.program_application_id,
4615: program_id = hz_utility_pub.program_id,
4616: program_update_date = sysdate
4617: WHERE cust_acct_site_id = p_from_id;
4610: last_update_date = hz_utility_pub.last_update_date,
4611: last_updated_by = hz_utility_pub.user_id,
4612: last_update_login = hz_utility_pub.last_update_login,
4613: request_id = hz_utility_pub.request_id,
4614: program_application_id = hz_utility_pub.program_application_id,
4615: program_id = hz_utility_pub.program_id,
4616: program_update_date = sysdate
4617: WHERE cust_acct_site_id = p_from_id;
4618:
4611: last_updated_by = hz_utility_pub.user_id,
4612: last_update_login = hz_utility_pub.last_update_login,
4613: request_id = hz_utility_pub.request_id,
4614: program_application_id = hz_utility_pub.program_application_id,
4615: program_id = hz_utility_pub.program_id,
4616: program_update_date = sysdate
4617: WHERE cust_acct_site_id = p_from_id;
4618:
4619: HZ_ORIG_SYSTEM_REF_PVT.remap_internal_identifier(
4639: ELSE
4640: UPDATE HZ_CUST_ACCT_SITES_ALL
4641: SET
4642: party_site_id = p_to_fk_id,
4643: last_update_date = hz_utility_pub.last_update_date,
4644: last_updated_by = hz_utility_pub.user_id,
4645: last_update_login = hz_utility_pub.last_update_login,
4646: request_id = hz_utility_pub.request_id,
4647: program_application_id = hz_utility_pub.program_application_id,
4640: UPDATE HZ_CUST_ACCT_SITES_ALL
4641: SET
4642: party_site_id = p_to_fk_id,
4643: last_update_date = hz_utility_pub.last_update_date,
4644: last_updated_by = hz_utility_pub.user_id,
4645: last_update_login = hz_utility_pub.last_update_login,
4646: request_id = hz_utility_pub.request_id,
4647: program_application_id = hz_utility_pub.program_application_id,
4648: program_id = hz_utility_pub.program_id,
4641: SET
4642: party_site_id = p_to_fk_id,
4643: last_update_date = hz_utility_pub.last_update_date,
4644: last_updated_by = hz_utility_pub.user_id,
4645: last_update_login = hz_utility_pub.last_update_login,
4646: request_id = hz_utility_pub.request_id,
4647: program_application_id = hz_utility_pub.program_application_id,
4648: program_id = hz_utility_pub.program_id,
4649: program_update_date = sysdate
4642: party_site_id = p_to_fk_id,
4643: last_update_date = hz_utility_pub.last_update_date,
4644: last_updated_by = hz_utility_pub.user_id,
4645: last_update_login = hz_utility_pub.last_update_login,
4646: request_id = hz_utility_pub.request_id,
4647: program_application_id = hz_utility_pub.program_application_id,
4648: program_id = hz_utility_pub.program_id,
4649: program_update_date = sysdate
4650: WHERE cust_acct_site_id = p_from_id;
4643: last_update_date = hz_utility_pub.last_update_date,
4644: last_updated_by = hz_utility_pub.user_id,
4645: last_update_login = hz_utility_pub.last_update_login,
4646: request_id = hz_utility_pub.request_id,
4647: program_application_id = hz_utility_pub.program_application_id,
4648: program_id = hz_utility_pub.program_id,
4649: program_update_date = sysdate
4650: WHERE cust_acct_site_id = p_from_id;
4651:
4644: last_updated_by = hz_utility_pub.user_id,
4645: last_update_login = hz_utility_pub.last_update_login,
4646: request_id = hz_utility_pub.request_id,
4647: program_application_id = hz_utility_pub.program_application_id,
4648: program_id = hz_utility_pub.program_id,
4649: program_update_date = sysdate
4650: WHERE cust_acct_site_id = p_from_id;
4651:
4652: END IF;
4674: x_to_id <> p_from_id) THEN
4675: UPDATE HZ_ORG_CONTACTS
4676: SET
4677: STATUS = 'M',
4678: last_update_date = hz_utility_pub.last_update_date,
4679: last_updated_by = hz_utility_pub.user_id,
4680: last_update_login = hz_utility_pub.last_update_login,
4681: request_id = hz_utility_pub.request_id,
4682: program_application_id = hz_utility_pub.program_application_id,
4675: UPDATE HZ_ORG_CONTACTS
4676: SET
4677: STATUS = 'M',
4678: last_update_date = hz_utility_pub.last_update_date,
4679: last_updated_by = hz_utility_pub.user_id,
4680: last_update_login = hz_utility_pub.last_update_login,
4681: request_id = hz_utility_pub.request_id,
4682: program_application_id = hz_utility_pub.program_application_id,
4683: program_id = hz_utility_pub.program_id,
4676: SET
4677: STATUS = 'M',
4678: last_update_date = hz_utility_pub.last_update_date,
4679: last_updated_by = hz_utility_pub.user_id,
4680: last_update_login = hz_utility_pub.last_update_login,
4681: request_id = hz_utility_pub.request_id,
4682: program_application_id = hz_utility_pub.program_application_id,
4683: program_id = hz_utility_pub.program_id,
4684: program_update_date = sysdate
4677: STATUS = 'M',
4678: last_update_date = hz_utility_pub.last_update_date,
4679: last_updated_by = hz_utility_pub.user_id,
4680: last_update_login = hz_utility_pub.last_update_login,
4681: request_id = hz_utility_pub.request_id,
4682: program_application_id = hz_utility_pub.program_application_id,
4683: program_id = hz_utility_pub.program_id,
4684: program_update_date = sysdate
4685: WHERE org_contact_id = p_from_id;
4678: last_update_date = hz_utility_pub.last_update_date,
4679: last_updated_by = hz_utility_pub.user_id,
4680: last_update_login = hz_utility_pub.last_update_login,
4681: request_id = hz_utility_pub.request_id,
4682: program_application_id = hz_utility_pub.program_application_id,
4683: program_id = hz_utility_pub.program_id,
4684: program_update_date = sysdate
4685: WHERE org_contact_id = p_from_id;
4686:
4679: last_updated_by = hz_utility_pub.user_id,
4680: last_update_login = hz_utility_pub.last_update_login,
4681: request_id = hz_utility_pub.request_id,
4682: program_application_id = hz_utility_pub.program_application_id,
4683: program_id = hz_utility_pub.program_id,
4684: program_update_date = sysdate
4685: WHERE org_contact_id = p_from_id;
4686:
4687: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE STAGED_FLAG='N' AND ENTITY='CONTACTS'
4710: ELSE
4711: UPDATE HZ_ORG_CONTACTS
4712: SET
4713: party_site_id = p_to_fk_id,
4714: last_update_date = hz_utility_pub.last_update_date,
4715: last_updated_by = hz_utility_pub.user_id,
4716: last_update_login = hz_utility_pub.last_update_login,
4717: request_id = hz_utility_pub.request_id,
4718: program_application_id = hz_utility_pub.program_application_id,
4711: UPDATE HZ_ORG_CONTACTS
4712: SET
4713: party_site_id = p_to_fk_id,
4714: last_update_date = hz_utility_pub.last_update_date,
4715: last_updated_by = hz_utility_pub.user_id,
4716: last_update_login = hz_utility_pub.last_update_login,
4717: request_id = hz_utility_pub.request_id,
4718: program_application_id = hz_utility_pub.program_application_id,
4719: program_id = hz_utility_pub.program_id,
4712: SET
4713: party_site_id = p_to_fk_id,
4714: last_update_date = hz_utility_pub.last_update_date,
4715: last_updated_by = hz_utility_pub.user_id,
4716: last_update_login = hz_utility_pub.last_update_login,
4717: request_id = hz_utility_pub.request_id,
4718: program_application_id = hz_utility_pub.program_application_id,
4719: program_id = hz_utility_pub.program_id,
4720: program_update_date = sysdate
4713: party_site_id = p_to_fk_id,
4714: last_update_date = hz_utility_pub.last_update_date,
4715: last_updated_by = hz_utility_pub.user_id,
4716: last_update_login = hz_utility_pub.last_update_login,
4717: request_id = hz_utility_pub.request_id,
4718: program_application_id = hz_utility_pub.program_application_id,
4719: program_id = hz_utility_pub.program_id,
4720: program_update_date = sysdate
4721: WHERE org_contact_id = p_from_id;
4714: last_update_date = hz_utility_pub.last_update_date,
4715: last_updated_by = hz_utility_pub.user_id,
4716: last_update_login = hz_utility_pub.last_update_login,
4717: request_id = hz_utility_pub.request_id,
4718: program_application_id = hz_utility_pub.program_application_id,
4719: program_id = hz_utility_pub.program_id,
4720: program_update_date = sysdate
4721: WHERE org_contact_id = p_from_id;
4722:
4715: last_updated_by = hz_utility_pub.user_id,
4716: last_update_login = hz_utility_pub.last_update_login,
4717: request_id = hz_utility_pub.request_id,
4718: program_application_id = hz_utility_pub.program_application_id,
4719: program_id = hz_utility_pub.program_id,
4720: program_update_date = sysdate
4721: WHERE org_contact_id = p_from_id;
4722:
4723: END IF;
4793: CLOSE c_merge_to_org_contact;
4794: UPDATE HZ_ORG_CONTACTS
4795: SET
4796: party_relationship_id = p_to_fk_id,
4797: last_update_date = hz_utility_pub.last_update_date,
4798: last_updated_by = hz_utility_pub.user_id,
4799: last_update_login = hz_utility_pub.last_update_login,
4800: request_id = hz_utility_pub.request_id,
4801: program_application_id = hz_utility_pub.program_application_id,
4794: UPDATE HZ_ORG_CONTACTS
4795: SET
4796: party_relationship_id = p_to_fk_id,
4797: last_update_date = hz_utility_pub.last_update_date,
4798: last_updated_by = hz_utility_pub.user_id,
4799: last_update_login = hz_utility_pub.last_update_login,
4800: request_id = hz_utility_pub.request_id,
4801: program_application_id = hz_utility_pub.program_application_id,
4802: program_id = hz_utility_pub.program_id,
4795: SET
4796: party_relationship_id = p_to_fk_id,
4797: last_update_date = hz_utility_pub.last_update_date,
4798: last_updated_by = hz_utility_pub.user_id,
4799: last_update_login = hz_utility_pub.last_update_login,
4800: request_id = hz_utility_pub.request_id,
4801: program_application_id = hz_utility_pub.program_application_id,
4802: program_id = hz_utility_pub.program_id,
4803: program_update_date = sysdate
4796: party_relationship_id = p_to_fk_id,
4797: last_update_date = hz_utility_pub.last_update_date,
4798: last_updated_by = hz_utility_pub.user_id,
4799: last_update_login = hz_utility_pub.last_update_login,
4800: request_id = hz_utility_pub.request_id,
4801: program_application_id = hz_utility_pub.program_application_id,
4802: program_id = hz_utility_pub.program_id,
4803: program_update_date = sysdate
4804: WHERE org_contact_id = p_from_id;
4797: last_update_date = hz_utility_pub.last_update_date,
4798: last_updated_by = hz_utility_pub.user_id,
4799: last_update_login = hz_utility_pub.last_update_login,
4800: request_id = hz_utility_pub.request_id,
4801: program_application_id = hz_utility_pub.program_application_id,
4802: program_id = hz_utility_pub.program_id,
4803: program_update_date = sysdate
4804: WHERE org_contact_id = p_from_id;
4805: ELSE
4798: last_updated_by = hz_utility_pub.user_id,
4799: last_update_login = hz_utility_pub.last_update_login,
4800: request_id = hz_utility_pub.request_id,
4801: program_application_id = hz_utility_pub.program_application_id,
4802: program_id = hz_utility_pub.program_id,
4803: program_update_date = sysdate
4804: WHERE org_contact_id = p_from_id;
4805: ELSE
4806: CLOSE c_merge_to_org_contact;
4847:
4848: UPDATE HZ_ORG_CONTACTS
4849: SET
4850: STATUS = 'M',
4851: last_update_date = hz_utility_pub.last_update_date,
4852: last_updated_by = hz_utility_pub.user_id,
4853: last_update_login = hz_utility_pub.last_update_login,
4854: request_id = hz_utility_pub.request_id,
4855: program_application_id = hz_utility_pub.program_application_id,
4848: UPDATE HZ_ORG_CONTACTS
4849: SET
4850: STATUS = 'M',
4851: last_update_date = hz_utility_pub.last_update_date,
4852: last_updated_by = hz_utility_pub.user_id,
4853: last_update_login = hz_utility_pub.last_update_login,
4854: request_id = hz_utility_pub.request_id,
4855: program_application_id = hz_utility_pub.program_application_id,
4856: program_id = hz_utility_pub.program_id,
4849: SET
4850: STATUS = 'M',
4851: last_update_date = hz_utility_pub.last_update_date,
4852: last_updated_by = hz_utility_pub.user_id,
4853: last_update_login = hz_utility_pub.last_update_login,
4854: request_id = hz_utility_pub.request_id,
4855: program_application_id = hz_utility_pub.program_application_id,
4856: program_id = hz_utility_pub.program_id,
4857: program_update_date = sysdate
4850: STATUS = 'M',
4851: last_update_date = hz_utility_pub.last_update_date,
4852: last_updated_by = hz_utility_pub.user_id,
4853: last_update_login = hz_utility_pub.last_update_login,
4854: request_id = hz_utility_pub.request_id,
4855: program_application_id = hz_utility_pub.program_application_id,
4856: program_id = hz_utility_pub.program_id,
4857: program_update_date = sysdate
4858: WHERE org_contact_id = p_from_id;
4851: last_update_date = hz_utility_pub.last_update_date,
4852: last_updated_by = hz_utility_pub.user_id,
4853: last_update_login = hz_utility_pub.last_update_login,
4854: request_id = hz_utility_pub.request_id,
4855: program_application_id = hz_utility_pub.program_application_id,
4856: program_id = hz_utility_pub.program_id,
4857: program_update_date = sysdate
4858: WHERE org_contact_id = p_from_id;
4859:
4852: last_updated_by = hz_utility_pub.user_id,
4853: last_update_login = hz_utility_pub.last_update_login,
4854: request_id = hz_utility_pub.request_id,
4855: program_application_id = hz_utility_pub.program_application_id,
4856: program_id = hz_utility_pub.program_id,
4857: program_update_date = sysdate
4858: WHERE org_contact_id = p_from_id;
4859:
4860: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE STAGED_FLAG='N' AND ENTITY='CONTACTS'
5147: OPEN c_to_party_reln;
5148: UPDATE HZ_RELATIONSHIPS
5149: SET
5150: party_id = l_from_party_id,
5151: last_update_date = hz_utility_pub.last_update_date,
5152: last_updated_by = hz_utility_pub.user_id,
5153: last_update_login = hz_utility_pub.last_update_login,
5154: request_id = hz_utility_pub.request_id,
5155: program_application_id = hz_utility_pub.program_application_id,
5148: UPDATE HZ_RELATIONSHIPS
5149: SET
5150: party_id = l_from_party_id,
5151: last_update_date = hz_utility_pub.last_update_date,
5152: last_updated_by = hz_utility_pub.user_id,
5153: last_update_login = hz_utility_pub.last_update_login,
5154: request_id = hz_utility_pub.request_id,
5155: program_application_id = hz_utility_pub.program_application_id,
5156: program_id = hz_utility_pub.program_id,
5149: SET
5150: party_id = l_from_party_id,
5151: last_update_date = hz_utility_pub.last_update_date,
5152: last_updated_by = hz_utility_pub.user_id,
5153: last_update_login = hz_utility_pub.last_update_login,
5154: request_id = hz_utility_pub.request_id,
5155: program_application_id = hz_utility_pub.program_application_id,
5156: program_id = hz_utility_pub.program_id,
5157: program_update_date = sysdate
5150: party_id = l_from_party_id,
5151: last_update_date = hz_utility_pub.last_update_date,
5152: last_updated_by = hz_utility_pub.user_id,
5153: last_update_login = hz_utility_pub.last_update_login,
5154: request_id = hz_utility_pub.request_id,
5155: program_application_id = hz_utility_pub.program_application_id,
5156: program_id = hz_utility_pub.program_id,
5157: program_update_date = sysdate
5158: WHERE relationship_id = x_to_id;
5151: last_update_date = hz_utility_pub.last_update_date,
5152: last_updated_by = hz_utility_pub.user_id,
5153: last_update_login = hz_utility_pub.last_update_login,
5154: request_id = hz_utility_pub.request_id,
5155: program_application_id = hz_utility_pub.program_application_id,
5156: program_id = hz_utility_pub.program_id,
5157: program_update_date = sysdate
5158: WHERE relationship_id = x_to_id;
5159: CLOSE c_to_party_reln;
5152: last_updated_by = hz_utility_pub.user_id,
5153: last_update_login = hz_utility_pub.last_update_login,
5154: request_id = hz_utility_pub.request_id,
5155: program_application_id = hz_utility_pub.program_application_id,
5156: program_id = hz_utility_pub.program_id,
5157: program_update_date = sysdate
5158: WHERE relationship_id = x_to_id;
5159: CLOSE c_to_party_reln;
5160: END IF;
5161:
5162: UPDATE HZ_RELATIONSHIPS
5163: SET
5164: STATUS = 'M',
5165: last_update_date = hz_utility_pub.last_update_date,
5166: last_updated_by = hz_utility_pub.user_id,
5167: last_update_login = hz_utility_pub.last_update_login,
5168: request_id = hz_utility_pub.request_id,
5169: program_application_id = hz_utility_pub.program_application_id,
5162: UPDATE HZ_RELATIONSHIPS
5163: SET
5164: STATUS = 'M',
5165: last_update_date = hz_utility_pub.last_update_date,
5166: last_updated_by = hz_utility_pub.user_id,
5167: last_update_login = hz_utility_pub.last_update_login,
5168: request_id = hz_utility_pub.request_id,
5169: program_application_id = hz_utility_pub.program_application_id,
5170: program_id = hz_utility_pub.program_id,
5163: SET
5164: STATUS = 'M',
5165: last_update_date = hz_utility_pub.last_update_date,
5166: last_updated_by = hz_utility_pub.user_id,
5167: last_update_login = hz_utility_pub.last_update_login,
5168: request_id = hz_utility_pub.request_id,
5169: program_application_id = hz_utility_pub.program_application_id,
5170: program_id = hz_utility_pub.program_id,
5171: program_update_date = sysdate
5164: STATUS = 'M',
5165: last_update_date = hz_utility_pub.last_update_date,
5166: last_updated_by = hz_utility_pub.user_id,
5167: last_update_login = hz_utility_pub.last_update_login,
5168: request_id = hz_utility_pub.request_id,
5169: program_application_id = hz_utility_pub.program_application_id,
5170: program_id = hz_utility_pub.program_id,
5171: program_update_date = sysdate
5172: WHERE relationship_id = p_from_id;
5165: last_update_date = hz_utility_pub.last_update_date,
5166: last_updated_by = hz_utility_pub.user_id,
5167: last_update_login = hz_utility_pub.last_update_login,
5168: request_id = hz_utility_pub.request_id,
5169: program_application_id = hz_utility_pub.program_application_id,
5170: program_id = hz_utility_pub.program_id,
5171: program_update_date = sysdate
5172: WHERE relationship_id = p_from_id;
5173:
5166: last_updated_by = hz_utility_pub.user_id,
5167: last_update_login = hz_utility_pub.last_update_login,
5168: request_id = hz_utility_pub.request_id,
5169: program_application_id = hz_utility_pub.program_application_id,
5170: program_id = hz_utility_pub.program_id,
5171: program_update_date = sysdate
5172: WHERE relationship_id = p_from_id;
5173:
5174: --4307667 merge usages with owner_table_name 'HZ_RELATIONSHIPS'
5199: WHERE orig_system = from_cont_source;
5200: OPEN c_check_valid_merge(from_start_date, from_end_date, from_cont_source_type,from_cont_source);
5201: FETCH c_check_valid_merge INTO l_dup_reln_id, l_request_id;
5202: IF c_check_valid_merge%FOUND AND
5203: l_request_id <> hz_utility_pub.request_id THEN
5204: CLOSE c_check_valid_merge;
5205: FND_MESSAGE.SET_NAME('AR', 'HZ_RELN_TRANSFER_NOT_ALLOWED');
5206: FND_MESSAGE.SET_TOKEN('FROMID',p_from_id);
5207: FND_MSG_PUB.ADD;
5255: ----End of DlProject Phase2--------------------
5256: UPDATE HZ_RELATIONSHIPS
5257: SET
5258: object_id = p_to_fk_id,
5259: last_update_date = hz_utility_pub.last_update_date,
5260: last_updated_by = hz_utility_pub.user_id,
5261: last_update_login = hz_utility_pub.last_update_login,
5262: request_id = hz_utility_pub.request_id,
5263: program_application_id = hz_utility_pub.program_application_id,
5256: UPDATE HZ_RELATIONSHIPS
5257: SET
5258: object_id = p_to_fk_id,
5259: last_update_date = hz_utility_pub.last_update_date,
5260: last_updated_by = hz_utility_pub.user_id,
5261: last_update_login = hz_utility_pub.last_update_login,
5262: request_id = hz_utility_pub.request_id,
5263: program_application_id = hz_utility_pub.program_application_id,
5264: program_id = hz_utility_pub.program_id,
5257: SET
5258: object_id = p_to_fk_id,
5259: last_update_date = hz_utility_pub.last_update_date,
5260: last_updated_by = hz_utility_pub.user_id,
5261: last_update_login = hz_utility_pub.last_update_login,
5262: request_id = hz_utility_pub.request_id,
5263: program_application_id = hz_utility_pub.program_application_id,
5264: program_id = hz_utility_pub.program_id,
5265: program_update_date = sysdate
5258: object_id = p_to_fk_id,
5259: last_update_date = hz_utility_pub.last_update_date,
5260: last_updated_by = hz_utility_pub.user_id,
5261: last_update_login = hz_utility_pub.last_update_login,
5262: request_id = hz_utility_pub.request_id,
5263: program_application_id = hz_utility_pub.program_application_id,
5264: program_id = hz_utility_pub.program_id,
5265: program_update_date = sysdate
5266: WHERE relationship_id = p_from_id
5259: last_update_date = hz_utility_pub.last_update_date,
5260: last_updated_by = hz_utility_pub.user_id,
5261: last_update_login = hz_utility_pub.last_update_login,
5262: request_id = hz_utility_pub.request_id,
5263: program_application_id = hz_utility_pub.program_application_id,
5264: program_id = hz_utility_pub.program_id,
5265: program_update_date = sysdate
5266: WHERE relationship_id = p_from_id
5267: AND DIRECTIONAL_FLAG = 'F'
5260: last_updated_by = hz_utility_pub.user_id,
5261: last_update_login = hz_utility_pub.last_update_login,
5262: request_id = hz_utility_pub.request_id,
5263: program_application_id = hz_utility_pub.program_application_id,
5264: program_id = hz_utility_pub.program_id,
5265: program_update_date = sysdate
5266: WHERE relationship_id = p_from_id
5267: AND DIRECTIONAL_FLAG = 'F'
5268: RETURNING subject_id, relationship_type, relationship_code,
5272:
5273: UPDATE HZ_RELATIONSHIPS
5274: SET
5275: subject_id = p_to_fk_id,
5276: last_update_date = hz_utility_pub.last_update_date,
5277: last_updated_by = hz_utility_pub.user_id,
5278: last_update_login = hz_utility_pub.last_update_login,
5279: request_id = hz_utility_pub.request_id,
5280: program_application_id = hz_utility_pub.program_application_id,
5273: UPDATE HZ_RELATIONSHIPS
5274: SET
5275: subject_id = p_to_fk_id,
5276: last_update_date = hz_utility_pub.last_update_date,
5277: last_updated_by = hz_utility_pub.user_id,
5278: last_update_login = hz_utility_pub.last_update_login,
5279: request_id = hz_utility_pub.request_id,
5280: program_application_id = hz_utility_pub.program_application_id,
5281: program_id = hz_utility_pub.program_id,
5274: SET
5275: subject_id = p_to_fk_id,
5276: last_update_date = hz_utility_pub.last_update_date,
5277: last_updated_by = hz_utility_pub.user_id,
5278: last_update_login = hz_utility_pub.last_update_login,
5279: request_id = hz_utility_pub.request_id,
5280: program_application_id = hz_utility_pub.program_application_id,
5281: program_id = hz_utility_pub.program_id,
5282: program_update_date = sysdate
5275: subject_id = p_to_fk_id,
5276: last_update_date = hz_utility_pub.last_update_date,
5277: last_updated_by = hz_utility_pub.user_id,
5278: last_update_login = hz_utility_pub.last_update_login,
5279: request_id = hz_utility_pub.request_id,
5280: program_application_id = hz_utility_pub.program_application_id,
5281: program_id = hz_utility_pub.program_id,
5282: program_update_date = sysdate
5283: WHERE relationship_id = p_from_id
5276: last_update_date = hz_utility_pub.last_update_date,
5277: last_updated_by = hz_utility_pub.user_id,
5278: last_update_login = hz_utility_pub.last_update_login,
5279: request_id = hz_utility_pub.request_id,
5280: program_application_id = hz_utility_pub.program_application_id,
5281: program_id = hz_utility_pub.program_id,
5282: program_update_date = sysdate
5283: WHERE relationship_id = p_from_id
5284: AND DIRECTIONAL_FLAG = 'B';
5277: last_updated_by = hz_utility_pub.user_id,
5278: last_update_login = hz_utility_pub.last_update_login,
5279: request_id = hz_utility_pub.request_id,
5280: program_application_id = hz_utility_pub.program_application_id,
5281: program_id = hz_utility_pub.program_id,
5282: program_update_date = sysdate
5283: WHERE relationship_id = p_from_id
5284: AND DIRECTIONAL_FLAG = 'B';
5285:
5322: UPDATE HZ_RELATIONSHIPS
5323: SET
5324: STATUS = 'I',
5325: END_DATE = sysdate,
5326: last_update_date = hz_utility_pub.last_update_date,
5327: last_updated_by = hz_utility_pub.user_id,
5328: last_update_login = hz_utility_pub.last_update_login,
5329: request_id = hz_utility_pub.request_id,
5330: program_application_id = hz_utility_pub.program_application_id,
5323: SET
5324: STATUS = 'I',
5325: END_DATE = sysdate,
5326: last_update_date = hz_utility_pub.last_update_date,
5327: last_updated_by = hz_utility_pub.user_id,
5328: last_update_login = hz_utility_pub.last_update_login,
5329: request_id = hz_utility_pub.request_id,
5330: program_application_id = hz_utility_pub.program_application_id,
5331: program_id = hz_utility_pub.program_id,
5324: STATUS = 'I',
5325: END_DATE = sysdate,
5326: last_update_date = hz_utility_pub.last_update_date,
5327: last_updated_by = hz_utility_pub.user_id,
5328: last_update_login = hz_utility_pub.last_update_login,
5329: request_id = hz_utility_pub.request_id,
5330: program_application_id = hz_utility_pub.program_application_id,
5331: program_id = hz_utility_pub.program_id,
5332: program_update_date = sysdate
5325: END_DATE = sysdate,
5326: last_update_date = hz_utility_pub.last_update_date,
5327: last_updated_by = hz_utility_pub.user_id,
5328: last_update_login = hz_utility_pub.last_update_login,
5329: request_id = hz_utility_pub.request_id,
5330: program_application_id = hz_utility_pub.program_application_id,
5331: program_id = hz_utility_pub.program_id,
5332: program_update_date = sysdate
5333: WHERE relationship_id = p_from_id;
5326: last_update_date = hz_utility_pub.last_update_date,
5327: last_updated_by = hz_utility_pub.user_id,
5328: last_update_login = hz_utility_pub.last_update_login,
5329: request_id = hz_utility_pub.request_id,
5330: program_application_id = hz_utility_pub.program_application_id,
5331: program_id = hz_utility_pub.program_id,
5332: program_update_date = sysdate
5333: WHERE relationship_id = p_from_id;
5334: ---Start of Bug:3880218----
5327: last_updated_by = hz_utility_pub.user_id,
5328: last_update_login = hz_utility_pub.last_update_login,
5329: request_id = hz_utility_pub.request_id,
5330: program_application_id = hz_utility_pub.program_application_id,
5331: program_id = hz_utility_pub.program_id,
5332: program_update_date = sysdate
5333: WHERE relationship_id = p_from_id;
5334: ---Start of Bug:3880218----
5335: IF l_rel_party_id is not null THEN
5334: ---Start of Bug:3880218----
5335: IF l_rel_party_id is not null THEN
5336: UPDATE HZ_PARTIES
5337: SET STATUS = 'I',
5338: last_update_date = hz_utility_pub.last_update_date,
5339: last_updated_by = hz_utility_pub.user_id,
5340: last_update_login = hz_utility_pub.last_update_login,
5341: request_id = hz_utility_pub.request_id,
5342: program_application_id = hz_utility_pub.program_application_id,
5335: IF l_rel_party_id is not null THEN
5336: UPDATE HZ_PARTIES
5337: SET STATUS = 'I',
5338: last_update_date = hz_utility_pub.last_update_date,
5339: last_updated_by = hz_utility_pub.user_id,
5340: last_update_login = hz_utility_pub.last_update_login,
5341: request_id = hz_utility_pub.request_id,
5342: program_application_id = hz_utility_pub.program_application_id,
5343: program_id = hz_utility_pub.program_id,
5336: UPDATE HZ_PARTIES
5337: SET STATUS = 'I',
5338: last_update_date = hz_utility_pub.last_update_date,
5339: last_updated_by = hz_utility_pub.user_id,
5340: last_update_login = hz_utility_pub.last_update_login,
5341: request_id = hz_utility_pub.request_id,
5342: program_application_id = hz_utility_pub.program_application_id,
5343: program_id = hz_utility_pub.program_id,
5344: program_update_date = sysdate
5337: SET STATUS = 'I',
5338: last_update_date = hz_utility_pub.last_update_date,
5339: last_updated_by = hz_utility_pub.user_id,
5340: last_update_login = hz_utility_pub.last_update_login,
5341: request_id = hz_utility_pub.request_id,
5342: program_application_id = hz_utility_pub.program_application_id,
5343: program_id = hz_utility_pub.program_id,
5344: program_update_date = sysdate
5345: WHERE PARTY_ID = l_rel_party_id;
5338: last_update_date = hz_utility_pub.last_update_date,
5339: last_updated_by = hz_utility_pub.user_id,
5340: last_update_login = hz_utility_pub.last_update_login,
5341: request_id = hz_utility_pub.request_id,
5342: program_application_id = hz_utility_pub.program_application_id,
5343: program_id = hz_utility_pub.program_id,
5344: program_update_date = sysdate
5345: WHERE PARTY_ID = l_rel_party_id;
5346: END IF;
5339: last_updated_by = hz_utility_pub.user_id,
5340: last_update_login = hz_utility_pub.last_update_login,
5341: request_id = hz_utility_pub.request_id,
5342: program_application_id = hz_utility_pub.program_application_id,
5343: program_id = hz_utility_pub.program_id,
5344: program_update_date = sysdate
5345: WHERE PARTY_ID = l_rel_party_id;
5346: END IF;
5347: ----End of Bug:3880218----
5357: --bug 4867151--start
5358: IF l_rel_party_id is not null THEN
5359: UPDATE HZ_PARTIES
5360: SET STATUS = 'M',
5361: last_update_date = hz_utility_pub.last_update_date,
5362: last_updated_by = hz_utility_pub.user_id,
5363: last_update_login = hz_utility_pub.last_update_login,
5364: request_id = hz_utility_pub.request_id,
5365: program_application_id = hz_utility_pub.program_application_id,
5358: IF l_rel_party_id is not null THEN
5359: UPDATE HZ_PARTIES
5360: SET STATUS = 'M',
5361: last_update_date = hz_utility_pub.last_update_date,
5362: last_updated_by = hz_utility_pub.user_id,
5363: last_update_login = hz_utility_pub.last_update_login,
5364: request_id = hz_utility_pub.request_id,
5365: program_application_id = hz_utility_pub.program_application_id,
5366: program_id = hz_utility_pub.program_id,
5359: UPDATE HZ_PARTIES
5360: SET STATUS = 'M',
5361: last_update_date = hz_utility_pub.last_update_date,
5362: last_updated_by = hz_utility_pub.user_id,
5363: last_update_login = hz_utility_pub.last_update_login,
5364: request_id = hz_utility_pub.request_id,
5365: program_application_id = hz_utility_pub.program_application_id,
5366: program_id = hz_utility_pub.program_id,
5367: program_update_date = sysdate
5360: SET STATUS = 'M',
5361: last_update_date = hz_utility_pub.last_update_date,
5362: last_updated_by = hz_utility_pub.user_id,
5363: last_update_login = hz_utility_pub.last_update_login,
5364: request_id = hz_utility_pub.request_id,
5365: program_application_id = hz_utility_pub.program_application_id,
5366: program_id = hz_utility_pub.program_id,
5367: program_update_date = sysdate
5368: WHERE PARTY_ID in (select party_id from hz_relationships where subject_id=p_to_fk_id
5361: last_update_date = hz_utility_pub.last_update_date,
5362: last_updated_by = hz_utility_pub.user_id,
5363: last_update_login = hz_utility_pub.last_update_login,
5364: request_id = hz_utility_pub.request_id,
5365: program_application_id = hz_utility_pub.program_application_id,
5366: program_id = hz_utility_pub.program_id,
5367: program_update_date = sysdate
5368: WHERE PARTY_ID in (select party_id from hz_relationships where subject_id=p_to_fk_id
5369: and object_id=p_to_fk_id and relationship_id <>p_from_id and status='A'
5362: last_updated_by = hz_utility_pub.user_id,
5363: last_update_login = hz_utility_pub.last_update_login,
5364: request_id = hz_utility_pub.request_id,
5365: program_application_id = hz_utility_pub.program_application_id,
5366: program_id = hz_utility_pub.program_id,
5367: program_update_date = sysdate
5368: WHERE PARTY_ID in (select party_id from hz_relationships where subject_id=p_to_fk_id
5369: and object_id=p_to_fk_id and relationship_id <>p_from_id and status='A'
5370: AND ((start_date between from_start_date and from_end_date)
5375: UPDATE HZ_RELATIONSHIPS
5376: SET
5377: STATUS = 'M',
5378: END_DATE = sysdate,
5379: last_update_date = hz_utility_pub.last_update_date,
5380: last_updated_by = hz_utility_pub.user_id,
5381: last_update_login = hz_utility_pub.last_update_login,
5382: request_id = hz_utility_pub.request_id,
5383: program_application_id = hz_utility_pub.program_application_id,
5376: SET
5377: STATUS = 'M',
5378: END_DATE = sysdate,
5379: last_update_date = hz_utility_pub.last_update_date,
5380: last_updated_by = hz_utility_pub.user_id,
5381: last_update_login = hz_utility_pub.last_update_login,
5382: request_id = hz_utility_pub.request_id,
5383: program_application_id = hz_utility_pub.program_application_id,
5384: program_id = hz_utility_pub.program_id,
5377: STATUS = 'M',
5378: END_DATE = sysdate,
5379: last_update_date = hz_utility_pub.last_update_date,
5380: last_updated_by = hz_utility_pub.user_id,
5381: last_update_login = hz_utility_pub.last_update_login,
5382: request_id = hz_utility_pub.request_id,
5383: program_application_id = hz_utility_pub.program_application_id,
5384: program_id = hz_utility_pub.program_id,
5385: program_update_date = sysdate
5378: END_DATE = sysdate,
5379: last_update_date = hz_utility_pub.last_update_date,
5380: last_updated_by = hz_utility_pub.user_id,
5381: last_update_login = hz_utility_pub.last_update_login,
5382: request_id = hz_utility_pub.request_id,
5383: program_application_id = hz_utility_pub.program_application_id,
5384: program_id = hz_utility_pub.program_id,
5385: program_update_date = sysdate
5386: WHERE relationship_id in (select relationship_id from hz_relationships where subject_id=p_to_fk_id
5379: last_update_date = hz_utility_pub.last_update_date,
5380: last_updated_by = hz_utility_pub.user_id,
5381: last_update_login = hz_utility_pub.last_update_login,
5382: request_id = hz_utility_pub.request_id,
5383: program_application_id = hz_utility_pub.program_application_id,
5384: program_id = hz_utility_pub.program_id,
5385: program_update_date = sysdate
5386: WHERE relationship_id in (select relationship_id from hz_relationships where subject_id=p_to_fk_id
5387: and object_id=p_to_fk_id and relationship_id <>p_from_id and status='A'
5380: last_updated_by = hz_utility_pub.user_id,
5381: last_update_login = hz_utility_pub.last_update_login,
5382: request_id = hz_utility_pub.request_id,
5383: program_application_id = hz_utility_pub.program_application_id,
5384: program_id = hz_utility_pub.program_id,
5385: program_update_date = sysdate
5386: WHERE relationship_id in (select relationship_id from hz_relationships where subject_id=p_to_fk_id
5387: and object_id=p_to_fk_id and relationship_id <>p_from_id and status='A'
5388: AND ((start_date between from_start_date and from_end_date)
5541: OPEN c_to_party_reln;
5542: UPDATE HZ_RELATIONSHIPS
5543: SET
5544: party_id = l_from_party_id,
5545: last_update_date = hz_utility_pub.last_update_date,
5546: last_updated_by = hz_utility_pub.user_id,
5547: last_update_login = hz_utility_pub.last_update_login,
5548: request_id = hz_utility_pub.request_id,
5549: program_application_id = hz_utility_pub.program_application_id,
5542: UPDATE HZ_RELATIONSHIPS
5543: SET
5544: party_id = l_from_party_id,
5545: last_update_date = hz_utility_pub.last_update_date,
5546: last_updated_by = hz_utility_pub.user_id,
5547: last_update_login = hz_utility_pub.last_update_login,
5548: request_id = hz_utility_pub.request_id,
5549: program_application_id = hz_utility_pub.program_application_id,
5550: program_id = hz_utility_pub.program_id,
5543: SET
5544: party_id = l_from_party_id,
5545: last_update_date = hz_utility_pub.last_update_date,
5546: last_updated_by = hz_utility_pub.user_id,
5547: last_update_login = hz_utility_pub.last_update_login,
5548: request_id = hz_utility_pub.request_id,
5549: program_application_id = hz_utility_pub.program_application_id,
5550: program_id = hz_utility_pub.program_id,
5551: program_update_date = sysdate
5544: party_id = l_from_party_id,
5545: last_update_date = hz_utility_pub.last_update_date,
5546: last_updated_by = hz_utility_pub.user_id,
5547: last_update_login = hz_utility_pub.last_update_login,
5548: request_id = hz_utility_pub.request_id,
5549: program_application_id = hz_utility_pub.program_application_id,
5550: program_id = hz_utility_pub.program_id,
5551: program_update_date = sysdate
5552: WHERE relationship_id = x_to_id;
5545: last_update_date = hz_utility_pub.last_update_date,
5546: last_updated_by = hz_utility_pub.user_id,
5547: last_update_login = hz_utility_pub.last_update_login,
5548: request_id = hz_utility_pub.request_id,
5549: program_application_id = hz_utility_pub.program_application_id,
5550: program_id = hz_utility_pub.program_id,
5551: program_update_date = sysdate
5552: WHERE relationship_id = x_to_id;
5553: CLOSE c_to_party_reln;
5546: last_updated_by = hz_utility_pub.user_id,
5547: last_update_login = hz_utility_pub.last_update_login,
5548: request_id = hz_utility_pub.request_id,
5549: program_application_id = hz_utility_pub.program_application_id,
5550: program_id = hz_utility_pub.program_id,
5551: program_update_date = sysdate
5552: WHERE relationship_id = x_to_id;
5553: CLOSE c_to_party_reln;
5554: END IF;
5555:
5556: UPDATE HZ_RELATIONSHIPS
5557: SET
5558: STATUS = 'M',
5559: last_update_date = hz_utility_pub.last_update_date,
5560: last_updated_by = hz_utility_pub.user_id,
5561: last_update_login = hz_utility_pub.last_update_login,
5562: request_id = hz_utility_pub.request_id,
5563: program_application_id = hz_utility_pub.program_application_id,
5556: UPDATE HZ_RELATIONSHIPS
5557: SET
5558: STATUS = 'M',
5559: last_update_date = hz_utility_pub.last_update_date,
5560: last_updated_by = hz_utility_pub.user_id,
5561: last_update_login = hz_utility_pub.last_update_login,
5562: request_id = hz_utility_pub.request_id,
5563: program_application_id = hz_utility_pub.program_application_id,
5564: program_id = hz_utility_pub.program_id,
5557: SET
5558: STATUS = 'M',
5559: last_update_date = hz_utility_pub.last_update_date,
5560: last_updated_by = hz_utility_pub.user_id,
5561: last_update_login = hz_utility_pub.last_update_login,
5562: request_id = hz_utility_pub.request_id,
5563: program_application_id = hz_utility_pub.program_application_id,
5564: program_id = hz_utility_pub.program_id,
5565: program_update_date = sysdate
5558: STATUS = 'M',
5559: last_update_date = hz_utility_pub.last_update_date,
5560: last_updated_by = hz_utility_pub.user_id,
5561: last_update_login = hz_utility_pub.last_update_login,
5562: request_id = hz_utility_pub.request_id,
5563: program_application_id = hz_utility_pub.program_application_id,
5564: program_id = hz_utility_pub.program_id,
5565: program_update_date = sysdate
5566: WHERE relationship_id = p_from_id;
5559: last_update_date = hz_utility_pub.last_update_date,
5560: last_updated_by = hz_utility_pub.user_id,
5561: last_update_login = hz_utility_pub.last_update_login,
5562: request_id = hz_utility_pub.request_id,
5563: program_application_id = hz_utility_pub.program_application_id,
5564: program_id = hz_utility_pub.program_id,
5565: program_update_date = sysdate
5566: WHERE relationship_id = p_from_id;
5567:
5560: last_updated_by = hz_utility_pub.user_id,
5561: last_update_login = hz_utility_pub.last_update_login,
5562: request_id = hz_utility_pub.request_id,
5563: program_application_id = hz_utility_pub.program_application_id,
5564: program_id = hz_utility_pub.program_id,
5565: program_update_date = sysdate
5566: WHERE relationship_id = p_from_id;
5567:
5568:
5597: OPEN c_check_valid_merge(from_start_date,from_end_date,from_cont_source_type,from_cont_source);
5598:
5599: FETCH c_check_valid_merge INTO l_dup_reln_id, l_request_id;
5600: IF c_check_valid_merge%FOUND AND
5601: l_request_id <> hz_utility_pub.request_id THEN
5602: CLOSE c_check_valid_merge;
5603:
5604: FND_MESSAGE.SET_NAME('AR', 'HZ_RELN_TRANSFER_NOT_ALLOWED');
5605: FND_MESSAGE.SET_TOKEN('FROMID',p_from_id);
5652:
5653: UPDATE HZ_RELATIONSHIPS
5654: SET
5655: subject_id = p_to_fk_id,
5656: last_update_date = hz_utility_pub.last_update_date,
5657: last_updated_by = hz_utility_pub.user_id,
5658: last_update_login = hz_utility_pub.last_update_login,
5659: request_id = hz_utility_pub.request_id,
5660: program_application_id = hz_utility_pub.program_application_id,
5653: UPDATE HZ_RELATIONSHIPS
5654: SET
5655: subject_id = p_to_fk_id,
5656: last_update_date = hz_utility_pub.last_update_date,
5657: last_updated_by = hz_utility_pub.user_id,
5658: last_update_login = hz_utility_pub.last_update_login,
5659: request_id = hz_utility_pub.request_id,
5660: program_application_id = hz_utility_pub.program_application_id,
5661: program_id = hz_utility_pub.program_id,
5654: SET
5655: subject_id = p_to_fk_id,
5656: last_update_date = hz_utility_pub.last_update_date,
5657: last_updated_by = hz_utility_pub.user_id,
5658: last_update_login = hz_utility_pub.last_update_login,
5659: request_id = hz_utility_pub.request_id,
5660: program_application_id = hz_utility_pub.program_application_id,
5661: program_id = hz_utility_pub.program_id,
5662: program_update_date = sysdate
5655: subject_id = p_to_fk_id,
5656: last_update_date = hz_utility_pub.last_update_date,
5657: last_updated_by = hz_utility_pub.user_id,
5658: last_update_login = hz_utility_pub.last_update_login,
5659: request_id = hz_utility_pub.request_id,
5660: program_application_id = hz_utility_pub.program_application_id,
5661: program_id = hz_utility_pub.program_id,
5662: program_update_date = sysdate
5663: WHERE relationship_id = p_from_id
5656: last_update_date = hz_utility_pub.last_update_date,
5657: last_updated_by = hz_utility_pub.user_id,
5658: last_update_login = hz_utility_pub.last_update_login,
5659: request_id = hz_utility_pub.request_id,
5660: program_application_id = hz_utility_pub.program_application_id,
5661: program_id = hz_utility_pub.program_id,
5662: program_update_date = sysdate
5663: WHERE relationship_id = p_from_id
5664: AND DIRECTIONAL_FLAG = 'F'
5657: last_updated_by = hz_utility_pub.user_id,
5658: last_update_login = hz_utility_pub.last_update_login,
5659: request_id = hz_utility_pub.request_id,
5660: program_application_id = hz_utility_pub.program_application_id,
5661: program_id = hz_utility_pub.program_id,
5662: program_update_date = sysdate
5663: WHERE relationship_id = p_from_id
5664: AND DIRECTIONAL_FLAG = 'F'
5665: RETURNING object_id, relationship_type, relationship_code ,
5669:
5670: UPDATE HZ_RELATIONSHIPS
5671: SET
5672: object_id = p_to_fk_id,
5673: last_update_date = hz_utility_pub.last_update_date,
5674: last_updated_by = hz_utility_pub.user_id,
5675: last_update_login = hz_utility_pub.last_update_login,
5676: request_id = hz_utility_pub.request_id,
5677: program_application_id = hz_utility_pub.program_application_id,
5670: UPDATE HZ_RELATIONSHIPS
5671: SET
5672: object_id = p_to_fk_id,
5673: last_update_date = hz_utility_pub.last_update_date,
5674: last_updated_by = hz_utility_pub.user_id,
5675: last_update_login = hz_utility_pub.last_update_login,
5676: request_id = hz_utility_pub.request_id,
5677: program_application_id = hz_utility_pub.program_application_id,
5678: program_id = hz_utility_pub.program_id,
5671: SET
5672: object_id = p_to_fk_id,
5673: last_update_date = hz_utility_pub.last_update_date,
5674: last_updated_by = hz_utility_pub.user_id,
5675: last_update_login = hz_utility_pub.last_update_login,
5676: request_id = hz_utility_pub.request_id,
5677: program_application_id = hz_utility_pub.program_application_id,
5678: program_id = hz_utility_pub.program_id,
5679: program_update_date = sysdate
5672: object_id = p_to_fk_id,
5673: last_update_date = hz_utility_pub.last_update_date,
5674: last_updated_by = hz_utility_pub.user_id,
5675: last_update_login = hz_utility_pub.last_update_login,
5676: request_id = hz_utility_pub.request_id,
5677: program_application_id = hz_utility_pub.program_application_id,
5678: program_id = hz_utility_pub.program_id,
5679: program_update_date = sysdate
5680: WHERE relationship_id = p_from_id
5673: last_update_date = hz_utility_pub.last_update_date,
5674: last_updated_by = hz_utility_pub.user_id,
5675: last_update_login = hz_utility_pub.last_update_login,
5676: request_id = hz_utility_pub.request_id,
5677: program_application_id = hz_utility_pub.program_application_id,
5678: program_id = hz_utility_pub.program_id,
5679: program_update_date = sysdate
5680: WHERE relationship_id = p_from_id
5681: AND DIRECTIONAL_FLAG = 'B';
5674: last_updated_by = hz_utility_pub.user_id,
5675: last_update_login = hz_utility_pub.last_update_login,
5676: request_id = hz_utility_pub.request_id,
5677: program_application_id = hz_utility_pub.program_application_id,
5678: program_id = hz_utility_pub.program_id,
5679: program_update_date = sysdate
5680: WHERE relationship_id = p_from_id
5681: AND DIRECTIONAL_FLAG = 'B';
5682:
5721: UPDATE HZ_RELATIONSHIPS
5722: SET
5723: STATUS = 'I',
5724: END_DATE = sysdate,
5725: last_update_date = hz_utility_pub.last_update_date,
5726: last_updated_by = hz_utility_pub.user_id,
5727: last_update_login = hz_utility_pub.last_update_login,
5728: request_id = hz_utility_pub.request_id,
5729: program_application_id = hz_utility_pub.program_application_id,
5722: SET
5723: STATUS = 'I',
5724: END_DATE = sysdate,
5725: last_update_date = hz_utility_pub.last_update_date,
5726: last_updated_by = hz_utility_pub.user_id,
5727: last_update_login = hz_utility_pub.last_update_login,
5728: request_id = hz_utility_pub.request_id,
5729: program_application_id = hz_utility_pub.program_application_id,
5730: program_id = hz_utility_pub.program_id,
5723: STATUS = 'I',
5724: END_DATE = sysdate,
5725: last_update_date = hz_utility_pub.last_update_date,
5726: last_updated_by = hz_utility_pub.user_id,
5727: last_update_login = hz_utility_pub.last_update_login,
5728: request_id = hz_utility_pub.request_id,
5729: program_application_id = hz_utility_pub.program_application_id,
5730: program_id = hz_utility_pub.program_id,
5731: program_update_date = sysdate
5724: END_DATE = sysdate,
5725: last_update_date = hz_utility_pub.last_update_date,
5726: last_updated_by = hz_utility_pub.user_id,
5727: last_update_login = hz_utility_pub.last_update_login,
5728: request_id = hz_utility_pub.request_id,
5729: program_application_id = hz_utility_pub.program_application_id,
5730: program_id = hz_utility_pub.program_id,
5731: program_update_date = sysdate
5732: WHERE relationship_id = p_from_id;
5725: last_update_date = hz_utility_pub.last_update_date,
5726: last_updated_by = hz_utility_pub.user_id,
5727: last_update_login = hz_utility_pub.last_update_login,
5728: request_id = hz_utility_pub.request_id,
5729: program_application_id = hz_utility_pub.program_application_id,
5730: program_id = hz_utility_pub.program_id,
5731: program_update_date = sysdate
5732: WHERE relationship_id = p_from_id;
5733:
5726: last_updated_by = hz_utility_pub.user_id,
5727: last_update_login = hz_utility_pub.last_update_login,
5728: request_id = hz_utility_pub.request_id,
5729: program_application_id = hz_utility_pub.program_application_id,
5730: program_id = hz_utility_pub.program_id,
5731: program_update_date = sysdate
5732: WHERE relationship_id = p_from_id;
5733:
5734: ---Start of Bug:3880218----
5734: ---Start of Bug:3880218----
5735: IF l_rel_party_id is not null THEN
5736: UPDATE HZ_PARTIES
5737: SET STATUS = 'I',
5738: last_update_date = hz_utility_pub.last_update_date,
5739: last_updated_by = hz_utility_pub.user_id,
5740: last_update_login = hz_utility_pub.last_update_login,
5741: request_id = hz_utility_pub.request_id,
5742: program_application_id = hz_utility_pub.program_application_id,
5735: IF l_rel_party_id is not null THEN
5736: UPDATE HZ_PARTIES
5737: SET STATUS = 'I',
5738: last_update_date = hz_utility_pub.last_update_date,
5739: last_updated_by = hz_utility_pub.user_id,
5740: last_update_login = hz_utility_pub.last_update_login,
5741: request_id = hz_utility_pub.request_id,
5742: program_application_id = hz_utility_pub.program_application_id,
5743: program_id = hz_utility_pub.program_id,
5736: UPDATE HZ_PARTIES
5737: SET STATUS = 'I',
5738: last_update_date = hz_utility_pub.last_update_date,
5739: last_updated_by = hz_utility_pub.user_id,
5740: last_update_login = hz_utility_pub.last_update_login,
5741: request_id = hz_utility_pub.request_id,
5742: program_application_id = hz_utility_pub.program_application_id,
5743: program_id = hz_utility_pub.program_id,
5744: program_update_date = sysdate
5737: SET STATUS = 'I',
5738: last_update_date = hz_utility_pub.last_update_date,
5739: last_updated_by = hz_utility_pub.user_id,
5740: last_update_login = hz_utility_pub.last_update_login,
5741: request_id = hz_utility_pub.request_id,
5742: program_application_id = hz_utility_pub.program_application_id,
5743: program_id = hz_utility_pub.program_id,
5744: program_update_date = sysdate
5745: WHERE PARTY_ID = l_rel_party_id;
5738: last_update_date = hz_utility_pub.last_update_date,
5739: last_updated_by = hz_utility_pub.user_id,
5740: last_update_login = hz_utility_pub.last_update_login,
5741: request_id = hz_utility_pub.request_id,
5742: program_application_id = hz_utility_pub.program_application_id,
5743: program_id = hz_utility_pub.program_id,
5744: program_update_date = sysdate
5745: WHERE PARTY_ID = l_rel_party_id;
5746: END IF;
5739: last_updated_by = hz_utility_pub.user_id,
5740: last_update_login = hz_utility_pub.last_update_login,
5741: request_id = hz_utility_pub.request_id,
5742: program_application_id = hz_utility_pub.program_application_id,
5743: program_id = hz_utility_pub.program_id,
5744: program_update_date = sysdate
5745: WHERE PARTY_ID = l_rel_party_id;
5746: END IF;
5747: ----End of Bug:3880218----
5757: ELSE
5758: IF l_rel_party_id is not null THEN
5759: UPDATE HZ_PARTIES
5760: SET STATUS = 'M',
5761: last_update_date = hz_utility_pub.last_update_date,
5762: last_updated_by = hz_utility_pub.user_id,
5763: last_update_login = hz_utility_pub.last_update_login,
5764: request_id = hz_utility_pub.request_id,
5765: program_application_id = hz_utility_pub.program_application_id,
5758: IF l_rel_party_id is not null THEN
5759: UPDATE HZ_PARTIES
5760: SET STATUS = 'M',
5761: last_update_date = hz_utility_pub.last_update_date,
5762: last_updated_by = hz_utility_pub.user_id,
5763: last_update_login = hz_utility_pub.last_update_login,
5764: request_id = hz_utility_pub.request_id,
5765: program_application_id = hz_utility_pub.program_application_id,
5766: program_id = hz_utility_pub.program_id,
5759: UPDATE HZ_PARTIES
5760: SET STATUS = 'M',
5761: last_update_date = hz_utility_pub.last_update_date,
5762: last_updated_by = hz_utility_pub.user_id,
5763: last_update_login = hz_utility_pub.last_update_login,
5764: request_id = hz_utility_pub.request_id,
5765: program_application_id = hz_utility_pub.program_application_id,
5766: program_id = hz_utility_pub.program_id,
5767: program_update_date = sysdate
5760: SET STATUS = 'M',
5761: last_update_date = hz_utility_pub.last_update_date,
5762: last_updated_by = hz_utility_pub.user_id,
5763: last_update_login = hz_utility_pub.last_update_login,
5764: request_id = hz_utility_pub.request_id,
5765: program_application_id = hz_utility_pub.program_application_id,
5766: program_id = hz_utility_pub.program_id,
5767: program_update_date = sysdate
5768: WHERE PARTY_ID IN (select party_id from hz_relationships where subject_id=p_to_fk_id
5761: last_update_date = hz_utility_pub.last_update_date,
5762: last_updated_by = hz_utility_pub.user_id,
5763: last_update_login = hz_utility_pub.last_update_login,
5764: request_id = hz_utility_pub.request_id,
5765: program_application_id = hz_utility_pub.program_application_id,
5766: program_id = hz_utility_pub.program_id,
5767: program_update_date = sysdate
5768: WHERE PARTY_ID IN (select party_id from hz_relationships where subject_id=p_to_fk_id
5769: and object_id=p_to_fk_id and relationship_id <>p_from_id and status='A'
5762: last_updated_by = hz_utility_pub.user_id,
5763: last_update_login = hz_utility_pub.last_update_login,
5764: request_id = hz_utility_pub.request_id,
5765: program_application_id = hz_utility_pub.program_application_id,
5766: program_id = hz_utility_pub.program_id,
5767: program_update_date = sysdate
5768: WHERE PARTY_ID IN (select party_id from hz_relationships where subject_id=p_to_fk_id
5769: and object_id=p_to_fk_id and relationship_id <>p_from_id and status='A'
5770: AND ((start_date between from_start_date and from_end_date)
5774: UPDATE HZ_RELATIONSHIPS
5775: SET
5776: STATUS = 'M',
5777: END_DATE = sysdate,
5778: last_update_date = hz_utility_pub.last_update_date,
5779: last_updated_by = hz_utility_pub.user_id,
5780: last_update_login = hz_utility_pub.last_update_login,
5781: request_id = hz_utility_pub.request_id,
5782: program_application_id = hz_utility_pub.program_application_id,
5775: SET
5776: STATUS = 'M',
5777: END_DATE = sysdate,
5778: last_update_date = hz_utility_pub.last_update_date,
5779: last_updated_by = hz_utility_pub.user_id,
5780: last_update_login = hz_utility_pub.last_update_login,
5781: request_id = hz_utility_pub.request_id,
5782: program_application_id = hz_utility_pub.program_application_id,
5783: program_id = hz_utility_pub.program_id,
5776: STATUS = 'M',
5777: END_DATE = sysdate,
5778: last_update_date = hz_utility_pub.last_update_date,
5779: last_updated_by = hz_utility_pub.user_id,
5780: last_update_login = hz_utility_pub.last_update_login,
5781: request_id = hz_utility_pub.request_id,
5782: program_application_id = hz_utility_pub.program_application_id,
5783: program_id = hz_utility_pub.program_id,
5784: program_update_date = sysdate
5777: END_DATE = sysdate,
5778: last_update_date = hz_utility_pub.last_update_date,
5779: last_updated_by = hz_utility_pub.user_id,
5780: last_update_login = hz_utility_pub.last_update_login,
5781: request_id = hz_utility_pub.request_id,
5782: program_application_id = hz_utility_pub.program_application_id,
5783: program_id = hz_utility_pub.program_id,
5784: program_update_date = sysdate
5785: WHERE relationship_id in (select relationship_id from hz_relationships where subject_id=p_to_fk_id
5778: last_update_date = hz_utility_pub.last_update_date,
5779: last_updated_by = hz_utility_pub.user_id,
5780: last_update_login = hz_utility_pub.last_update_login,
5781: request_id = hz_utility_pub.request_id,
5782: program_application_id = hz_utility_pub.program_application_id,
5783: program_id = hz_utility_pub.program_id,
5784: program_update_date = sysdate
5785: WHERE relationship_id in (select relationship_id from hz_relationships where subject_id=p_to_fk_id
5786: and object_id=p_to_fk_id and relationship_id <>p_from_id and status='A'
5779: last_updated_by = hz_utility_pub.user_id,
5780: last_update_login = hz_utility_pub.last_update_login,
5781: request_id = hz_utility_pub.request_id,
5782: program_application_id = hz_utility_pub.program_application_id,
5783: program_id = hz_utility_pub.program_id,
5784: program_update_date = sysdate
5785: WHERE relationship_id in (select relationship_id from hz_relationships where subject_id=p_to_fk_id
5786: and object_id=p_to_fk_id and relationship_id <>p_from_id and status='A'
5787: AND ((start_date between from_start_date and from_end_date)
5855:
5856: UPDATE HZ_RELATIONSHIPS
5857: SET
5858: STATUS = 'M',
5859: last_update_date = hz_utility_pub.last_update_date,
5860: last_updated_by = hz_utility_pub.user_id,
5861: last_update_login = hz_utility_pub.last_update_login,
5862: request_id = hz_utility_pub.request_id,
5863: program_application_id = hz_utility_pub.program_application_id,
5856: UPDATE HZ_RELATIONSHIPS
5857: SET
5858: STATUS = 'M',
5859: last_update_date = hz_utility_pub.last_update_date,
5860: last_updated_by = hz_utility_pub.user_id,
5861: last_update_login = hz_utility_pub.last_update_login,
5862: request_id = hz_utility_pub.request_id,
5863: program_application_id = hz_utility_pub.program_application_id,
5864: program_id = hz_utility_pub.program_id,
5857: SET
5858: STATUS = 'M',
5859: last_update_date = hz_utility_pub.last_update_date,
5860: last_updated_by = hz_utility_pub.user_id,
5861: last_update_login = hz_utility_pub.last_update_login,
5862: request_id = hz_utility_pub.request_id,
5863: program_application_id = hz_utility_pub.program_application_id,
5864: program_id = hz_utility_pub.program_id,
5865: program_update_date = sysdate
5858: STATUS = 'M',
5859: last_update_date = hz_utility_pub.last_update_date,
5860: last_updated_by = hz_utility_pub.user_id,
5861: last_update_login = hz_utility_pub.last_update_login,
5862: request_id = hz_utility_pub.request_id,
5863: program_application_id = hz_utility_pub.program_application_id,
5864: program_id = hz_utility_pub.program_id,
5865: program_update_date = sysdate
5866: WHERE relationship_id = p_from_id;
5859: last_update_date = hz_utility_pub.last_update_date,
5860: last_updated_by = hz_utility_pub.user_id,
5861: last_update_login = hz_utility_pub.last_update_login,
5862: request_id = hz_utility_pub.request_id,
5863: program_application_id = hz_utility_pub.program_application_id,
5864: program_id = hz_utility_pub.program_id,
5865: program_update_date = sysdate
5866: WHERE relationship_id = p_from_id;
5867: ----Start of DlProject Phase2--------------------
5860: last_updated_by = hz_utility_pub.user_id,
5861: last_update_login = hz_utility_pub.last_update_login,
5862: request_id = hz_utility_pub.request_id,
5863: program_application_id = hz_utility_pub.program_application_id,
5864: program_id = hz_utility_pub.program_id,
5865: program_update_date = sysdate
5866: WHERE relationship_id = p_from_id;
5867: ----Start of DlProject Phase2--------------------
5868: do_hierarchy_nodes_merge(p_from_id => p_from_id,
6006: UPDATE HZ_ORGANIZATION_PROFILES
6007: SET
6008: STATUS = 'M',
6009: effective_end_date = trunc(SYSDATE-1),
6010: last_update_date = hz_utility_pub.last_update_date,
6011: last_updated_by = hz_utility_pub.user_id,
6012: last_update_login = hz_utility_pub.last_update_login,
6013: request_id = hz_utility_pub.request_id,
6014: program_application_id = hz_utility_pub.program_application_id,
6007: SET
6008: STATUS = 'M',
6009: effective_end_date = trunc(SYSDATE-1),
6010: last_update_date = hz_utility_pub.last_update_date,
6011: last_updated_by = hz_utility_pub.user_id,
6012: last_update_login = hz_utility_pub.last_update_login,
6013: request_id = hz_utility_pub.request_id,
6014: program_application_id = hz_utility_pub.program_application_id,
6015: program_id = hz_utility_pub.program_id,
6008: STATUS = 'M',
6009: effective_end_date = trunc(SYSDATE-1),
6010: last_update_date = hz_utility_pub.last_update_date,
6011: last_updated_by = hz_utility_pub.user_id,
6012: last_update_login = hz_utility_pub.last_update_login,
6013: request_id = hz_utility_pub.request_id,
6014: program_application_id = hz_utility_pub.program_application_id,
6015: program_id = hz_utility_pub.program_id,
6016: program_update_date = sysdate
6009: effective_end_date = trunc(SYSDATE-1),
6010: last_update_date = hz_utility_pub.last_update_date,
6011: last_updated_by = hz_utility_pub.user_id,
6012: last_update_login = hz_utility_pub.last_update_login,
6013: request_id = hz_utility_pub.request_id,
6014: program_application_id = hz_utility_pub.program_application_id,
6015: program_id = hz_utility_pub.program_id,
6016: program_update_date = sysdate
6017: WHERE organization_profile_id = p_from_id;
6010: last_update_date = hz_utility_pub.last_update_date,
6011: last_updated_by = hz_utility_pub.user_id,
6012: last_update_login = hz_utility_pub.last_update_login,
6013: request_id = hz_utility_pub.request_id,
6014: program_application_id = hz_utility_pub.program_application_id,
6015: program_id = hz_utility_pub.program_id,
6016: program_update_date = sysdate
6017: WHERE organization_profile_id = p_from_id;
6018:
6011: last_updated_by = hz_utility_pub.user_id,
6012: last_update_login = hz_utility_pub.last_update_login,
6013: request_id = hz_utility_pub.request_id,
6014: program_application_id = hz_utility_pub.program_application_id,
6015: program_id = hz_utility_pub.program_id,
6016: program_update_date = sysdate
6017: WHERE organization_profile_id = p_from_id;
6018:
6019: EXCEPTION
6065: ELSE
6066: UPDATE HZ_PERSON_PROFILES
6067: SET
6068: party_id = p_to_fk_id,
6069: last_update_date = hz_utility_pub.last_update_date,
6070: last_updated_by = hz_utility_pub.user_id,
6071: last_update_login = hz_utility_pub.last_update_login,
6072: request_id = hz_utility_pub.request_id,
6073: program_application_id = hz_utility_pub.program_application_id,
6066: UPDATE HZ_PERSON_PROFILES
6067: SET
6068: party_id = p_to_fk_id,
6069: last_update_date = hz_utility_pub.last_update_date,
6070: last_updated_by = hz_utility_pub.user_id,
6071: last_update_login = hz_utility_pub.last_update_login,
6072: request_id = hz_utility_pub.request_id,
6073: program_application_id = hz_utility_pub.program_application_id,
6074: program_id = hz_utility_pub.program_id,
6067: SET
6068: party_id = p_to_fk_id,
6069: last_update_date = hz_utility_pub.last_update_date,
6070: last_updated_by = hz_utility_pub.user_id,
6071: last_update_login = hz_utility_pub.last_update_login,
6072: request_id = hz_utility_pub.request_id,
6073: program_application_id = hz_utility_pub.program_application_id,
6074: program_id = hz_utility_pub.program_id,
6075: program_update_date = sysdate
6068: party_id = p_to_fk_id,
6069: last_update_date = hz_utility_pub.last_update_date,
6070: last_updated_by = hz_utility_pub.user_id,
6071: last_update_login = hz_utility_pub.last_update_login,
6072: request_id = hz_utility_pub.request_id,
6073: program_application_id = hz_utility_pub.program_application_id,
6074: program_id = hz_utility_pub.program_id,
6075: program_update_date = sysdate
6076: WHERE person_profile_id = p_from_id;
6069: last_update_date = hz_utility_pub.last_update_date,
6070: last_updated_by = hz_utility_pub.user_id,
6071: last_update_login = hz_utility_pub.last_update_login,
6072: request_id = hz_utility_pub.request_id,
6073: program_application_id = hz_utility_pub.program_application_id,
6074: program_id = hz_utility_pub.program_id,
6075: program_update_date = sysdate
6076: WHERE person_profile_id = p_from_id;
6077: END IF;
6070: last_updated_by = hz_utility_pub.user_id,
6071: last_update_login = hz_utility_pub.last_update_login,
6072: request_id = hz_utility_pub.request_id,
6073: program_application_id = hz_utility_pub.program_application_id,
6074: program_id = hz_utility_pub.program_id,
6075: program_update_date = sysdate
6076: WHERE person_profile_id = p_from_id;
6077: END IF;
6078: ELSE
6081: UPDATE HZ_PERSON_PROFILES
6082: SET
6083: STATUS = 'M',
6084: effective_end_date = trunc(SYSDATE-1),
6085: last_update_date = hz_utility_pub.last_update_date,
6086: last_updated_by = hz_utility_pub.user_id,
6087: last_update_login = hz_utility_pub.last_update_login,
6088: request_id = hz_utility_pub.request_id,
6089: program_application_id = hz_utility_pub.program_application_id,
6082: SET
6083: STATUS = 'M',
6084: effective_end_date = trunc(SYSDATE-1),
6085: last_update_date = hz_utility_pub.last_update_date,
6086: last_updated_by = hz_utility_pub.user_id,
6087: last_update_login = hz_utility_pub.last_update_login,
6088: request_id = hz_utility_pub.request_id,
6089: program_application_id = hz_utility_pub.program_application_id,
6090: program_id = hz_utility_pub.program_id,
6083: STATUS = 'M',
6084: effective_end_date = trunc(SYSDATE-1),
6085: last_update_date = hz_utility_pub.last_update_date,
6086: last_updated_by = hz_utility_pub.user_id,
6087: last_update_login = hz_utility_pub.last_update_login,
6088: request_id = hz_utility_pub.request_id,
6089: program_application_id = hz_utility_pub.program_application_id,
6090: program_id = hz_utility_pub.program_id,
6091: program_update_date = sysdate
6084: effective_end_date = trunc(SYSDATE-1),
6085: last_update_date = hz_utility_pub.last_update_date,
6086: last_updated_by = hz_utility_pub.user_id,
6087: last_update_login = hz_utility_pub.last_update_login,
6088: request_id = hz_utility_pub.request_id,
6089: program_application_id = hz_utility_pub.program_application_id,
6090: program_id = hz_utility_pub.program_id,
6091: program_update_date = sysdate
6092: WHERE person_profile_id = p_from_id;
6085: last_update_date = hz_utility_pub.last_update_date,
6086: last_updated_by = hz_utility_pub.user_id,
6087: last_update_login = hz_utility_pub.last_update_login,
6088: request_id = hz_utility_pub.request_id,
6089: program_application_id = hz_utility_pub.program_application_id,
6090: program_id = hz_utility_pub.program_id,
6091: program_update_date = sysdate
6092: WHERE person_profile_id = p_from_id;
6093:
6086: last_updated_by = hz_utility_pub.user_id,
6087: last_update_login = hz_utility_pub.last_update_login,
6088: request_id = hz_utility_pub.request_id,
6089: program_application_id = hz_utility_pub.program_application_id,
6090: program_id = hz_utility_pub.program_id,
6091: program_update_date = sysdate
6092: WHERE person_profile_id = p_from_id;
6093:
6094: --For NOCOPY fix
6383:
6384: UPDATE HZ_PARTY_SITES
6385: SET
6386: STATUS = 'M',
6387: last_update_date = hz_utility_pub.last_update_date,
6388: last_updated_by = hz_utility_pub.user_id,
6389: last_update_login = hz_utility_pub.last_update_login,
6390: request_id = hz_utility_pub.request_id,
6391: program_application_id = hz_utility_pub.program_application_id,
6384: UPDATE HZ_PARTY_SITES
6385: SET
6386: STATUS = 'M',
6387: last_update_date = hz_utility_pub.last_update_date,
6388: last_updated_by = hz_utility_pub.user_id,
6389: last_update_login = hz_utility_pub.last_update_login,
6390: request_id = hz_utility_pub.request_id,
6391: program_application_id = hz_utility_pub.program_application_id,
6392: program_id = hz_utility_pub.program_id,
6385: SET
6386: STATUS = 'M',
6387: last_update_date = hz_utility_pub.last_update_date,
6388: last_updated_by = hz_utility_pub.user_id,
6389: last_update_login = hz_utility_pub.last_update_login,
6390: request_id = hz_utility_pub.request_id,
6391: program_application_id = hz_utility_pub.program_application_id,
6392: program_id = hz_utility_pub.program_id,
6393: program_update_date = sysdate
6386: STATUS = 'M',
6387: last_update_date = hz_utility_pub.last_update_date,
6388: last_updated_by = hz_utility_pub.user_id,
6389: last_update_login = hz_utility_pub.last_update_login,
6390: request_id = hz_utility_pub.request_id,
6391: program_application_id = hz_utility_pub.program_application_id,
6392: program_id = hz_utility_pub.program_id,
6393: program_update_date = sysdate
6394: WHERE party_site_id = p_from_id;
6387: last_update_date = hz_utility_pub.last_update_date,
6388: last_updated_by = hz_utility_pub.user_id,
6389: last_update_login = hz_utility_pub.last_update_login,
6390: request_id = hz_utility_pub.request_id,
6391: program_application_id = hz_utility_pub.program_application_id,
6392: program_id = hz_utility_pub.program_id,
6393: program_update_date = sysdate
6394: WHERE party_site_id = p_from_id;
6395: /* Bug 3892399
6388: last_updated_by = hz_utility_pub.user_id,
6389: last_update_login = hz_utility_pub.last_update_login,
6390: request_id = hz_utility_pub.request_id,
6391: program_application_id = hz_utility_pub.program_application_id,
6392: program_id = hz_utility_pub.program_id,
6393: program_update_date = sysdate
6394: WHERE party_site_id = p_from_id;
6395: /* Bug 3892399
6396: UPDATE HZ_ORIG_SYS_REFERENCES
6395: /* Bug 3892399
6396: UPDATE HZ_ORIG_SYS_REFERENCES
6397: SET
6398: STATUS = 'I',
6399: last_update_date = hz_utility_pub.last_update_date,
6400: last_updated_by = hz_utility_pub.user_id,
6401: last_update_login = hz_utility_pub.last_update_login
6402: WHERE owner_table_id = p_from_id and owner_table_name='HZ_PARTY_SITES';
6403: */
6396: UPDATE HZ_ORIG_SYS_REFERENCES
6397: SET
6398: STATUS = 'I',
6399: last_update_date = hz_utility_pub.last_update_date,
6400: last_updated_by = hz_utility_pub.user_id,
6401: last_update_login = hz_utility_pub.last_update_login
6402: WHERE owner_table_id = p_from_id and owner_table_name='HZ_PARTY_SITES';
6403: */
6404: HZ_ORIG_SYSTEM_REF_PVT.remap_internal_identifier(
6397: SET
6398: STATUS = 'I',
6399: last_update_date = hz_utility_pub.last_update_date,
6400: last_updated_by = hz_utility_pub.user_id,
6401: last_update_login = hz_utility_pub.last_update_login
6402: WHERE owner_table_id = p_from_id and owner_table_name='HZ_PARTY_SITES';
6403: */
6404: HZ_ORIG_SYSTEM_REF_PVT.remap_internal_identifier(
6405: p_init_msg_list => FND_API.G_FALSE,
6462: UPDATE HZ_PARTY_SITES
6463: SET
6464: STATUS = 'M',
6465: party_site_number = l_party_site_number,
6466: last_update_date = hz_utility_pub.last_update_date,
6467: last_updated_by = hz_utility_pub.user_id,
6468: last_update_login = hz_utility_pub.last_update_login,
6469: request_id = hz_utility_pub.request_id,
6470: program_application_id = hz_utility_pub.program_application_id,
6463: SET
6464: STATUS = 'M',
6465: party_site_number = l_party_site_number,
6466: last_update_date = hz_utility_pub.last_update_date,
6467: last_updated_by = hz_utility_pub.user_id,
6468: last_update_login = hz_utility_pub.last_update_login,
6469: request_id = hz_utility_pub.request_id,
6470: program_application_id = hz_utility_pub.program_application_id,
6471: program_id = hz_utility_pub.program_id,
6464: STATUS = 'M',
6465: party_site_number = l_party_site_number,
6466: last_update_date = hz_utility_pub.last_update_date,
6467: last_updated_by = hz_utility_pub.user_id,
6468: last_update_login = hz_utility_pub.last_update_login,
6469: request_id = hz_utility_pub.request_id,
6470: program_application_id = hz_utility_pub.program_application_id,
6471: program_id = hz_utility_pub.program_id,
6472: program_update_date = sysdate
6465: party_site_number = l_party_site_number,
6466: last_update_date = hz_utility_pub.last_update_date,
6467: last_updated_by = hz_utility_pub.user_id,
6468: last_update_login = hz_utility_pub.last_update_login,
6469: request_id = hz_utility_pub.request_id,
6470: program_application_id = hz_utility_pub.program_application_id,
6471: program_id = hz_utility_pub.program_id,
6472: program_update_date = sysdate
6473: WHERE party_site_id = p_from_id;
6466: last_update_date = hz_utility_pub.last_update_date,
6467: last_updated_by = hz_utility_pub.user_id,
6468: last_update_login = hz_utility_pub.last_update_login,
6469: request_id = hz_utility_pub.request_id,
6470: program_application_id = hz_utility_pub.program_application_id,
6471: program_id = hz_utility_pub.program_id,
6472: program_update_date = sysdate
6473: WHERE party_site_id = p_from_id;
6474: EXCEPTION
6467: last_updated_by = hz_utility_pub.user_id,
6468: last_update_login = hz_utility_pub.last_update_login,
6469: request_id = hz_utility_pub.request_id,
6470: program_application_id = hz_utility_pub.program_application_id,
6471: program_id = hz_utility_pub.program_id,
6472: program_update_date = sysdate
6473: WHERE party_site_id = p_from_id;
6474: EXCEPTION
6475: WHEN DUP_VAL_ON_INDEX THEN
6677: -- Update and set status to merged
6678: UPDATE HZ_PARTIES
6679: SET
6680: STATUS = 'M',
6681: last_update_date = hz_utility_pub.last_update_date,
6682: last_updated_by = hz_utility_pub.user_id,
6683: last_update_login = hz_utility_pub.last_update_login,
6684: request_id = hz_utility_pub.request_id,
6685: program_application_id = hz_utility_pub.program_application_id,
6678: UPDATE HZ_PARTIES
6679: SET
6680: STATUS = 'M',
6681: last_update_date = hz_utility_pub.last_update_date,
6682: last_updated_by = hz_utility_pub.user_id,
6683: last_update_login = hz_utility_pub.last_update_login,
6684: request_id = hz_utility_pub.request_id,
6685: program_application_id = hz_utility_pub.program_application_id,
6686: program_id = hz_utility_pub.program_id,
6679: SET
6680: STATUS = 'M',
6681: last_update_date = hz_utility_pub.last_update_date,
6682: last_updated_by = hz_utility_pub.user_id,
6683: last_update_login = hz_utility_pub.last_update_login,
6684: request_id = hz_utility_pub.request_id,
6685: program_application_id = hz_utility_pub.program_application_id,
6686: program_id = hz_utility_pub.program_id,
6687: program_update_date = sysdate
6680: STATUS = 'M',
6681: last_update_date = hz_utility_pub.last_update_date,
6682: last_updated_by = hz_utility_pub.user_id,
6683: last_update_login = hz_utility_pub.last_update_login,
6684: request_id = hz_utility_pub.request_id,
6685: program_application_id = hz_utility_pub.program_application_id,
6686: program_id = hz_utility_pub.program_id,
6687: program_update_date = sysdate
6688: WHERE party_id = p_from_id;
6681: last_update_date = hz_utility_pub.last_update_date,
6682: last_updated_by = hz_utility_pub.user_id,
6683: last_update_login = hz_utility_pub.last_update_login,
6684: request_id = hz_utility_pub.request_id,
6685: program_application_id = hz_utility_pub.program_application_id,
6686: program_id = hz_utility_pub.program_id,
6687: program_update_date = sysdate
6688: WHERE party_id = p_from_id;
6689:
6682: last_updated_by = hz_utility_pub.user_id,
6683: last_update_login = hz_utility_pub.last_update_login,
6684: request_id = hz_utility_pub.request_id,
6685: program_application_id = hz_utility_pub.program_application_id,
6686: program_id = hz_utility_pub.program_id,
6687: program_update_date = sysdate
6688: WHERE party_id = p_from_id;
6689:
6690: UPDATE HZ_DQM_SYNC_INTERFACE
6732:
6733: UPDATE HZ_ORGANIZATION_PROFILES
6734: SET
6735: displayed_duns_party_id = p_to_fk_id,
6736: last_update_date = hz_utility_pub.last_update_date,
6737: last_updated_by = hz_utility_pub.user_id,
6738: last_update_login = hz_utility_pub.last_update_login,
6739: request_id = hz_utility_pub.request_id,
6740: program_application_id = hz_utility_pub.program_application_id,
6733: UPDATE HZ_ORGANIZATION_PROFILES
6734: SET
6735: displayed_duns_party_id = p_to_fk_id,
6736: last_update_date = hz_utility_pub.last_update_date,
6737: last_updated_by = hz_utility_pub.user_id,
6738: last_update_login = hz_utility_pub.last_update_login,
6739: request_id = hz_utility_pub.request_id,
6740: program_application_id = hz_utility_pub.program_application_id,
6741: program_id = hz_utility_pub.program_id,
6734: SET
6735: displayed_duns_party_id = p_to_fk_id,
6736: last_update_date = hz_utility_pub.last_update_date,
6737: last_updated_by = hz_utility_pub.user_id,
6738: last_update_login = hz_utility_pub.last_update_login,
6739: request_id = hz_utility_pub.request_id,
6740: program_application_id = hz_utility_pub.program_application_id,
6741: program_id = hz_utility_pub.program_id,
6742: program_update_date = sysdate
6735: displayed_duns_party_id = p_to_fk_id,
6736: last_update_date = hz_utility_pub.last_update_date,
6737: last_updated_by = hz_utility_pub.user_id,
6738: last_update_login = hz_utility_pub.last_update_login,
6739: request_id = hz_utility_pub.request_id,
6740: program_application_id = hz_utility_pub.program_application_id,
6741: program_id = hz_utility_pub.program_id,
6742: program_update_date = sysdate
6743: WHERE organization_profile_id = p_from_id;
6736: last_update_date = hz_utility_pub.last_update_date,
6737: last_updated_by = hz_utility_pub.user_id,
6738: last_update_login = hz_utility_pub.last_update_login,
6739: request_id = hz_utility_pub.request_id,
6740: program_application_id = hz_utility_pub.program_application_id,
6741: program_id = hz_utility_pub.program_id,
6742: program_update_date = sysdate
6743: WHERE organization_profile_id = p_from_id;
6744:
6737: last_updated_by = hz_utility_pub.user_id,
6738: last_update_login = hz_utility_pub.last_update_login,
6739: request_id = hz_utility_pub.request_id,
6740: program_application_id = hz_utility_pub.program_application_id,
6741: program_id = hz_utility_pub.program_id,
6742: program_update_date = sysdate
6743: WHERE organization_profile_id = p_from_id;
6744:
6745:
6790: p_destination_party_id,
6791: l_requested_product,
6792: l_duns_number,
6793: 'S',
6794: hz_utility_pub.CREATED_BY,
6795: hz_utility_pub.CREATION_DATE,
6796: hz_utility_pub.LAST_UPDATED_BY,
6797: hz_utility_pub.LAST_UPDATE_DATE,
6798: hz_utility_pub.LAST_UPDATE_LOGIN,
6791: l_requested_product,
6792: l_duns_number,
6793: 'S',
6794: hz_utility_pub.CREATED_BY,
6795: hz_utility_pub.CREATION_DATE,
6796: hz_utility_pub.LAST_UPDATED_BY,
6797: hz_utility_pub.LAST_UPDATE_DATE,
6798: hz_utility_pub.LAST_UPDATE_LOGIN,
6799: p_source_party_id );
6792: l_duns_number,
6793: 'S',
6794: hz_utility_pub.CREATED_BY,
6795: hz_utility_pub.CREATION_DATE,
6796: hz_utility_pub.LAST_UPDATED_BY,
6797: hz_utility_pub.LAST_UPDATE_DATE,
6798: hz_utility_pub.LAST_UPDATE_LOGIN,
6799: p_source_party_id );
6800: EXCEPTION
6793: 'S',
6794: hz_utility_pub.CREATED_BY,
6795: hz_utility_pub.CREATION_DATE,
6796: hz_utility_pub.LAST_UPDATED_BY,
6797: hz_utility_pub.LAST_UPDATE_DATE,
6798: hz_utility_pub.LAST_UPDATE_LOGIN,
6799: p_source_party_id );
6800: EXCEPTION
6801: WHEN NO_DATA_FOUND THEN
6794: hz_utility_pub.CREATED_BY,
6795: hz_utility_pub.CREATION_DATE,
6796: hz_utility_pub.LAST_UPDATED_BY,
6797: hz_utility_pub.LAST_UPDATE_DATE,
6798: hz_utility_pub.LAST_UPDATE_LOGIN,
6799: p_source_party_id );
6800: EXCEPTION
6801: WHEN NO_DATA_FOUND THEN
6802: null;