DBA Data[Home] [Help]

APPS.EAM_ASSIGN_EMP_PUB dependencies on EAM_EMP_SEARCH_RESULT_TBL

Line 45: TYPE Emp_Search_Result_Tbl_Type IS TABLE OF Eam_Emp_Search_Result_Tbl%ROWTYPE;

41: wo_firm_status VARCHAR2(1), --1 firm, 2 non-firm
42: uom VARCHAR2(3)
43: );
44:
45: TYPE Emp_Search_Result_Tbl_Type IS TABLE OF Eam_Emp_Search_Result_Tbl%ROWTYPE;
46:
47: TYPE Emp_Assignment_Rec_Type IS RECORD
48: (
49: wip_entity_id NUMBER,

Line 71: * Depending upon the search criteria entered, the eligible employees will be inserted into Eam_Emp_Search_Result_Tbl temporary table.

67:
68: --- Function and procedure signature to return the employee search results
69: /*
70: * This procedure is used to get all the employees who can be assigned to a workorder.
71: * Depending upon the search criteria entered, the eligible employees will be inserted into Eam_Emp_Search_Result_Tbl temporary table.
72: * The API calls the required procedures and function to calculate the assigned hour,available hour,assigned percentage for each eligible employee.
73: * The API requires you to enter atleast one of the following parameters: department id,resource id, person id,competence type, competence id.
74: * Also, enter the relevant horizon for which the result is to be fetched.
75: * In case of error ,API reports detailed and translatable error messages .