Project

General

Profile

Bug #1183

ادخال نواقس الرواتب

Added by Abdelhalim Abu Qamar about 6 years ago. Updated about 6 years ago.

Status:
Open
Priority:
High
Assignee:
Abdelhalim Abu Qamar
Start date:
05/06/2019
Due date:
% Done:

100%

Co-Workers:
Severity:
Normal
Category:
inspection screen
Sub-Category:
Step_Description:
Pre_Conditions:
Expected Result:
Actual Result:
Environment:
Development
Transaction Number:
Username:
Browser:
URL:
Test Case ID:

Description

dear Ahmed
kindly find attachment photo to update the LOV and show reason name not only code

excp.jpg (112 KB) Abdelhalim Abu Qamar, 05/06/2019 01:29 PM

History

#1 Updated by Ahmad Amer about 6 years ago

  • Assignee changed from Ahmad Amer to Abdelhalim Abu Qamar

please provide me with the lookup M_ID for the reason.

#2 Updated by Abdelhalim Abu Qamar about 6 years ago

u must add new object view with SQL :
SELECT REASON_CODE ,REASON_NAME FROM INS_SALARY_SHORTFALLS WHERE STATUS = 1 ;

#3 Updated by Abdelhalim Abu Qamar about 6 years ago

  • Assignee changed from Abdelhalim Abu Qamar to Ahmad Amer
  • Environment Development added
  • Environment deleted (QA)

#4 Updated by Ahmad Amer about 6 years ago

  • Assignee changed from Ahmad Amer to Abdelhalim Abu Qamar
  • % Done changed from 0 to 100

done on test please review the screen

#5 Updated by Abdelhalim Abu Qamar about 6 years ago

  • Assignee changed from Abdelhalim Abu Qamar to Ahmad Amer

kindly update the LOV to redirect ream from old Database MOSAL_USER

SELECT CWI_NS_REASONS_RECID , REASON_CODE ,REASON_DESC
FROM MOSAL_USER.CWI_NS_REASONS ;

also to show the name and code at the screen

#6 Updated by Ahmad Amer about 6 years ago

  • Assignee changed from Ahmad Amer to Abdelhalim Abu Qamar

done on test, please review the screen

#7 Updated by Abdelhalim Abu Qamar about 6 years ago

  • Assignee changed from Abdelhalim Abu Qamar to Ahmad Amer

Aslo to add new validtion on screen :
------------------------------------------
for CWI_NS_REASONS_RECID = 2
used : PRD_PKG.CHECK_LABER_ABSENCES
 1
 يوجد بلاغ تغيب فعال على العامل 
0
لا يمنك اضافة هذا السبب,لا يوجد بلاغ تغيب فعال على العامل
------------------------------------------
for CWI_NS_REASONS_RECID = 7 
used : FUNCTION CHECK_FOR_ABSENCES
1
  يوجد شكوى على العامل 
0
لا يمنك اضافة هذا السبب,لا يوجد شكوى على العامل

for CWI_NS_REASONS_RECID = 6

used : if b.NATIONALITY = 101 then 

العامل مسجل لدى العمالة الوطنية

else

لا يمنك اضافة هذا السبب,  العامل ليس من العمالة الوطنية
------------------------------------------

#8 Updated by Ahmad Amer about 6 years ago

  • Assignee changed from Ahmad Amer to Abdelhalim Abu Qamar

done on both prod and test

Also available in: Atom PDF