eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_PRD_WO_LOGIN_PVT dependencies on FND_FUNCTION

Line 643: p_fnd_function_name => p_user_role);

639: p_workorder_id => p_workorder_id,
640: p_operation_seq_num => p_operation_seq_num,
641: p_resource_seq_num => p_resource_seq_num,
642: p_resource_id => p_resource_id,
643: p_fnd_function_name => p_user_role);
644:
645: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
646: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login',
647: 'After call to Is_Login_Allowed procedure:l_login_allowed_flag:' || l_login_allowed_flag);

Line 1003: p_fnd_function_name => p_user_role);

999: -- Call procedure to check if login allowed or not.
1000: l_login_allowed_flag := Is_Login_Allowed(p_employee_id => p_employee_id,
1001: p_workorder_id => p_workorder_id,
1002: p_operation_seq_num => p_operation_seq_num,
1003: p_fnd_function_name => p_user_role);
1004:
1005: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1006: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_login',
1007: 'After call to Is_Login_Allowed procedure:l_login_allowed_flag:' || l_login_allowed_flag);

Line 1295: p_fnd_function_name => p_user_role);

1291:
1292: -- Call procedure to check if login allowed or not.
1293: l_login_allowed_flag := Is_Login_Allowed(p_employee_id => p_employee_id,
1294: p_workorder_id => p_workorder_id,
1295: p_fnd_function_name => p_user_role);
1296:
1297: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1298: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login',
1299: 'After call to Is_Login_Allowed procedure:l_login_allowed_flag:' || l_login_allowed_flag);

Line 2317: -- p_fnd_function_name Input FND function name.

2313: -- Start of Comments --
2314: -- Function name : Get_User_Role
2315: --
2316: -- Parameters :
2317: -- p_fnd_function_name Input FND function name.
2318: --
2319: -- Description : This function is used to retrieve the role associated with the current
2320: -- user - it could be a Production Tech, Production Data Clerk or
2321: -- Production Transit Tech.

Line 2339: IF (FND_FUNCTION.TEST(AHL_PRD_UTIL_PKG.G_TECH_MYWO)

2335: 'At Start of procedure AHL_PRD_WO_LOGIN_PVT.Get_User_Role');
2336: END IF;
2337: --Kasridha: Added for Component Maintenance Planning
2338: -- Treat component Technician role similar to technician role
2339: IF (FND_FUNCTION.TEST(AHL_PRD_UTIL_PKG.G_TECH_MYWO)
2340: OR FND_FUNCTION.TEST(G_CMP_TECH_MYWO)) THEN
2341: -- Technician Role.
2342: l_user_role := AHL_PRD_UTIL_PKG.G_TECH_MYWO;
2343: ELSIF (FND_FUNCTION.TEST(AHL_PRD_UTIL_PKG.G_DATA_CLERK)) THEN

Line 2340: OR FND_FUNCTION.TEST(G_CMP_TECH_MYWO)) THEN

2336: END IF;
2337: --Kasridha: Added for Component Maintenance Planning
2338: -- Treat component Technician role similar to technician role
2339: IF (FND_FUNCTION.TEST(AHL_PRD_UTIL_PKG.G_TECH_MYWO)
2340: OR FND_FUNCTION.TEST(G_CMP_TECH_MYWO)) THEN
2341: -- Technician Role.
2342: l_user_role := AHL_PRD_UTIL_PKG.G_TECH_MYWO;
2343: ELSIF (FND_FUNCTION.TEST(AHL_PRD_UTIL_PKG.G_DATA_CLERK)) THEN
2344: -- Data Clerk Role.

Line 2343: ELSIF (FND_FUNCTION.TEST(AHL_PRD_UTIL_PKG.G_DATA_CLERK)) THEN

2339: IF (FND_FUNCTION.TEST(AHL_PRD_UTIL_PKG.G_TECH_MYWO)
2340: OR FND_FUNCTION.TEST(G_CMP_TECH_MYWO)) THEN
2341: -- Technician Role.
2342: l_user_role := AHL_PRD_UTIL_PKG.G_TECH_MYWO;
2343: ELSIF (FND_FUNCTION.TEST(AHL_PRD_UTIL_PKG.G_DATA_CLERK)) THEN
2344: -- Data Clerk Role.
2345: l_user_role := AHL_PRD_UTIL_PKG.G_DATA_CLERK;
2346: ELSIF (FND_FUNCTION.TEST(AHL_PRD_UTIL_PKG.G_LINE_TECH)) THEN
2347: -- Transit Check Role.

Line 2346: ELSIF (FND_FUNCTION.TEST(AHL_PRD_UTIL_PKG.G_LINE_TECH)) THEN

2342: l_user_role := AHL_PRD_UTIL_PKG.G_TECH_MYWO;
2343: ELSIF (FND_FUNCTION.TEST(AHL_PRD_UTIL_PKG.G_DATA_CLERK)) THEN
2344: -- Data Clerk Role.
2345: l_user_role := AHL_PRD_UTIL_PKG.G_DATA_CLERK;
2346: ELSIF (FND_FUNCTION.TEST(AHL_PRD_UTIL_PKG.G_LINE_TECH)) THEN
2347: -- Transit Check Role.
2348: l_user_role := AHL_PRD_UTIL_PKG.G_LINE_TECH;
2349: END IF;
2350:

Line 2620: -- p_fnd_function_name -- Mandatory fnd_function to identify user role.

2616: -- p_employee_id -- Optional Input Employee Id.
2617: -- p_wip_entity_id -- Mandatory Workorder ID.
2618: -- p_operation_seq_num -- Mandatory Operation Seq Number
2619: -- p_resource_seq_num -- Mandatory Resource ID.
2620: -- p_fnd_function_name -- Mandatory fnd_function to identify user role.
2621: --
2622: -- Description : This function is used to determine if a given technician is
2623: -- allowed to login to a particular workorder/operation/oper-resource.
2624: -- User is allowed to login only if value of the profile

Line 2639: p_fnd_function_name IN VARCHAR2)

2635: p_workorder_id IN NUMBER,
2636: p_operation_seq_num IN NUMBER := NULL,
2637: p_resource_seq_num IN NUMBER := NULL,
2638: p_resource_id IN NUMBER := NULL,
2639: p_fnd_function_name IN VARCHAR2)
2640: RETURN VARCHAR2 IS
2641:
2642: -- get WO status.
2643: CURSOR c_is_wo_valid(p_workorder_id IN NUMBER) IS

Line 2878: l_fnd_function_name VARCHAR2(100);

2874: l_login_wo_name AHL_WORKORDERS.workorder_name%TYPE;
2875: l_resource_id NUMBER;
2876: l_employee_name per_people_f.full_name%TYPE;
2877:
2878: l_fnd_function_name VARCHAR2(100);
2879:
2880: BEGIN
2881:
2882: -- log debug message.

Line 2901: 'p_fnd_function_name:' || p_fnd_function_name);

2897: 'p_resource_seq_num:' || p_resource_seq_num);
2898: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2899: 'p_resource_id:' || p_resource_id);
2900: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2901: 'p_fnd_function_name:' || p_fnd_function_name);
2902:
2903: END IF;
2904:
2905: -- Check if login enabled.

Line 2907: (l_fnd_function_name = AHL_PRD_UTIL_PKG.G_DATA_CLERK) THEN

2903: END IF;
2904:
2905: -- Check if login enabled.
2906: IF (NVL(FND_PROFILE.value('AHL_PRD_MANUAL_RES_TXN'),'N') = 'Y') OR
2907: (l_fnd_function_name = AHL_PRD_UTIL_PKG.G_DATA_CLERK) THEN
2908: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_AUTOTXN_DSBLD');
2909: FND_MSG_PUB.ADD;
2910: Return FND_API.G_FALSE;
2911: END IF;

Line 3023: IF (p_fnd_function_name IS NULL) THEN

3019: FND_MSG_PUB.ADD;
3020: RETURN FND_API.G_FALSE;
3021: END IF;
3022:
3023: IF (p_fnd_function_name IS NULL) THEN
3024: l_fnd_function_name := get_user_role();
3025: ELSE
3026: l_fnd_function_name := p_fnd_function_name;
3027: END IF;

Line 3024: l_fnd_function_name := get_user_role();

3020: RETURN FND_API.G_FALSE;
3021: END IF;
3022:
3023: IF (p_fnd_function_name IS NULL) THEN
3024: l_fnd_function_name := get_user_role();
3025: ELSE
3026: l_fnd_function_name := p_fnd_function_name;
3027: END IF;
3028:

Line 3026: l_fnd_function_name := p_fnd_function_name;

3022:
3023: IF (p_fnd_function_name IS NULL) THEN
3024: l_fnd_function_name := get_user_role();
3025: ELSE
3026: l_fnd_function_name := p_fnd_function_name;
3027: END IF;
3028:
3029: IF (l_fnd_function_name IS NULL) THEN
3030: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_FUNC_NULL');

Line 3029: IF (l_fnd_function_name IS NULL) THEN

3025: ELSE
3026: l_fnd_function_name := p_fnd_function_name;
3027: END IF;
3028:
3029: IF (l_fnd_function_name IS NULL) THEN
3030: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_FUNC_NULL');
3031: FND_MSG_PUB.ADD;
3032: Return FND_API.G_FALSE;
3033: END IF;

Line 3039: l_fnd_function_name);

3035: -- Debug Checkpoint.
3036: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
3037: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',
3038: 'After unit lock check, user role check.. starting qualification checks for function:' ||
3039: l_fnd_function_name);
3040: END IF;
3041:
3042: -- validate login into workorder/operation/operation-resource.
3043: IF (p_operation_seq_num IS NULL) THEN

Line 3077: -- Commented l_fnd_function_name validation to fix bug# 5015149.

3073: END IF; -- c_check_res_reqd.
3074: CLOSE c_check_res_reqd;
3075:
3076: -- Validate qualification to login into a WO in Technician case.
3077: -- Commented l_fnd_function_name validation to fix bug# 5015149.
3078: -- IF (l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO) THEN
3079: -- validate user qualifies for at least one resource requirement within each operation.
3080: FOR operation_rec IN c_get_workorder_oper(l_wip_entity_id) LOOP
3081: OPEN c_qualified_for_one_res(l_employee_id, l_wip_entity_id, operation_rec.operation_seq_num);

Line 3078: -- IF (l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO) THEN

3074: CLOSE c_check_res_reqd;
3075:
3076: -- Validate qualification to login into a WO in Technician case.
3077: -- Commented l_fnd_function_name validation to fix bug# 5015149.
3078: -- IF (l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO) THEN
3079: -- validate user qualifies for at least one resource requirement within each operation.
3080: FOR operation_rec IN c_get_workorder_oper(l_wip_entity_id) LOOP
3081: OPEN c_qualified_for_one_res(l_employee_id, l_wip_entity_id, operation_rec.operation_seq_num);
3082: FETCH c_qualified_for_one_res INTO l_junk;

Line 3092: -- END IF; -- l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO

3088: RETURN FND_API.G_FALSE;
3089: END IF; -- c_qualified_for_one_ops
3090: CLOSE c_qualified_for_one_res;
3091: END LOOP; -- operation_rec
3092: -- END IF; -- l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO
3093:
3094: /*
3095: -- If user qualifies for multiple resource requirements within the same operation and
3096: -- profile 'AHL_ALLOW_MULTI_RESRC_LOGIN' = 'Y then do not allow WO login.

Line 3150: -- Commented l_fnd_function_name validation to fix bug# 5015149.

3146: END IF;
3147:
3148:
3149: -- Validate qualification to login into a Operation in Technician case.
3150: -- Commented l_fnd_function_name validation to fix bug# 5015149.
3151: -- IF (l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO) THEN
3152: -- validate user qualifies for at least one resource requirement for the operation.
3153: OPEN c_qualified_for_one_res(l_employee_id, l_wip_entity_id, p_operation_seq_num);
3154: FETCH c_qualified_for_one_res INTO l_junk;

Line 3151: -- IF (l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO) THEN

3147:
3148:
3149: -- Validate qualification to login into a Operation in Technician case.
3150: -- Commented l_fnd_function_name validation to fix bug# 5015149.
3151: -- IF (l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO) THEN
3152: -- validate user qualifies for at least one resource requirement for the operation.
3153: OPEN c_qualified_for_one_res(l_employee_id, l_wip_entity_id, p_operation_seq_num);
3154: FETCH c_qualified_for_one_res INTO l_junk;
3155: IF (c_qualified_for_one_res%NOTFOUND) THEN

Line 3164: -- END IF; -- l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO

3160: FND_MSG_PUB.ADD;
3161: RETURN FND_API.G_FALSE;
3162: END IF; -- c_qualified_for_one_res
3163: CLOSE c_qualified_for_one_res;
3164: -- END IF; -- l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO
3165:
3166: /*
3167: -- If user qualifies for multiple resource requirements within the same operation and
3168: -- profile 'AHL_ALLOW_MULTI_RESRC_LOGIN' = 'Y then do not allow WO-OP login.

Line 3225: -- Commented l_fnd_function_name validation to fix bug# 5015149.

3221: END IF; -- c_is_resource_valid
3222: CLOSE c_is_resource_valid;
3223:
3224: -- Validate qualification in case of technician.
3225: -- Commented l_fnd_function_name validation to fix bug# 5015149.
3226: -- IF (l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO) THEN
3227: OPEN c_qualify_res(l_employee_id, l_wip_entity_id, p_operation_seq_num,
3228: l_resource_id);
3229: FETCH c_qualify_res INTO l_junk;

Line 3226: -- IF (l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO) THEN

3222: CLOSE c_is_resource_valid;
3223:
3224: -- Validate qualification in case of technician.
3225: -- Commented l_fnd_function_name validation to fix bug# 5015149.
3226: -- IF (l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO) THEN
3227: OPEN c_qualify_res(l_employee_id, l_wip_entity_id, p_operation_seq_num,
3228: l_resource_id);
3229: FETCH c_qualify_res INTO l_junk;
3230: IF (c_qualify_res%FOUND) THEN

Line 3240: -- END IF; -- l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO

3236: FND_MSG_PUB.ADD;
3237: RETURN FND_API.G_FALSE;
3238: END IF;
3239: CLOSE c_qualify_res;
3240: -- END IF; -- l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO
3241:
3242: END IF; -- p_resource_id IS NULL
3243:
3244: END IF; -- operation_seq_num is not null.

Line 3306: p_fnd_function_name => p_function_name

3302: LOOP
3303: p_x_wos(i).is_login_allowed := Is_Login_Allowed(
3304: p_employee_id => p_employee_id,
3305: p_workorder_id => p_x_wos(i).workorder_id,
3306: p_fnd_function_name => p_function_name
3307: );
3308: END LOOP;
3309: END IF;
3310:

Line 3345: p_fnd_function_name => p_function_name

3341: p_employee_id => p_employee_id,
3342: p_workorder_id => p_workorder_id,
3343: p_operation_seq_num => p_x_op_res(i).operation_seq_num,
3344: p_resource_id => p_x_op_res(i).resource_id,
3345: p_fnd_function_name => p_function_name
3346: );
3347: END LOOP;
3348: END IF;
3349:

Line 3368: -- p_fnd_function_name -- fnd_function to identify user role.

3364: -- p_employee_id -- Optional Input Employee Id.
3365: -- p_wip_entity_id -- Mandatory Workorder ID.
3366: -- p_operation_seq_num -- Mandatory Operation Seq Number
3367: -- p_resource_seq_num -- Mandatory Resource ID.
3368: -- p_fnd_function_name -- fnd_function to identify user role.
3369: --
3370: -- Description : This function returns whether user is allowed to login into a
3371: -- wrokorder/operation-resource
3372: --

Line 3380: p_fnd_function_name IN VARCHAR2 :=NULL) RETURN VARCHAR2 IS

3376: p_workorder_id IN NUMBER,
3377: p_operation_seq_num IN NUMBER := NULL,
3378: p_resource_seq_num IN NUMBER := NULL,
3379: p_resource_id IN NUMBER := NULL,
3380: p_fnd_function_name IN VARCHAR2 :=NULL) RETURN VARCHAR2 IS
3381:
3382: -- get WO status.
3383: CURSOR c_is_wo_valid(p_workorder_id IN NUMBER) IS
3384: SELECT wo.STATUS_CODE, wo.workorder_name, wo.wip_entity_id, we.organization_id

Line 3541: l_fnd_function_name VARCHAR2(100);

3537: l_login_wo_name AHL_WORKORDERS.workorder_name%TYPE;
3538: l_resource_id NUMBER;
3539: l_employee_name per_people_f.full_name%TYPE;
3540:
3541: l_fnd_function_name VARCHAR2(100);
3542:
3543: CURSOR c_emp_login_details(c_employee_id IN NUMBER) IS
3544: SELECT WLGN.workorder_id,
3545: WLGN.operation_seq_num,

Line 3642: -- Commented l_fnd_function_name validation to fix bug# 5015149.

3638: END IF; -- c_check_res_reqd.
3639: CLOSE c_check_res_reqd;
3640:
3641: -- Validate qualification to login into a WO in Technician case.
3642: -- Commented l_fnd_function_name validation to fix bug# 5015149.
3643: -- IF (l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO) THEN
3644: -- validate user qualifies for at least one resource requirement within each operation.
3645: FOR operation_rec IN c_get_workorder_oper(l_wip_entity_id) LOOP
3646: OPEN c_qualified_for_one_res(l_employee_id, l_wip_entity_id, operation_rec.operation_seq_num);

Line 3643: -- IF (l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO) THEN

3639: CLOSE c_check_res_reqd;
3640:
3641: -- Validate qualification to login into a WO in Technician case.
3642: -- Commented l_fnd_function_name validation to fix bug# 5015149.
3643: -- IF (l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO) THEN
3644: -- validate user qualifies for at least one resource requirement within each operation.
3645: FOR operation_rec IN c_get_workorder_oper(l_wip_entity_id) LOOP
3646: OPEN c_qualified_for_one_res(l_employee_id, l_wip_entity_id, operation_rec.operation_seq_num);
3647: FETCH c_qualified_for_one_res INTO l_junk;

Line 3674: -- Commented l_fnd_function_name validation to fix bug# 5015149.

3670: IF (p_resource_id IS NULL AND p_resource_seq_num IS NULL) THEN
3671:
3672: -- Login into operation only.
3673: -- Validate qualification to login into a Operation in Technician case.
3674: -- Commented l_fnd_function_name validation to fix bug# 5015149.
3675: -- IF (l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO) THEN
3676: -- validate user qualifies for at least one resource requirement for the operation.
3677: OPEN c_qualified_for_one_res(l_employee_id, l_wip_entity_id, p_operation_seq_num);
3678: FETCH c_qualified_for_one_res INTO l_junk;

Line 3675: -- IF (l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO) THEN

3671:
3672: -- Login into operation only.
3673: -- Validate qualification to login into a Operation in Technician case.
3674: -- Commented l_fnd_function_name validation to fix bug# 5015149.
3675: -- IF (l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO) THEN
3676: -- validate user qualifies for at least one resource requirement for the operation.
3677: OPEN c_qualified_for_one_res(l_employee_id, l_wip_entity_id, p_operation_seq_num);
3678: FETCH c_qualified_for_one_res INTO l_junk;
3679: IF (c_qualified_for_one_res%NOTFOUND) THEN

Line 3708: -- Commented l_fnd_function_name validation to fix bug# 5015149.

3704: END IF; -- c_is_resource_valid
3705: CLOSE c_is_resource_valid;
3706:
3707: -- Validate qualification in case of technician.
3708: -- Commented l_fnd_function_name validation to fix bug# 5015149.
3709: -- IF (l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO) THEN
3710: OPEN c_qualify_res(l_employee_id, l_wip_entity_id, p_operation_seq_num,
3711: l_resource_id);
3712: FETCH c_qualify_res INTO l_junk;

Line 3709: -- IF (l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO) THEN

3705: CLOSE c_is_resource_valid;
3706:
3707: -- Validate qualification in case of technician.
3708: -- Commented l_fnd_function_name validation to fix bug# 5015149.
3709: -- IF (l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO) THEN
3710: OPEN c_qualify_res(l_employee_id, l_wip_entity_id, p_operation_seq_num,
3711: l_resource_id);
3712: FETCH c_qualify_res INTO l_junk;
3713: IF (c_qualify_res%FOUND) THEN

Line 3718: -- END IF; -- l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO

3714: CLOSE c_qualify_res;
3715: RETURN FND_API.G_FALSE;
3716: END IF;
3717: CLOSE c_qualify_res;
3718: -- END IF; -- l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO
3719:
3720: END IF; -- p_resource_id IS NULL
3721:
3722: END IF; -- operation_seq_num is not null.

Line 3737: -- p_fnd_function_name -- Mandatory fnd_function to identify user role.

3733: -- p_employee_id -- Optional Input Employee Id.
3734: -- p_wip_entity_id -- Mandatory Workorder ID.
3735: -- p_operation_seq_num -- Mandatory Operation Seq Number
3736: -- p_resource_seq_num -- Mandatory Resource ID.
3737: -- p_fnd_function_name -- Mandatory fnd_function to identify user role.
3738: --
3739: -- Description : This function returns whether user is allowed to logout into a
3740: -- wrokorder/operation-resource
3741: --

Line 3749: p_fnd_function_name IN VARCHAR2 := NULL)

3745: p_workorder_id IN NUMBER,
3746: p_operation_seq_num IN NUMBER := NULL,
3747: p_resource_seq_num IN NUMBER := NULL,
3748: p_resource_id IN NUMBER := NULL,
3749: p_fnd_function_name IN VARCHAR2 := NULL)
3750: RETURN VARCHAR2 IS
3751:
3752:
3753: l_login_workorder_id NUMBER;