49:
50: UPDATE OZF_CLAIMS_ALL
51: SET vendor_id = p_vendor_id,
52: vendor_site_id = p_vendor_site_id,
53: last_update_date = hz_utility_pub.last_update_date,
54: last_updated_by = hz_utility_pub.user_id,
55: last_update_login = hz_utility_pub.last_update_login,
56: program_application_id = hz_utility_pub.program_application_id,
57: program_id = hz_utility_pub.program_id,
50: UPDATE OZF_CLAIMS_ALL
51: SET vendor_id = p_vendor_id,
52: vendor_site_id = p_vendor_site_id,
53: last_update_date = hz_utility_pub.last_update_date,
54: last_updated_by = hz_utility_pub.user_id,
55: last_update_login = hz_utility_pub.last_update_login,
56: program_application_id = hz_utility_pub.program_application_id,
57: program_id = hz_utility_pub.program_id,
58: program_update_date = sysdate
51: SET vendor_id = p_vendor_id,
52: vendor_site_id = p_vendor_site_id,
53: last_update_date = hz_utility_pub.last_update_date,
54: last_updated_by = hz_utility_pub.user_id,
55: last_update_login = hz_utility_pub.last_update_login,
56: program_application_id = hz_utility_pub.program_application_id,
57: program_id = hz_utility_pub.program_id,
58: program_update_date = sysdate
59: WHERE vendor_id = p_dup_vendor_id
52: vendor_site_id = p_vendor_site_id,
53: last_update_date = hz_utility_pub.last_update_date,
54: last_updated_by = hz_utility_pub.user_id,
55: last_update_login = hz_utility_pub.last_update_login,
56: program_application_id = hz_utility_pub.program_application_id,
57: program_id = hz_utility_pub.program_id,
58: program_update_date = sysdate
59: WHERE vendor_id = p_dup_vendor_id
60: AND vendor_site_id = p_dup_vendor_site_id;
53: last_update_date = hz_utility_pub.last_update_date,
54: last_updated_by = hz_utility_pub.user_id,
55: last_update_login = hz_utility_pub.last_update_login,
56: program_application_id = hz_utility_pub.program_application_id,
57: program_id = hz_utility_pub.program_id,
58: program_update_date = sysdate
59: WHERE vendor_id = p_dup_vendor_id
60: AND vendor_site_id = p_dup_vendor_site_id;
61:
82: IF p_dup_vendor_id <> p_vendor_id THEN
83: UPDATE OZF_CLAIMS_HISTORY_ALL
84: SET vendor_id = p_vendor_id,
85: vendor_site_id = p_vendor_site_id,
86: last_update_date = hz_utility_pub.last_update_date,
87: last_updated_by = hz_utility_pub.user_id,
88: last_update_login = hz_utility_pub.last_update_login,
89: program_application_id = hz_utility_pub.program_application_id,
90: program_id = hz_utility_pub.program_id,
83: UPDATE OZF_CLAIMS_HISTORY_ALL
84: SET vendor_id = p_vendor_id,
85: vendor_site_id = p_vendor_site_id,
86: last_update_date = hz_utility_pub.last_update_date,
87: last_updated_by = hz_utility_pub.user_id,
88: last_update_login = hz_utility_pub.last_update_login,
89: program_application_id = hz_utility_pub.program_application_id,
90: program_id = hz_utility_pub.program_id,
91: program_update_date = sysdate
84: SET vendor_id = p_vendor_id,
85: vendor_site_id = p_vendor_site_id,
86: last_update_date = hz_utility_pub.last_update_date,
87: last_updated_by = hz_utility_pub.user_id,
88: last_update_login = hz_utility_pub.last_update_login,
89: program_application_id = hz_utility_pub.program_application_id,
90: program_id = hz_utility_pub.program_id,
91: program_update_date = sysdate
92: WHERE vendor_id = p_dup_vendor_id
85: vendor_site_id = p_vendor_site_id,
86: last_update_date = hz_utility_pub.last_update_date,
87: last_updated_by = hz_utility_pub.user_id,
88: last_update_login = hz_utility_pub.last_update_login,
89: program_application_id = hz_utility_pub.program_application_id,
90: program_id = hz_utility_pub.program_id,
91: program_update_date = sysdate
92: WHERE vendor_id = p_dup_vendor_id
93: AND vendor_site_id = p_dup_vendor_site_id;
86: last_update_date = hz_utility_pub.last_update_date,
87: last_updated_by = hz_utility_pub.user_id,
88: last_update_login = hz_utility_pub.last_update_login,
89: program_application_id = hz_utility_pub.program_application_id,
90: program_id = hz_utility_pub.program_id,
91: program_update_date = sysdate
92: WHERE vendor_id = p_dup_vendor_id
93: AND vendor_site_id = p_dup_vendor_site_id;
94:
114:
115: UPDATE OZF_CLAIMS_INT_ALL
116: SET vendor_id = p_vendor_id,
117: vendor_site_id = p_vendor_site_id,
118: last_update_date = hz_utility_pub.last_update_date,
119: last_updated_by = hz_utility_pub.user_id,
120: last_update_login = hz_utility_pub.last_update_login,
121: program_application_id = hz_utility_pub.program_application_id,
122: program_id = hz_utility_pub.program_id,
115: UPDATE OZF_CLAIMS_INT_ALL
116: SET vendor_id = p_vendor_id,
117: vendor_site_id = p_vendor_site_id,
118: last_update_date = hz_utility_pub.last_update_date,
119: last_updated_by = hz_utility_pub.user_id,
120: last_update_login = hz_utility_pub.last_update_login,
121: program_application_id = hz_utility_pub.program_application_id,
122: program_id = hz_utility_pub.program_id,
123: program_update_date = sysdate
116: SET vendor_id = p_vendor_id,
117: vendor_site_id = p_vendor_site_id,
118: last_update_date = hz_utility_pub.last_update_date,
119: last_updated_by = hz_utility_pub.user_id,
120: last_update_login = hz_utility_pub.last_update_login,
121: program_application_id = hz_utility_pub.program_application_id,
122: program_id = hz_utility_pub.program_id,
123: program_update_date = sysdate
124: WHERE vendor_id = p_dup_vendor_id
117: vendor_site_id = p_vendor_site_id,
118: last_update_date = hz_utility_pub.last_update_date,
119: last_updated_by = hz_utility_pub.user_id,
120: last_update_login = hz_utility_pub.last_update_login,
121: program_application_id = hz_utility_pub.program_application_id,
122: program_id = hz_utility_pub.program_id,
123: program_update_date = sysdate
124: WHERE vendor_id = p_dup_vendor_id
125: AND vendor_site_id = p_dup_vendor_site_id;
118: last_update_date = hz_utility_pub.last_update_date,
119: last_updated_by = hz_utility_pub.user_id,
120: last_update_login = hz_utility_pub.last_update_login,
121: program_application_id = hz_utility_pub.program_application_id,
122: program_id = hz_utility_pub.program_id,
123: program_update_date = sysdate
124: WHERE vendor_id = p_dup_vendor_id
125: AND vendor_site_id = p_dup_vendor_site_id;
126:
146:
147: UPDATE OZF_CUST_TRD_PRFLS_ALL
148: SET vendor_id = p_vendor_id,
149: vendor_site_id = p_vendor_site_id,
150: last_update_date = hz_utility_pub.last_update_date,
151: last_updated_by = hz_utility_pub.user_id,
152: last_update_login = hz_utility_pub.last_update_login,
153: program_application_id = hz_utility_pub.program_application_id,
154: program_id = hz_utility_pub.program_id,
147: UPDATE OZF_CUST_TRD_PRFLS_ALL
148: SET vendor_id = p_vendor_id,
149: vendor_site_id = p_vendor_site_id,
150: last_update_date = hz_utility_pub.last_update_date,
151: last_updated_by = hz_utility_pub.user_id,
152: last_update_login = hz_utility_pub.last_update_login,
153: program_application_id = hz_utility_pub.program_application_id,
154: program_id = hz_utility_pub.program_id,
155: program_update_date = sysdate
148: SET vendor_id = p_vendor_id,
149: vendor_site_id = p_vendor_site_id,
150: last_update_date = hz_utility_pub.last_update_date,
151: last_updated_by = hz_utility_pub.user_id,
152: last_update_login = hz_utility_pub.last_update_login,
153: program_application_id = hz_utility_pub.program_application_id,
154: program_id = hz_utility_pub.program_id,
155: program_update_date = sysdate
156: WHERE vendor_id = p_dup_vendor_id
149: vendor_site_id = p_vendor_site_id,
150: last_update_date = hz_utility_pub.last_update_date,
151: last_updated_by = hz_utility_pub.user_id,
152: last_update_login = hz_utility_pub.last_update_login,
153: program_application_id = hz_utility_pub.program_application_id,
154: program_id = hz_utility_pub.program_id,
155: program_update_date = sysdate
156: WHERE vendor_id = p_dup_vendor_id
157: AND vendor_site_id = p_dup_vendor_site_id;
150: last_update_date = hz_utility_pub.last_update_date,
151: last_updated_by = hz_utility_pub.user_id,
152: last_update_login = hz_utility_pub.last_update_login,
153: program_application_id = hz_utility_pub.program_application_id,
154: program_id = hz_utility_pub.program_id,
155: program_update_date = sysdate
156: WHERE vendor_id = p_dup_vendor_id
157: AND vendor_site_id = p_dup_vendor_site_id;
158: