APPS.AHL_PRD_DF_APPR_PVT dependencies on AHL_UNIT_DEFERRALS_TL

Line 1201: UPDATE AHL_UNIT_DEFERRALS_TL

1197: itemkey => itemkey,
1198: aname => 'APPROVER NOTE'
1199: );
1200:
1201: UPDATE AHL_UNIT_DEFERRALS_TL
1202: SET approver_notes = l_approver_note,
1203: SOURCE_LANG = userenv('LANG')
1204: WHERE unit_deferral_id = l_object_id
1205: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);

Line 1327: UPDATE AHL_UNIT_DEFERRALS_TL

1323: );
1324: END IF;
1325:
1326: -- update validation errors.
1327: UPDATE AHL_UNIT_DEFERRALS_TL
1328: SET approver_notes = substrb(l_error_msg,1,4000)
1329: WHERE unit_deferral_id = l_object_id
1330: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
1331:

Line 1348: UPDATE AHL_UNIT_DEFERRALS_TL

1344: wf_core.context( 'AHLGAPP', 'Update_Status', itemtype, itemkey );
1345:
1346: l_error_msg := SQLCODE || ': ' || SQLERRM;
1347: -- update validation errors.
1348: UPDATE AHL_UNIT_DEFERRALS_TL
1349: SET approver_notes = substrb(l_error_msg,1,4000)
1350: WHERE unit_deferral_id = l_object_id
1351: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
1352:

Line 1493: UPDATE AHL_UNIT_DEFERRALS_TL

1489: ) ;
1490: wf_core.context(G_PKG_NAME,'Revert_Status',itemtype,itemkey,l_error_msg);
1491:
1492: -- update validation errors.
1493: UPDATE AHL_UNIT_DEFERRALS_TL
1494: SET approver_notes = substrb(l_error_msg,1,4000)
1495: WHERE unit_deferral_id = l_object_id
1496: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
1497:

Line 1514: UPDATE AHL_UNIT_DEFERRALS_TL

1510: wf_core.context( 'AHLGAPP', 'Revert_Status', itemtype, itemkey );
1511:
1512: l_error_msg := SQLCODE || ': ' || SQLERRM;
1513: -- update validation errors.
1514: UPDATE AHL_UNIT_DEFERRALS_TL
1515: SET approver_notes = substrb(l_error_msg,1,4000)
1516: WHERE unit_deferral_id = l_object_id
1517: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
1518: