APPS.AHL_PRD_DF_APPR_PVT dependencies on AHL_UNIT_DEFERRALS_TL

Line 1210: UPDATE AHL_UNIT_DEFERRALS_TL

1206: itemkey => itemkey,
1207: aname => 'APPROVER NOTE'
1208: );
1209:
1210: UPDATE AHL_UNIT_DEFERRALS_TL
1211: SET approver_notes = l_approver_note,
1212: SOURCE_LANG = userenv('LANG')
1213: WHERE unit_deferral_id = l_object_id
1214: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);

Line 1281: UPDATE AHL_UNIT_DEFERRALS_TL

1277: l_df_header_info_rec.MR_APPL_EXPIRED = FND_API.G_TRUE)THEN
1278:
1279: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_MR_EXPIRED');
1280: l_msg_data := FND_MESSAGE.get;
1281: UPDATE AHL_UNIT_DEFERRALS_TL
1282: SET approver_notes = approver_notes || l_msg_data,
1283: SOURCE_LANG = userenv('LANG')
1284: WHERE unit_deferral_id = l_object_id
1285: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);

Line 1399: UPDATE AHL_UNIT_DEFERRALS_TL

1395: );
1396: END IF;
1397:
1398: -- update validation errors.
1399: UPDATE AHL_UNIT_DEFERRALS_TL
1400: SET approver_notes = substrb(l_error_msg,1,4000)
1401: WHERE unit_deferral_id = l_object_id
1402: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
1403:

Line 1420: UPDATE AHL_UNIT_DEFERRALS_TL

1416: wf_core.context( 'AHLGAPP', 'Update_Status', itemtype, itemkey );
1417:
1418: l_error_msg := SQLCODE || ': ' || SQLERRM;
1419: -- update validation errors.
1420: UPDATE AHL_UNIT_DEFERRALS_TL
1421: SET approver_notes = substrb(l_error_msg,1,4000)
1422: WHERE unit_deferral_id = l_object_id
1423: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
1424:

Line 1565: UPDATE AHL_UNIT_DEFERRALS_TL

1561: ) ;
1562: wf_core.context(G_PKG_NAME,'Revert_Status',itemtype,itemkey,l_error_msg);
1563:
1564: -- update validation errors.
1565: UPDATE AHL_UNIT_DEFERRALS_TL
1566: SET approver_notes = substrb(l_error_msg,1,4000)
1567: WHERE unit_deferral_id = l_object_id
1568: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
1569:

Line 1586: UPDATE AHL_UNIT_DEFERRALS_TL

1582: wf_core.context( 'AHLGAPP', 'Revert_Status', itemtype, itemkey );
1583:
1584: l_error_msg := SQLCODE || ': ' || SQLERRM;
1585: -- update validation errors.
1586: UPDATE AHL_UNIT_DEFERRALS_TL
1587: SET approver_notes = substrb(l_error_msg,1,4000)
1588: WHERE unit_deferral_id = l_object_id
1589: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
1590: