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.AHL_UC_INSTANCE_PVT dependencies on FND_GLOBAL

Line 579: last_updated_by = FND_GLOBAL.user_id,

575: SET unit_config_status_code = 'INCOMPLETE',
576: active_uc_status_code = 'UNAPPROVED',
577: object_version_number = object_version_number + 1,
578: last_update_date = SYSDATE,
579: last_updated_by = FND_GLOBAL.user_id,
580: last_update_login = FND_GLOBAL.login_id
581: WHERE unit_config_header_id = l_root_uc_header_id
582: AND object_version_number = l_root_uc_ovn;
583: IF SQL%ROWCOUNT = 0 THEN

Line 580: last_update_login = FND_GLOBAL.login_id

576: active_uc_status_code = 'UNAPPROVED',
577: object_version_number = object_version_number + 1,
578: last_update_date = SYSDATE,
579: last_updated_by = FND_GLOBAL.user_id,
580: last_update_login = FND_GLOBAL.login_id
581: WHERE unit_config_header_id = l_root_uc_header_id
582: AND object_version_number = l_root_uc_ovn;
583: IF SQL%ROWCOUNT = 0 THEN
584: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 595: last_updated_by = FND_GLOBAL.user_id,

591: UPDATE ahl_unit_config_headers
592: SET active_uc_status_code = 'UNAPPROVED',
593: object_version_number = object_version_number + 1,
594: last_update_date = SYSDATE,
595: last_updated_by = FND_GLOBAL.user_id,
596: last_update_login = FND_GLOBAL.login_id
597: WHERE unit_config_header_id = l_root_uc_header_id
598: AND object_version_number = l_root_uc_ovn;
599: IF SQL%ROWCOUNT = 0 THEN

Line 596: last_update_login = FND_GLOBAL.login_id

592: SET active_uc_status_code = 'UNAPPROVED',
593: object_version_number = object_version_number + 1,
594: last_update_date = SYSDATE,
595: last_updated_by = FND_GLOBAL.user_id,
596: last_update_login = FND_GLOBAL.login_id
597: WHERE unit_config_header_id = l_root_uc_header_id
598: AND object_version_number = l_root_uc_ovn;
599: IF SQL%ROWCOUNT = 0 THEN
600: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 609: last_updated_by = FND_GLOBAL.user_id,

605: UPDATE ahl_unit_config_headers
606: SET unit_config_status_code = 'DRAFT',
607: object_version_number = object_version_number + 1,
608: last_update_date = SYSDATE,
609: last_updated_by = FND_GLOBAL.user_id,
610: last_update_login = FND_GLOBAL.login_id
611: WHERE unit_config_header_id = l_root_uc_header_id
612: AND object_version_number = l_root_uc_ovn;
613: IF SQL%ROWCOUNT = 0 THEN

Line 610: last_update_login = FND_GLOBAL.login_id

606: SET unit_config_status_code = 'DRAFT',
607: object_version_number = object_version_number + 1,
608: last_update_date = SYSDATE,
609: last_updated_by = FND_GLOBAL.user_id,
610: last_update_login = FND_GLOBAL.login_id
611: WHERE unit_config_header_id = l_root_uc_header_id
612: AND object_version_number = l_root_uc_ovn;
613: IF SQL%ROWCOUNT = 0 THEN
614: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 625: last_updated_by = FND_GLOBAL.user_id,

621: UPDATE ahl_unit_config_headers
622: SET unit_config_status_code = 'INCOMPLETE',
623: object_version_number = object_version_number + 1,
624: last_update_date = SYSDATE,
625: last_updated_by = FND_GLOBAL.user_id,
626: last_update_login = FND_GLOBAL.login_id
627: WHERE unit_config_header_id = l_root_uc_header_id
628: AND object_version_number = l_root_uc_ovn;
629: IF SQL%ROWCOUNT = 0 THEN

Line 626: last_update_login = FND_GLOBAL.login_id

622: SET unit_config_status_code = 'INCOMPLETE',
623: object_version_number = object_version_number + 1,
624: last_update_date = SYSDATE,
625: last_updated_by = FND_GLOBAL.user_id,
626: last_update_login = FND_GLOBAL.login_id
627: WHERE unit_config_header_id = l_root_uc_header_id
628: AND object_version_number = l_root_uc_ovn;
629: IF SQL%ROWCOUNT = 0 THEN
630: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 1079: last_updated_by = FND_GLOBAL.user_id,

1075: unit_config_status_code = l_uc_status_code,
1076: active_uc_status_code = l_active_uc_status_code,
1077: object_version_number = object_version_number + 1,
1078: last_update_date = SYSDATE,
1079: last_updated_by = FND_GLOBAL.user_id,
1080: last_update_login = FND_GLOBAL.login_id
1081: WHERE unit_config_header_id = l_sub_uc_header_id;
1082: --Not necessary to check the object_version_number here
1083:

Line 1080: last_update_login = FND_GLOBAL.login_id

1076: active_uc_status_code = l_active_uc_status_code,
1077: object_version_number = object_version_number + 1,
1078: last_update_date = SYSDATE,
1079: last_updated_by = FND_GLOBAL.user_id,
1080: last_update_login = FND_GLOBAL.login_id
1081: WHERE unit_config_header_id = l_sub_uc_header_id;
1082: --Not necessary to check the object_version_number here
1083:
1084: --Copy the change to UC history table

Line 1112: last_updated_by = FND_GLOBAL.user_id,

1108: unit_config_status_code = l_uc_status_code,
1109: active_uc_status_code = l_active_uc_status_code,
1110: object_version_number = object_version_number + 1,
1111: last_update_date = SYSDATE,
1112: last_updated_by = FND_GLOBAL.user_id,
1113: last_update_login = FND_GLOBAL.login_id
1114: WHERE unit_config_header_id = l_sub_uc_header_id;
1115: --csi_item_instance_id = l_get_1st_level_subunit.subject_id
1116: --AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);

Line 1113: last_update_login = FND_GLOBAL.login_id

1109: active_uc_status_code = l_active_uc_status_code,
1110: object_version_number = object_version_number + 1,
1111: last_update_date = SYSDATE,
1112: last_updated_by = FND_GLOBAL.user_id,
1113: last_update_login = FND_GLOBAL.login_id
1114: WHERE unit_config_header_id = l_sub_uc_header_id;
1115: --csi_item_instance_id = l_get_1st_level_subunit.subject_id
1116: --AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
1117: --Not necessary to check the object_version_number here

Line 1158: last_updated_by = FND_GLOBAL.user_id,

1154: SET unit_config_status_code = 'INCOMPLETE',
1155: active_uc_status_code = 'UNAPPROVED',
1156: object_version_number = object_version_number + 1,
1157: last_update_date = SYSDATE,
1158: last_updated_by = FND_GLOBAL.user_id,
1159: last_update_login = FND_GLOBAL.login_id
1160: WHERE unit_config_header_id = l_root_uc_header_id
1161: AND object_version_number = l_root_uc_ovn;
1162: IF SQL%ROWCOUNT = 0 THEN

Line 1159: last_update_login = FND_GLOBAL.login_id

1155: active_uc_status_code = 'UNAPPROVED',
1156: object_version_number = object_version_number + 1,
1157: last_update_date = SYSDATE,
1158: last_updated_by = FND_GLOBAL.user_id,
1159: last_update_login = FND_GLOBAL.login_id
1160: WHERE unit_config_header_id = l_root_uc_header_id
1161: AND object_version_number = l_root_uc_ovn;
1162: IF SQL%ROWCOUNT = 0 THEN
1163: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 1176: last_updated_by = FND_GLOBAL.user_id,

1172: UPDATE ahl_unit_config_headers
1173: SET active_uc_status_code = 'UNAPPROVED',
1174: object_version_number = object_version_number + 1,
1175: last_update_date = SYSDATE,
1176: last_updated_by = FND_GLOBAL.user_id,
1177: last_update_login = FND_GLOBAL.login_id
1178: WHERE unit_config_header_id = l_root_uc_header_id
1179: AND object_version_number = l_root_uc_ovn;
1180: IF SQL%ROWCOUNT = 0 THEN

Line 1177: last_update_login = FND_GLOBAL.login_id

1173: SET active_uc_status_code = 'UNAPPROVED',
1174: object_version_number = object_version_number + 1,
1175: last_update_date = SYSDATE,
1176: last_updated_by = FND_GLOBAL.user_id,
1177: last_update_login = FND_GLOBAL.login_id
1178: WHERE unit_config_header_id = l_root_uc_header_id
1179: AND object_version_number = l_root_uc_ovn;
1180: IF SQL%ROWCOUNT = 0 THEN
1181: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 1192: last_updated_by = FND_GLOBAL.user_id,

1188: UPDATE ahl_unit_config_headers
1189: SET unit_config_status_code = 'DRAFT',
1190: object_version_number = object_version_number + 1,
1191: last_update_date = SYSDATE,
1192: last_updated_by = FND_GLOBAL.user_id,
1193: last_update_login = FND_GLOBAL.login_id
1194: WHERE unit_config_header_id = l_root_uc_header_id
1195: AND object_version_number = l_root_uc_ovn;
1196: IF SQL%ROWCOUNT = 0 THEN

Line 1193: last_update_login = FND_GLOBAL.login_id

1189: SET unit_config_status_code = 'DRAFT',
1190: object_version_number = object_version_number + 1,
1191: last_update_date = SYSDATE,
1192: last_updated_by = FND_GLOBAL.user_id,
1193: last_update_login = FND_GLOBAL.login_id
1194: WHERE unit_config_header_id = l_root_uc_header_id
1195: AND object_version_number = l_root_uc_ovn;
1196: IF SQL%ROWCOUNT = 0 THEN
1197: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 1208: last_updated_by = FND_GLOBAL.user_id,

1204: UPDATE ahl_unit_config_headers
1205: SET unit_config_status_code = 'INCOMPLETE',
1206: object_version_number = object_version_number + 1,
1207: last_update_date = SYSDATE,
1208: last_updated_by = FND_GLOBAL.user_id,
1209: last_update_login = FND_GLOBAL.login_id
1210: WHERE unit_config_header_id = l_root_uc_header_id
1211: AND object_version_number = l_root_uc_ovn;
1212: IF SQL%ROWCOUNT = 0 THEN

Line 1209: last_update_login = FND_GLOBAL.login_id

1205: SET unit_config_status_code = 'INCOMPLETE',
1206: object_version_number = object_version_number + 1,
1207: last_update_date = SYSDATE,
1208: last_updated_by = FND_GLOBAL.user_id,
1209: last_update_login = FND_GLOBAL.login_id
1210: WHERE unit_config_header_id = l_root_uc_header_id
1211: AND object_version_number = l_root_uc_ovn;
1212: IF SQL%ROWCOUNT = 0 THEN
1213: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 2113: last_updated_by = FND_GLOBAL.user_id,

2109: SET unit_config_status_code = 'INCOMPLETE',
2110: active_uc_status_code = 'UNAPPROVED',
2111: object_version_number = object_version_number + 1,
2112: last_update_date = SYSDATE,
2113: last_updated_by = FND_GLOBAL.user_id,
2114: last_update_login = FND_GLOBAL.login_id
2115: WHERE unit_config_header_id = l_root_uc_header_id
2116: AND object_version_number = l_root_uc_ovn;
2117: IF SQL%ROWCOUNT = 0 THEN

Line 2114: last_update_login = FND_GLOBAL.login_id

2110: active_uc_status_code = 'UNAPPROVED',
2111: object_version_number = object_version_number + 1,
2112: last_update_date = SYSDATE,
2113: last_updated_by = FND_GLOBAL.user_id,
2114: last_update_login = FND_GLOBAL.login_id
2115: WHERE unit_config_header_id = l_root_uc_header_id
2116: AND object_version_number = l_root_uc_ovn;
2117: IF SQL%ROWCOUNT = 0 THEN
2118: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 2130: last_updated_by = FND_GLOBAL.user_id,

2126: SET unit_config_status_code = 'INCOMPLETE',
2127: active_uc_status_code = 'UNAPPROVED',
2128: object_version_number = object_version_number + 1,
2129: last_update_date = SYSDATE,
2130: last_updated_by = FND_GLOBAL.user_id,
2131: last_update_login = FND_GLOBAL.login_id
2132: WHERE unit_config_header_id = l_root_uc_header_id
2133: AND object_version_number = l_root_uc_ovn;
2134: IF SQL%ROWCOUNT = 0 THEN

Line 2131: last_update_login = FND_GLOBAL.login_id

2127: active_uc_status_code = 'UNAPPROVED',
2128: object_version_number = object_version_number + 1,
2129: last_update_date = SYSDATE,
2130: last_updated_by = FND_GLOBAL.user_id,
2131: last_update_login = FND_GLOBAL.login_id
2132: WHERE unit_config_header_id = l_root_uc_header_id
2133: AND object_version_number = l_root_uc_ovn;
2134: IF SQL%ROWCOUNT = 0 THEN
2135: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 2146: last_updated_by = FND_GLOBAL.user_id,

2142: UPDATE ahl_unit_config_headers
2143: SET unit_config_status_code = 'DRAFT',
2144: object_version_number = object_version_number + 1,
2145: last_update_date = SYSDATE,
2146: last_updated_by = FND_GLOBAL.user_id,
2147: last_update_login = FND_GLOBAL.login_id
2148: WHERE unit_config_header_id = l_root_uc_header_id
2149: AND object_version_number = l_root_uc_ovn;
2150: IF SQL%ROWCOUNT = 0 THEN

Line 2147: last_update_login = FND_GLOBAL.login_id

2143: SET unit_config_status_code = 'DRAFT',
2144: object_version_number = object_version_number + 1,
2145: last_update_date = SYSDATE,
2146: last_updated_by = FND_GLOBAL.user_id,
2147: last_update_login = FND_GLOBAL.login_id
2148: WHERE unit_config_header_id = l_root_uc_header_id
2149: AND object_version_number = l_root_uc_ovn;
2150: IF SQL%ROWCOUNT = 0 THEN
2151: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 3178: last_updated_by = FND_GLOBAL.user_id,

3174: SET unit_config_status_code = 'INCOMPLETE',
3175: active_uc_status_code = 'UNAPPROVED',
3176: object_version_number = object_version_number + 1,
3177: last_update_date = SYSDATE,
3178: last_updated_by = FND_GLOBAL.user_id,
3179: last_update_login = FND_GLOBAL.login_id
3180: WHERE unit_config_header_id = l_root_uc_header_id
3181: AND object_version_number = l_root_uc_ovn;
3182: IF SQL%ROWCOUNT = 0 THEN

Line 3179: last_update_login = FND_GLOBAL.login_id

3175: active_uc_status_code = 'UNAPPROVED',
3176: object_version_number = object_version_number + 1,
3177: last_update_date = SYSDATE,
3178: last_updated_by = FND_GLOBAL.user_id,
3179: last_update_login = FND_GLOBAL.login_id
3180: WHERE unit_config_header_id = l_root_uc_header_id
3181: AND object_version_number = l_root_uc_ovn;
3182: IF SQL%ROWCOUNT = 0 THEN
3183: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 3196: last_updated_by = FND_GLOBAL.user_id,

3192: UPDATE ahl_unit_config_headers
3193: SET active_uc_status_code = 'UNAPPROVED',
3194: object_version_number = object_version_number + 1,
3195: last_update_date = SYSDATE,
3196: last_updated_by = FND_GLOBAL.user_id,
3197: last_update_login = FND_GLOBAL.login_id
3198: WHERE unit_config_header_id = l_root_uc_header_id
3199: AND object_version_number = l_root_uc_ovn;
3200: IF SQL%ROWCOUNT = 0 THEN

Line 3197: last_update_login = FND_GLOBAL.login_id

3193: SET active_uc_status_code = 'UNAPPROVED',
3194: object_version_number = object_version_number + 1,
3195: last_update_date = SYSDATE,
3196: last_updated_by = FND_GLOBAL.user_id,
3197: last_update_login = FND_GLOBAL.login_id
3198: WHERE unit_config_header_id = l_root_uc_header_id
3199: AND object_version_number = l_root_uc_ovn;
3200: IF SQL%ROWCOUNT = 0 THEN
3201: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 3218: last_updated_by = FND_GLOBAL.user_id,

3214: UPDATE ahl_unit_config_headers
3215: SET unit_config_status_code = 'DRAFT',
3216: object_version_number = object_version_number + 1,
3217: last_update_date = SYSDATE,
3218: last_updated_by = FND_GLOBAL.user_id,
3219: last_update_login = FND_GLOBAL.login_id
3220: WHERE unit_config_header_id = l_root_uc_header_id
3221: AND object_version_number = l_root_uc_ovn;
3222: IF SQL%ROWCOUNT = 0 THEN

Line 3219: last_update_login = FND_GLOBAL.login_id

3215: SET unit_config_status_code = 'DRAFT',
3216: object_version_number = object_version_number + 1,
3217: last_update_date = SYSDATE,
3218: last_updated_by = FND_GLOBAL.user_id,
3219: last_update_login = FND_GLOBAL.login_id
3220: WHERE unit_config_header_id = l_root_uc_header_id
3221: AND object_version_number = l_root_uc_ovn;
3222: IF SQL%ROWCOUNT = 0 THEN
3223: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 3235: last_updated_by = FND_GLOBAL.user_id,

3231: UPDATE ahl_unit_config_headers
3232: SET unit_config_status_code = 'INCOMPLETE',
3233: object_version_number = object_version_number + 1,
3234: last_update_date = SYSDATE,
3235: last_updated_by = FND_GLOBAL.user_id,
3236: last_update_login = FND_GLOBAL.login_id
3237: WHERE unit_config_header_id = l_root_uc_header_id
3238: AND object_version_number = l_root_uc_ovn;
3239: IF SQL%ROWCOUNT = 0 THEN

Line 3236: last_update_login = FND_GLOBAL.login_id

3232: SET unit_config_status_code = 'INCOMPLETE',
3233: object_version_number = object_version_number + 1,
3234: last_update_date = SYSDATE,
3235: last_updated_by = FND_GLOBAL.user_id,
3236: last_update_login = FND_GLOBAL.login_id
3237: WHERE unit_config_header_id = l_root_uc_header_id
3238: AND object_version_number = l_root_uc_ovn;
3239: IF SQL%ROWCOUNT = 0 THEN
3240: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 4202: last_updated_by = FND_GLOBAL.user_id,

4198: --installed instance.
4199: SET parent_uc_header_id = l_parent_uc_header_id,
4200: object_version_number = object_version_number + 1,
4201: last_update_date = SYSDATE,
4202: last_updated_by = FND_GLOBAL.user_id,
4203: last_update_login = FND_GLOBAL.login_id
4204: WHERE csi_item_instance_id = p_instance_id
4205: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
4206: --Not necessary to check the object_version_number here

Line 4203: last_update_login = FND_GLOBAL.login_id

4199: SET parent_uc_header_id = l_parent_uc_header_id,
4200: object_version_number = object_version_number + 1,
4201: last_update_date = SYSDATE,
4202: last_updated_by = FND_GLOBAL.user_id,
4203: last_update_login = FND_GLOBAL.login_id
4204: WHERE csi_item_instance_id = p_instance_id
4205: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
4206: --Not necessary to check the object_version_number here
4207: --Copy the change to history table

Line 4223: last_updated_by = FND_GLOBAL.user_id,

4219: UPDATE ahl_unit_config_headers
4220: SET parent_uc_header_id = l_parent_uc_header_id,
4221: object_version_number = object_version_number + 1,
4222: last_update_date = SYSDATE,
4223: last_updated_by = FND_GLOBAL.user_id,
4224: last_update_login = FND_GLOBAL.login_id
4225: WHERE csi_item_instance_id = l_get_1st_level_subunit.subject_id
4226: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
4227: --Not necessary to check the object_version_number here

Line 4224: last_update_login = FND_GLOBAL.login_id

4220: SET parent_uc_header_id = l_parent_uc_header_id,
4221: object_version_number = object_version_number + 1,
4222: last_update_date = SYSDATE,
4223: last_updated_by = FND_GLOBAL.user_id,
4224: last_update_login = FND_GLOBAL.login_id
4225: WHERE csi_item_instance_id = l_get_1st_level_subunit.subject_id
4226: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
4227: --Not necessary to check the object_version_number here
4228:

Line 4317: last_updated_by = FND_GLOBAL.user_id,

4313: SET unit_config_status_code = 'INCOMPLETE',
4314: active_uc_status_code = 'UNAPPROVED',
4315: object_version_number = object_version_number + 1,
4316: last_update_date = SYSDATE,
4317: last_updated_by = FND_GLOBAL.user_id,
4318: last_update_login = FND_GLOBAL.login_id
4319: WHERE unit_config_header_id = l_root_uc_header_id
4320: AND object_version_number = l_root_uc_ovn;
4321: IF SQL%ROWCOUNT = 0 THEN

Line 4318: last_update_login = FND_GLOBAL.login_id

4314: active_uc_status_code = 'UNAPPROVED',
4315: object_version_number = object_version_number + 1,
4316: last_update_date = SYSDATE,
4317: last_updated_by = FND_GLOBAL.user_id,
4318: last_update_login = FND_GLOBAL.login_id
4319: WHERE unit_config_header_id = l_root_uc_header_id
4320: AND object_version_number = l_root_uc_ovn;
4321: IF SQL%ROWCOUNT = 0 THEN
4322: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 4335: last_updated_by = FND_GLOBAL.user_id,

4331: UPDATE ahl_unit_config_headers
4332: SET active_uc_status_code = 'UNAPPROVED',
4333: object_version_number = object_version_number + 1,
4334: last_update_date = SYSDATE,
4335: last_updated_by = FND_GLOBAL.user_id,
4336: last_update_login = FND_GLOBAL.login_id
4337: WHERE unit_config_header_id = l_root_uc_header_id
4338: AND object_version_number = l_root_uc_ovn;
4339: IF SQL%ROWCOUNT = 0 THEN

Line 4336: last_update_login = FND_GLOBAL.login_id

4332: SET active_uc_status_code = 'UNAPPROVED',
4333: object_version_number = object_version_number + 1,
4334: last_update_date = SYSDATE,
4335: last_updated_by = FND_GLOBAL.user_id,
4336: last_update_login = FND_GLOBAL.login_id
4337: WHERE unit_config_header_id = l_root_uc_header_id
4338: AND object_version_number = l_root_uc_ovn;
4339: IF SQL%ROWCOUNT = 0 THEN
4340: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 4357: last_updated_by = FND_GLOBAL.user_id,

4353: UPDATE ahl_unit_config_headers
4354: SET unit_config_status_code = 'DRAFT',
4355: object_version_number = object_version_number + 1,
4356: last_update_date = SYSDATE,
4357: last_updated_by = FND_GLOBAL.user_id,
4358: last_update_login = FND_GLOBAL.login_id
4359: WHERE unit_config_header_id = l_root_uc_header_id
4360: AND object_version_number = l_root_uc_ovn;
4361: IF SQL%ROWCOUNT = 0 THEN

Line 4358: last_update_login = FND_GLOBAL.login_id

4354: SET unit_config_status_code = 'DRAFT',
4355: object_version_number = object_version_number + 1,
4356: last_update_date = SYSDATE,
4357: last_updated_by = FND_GLOBAL.user_id,
4358: last_update_login = FND_GLOBAL.login_id
4359: WHERE unit_config_header_id = l_root_uc_header_id
4360: AND object_version_number = l_root_uc_ovn;
4361: IF SQL%ROWCOUNT = 0 THEN
4362: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 4374: last_updated_by = FND_GLOBAL.user_id,

4370: UPDATE ahl_unit_config_headers
4371: SET unit_config_status_code = 'INCOMPLETE',
4372: object_version_number = object_version_number + 1,
4373: last_update_date = SYSDATE,
4374: last_updated_by = FND_GLOBAL.user_id,
4375: last_update_login = FND_GLOBAL.login_id
4376: WHERE unit_config_header_id = l_root_uc_header_id
4377: AND object_version_number = l_root_uc_ovn;
4378: IF SQL%ROWCOUNT = 0 THEN

Line 4375: last_update_login = FND_GLOBAL.login_id

4371: SET unit_config_status_code = 'INCOMPLETE',
4372: object_version_number = object_version_number + 1,
4373: last_update_date = SYSDATE,
4374: last_updated_by = FND_GLOBAL.user_id,
4375: last_update_login = FND_GLOBAL.login_id
4376: WHERE unit_config_header_id = l_root_uc_header_id
4377: AND object_version_number = l_root_uc_ovn;
4378: IF SQL%ROWCOUNT = 0 THEN
4379: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );