DBA Data[Home] [Help]

APPS.HZ_MERGE_PARTIES_PUB dependencies on HZ_UTILITY_PUB

Line 124: p_CREATED_BY => HZ_UTILITY_PUB.CREATED_BY,

120: p_from_party_id => p_from_party_id,
121: p_to_party_id => p_to_party_id,
122: p_merge_reason_code => p_MERGE_REASON_CODE,
123: p_merge_status => 'PENDING',
124: p_CREATED_BY => HZ_UTILITY_PUB.CREATED_BY,
125: p_CREATION_DATE => HZ_UTILITY_PUB.CREATION_DATE,
126: p_LAST_UPDATE_LOGIN => HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
127: p_LAST_UPDATE_DATE => HZ_UTILITY_PUB.LAST_UPDATE_DATE,
128: p_LAST_UPDATED_BY => HZ_UTILITY_PUB.LAST_UPDATED_BY);

Line 125: p_CREATION_DATE => HZ_UTILITY_PUB.CREATION_DATE,

121: p_to_party_id => p_to_party_id,
122: p_merge_reason_code => p_MERGE_REASON_CODE,
123: p_merge_status => 'PENDING',
124: p_CREATED_BY => HZ_UTILITY_PUB.CREATED_BY,
125: p_CREATION_DATE => HZ_UTILITY_PUB.CREATION_DATE,
126: p_LAST_UPDATE_LOGIN => HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
127: p_LAST_UPDATE_DATE => HZ_UTILITY_PUB.LAST_UPDATE_DATE,
128: p_LAST_UPDATED_BY => HZ_UTILITY_PUB.LAST_UPDATED_BY);
129:

Line 126: p_LAST_UPDATE_LOGIN => HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,

122: p_merge_reason_code => p_MERGE_REASON_CODE,
123: p_merge_status => 'PENDING',
124: p_CREATED_BY => HZ_UTILITY_PUB.CREATED_BY,
125: p_CREATION_DATE => HZ_UTILITY_PUB.CREATION_DATE,
126: p_LAST_UPDATE_LOGIN => HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
127: p_LAST_UPDATE_DATE => HZ_UTILITY_PUB.LAST_UPDATE_DATE,
128: p_LAST_UPDATED_BY => HZ_UTILITY_PUB.LAST_UPDATED_BY);
129:
130: END do_create_merge_party;

Line 127: p_LAST_UPDATE_DATE => HZ_UTILITY_PUB.LAST_UPDATE_DATE,

123: p_merge_status => 'PENDING',
124: p_CREATED_BY => HZ_UTILITY_PUB.CREATED_BY,
125: p_CREATION_DATE => HZ_UTILITY_PUB.CREATION_DATE,
126: p_LAST_UPDATE_LOGIN => HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
127: p_LAST_UPDATE_DATE => HZ_UTILITY_PUB.LAST_UPDATE_DATE,
128: p_LAST_UPDATED_BY => HZ_UTILITY_PUB.LAST_UPDATED_BY);
129:
130: END do_create_merge_party;
131:

Line 128: p_LAST_UPDATED_BY => HZ_UTILITY_PUB.LAST_UPDATED_BY);

124: p_CREATED_BY => HZ_UTILITY_PUB.CREATED_BY,
125: p_CREATION_DATE => HZ_UTILITY_PUB.CREATION_DATE,
126: p_LAST_UPDATE_LOGIN => HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
127: p_LAST_UPDATE_DATE => HZ_UTILITY_PUB.LAST_UPDATE_DATE,
128: p_LAST_UPDATED_BY => HZ_UTILITY_PUB.LAST_UPDATED_BY);
129:
130: END do_create_merge_party;
131:
132:

Line 142: HZ_UTILITY_PUB.CREATED_BY,

138: hz_merge_util.insert_party_site_details(
139: cp_from_party_id,
140: cp_to_party_id,
141: cp_batch_party_id,
142: HZ_UTILITY_PUB.CREATED_BY,
143: HZ_UTILITY_PUB.CREATION_DATE,
144: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
145: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
146: HZ_UTILITY_PUB.LAST_UPDATED_BY);

Line 143: HZ_UTILITY_PUB.CREATION_DATE,

139: cp_from_party_id,
140: cp_to_party_id,
141: cp_batch_party_id,
142: HZ_UTILITY_PUB.CREATED_BY,
143: HZ_UTILITY_PUB.CREATION_DATE,
144: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
145: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
146: HZ_UTILITY_PUB.LAST_UPDATED_BY);
147:

Line 144: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,

140: cp_to_party_id,
141: cp_batch_party_id,
142: HZ_UTILITY_PUB.CREATED_BY,
143: HZ_UTILITY_PUB.CREATION_DATE,
144: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
145: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
146: HZ_UTILITY_PUB.LAST_UPDATED_BY);
147:
148: -----Insert Party Relations details

Line 145: HZ_UTILITY_PUB.LAST_UPDATE_DATE,

141: cp_batch_party_id,
142: HZ_UTILITY_PUB.CREATED_BY,
143: HZ_UTILITY_PUB.CREATION_DATE,
144: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
145: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
146: HZ_UTILITY_PUB.LAST_UPDATED_BY);
147:
148: -----Insert Party Relations details
149: hz_merge_util.insert_party_reln_details(

Line 146: HZ_UTILITY_PUB.LAST_UPDATED_BY);

142: HZ_UTILITY_PUB.CREATED_BY,
143: HZ_UTILITY_PUB.CREATION_DATE,
144: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
145: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
146: HZ_UTILITY_PUB.LAST_UPDATED_BY);
147:
148: -----Insert Party Relations details
149: hz_merge_util.insert_party_reln_details(
150: cp_from_party_id,

Line 153: HZ_UTILITY_PUB.CREATED_BY,

149: hz_merge_util.insert_party_reln_details(
150: cp_from_party_id,
151: cp_to_party_id,
152: cp_batch_party_id,
153: HZ_UTILITY_PUB.CREATED_BY,
154: HZ_UTILITY_PUB.CREATION_DATE,
155: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
156: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
157: HZ_UTILITY_PUB.LAST_UPDATED_BY);

Line 154: HZ_UTILITY_PUB.CREATION_DATE,

150: cp_from_party_id,
151: cp_to_party_id,
152: cp_batch_party_id,
153: HZ_UTILITY_PUB.CREATED_BY,
154: HZ_UTILITY_PUB.CREATION_DATE,
155: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
156: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
157: HZ_UTILITY_PUB.LAST_UPDATED_BY);
158:

Line 155: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,

151: cp_to_party_id,
152: cp_batch_party_id,
153: HZ_UTILITY_PUB.CREATED_BY,
154: HZ_UTILITY_PUB.CREATION_DATE,
155: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
156: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
157: HZ_UTILITY_PUB.LAST_UPDATED_BY);
158:
159: END insert_party_details;

Line 156: HZ_UTILITY_PUB.LAST_UPDATE_DATE,

152: cp_batch_party_id,
153: HZ_UTILITY_PUB.CREATED_BY,
154: HZ_UTILITY_PUB.CREATION_DATE,
155: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
156: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
157: HZ_UTILITY_PUB.LAST_UPDATED_BY);
158:
159: END insert_party_details;
160:

Line 157: HZ_UTILITY_PUB.LAST_UPDATED_BY);

153: HZ_UTILITY_PUB.CREATED_BY,
154: HZ_UTILITY_PUB.CREATION_DATE,
155: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
156: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
157: HZ_UTILITY_PUB.LAST_UPDATED_BY);
158:
159: END insert_party_details;
160:
161:

Line 213: HZ_UTILITY_PUB.CREATED_BY,

209: l_from_reln_party_id,
210: l_to_reln_party_id,
211: 'DUPLICATE_RELN_PARTY',
212: 'PENDING',
213: HZ_UTILITY_PUB.CREATED_BY,
214: HZ_UTILITY_PUB.CREATION_DATE,
215: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
216: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
217: HZ_UTILITY_PUB.LAST_UPDATED_BY);

Line 214: HZ_UTILITY_PUB.CREATION_DATE,

210: l_to_reln_party_id,
211: 'DUPLICATE_RELN_PARTY',
212: 'PENDING',
213: HZ_UTILITY_PUB.CREATED_BY,
214: HZ_UTILITY_PUB.CREATION_DATE,
215: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
216: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
217: HZ_UTILITY_PUB.LAST_UPDATED_BY);
218:

Line 215: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,

211: 'DUPLICATE_RELN_PARTY',
212: 'PENDING',
213: HZ_UTILITY_PUB.CREATED_BY,
214: HZ_UTILITY_PUB.CREATION_DATE,
215: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
216: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
217: HZ_UTILITY_PUB.LAST_UPDATED_BY);
218:
219: num := num+1;

Line 216: HZ_UTILITY_PUB.LAST_UPDATE_DATE,

212: 'PENDING',
213: HZ_UTILITY_PUB.CREATED_BY,
214: HZ_UTILITY_PUB.CREATION_DATE,
215: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
216: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
217: HZ_UTILITY_PUB.LAST_UPDATED_BY);
218:
219: num := num+1;
220: END IF;

Line 217: HZ_UTILITY_PUB.LAST_UPDATED_BY);

213: HZ_UTILITY_PUB.CREATED_BY,
214: HZ_UTILITY_PUB.CREATION_DATE,
215: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
216: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
217: HZ_UTILITY_PUB.LAST_UPDATED_BY);
218:
219: num := num+1;
220: END IF;
221: END LOOP;