155: var_agmt_agreement_id,
156: var_agmt_agreement_num,
157: final_agreement_num,
158: 'U',
159: hz_utility_pub.CREATED_BY,
160: hz_utility_pub.CREATION_DATE,
161: hz_utility_pub.LAST_UPDATE_LOGIN,
162: hz_utility_pub.LAST_UPDATE_DATE,
163: hz_utility_pub.LAST_UPDATED_BY);
156: var_agmt_agreement_num,
157: final_agreement_num,
158: 'U',
159: hz_utility_pub.CREATED_BY,
160: hz_utility_pub.CREATION_DATE,
161: hz_utility_pub.LAST_UPDATE_LOGIN,
162: hz_utility_pub.LAST_UPDATE_DATE,
163: hz_utility_pub.LAST_UPDATED_BY);
164: END IF;
157: final_agreement_num,
158: 'U',
159: hz_utility_pub.CREATED_BY,
160: hz_utility_pub.CREATION_DATE,
161: hz_utility_pub.LAST_UPDATE_LOGIN,
162: hz_utility_pub.LAST_UPDATE_DATE,
163: hz_utility_pub.LAST_UPDATED_BY);
164: END IF;
165: /* End of TCA Audit */
158: 'U',
159: hz_utility_pub.CREATED_BY,
160: hz_utility_pub.CREATION_DATE,
161: hz_utility_pub.LAST_UPDATE_LOGIN,
162: hz_utility_pub.LAST_UPDATE_DATE,
163: hz_utility_pub.LAST_UPDATED_BY);
164: END IF;
165: /* End of TCA Audit */
166:
159: hz_utility_pub.CREATED_BY,
160: hz_utility_pub.CREATION_DATE,
161: hz_utility_pub.LAST_UPDATE_LOGIN,
162: hz_utility_pub.LAST_UPDATE_DATE,
163: hz_utility_pub.LAST_UPDATED_BY);
164: END IF;
165: /* End of TCA Audit */
166:
167: UPDATE PA_AGREEMENTS PA -- bug 3891382.
308: var_agmt_agreement_id,
309: var_agmt_customer_id,
310: var_racm_customer_id,
311: 'U',
312: hz_utility_pub.CREATED_BY,
313: hz_utility_pub.CREATION_DATE,
314: hz_utility_pub.LAST_UPDATE_LOGIN,
315: hz_utility_pub.LAST_UPDATE_DATE,
316: hz_utility_pub.LAST_UPDATED_BY);
309: var_agmt_customer_id,
310: var_racm_customer_id,
311: 'U',
312: hz_utility_pub.CREATED_BY,
313: hz_utility_pub.CREATION_DATE,
314: hz_utility_pub.LAST_UPDATE_LOGIN,
315: hz_utility_pub.LAST_UPDATE_DATE,
316: hz_utility_pub.LAST_UPDATED_BY);
317: END IF;
310: var_racm_customer_id,
311: 'U',
312: hz_utility_pub.CREATED_BY,
313: hz_utility_pub.CREATION_DATE,
314: hz_utility_pub.LAST_UPDATE_LOGIN,
315: hz_utility_pub.LAST_UPDATE_DATE,
316: hz_utility_pub.LAST_UPDATED_BY);
317: END IF;
318:
311: 'U',
312: hz_utility_pub.CREATED_BY,
313: hz_utility_pub.CREATION_DATE,
314: hz_utility_pub.LAST_UPDATE_LOGIN,
315: hz_utility_pub.LAST_UPDATE_DATE,
316: hz_utility_pub.LAST_UPDATED_BY);
317: END IF;
318:
319: /*End of TCA audit*/
312: hz_utility_pub.CREATED_BY,
313: hz_utility_pub.CREATION_DATE,
314: hz_utility_pub.LAST_UPDATE_LOGIN,
315: hz_utility_pub.LAST_UPDATE_DATE,
316: hz_utility_pub.LAST_UPDATED_BY);
317: END IF;
318:
319: /*End of TCA audit*/
320: