DBA Data[Home] [Help]

APPS.OZF_VENDORMERGE_GRP dependencies on HZ_UTILITY_PUB

Line 53: last_update_date = hz_utility_pub.last_update_date,

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,

Line 54: last_updated_by = hz_utility_pub.user_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

Line 55: last_update_login = hz_utility_pub.last_update_login,

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

Line 56: program_application_id = hz_utility_pub.program_application_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;

Line 57: program_id = hz_utility_pub.program_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:

Line 86: last_update_date = hz_utility_pub.last_update_date,

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,

Line 87: last_updated_by = hz_utility_pub.user_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

Line 88: last_update_login = hz_utility_pub.last_update_login,

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

Line 89: program_application_id = hz_utility_pub.program_application_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;

Line 90: program_id = hz_utility_pub.program_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:

Line 118: last_update_date = hz_utility_pub.last_update_date,

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,

Line 119: last_updated_by = hz_utility_pub.user_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

Line 120: last_update_login = hz_utility_pub.last_update_login,

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

Line 121: program_application_id = hz_utility_pub.program_application_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;

Line 122: program_id = hz_utility_pub.program_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:

Line 150: last_update_date = hz_utility_pub.last_update_date,

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,

Line 151: last_updated_by = hz_utility_pub.user_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

Line 152: last_update_login = hz_utility_pub.last_update_login,

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

Line 153: program_application_id = hz_utility_pub.program_application_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;

Line 154: program_id = hz_utility_pub.program_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: