APPS.AHL_PRD_DF_APPR_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 47

  SELECT unit_effectivity_id from ahl_unit_deferrals_b
  WHERE unit_deferral_id = p_unit_deferral_id;

Line: 1144

PROCEDURE Update_Status(
   itemtype    IN       VARCHAR2,
   itemkey     IN       VARCHAR2,
   actid       IN       NUMBER,
   funcmode    IN       VARCHAR2,
   resultout   OUT NOCOPY      VARCHAR2) IS

  l_error_msg                VARCHAR2(4000);

Line: 1162

  SELECT unit_effectivity_id from ahl_unit_deferrals_b
  WHERE unit_deferral_id = p_unit_deferral_id;

Line: 1176

			'ahl.plsql.AHL_PRD_DF_APPR_PVT.Update_Status.begin',
			'At the start of PLSQL procedure'
		);

Line: 1180

  SAVEPOINT AHL_DEF_UPDATE_STATUS;

Line: 1191

                           aname    => 'UPDATE_GEN_STATUS'
                        );

Line: 1210

     UPDATE AHL_UNIT_DEFERRALS_TL
     SET approver_notes = l_approver_note,
     SOURCE_LANG = userenv('LANG')
     WHERE unit_deferral_id = l_object_id
     AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);

Line: 1220

			'ahl.plsql.AHL_PRD_DF_APPR_PVT.Update_Status',
			'unit_deferral_id : ' || l_object_id
		);

Line: 1226

			'ahl.plsql.AHL_PRD_DF_APPR_PVT.Update_Status',
			'object_version_number : ' || l_object_version_number
		);

Line: 1232

			'ahl.plsql.AHL_PRD_DF_APPR_PVT.Update_Status',
			'approval status : ' || l_approval_status
		);

Line: 1281

              UPDATE AHL_UNIT_DEFERRALS_TL
              SET approver_notes = approver_notes || l_msg_data,
              SOURCE_LANG = userenv('LANG')
              WHERE unit_deferral_id = l_object_id
              AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);

Line: 1332

			'ahl.plsql.AHL_PRD_DF_APPR_PVT.Update_Status',
			'new status : ' || l_new_status
		);

Line: 1338

			'ahl.plsql.AHL_PRD_DF_APPR_PVT.Update_Status',
			'return status after process_approval_rejected API call : ' || l_return_status
		);

Line: 1357

			'ahl.plsql.AHL_PRD_DF_APPR_PVT.Update_Status.end',
			'At the end of PLSQL procedure'
		);

Line: 1365

       ROLLBACK TO AHL_DEF_UPDATE_STATUS;

Line: 1375

			    'ahl.plsql.AHL_PRD_DF_APPR_PVT.update_status',
			    ' Error Message : l_msg_data : ' || l_msg_data
		    );

Line: 1387

      wf_core.context(G_PKG_NAME,'Update_Status',itemtype,itemkey,l_error_msg);

Line: 1393

			    'ahl.plsql.AHL_PRD_DF_APPR_PVT.update_status',
			    ' Error Message : l_error_msg : ' || l_error_msg
		    );

Line: 1399

      UPDATE AHL_UNIT_DEFERRALS_TL
      SET approver_notes = substrb(l_error_msg,1,4000)
      WHERE unit_deferral_id = l_object_id
        AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);

Line: 1404

      UPDATE AHL_UNIT_DEFERRALS_B
      SET approval_status_code = 'DEFERRAL_REJECTED',
          object_version_number = object_version_number + 1,
          last_update_date = sysdate,
          last_updated_by = fnd_global.user_id,
          last_update_login = fnd_global.login_id
      WHERE unit_deferral_id = l_object_id;

Line: 1415

      ROLLBACK TO AHL_DEF_UPDATE_STATUS;

Line: 1416

      wf_core.context( 'AHLGAPP', 'Update_Status', itemtype, itemkey );

Line: 1420

      UPDATE AHL_UNIT_DEFERRALS_TL
      SET approver_notes = substrb(l_error_msg,1,4000)
      WHERE unit_deferral_id = l_object_id
        AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);

Line: 1425

      UPDATE AHL_UNIT_DEFERRALS_B
      SET approval_status_code = 'DEFERRAL_REJECTED',
          object_version_number = object_version_number + 1,
          last_update_date = sysdate,
          last_updated_by = fnd_global.user_id,
          last_update_login = fnd_global.login_id
      WHERE unit_deferral_id = l_object_id;

Line: 1437

END Update_Status;

Line: 1565

      UPDATE AHL_UNIT_DEFERRALS_TL
      SET approver_notes = substrb(l_error_msg,1,4000)
      WHERE unit_deferral_id = l_object_id
        AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);

Line: 1570

      UPDATE AHL_UNIT_DEFERRALS_B
      SET approval_status_code = 'DEFERRAL_REJECTED',
          object_version_number = object_version_number + 1,
          last_update_date = sysdate,
          last_updated_by = fnd_global.user_id,
          last_update_login = fnd_global.login_id
      WHERE unit_deferral_id = l_object_id;

Line: 1586

      UPDATE AHL_UNIT_DEFERRALS_TL
      SET approver_notes = substrb(l_error_msg,1,4000)
      WHERE unit_deferral_id = l_object_id
        AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);

Line: 1591

      UPDATE AHL_UNIT_DEFERRALS_B
      SET approval_status_code = 'DEFERRAL_REJECTED',
          object_version_number = object_version_number + 1,
          last_update_date = sysdate,
          last_updated_by = fnd_global.user_id,
          last_update_login = fnd_global.login_id
      WHERE unit_deferral_id = l_object_id;

Line: 1613

     SELECT lookup_code, meaning FROM fnd_lookup_values_vl fnd
     WHERE fnd.lookup_type = 'AHL_PRD_DF_CT_VAL_TYPES';

Line: 1707

     SELECT meaning FROM fnd_lookup_values_vl fnd
     WHERE fnd.lookup_type = 'AHL_PRD_DF_REASON_TYPES'
     AND fnd.lookup_code = p_reason_code;