232: -- Initialize object version number to 1
233: l_setup_data_rec.OBJECT_VERSION_NUMBER := 1;
234:
235: -- Intialize who column info
236: l_setup_data_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
237: l_setup_data_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
238: l_setup_data_rec.CREATED_BY := fnd_global.user_id;
239: l_setup_data_rec.CREATION_DATE := sysdate;
240: l_setup_data_rec.LAST_UPDATE_DATE := sysdate;
233: l_setup_data_rec.OBJECT_VERSION_NUMBER := 1;
234:
235: -- Intialize who column info
236: l_setup_data_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
237: l_setup_data_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
238: l_setup_data_rec.CREATED_BY := fnd_global.user_id;
239: l_setup_data_rec.CREATION_DATE := sysdate;
240: l_setup_data_rec.LAST_UPDATE_DATE := sysdate;
241:
234:
235: -- Intialize who column info
236: l_setup_data_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
237: l_setup_data_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
238: l_setup_data_rec.CREATED_BY := fnd_global.user_id;
239: l_setup_data_rec.CREATION_DATE := sysdate;
240: l_setup_data_rec.LAST_UPDATE_DATE := sysdate;
241:
242: -- Initialize security group id
730: -- Initialize object version number to 1
731: l_ra_def_hdr_rec.OBJECT_VERSION_NUMBER := 1;
732:
733: -- Intialize who column info
734: l_ra_def_hdr_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
735: l_ra_def_hdr_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
736: l_ra_def_hdr_rec.CREATED_BY := fnd_global.user_id;
737: l_ra_def_hdr_rec.CREATION_DATE := sysdate;
738: l_ra_def_hdr_rec.LAST_UPDATE_DATE := sysdate;
731: l_ra_def_hdr_rec.OBJECT_VERSION_NUMBER := 1;
732:
733: -- Intialize who column info
734: l_ra_def_hdr_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
735: l_ra_def_hdr_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
736: l_ra_def_hdr_rec.CREATED_BY := fnd_global.user_id;
737: l_ra_def_hdr_rec.CREATION_DATE := sysdate;
738: l_ra_def_hdr_rec.LAST_UPDATE_DATE := sysdate;
739:
732:
733: -- Intialize who column info
734: l_ra_def_hdr_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
735: l_ra_def_hdr_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
736: l_ra_def_hdr_rec.CREATED_BY := fnd_global.user_id;
737: l_ra_def_hdr_rec.CREATION_DATE := sysdate;
738: l_ra_def_hdr_rec.LAST_UPDATE_DATE := sysdate;
739:
740: -- Initialize security group id
1299: -- Initialize object version number to 1
1300: l_ra_def_dtl_rec.OBJECT_VERSION_NUMBER := 1;
1301:
1302: -- Intialize who column info
1303: l_ra_def_dtl_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
1304: l_ra_def_dtl_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
1305: l_ra_def_dtl_rec.CREATED_BY := fnd_global.user_id;
1306: l_ra_def_dtl_rec.CREATION_DATE := sysdate;
1307: l_ra_def_dtl_rec.LAST_UPDATE_DATE := sysdate;
1300: l_ra_def_dtl_rec.OBJECT_VERSION_NUMBER := 1;
1301:
1302: -- Intialize who column info
1303: l_ra_def_dtl_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
1304: l_ra_def_dtl_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
1305: l_ra_def_dtl_rec.CREATED_BY := fnd_global.user_id;
1306: l_ra_def_dtl_rec.CREATION_DATE := sysdate;
1307: l_ra_def_dtl_rec.LAST_UPDATE_DATE := sysdate;
1308:
1301:
1302: -- Intialize who column info
1303: l_ra_def_dtl_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
1304: l_ra_def_dtl_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
1305: l_ra_def_dtl_rec.CREATED_BY := fnd_global.user_id;
1306: l_ra_def_dtl_rec.CREATION_DATE := sysdate;
1307: l_ra_def_dtl_rec.LAST_UPDATE_DATE := sysdate;
1308:
1309: -- Initialize security group id
1712: -- Increment object version number
1713: l_ra_def_dtl_rec.OBJECT_VERSION_NUMBER := l_ra_def_dtl_rec.OBJECT_VERSION_NUMBER + 1;
1714:
1715: -- Intialize who column info
1716: l_ra_def_dtl_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
1717: l_ra_def_dtl_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
1718: l_ra_def_dtl_rec.LAST_UPDATE_DATE := sysdate;
1719: l_ra_def_dtl_rec.CREATED_BY := fnd_global.user_id;
1720: l_ra_def_dtl_rec.CREATION_DATE := sysdate;
1713: l_ra_def_dtl_rec.OBJECT_VERSION_NUMBER := l_ra_def_dtl_rec.OBJECT_VERSION_NUMBER + 1;
1714:
1715: -- Intialize who column info
1716: l_ra_def_dtl_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
1717: l_ra_def_dtl_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
1718: l_ra_def_dtl_rec.LAST_UPDATE_DATE := sysdate;
1719: l_ra_def_dtl_rec.CREATED_BY := fnd_global.user_id;
1720: l_ra_def_dtl_rec.CREATION_DATE := sysdate;
1721:
1715: -- Intialize who column info
1716: l_ra_def_dtl_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
1717: l_ra_def_dtl_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
1718: l_ra_def_dtl_rec.LAST_UPDATE_DATE := sysdate;
1719: l_ra_def_dtl_rec.CREATED_BY := fnd_global.user_id;
1720: l_ra_def_dtl_rec.CREATION_DATE := sysdate;
1721:
1722: UPDATE AHL_RA_DEFINITION_DTLS
1723: SET
2347: -- Initialize object version number to 1
2348: l_counter_assoc_rec.OBJECT_VERSION_NUMBER := 1;
2349:
2350: -- Intialize who column info
2351: l_counter_assoc_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
2352: l_counter_assoc_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
2353: l_counter_assoc_rec.CREATED_BY := fnd_global.user_id;
2354: l_counter_assoc_rec.CREATION_DATE := sysdate;
2355: l_counter_assoc_rec.LAST_UPDATE_DATE := sysdate;
2348: l_counter_assoc_rec.OBJECT_VERSION_NUMBER := 1;
2349:
2350: -- Intialize who column info
2351: l_counter_assoc_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
2352: l_counter_assoc_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
2353: l_counter_assoc_rec.CREATED_BY := fnd_global.user_id;
2354: l_counter_assoc_rec.CREATION_DATE := sysdate;
2355: l_counter_assoc_rec.LAST_UPDATE_DATE := sysdate;
2356:
2349:
2350: -- Intialize who column info
2351: l_counter_assoc_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
2352: l_counter_assoc_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
2353: l_counter_assoc_rec.CREATED_BY := fnd_global.user_id;
2354: l_counter_assoc_rec.CREATION_DATE := sysdate;
2355: l_counter_assoc_rec.LAST_UPDATE_DATE := sysdate;
2356:
2357: -- Initialize security group id
2935: -- Initialize object version number to 1
2936: l_fct_assoc_rec.OBJECT_VERSION_NUMBER := 1;
2937:
2938: -- Intialize who column info
2939: l_fct_assoc_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
2940: l_fct_assoc_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
2941: l_fct_assoc_rec.CREATED_BY := fnd_global.user_id;
2942: l_fct_assoc_rec.CREATION_DATE := sysdate;
2943: l_fct_assoc_rec.LAST_UPDATE_DATE := sysdate;
2936: l_fct_assoc_rec.OBJECT_VERSION_NUMBER := 1;
2937:
2938: -- Intialize who column info
2939: l_fct_assoc_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
2940: l_fct_assoc_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
2941: l_fct_assoc_rec.CREATED_BY := fnd_global.user_id;
2942: l_fct_assoc_rec.CREATION_DATE := sysdate;
2943: l_fct_assoc_rec.LAST_UPDATE_DATE := sysdate;
2944:
2937:
2938: -- Intialize who column info
2939: l_fct_assoc_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
2940: l_fct_assoc_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
2941: l_fct_assoc_rec.CREATED_BY := fnd_global.user_id;
2942: l_fct_assoc_rec.CREATION_DATE := sysdate;
2943: l_fct_assoc_rec.LAST_UPDATE_DATE := sysdate;
2944:
2945: -- Initialize security group id
3418: -- Increment object version number
3419: l_fct_assoc_rec.OBJECT_VERSION_NUMBER := l_fct_assoc_rec.OBJECT_VERSION_NUMBER + 1;
3420:
3421: -- Intialize who column info
3422: l_fct_assoc_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
3423: l_fct_assoc_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
3424: l_fct_assoc_rec.LAST_UPDATE_DATE := sysdate;
3425: l_fct_assoc_rec.CREATED_BY := fnd_global.user_id;
3426: l_fct_assoc_rec.CREATION_DATE := sysdate;
3419: l_fct_assoc_rec.OBJECT_VERSION_NUMBER := l_fct_assoc_rec.OBJECT_VERSION_NUMBER + 1;
3420:
3421: -- Intialize who column info
3422: l_fct_assoc_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
3423: l_fct_assoc_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
3424: l_fct_assoc_rec.LAST_UPDATE_DATE := sysdate;
3425: l_fct_assoc_rec.CREATED_BY := fnd_global.user_id;
3426: l_fct_assoc_rec.CREATION_DATE := sysdate;
3427:
3421: -- Intialize who column info
3422: l_fct_assoc_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
3423: l_fct_assoc_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
3424: l_fct_assoc_rec.LAST_UPDATE_DATE := sysdate;
3425: l_fct_assoc_rec.CREATED_BY := fnd_global.user_id;
3426: l_fct_assoc_rec.CREATION_DATE := sysdate;
3427:
3428: -- INSERT Forecast Associations Data in AHL_RA_FCT_ASSOCIATIONS
3429: UPDATE AHL_RA_FCT_ASSOCIATIONS