eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_OPP_MERGE_PKG dependencies on HZ_UTILITY_PUB

Line 56: last_update_date = hz_utility_pub.last_update_date,

52: l_col_name := 'AS_LEADS_ALL.customer_id';
53:
54: UPDATE AS_LEADS_ALL
55: set object_version_number = nvl(object_version_number,0) + 1, customer_id = p_to_fk_id,
56: last_update_date = hz_utility_pub.last_update_date,
57: last_updated_by = hz_utility_pub.user_id,
58: last_update_login = hz_utility_pub.last_update_login,
59: request_id = hz_utility_pub.request_id,
60: program_application_id = hz_utility_pub.program_application_id,

Line 57: last_updated_by = hz_utility_pub.user_id,

53:
54: UPDATE AS_LEADS_ALL
55: set object_version_number = nvl(object_version_number,0) + 1, customer_id = p_to_fk_id,
56: last_update_date = hz_utility_pub.last_update_date,
57: last_updated_by = hz_utility_pub.user_id,
58: last_update_login = hz_utility_pub.last_update_login,
59: request_id = hz_utility_pub.request_id,
60: program_application_id = hz_utility_pub.program_application_id,
61: program_id = hz_utility_pub.program_id,

Line 58: last_update_login = hz_utility_pub.last_update_login,

54: UPDATE AS_LEADS_ALL
55: set object_version_number = nvl(object_version_number,0) + 1, customer_id = p_to_fk_id,
56: last_update_date = hz_utility_pub.last_update_date,
57: last_updated_by = hz_utility_pub.user_id,
58: last_update_login = hz_utility_pub.last_update_login,
59: request_id = hz_utility_pub.request_id,
60: program_application_id = hz_utility_pub.program_application_id,
61: program_id = hz_utility_pub.program_id,
62: program_update_date = sysdate

Line 59: request_id = hz_utility_pub.request_id,

55: set object_version_number = nvl(object_version_number,0) + 1, customer_id = p_to_fk_id,
56: last_update_date = hz_utility_pub.last_update_date,
57: last_updated_by = hz_utility_pub.user_id,
58: last_update_login = hz_utility_pub.last_update_login,
59: request_id = hz_utility_pub.request_id,
60: program_application_id = hz_utility_pub.program_application_id,
61: program_id = hz_utility_pub.program_id,
62: program_update_date = sysdate
63: where customer_id = p_from_fk_id;

Line 60: program_application_id = hz_utility_pub.program_application_id,

56: last_update_date = hz_utility_pub.last_update_date,
57: last_updated_by = hz_utility_pub.user_id,
58: last_update_login = hz_utility_pub.last_update_login,
59: request_id = hz_utility_pub.request_id,
60: program_application_id = hz_utility_pub.program_application_id,
61: program_id = hz_utility_pub.program_id,
62: program_update_date = sysdate
63: where customer_id = p_from_fk_id;
64:

Line 61: program_id = hz_utility_pub.program_id,

57: last_updated_by = hz_utility_pub.user_id,
58: last_update_login = hz_utility_pub.last_update_login,
59: request_id = hz_utility_pub.request_id,
60: program_application_id = hz_utility_pub.program_application_id,
61: program_id = hz_utility_pub.program_id,
62: program_update_date = sysdate
63: where customer_id = p_from_fk_id;
64:
65: l_col_name := 'AS_LEADS_ALL.close_competitor_id';

Line 69: last_update_date = hz_utility_pub.last_update_date,

65: l_col_name := 'AS_LEADS_ALL.close_competitor_id';
66:
67: UPDATE AS_LEADS_ALL
68: set object_version_number = nvl(object_version_number,0) + 1, close_competitor_id = p_to_fk_id,
69: last_update_date = hz_utility_pub.last_update_date,
70: last_updated_by = hz_utility_pub.user_id,
71: last_update_login = hz_utility_pub.last_update_login,
72: request_id = hz_utility_pub.request_id,
73: program_application_id = hz_utility_pub.program_application_id,

Line 70: last_updated_by = hz_utility_pub.user_id,

66:
67: UPDATE AS_LEADS_ALL
68: set object_version_number = nvl(object_version_number,0) + 1, close_competitor_id = p_to_fk_id,
69: last_update_date = hz_utility_pub.last_update_date,
70: last_updated_by = hz_utility_pub.user_id,
71: last_update_login = hz_utility_pub.last_update_login,
72: request_id = hz_utility_pub.request_id,
73: program_application_id = hz_utility_pub.program_application_id,
74: program_id = hz_utility_pub.program_id,

Line 71: last_update_login = hz_utility_pub.last_update_login,

67: UPDATE AS_LEADS_ALL
68: set object_version_number = nvl(object_version_number,0) + 1, close_competitor_id = p_to_fk_id,
69: last_update_date = hz_utility_pub.last_update_date,
70: last_updated_by = hz_utility_pub.user_id,
71: last_update_login = hz_utility_pub.last_update_login,
72: request_id = hz_utility_pub.request_id,
73: program_application_id = hz_utility_pub.program_application_id,
74: program_id = hz_utility_pub.program_id,
75: program_update_date = sysdate

Line 72: request_id = hz_utility_pub.request_id,

68: set object_version_number = nvl(object_version_number,0) + 1, close_competitor_id = p_to_fk_id,
69: last_update_date = hz_utility_pub.last_update_date,
70: last_updated_by = hz_utility_pub.user_id,
71: last_update_login = hz_utility_pub.last_update_login,
72: request_id = hz_utility_pub.request_id,
73: program_application_id = hz_utility_pub.program_application_id,
74: program_id = hz_utility_pub.program_id,
75: program_update_date = sysdate
76: where close_competitor_id = p_from_fk_id;

Line 73: program_application_id = hz_utility_pub.program_application_id,

69: last_update_date = hz_utility_pub.last_update_date,
70: last_updated_by = hz_utility_pub.user_id,
71: last_update_login = hz_utility_pub.last_update_login,
72: request_id = hz_utility_pub.request_id,
73: program_application_id = hz_utility_pub.program_application_id,
74: program_id = hz_utility_pub.program_id,
75: program_update_date = sysdate
76: where close_competitor_id = p_from_fk_id;
77:

Line 74: program_id = hz_utility_pub.program_id,

70: last_updated_by = hz_utility_pub.user_id,
71: last_update_login = hz_utility_pub.last_update_login,
72: request_id = hz_utility_pub.request_id,
73: program_application_id = hz_utility_pub.program_application_id,
74: program_id = hz_utility_pub.program_id,
75: program_update_date = sysdate
76: where close_competitor_id = p_from_fk_id;
77:
78: /*

Line 83: last_update_date = hz_utility_pub.last_update_date,

79: l_col_name := 'AS_LEADS_ALL.end_user_customer_id';
80:
81: UPDATE AS_LEADS_ALL
82: set object_version_number = nvl(object_version_number,0) + 1, end_user_customer_id = p_to_fk_id,
83: last_update_date = hz_utility_pub.last_update_date,
84: last_updated_by = hz_utility_pub.user_id,
85: last_update_login = hz_utility_pub.last_update_login,
86: request_id = hz_utility_pub.request_id,
87: program_application_id = hz_utility_pub.program_application_id,

Line 84: last_updated_by = hz_utility_pub.user_id,

80:
81: UPDATE AS_LEADS_ALL
82: set object_version_number = nvl(object_version_number,0) + 1, end_user_customer_id = p_to_fk_id,
83: last_update_date = hz_utility_pub.last_update_date,
84: last_updated_by = hz_utility_pub.user_id,
85: last_update_login = hz_utility_pub.last_update_login,
86: request_id = hz_utility_pub.request_id,
87: program_application_id = hz_utility_pub.program_application_id,
88: program_id = hz_utility_pub.program_id,

Line 85: last_update_login = hz_utility_pub.last_update_login,

81: UPDATE AS_LEADS_ALL
82: set object_version_number = nvl(object_version_number,0) + 1, end_user_customer_id = p_to_fk_id,
83: last_update_date = hz_utility_pub.last_update_date,
84: last_updated_by = hz_utility_pub.user_id,
85: last_update_login = hz_utility_pub.last_update_login,
86: request_id = hz_utility_pub.request_id,
87: program_application_id = hz_utility_pub.program_application_id,
88: program_id = hz_utility_pub.program_id,
89: program_update_date = sysdate

Line 86: request_id = hz_utility_pub.request_id,

82: set object_version_number = nvl(object_version_number,0) + 1, end_user_customer_id = p_to_fk_id,
83: last_update_date = hz_utility_pub.last_update_date,
84: last_updated_by = hz_utility_pub.user_id,
85: last_update_login = hz_utility_pub.last_update_login,
86: request_id = hz_utility_pub.request_id,
87: program_application_id = hz_utility_pub.program_application_id,
88: program_id = hz_utility_pub.program_id,
89: program_update_date = sysdate
90: where end_user_customer_id = p_from_fk_id;

Line 87: program_application_id = hz_utility_pub.program_application_id,

83: last_update_date = hz_utility_pub.last_update_date,
84: last_updated_by = hz_utility_pub.user_id,
85: last_update_login = hz_utility_pub.last_update_login,
86: request_id = hz_utility_pub.request_id,
87: program_application_id = hz_utility_pub.program_application_id,
88: program_id = hz_utility_pub.program_id,
89: program_update_date = sysdate
90: where end_user_customer_id = p_from_fk_id;
91: */

Line 88: program_id = hz_utility_pub.program_id,

84: last_updated_by = hz_utility_pub.user_id,
85: last_update_login = hz_utility_pub.last_update_login,
86: request_id = hz_utility_pub.request_id,
87: program_application_id = hz_utility_pub.program_application_id,
88: program_id = hz_utility_pub.program_id,
89: program_update_date = sysdate
90: where end_user_customer_id = p_from_fk_id;
91: */
92:

Line 101: last_update_date = hz_utility_pub.last_update_date,

97: incumbent_partner_resource_id=( select resource_id
98: from jtf_rs_resource_extns
99: where category = 'PARTNER'
100: and source_id = p_to_fk_id),
101: last_update_date = hz_utility_pub.last_update_date,
102: last_updated_by = hz_utility_pub.user_id,
103: last_update_login = hz_utility_pub.last_update_login,
104: request_id = hz_utility_pub.request_id,
105: program_application_id = hz_utility_pub.program_application_id,

Line 102: last_updated_by = hz_utility_pub.user_id,

98: from jtf_rs_resource_extns
99: where category = 'PARTNER'
100: and source_id = p_to_fk_id),
101: last_update_date = hz_utility_pub.last_update_date,
102: last_updated_by = hz_utility_pub.user_id,
103: last_update_login = hz_utility_pub.last_update_login,
104: request_id = hz_utility_pub.request_id,
105: program_application_id = hz_utility_pub.program_application_id,
106: program_id = hz_utility_pub.program_id,

Line 103: last_update_login = hz_utility_pub.last_update_login,

99: where category = 'PARTNER'
100: and source_id = p_to_fk_id),
101: last_update_date = hz_utility_pub.last_update_date,
102: last_updated_by = hz_utility_pub.user_id,
103: last_update_login = hz_utility_pub.last_update_login,
104: request_id = hz_utility_pub.request_id,
105: program_application_id = hz_utility_pub.program_application_id,
106: program_id = hz_utility_pub.program_id,
107: program_update_date = sysdate

Line 104: request_id = hz_utility_pub.request_id,

100: and source_id = p_to_fk_id),
101: last_update_date = hz_utility_pub.last_update_date,
102: last_updated_by = hz_utility_pub.user_id,
103: last_update_login = hz_utility_pub.last_update_login,
104: request_id = hz_utility_pub.request_id,
105: program_application_id = hz_utility_pub.program_application_id,
106: program_id = hz_utility_pub.program_id,
107: program_update_date = sysdate
108: where incumbent_partner_party_id = p_from_fk_id;

Line 105: program_application_id = hz_utility_pub.program_application_id,

101: last_update_date = hz_utility_pub.last_update_date,
102: last_updated_by = hz_utility_pub.user_id,
103: last_update_login = hz_utility_pub.last_update_login,
104: request_id = hz_utility_pub.request_id,
105: program_application_id = hz_utility_pub.program_application_id,
106: program_id = hz_utility_pub.program_id,
107: program_update_date = sysdate
108: where incumbent_partner_party_id = p_from_fk_id;
109:

Line 106: program_id = hz_utility_pub.program_id,

102: last_updated_by = hz_utility_pub.user_id,
103: last_update_login = hz_utility_pub.last_update_login,
104: request_id = hz_utility_pub.request_id,
105: program_application_id = hz_utility_pub.program_application_id,
106: program_id = hz_utility_pub.program_id,
107: program_update_date = sysdate
108: where incumbent_partner_party_id = p_from_fk_id;
109:
110: l_col_name := 'AS_LEAD_COMPETITORS.competitor_id';

Line 114: last_update_date = hz_utility_pub.last_update_date,

110: l_col_name := 'AS_LEAD_COMPETITORS.competitor_id';
111:
112: UPDATE AS_LEAD_COMPETITORS
113: set object_version_number = nvl(object_version_number,0) + 1, competitor_id = p_to_fk_id,
114: last_update_date = hz_utility_pub.last_update_date,
115: last_updated_by = hz_utility_pub.user_id,
116: last_update_login = hz_utility_pub.last_update_login,
117: request_id = hz_utility_pub.request_id,
118: program_application_id = hz_utility_pub.program_application_id,

Line 115: last_updated_by = hz_utility_pub.user_id,

111:
112: UPDATE AS_LEAD_COMPETITORS
113: set object_version_number = nvl(object_version_number,0) + 1, competitor_id = p_to_fk_id,
114: last_update_date = hz_utility_pub.last_update_date,
115: last_updated_by = hz_utility_pub.user_id,
116: last_update_login = hz_utility_pub.last_update_login,
117: request_id = hz_utility_pub.request_id,
118: program_application_id = hz_utility_pub.program_application_id,
119: program_id = hz_utility_pub.program_id,

Line 116: last_update_login = hz_utility_pub.last_update_login,

112: UPDATE AS_LEAD_COMPETITORS
113: set object_version_number = nvl(object_version_number,0) + 1, competitor_id = p_to_fk_id,
114: last_update_date = hz_utility_pub.last_update_date,
115: last_updated_by = hz_utility_pub.user_id,
116: last_update_login = hz_utility_pub.last_update_login,
117: request_id = hz_utility_pub.request_id,
118: program_application_id = hz_utility_pub.program_application_id,
119: program_id = hz_utility_pub.program_id,
120: program_update_date = sysdate

Line 117: request_id = hz_utility_pub.request_id,

113: set object_version_number = nvl(object_version_number,0) + 1, competitor_id = p_to_fk_id,
114: last_update_date = hz_utility_pub.last_update_date,
115: last_updated_by = hz_utility_pub.user_id,
116: last_update_login = hz_utility_pub.last_update_login,
117: request_id = hz_utility_pub.request_id,
118: program_application_id = hz_utility_pub.program_application_id,
119: program_id = hz_utility_pub.program_id,
120: program_update_date = sysdate
121: where competitor_id = p_from_fk_id;

Line 118: program_application_id = hz_utility_pub.program_application_id,

114: last_update_date = hz_utility_pub.last_update_date,
115: last_updated_by = hz_utility_pub.user_id,
116: last_update_login = hz_utility_pub.last_update_login,
117: request_id = hz_utility_pub.request_id,
118: program_application_id = hz_utility_pub.program_application_id,
119: program_id = hz_utility_pub.program_id,
120: program_update_date = sysdate
121: where competitor_id = p_from_fk_id;
122:

Line 119: program_id = hz_utility_pub.program_id,

115: last_updated_by = hz_utility_pub.user_id,
116: last_update_login = hz_utility_pub.last_update_login,
117: request_id = hz_utility_pub.request_id,
118: program_application_id = hz_utility_pub.program_application_id,
119: program_id = hz_utility_pub.program_id,
120: program_update_date = sysdate
121: where competitor_id = p_from_fk_id;
122:
123: l_col_name := 'AS_LEAD_CONTACTS_ALL.contact_party_id';

Line 127: last_update_date = hz_utility_pub.last_update_date,

123: l_col_name := 'AS_LEAD_CONTACTS_ALL.contact_party_id';
124:
125: UPDATE AS_LEAD_CONTACTS_ALL
126: set object_version_number = nvl(object_version_number,0) + 1, contact_party_id = p_to_fk_id,
127: last_update_date = hz_utility_pub.last_update_date,
128: last_updated_by = hz_utility_pub.user_id,
129: last_update_login = hz_utility_pub.last_update_login,
130: request_id = hz_utility_pub.request_id,
131: program_application_id = hz_utility_pub.program_application_id,

Line 128: last_updated_by = hz_utility_pub.user_id,

124:
125: UPDATE AS_LEAD_CONTACTS_ALL
126: set object_version_number = nvl(object_version_number,0) + 1, contact_party_id = p_to_fk_id,
127: last_update_date = hz_utility_pub.last_update_date,
128: last_updated_by = hz_utility_pub.user_id,
129: last_update_login = hz_utility_pub.last_update_login,
130: request_id = hz_utility_pub.request_id,
131: program_application_id = hz_utility_pub.program_application_id,
132: program_id = hz_utility_pub.program_id,

Line 129: last_update_login = hz_utility_pub.last_update_login,

125: UPDATE AS_LEAD_CONTACTS_ALL
126: set object_version_number = nvl(object_version_number,0) + 1, contact_party_id = p_to_fk_id,
127: last_update_date = hz_utility_pub.last_update_date,
128: last_updated_by = hz_utility_pub.user_id,
129: last_update_login = hz_utility_pub.last_update_login,
130: request_id = hz_utility_pub.request_id,
131: program_application_id = hz_utility_pub.program_application_id,
132: program_id = hz_utility_pub.program_id,
133: program_update_date = sysdate

Line 130: request_id = hz_utility_pub.request_id,

126: set object_version_number = nvl(object_version_number,0) + 1, contact_party_id = p_to_fk_id,
127: last_update_date = hz_utility_pub.last_update_date,
128: last_updated_by = hz_utility_pub.user_id,
129: last_update_login = hz_utility_pub.last_update_login,
130: request_id = hz_utility_pub.request_id,
131: program_application_id = hz_utility_pub.program_application_id,
132: program_id = hz_utility_pub.program_id,
133: program_update_date = sysdate
134: where contact_party_id = p_from_fk_id;

Line 131: program_application_id = hz_utility_pub.program_application_id,

127: last_update_date = hz_utility_pub.last_update_date,
128: last_updated_by = hz_utility_pub.user_id,
129: last_update_login = hz_utility_pub.last_update_login,
130: request_id = hz_utility_pub.request_id,
131: program_application_id = hz_utility_pub.program_application_id,
132: program_id = hz_utility_pub.program_id,
133: program_update_date = sysdate
134: where contact_party_id = p_from_fk_id;
135:

Line 132: program_id = hz_utility_pub.program_id,

128: last_updated_by = hz_utility_pub.user_id,
129: last_update_login = hz_utility_pub.last_update_login,
130: request_id = hz_utility_pub.request_id,
131: program_application_id = hz_utility_pub.program_application_id,
132: program_id = hz_utility_pub.program_id,
133: program_update_date = sysdate
134: where contact_party_id = p_from_fk_id;
135:
136: l_col_name := 'AS_LEAD_CONTACTS_ALL.customer_id';

Line 140: last_update_date = hz_utility_pub.last_update_date,

136: l_col_name := 'AS_LEAD_CONTACTS_ALL.customer_id';
137:
138: UPDATE AS_LEAD_CONTACTS_ALL
139: set object_version_number = nvl(object_version_number,0) + 1, customer_id = p_to_fk_id,
140: last_update_date = hz_utility_pub.last_update_date,
141: last_updated_by = hz_utility_pub.user_id,
142: last_update_login = hz_utility_pub.last_update_login,
143: request_id = hz_utility_pub.request_id,
144: program_application_id = hz_utility_pub.program_application_id,

Line 141: last_updated_by = hz_utility_pub.user_id,

137:
138: UPDATE AS_LEAD_CONTACTS_ALL
139: set object_version_number = nvl(object_version_number,0) + 1, customer_id = p_to_fk_id,
140: last_update_date = hz_utility_pub.last_update_date,
141: last_updated_by = hz_utility_pub.user_id,
142: last_update_login = hz_utility_pub.last_update_login,
143: request_id = hz_utility_pub.request_id,
144: program_application_id = hz_utility_pub.program_application_id,
145: program_id = hz_utility_pub.program_id,

Line 142: last_update_login = hz_utility_pub.last_update_login,

138: UPDATE AS_LEAD_CONTACTS_ALL
139: set object_version_number = nvl(object_version_number,0) + 1, customer_id = p_to_fk_id,
140: last_update_date = hz_utility_pub.last_update_date,
141: last_updated_by = hz_utility_pub.user_id,
142: last_update_login = hz_utility_pub.last_update_login,
143: request_id = hz_utility_pub.request_id,
144: program_application_id = hz_utility_pub.program_application_id,
145: program_id = hz_utility_pub.program_id,
146: program_update_date = sysdate

Line 143: request_id = hz_utility_pub.request_id,

139: set object_version_number = nvl(object_version_number,0) + 1, customer_id = p_to_fk_id,
140: last_update_date = hz_utility_pub.last_update_date,
141: last_updated_by = hz_utility_pub.user_id,
142: last_update_login = hz_utility_pub.last_update_login,
143: request_id = hz_utility_pub.request_id,
144: program_application_id = hz_utility_pub.program_application_id,
145: program_id = hz_utility_pub.program_id,
146: program_update_date = sysdate
147: where customer_id = p_from_fk_id;

Line 144: program_application_id = hz_utility_pub.program_application_id,

140: last_update_date = hz_utility_pub.last_update_date,
141: last_updated_by = hz_utility_pub.user_id,
142: last_update_login = hz_utility_pub.last_update_login,
143: request_id = hz_utility_pub.request_id,
144: program_application_id = hz_utility_pub.program_application_id,
145: program_id = hz_utility_pub.program_id,
146: program_update_date = sysdate
147: where customer_id = p_from_fk_id;
148:

Line 145: program_id = hz_utility_pub.program_id,

141: last_updated_by = hz_utility_pub.user_id,
142: last_update_login = hz_utility_pub.last_update_login,
143: request_id = hz_utility_pub.request_id,
144: program_application_id = hz_utility_pub.program_application_id,
145: program_id = hz_utility_pub.program_id,
146: program_update_date = sysdate
147: where customer_id = p_from_fk_id;
148:
149: l_col_name := 'AS_SALES_CREDITS.partner_customer_id';

Line 153: last_update_date = hz_utility_pub.last_update_date,

149: l_col_name := 'AS_SALES_CREDITS.partner_customer_id';
150:
151: UPDATE AS_SALES_CREDITS
152: set object_version_number = nvl(object_version_number,0) + 1, partner_customer_id = p_to_fk_id,
153: last_update_date = hz_utility_pub.last_update_date,
154: last_updated_by = hz_utility_pub.user_id,
155: last_update_login = hz_utility_pub.last_update_login,
156: request_id = hz_utility_pub.request_id,
157: program_application_id = hz_utility_pub.program_application_id,

Line 154: last_updated_by = hz_utility_pub.user_id,

150:
151: UPDATE AS_SALES_CREDITS
152: set object_version_number = nvl(object_version_number,0) + 1, partner_customer_id = p_to_fk_id,
153: last_update_date = hz_utility_pub.last_update_date,
154: last_updated_by = hz_utility_pub.user_id,
155: last_update_login = hz_utility_pub.last_update_login,
156: request_id = hz_utility_pub.request_id,
157: program_application_id = hz_utility_pub.program_application_id,
158: program_id = hz_utility_pub.program_id,

Line 155: last_update_login = hz_utility_pub.last_update_login,

151: UPDATE AS_SALES_CREDITS
152: set object_version_number = nvl(object_version_number,0) + 1, partner_customer_id = p_to_fk_id,
153: last_update_date = hz_utility_pub.last_update_date,
154: last_updated_by = hz_utility_pub.user_id,
155: last_update_login = hz_utility_pub.last_update_login,
156: request_id = hz_utility_pub.request_id,
157: program_application_id = hz_utility_pub.program_application_id,
158: program_id = hz_utility_pub.program_id,
159: program_update_date = sysdate

Line 156: request_id = hz_utility_pub.request_id,

152: set object_version_number = nvl(object_version_number,0) + 1, partner_customer_id = p_to_fk_id,
153: last_update_date = hz_utility_pub.last_update_date,
154: last_updated_by = hz_utility_pub.user_id,
155: last_update_login = hz_utility_pub.last_update_login,
156: request_id = hz_utility_pub.request_id,
157: program_application_id = hz_utility_pub.program_application_id,
158: program_id = hz_utility_pub.program_id,
159: program_update_date = sysdate
160: where partner_customer_id = p_from_fk_id;

Line 157: program_application_id = hz_utility_pub.program_application_id,

153: last_update_date = hz_utility_pub.last_update_date,
154: last_updated_by = hz_utility_pub.user_id,
155: last_update_login = hz_utility_pub.last_update_login,
156: request_id = hz_utility_pub.request_id,
157: program_application_id = hz_utility_pub.program_application_id,
158: program_id = hz_utility_pub.program_id,
159: program_update_date = sysdate
160: where partner_customer_id = p_from_fk_id;
161:

Line 158: program_id = hz_utility_pub.program_id,

154: last_updated_by = hz_utility_pub.user_id,
155: last_update_login = hz_utility_pub.last_update_login,
156: request_id = hz_utility_pub.request_id,
157: program_application_id = hz_utility_pub.program_application_id,
158: program_id = hz_utility_pub.program_id,
159: program_update_date = sysdate
160: where partner_customer_id = p_from_fk_id;
161:
162: l_col_name := 'AS_SALES_CREDITS_DENORM.partner_customer_id';

Line 166: last_update_date = hz_utility_pub.last_update_date,

162: l_col_name := 'AS_SALES_CREDITS_DENORM.partner_customer_id';
163:
164: UPDATE AS_SALES_CREDITS_DENORM
165: set object_version_number = nvl(object_version_number,0) + 1, partner_customer_id = p_to_fk_id,
166: last_update_date = hz_utility_pub.last_update_date,
167: last_updated_by = hz_utility_pub.user_id,
168: last_update_login = hz_utility_pub.last_update_login,
169: request_id = hz_utility_pub.request_id,
170: program_application_id = hz_utility_pub.program_application_id,

Line 167: last_updated_by = hz_utility_pub.user_id,

163:
164: UPDATE AS_SALES_CREDITS_DENORM
165: set object_version_number = nvl(object_version_number,0) + 1, partner_customer_id = p_to_fk_id,
166: last_update_date = hz_utility_pub.last_update_date,
167: last_updated_by = hz_utility_pub.user_id,
168: last_update_login = hz_utility_pub.last_update_login,
169: request_id = hz_utility_pub.request_id,
170: program_application_id = hz_utility_pub.program_application_id,
171: program_id = hz_utility_pub.program_id,

Line 168: last_update_login = hz_utility_pub.last_update_login,

164: UPDATE AS_SALES_CREDITS_DENORM
165: set object_version_number = nvl(object_version_number,0) + 1, partner_customer_id = p_to_fk_id,
166: last_update_date = hz_utility_pub.last_update_date,
167: last_updated_by = hz_utility_pub.user_id,
168: last_update_login = hz_utility_pub.last_update_login,
169: request_id = hz_utility_pub.request_id,
170: program_application_id = hz_utility_pub.program_application_id,
171: program_id = hz_utility_pub.program_id,
172: program_update_date = sysdate

Line 169: request_id = hz_utility_pub.request_id,

165: set object_version_number = nvl(object_version_number,0) + 1, partner_customer_id = p_to_fk_id,
166: last_update_date = hz_utility_pub.last_update_date,
167: last_updated_by = hz_utility_pub.user_id,
168: last_update_login = hz_utility_pub.last_update_login,
169: request_id = hz_utility_pub.request_id,
170: program_application_id = hz_utility_pub.program_application_id,
171: program_id = hz_utility_pub.program_id,
172: program_update_date = sysdate
173: where partner_customer_id = p_from_fk_id;

Line 170: program_application_id = hz_utility_pub.program_application_id,

166: last_update_date = hz_utility_pub.last_update_date,
167: last_updated_by = hz_utility_pub.user_id,
168: last_update_login = hz_utility_pub.last_update_login,
169: request_id = hz_utility_pub.request_id,
170: program_application_id = hz_utility_pub.program_application_id,
171: program_id = hz_utility_pub.program_id,
172: program_update_date = sysdate
173: where partner_customer_id = p_from_fk_id;
174:

Line 171: program_id = hz_utility_pub.program_id,

167: last_updated_by = hz_utility_pub.user_id,
168: last_update_login = hz_utility_pub.last_update_login,
169: request_id = hz_utility_pub.request_id,
170: program_application_id = hz_utility_pub.program_application_id,
171: program_id = hz_utility_pub.program_id,
172: program_update_date = sysdate
173: where partner_customer_id = p_from_fk_id;
174:
175: l_col_name := 'AS_SALES_CREDITS_DENORM.customer_id';

Line 179: last_update_date = hz_utility_pub.last_update_date,

175: l_col_name := 'AS_SALES_CREDITS_DENORM.customer_id';
176:
177: UPDATE AS_SALES_CREDITS_DENORM
178: set object_version_number = nvl(object_version_number,0) + 1, customer_id = p_to_fk_id,
179: last_update_date = hz_utility_pub.last_update_date,
180: last_updated_by = hz_utility_pub.user_id,
181: last_update_login = hz_utility_pub.last_update_login,
182: request_id = hz_utility_pub.request_id,
183: program_application_id = hz_utility_pub.program_application_id,

Line 180: last_updated_by = hz_utility_pub.user_id,

176:
177: UPDATE AS_SALES_CREDITS_DENORM
178: set object_version_number = nvl(object_version_number,0) + 1, customer_id = p_to_fk_id,
179: last_update_date = hz_utility_pub.last_update_date,
180: last_updated_by = hz_utility_pub.user_id,
181: last_update_login = hz_utility_pub.last_update_login,
182: request_id = hz_utility_pub.request_id,
183: program_application_id = hz_utility_pub.program_application_id,
184: program_id = hz_utility_pub.program_id,

Line 181: last_update_login = hz_utility_pub.last_update_login,

177: UPDATE AS_SALES_CREDITS_DENORM
178: set object_version_number = nvl(object_version_number,0) + 1, customer_id = p_to_fk_id,
179: last_update_date = hz_utility_pub.last_update_date,
180: last_updated_by = hz_utility_pub.user_id,
181: last_update_login = hz_utility_pub.last_update_login,
182: request_id = hz_utility_pub.request_id,
183: program_application_id = hz_utility_pub.program_application_id,
184: program_id = hz_utility_pub.program_id,
185: program_update_date = sysdate

Line 182: request_id = hz_utility_pub.request_id,

178: set object_version_number = nvl(object_version_number,0) + 1, customer_id = p_to_fk_id,
179: last_update_date = hz_utility_pub.last_update_date,
180: last_updated_by = hz_utility_pub.user_id,
181: last_update_login = hz_utility_pub.last_update_login,
182: request_id = hz_utility_pub.request_id,
183: program_application_id = hz_utility_pub.program_application_id,
184: program_id = hz_utility_pub.program_id,
185: program_update_date = sysdate
186: where customer_id = p_from_fk_id;

Line 183: program_application_id = hz_utility_pub.program_application_id,

179: last_update_date = hz_utility_pub.last_update_date,
180: last_updated_by = hz_utility_pub.user_id,
181: last_update_login = hz_utility_pub.last_update_login,
182: request_id = hz_utility_pub.request_id,
183: program_application_id = hz_utility_pub.program_application_id,
184: program_id = hz_utility_pub.program_id,
185: program_update_date = sysdate
186: where customer_id = p_from_fk_id;
187:

Line 184: program_id = hz_utility_pub.program_id,

180: last_updated_by = hz_utility_pub.user_id,
181: last_update_login = hz_utility_pub.last_update_login,
182: request_id = hz_utility_pub.request_id,
183: program_application_id = hz_utility_pub.program_application_id,
184: program_id = hz_utility_pub.program_id,
185: program_update_date = sysdate
186: where customer_id = p_from_fk_id;
187:
188: -- add AS_LEADS_LOG.customer_id and AS_LEADS_LOG.close_competitor_id

Line 195: --last_update_date = hz_utility_pub.last_update_date,

191: l_col_name := 'AS_LEADS_LOG.customer_id';
192:
193: UPDATE AS_LEADS_LOG
194: set object_version_number = nvl(object_version_number,0) + 1, customer_id = p_to_fk_id
195: --last_update_date = hz_utility_pub.last_update_date,
196: --last_updated_by = hz_utility_pub.user_id,
197: --last_update_login = hz_utility_pub.last_update_login
198: --request_id = hz_utility_pub.request_id,
199: --program_application_id = hz_utility_pub.program_application_id,

Line 196: --last_updated_by = hz_utility_pub.user_id,

192:
193: UPDATE AS_LEADS_LOG
194: set object_version_number = nvl(object_version_number,0) + 1, customer_id = p_to_fk_id
195: --last_update_date = hz_utility_pub.last_update_date,
196: --last_updated_by = hz_utility_pub.user_id,
197: --last_update_login = hz_utility_pub.last_update_login
198: --request_id = hz_utility_pub.request_id,
199: --program_application_id = hz_utility_pub.program_application_id,
200: --program_id = hz_utility_pub.program_id,

Line 197: --last_update_login = hz_utility_pub.last_update_login

193: UPDATE AS_LEADS_LOG
194: set object_version_number = nvl(object_version_number,0) + 1, customer_id = p_to_fk_id
195: --last_update_date = hz_utility_pub.last_update_date,
196: --last_updated_by = hz_utility_pub.user_id,
197: --last_update_login = hz_utility_pub.last_update_login
198: --request_id = hz_utility_pub.request_id,
199: --program_application_id = hz_utility_pub.program_application_id,
200: --program_id = hz_utility_pub.program_id,
201: --program_update_date = sysdate

Line 198: --request_id = hz_utility_pub.request_id,

194: set object_version_number = nvl(object_version_number,0) + 1, customer_id = p_to_fk_id
195: --last_update_date = hz_utility_pub.last_update_date,
196: --last_updated_by = hz_utility_pub.user_id,
197: --last_update_login = hz_utility_pub.last_update_login
198: --request_id = hz_utility_pub.request_id,
199: --program_application_id = hz_utility_pub.program_application_id,
200: --program_id = hz_utility_pub.program_id,
201: --program_update_date = sysdate
202: where customer_id = p_from_fk_id;

Line 199: --program_application_id = hz_utility_pub.program_application_id,

195: --last_update_date = hz_utility_pub.last_update_date,
196: --last_updated_by = hz_utility_pub.user_id,
197: --last_update_login = hz_utility_pub.last_update_login
198: --request_id = hz_utility_pub.request_id,
199: --program_application_id = hz_utility_pub.program_application_id,
200: --program_id = hz_utility_pub.program_id,
201: --program_update_date = sysdate
202: where customer_id = p_from_fk_id;
203:

Line 200: --program_id = hz_utility_pub.program_id,

196: --last_updated_by = hz_utility_pub.user_id,
197: --last_update_login = hz_utility_pub.last_update_login
198: --request_id = hz_utility_pub.request_id,
199: --program_application_id = hz_utility_pub.program_application_id,
200: --program_id = hz_utility_pub.program_id,
201: --program_update_date = sysdate
202: where customer_id = p_from_fk_id;
203:
204: l_col_name := 'AS_LEADS_LOG.close_competitor_id';

Line 208: --last_update_date = hz_utility_pub.last_update_date,

204: l_col_name := 'AS_LEADS_LOG.close_competitor_id';
205:
206: UPDATE AS_LEADS_LOG
207: set object_version_number = nvl(object_version_number,0) + 1, close_competitor_id = p_to_fk_id
208: --last_update_date = hz_utility_pub.last_update_date,
209: --last_updated_by = hz_utility_pub.user_id,
210: --last_update_login = hz_utility_pub.last_update_login,
211: --request_id = hz_utility_pub.request_id,
212: --program_application_id = hz_utility_pub.program_application_id,

Line 209: --last_updated_by = hz_utility_pub.user_id,

205:
206: UPDATE AS_LEADS_LOG
207: set object_version_number = nvl(object_version_number,0) + 1, close_competitor_id = p_to_fk_id
208: --last_update_date = hz_utility_pub.last_update_date,
209: --last_updated_by = hz_utility_pub.user_id,
210: --last_update_login = hz_utility_pub.last_update_login,
211: --request_id = hz_utility_pub.request_id,
212: --program_application_id = hz_utility_pub.program_application_id,
213: --program_id = hz_utility_pub.program_id,

Line 210: --last_update_login = hz_utility_pub.last_update_login,

206: UPDATE AS_LEADS_LOG
207: set object_version_number = nvl(object_version_number,0) + 1, close_competitor_id = p_to_fk_id
208: --last_update_date = hz_utility_pub.last_update_date,
209: --last_updated_by = hz_utility_pub.user_id,
210: --last_update_login = hz_utility_pub.last_update_login,
211: --request_id = hz_utility_pub.request_id,
212: --program_application_id = hz_utility_pub.program_application_id,
213: --program_id = hz_utility_pub.program_id,
214: --program_update_date = sysdate

Line 211: --request_id = hz_utility_pub.request_id,

207: set object_version_number = nvl(object_version_number,0) + 1, close_competitor_id = p_to_fk_id
208: --last_update_date = hz_utility_pub.last_update_date,
209: --last_updated_by = hz_utility_pub.user_id,
210: --last_update_login = hz_utility_pub.last_update_login,
211: --request_id = hz_utility_pub.request_id,
212: --program_application_id = hz_utility_pub.program_application_id,
213: --program_id = hz_utility_pub.program_id,
214: --program_update_date = sysdate
215: where close_competitor_id = p_from_fk_id;

Line 212: --program_application_id = hz_utility_pub.program_application_id,

208: --last_update_date = hz_utility_pub.last_update_date,
209: --last_updated_by = hz_utility_pub.user_id,
210: --last_update_login = hz_utility_pub.last_update_login,
211: --request_id = hz_utility_pub.request_id,
212: --program_application_id = hz_utility_pub.program_application_id,
213: --program_id = hz_utility_pub.program_id,
214: --program_update_date = sysdate
215: where close_competitor_id = p_from_fk_id;
216:

Line 213: --program_id = hz_utility_pub.program_id,

209: --last_updated_by = hz_utility_pub.user_id,
210: --last_update_login = hz_utility_pub.last_update_login,
211: --request_id = hz_utility_pub.request_id,
212: --program_application_id = hz_utility_pub.program_application_id,
213: --program_id = hz_utility_pub.program_id,
214: --program_update_date = sysdate
215: where close_competitor_id = p_from_fk_id;
216:
217: l_col_name := 'AS_SALES_CREDITS_DENORM.close_competitor_id';

Line 221: last_update_date = hz_utility_pub.last_update_date,

217: l_col_name := 'AS_SALES_CREDITS_DENORM.close_competitor_id';
218:
219: UPDATE AS_SALES_CREDITS_DENORM
220: set object_version_number = nvl(object_version_number,0) + 1, close_competitor_id = p_to_fk_id,
221: last_update_date = hz_utility_pub.last_update_date,
222: last_updated_by = hz_utility_pub.user_id,
223: last_update_login = hz_utility_pub.last_update_login,
224: request_id = hz_utility_pub.request_id,
225: program_application_id = hz_utility_pub.program_application_id,

Line 222: last_updated_by = hz_utility_pub.user_id,

218:
219: UPDATE AS_SALES_CREDITS_DENORM
220: set object_version_number = nvl(object_version_number,0) + 1, close_competitor_id = p_to_fk_id,
221: last_update_date = hz_utility_pub.last_update_date,
222: last_updated_by = hz_utility_pub.user_id,
223: last_update_login = hz_utility_pub.last_update_login,
224: request_id = hz_utility_pub.request_id,
225: program_application_id = hz_utility_pub.program_application_id,
226: program_id = hz_utility_pub.program_id,

Line 223: last_update_login = hz_utility_pub.last_update_login,

219: UPDATE AS_SALES_CREDITS_DENORM
220: set object_version_number = nvl(object_version_number,0) + 1, close_competitor_id = p_to_fk_id,
221: last_update_date = hz_utility_pub.last_update_date,
222: last_updated_by = hz_utility_pub.user_id,
223: last_update_login = hz_utility_pub.last_update_login,
224: request_id = hz_utility_pub.request_id,
225: program_application_id = hz_utility_pub.program_application_id,
226: program_id = hz_utility_pub.program_id,
227: program_update_date = sysdate

Line 224: request_id = hz_utility_pub.request_id,

220: set object_version_number = nvl(object_version_number,0) + 1, close_competitor_id = p_to_fk_id,
221: last_update_date = hz_utility_pub.last_update_date,
222: last_updated_by = hz_utility_pub.user_id,
223: last_update_login = hz_utility_pub.last_update_login,
224: request_id = hz_utility_pub.request_id,
225: program_application_id = hz_utility_pub.program_application_id,
226: program_id = hz_utility_pub.program_id,
227: program_update_date = sysdate
228: where close_competitor_id = p_from_fk_id;

Line 225: program_application_id = hz_utility_pub.program_application_id,

221: last_update_date = hz_utility_pub.last_update_date,
222: last_updated_by = hz_utility_pub.user_id,
223: last_update_login = hz_utility_pub.last_update_login,
224: request_id = hz_utility_pub.request_id,
225: program_application_id = hz_utility_pub.program_application_id,
226: program_id = hz_utility_pub.program_id,
227: program_update_date = sysdate
228: where close_competitor_id = p_from_fk_id;
229:

Line 226: program_id = hz_utility_pub.program_id,

222: last_updated_by = hz_utility_pub.user_id,
223: last_update_login = hz_utility_pub.last_update_login,
224: request_id = hz_utility_pub.request_id,
225: program_application_id = hz_utility_pub.program_application_id,
226: program_id = hz_utility_pub.program_id,
227: program_update_date = sysdate
228: where close_competitor_id = p_from_fk_id;
229:
230:

Line 237: last_update_date = hz_utility_pub.last_update_date,

233: l_col_name := 'AS_LEADS_ALL.address_id';
234:
235: UPDATE AS_LEADS_ALL
236: set object_version_number = nvl(object_version_number,0) + 1, address_id = p_to_fk_id,
237: last_update_date = hz_utility_pub.last_update_date,
238: last_updated_by = hz_utility_pub.user_id,
239: last_update_login = hz_utility_pub.last_update_login,
240: request_id = hz_utility_pub.request_id,
241: program_application_id = hz_utility_pub.program_application_id,

Line 238: last_updated_by = hz_utility_pub.user_id,

234:
235: UPDATE AS_LEADS_ALL
236: set object_version_number = nvl(object_version_number,0) + 1, address_id = p_to_fk_id,
237: last_update_date = hz_utility_pub.last_update_date,
238: last_updated_by = hz_utility_pub.user_id,
239: last_update_login = hz_utility_pub.last_update_login,
240: request_id = hz_utility_pub.request_id,
241: program_application_id = hz_utility_pub.program_application_id,
242: program_id = hz_utility_pub.program_id,

Line 239: last_update_login = hz_utility_pub.last_update_login,

235: UPDATE AS_LEADS_ALL
236: set object_version_number = nvl(object_version_number,0) + 1, address_id = p_to_fk_id,
237: last_update_date = hz_utility_pub.last_update_date,
238: last_updated_by = hz_utility_pub.user_id,
239: last_update_login = hz_utility_pub.last_update_login,
240: request_id = hz_utility_pub.request_id,
241: program_application_id = hz_utility_pub.program_application_id,
242: program_id = hz_utility_pub.program_id,
243: program_update_date = sysdate

Line 240: request_id = hz_utility_pub.request_id,

236: set object_version_number = nvl(object_version_number,0) + 1, address_id = p_to_fk_id,
237: last_update_date = hz_utility_pub.last_update_date,
238: last_updated_by = hz_utility_pub.user_id,
239: last_update_login = hz_utility_pub.last_update_login,
240: request_id = hz_utility_pub.request_id,
241: program_application_id = hz_utility_pub.program_application_id,
242: program_id = hz_utility_pub.program_id,
243: program_update_date = sysdate
244: where address_id = p_from_fk_id;

Line 241: program_application_id = hz_utility_pub.program_application_id,

237: last_update_date = hz_utility_pub.last_update_date,
238: last_updated_by = hz_utility_pub.user_id,
239: last_update_login = hz_utility_pub.last_update_login,
240: request_id = hz_utility_pub.request_id,
241: program_application_id = hz_utility_pub.program_application_id,
242: program_id = hz_utility_pub.program_id,
243: program_update_date = sysdate
244: where address_id = p_from_fk_id;
245:

Line 242: program_id = hz_utility_pub.program_id,

238: last_updated_by = hz_utility_pub.user_id,
239: last_update_login = hz_utility_pub.last_update_login,
240: request_id = hz_utility_pub.request_id,
241: program_application_id = hz_utility_pub.program_application_id,
242: program_id = hz_utility_pub.program_id,
243: program_update_date = sysdate
244: where address_id = p_from_fk_id;
245:
246: /*

Line 251: last_update_date = hz_utility_pub.last_update_date,

247: l_col_name := 'AS_LEADS_ALL.end_user_address_id';
248:
249: UPDATE AS_LEADS_ALL
250: set object_version_number = nvl(object_version_number,0) + 1, end_user_address_id = p_to_fk_id,
251: last_update_date = hz_utility_pub.last_update_date,
252: last_updated_by = hz_utility_pub.user_id,
253: last_update_login = hz_utility_pub.last_update_login,
254: request_id = hz_utility_pub.request_id,
255: program_application_id = hz_utility_pub.program_application_id,

Line 252: last_updated_by = hz_utility_pub.user_id,

248:
249: UPDATE AS_LEADS_ALL
250: set object_version_number = nvl(object_version_number,0) + 1, end_user_address_id = p_to_fk_id,
251: last_update_date = hz_utility_pub.last_update_date,
252: last_updated_by = hz_utility_pub.user_id,
253: last_update_login = hz_utility_pub.last_update_login,
254: request_id = hz_utility_pub.request_id,
255: program_application_id = hz_utility_pub.program_application_id,
256: program_id = hz_utility_pub.program_id,

Line 253: last_update_login = hz_utility_pub.last_update_login,

249: UPDATE AS_LEADS_ALL
250: set object_version_number = nvl(object_version_number,0) + 1, end_user_address_id = p_to_fk_id,
251: last_update_date = hz_utility_pub.last_update_date,
252: last_updated_by = hz_utility_pub.user_id,
253: last_update_login = hz_utility_pub.last_update_login,
254: request_id = hz_utility_pub.request_id,
255: program_application_id = hz_utility_pub.program_application_id,
256: program_id = hz_utility_pub.program_id,
257: program_update_date = sysdate

Line 254: request_id = hz_utility_pub.request_id,

250: set object_version_number = nvl(object_version_number,0) + 1, end_user_address_id = p_to_fk_id,
251: last_update_date = hz_utility_pub.last_update_date,
252: last_updated_by = hz_utility_pub.user_id,
253: last_update_login = hz_utility_pub.last_update_login,
254: request_id = hz_utility_pub.request_id,
255: program_application_id = hz_utility_pub.program_application_id,
256: program_id = hz_utility_pub.program_id,
257: program_update_date = sysdate
258: where end_user_address_id = p_from_fk_id;

Line 255: program_application_id = hz_utility_pub.program_application_id,

251: last_update_date = hz_utility_pub.last_update_date,
252: last_updated_by = hz_utility_pub.user_id,
253: last_update_login = hz_utility_pub.last_update_login,
254: request_id = hz_utility_pub.request_id,
255: program_application_id = hz_utility_pub.program_application_id,
256: program_id = hz_utility_pub.program_id,
257: program_update_date = sysdate
258: where end_user_address_id = p_from_fk_id;
259: */

Line 256: program_id = hz_utility_pub.program_id,

252: last_updated_by = hz_utility_pub.user_id,
253: last_update_login = hz_utility_pub.last_update_login,
254: request_id = hz_utility_pub.request_id,
255: program_application_id = hz_utility_pub.program_application_id,
256: program_id = hz_utility_pub.program_id,
257: program_update_date = sysdate
258: where end_user_address_id = p_from_fk_id;
259: */
260:

Line 265: last_update_date = hz_utility_pub.last_update_date,

261: l_col_name := 'AS_LEAD_CONTACTS_ALL.address_id';
262:
263: UPDATE AS_LEAD_CONTACTS_ALL
264: set object_version_number = nvl(object_version_number,0) + 1, address_id = p_to_fk_id,
265: last_update_date = hz_utility_pub.last_update_date,
266: last_updated_by = hz_utility_pub.user_id,
267: last_update_login = hz_utility_pub.last_update_login,
268: request_id = hz_utility_pub.request_id,
269: program_application_id = hz_utility_pub.program_application_id,

Line 266: last_updated_by = hz_utility_pub.user_id,

262:
263: UPDATE AS_LEAD_CONTACTS_ALL
264: set object_version_number = nvl(object_version_number,0) + 1, address_id = p_to_fk_id,
265: last_update_date = hz_utility_pub.last_update_date,
266: last_updated_by = hz_utility_pub.user_id,
267: last_update_login = hz_utility_pub.last_update_login,
268: request_id = hz_utility_pub.request_id,
269: program_application_id = hz_utility_pub.program_application_id,
270: program_id = hz_utility_pub.program_id,

Line 267: last_update_login = hz_utility_pub.last_update_login,

263: UPDATE AS_LEAD_CONTACTS_ALL
264: set object_version_number = nvl(object_version_number,0) + 1, address_id = p_to_fk_id,
265: last_update_date = hz_utility_pub.last_update_date,
266: last_updated_by = hz_utility_pub.user_id,
267: last_update_login = hz_utility_pub.last_update_login,
268: request_id = hz_utility_pub.request_id,
269: program_application_id = hz_utility_pub.program_application_id,
270: program_id = hz_utility_pub.program_id,
271: program_update_date = sysdate

Line 268: request_id = hz_utility_pub.request_id,

264: set object_version_number = nvl(object_version_number,0) + 1, address_id = p_to_fk_id,
265: last_update_date = hz_utility_pub.last_update_date,
266: last_updated_by = hz_utility_pub.user_id,
267: last_update_login = hz_utility_pub.last_update_login,
268: request_id = hz_utility_pub.request_id,
269: program_application_id = hz_utility_pub.program_application_id,
270: program_id = hz_utility_pub.program_id,
271: program_update_date = sysdate
272: where address_id = p_from_fk_id;

Line 269: program_application_id = hz_utility_pub.program_application_id,

265: last_update_date = hz_utility_pub.last_update_date,
266: last_updated_by = hz_utility_pub.user_id,
267: last_update_login = hz_utility_pub.last_update_login,
268: request_id = hz_utility_pub.request_id,
269: program_application_id = hz_utility_pub.program_application_id,
270: program_id = hz_utility_pub.program_id,
271: program_update_date = sysdate
272: where address_id = p_from_fk_id;
273:

Line 270: program_id = hz_utility_pub.program_id,

266: last_updated_by = hz_utility_pub.user_id,
267: last_update_login = hz_utility_pub.last_update_login,
268: request_id = hz_utility_pub.request_id,
269: program_application_id = hz_utility_pub.program_application_id,
270: program_id = hz_utility_pub.program_id,
271: program_update_date = sysdate
272: where address_id = p_from_fk_id;
273:
274: l_col_name := 'AS_SALES_CREDITS.partner_address_id';

Line 278: last_update_date = hz_utility_pub.last_update_date,

274: l_col_name := 'AS_SALES_CREDITS.partner_address_id';
275:
276: UPDATE AS_SALES_CREDITS
277: set object_version_number = nvl(object_version_number,0) + 1, partner_address_id = p_to_fk_id,
278: last_update_date = hz_utility_pub.last_update_date,
279: last_updated_by = hz_utility_pub.user_id,
280: last_update_login = hz_utility_pub.last_update_login,
281: request_id = hz_utility_pub.request_id,
282: program_application_id = hz_utility_pub.program_application_id,

Line 279: last_updated_by = hz_utility_pub.user_id,

275:
276: UPDATE AS_SALES_CREDITS
277: set object_version_number = nvl(object_version_number,0) + 1, partner_address_id = p_to_fk_id,
278: last_update_date = hz_utility_pub.last_update_date,
279: last_updated_by = hz_utility_pub.user_id,
280: last_update_login = hz_utility_pub.last_update_login,
281: request_id = hz_utility_pub.request_id,
282: program_application_id = hz_utility_pub.program_application_id,
283: program_id = hz_utility_pub.program_id,

Line 280: last_update_login = hz_utility_pub.last_update_login,

276: UPDATE AS_SALES_CREDITS
277: set object_version_number = nvl(object_version_number,0) + 1, partner_address_id = p_to_fk_id,
278: last_update_date = hz_utility_pub.last_update_date,
279: last_updated_by = hz_utility_pub.user_id,
280: last_update_login = hz_utility_pub.last_update_login,
281: request_id = hz_utility_pub.request_id,
282: program_application_id = hz_utility_pub.program_application_id,
283: program_id = hz_utility_pub.program_id,
284: program_update_date = sysdate

Line 281: request_id = hz_utility_pub.request_id,

277: set object_version_number = nvl(object_version_number,0) + 1, partner_address_id = p_to_fk_id,
278: last_update_date = hz_utility_pub.last_update_date,
279: last_updated_by = hz_utility_pub.user_id,
280: last_update_login = hz_utility_pub.last_update_login,
281: request_id = hz_utility_pub.request_id,
282: program_application_id = hz_utility_pub.program_application_id,
283: program_id = hz_utility_pub.program_id,
284: program_update_date = sysdate
285: where partner_address_id = p_from_fk_id;

Line 282: program_application_id = hz_utility_pub.program_application_id,

278: last_update_date = hz_utility_pub.last_update_date,
279: last_updated_by = hz_utility_pub.user_id,
280: last_update_login = hz_utility_pub.last_update_login,
281: request_id = hz_utility_pub.request_id,
282: program_application_id = hz_utility_pub.program_application_id,
283: program_id = hz_utility_pub.program_id,
284: program_update_date = sysdate
285: where partner_address_id = p_from_fk_id;
286:

Line 283: program_id = hz_utility_pub.program_id,

279: last_updated_by = hz_utility_pub.user_id,
280: last_update_login = hz_utility_pub.last_update_login,
281: request_id = hz_utility_pub.request_id,
282: program_application_id = hz_utility_pub.program_application_id,
283: program_id = hz_utility_pub.program_id,
284: program_update_date = sysdate
285: where partner_address_id = p_from_fk_id;
286:
287: l_col_name := 'AS_SALES_CREDITS_DENORM.partner_address_id';

Line 291: last_update_date = hz_utility_pub.last_update_date,

287: l_col_name := 'AS_SALES_CREDITS_DENORM.partner_address_id';
288:
289: UPDATE AS_SALES_CREDITS_DENORM
290: set object_version_number = nvl(object_version_number,0) + 1, partner_address_id = p_to_fk_id,
291: last_update_date = hz_utility_pub.last_update_date,
292: last_updated_by = hz_utility_pub.user_id,
293: last_update_login = hz_utility_pub.last_update_login,
294: request_id = hz_utility_pub.request_id,
295: program_application_id = hz_utility_pub.program_application_id,

Line 292: last_updated_by = hz_utility_pub.user_id,

288:
289: UPDATE AS_SALES_CREDITS_DENORM
290: set object_version_number = nvl(object_version_number,0) + 1, partner_address_id = p_to_fk_id,
291: last_update_date = hz_utility_pub.last_update_date,
292: last_updated_by = hz_utility_pub.user_id,
293: last_update_login = hz_utility_pub.last_update_login,
294: request_id = hz_utility_pub.request_id,
295: program_application_id = hz_utility_pub.program_application_id,
296: program_id = hz_utility_pub.program_id,

Line 293: last_update_login = hz_utility_pub.last_update_login,

289: UPDATE AS_SALES_CREDITS_DENORM
290: set object_version_number = nvl(object_version_number,0) + 1, partner_address_id = p_to_fk_id,
291: last_update_date = hz_utility_pub.last_update_date,
292: last_updated_by = hz_utility_pub.user_id,
293: last_update_login = hz_utility_pub.last_update_login,
294: request_id = hz_utility_pub.request_id,
295: program_application_id = hz_utility_pub.program_application_id,
296: program_id = hz_utility_pub.program_id,
297: program_update_date = sysdate

Line 294: request_id = hz_utility_pub.request_id,

290: set object_version_number = nvl(object_version_number,0) + 1, partner_address_id = p_to_fk_id,
291: last_update_date = hz_utility_pub.last_update_date,
292: last_updated_by = hz_utility_pub.user_id,
293: last_update_login = hz_utility_pub.last_update_login,
294: request_id = hz_utility_pub.request_id,
295: program_application_id = hz_utility_pub.program_application_id,
296: program_id = hz_utility_pub.program_id,
297: program_update_date = sysdate
298: where partner_address_id = p_from_fk_id;

Line 295: program_application_id = hz_utility_pub.program_application_id,

291: last_update_date = hz_utility_pub.last_update_date,
292: last_updated_by = hz_utility_pub.user_id,
293: last_update_login = hz_utility_pub.last_update_login,
294: request_id = hz_utility_pub.request_id,
295: program_application_id = hz_utility_pub.program_application_id,
296: program_id = hz_utility_pub.program_id,
297: program_update_date = sysdate
298: where partner_address_id = p_from_fk_id;
299:

Line 296: program_id = hz_utility_pub.program_id,

292: last_updated_by = hz_utility_pub.user_id,
293: last_update_login = hz_utility_pub.last_update_login,
294: request_id = hz_utility_pub.request_id,
295: program_application_id = hz_utility_pub.program_application_id,
296: program_id = hz_utility_pub.program_id,
297: program_update_date = sysdate
298: where partner_address_id = p_from_fk_id;
299:
300: l_col_name := 'AS_SALES_CREDITS_DENORM.address_id';

Line 304: last_update_date = hz_utility_pub.last_update_date,

300: l_col_name := 'AS_SALES_CREDITS_DENORM.address_id';
301:
302: UPDATE AS_SALES_CREDITS_DENORM
303: set object_version_number = nvl(object_version_number,0) + 1, address_id = p_to_fk_id,
304: last_update_date = hz_utility_pub.last_update_date,
305: last_updated_by = hz_utility_pub.user_id,
306: last_update_login = hz_utility_pub.last_update_login,
307: request_id = hz_utility_pub.request_id,
308: program_application_id = hz_utility_pub.program_application_id,

Line 305: last_updated_by = hz_utility_pub.user_id,

301:
302: UPDATE AS_SALES_CREDITS_DENORM
303: set object_version_number = nvl(object_version_number,0) + 1, address_id = p_to_fk_id,
304: last_update_date = hz_utility_pub.last_update_date,
305: last_updated_by = hz_utility_pub.user_id,
306: last_update_login = hz_utility_pub.last_update_login,
307: request_id = hz_utility_pub.request_id,
308: program_application_id = hz_utility_pub.program_application_id,
309: program_id = hz_utility_pub.program_id,

Line 306: last_update_login = hz_utility_pub.last_update_login,

302: UPDATE AS_SALES_CREDITS_DENORM
303: set object_version_number = nvl(object_version_number,0) + 1, address_id = p_to_fk_id,
304: last_update_date = hz_utility_pub.last_update_date,
305: last_updated_by = hz_utility_pub.user_id,
306: last_update_login = hz_utility_pub.last_update_login,
307: request_id = hz_utility_pub.request_id,
308: program_application_id = hz_utility_pub.program_application_id,
309: program_id = hz_utility_pub.program_id,
310: program_update_date = sysdate

Line 307: request_id = hz_utility_pub.request_id,

303: set object_version_number = nvl(object_version_number,0) + 1, address_id = p_to_fk_id,
304: last_update_date = hz_utility_pub.last_update_date,
305: last_updated_by = hz_utility_pub.user_id,
306: last_update_login = hz_utility_pub.last_update_login,
307: request_id = hz_utility_pub.request_id,
308: program_application_id = hz_utility_pub.program_application_id,
309: program_id = hz_utility_pub.program_id,
310: program_update_date = sysdate
311: where address_id = p_from_fk_id;

Line 308: program_application_id = hz_utility_pub.program_application_id,

304: last_update_date = hz_utility_pub.last_update_date,
305: last_updated_by = hz_utility_pub.user_id,
306: last_update_login = hz_utility_pub.last_update_login,
307: request_id = hz_utility_pub.request_id,
308: program_application_id = hz_utility_pub.program_application_id,
309: program_id = hz_utility_pub.program_id,
310: program_update_date = sysdate
311: where address_id = p_from_fk_id;
312:

Line 309: program_id = hz_utility_pub.program_id,

305: last_updated_by = hz_utility_pub.user_id,
306: last_update_login = hz_utility_pub.last_update_login,
307: request_id = hz_utility_pub.request_id,
308: program_application_id = hz_utility_pub.program_application_id,
309: program_id = hz_utility_pub.program_id,
310: program_update_date = sysdate
311: where address_id = p_from_fk_id;
312:
313: -- add AS_LEADS_LOG.address_id

Line 319: --last_update_date = hz_utility_pub.last_update_date,

315: l_col_name := 'AS_LEADS_LOG.address_id';
316:
317: UPDATE AS_LEADS_LOG
318: set object_version_number = nvl(object_version_number,0) + 1, address_id = p_to_fk_id
319: --last_update_date = hz_utility_pub.last_update_date,
320: --last_updated_by = hz_utility_pub.user_id,
321: --last_update_login = hz_utility_pub.last_update_login,
322: --request_id = hz_utility_pub.request_id,
323: --program_application_id = hz_utility_pub.program_application_id,

Line 320: --last_updated_by = hz_utility_pub.user_id,

316:
317: UPDATE AS_LEADS_LOG
318: set object_version_number = nvl(object_version_number,0) + 1, address_id = p_to_fk_id
319: --last_update_date = hz_utility_pub.last_update_date,
320: --last_updated_by = hz_utility_pub.user_id,
321: --last_update_login = hz_utility_pub.last_update_login,
322: --request_id = hz_utility_pub.request_id,
323: --program_application_id = hz_utility_pub.program_application_id,
324: --program_id = hz_utility_pub.program_id,

Line 321: --last_update_login = hz_utility_pub.last_update_login,

317: UPDATE AS_LEADS_LOG
318: set object_version_number = nvl(object_version_number,0) + 1, address_id = p_to_fk_id
319: --last_update_date = hz_utility_pub.last_update_date,
320: --last_updated_by = hz_utility_pub.user_id,
321: --last_update_login = hz_utility_pub.last_update_login,
322: --request_id = hz_utility_pub.request_id,
323: --program_application_id = hz_utility_pub.program_application_id,
324: --program_id = hz_utility_pub.program_id,
325: --program_update_date = sysdate

Line 322: --request_id = hz_utility_pub.request_id,

318: set object_version_number = nvl(object_version_number,0) + 1, address_id = p_to_fk_id
319: --last_update_date = hz_utility_pub.last_update_date,
320: --last_updated_by = hz_utility_pub.user_id,
321: --last_update_login = hz_utility_pub.last_update_login,
322: --request_id = hz_utility_pub.request_id,
323: --program_application_id = hz_utility_pub.program_application_id,
324: --program_id = hz_utility_pub.program_id,
325: --program_update_date = sysdate
326: where address_id = p_from_fk_id;

Line 323: --program_application_id = hz_utility_pub.program_application_id,

319: --last_update_date = hz_utility_pub.last_update_date,
320: --last_updated_by = hz_utility_pub.user_id,
321: --last_update_login = hz_utility_pub.last_update_login,
322: --request_id = hz_utility_pub.request_id,
323: --program_application_id = hz_utility_pub.program_application_id,
324: --program_id = hz_utility_pub.program_id,
325: --program_update_date = sysdate
326: where address_id = p_from_fk_id;
327:

Line 324: --program_id = hz_utility_pub.program_id,

320: --last_updated_by = hz_utility_pub.user_id,
321: --last_update_login = hz_utility_pub.last_update_login,
322: --request_id = hz_utility_pub.request_id,
323: --program_application_id = hz_utility_pub.program_application_id,
324: --program_id = hz_utility_pub.program_id,
325: --program_update_date = sysdate
326: where address_id = p_from_fk_id;
327:
328: ELSIF p_parent_entity_name = 'HZ_ORG_CONTACTS' THEN

Line 335: last_update_date = hz_utility_pub.last_update_date,

331: l_col_name := 'AS_LEAD_CONTACTS_ALL.contact_id';
332:
333: UPDATE AS_LEAD_CONTACTS_ALL
334: set object_version_number = nvl(object_version_number,0) + 1, contact_id = p_to_fk_id,
335: last_update_date = hz_utility_pub.last_update_date,
336: last_updated_by = hz_utility_pub.user_id,
337: last_update_login = hz_utility_pub.last_update_login,
338: request_id = hz_utility_pub.request_id,
339: program_application_id = hz_utility_pub.program_application_id,

Line 336: last_updated_by = hz_utility_pub.user_id,

332:
333: UPDATE AS_LEAD_CONTACTS_ALL
334: set object_version_number = nvl(object_version_number,0) + 1, contact_id = p_to_fk_id,
335: last_update_date = hz_utility_pub.last_update_date,
336: last_updated_by = hz_utility_pub.user_id,
337: last_update_login = hz_utility_pub.last_update_login,
338: request_id = hz_utility_pub.request_id,
339: program_application_id = hz_utility_pub.program_application_id,
340: program_id = hz_utility_pub.program_id,

Line 337: last_update_login = hz_utility_pub.last_update_login,

333: UPDATE AS_LEAD_CONTACTS_ALL
334: set object_version_number = nvl(object_version_number,0) + 1, contact_id = p_to_fk_id,
335: last_update_date = hz_utility_pub.last_update_date,
336: last_updated_by = hz_utility_pub.user_id,
337: last_update_login = hz_utility_pub.last_update_login,
338: request_id = hz_utility_pub.request_id,
339: program_application_id = hz_utility_pub.program_application_id,
340: program_id = hz_utility_pub.program_id,
341: program_update_date = sysdate

Line 338: request_id = hz_utility_pub.request_id,

334: set object_version_number = nvl(object_version_number,0) + 1, contact_id = p_to_fk_id,
335: last_update_date = hz_utility_pub.last_update_date,
336: last_updated_by = hz_utility_pub.user_id,
337: last_update_login = hz_utility_pub.last_update_login,
338: request_id = hz_utility_pub.request_id,
339: program_application_id = hz_utility_pub.program_application_id,
340: program_id = hz_utility_pub.program_id,
341: program_update_date = sysdate
342: where contact_id = p_from_fk_id;

Line 339: program_application_id = hz_utility_pub.program_application_id,

335: last_update_date = hz_utility_pub.last_update_date,
336: last_updated_by = hz_utility_pub.user_id,
337: last_update_login = hz_utility_pub.last_update_login,
338: request_id = hz_utility_pub.request_id,
339: program_application_id = hz_utility_pub.program_application_id,
340: program_id = hz_utility_pub.program_id,
341: program_update_date = sysdate
342: where contact_id = p_from_fk_id;
343:

Line 340: program_id = hz_utility_pub.program_id,

336: last_updated_by = hz_utility_pub.user_id,
337: last_update_login = hz_utility_pub.last_update_login,
338: request_id = hz_utility_pub.request_id,
339: program_application_id = hz_utility_pub.program_application_id,
340: program_id = hz_utility_pub.program_id,
341: program_update_date = sysdate
342: where contact_id = p_from_fk_id;
343:
344: ELSIF p_parent_entity_name = 'HZ_CONTACT_POINTS' THEN

Line 350: last_update_date = hz_utility_pub.last_update_date,

346: l_col_name := 'AS_LEAD_CONTACTS_ALL.phone_id';
347:
348: UPDATE AS_LEAD_CONTACTS_ALL
349: set object_version_number = nvl(object_version_number,0) + 1, phone_id = p_to_fk_id,
350: last_update_date = hz_utility_pub.last_update_date,
351: last_updated_by = hz_utility_pub.user_id,
352: last_update_login = hz_utility_pub.last_update_login,
353: request_id = hz_utility_pub.request_id,
354: program_application_id = hz_utility_pub.program_application_id,

Line 351: last_updated_by = hz_utility_pub.user_id,

347:
348: UPDATE AS_LEAD_CONTACTS_ALL
349: set object_version_number = nvl(object_version_number,0) + 1, phone_id = p_to_fk_id,
350: last_update_date = hz_utility_pub.last_update_date,
351: last_updated_by = hz_utility_pub.user_id,
352: last_update_login = hz_utility_pub.last_update_login,
353: request_id = hz_utility_pub.request_id,
354: program_application_id = hz_utility_pub.program_application_id,
355: program_id = hz_utility_pub.program_id,

Line 352: last_update_login = hz_utility_pub.last_update_login,

348: UPDATE AS_LEAD_CONTACTS_ALL
349: set object_version_number = nvl(object_version_number,0) + 1, phone_id = p_to_fk_id,
350: last_update_date = hz_utility_pub.last_update_date,
351: last_updated_by = hz_utility_pub.user_id,
352: last_update_login = hz_utility_pub.last_update_login,
353: request_id = hz_utility_pub.request_id,
354: program_application_id = hz_utility_pub.program_application_id,
355: program_id = hz_utility_pub.program_id,
356: program_update_date = sysdate

Line 353: request_id = hz_utility_pub.request_id,

349: set object_version_number = nvl(object_version_number,0) + 1, phone_id = p_to_fk_id,
350: last_update_date = hz_utility_pub.last_update_date,
351: last_updated_by = hz_utility_pub.user_id,
352: last_update_login = hz_utility_pub.last_update_login,
353: request_id = hz_utility_pub.request_id,
354: program_application_id = hz_utility_pub.program_application_id,
355: program_id = hz_utility_pub.program_id,
356: program_update_date = sysdate
357: where phone_id = p_from_fk_id;

Line 354: program_application_id = hz_utility_pub.program_application_id,

350: last_update_date = hz_utility_pub.last_update_date,
351: last_updated_by = hz_utility_pub.user_id,
352: last_update_login = hz_utility_pub.last_update_login,
353: request_id = hz_utility_pub.request_id,
354: program_application_id = hz_utility_pub.program_application_id,
355: program_id = hz_utility_pub.program_id,
356: program_update_date = sysdate
357: where phone_id = p_from_fk_id;
358:

Line 355: program_id = hz_utility_pub.program_id,

351: last_updated_by = hz_utility_pub.user_id,
352: last_update_login = hz_utility_pub.last_update_login,
353: request_id = hz_utility_pub.request_id,
354: program_application_id = hz_utility_pub.program_application_id,
355: program_id = hz_utility_pub.program_id,
356: program_update_date = sysdate
357: where phone_id = p_from_fk_id;
358:
359: