[Home] [Help]
1: PACKAGE BODY Eng_Workflow_Util AS
2: /* $Header: ENGUWKFB.pls 120.37.12020000.6 2013/05/22 03:36:15 leizhzha ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'Eng_Workflow_Util' ;
5:
1: PACKAGE BODY Eng_Workflow_Util AS
2: /* $Header: ENGUWKFB.pls 120.37.12020000.6 2013/05/22 03:36:15 leizhzha ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'Eng_Workflow_Util' ;
5:
6: -- For Debug
7: g_debug_file UTL_FILE.FILE_TYPE ;
8: g_debug_flag BOOLEAN := FALSE ; -- For Debug, set TRUE
9: g_output_dir VARCHAR2(240) := NULL ;
10: g_debug_filename VARCHAR2(30) := 'EngChangeWorkflowUtil.log' ;
11: g_debug_errmesg VARCHAR2(400);
12:
13: G_BO_IDENTIFIER VARCHAR2(30) := 'ENG_WORKFLOW_UTIL';
14: G_ERRFILE_PATH_AND_NAME VARCHAR2(10000);
15: g_profile_debug_option VARCHAR2(10) ;
16: g_profile_debug_level VARCHAR2(10) ;
17:
998: FROM ENG_SECURITY_PEOPLE_V EngSecPeople
999: , ENG_CHANGE_ROUTE_PEOPLE step_people
1000: , ENG_CHANGE_ROUTE_STEPS step
1001: WHERE EngSecPeople.person_id = step_people.assignee_id
1002: AND step_people.assignee_type_code = Eng_Workflow_Util.G_PERSON
1003: AND step_people.assignee_id <> -1
1004: AND step_people.step_id = step.step_id
1005: AND step.step_status_code <> Eng_Workflow_Util.G_RT_NOT_STARTED
1006: AND step.step_start_date IS NOT NULL
1001: WHERE EngSecPeople.person_id = step_people.assignee_id
1002: AND step_people.assignee_type_code = Eng_Workflow_Util.G_PERSON
1003: AND step_people.assignee_id <> -1
1004: AND step_people.step_id = step.step_id
1005: AND step.step_status_code <> Eng_Workflow_Util.G_RT_NOT_STARTED
1006: AND step.step_start_date IS NOT NULL
1007: AND step.route_id = p_route_id ;
1008:
1009: BEGIN
1052: FROM ENG_SECURITY_PEOPLE_V EngSecPeople
1053: , ENG_CHANGE_ROUTE_PEOPLE step_people
1054: WHERE EngSecPeople.person_id = step_people.assignee_id
1055: AND step_people.assignee_id <> -1
1056: AND step_people.assignee_type_code = Eng_Workflow_Util.G_PERSON
1057: AND step_people.step_id = p_route_step_id
1058: AND ( step_people.response_code IS NULL
1059: OR step_people.response_code = Eng_Workflow_Util.G_RT_SUBMITTED
1060: OR step_people.response_code = Eng_Workflow_Util.G_RT_NOT_RECEIVED
1055: AND step_people.assignee_id <> -1
1056: AND step_people.assignee_type_code = Eng_Workflow_Util.G_PERSON
1057: AND step_people.step_id = p_route_step_id
1058: AND ( step_people.response_code IS NULL
1059: OR step_people.response_code = Eng_Workflow_Util.G_RT_SUBMITTED
1060: OR step_people.response_code = Eng_Workflow_Util.G_RT_NOT_RECEIVED
1061: ) ;
1062:
1063:
1056: AND step_people.assignee_type_code = Eng_Workflow_Util.G_PERSON
1057: AND step_people.step_id = p_route_step_id
1058: AND ( step_people.response_code IS NULL
1059: OR step_people.response_code = Eng_Workflow_Util.G_RT_SUBMITTED
1060: OR step_people.response_code = Eng_Workflow_Util.G_RT_NOT_RECEIVED
1061: ) ;
1062:
1063:
1064: BEGIN
1401: FROM ENG_SECURITY_PEOPLE_V EngSecPeople
1402: , ENG_CHANGE_ROUTE_PEOPLE step_people
1403: , ENG_CHANGE_ROUTE_STEPS step
1404: WHERE EngSecPeople.person_id = step_people.assignee_id
1405: AND step_people.assignee_type_code = Eng_Workflow_Util.G_PERSON
1406: AND step_people.assignee_id <> -1
1407: AND step_people.step_id = step.step_id
1408: AND step.step_status_code <> Eng_Workflow_Util.G_RT_NOT_STARTED
1409: AND step.step_start_date IS NOT NULL
1404: WHERE EngSecPeople.person_id = step_people.assignee_id
1405: AND step_people.assignee_type_code = Eng_Workflow_Util.G_PERSON
1406: AND step_people.assignee_id <> -1
1407: AND step_people.step_id = step.step_id
1408: AND step.step_status_code <> Eng_Workflow_Util.G_RT_NOT_STARTED
1409: AND step.step_start_date IS NOT NULL
1410: AND step.route_id = p_route_id ;
1411:
1412: BEGIN
1437: FROM ENG_SECURITY_PEOPLE_V EngSecPeople
1438: , ENG_CHANGE_ROUTE_PEOPLE step_people
1439: WHERE EngSecPeople.person_id = step_people.assignee_id
1440: AND step_people.assignee_id <> -1
1441: AND step_people.assignee_type_code = Eng_Workflow_Util.G_PERSON
1442: AND step_people.step_id = p_route_step_id
1443: AND ( step_people.response_code IS NULL
1444: OR step_people.response_code = Eng_Workflow_Util.G_RT_SUBMITTED
1445: OR step_people.response_code = Eng_Workflow_Util.G_RT_NOT_RECEIVED
1440: AND step_people.assignee_id <> -1
1441: AND step_people.assignee_type_code = Eng_Workflow_Util.G_PERSON
1442: AND step_people.step_id = p_route_step_id
1443: AND ( step_people.response_code IS NULL
1444: OR step_people.response_code = Eng_Workflow_Util.G_RT_SUBMITTED
1445: OR step_people.response_code = Eng_Workflow_Util.G_RT_NOT_RECEIVED
1446: ) ;
1447:
1448: BEGIN
1441: AND step_people.assignee_type_code = Eng_Workflow_Util.G_PERSON
1442: AND step_people.step_id = p_route_step_id
1443: AND ( step_people.response_code IS NULL
1444: OR step_people.response_code = Eng_Workflow_Util.G_RT_SUBMITTED
1445: OR step_people.response_code = Eng_Workflow_Util.G_RT_NOT_RECEIVED
1446: ) ;
1447:
1448: BEGIN
1449:
1872: PROCEDURE CheckWFActivityStatus
1873: ( p_item_type IN VARCHAR2
1874: , p_item_key IN VARCHAR2
1875: , p_process_name IN VARCHAR2 := NULL
1876: , p_activity_item_type IN VARCHAR2 := Eng_Workflow_Util.G_STD_ITEM_TYPE
1877: , p_activity_name IN VARCHAR2
1878: , x_activity_status OUT NOCOPY VARCHAR2
1879: )
1880: IS
2217: END LOOP ;
2218:
2219:
2220: IF x_default_resp_code IS NULL THEN
2221: x_default_resp_code := Eng_Workflow_Util.G_RT_SUBMITTED ;
2222: END IF ;
2223:
2224: END GetStepDefaultRespCode ;
2225:
2339: BEGIN
2340:
2341:
2342: IF g_debug_flag THEN
2343: Write_Debug('Eng_Workflow_Util.RespondToDuplicateNtf Log');
2344: Write_Debug('-----------------------------------------------------');
2345: Write_Debug('Target Dup Notification Id : ' || TO_CHAR(p_dupllicate_ntf_id));
2346: Write_Debug('Original Notification Id : ' || TO_CHAR(p_orig_ntf_id));
2347: Write_Debug('-----------------------------------------------------');
2410: l_route_type_code VARCHAR2(30) ;
2411:
2412: BEGIN
2413:
2414: Eng_Workflow_Util.GetRouteTypeCode( p_route_id => p_route_id
2415: , x_route_type_code => l_route_type_code
2416: ) ;
2417:
2418: IF Eng_Workflow_Util.G_LINE_RT_TYPE_NOTIFICATION = l_route_type_code
2414: Eng_Workflow_Util.GetRouteTypeCode( p_route_id => p_route_id
2415: , x_route_type_code => l_route_type_code
2416: ) ;
2417:
2418: IF Eng_Workflow_Util.G_LINE_RT_TYPE_NOTIFICATION = l_route_type_code
2419: THEN
2420: RETURN TRUE ;
2421: ELSE
2422: RETURN FALSE ;
2744: BEGIN
2745:
2746:
2747: IF g_debug_flag THEN
2748: Write_Debug('Eng_Workflow_Util.GetRouteTypeCode Log');
2749: Write_Debug('-----------------------------------------------------');
2750: Write_Debug('Route Id : ' || TO_CHAR(p_route_id));
2751: Write_Debug('-----------------------------------------------------');
2752: END IF ;
3017: BEGIN
3018:
3019:
3020: -- Get Route Step Id
3021: Eng_Workflow_Util.GetRouteStepId
3022: ( p_item_type => p_item_type
3023: , p_item_key => p_item_key
3024: , x_route_step_id => l_route_step_id
3025: ) ;
3026:
3027:
3028:
3029: -- Set Step Voting Option based on Step Activity Condition
3030: IF p_condition_type_code = Eng_Workflow_Util.G_ALL THEN
3031:
3032:
3033: -- R12B
3034: -- Need to get Additional Vote Option for All
3045: , x_vote_option_for_step_all => l_vote_option_for_step_all
3046: ) ;
3047:
3048: IF ( l_vote_option_for_step_all IS NULL
3049: OR ( Eng_Workflow_Util.G_WAIT_FOR_ALL_VOTES <> l_vote_option_for_step_all
3050: AND Eng_Workflow_Util.G_TALLY_ON_EVERY_VOTE <> l_vote_option_for_step_all
3051: AND Eng_Workflow_Util.G_REQUIRE_ALL_VOTES <> l_vote_option_for_step_all
3052: )
3053: )
3046: ) ;
3047:
3048: IF ( l_vote_option_for_step_all IS NULL
3049: OR ( Eng_Workflow_Util.G_WAIT_FOR_ALL_VOTES <> l_vote_option_for_step_all
3050: AND Eng_Workflow_Util.G_TALLY_ON_EVERY_VOTE <> l_vote_option_for_step_all
3051: AND Eng_Workflow_Util.G_REQUIRE_ALL_VOTES <> l_vote_option_for_step_all
3052: )
3053: )
3054: THEN
3047:
3048: IF ( l_vote_option_for_step_all IS NULL
3049: OR ( Eng_Workflow_Util.G_WAIT_FOR_ALL_VOTES <> l_vote_option_for_step_all
3050: AND Eng_Workflow_Util.G_TALLY_ON_EVERY_VOTE <> l_vote_option_for_step_all
3051: AND Eng_Workflow_Util.G_REQUIRE_ALL_VOTES <> l_vote_option_for_step_all
3052: )
3053: )
3054: THEN
3055: l_vote_option_for_step_all := Eng_Workflow_Util.G_TALLY_ON_EVERY_VOTE;
3051: AND Eng_Workflow_Util.G_REQUIRE_ALL_VOTES <> l_vote_option_for_step_all
3052: )
3053: )
3054: THEN
3055: l_vote_option_for_step_all := Eng_Workflow_Util.G_TALLY_ON_EVERY_VOTE;
3056:
3057: END IF ;
3058:
3059: l_step_voting_option := l_vote_option_for_step_all ;
3057: END IF ;
3058:
3059: l_step_voting_option := l_vote_option_for_step_all ;
3060: -- Bug 5254686
3061: IF ( l_step_voting_option = Eng_Workflow_Util.G_REQUIRE_ALL_VOTES )
3062: THEN
3063:
3064: l_yes_percentage := NULL ;
3065: l_no_percentage := NULL ;
3069: l_yes_percentage := 100 ;
3070: l_no_percentage := 0 ;
3071: END IF ;
3072:
3073: ELSIF p_condition_type_code = Eng_Workflow_Util.G_ONE THEN
3074:
3075: l_step_voting_option := Eng_Workflow_Util.G_TALLY_ON_EVERY_VOTE ;
3076: l_yes_percentage := 0 ;
3077: l_no_percentage := 0 ;
3071: END IF ;
3072:
3073: ELSIF p_condition_type_code = Eng_Workflow_Util.G_ONE THEN
3074:
3075: l_step_voting_option := Eng_Workflow_Util.G_TALLY_ON_EVERY_VOTE ;
3076: l_yes_percentage := 0 ;
3077: l_no_percentage := 0 ;
3078:
3079: ELSIF p_condition_type_code = Eng_Workflow_Util.G_PEOPLE THEN
3075: l_step_voting_option := Eng_Workflow_Util.G_TALLY_ON_EVERY_VOTE ;
3076: l_yes_percentage := 0 ;
3077: l_no_percentage := 0 ;
3078:
3079: ELSIF p_condition_type_code = Eng_Workflow_Util.G_PEOPLE THEN
3080:
3081: l_step_voting_option := Eng_Workflow_Util.G_PEOPLE;
3082: l_yes_percentage := 100 ;
3083: l_no_percentage := 0 ;
3077: l_no_percentage := 0 ;
3078:
3079: ELSIF p_condition_type_code = Eng_Workflow_Util.G_PEOPLE THEN
3080:
3081: l_step_voting_option := Eng_Workflow_Util.G_PEOPLE;
3082: l_yes_percentage := 100 ;
3083: l_no_percentage := 0 ;
3084:
3085:
3083: l_no_percentage := 0 ;
3084:
3085:
3086: /* For future ref
3087: ELSIF p_condition_type_code = Eng_Workflow_Util.G_WAIT_ALL THEN
3088:
3089: l_step_voting_option := Eng_Workflow_Util.G_WAIT_FOR_ALL_VOTES ;
3090: l_yes_percentage := 100 ;
3091: l_no_percentage := 0 ;
3085:
3086: /* For future ref
3087: ELSIF p_condition_type_code = Eng_Workflow_Util.G_WAIT_ALL THEN
3088:
3089: l_step_voting_option := Eng_Workflow_Util.G_WAIT_FOR_ALL_VOTES ;
3090: l_yes_percentage := 100 ;
3091: l_no_percentage := 0 ;
3092: */
3093:
3651: -- R12B for Distribution Line Enh
3652: -- If the Line is attached to Line Workflow
3653: -- Line Status Display Name should be
3654: -- the value defined in lookup type: ENG_DIST_LINE_STATUSES
3655: IF l_route_type_code = Eng_Workflow_Util.G_LINE_RT_TYPE_NOTIFICATION
3656: THEN
3657:
3658: x_line_status := l_list_dist_status;
3659:
4114: UPDATE eng_engineering_changes
4115: SET approval_status_type = p_new_appr_status_type,
4116: approval_date = NULL ,
4117: approval_request_date = DECODE(p_new_appr_status_type
4118: , Eng_Workflow_Util.G_REQUESTED
4119: , sysdate
4120: , approval_request_date) ,
4121: request_id = l_request_id ,
4122: last_update_date = SYSDATE ,
4144:
4145: IF p_sync_lines > 0 THEN
4146:
4147: -- Sync child line approval status
4148: Eng_Workflow_Util.SyncLineApprovalStatus
4149: ( x_return_status => x_return_status
4150: , x_msg_count => x_msg_count
4151: , x_msg_data => x_msg_data
4152: , p_change_id => p_change_id
4196: UPDATE eng_change_lines
4197: SET approval_status_type = p_new_appr_status_type,
4198: approval_date = NULL ,
4199: approval_request_date = DECODE(p_new_appr_status_type
4200: , Eng_Workflow_Util.G_REQUESTED
4201: , sysdate
4202: , approval_request_date) ,
4203: request_id = l_request_id ,
4204: last_update_date = SYSDATE ,
4276: IS
4277: SELECT ecl.change_line_id
4278: FROM ENG_CHANGE_LINES ecl
4279: -- , ENG_CHANGE_ROUTES ecr
4280: WHERE ( ecl.approval_status_type <> Eng_Workflow_Util.G_APPROVED
4281: AND ecl.approval_status_type <> Eng_Workflow_Util.G_REQUESTED )
4282: -- AND ( ecl.status_code <> Eng_Workflow_Util.G_CL_COMPLETED
4283: -- AND ecl.status_code <> Eng_Workflow_Util.G_CL_CANCELLED )
4284: AND ecl.sequence_number <> -1
4277: SELECT ecl.change_line_id
4278: FROM ENG_CHANGE_LINES ecl
4279: -- , ENG_CHANGE_ROUTES ecr
4280: WHERE ( ecl.approval_status_type <> Eng_Workflow_Util.G_APPROVED
4281: AND ecl.approval_status_type <> Eng_Workflow_Util.G_REQUESTED )
4282: -- AND ( ecl.status_code <> Eng_Workflow_Util.G_CL_COMPLETED
4283: -- AND ecl.status_code <> Eng_Workflow_Util.G_CL_CANCELLED )
4284: AND ecl.sequence_number <> -1
4285: AND ecl.change_type_id <> -1
4278: FROM ENG_CHANGE_LINES ecl
4279: -- , ENG_CHANGE_ROUTES ecr
4280: WHERE ( ecl.approval_status_type <> Eng_Workflow_Util.G_APPROVED
4281: AND ecl.approval_status_type <> Eng_Workflow_Util.G_REQUESTED )
4282: -- AND ( ecl.status_code <> Eng_Workflow_Util.G_CL_COMPLETED
4283: -- AND ecl.status_code <> Eng_Workflow_Util.G_CL_CANCELLED )
4284: AND ecl.sequence_number <> -1
4285: AND ecl.change_type_id <> -1
4286: -- AND ecl.parent_line_id IS NULL
4279: -- , ENG_CHANGE_ROUTES ecr
4280: WHERE ( ecl.approval_status_type <> Eng_Workflow_Util.G_APPROVED
4281: AND ecl.approval_status_type <> Eng_Workflow_Util.G_REQUESTED )
4282: -- AND ( ecl.status_code <> Eng_Workflow_Util.G_CL_COMPLETED
4283: -- AND ecl.status_code <> Eng_Workflow_Util.G_CL_CANCELLED )
4284: AND ecl.sequence_number <> -1
4285: AND ecl.change_type_id <> -1
4286: -- AND ecl.parent_line_id IS NULL
4287: -- AND ecr.status_code = Eng_Workflow_Util.G_RT_NOT_STARTED
4283: -- AND ecl.status_code <> Eng_Workflow_Util.G_CL_CANCELLED )
4284: AND ecl.sequence_number <> -1
4285: AND ecl.change_type_id <> -1
4286: -- AND ecl.parent_line_id IS NULL
4287: -- AND ecr.status_code = Eng_Workflow_Util.G_RT_NOT_STARTED
4288: -- AND ecl.route_id = ecr.route_id
4289: AND ecl.change_id = p_change_id ;
4290:
4291: BEGIN
4308:
4309: IF l_updatable_flag THEN
4310:
4311: -- Set Approval Status
4312: Eng_Workflow_Util.SetChangeApprovalStatus
4313: ( x_return_status => l_return_status
4314: , x_msg_count => l_msg_count
4315: , x_msg_data => l_msg_data
4316: , p_item_type => null
4389: Write_Debug('Set Route Status . . .');
4390: END IF ;
4391:
4392:
4393: IF p_new_status_code = Eng_Workflow_Util.G_RT_IN_PROGRESS
4394: THEN
4395:
4396: l_set_start_date_flag := 1 ;
4397:
4394: THEN
4395:
4396: l_set_start_date_flag := 1 ;
4397:
4398: ELSIF p_new_status_code IN ( Eng_Workflow_Util.G_RT_REJECTED
4399: , Eng_Workflow_Util.G_RT_APPROVED
4400: , Eng_Workflow_Util.G_RT_COMPLETED
4401: , Eng_Workflow_Util.G_RT_TIME_OUT
4402: , Eng_Workflow_Util.G_RT_ABORTED )
4395:
4396: l_set_start_date_flag := 1 ;
4397:
4398: ELSIF p_new_status_code IN ( Eng_Workflow_Util.G_RT_REJECTED
4399: , Eng_Workflow_Util.G_RT_APPROVED
4400: , Eng_Workflow_Util.G_RT_COMPLETED
4401: , Eng_Workflow_Util.G_RT_TIME_OUT
4402: , Eng_Workflow_Util.G_RT_ABORTED )
4403: THEN
4396: l_set_start_date_flag := 1 ;
4397:
4398: ELSIF p_new_status_code IN ( Eng_Workflow_Util.G_RT_REJECTED
4399: , Eng_Workflow_Util.G_RT_APPROVED
4400: , Eng_Workflow_Util.G_RT_COMPLETED
4401: , Eng_Workflow_Util.G_RT_TIME_OUT
4402: , Eng_Workflow_Util.G_RT_ABORTED )
4403: THEN
4404:
4397:
4398: ELSIF p_new_status_code IN ( Eng_Workflow_Util.G_RT_REJECTED
4399: , Eng_Workflow_Util.G_RT_APPROVED
4400: , Eng_Workflow_Util.G_RT_COMPLETED
4401: , Eng_Workflow_Util.G_RT_TIME_OUT
4402: , Eng_Workflow_Util.G_RT_ABORTED )
4403: THEN
4404:
4405: l_set_end_date_flag := 1 ;
4398: ELSIF p_new_status_code IN ( Eng_Workflow_Util.G_RT_REJECTED
4399: , Eng_Workflow_Util.G_RT_APPROVED
4400: , Eng_Workflow_Util.G_RT_COMPLETED
4401: , Eng_Workflow_Util.G_RT_TIME_OUT
4402: , Eng_Workflow_Util.G_RT_ABORTED )
4403: THEN
4404:
4405: l_set_end_date_flag := 1 ;
4406:
4450: -- Check If this is Line Notification Workflow Routing
4451: -- Need to sync up with Line Status automatically
4452: --
4453: l_dist_line_ntf_wf_flag := FALSE ;
4454: IF ( Eng_Workflow_Util.Is_Line_Ntf_WF(p_route_id => p_route_id))
4455: THEN
4456:
4457: IF g_debug_flag THEN
4458: Write_Debug('Set Route Status for Line Notification Workflow Routing Flag. . .') ;
4463:
4464:
4465: IF (l_dist_line_ntf_wf_flag) THEN
4466:
4467: l_dist_line_status_code := Eng_Workflow_Util.ConvNtfWFStatToDistLNStat
4468: ( p_route_status_code => p_new_status_code
4469: , p_convert_type => 'WF_PROCESS' ) ;
4470:
4471:
4501: , x_msg_count => l_msg_count
4502: , x_msg_data => l_msg_data
4503: , p_init_msg_list => FND_API.G_FALSE
4504: , p_commit => FND_API.G_FALSE
4505: , p_action_type => Eng_Workflow_Util.G_LINE_ACT_CHG_STATUS
4506: , p_object_name => Eng_Workflow_Util.G_ENG_CHANGE_LINE
4507: , p_object_id1 => p_change_id
4508: , p_object_id2 => p_change_line_id
4509: , p_object_id3 => NULL
4502: , x_msg_data => l_msg_data
4503: , p_init_msg_list => FND_API.G_FALSE
4504: , p_commit => FND_API.G_FALSE
4505: , p_action_type => Eng_Workflow_Util.G_LINE_ACT_CHG_STATUS
4506: , p_object_name => Eng_Workflow_Util.G_ENG_CHANGE_LINE
4507: , p_object_id1 => p_change_id
4508: , p_object_id2 => p_change_line_id
4509: , p_object_id3 => NULL
4510: , p_object_id4 => NULL
4535: Write_Debug('Start Line Status Change Workflow. . .. ' );
4536: END IF ;
4537:
4538: -- Create and Start Line Status Change Workflow to send Resp FYI ntf
4539: Eng_Workflow_Util.StartWorkflow
4540: ( p_api_version => 1.0
4541: , p_init_msg_list => FND_API.G_FALSE
4542: , p_commit => FND_API.G_FALSE
4543: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
4543: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
4544: , x_return_status => l_return_status
4545: , x_msg_count => l_msg_count
4546: , x_msg_data => l_msg_data
4547: , p_item_type => Eng_Workflow_Util.G_CHANGE_LINE_ACTION_ITEM_TYPE
4548: , x_item_key => l_line_stat_chg_wf_key
4549: , p_process_name => Eng_Workflow_Util.G_STATUS_CHANGE_PROC
4550: , p_change_id => p_change_id
4551: , p_change_line_id => p_change_line_id
4545: , x_msg_count => l_msg_count
4546: , x_msg_data => l_msg_data
4547: , p_item_type => Eng_Workflow_Util.G_CHANGE_LINE_ACTION_ITEM_TYPE
4548: , x_item_key => l_line_stat_chg_wf_key
4549: , p_process_name => Eng_Workflow_Util.G_STATUS_CHANGE_PROC
4550: , p_change_id => p_change_id
4551: , p_change_line_id => p_change_line_id
4552: , p_wf_user_id => p_wf_user_id
4553: , p_host_url => NULL
4601: l_set_start_date_flag := 0 ;
4602: l_set_end_date_flag := 0 ;
4603:
4604:
4605: IF p_new_status_code = Eng_Workflow_Util.G_RT_IN_PROGRESS
4606: THEN
4607:
4608: l_set_start_date_flag := 1 ;
4609: l_required_date := GetStepRequiredDate(p_step_id => p_route_step_id) ;
4607:
4608: l_set_start_date_flag := 1 ;
4609: l_required_date := GetStepRequiredDate(p_step_id => p_route_step_id) ;
4610:
4611: ELSIF p_new_status_code IN ( Eng_Workflow_Util.G_RT_REJECTED
4612: , Eng_Workflow_Util.G_RT_APPROVED
4613: , Eng_Workflow_Util.G_RT_COMPLETED
4614: , Eng_Workflow_Util.G_RT_TIME_OUT)
4615: THEN
4608: l_set_start_date_flag := 1 ;
4609: l_required_date := GetStepRequiredDate(p_step_id => p_route_step_id) ;
4610:
4611: ELSIF p_new_status_code IN ( Eng_Workflow_Util.G_RT_REJECTED
4612: , Eng_Workflow_Util.G_RT_APPROVED
4613: , Eng_Workflow_Util.G_RT_COMPLETED
4614: , Eng_Workflow_Util.G_RT_TIME_OUT)
4615: THEN
4616:
4609: l_required_date := GetStepRequiredDate(p_step_id => p_route_step_id) ;
4610:
4611: ELSIF p_new_status_code IN ( Eng_Workflow_Util.G_RT_REJECTED
4612: , Eng_Workflow_Util.G_RT_APPROVED
4613: , Eng_Workflow_Util.G_RT_COMPLETED
4614: , Eng_Workflow_Util.G_RT_TIME_OUT)
4615: THEN
4616:
4617: l_set_end_date_flag := 1 ;
4610:
4611: ELSIF p_new_status_code IN ( Eng_Workflow_Util.G_RT_REJECTED
4612: , Eng_Workflow_Util.G_RT_APPROVED
4613: , Eng_Workflow_Util.G_RT_COMPLETED
4614: , Eng_Workflow_Util.G_RT_TIME_OUT)
4615: THEN
4616:
4617: l_set_end_date_flag := 1 ;
4618:
4634: raise no_data_found;
4635: end if;
4636:
4637:
4638: IF p_new_status_code = Eng_Workflow_Util.G_RT_IN_PROGRESS
4639: THEN
4640:
4641: -- R12B
4642: -- Check If this is Line Notification Workflow Routing
4641: -- R12B
4642: -- Check If this is Line Notification Workflow Routing
4643: -- Need to update assignee response code 'Not Received'
4644: --
4645: IF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE
4646: AND Eng_Workflow_Util.Is_Line_Ntf_WF(p_route_id => p_route_id)
4647: )
4648: THEN
4649:
4642: -- Check If this is Line Notification Workflow Routing
4643: -- Need to update assignee response code 'Not Received'
4644: --
4645: IF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE
4646: AND Eng_Workflow_Util.Is_Line_Ntf_WF(p_route_id => p_route_id)
4647: )
4648: THEN
4649:
4650: IF g_debug_flag THEN
4650: IF g_debug_flag THEN
4651: Write_Debug('Calling GetStepDefaultRespCode ' ) ;
4652: END IF ;
4653:
4654: Eng_Workflow_Util.GetStepDefaultRespCode
4655: ( p_step_id => p_route_step_id
4656: , x_default_resp_code => l_default_assignee_resp
4657: ) ;
4658:
4661: END IF ;
4662:
4663: ELSE
4664:
4665: l_default_assignee_resp := Eng_Workflow_Util.G_RT_SUBMITTED ;
4666:
4667: END IF ;
4668:
4669:
4676: where step_id = p_route_step_id
4677: and assignee_id <> -1
4678: and response_code IS NULL ;
4679:
4680: ELSIF p_new_status_code IN ( Eng_Workflow_Util.G_RT_REJECTED
4681: , Eng_Workflow_Util.G_RT_APPROVED
4682: , Eng_Workflow_Util.G_RT_COMPLETED
4683: , Eng_Workflow_Util.G_RT_TIME_OUT
4684: , Eng_Workflow_Util.G_RT_ABORTED
4677: and assignee_id <> -1
4678: and response_code IS NULL ;
4679:
4680: ELSIF p_new_status_code IN ( Eng_Workflow_Util.G_RT_REJECTED
4681: , Eng_Workflow_Util.G_RT_APPROVED
4682: , Eng_Workflow_Util.G_RT_COMPLETED
4683: , Eng_Workflow_Util.G_RT_TIME_OUT
4684: , Eng_Workflow_Util.G_RT_ABORTED
4685: )
4678: and response_code IS NULL ;
4679:
4680: ELSIF p_new_status_code IN ( Eng_Workflow_Util.G_RT_REJECTED
4681: , Eng_Workflow_Util.G_RT_APPROVED
4682: , Eng_Workflow_Util.G_RT_COMPLETED
4683: , Eng_Workflow_Util.G_RT_TIME_OUT
4684: , Eng_Workflow_Util.G_RT_ABORTED
4685: )
4686: THEN
4679:
4680: ELSIF p_new_status_code IN ( Eng_Workflow_Util.G_RT_REJECTED
4681: , Eng_Workflow_Util.G_RT_APPROVED
4682: , Eng_Workflow_Util.G_RT_COMPLETED
4683: , Eng_Workflow_Util.G_RT_TIME_OUT
4684: , Eng_Workflow_Util.G_RT_ABORTED
4685: )
4686: THEN
4687:
4680: ELSIF p_new_status_code IN ( Eng_Workflow_Util.G_RT_REJECTED
4681: , Eng_Workflow_Util.G_RT_APPROVED
4682: , Eng_Workflow_Util.G_RT_COMPLETED
4683: , Eng_Workflow_Util.G_RT_TIME_OUT
4684: , Eng_Workflow_Util.G_RT_ABORTED
4685: )
4686: THEN
4687:
4688: update ENG_CHANGE_ROUTE_PEOPLE set
4691: last_updated_by = p_wf_user_id,
4692: last_update_login = ''
4693: where step_id = p_route_step_id
4694: and assignee_id <> -1
4695: and ( response_code = Eng_Workflow_Util.G_RT_SUBMITTED
4696: OR response_code = Eng_Workflow_Util.G_RT_NOT_RECEIVED ) ;
4697:
4698: END IF ;
4699:
4692: last_update_login = ''
4693: where step_id = p_route_step_id
4694: and assignee_id <> -1
4695: and ( response_code = Eng_Workflow_Util.G_RT_SUBMITTED
4696: OR response_code = Eng_Workflow_Util.G_RT_NOT_RECEIVED ) ;
4697:
4698: END IF ;
4699:
4700: END SetRouteStepStatus ;
5053: -- Comment Out for 115.9 code
5054: -- because this URL does not work 510 OA Fwk
5055: -- Get Change Detail Page URL
5056: -- l_change_detail_url := 'JSP:/OA_HTML/'
5057: -- || Eng_Workflow_Util.GetFunctionWebHTMLCall
5058: -- (p_function_name => 'ENG_CHANGE_DETAIL_PAGE' )
5059: -- || '&changeId=-&CHANGE_ID-'
5060: -- || '&OAFunc=ENG_CHANGE_DETAIL_PAGE' ;
5061: --
5074:
5075: -- Comment Out for 115.9 code
5076: -- because this URL does not work 510 OA Fwk
5077: -- l_change_line_detail_url := 'JSP:/OA_HTML/'
5078: -- || Eng_Workflow_Util.GetFunctionWebHTMLCall
5079: -- (p_function_name => 'ENG_CHANGE_LINE_DETAIL_PAGE' )
5080: -- || '&changeLineId=-&CHANGE_LINE_ID-'
5081: -- || '&OAFunc=ENG_CHANGE_LINE_DETAIL_PAGE' ;
5082: --
5222: -- Change Reviewer Role
5223: I := I + 1 ;
5224: l_text_attr_name_tbl(I) := 'REVIEWERS_ROLE' ;
5225: l_text_attr_value_tbl(I) := GetWFAdhocRoleName
5226: ( p_role_prefix => Eng_Workflow_Util.G_REV_ROLE
5227: , p_item_type => p_item_type
5228: , p_item_key => p_item_key ) ;
5229:
5230:
5231: -- Change Assignee Role
5232: I := I + 1 ;
5233: l_text_attr_name_tbl(I) := 'ASSIGNEE_ROLE' ;
5234: l_text_attr_value_tbl(I) := GetWFAdhocRoleName
5235: ( p_role_prefix => Eng_Workflow_Util.G_ASSIGNEE_ROLE
5236: , p_item_type => p_item_type
5237: , p_item_key => p_item_key ) ;
5238:
5239:
5260: -- Change Adhoc Party Role
5261: I := I + 1 ;
5262: l_text_attr_name_tbl(I) := 'ADHOC_PARTY_ROLE' ;
5263: l_text_attr_value_tbl(I) := GetWFAdhocRoleName
5264: ( p_role_prefix => Eng_Workflow_Util.G_ADHOC_PARTY_ROLE
5265: , p_item_type => p_item_type
5266: , p_item_key => p_item_key ) ;
5267:
5268:
5313: -- Change Route People Party Role
5314: I := I + 1 ;
5315: l_text_attr_name_tbl(I) := 'ROUTE_PEOPLE_ROLE' ;
5316: l_text_attr_value_tbl(I) := GetWFAdhocRoleName
5317: ( p_role_prefix => Eng_Workflow_Util.G_ROUTE_PEOPLE_ROLE
5318: , p_item_type => p_item_type
5319: , p_item_key => p_item_key ) ;
5320:
5321:
5350: -- Change Route People Party Role
5351: I := I + 1 ;
5352: l_text_attr_name_tbl(I) := 'ROUTE_PEOPLE_ROLE' ;
5353: l_text_attr_value_tbl(I) := GetWFAdhocRoleName
5354: ( p_role_prefix => Eng_Workflow_Util.G_ROUTE_PEOPLE_ROLE
5355: , p_item_type => p_item_type
5356: , p_item_key => p_item_key ) ;
5357:
5358:
5359: -- Change Route Step People Role
5360: I := I + 1 ;
5361: l_text_attr_name_tbl(I) := 'STEP_PEOPLE_ROLE' ;
5362: l_text_attr_value_tbl(I) := GetWFAdhocRoleName
5363: ( p_role_prefix => Eng_Workflow_Util.G_STEP_PEOPLE_ROLE
5364: , p_item_type => p_item_type
5365: , p_item_key => p_item_key ) ;
5366:
5367:
5412: -- Line Reviewer Role
5413: I := I + 1 ;
5414: l_text_attr_name_tbl(I) := 'LINE_REVIEWERS_ROLE' ;
5415: l_text_attr_value_tbl(I) := GetWFAdhocRoleName
5416: ( p_role_prefix => Eng_Workflow_Util.G_LINE_REV_ROLE
5417: , p_item_type => p_item_type
5418: , p_item_key => p_item_key ) ;
5419:
5420: -- Line Assignee Role
5420: -- Line Assignee Role
5421: I := I + 1 ;
5422: l_text_attr_name_tbl(I) := 'LINE_ASSIGNEE_ROLE' ;
5423: l_text_attr_value_tbl(I) := GetWFAdhocRoleName
5424: ( p_role_prefix => Eng_Workflow_Util.G_LINE_ASSIGNEE_ROLE
5425: , p_item_type => p_item_type
5426: , p_item_key => p_item_key ) ;
5427:
5428: -- Line Object Name
5826:
5827: SELECT 'Can not be started'
5828: FROM ENG_CHANGE_ROUTES
5829: WHERE route_id = p_route_id
5830: AND status_code <> Eng_Workflow_Util.G_RT_NOT_STARTED ;
5831:
5832: CURSOR c_route_instance (p_route_id NUMBER)
5833: IS
5834:
5834:
5835: SELECT 'Can not be started'
5836: FROM ENG_CHANGE_ROUTES
5837: WHERE route_id = p_route_id
5838: AND template_flag <> Eng_Workflow_Util.G_RT_INSTANCE ;
5839:
5840:
5841: l_return_status VARCHAR2(1) ;
5842:
5938: FROM ENG_CHANGE_ROUTE_STEPS step
5939: WHERE EXISTS (SELECT 'Invalid Assignee Exists'
5940: FROM ENG_CHANGE_ROUTE_PEOPLE people
5941: WHERE people.assignee_id = -1
5942: AND people.assignee_type_code = Eng_Workflow_Util.G_PERSON
5943: AND people.step_id = step.step_id )
5944: AND step.route_id = p_route_id ;
5945:
5946:
6431:
6432: ELSE
6433:
6434: -- Return N as None
6435: x_return_status := Eng_Workflow_Util.G_RET_STS_NONE;
6436:
6437: END IF;
6438:
6439: EXCEPTION
6478: BEGIN
6479:
6480:
6481: IF g_debug_flag THEN
6482: Write_Debug('Eng_Workflow_Util.SetAssigneeRole Log');
6483: Write_Debug('-----------------------------------------------------');
6484: Write_Debug('Item Type : ' || p_item_type );
6485: Write_Debug('Item Key : ' || p_item_key );
6486: Write_Debug('-----------------------------------------------------');
6546:
6547: ELSE
6548:
6549: -- Return N as None
6550: x_return_status := Eng_Workflow_Util.G_RET_STS_NONE ;
6551:
6552: END IF;
6553:
6554: EXCEPTION
6598: BEGIN
6599:
6600:
6601: IF g_debug_flag THEN
6602: Write_Debug('Eng_Workflow_Util.SetReviewersRole Log');
6603: Write_Debug('-----------------------------------------------------');
6604: Write_Debug('Item Type : ' || p_item_type );
6605: Write_Debug('Item Key : ' || p_item_key );
6606: Write_Debug('Reviewer Type : ' || p_reviewer_type );
6715:
6716: ELSE
6717:
6718: -- Return N as None
6719: x_return_status := Eng_Workflow_Util.G_RET_STS_NONE ;
6720:
6721: END IF;
6722:
6723: EXCEPTION
6779: BEGIN
6780:
6781:
6782: IF g_debug_flag THEN
6783: Write_Debug('Eng_Workflow_Util.StartAllLineWorkflows');
6784: Write_Debug('-----------------------------------------------------');
6785: Write_Debug('Item Type : ' || p_item_type );
6786: Write_Debug('Item Key : ' || p_item_key );
6787: Write_Debug('Change Id : ' || TO_CHAR(p_change_id) );
6812: l_line_item_key := null ;
6813:
6814: -- Start Change Line Workflows
6815: -- FND_MSG_PUB.initialize ;
6816: Eng_Workflow_Util.StartWorkflow
6817: ( p_api_version => 1.0
6818: , p_init_msg_list => FND_API.G_FALSE
6819: , p_commit => FND_API.G_FALSE
6820: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
6841:
6842: END IF ;
6843:
6844: IF g_debug_flag THEN
6845: Write_Debug('After call Eng_Workflow_Util.StartWorkflow' ) ;
6846: Write_Debug('Return Status: ' || l_return_status ) ;
6847: Write_Debug('Return Message: ' || x_msg_data ) ;
6848: Write_Debug('Started Change Line Id : ' || TO_CHAR(line_rec.change_line_id) ) ;
6849: Write_Debug('Started CL WF Item Type: ' || p_line_item_type ) ;
6913: BEGIN
6914:
6915:
6916: IF g_debug_flag THEN
6917: Write_Debug('Eng_Workflow_Util.SetLineAssigneeRole Log');
6918: Write_Debug('-----------------------------------------------------');
6919: Write_Debug('Item Type : ' || p_item_type );
6920: Write_Debug('Item Key : ' || p_item_key );
6921: Write_Debug('-----------------------------------------------------');
6976:
6977: ELSE
6978:
6979: -- Return N as None
6980: x_return_status := Eng_Workflow_Util.G_RET_STS_NONE ;
6981:
6982: END IF;
6983:
6984: EXCEPTION
7031: BEGIN
7032:
7033:
7034: IF g_debug_flag THEN
7035: Write_Debug('Eng_Workflow_Util.SetLineReviewersRole Log');
7036: Write_Debug('-----------------------------------------------------');
7037: Write_Debug('Item Type : ' || p_item_type );
7038: Write_Debug('Item Key : ' || p_item_key );
7039: Write_Debug('Reviewer Type : ' || p_reviewer_type );
7158:
7159: ELSE
7160:
7161: -- Return N as None
7162: x_return_status := Eng_Workflow_Util.G_RET_STS_NONE ;
7163:
7164: END IF;
7165:
7166: EXCEPTION
7212: BEGIN
7213:
7214:
7215: IF g_debug_flag THEN
7216: Write_Debug('Eng_Workflow_Util.SetRoutePeopleRole Log');
7217: Write_Debug('-----------------------------------------------------');
7218: Write_Debug('Item Type : ' || p_item_type );
7219: Write_Debug('Item Key : ' || p_item_key );
7220: Write_Debug('-----------------------------------------------------');
7284:
7285: ELSE
7286:
7287: -- Return N as None
7288: x_return_status := Eng_Workflow_Util.G_RET_STS_NONE;
7289:
7290: END IF;
7291:
7292: EXCEPTION
7338: BEGIN
7339:
7340:
7341: IF g_debug_flag THEN
7342: Write_Debug('Eng_Workflow_Util.SetStepPeopleRole Log');
7343: Write_Debug('-----------------------------------------------------');
7344: Write_Debug('Item Type : ' || p_item_type );
7345: Write_Debug('Item Key : ' || p_item_key );
7346: Write_Debug('-----------------------------------------------------');
7396:
7397: ELSE
7398:
7399: -- Return N as None
7400: x_return_status := Eng_Workflow_Util.G_RET_STS_NONE;
7401:
7402: END IF;
7403:
7404: EXCEPTION
7459: -- G_LINE_ASSIGNEE_ROLE
7460:
7461: I := I + 1 ;
7462: l_role_names(I) := GetWFAdhocRoleName
7463: ( p_role_prefix => Eng_Workflow_Util.G_ADHOC_PARTY_ROLE
7464: , p_item_type => p_item_type
7465: , p_item_key => p_item_key ) ;
7466:
7467: I := I + 1 ;
7465: , p_item_key => p_item_key ) ;
7466:
7467: I := I + 1 ;
7468: l_role_names(I) := GetWFAdhocRoleName
7469: ( p_role_prefix => Eng_Workflow_Util.G_REV_ROLE
7470: , p_item_type => p_item_type
7471: , p_item_key => p_item_key ) ;
7472:
7473:
7472:
7473:
7474: I := I + 1 ;
7475: l_role_names(I) := GetWFAdhocRoleName
7476: ( p_role_prefix => Eng_Workflow_Util.G_ASSIGNEE_ROLE
7477: , p_item_type => p_item_type
7478: , p_item_key => p_item_key ) ;
7479:
7480: I := I + 1 ;
7478: , p_item_key => p_item_key ) ;
7479:
7480: I := I + 1 ;
7481: l_role_names(I) := GetWFAdhocRoleName
7482: ( p_role_prefix => Eng_Workflow_Util.G_OWNER_ROLE
7483: , p_item_type => p_item_type
7484: , p_item_key => p_item_key ) ;
7485:
7486: I := I + 1 ;
7484: , p_item_key => p_item_key ) ;
7485:
7486: I := I + 1 ;
7487: l_role_names(I) := GetWFAdhocRoleName
7488: ( p_role_prefix => Eng_Workflow_Util.G_ROUTE_PEOPLE_ROLE
7489: , p_item_type => p_item_type
7490: , p_item_key => p_item_key ) ;
7491:
7492:
7491:
7492:
7493: I := I + 1 ;
7494: l_role_names(I) := GetWFAdhocRoleName
7495: ( p_role_prefix => Eng_Workflow_Util.G_STEP_PEOPLE_ROLE
7496: , p_item_type => p_item_type
7497: , p_item_key => p_item_key ) ;
7498:
7499: I := I + 1 ;
7497: , p_item_key => p_item_key ) ;
7498:
7499: I := I + 1 ;
7500: l_role_names(I) := GetWFAdhocRoleName
7501: ( p_role_prefix => Eng_Workflow_Util.G_LINE_REV_ROLE
7502: , p_item_type => p_item_type
7503: , p_item_key => p_item_key ) ;
7504:
7505: I := I + 1 ;
7503: , p_item_key => p_item_key ) ;
7504:
7505: I := I + 1 ;
7506: l_role_names(I) := GetWFAdhocRoleName
7507: ( p_role_prefix => Eng_Workflow_Util.G_LINE_ASSIGNEE_ROLE
7508: , p_item_type => p_item_type
7509: , p_item_key => p_item_key ) ;
7510:
7511:
7575:
7576: BEGIN
7577:
7578: --IF g_debug_flag THEN
7579: -- Write_Debug('Eng_Workflow_Util.CreateAction Log');
7580: -- Write_Debug('-----------------------------------------------------');
7581: -- Write_Debug('Item Type : ' || p_item_type );
7582: -- Write_Debug('Item Key : ' || p_item_key );
7583: -- Write_Debug('Action Type : ' || p_action_type );
7596: ) ;
7597:
7598:
7599: -- Get Action Id and set this as parent action id
7600: Eng_Workflow_Util.GetActionId
7601: ( p_item_type => p_item_type
7602: , p_item_key => p_item_key
7603: , x_action_id => l_parent_action_id
7604: ) ;
7609: -- ( p_change_id => l_change_id ) ;
7610:
7611: -- R12B
7612: -- Get Route Object Name
7613: Eng_Workflow_Util.GetRouteObject
7614: ( p_item_type => p_item_type
7615: , p_item_key => p_item_key
7616: , x_route_object => l_object_name
7617: ) ;
7617: ) ;
7618:
7619:
7620: -- Get Change Line Object Identifier
7621: Eng_Workflow_Util.GetChangeLineObject
7622: ( p_item_type => p_item_type
7623: , p_item_key => p_item_key
7624: , x_change_line_id => l_change_line_id
7625: ) ;
7777: , OBJECT_NAME
7778: , OBJECT_ID1
7779: FROM ENG_CHANGE_ROUTES
7780: WHERE ROUTE_ID = p_route_id
7781: AND TEMPLATE_FLAG = Eng_Workflow_Util.G_RT_INSTANCE ;
7782:
7783: BEGIN
7784:
7785: IF g_debug_flag THEN
7782:
7783: BEGIN
7784:
7785: IF g_debug_flag THEN
7786: Write_Debug('Eng_Workflow_Util.CreateRouteAction Log');
7787: Write_Debug('-----------------------------------------------------');
7788: Write_Debug('Change Id : ' || TO_CHAR(p_change_id));
7789: Write_Debug('Change Line Id : ' || TO_CHAR(p_change_line_id));
7790: Write_Debug('Action Type : ' || p_action_type );
7930: , OBJECT_NAME
7931: , OBJECT_ID1
7932: FROM ENG_CHANGE_ROUTES
7933: WHERE ROUTE_ID = p_route_id
7934: AND TEMPLATE_FLAG = Eng_Workflow_Util.G_RT_INSTANCE ;
7935:
7936: BEGIN
7937:
7938: IF g_debug_flag THEN
7935:
7936: BEGIN
7937:
7938: IF g_debug_flag THEN
7939: Write_Debug('Eng_Workflow_Util.SyncChangeLCPhase Log');
7940: Write_Debug('-----------------------------------------------------');
7941: Write_Debug('Route Id : ' || TO_CHAR(p_route_id));
7942: Write_Debug('-----------------------------------------------------');
7943: END IF ;
8089: , WF_ITEMS wi
8090: WHERE wi.end_date IS NULL
8091: AND wi.item_key = ecr.wf_item_key
8092: AND wi.item_type = ecr.wf_item_type
8093: AND ecr.status_code = Eng_Workflow_Util.G_RT_IN_PROGRESS
8094: AND ecr.route_id = eec.route_id
8095: AND eec.approval_status_type = Eng_Workflow_Util.G_REQUESTED
8096: AND eec.change_id = p_change_id ;
8097:
8091: AND wi.item_key = ecr.wf_item_key
8092: AND wi.item_type = ecr.wf_item_type
8093: AND ecr.status_code = Eng_Workflow_Util.G_RT_IN_PROGRESS
8094: AND ecr.route_id = eec.route_id
8095: AND eec.approval_status_type = Eng_Workflow_Util.G_REQUESTED
8096: AND eec.change_id = p_change_id ;
8097:
8098:
8099: CURSOR c_line_route_wf (p_change_id NUMBER)
8105: , WF_ITEMS wi
8106: WHERE wi.end_date IS NULL
8107: AND wi.item_key = ecr.wf_item_key
8108: AND wi.item_type = ecr.wf_item_type
8109: AND ecr.status_code = Eng_Workflow_Util.G_RT_IN_PROGRESS
8110: AND ecr.route_id = ecl.route_id
8111: -- AND ecl.parent_line_id IS NULL
8112: AND ecl.approval_status_type = Eng_Workflow_Util.G_REQUESTED
8113: AND ecl.sequence_number <> -1
8108: AND wi.item_type = ecr.wf_item_type
8109: AND ecr.status_code = Eng_Workflow_Util.G_RT_IN_PROGRESS
8110: AND ecr.route_id = ecl.route_id
8111: -- AND ecl.parent_line_id IS NULL
8112: AND ecl.approval_status_type = Eng_Workflow_Util.G_REQUESTED
8113: AND ecl.sequence_number <> -1
8114: AND ecl.change_type_id <> -1
8115: AND ecl.change_id = p_change_id ;
8116:
8118:
8119: BEGIN
8120:
8121: IF g_debug_flag THEN
8122: Write_Debug('Eng_Workflow_Util.CreateRouteAction Log');
8123: Write_Debug('-----------------------------------------------------');
8124: Write_Debug('Change Id : ' || TO_CHAR(p_change_id));
8125: Write_Debug('Change Line Id : ' || TO_CHAR(p_change_line_id));
8126: Write_Debug('Route Id : ' || TO_CHAR(p_route_id));
8323: , WF_NOTIFICATIONS wn
8324: WHERE RoutePeople.assignee_id = EngSecPeople.person_id
8325: AND RoutePeople.step_id = p_step_id
8326: AND EngSecPeople.user_name = wn.recipient_role
8327: AND ( RoutePeople.response_code <> Eng_Workflow_Util.G_ACT_DELEGATED
8328: AND RoutePeople.response_code <> Eng_Workflow_Util.G_RT_TRANSFERRED
8329: AND RoutePeople.response_code <> Eng_Workflow_Util.G_RT_FORWARDED
8330: AND RoutePeople.response_code <> Eng_Workflow_Util.G_ACT_TRANSFERRED ) -- Bug 11802032
8331: AND wn.notification_id = p_notification_id
8324: WHERE RoutePeople.assignee_id = EngSecPeople.person_id
8325: AND RoutePeople.step_id = p_step_id
8326: AND EngSecPeople.user_name = wn.recipient_role
8327: AND ( RoutePeople.response_code <> Eng_Workflow_Util.G_ACT_DELEGATED
8328: AND RoutePeople.response_code <> Eng_Workflow_Util.G_RT_TRANSFERRED
8329: AND RoutePeople.response_code <> Eng_Workflow_Util.G_RT_FORWARDED
8330: AND RoutePeople.response_code <> Eng_Workflow_Util.G_ACT_TRANSFERRED ) -- Bug 11802032
8331: AND wn.notification_id = p_notification_id
8332: AND ( ( p_chg_rte_cnt_nonull_ntfid > 0 and RoutePeople.wf_notification_id = p_notification_id )
8325: AND RoutePeople.step_id = p_step_id
8326: AND EngSecPeople.user_name = wn.recipient_role
8327: AND ( RoutePeople.response_code <> Eng_Workflow_Util.G_ACT_DELEGATED
8328: AND RoutePeople.response_code <> Eng_Workflow_Util.G_RT_TRANSFERRED
8329: AND RoutePeople.response_code <> Eng_Workflow_Util.G_RT_FORWARDED
8330: AND RoutePeople.response_code <> Eng_Workflow_Util.G_ACT_TRANSFERRED ) -- Bug 11802032
8331: AND wn.notification_id = p_notification_id
8332: AND ( ( p_chg_rte_cnt_nonull_ntfid > 0 and RoutePeople.wf_notification_id = p_notification_id )
8333: OR ( p_chg_rte_cnt_nonull_ntfid = 0 and RoutePeople.wf_notification_id is null)) ;
8326: AND EngSecPeople.user_name = wn.recipient_role
8327: AND ( RoutePeople.response_code <> Eng_Workflow_Util.G_ACT_DELEGATED
8328: AND RoutePeople.response_code <> Eng_Workflow_Util.G_RT_TRANSFERRED
8329: AND RoutePeople.response_code <> Eng_Workflow_Util.G_RT_FORWARDED
8330: AND RoutePeople.response_code <> Eng_Workflow_Util.G_ACT_TRANSFERRED ) -- Bug 11802032
8331: AND wn.notification_id = p_notification_id
8332: AND ( ( p_chg_rte_cnt_nonull_ntfid > 0 and RoutePeople.wf_notification_id = p_notification_id )
8333: OR ( p_chg_rte_cnt_nonull_ntfid = 0 and RoutePeople.wf_notification_id is null)) ;
8334: --Bug 11802032 End
8374: ) ;
8375:
8376:
8377: IF g_debug_flag THEN
8378: Write_Debug('Eng_Workflow_Util.SetRouteResponse Log');
8379: Write_Debug('-----------------------------------------------------');
8380: Write_Debug('Item Type : ' || p_item_type );
8381: Write_Debug('Item Key : ' || p_item_key );
8382: Write_Debug('NTF Id : ' || to_char(p_notification_id) );
8591: -- In case that Route Object is Change Object
8592: IF l_change_id IS NOT NULL AND l_change_id > 0
8593: THEN
8594:
8595: l_action_type := Eng_Workflow_Util.ConvertRouteStatusToActionType
8596: ( p_route_status_code => p_response_code
8597: , p_convert_type => 'RESPONSE' ) ;
8598:
8599: -- Record Action
8596: ( p_route_status_code => p_response_code
8597: , p_convert_type => 'RESPONSE' ) ;
8598:
8599: -- Record Action
8600: Eng_Workflow_Util.CreateAction
8601: ( x_return_status => l_return_status
8602: , x_msg_count => l_msg_count
8603: , x_msg_data => l_msg_data
8604: , p_item_type => p_item_type
8648: IF g_debug_flag THEN
8649: Write_Debug('Result is null and call RespondToDuplicateNtf: ' || dup_ntf_rec.NOTIFICATION_ID ) ;
8650: END IF ;
8651:
8652: Eng_Workflow_Util.RespondToDuplicateNtf( p_dupllicate_ntf_id => dup_ntf_rec.notification_id
8653: , p_orig_ntf_id => p_notification_id
8654: , p_responder => dup_ntf_rec.RECIPIENT_ROLE
8655: ) ;
8656: END IF ;
8674: -- If the response is the value specified in AUTO_REVOKE_RESPONSE NTF Attribute
8675: -- we will revoke roles on this wf assignee
8676: -- Record Route Response
8677: IF ( p_funcmode = 'RESPOND'
8678: AND ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
8679: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE
8680: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE
8681: )
8682: )
8675: -- we will revoke roles on this wf assignee
8676: -- Record Route Response
8677: IF ( p_funcmode = 'RESPOND'
8678: AND ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
8679: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE
8680: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE
8681: )
8682: )
8683: THEN
8676: -- Record Route Response
8677: IF ( p_funcmode = 'RESPOND'
8678: AND ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
8679: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE
8680: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE
8681: )
8682: )
8683: THEN
8684:
8705: THEN
8706:
8707: l_obj_index := 0 ;
8708: l_person_idx := 0 ;
8709: IF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE )
8710: THEN
8711: l_obj_index := l_obj_index + 1 ;
8712: l_target_obj_tbl.EXTEND ;
8713: l_target_obj_tbl(l_obj_index) := G_DOM_DOCUMENT_REVISION ;
8718: l_person_id_tbl(l_person_idx + 1) := l_performer_party_id ;
8719:
8720:
8721: IF g_debug_flag THEN
8722: Write_Debug('Calling Eng_Workflow_Util.RevokeObjectRoles for this assignee: ' || l_performer_party_id );
8723: END IF ;
8724:
8725:
8726: Eng_Workflow_Util.RevokeObjectRoles
8722: Write_Debug('Calling Eng_Workflow_Util.RevokeObjectRoles for this assignee: ' || l_performer_party_id );
8723: END IF ;
8724:
8725:
8726: Eng_Workflow_Util.RevokeObjectRoles
8727: ( p_api_version => 1.0
8728: , p_init_msg_list => FND_API.G_FALSE --
8729: , p_commit => FND_API.G_FALSE --
8730: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
8744: , p_revoke_option => NULL
8745: ) ;
8746:
8747: IF g_debug_flag THEN
8748: Write_Debug('After Eng_Workflow_Util.RevokeObjectRoles.' || l_return_status );
8749: END IF ;
8750:
8751: --
8752: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
8763: EXCEPTION
8764: WHEN OTHERS THEN
8765:
8766: IF g_debug_flag THEN
8767: Write_Debug('Eng_Workflow_Util.SetRouteResponse Unxexpected Error.' || SQLERRM);
8768: END IF ;
8769:
8770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8771:
8811: wf_item_type,
8812: wf_process_name
8813: FROM ENG_CHANGE_ROUTE_STEPS
8814: WHERE route_id = p_route_id
8815: AND step_status_code = Eng_Workflow_Util.G_RT_NOT_STARTED
8816: AND step_start_date IS NULL
8817: AND step_end_date IS NULL
8818: ORDER BY 2 ASC ;
8819:
8903:
8904: BEGIN
8905:
8906: IF g_debug_flag THEN
8907: Write_Debug('Eng_Workflow_Util.StartNextRouteStep Log');
8908: Write_Debug('-----------------------------------------------------');
8909: Write_Debug('Route Item Type : ' || p_route_item_type );
8910: Write_Debug('Route Item Key : ' || p_route_item_key );
8911: Write_Debug('Route Id : ' || TO_CHAR(p_route_id) );
8938:
8939:
8940: IF x_step_id IS NULL THEN
8941:
8942: x_return_status := Eng_Workflow_Util.G_RET_STS_NONE ;
8943: RETURN ;
8944:
8945: END IF ;
8946:
8945: END IF ;
8946:
8947:
8948: -- FND_MSG_PUB.initialize ;
8949: Eng_Workflow_Util.StartWorkflow
8950: ( p_api_version => 1.0
8951: , p_init_msg_list => FND_API.G_FALSE
8952: , p_commit => FND_API.G_FALSE
8953: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
8986:
8987: END IF ;
8988:
8989: IF g_debug_flag THEN
8990: Write_Debug('After call Eng_Workflow_Util.StartWorkflow' ) ;
8991: Write_Debug('Return Status: ' || x_return_status ) ;
8992: Write_Debug('Return Message: ' || x_msg_data ) ;
8993: Write_Debug('Started Step Id : ' || x_step_id ) ;
8994: Write_Debug('Started Step WF Item Type: ' || x_step_item_type ) ;
9045: , wi.root_activity wf_process_name
9046: FROM WF_ITEMS wi
9047: WHERE wi.parent_item_type = p_route_item_type
9048: AND wi.parent_item_key = p_route_item_key
9049: AND wi.item_type IN ( Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
9050: , Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE
9051: , Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE )
9052: AND wi.end_date IS NULL ;
9053:
9046: FROM WF_ITEMS wi
9047: WHERE wi.parent_item_type = p_route_item_type
9048: AND wi.parent_item_key = p_route_item_key
9049: AND wi.item_type IN ( Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
9050: , Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE
9051: , Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE )
9052: AND wi.end_date IS NULL ;
9053:
9054: BEGIN
9047: WHERE wi.parent_item_type = p_route_item_type
9048: AND wi.parent_item_key = p_route_item_key
9049: AND wi.item_type IN ( Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
9050: , Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE
9051: , Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE )
9052: AND wi.end_date IS NULL ;
9053:
9054: BEGIN
9055:
9053:
9054: BEGIN
9055:
9056: IF g_debug_flag THEN
9057: Write_Debug('Eng_Workflow_Util.AbortRouteStepsLog');
9058: Write_Debug('-----------------------------------------------------');
9059: Write_Debug('Route Item Type : ' || p_route_item_type );
9060: Write_Debug('Route Item Key : ' || p_route_item_key );
9061: Write_Debug('-----------------------------------------------------');
9075: Write_Debug('Step Item Key : ' || abort_step_rec.wf_item_key);
9076: END IF ;
9077:
9078:
9079: Eng_Workflow_Util.AbortWorkflow
9080: ( p_api_version => 1.0
9081: , p_init_msg_list => FND_API.G_FALSE
9082: , p_commit => FND_API.G_FALSE
9083: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
9105:
9106: END LOOP ;
9107:
9108: IF g_debug_flag THEN
9109: Write_Debug('After call Eng_Workflow_Util.AbortWorkflow' ) ;
9110: Write_Debug('Return Status: ' || x_return_status ) ;
9111: Write_Debug('Return Message: ' || x_msg_data ) ;
9112: END IF ;
9113:
9248: , ecr.wf_item_type
9249: , ecr.wf_process_name
9250: FROM ENG_CHANGE_LINES ecl
9251: , ENG_CHANGE_ROUTES ecr
9252: WHERE ( ecl.status_code <> Eng_Workflow_Util.G_CL_COMPLETED
9253: AND ecl.status_code <> Eng_Workflow_Util.G_CL_CANCELLED )
9254: AND ( ecl.approval_status_type <> Eng_Workflow_Util.G_APPROVED
9255: AND ecl.approval_status_type <> Eng_Workflow_Util.G_REQUESTED )
9256: AND ecl.sequence_number <> -1
9249: , ecr.wf_process_name
9250: FROM ENG_CHANGE_LINES ecl
9251: , ENG_CHANGE_ROUTES ecr
9252: WHERE ( ecl.status_code <> Eng_Workflow_Util.G_CL_COMPLETED
9253: AND ecl.status_code <> Eng_Workflow_Util.G_CL_CANCELLED )
9254: AND ( ecl.approval_status_type <> Eng_Workflow_Util.G_APPROVED
9255: AND ecl.approval_status_type <> Eng_Workflow_Util.G_REQUESTED )
9256: AND ecl.sequence_number <> -1
9257: -- AND ecl.parent_line_id IS NULL
9250: FROM ENG_CHANGE_LINES ecl
9251: , ENG_CHANGE_ROUTES ecr
9252: WHERE ( ecl.status_code <> Eng_Workflow_Util.G_CL_COMPLETED
9253: AND ecl.status_code <> Eng_Workflow_Util.G_CL_CANCELLED )
9254: AND ( ecl.approval_status_type <> Eng_Workflow_Util.G_APPROVED
9255: AND ecl.approval_status_type <> Eng_Workflow_Util.G_REQUESTED )
9256: AND ecl.sequence_number <> -1
9257: -- AND ecl.parent_line_id IS NULL
9258: -- AND ecr.status_code = Eng_Workflow_Util.G_RT_NOT_STARTED
9251: , ENG_CHANGE_ROUTES ecr
9252: WHERE ( ecl.status_code <> Eng_Workflow_Util.G_CL_COMPLETED
9253: AND ecl.status_code <> Eng_Workflow_Util.G_CL_CANCELLED )
9254: AND ( ecl.approval_status_type <> Eng_Workflow_Util.G_APPROVED
9255: AND ecl.approval_status_type <> Eng_Workflow_Util.G_REQUESTED )
9256: AND ecl.sequence_number <> -1
9257: -- AND ecl.parent_line_id IS NULL
9258: -- AND ecr.status_code = Eng_Workflow_Util.G_RT_NOT_STARTED
9259: AND ecl.change_type_id <> -1
9254: AND ( ecl.approval_status_type <> Eng_Workflow_Util.G_APPROVED
9255: AND ecl.approval_status_type <> Eng_Workflow_Util.G_REQUESTED )
9256: AND ecl.sequence_number <> -1
9257: -- AND ecl.parent_line_id IS NULL
9258: -- AND ecr.status_code = Eng_Workflow_Util.G_RT_NOT_STARTED
9259: AND ecl.change_type_id <> -1
9260: AND ecl.route_id = ecr.route_id
9261: AND ecl.change_id = p_change_id ;
9262:
9263:
9264: BEGIN
9265:
9266: IF g_debug_flag THEN
9267: Write_Debug('Eng_Workflow_Util.StartLineRoutes');
9268: Write_Debug('-----------------------------------------------------');
9269: Write_Debug('Item Type : ' || p_item_type );
9270: Write_Debug('Item Key : ' || p_item_key );
9271: Write_Debug('Change Id : ' || TO_CHAR(p_change_id) );
9272: Write_Debug('-----------------------------------------------------');
9273: END IF ;
9274:
9275: -- Initialize API return status to None:N
9276: l_return_status := Eng_Workflow_Util.G_RET_STS_NONE ;
9277: x_return_status := Eng_Workflow_Util.G_RET_STS_NONE ;
9278:
9279: --
9280: -- Don't try to get Parent Item Attributes from this procedure
9273: END IF ;
9274:
9275: -- Initialize API return status to None:N
9276: l_return_status := Eng_Workflow_Util.G_RET_STS_NONE ;
9277: x_return_status := Eng_Workflow_Util.G_RET_STS_NONE ;
9278:
9279: --
9280: -- Don't try to get Parent Item Attributes from this procedure
9281: -- because this proc is setting PRAGMA AUTONOMOUS_TRANSACTION
9292: l_line_item_key := null ;
9293:
9294: -- Start Change Line Workflows
9295: -- FND_MSG_PUB.initialize ;
9296: Eng_Workflow_Util.StartWorkflow
9297: ( p_api_version => 1.0
9298: , p_init_msg_list => FND_API.G_FALSE
9299: , p_commit => FND_API.G_FALSE
9300: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
9321:
9322: END IF ;
9323:
9324: IF g_debug_flag THEN
9325: Write_Debug('After call Eng_Workflow_Util.StartWorkflow' ) ;
9326: Write_Debug('Return Status: ' || l_return_status ) ;
9327: Write_Debug('Return Message: ' || x_msg_data ) ;
9328: Write_Debug('Started Change Line Id : ' || TO_CHAR(line_rec.change_line_id) ) ;
9329: Write_Debug('Started CL WF Item Type: ' || line_rec.wf_item_type) ;
9336:
9337:
9338:
9339: IF x_return_status = FND_API.G_RET_STS_SUCCESS
9340: OR x_return_status = Eng_Workflow_Util.G_RET_STS_NONE
9341: THEN
9342:
9343: COMMIT ;
9344:
9390: SELECT 'Non Approved Line Exists'
9391: FROM DUAL
9392: WHERE EXISTS ( SELECT null
9393: FROM ENG_CHANGE_LINES ecl
9394: WHERE ( ecl.status_code <> Eng_Workflow_Util.G_CL_COMPLETED
9395: AND ecl.status_code <> Eng_Workflow_Util.G_CL_CANCELLED )
9396: AND ecl.approval_status_type <> Eng_Workflow_Util.G_APPROVED
9397: AND ecl.change_type_id <> -1
9398: AND ecl.sequence_number <> -1
9391: FROM DUAL
9392: WHERE EXISTS ( SELECT null
9393: FROM ENG_CHANGE_LINES ecl
9394: WHERE ( ecl.status_code <> Eng_Workflow_Util.G_CL_COMPLETED
9395: AND ecl.status_code <> Eng_Workflow_Util.G_CL_CANCELLED )
9396: AND ecl.approval_status_type <> Eng_Workflow_Util.G_APPROVED
9397: AND ecl.change_type_id <> -1
9398: AND ecl.sequence_number <> -1
9399: -- AND ecl.parent_line_id IS NULL
9392: WHERE EXISTS ( SELECT null
9393: FROM ENG_CHANGE_LINES ecl
9394: WHERE ( ecl.status_code <> Eng_Workflow_Util.G_CL_COMPLETED
9395: AND ecl.status_code <> Eng_Workflow_Util.G_CL_CANCELLED )
9396: AND ecl.approval_status_type <> Eng_Workflow_Util.G_APPROVED
9397: AND ecl.change_type_id <> -1
9398: AND ecl.sequence_number <> -1
9399: -- AND ecl.parent_line_id IS NULL
9400: AND ecl.route_id IS NOT NULL
9406:
9407: -- Initialize API return status to success
9408: x_return_status := FND_API.G_RET_STS_SUCCESS;
9409:
9410: x_line_approval_status := Eng_Workflow_Util.G_APPROVED ;
9411:
9412: FOR l_approved_line_rec IN c_approved_line (p_change_id )
9413: LOOP
9414:
9411:
9412: FOR l_approved_line_rec IN c_approved_line (p_change_id )
9413: LOOP
9414:
9415: x_line_approval_status := Eng_Workflow_Util.G_REQUESTED ;
9416:
9417: END LOOP ;
9418:
9419:
9946: END IF ;
9947:
9948: IF MandatoryResultCode IS NOT NULL AND
9949: ( MandatoryResultCode = ResultCode
9950: OR Eng_Workflow_Util.G_MANDATORY_RESP_ANY = MandatoryResultCode
9951: ) -- Added for Route
9952: THEN
9953:
9954: --
10005: Write_Debug('l_total_voted: ' || to_char(l_total_voted) );
10006: Write_Debug('l_code_count: ' || to_char(l_code_count) );
10007: END IF ;
10008:
10009: IF ( Eng_Workflow_Util.G_MANDATORY_RESP_ANY = MandatoryResultCode )
10010: THEN
10011:
10012: IF g_debug_flag THEN
10013: Write_Debug('In case Mandaotry Response Code is ANY. . .' );
10098:
10099:
10100: exception
10101: when others then
10102: wf_core.context('Eng_Workflow_Util',
10103: 'PeopleLevelVoteCount',
10104: to_char(gid),
10105: ResultCode );
10106: raise;
10124: -- Route Notofication Call Back Functions
10125: --
10126: -- ACTIVITY ATTRIBUTES REFERENCED
10127: -- VOTING_OPTION
10128: -- Eng_Workflow_Util.G_PEOPLE - Evaluate voting after every vote.
10129: -- - After every vote voting percentages are
10130: -- - calculated as a percentage of user specified as
10131: -- - mandatory notified to vote. voting
10132: -- - percentages are calculated as a percentage
10192: end if;
10193:
10194: -- SYNCHMODE: Not allowed
10195: if (itemkey = wf_engine.eng_synch) then
10196: Wf_Core.Token('OPERATION', 'Eng_Workflow_Util.PeopleLevelVoteForResultType');
10197: Wf_Core.Raise('WFENG_SYNCH_DISABLED');
10198: end if;
10199:
10200: -- Always clear the cache first
10224:
10225:
10226: if (l_voting_option not in ('REQUIRE_ALL_VOTES', 'WAIT_FOR_ALL_VOTES',
10227: 'TALLY_ON_EVERY_VOTE'))
10228: AND (l_voting_option <> Eng_Workflow_Util.G_PEOPLE ) -- Added for Route
10229: then
10230: raise wf_invalid_command;
10231: end if;
10232:
10237: -- d. REQUIRE_ALL_VOTES and all votes are cast
10238: -- Tally votes.
10239: for result_rec in result_codes loop
10240:
10241: IF (l_voting_option = Eng_Workflow_Util.G_PEOPLE
10242: AND ( ( l_mandatory_result IS NOT NULL
10243: AND l_mandatory_result = result_rec.result_code )
10244: OR l_mandatory_result = Eng_Workflow_Util.G_MANDATORY_RESP_ANY
10245: )
10240:
10241: IF (l_voting_option = Eng_Workflow_Util.G_PEOPLE
10242: AND ( ( l_mandatory_result IS NOT NULL
10243: AND l_mandatory_result = result_rec.result_code )
10244: OR l_mandatory_result = Eng_Workflow_Util.G_MANDATORY_RESP_ANY
10245: )
10246: )
10247: THEN
10248:
10247: THEN
10248:
10249:
10250: IF g_debug_flag THEN
10251: Write_Debug('Calling Eng_Workflow_Util.PeopleLevelVoteCount . . .' );
10252: Write_Debug('Step Id : ' || to_char(l_route_step_id) );
10253: END IF ;
10254:
10255: -- Get Route Step Id
10261:
10262: -- Tally Vote Count for this result code
10263: -- in case that Votion Option is Assignee Level(PEOPLE)
10264: -- and it is reponse code should be tallied among mandatory responses
10265: Eng_Workflow_Util.PeopleLevelVoteCount
10266: (Gid => l_group_id,
10267: ResultCode => result_rec.result_code,
10268: MandatoryResultCode => l_mandatory_result,
10269: ResultCount => l_code_count,
10418:
10419:
10420: exception
10421: when wf_invalid_command then
10422: Wf_Core.Context('Eng_Workflow_Util', 'PeopleLevelVoteForResultType', itemtype,
10423: itemkey, to_char(actid), funcmode);
10424: Wf_Core.Token('COMMAND', l_voting_option);
10425: Wf_Core.Raise('WFSQL_COMMAND');
10426: when others then
10423: itemkey, to_char(actid), funcmode);
10424: Wf_Core.Token('COMMAND', l_voting_option);
10425: Wf_Core.Raise('WFSQL_COMMAND');
10426: when others then
10427: Wf_Core.Context('Eng_Workflow_Util', 'PeopleLevelVoteForResultType',itemtype,
10428: itemkey, to_char(actid), funcmode);
10429: raise;
10430:
10431:
10463: IF g_debug_flag THEN
10464: Write_Debug('Voting Option: ' || l_voting_option );
10465: END IF ;
10466:
10467: if (l_voting_option in (Eng_Workflow_Util.G_WAIT_FOR_ALL_VOTES,
10468: Eng_Workflow_Util.G_REQUIRE_ALL_VOTES,
10469: Eng_Workflow_Util.G_TALLY_ON_EVERY_VOTE)
10470: )
10471: then
10464: Write_Debug('Voting Option: ' || l_voting_option );
10465: END IF ;
10466:
10467: if (l_voting_option in (Eng_Workflow_Util.G_WAIT_FOR_ALL_VOTES,
10468: Eng_Workflow_Util.G_REQUIRE_ALL_VOTES,
10469: Eng_Workflow_Util.G_TALLY_ON_EVERY_VOTE)
10470: )
10471: then
10472:
10465: END IF ;
10466:
10467: if (l_voting_option in (Eng_Workflow_Util.G_WAIT_FOR_ALL_VOTES,
10468: Eng_Workflow_Util.G_REQUIRE_ALL_VOTES,
10469: Eng_Workflow_Util.G_TALLY_ON_EVERY_VOTE)
10470: )
10471: then
10472:
10473:
10471: then
10472:
10473:
10474: IF g_debug_flag THEN
10475: Write_Debug('Calling Eng_Workflow_Util.VoteForResultType . . . ' );
10476: END IF ;
10477:
10478: Eng_Workflow_Util.VoteForResultType
10479: ( itemtype
10474: IF g_debug_flag THEN
10475: Write_Debug('Calling Eng_Workflow_Util.VoteForResultType . . . ' );
10476: END IF ;
10477:
10478: Eng_Workflow_Util.VoteForResultType
10479: ( itemtype
10480: , itemkey
10481: , actid
10482: , funcmode
10481: , actid
10482: , funcmode
10483: , resultout ) ;
10484:
10485: elsif (l_voting_option = Eng_Workflow_Util.G_PEOPLE)
10486: then
10487:
10488:
10489: IF g_debug_flag THEN
10486: then
10487:
10488:
10489: IF g_debug_flag THEN
10490: Write_Debug('Calling Eng_Workflow_Util.Eng_Workflow_Util.PeopleLevelVoteForResultType . . . ' );
10491: END IF ;
10492:
10493: Eng_Workflow_Util.PeopleLevelVoteForResultType
10494: ( itemtype
10489: IF g_debug_flag THEN
10490: Write_Debug('Calling Eng_Workflow_Util.Eng_Workflow_Util.PeopleLevelVoteForResultType . . . ' );
10491: END IF ;
10492:
10493: Eng_Workflow_Util.PeopleLevelVoteForResultType
10494: ( itemtype
10495: , itemkey
10496: , actid
10497: , funcmode
10556:
10557:
10558:
10559: IF g_debug_flag THEN
10560: Write_Debug('Eng_Workflow_Util.ContinueHeaderRouteLog');
10561: Write_Debug('-----------------------------------------------------');
10562: Write_Debug('Item Type : ' || p_item_type );
10563: Write_Debug('Item Key : ' || p_item_key );
10564: Write_Debug('Acttivity Id : ' || to_char(p_actid));
10573:
10574: if (p_waiting_flow_type = 'APPROVAL') then
10575:
10576: -- Get Change Object Identifier
10577: Eng_Workflow_Util.GetChangeObject
10578: ( p_item_type => p_item_type
10579: , p_item_key => p_item_key
10580: , x_change_id => l_change_id
10581: ) ;
10613: WHERE item_type = l_parent_itemtype
10614: AND item_key = l_parent_itemkey
10615: FOR UPDATE ;
10616:
10617: Eng_Workflow_Util.CheckAllLineApproved
10618: ( x_return_status => x_return_status
10619: , x_msg_count => x_msg_count
10620: , x_msg_data => x_msg_data
10621: , p_change_id => l_change_id
10626: IF g_debug_flag THEN
10627: Write_Debug('After calling CheckAllLineApproved, line appr status: ' || to_char(l_line_approval_status) );
10628: END IF ;
10629:
10630: IF l_line_approval_status = Eng_Workflow_Util.G_APPROVED
10631: THEN
10632:
10633:
10634: begin
10706:
10707: if (p_continuation_flow_type = 'APPROVAL') then
10708:
10709: -- Get Change Object Identifier
10710: Eng_Workflow_Util.GetChangeObject
10711: ( p_item_type => p_item_type
10712: , p_item_key => p_item_key
10713: , x_change_id => l_change_id
10714: ) ;
10712: , p_item_key => p_item_key
10713: , x_change_id => l_change_id
10714: ) ;
10715:
10716: Eng_Workflow_Util.CheckAllLineApproved
10717: ( x_return_status => x_return_status
10718: , x_msg_count => x_msg_count
10719: , x_msg_data => x_msg_data
10720: , p_change_id => l_change_id
10721: , x_line_approval_status => l_line_approval_status
10722: ) ;
10723:
10724:
10725: IF l_line_approval_status <> Eng_Workflow_Util.G_APPROVED
10726: THEN
10727: x_resultout := wf_engine.eng_notified ||':'||
10728: wf_engine.eng_null ||':'||
10729: wf_engine.eng_null;
10806:
10807: END LOOP ;
10808:
10809:
10810: Eng_Workflow_util.GetChangeObject( p_item_type => p_itemtype
10811: , p_item_key => p_itemKey
10812: , x_change_id => l_change_Id
10813: );
10814:
10813: );
10814:
10815:
10816: -- create and start Response FYI process to send Resp FYI ntf
10817: Eng_Workflow_Util.StartWorkflow
10818: ( p_api_version => 1.0
10819: , p_init_msg_list => FND_API.G_FALSE
10820: , p_commit => FND_API.G_FALSE
10821: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
10902: x_return_status := FND_API.G_RET_STS_SUCCESS ;
10903:
10904:
10905: IF g_debug_flag THEN
10906: Write_Debug('Eng_Workflow_Util.StartValidateDefProcess Log');
10907: Write_Debug('-----------------------------------------------------');
10908: Write_Debug('Step Item Type : ' || p_step_item_type );
10909: Write_Debug('Step Item Key : ' || p_step_item_key );
10910: Write_Debug('Route Id : ' || TO_CHAR(p_route_id) );
10921: BEGIN
10922: l_return_status := FND_API.G_RET_STS_SUCCESS ;
10923:
10924: -- FND_MSG_PUB.initialize ;
10925: Eng_Workflow_Util.StartWorkflow
10926: ( p_api_version => 1.0
10927: , p_init_msg_list => FND_API.G_FALSE
10928: , p_commit => FND_API.G_FALSE
10929: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
10946: ) ;
10947:
10948:
10949: IF g_debug_flag THEN
10950: Write_Debug('After call Eng_Workflow_Util.StartWorkflow' ) ;
10951: Write_Debug('Return Status: ' || l_return_status ) ;
10952: Write_Debug('Return Message: ' || l_msg_data ) ;
10953: Write_Debug('Started Val Def WF Item Type: ' || p_val_def_item_type ) ;
10954: Write_Debug('Started Val Def WF Item Kye: ' || x_val_def_item_key ) ;
11009:
11010: IF p_convert_type = 'RESPONSE' THEN
11011:
11012: -- Convert Route Status to Action Type for User Response in Route
11013: IF p_route_status_code = Eng_Workflow_Util.G_RT_APPROVED
11014: THEN
11015:
11016: l_action_type := Eng_Workflow_Util.G_ACT_APPROVED ;
11017:
11012: -- Convert Route Status to Action Type for User Response in Route
11013: IF p_route_status_code = Eng_Workflow_Util.G_RT_APPROVED
11014: THEN
11015:
11016: l_action_type := Eng_Workflow_Util.G_ACT_APPROVED ;
11017:
11018: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_REJECTED
11019: THEN
11020:
11014: THEN
11015:
11016: l_action_type := Eng_Workflow_Util.G_ACT_APPROVED ;
11017:
11018: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_REJECTED
11019: THEN
11020:
11021: l_action_type := Eng_Workflow_Util.G_ACT_REJECTED ;
11022:
11017:
11018: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_REJECTED
11019: THEN
11020:
11021: l_action_type := Eng_Workflow_Util.G_ACT_REJECTED ;
11022:
11023: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_COMPLETED
11024: THEN
11025:
11019: THEN
11020:
11021: l_action_type := Eng_Workflow_Util.G_ACT_REJECTED ;
11022:
11023: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_COMPLETED
11024: THEN
11025:
11026: l_action_type := Eng_Workflow_Util.G_ACT_COMPLETED ;
11027:
11022:
11023: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_COMPLETED
11024: THEN
11025:
11026: l_action_type := Eng_Workflow_Util.G_ACT_COMPLETED ;
11027:
11028: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_REPLIED
11029: THEN
11030:
11024: THEN
11025:
11026: l_action_type := Eng_Workflow_Util.G_ACT_COMPLETED ;
11027:
11028: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_REPLIED
11029: THEN
11030:
11031: l_action_type := Eng_Workflow_Util.G_ACT_REPLIED;
11032:
11027:
11028: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_REPLIED
11029: THEN
11030:
11031: l_action_type := Eng_Workflow_Util.G_ACT_REPLIED;
11032:
11033:
11034: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_TIME_OUT
11035: THEN
11030:
11031: l_action_type := Eng_Workflow_Util.G_ACT_REPLIED;
11032:
11033:
11034: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_TIME_OUT
11035: THEN
11036:
11037: l_action_type := Eng_Workflow_Util.G_ACT_TIMEOUT_WF;
11038:
11033:
11034: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_TIME_OUT
11035: THEN
11036:
11037: l_action_type := Eng_Workflow_Util.G_ACT_TIMEOUT_WF;
11038:
11039: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_FORWARDED
11040: THEN
11041:
11035: THEN
11036:
11037: l_action_type := Eng_Workflow_Util.G_ACT_TIMEOUT_WF;
11038:
11039: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_FORWARDED
11040: THEN
11041:
11042: l_action_type := Eng_Workflow_Util.G_ACT_DELEGATED;
11043:
11038:
11039: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_FORWARDED
11040: THEN
11041:
11042: l_action_type := Eng_Workflow_Util.G_ACT_DELEGATED;
11043:
11044: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_TRANSFERRED
11045: THEN
11046:
11040: THEN
11041:
11042: l_action_type := Eng_Workflow_Util.G_ACT_DELEGATED;
11043:
11044: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_TRANSFERRED
11045: THEN
11046:
11047: l_action_type := Eng_Workflow_Util.G_ACT_TRANSFERRED;
11048:
11043:
11044: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_TRANSFERRED
11045: THEN
11046:
11047: l_action_type := Eng_Workflow_Util.G_ACT_TRANSFERRED;
11048:
11049:
11050: -- R12B
11051: -- Added for Line Workflow Request Response
11048:
11049:
11050: -- R12B
11051: -- Added for Line Workflow Request Response
11052: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_RECEIVED
11053: THEN
11054:
11055: l_action_type := Eng_Workflow_Util.G_ACT_RECEIVED;
11056:
11051: -- Added for Line Workflow Request Response
11052: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_RECEIVED
11053: THEN
11054:
11055: l_action_type := Eng_Workflow_Util.G_ACT_RECEIVED;
11056:
11057: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_DECLINED
11058: THEN
11059:
11053: THEN
11054:
11055: l_action_type := Eng_Workflow_Util.G_ACT_RECEIVED;
11056:
11057: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_DECLINED
11058: THEN
11059:
11060: l_action_type := Eng_Workflow_Util.G_ACT_DECLINED;
11061:
11056:
11057: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_DECLINED
11058: THEN
11059:
11060: l_action_type := Eng_Workflow_Util.G_ACT_DECLINED;
11061:
11062:
11063: ELSE
11064:
11061:
11062:
11063: ELSE
11064:
11065: l_action_type := Eng_Workflow_Util.G_ACT_COMPLETED ;
11066: END IF ;
11067:
11068: ELSIF p_convert_type = 'WF_PROCESS' THEN
11069: -- Convert Route Status to Action Type for Workflow Process Status
11067:
11068: ELSIF p_convert_type = 'WF_PROCESS' THEN
11069: -- Convert Route Status to Action Type for Workflow Process Status
11070:
11071: IF p_route_status_code = Eng_Workflow_Util.G_RT_IN_PROGRESS
11072: THEN
11073:
11074: l_action_type := Eng_Workflow_Util.G_ACT_WF_STARTED;
11075:
11070:
11071: IF p_route_status_code = Eng_Workflow_Util.G_RT_IN_PROGRESS
11072: THEN
11073:
11074: l_action_type := Eng_Workflow_Util.G_ACT_WF_STARTED;
11075:
11076: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_APPROVED
11077: THEN
11078:
11072: THEN
11073:
11074: l_action_type := Eng_Workflow_Util.G_ACT_WF_STARTED;
11075:
11076: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_APPROVED
11077: THEN
11078:
11079: l_action_type := Eng_Workflow_Util.G_ACT_WF_APPROVED ;
11080:
11075:
11076: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_APPROVED
11077: THEN
11078:
11079: l_action_type := Eng_Workflow_Util.G_ACT_WF_APPROVED ;
11080:
11081:
11082: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_REJECTED
11083: THEN
11078:
11079: l_action_type := Eng_Workflow_Util.G_ACT_WF_APPROVED ;
11080:
11081:
11082: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_REJECTED
11083: THEN
11084:
11085: l_action_type := Eng_Workflow_Util.G_ACT_WF_REJECTED;
11086:
11081:
11082: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_REJECTED
11083: THEN
11084:
11085: l_action_type := Eng_Workflow_Util.G_ACT_WF_REJECTED;
11086:
11087: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_COMPLETED
11088: THEN
11089:
11083: THEN
11084:
11085: l_action_type := Eng_Workflow_Util.G_ACT_WF_REJECTED;
11086:
11087: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_COMPLETED
11088: THEN
11089:
11090: l_action_type := Eng_Workflow_Util.G_ACT_WF_COMPLETED;
11091:
11086:
11087: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_COMPLETED
11088: THEN
11089:
11090: l_action_type := Eng_Workflow_Util.G_ACT_WF_COMPLETED;
11091:
11092: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_ABORTED
11093: THEN
11094:
11088: THEN
11089:
11090: l_action_type := Eng_Workflow_Util.G_ACT_WF_COMPLETED;
11091:
11092: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_ABORTED
11093: THEN
11094:
11095: l_action_type := Eng_Workflow_Util.G_ACT_WF_ABORTED;
11096:
11091:
11092: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_ABORTED
11093: THEN
11094:
11095: l_action_type := Eng_Workflow_Util.G_ACT_WF_ABORTED;
11096:
11097:
11098: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_TIME_OUT
11099: THEN
11094:
11095: l_action_type := Eng_Workflow_Util.G_ACT_WF_ABORTED;
11096:
11097:
11098: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_TIME_OUT
11099: THEN
11100:
11101: l_action_type := Eng_Workflow_Util.G_ACT_WF_TIME_OUT;
11102:
11097:
11098: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_TIME_OUT
11099: THEN
11100:
11101: l_action_type := Eng_Workflow_Util.G_ACT_WF_TIME_OUT;
11102:
11103: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_ERROR -- Not Stupported yet
11104: THEN
11105:
11099: THEN
11100:
11101: l_action_type := Eng_Workflow_Util.G_ACT_WF_TIME_OUT;
11102:
11103: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_ERROR -- Not Stupported yet
11104: THEN
11105:
11106: l_action_type := Eng_Workflow_Util.G_ACT_WF_PROCESS_ERROR ;
11107:
11102:
11103: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_ERROR -- Not Stupported yet
11104: THEN
11105:
11106: l_action_type := Eng_Workflow_Util.G_ACT_WF_PROCESS_ERROR ;
11107:
11108: ELSE
11109:
11110: l_action_type := Eng_Workflow_Util.G_ACT_WF_COMPLETED ;
11106: l_action_type := Eng_Workflow_Util.G_ACT_WF_PROCESS_ERROR ;
11107:
11108: ELSE
11109:
11110: l_action_type := Eng_Workflow_Util.G_ACT_WF_COMPLETED ;
11111:
11112: END IF ;
11113:
11114: END IF ;
11130:
11131: BEGIN
11132:
11133: -- Convert Notification Line Route Status to Distribution Line Status
11134: IF p_route_status_code = Eng_Workflow_Util.G_RT_IN_PROGRESS
11135: THEN
11136:
11137: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_DIST_IN_PROGRESS;
11138:
11133: -- Convert Notification Line Route Status to Distribution Line Status
11134: IF p_route_status_code = Eng_Workflow_Util.G_RT_IN_PROGRESS
11135: THEN
11136:
11137: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_DIST_IN_PROGRESS;
11138:
11139: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_APPROVED
11140: THEN
11141:
11135: THEN
11136:
11137: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_DIST_IN_PROGRESS;
11138:
11139: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_APPROVED
11140: THEN
11141:
11142: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_DISTRIBUTED ;
11143:
11138:
11139: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_APPROVED
11140: THEN
11141:
11142: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_DISTRIBUTED ;
11143:
11144:
11145: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_REJECTED
11146: THEN
11141:
11142: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_DISTRIBUTED ;
11143:
11144:
11145: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_REJECTED
11146: THEN
11147:
11148: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_NOT_DISTRIBUTED;
11149:
11144:
11145: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_REJECTED
11146: THEN
11147:
11148: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_NOT_DISTRIBUTED;
11149:
11150: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_COMPLETED
11151: THEN
11152:
11146: THEN
11147:
11148: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_NOT_DISTRIBUTED;
11149:
11150: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_COMPLETED
11151: THEN
11152:
11153: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_DISTRIBUTED;
11154:
11149:
11150: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_COMPLETED
11151: THEN
11152:
11153: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_DISTRIBUTED;
11154:
11155: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_ABORTED
11156: THEN
11157:
11151: THEN
11152:
11153: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_DISTRIBUTED;
11154:
11155: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_ABORTED
11156: THEN
11157:
11158: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_NOT_DISTRIBUTED;
11159:
11154:
11155: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_ABORTED
11156: THEN
11157:
11158: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_NOT_DISTRIBUTED;
11159:
11160:
11161: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_TIME_OUT
11162: THEN
11157:
11158: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_NOT_DISTRIBUTED;
11159:
11160:
11161: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_TIME_OUT
11162: THEN
11163:
11164: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_NOT_DISTRIBUTED;
11165:
11160:
11161: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_TIME_OUT
11162: THEN
11163:
11164: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_NOT_DISTRIBUTED;
11165:
11166: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_ERROR -- Not Stupported yet
11167: THEN
11168:
11162: THEN
11163:
11164: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_NOT_DISTRIBUTED;
11165:
11166: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_ERROR -- Not Stupported yet
11167: THEN
11168:
11169: l_dist_line_status_code := Eng_Workflow_Util.G_ACT_WF_PROCESS_ERROR ;
11170:
11165:
11166: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_ERROR -- Not Stupported yet
11167: THEN
11168:
11169: l_dist_line_status_code := Eng_Workflow_Util.G_ACT_WF_PROCESS_ERROR ;
11170:
11171: ELSE
11172:
11173: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_NOT_DISTRIBUTED ;
11169: l_dist_line_status_code := Eng_Workflow_Util.G_ACT_WF_PROCESS_ERROR ;
11170:
11171: ELSE
11172:
11173: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_NOT_DISTRIBUTED ;
11174:
11175: END IF ;
11176:
11177: RETURN l_dist_line_status_code ;
11229: -- Initialize API return status to success
11230: x_return_status := FND_API.G_RET_STS_SUCCESS;
11231:
11232: IF g_debug_flag THEN
11233: Write_Debug('Eng_Workflow_Util.RespondToActReqCommentFromUI Log');
11234: Write_Debug('-----------------------------------------------------');
11235: Write_Debug('Item Type : ' || p_item_type );
11236: Write_Debug('Item Key : ' || p_item_key );
11237: Write_Debug('Responder : ' || p_responder );
11350: -- Initialize API return status to success
11351: x_return_status := FND_API.G_RET_STS_SUCCESS;
11352:
11353: IF g_debug_flag THEN
11354: Write_Debug('Eng_Workflow_Util.SetChangeOrderMRPFlag Log');
11355: Write_Debug('-----------------------------------------------------');
11356: Write_Debug('Change Id : ' || to_char(p_change_id) );
11357: Write_Debug('MFP Flag : ' || to_char(p_change_id) );
11358: Write_Debug('WF User Id : ' || to_char(p_wf_user_id) );
11434: , x_msg_count OUT NOCOPY NUMBER
11435: , x_msg_data OUT NOCOPY VARCHAR2
11436: , p_item_type IN VARCHAR2
11437: , p_item_key IN VARCHAR2
11438: , p_url_type IN VARCHAR2 := Eng_Workflow_Util.G_MONITOR_DIAGRAM
11439: , p_admin_mode IN VARCHAR2 := FND_API.G_FALSE
11440: , p_option IN VARCHAR2 := NULL
11441: , x_url OUT NOCOPY VARCHAR2
11442: )
11488: l_wf_web_agent := WF_CORE.Translate('WF_WEB_AGENT') ;
11489:
11490:
11491:
11492: IF p_url_type = Eng_Workflow_Util.G_MONITOR_ACCESSKEY
11493: THEN
11494:
11495: x_url := WF_MONITOR.GetAccessKey
11496: ( x_item_type => p_item_type
11496: ( x_item_type => p_item_type
11497: , x_item_key => p_item_key
11498: , x_admin_mode => l_admin_mode ) ;
11499:
11500: ELSIF p_url_type = Eng_Workflow_Util.G_MONITOR_DIAGRAM
11501: THEN
11502:
11503: x_url := WF_MONITOR.GetDiagramURL
11504: ( x_agent => l_apps_web_agent
11505: , x_item_type => p_item_type
11506: , x_item_key => p_item_key
11507: , x_admin_mode => l_admin_mode ) ;
11508:
11509: ELSIF p_url_type = Eng_Workflow_Util.G_MONITOR_ENVELOPE
11510: THEN
11511:
11512: x_url := WF_MONITOR.GetEnvelopeURL
11513: ( x_agent => l_apps_web_agent
11515: , x_item_key => p_item_key
11516: , x_admin_mode => l_admin_mode ) ;
11517:
11518:
11519: ELSIF p_url_type = Eng_Workflow_Util.G_MONITOR_ADVANCED_ENVELOPE
11520: THEN
11521:
11522: x_url := WF_MONITOR.GetAdvancedEnvelopeURL
11523: ( x_agent => l_apps_web_agent
11785: l_action_id := p_action_id ;
11786: END IF ;
11787:
11788: IF g_debug_flag THEN
11789: Write_Debug('Eng_Workflow_Util.StartWorkflow Log');
11790: Write_Debug('-----------------------------------------------------');
11791: Write_Debug('Item Type : ' || p_item_type );
11792: Write_Debug('Item Key : ' || x_item_key );
11793: Write_Debug('Process Name : ' || p_process_name);
11885: Write_Debug('CM Workflows except Doc Phse WF Routing are not supported in Document LC ChangeObject. return. .. ');
11886: END IF ;
11887: -- At this time, not raising any error
11888: -- Set dummy item key
11889: x_item_key := Eng_Workflow_Util.G_RET_STS_NONE ;
11890: RETURN ;
11891:
11892: ELSE
11893:
11968:
11969: -- Set User Id
11970: IF p_wf_user_id IS NULL OR p_wf_user_id < 0
11971: THEN
11972: l_api_caller := Eng_Workflow_Util.G_WF_CALL ;
11973: END IF ;
11974:
11975: IF g_debug_flag THEN
11976: Write_Debug('2-2. Get Spcial API Caller: ' || l_api_caller );
12036: Write_Debug('Parent Item Key : ' || p_parent_item_key);
12037: END IF ;
12038:
12039: -- If Parent WF Info is not null and
12040: -- item_type is NOT Eng_Workflow_Util.G_CHANGE_ROUTE_ITEM_TYPE
12041: -- G_CHANGE_ROUTE_ITEM_TYPE has own API to set parent wf info
12042: IF p_parent_item_type IS NOT NULL
12043: AND p_parent_item_key IS NOT NULL
12044: AND p_item_type <> Eng_Workflow_Util.G_CHANGE_ROUTE_ITEM_TYPE
12040: -- item_type is NOT Eng_Workflow_Util.G_CHANGE_ROUTE_ITEM_TYPE
12041: -- G_CHANGE_ROUTE_ITEM_TYPE has own API to set parent wf info
12042: IF p_parent_item_type IS NOT NULL
12043: AND p_parent_item_key IS NOT NULL
12044: AND p_item_type <> Eng_Workflow_Util.G_CHANGE_ROUTE_ITEM_TYPE
12045: THEN
12046:
12047: -- Set Parent Worklfow Process
12048: WF_ENGINE.SetItemParent
12055:
12056: END IF ;
12057:
12058:
12059: IF p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_ITEM_TYPE
12060: THEN
12061:
12062: IF g_debug_flag THEN
12063: Write_Debug('4-2. Set Route Status . . .');
12067: ( p_item_type => p_item_type
12068: , p_item_key => x_item_key
12069: , p_wf_user_id => p_wf_user_id
12070: , p_route_id => p_route_id
12071: , p_new_status_code => Eng_Workflow_Util.G_RT_IN_PROGRESS
12072: , p_init_route => FND_API.G_TRUE
12073: , p_change_id => l_change_id
12074: , p_change_line_id => l_change_line_id -- Added in R12B
12075: ) ;
12075: ) ;
12076:
12077:
12078: -- In case that Route Object is Change Object
12079: IF p_object_name = Eng_Workflow_Util.G_ENG_CHANGE
12080: THEN
12081:
12082: /***********************************************
12083: --
12096: -- , p_item_key => x_item_key
12097: -- , p_change_id => l_change_id
12098: -- , p_change_line_id => l_change_line_id
12099: -- , p_wf_user_id => p_wf_user_id
12100: -- , p_new_appr_status_type => Eng_Workflow_Util.G_REQUESTED
12101: -- ) ;
12102: --
12103:
12104: -- IF g_debug_flag THEN
12115:
12116: IF g_debug_flag THEN
12117: Write_Debug('4-4. Set Workflow Routing Action Log . . .');
12118: END IF ;
12119: l_action_type := Eng_Workflow_Util.ConvertRouteStatusToActionType
12120: ( p_route_status_code => Eng_Workflow_Util.G_RT_IN_PROGRESS
12121: , p_convert_type => 'WF_PROCESS' ) ;
12122:
12123: CreateRouteAction
12116: IF g_debug_flag THEN
12117: Write_Debug('4-4. Set Workflow Routing Action Log . . .');
12118: END IF ;
12119: l_action_type := Eng_Workflow_Util.ConvertRouteStatusToActionType
12120: ( p_route_status_code => Eng_Workflow_Util.G_RT_IN_PROGRESS
12121: , p_convert_type => 'WF_PROCESS' ) ;
12122:
12123: CreateRouteAction
12124: ( x_return_status => x_return_status
12154: Write_Debug('4-5. Sync Workflow Routing Status and LC Phase WF Status. . .');
12155: END IF ;
12156:
12157: -- R12B
12158: -- No need to call Eng_Workflow_Util.SyncChangeLCPhase
12159: -- For Line
12160: IF ( l_change_line_id IS NULL OR l_change_line_id <= 0)
12161: THEN
12162:
12160: IF ( l_change_line_id IS NULL OR l_change_line_id <= 0)
12161: THEN
12162:
12163: -- Call Sync Change Lifecycle Phase API
12164: Eng_Workflow_Util.SyncChangeLCPhase
12165: ( x_return_status => x_return_status
12166: , x_msg_count => x_msg_count
12167: , x_msg_data => x_msg_data
12168: , p_route_id => p_route_id
12184:
12185:
12186: -- R12B Line Workfow Routing
12187: -- In case that Route Object is Change Line Object
12188: ELSIF p_object_name = Eng_Workflow_Util.G_ENG_CHANGE_LINE
12189: THEN
12190:
12191:
12192: IF g_debug_flag THEN
12191:
12192: IF g_debug_flag THEN
12193: Write_Debug('4-4. Set Line Workflow Routing Action Log . . .');
12194: END IF ;
12195: l_action_type := Eng_Workflow_Util.ConvertRouteStatusToActionType
12196: ( p_route_status_code => Eng_Workflow_Util.G_RT_IN_PROGRESS
12197: , p_convert_type => 'WF_PROCESS' ) ;
12198:
12199: CreateRouteAction
12192: IF g_debug_flag THEN
12193: Write_Debug('4-4. Set Line Workflow Routing Action Log . . .');
12194: END IF ;
12195: l_action_type := Eng_Workflow_Util.ConvertRouteStatusToActionType
12196: ( p_route_status_code => Eng_Workflow_Util.G_RT_IN_PROGRESS
12197: , p_convert_type => 'WF_PROCESS' ) ;
12198:
12199: CreateRouteAction
12200: ( x_return_status => x_return_status
12226: , p_action_id => l_action_id
12227: ) ;
12228:
12229:
12230: END IF ; -- End if p_object_name = Eng_Workflow_Util.G_ENG_CHANGE_LINE
12231:
12232:
12233: /***********************************************
12234: -- In 115.10
12262:
12263:
12264:
12265:
12266: ELSIF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
12267: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE
12268: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE
12269: )
12270: THEN
12263:
12264:
12265:
12266: ELSIF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
12267: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE
12268: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE
12269: )
12270: THEN
12271:
12264:
12265:
12266: ELSIF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
12267: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE
12268: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE
12269: )
12270: THEN
12271:
12272: IF g_debug_flag THEN
12272: IF g_debug_flag THEN
12273: Write_Debug('4-2. Set Route Step Status . . .' || to_char(p_route_step_id));
12274: END IF ;
12275:
12276: Eng_Workflow_Util.SetRouteStepStatus
12277: ( p_item_type => p_item_type
12278: , p_item_key => x_item_key
12279: , p_wf_user_id => p_wf_user_id
12280: , p_route_id => p_route_id
12278: , p_item_key => x_item_key
12279: , p_wf_user_id => p_wf_user_id
12280: , p_route_id => p_route_id
12281: , p_route_step_id => p_route_step_id
12282: , p_new_status_code => Eng_Workflow_Util.G_RT_IN_PROGRESS
12283: ) ;
12284:
12285:
12286: IF g_debug_flag THEN
12308: -- same roles specified in WF Definition will be granted to the original assignee will be kept.
12309: -- In addition view grants will be provided to the new assignees
12310: --
12311: IF g_debug_flag THEN
12312: Write_Debug('calling Eng_Workflow_Util.GrantObjectRoles.' );
12313: END IF ;
12314:
12315: l_index := 0 ;
12316: l_target_obj_tbl := FND_TABLE_OF_VARCHAR2_30();
12313: END IF ;
12314:
12315: l_index := 0 ;
12316: l_target_obj_tbl := FND_TABLE_OF_VARCHAR2_30();
12317: IF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE )
12318: THEN
12319: l_target_obj_tbl.EXTEND ;
12320: l_index := l_index + 1 ;
12321: l_target_obj_tbl(l_index) := G_DOM_DOCUMENT_REVISION ;
12321: l_target_obj_tbl(l_index) := G_DOM_DOCUMENT_REVISION ;
12322: END IF ;
12323:
12324:
12325: Eng_Workflow_Util.GrantObjectRoles
12326: ( p_api_version => 1.0
12327: , p_init_msg_list => FND_API.G_FALSE --
12328: , p_commit => FND_API.G_FALSE --
12329: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
12344: ) ;
12345:
12346:
12347: IF g_debug_flag THEN
12348: Write_Debug('After Eng_Workflow_Util.GrantObjectRoles: ' || l_return_status );
12349: END IF ;
12350:
12351: --
12352: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
12611: -- END IF;
12612:
12613:
12614: IF g_debug_flag THEN
12615: Write_Debug('Eng_Workflow_Util.AbortWorkflow Log');
12616: Write_Debug('-----------------------------------------------------');
12617: Write_Debug('Item Type : ' || p_item_type );
12618: Write_Debug('Item Key : ' || p_item_Key );
12619: Write_Debug('Process Name : ' || p_process_name);
12690: ) ;
12691:
12692: ELSE
12693:
12694: l_api_caller := Eng_Workflow_Util.G_WF_CALL ;
12695:
12696: END IF ;
12697:
12698:
12702: END IF ;
12703:
12704:
12705: -- Put the Item Type specific logic here
12706: IF p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_ITEM_TYPE
12707: THEN
12708:
12709: IF g_debug_flag THEN
12710: Write_Debug('3-1. Set Route Status . . .');
12710: Write_Debug('3-1. Set Route Status . . .');
12711: END IF ;
12712:
12713: -- Get Change Object Identifier
12714: Eng_Workflow_Util.GetChangeObject
12715: ( p_item_type => p_item_type
12716: , p_item_key => p_item_key
12717: , x_change_id => l_change_id
12718: ) ;
12718: ) ;
12719:
12720:
12721: -- Get Change Line Object Identifier
12722: Eng_Workflow_Util.GetChangeLineObject
12723: ( p_item_type => p_item_type
12724: , p_item_key => p_item_key
12725: , x_change_line_id => l_change_line_id
12726: ) ;
12725: , x_change_line_id => l_change_line_id
12726: ) ;
12727:
12728: -- Get Route Id
12729: Eng_Workflow_Util.GetRouteId
12730: ( p_item_type => p_item_type
12731: , p_item_key => p_item_key
12732: , x_route_id => l_route_id
12733: ) ;
12732: , x_route_id => l_route_id
12733: ) ;
12734:
12735: -- Get Route Object Name
12736: Eng_Workflow_Util.GetRouteObject
12737: ( p_item_type => p_item_type
12738: , p_item_key => p_item_key
12739: , x_route_object => l_route_object_name
12740: ) ;
12745: ( p_item_type => p_item_type
12746: , p_item_key => p_item_key
12747: , p_wf_user_id => p_wf_user_id
12748: , p_route_id => l_route_id
12749: , p_new_status_code => Eng_Workflow_Util.G_RT_ABORTED
12750: , p_change_id => l_change_id
12751: , p_change_line_id => l_change_line_id -- Added in R12B
12752: ) ;
12753:
12765: -- , p_item_key => p_item_key
12766: -- , p_change_id => l_change_id
12767: -- , p_change_line_id => l_change_line_id
12768: -- , p_wf_user_id => p_wf_user_id
12769: -- , p_new_appr_status_type => Eng_Workflow_Util.G_NOT_SUBMITTED
12770: -- ) ;
12771:
12772: IF g_debug_flag THEN
12773: Write_Debug('After Set Approval Status .' || x_return_status );
12803: END IF ;
12804:
12805:
12806: -- In case that Route Object is Change Object
12807: IF l_route_object_name = Eng_Workflow_Util.G_ENG_CHANGE
12808: THEN
12809:
12810: --
12811: -- R12 DOM LC Phase Workflow Support
12846: Write_Debug('3-4. Set Workflow Routing Action Log . . .');
12847: END IF ;
12848:
12849: -- Get Action Id and set this as parent action id
12850: Eng_Workflow_Util.GetActionId
12851: ( p_item_type => p_item_type
12852: , p_item_key => p_item_key
12853: , x_action_id => l_parent_action_id
12854: ) ;
12852: , p_item_key => p_item_key
12853: , x_action_id => l_parent_action_id
12854: ) ;
12855:
12856: l_action_type := Eng_Workflow_Util.ConvertRouteStatusToActionType
12857: ( p_route_status_code => Eng_Workflow_Util.G_RT_ABORTED
12858: , p_convert_type => 'WF_PROCESS' ) ;
12859:
12860:
12853: , x_action_id => l_parent_action_id
12854: ) ;
12855:
12856: l_action_type := Eng_Workflow_Util.ConvertRouteStatusToActionType
12857: ( p_route_status_code => Eng_Workflow_Util.G_RT_ABORTED
12858: , p_convert_type => 'WF_PROCESS' ) ;
12859:
12860:
12861: CreateRouteAction
12882: END IF ;
12883:
12884:
12885: -- R12B
12886: -- No need to call Eng_Workflow_Util.SyncChangeLCPhase
12887: -- For Line
12888: IF ( l_change_line_id IS NULL OR l_change_line_id <= 0)
12889: THEN
12890:
12888: IF ( l_change_line_id IS NULL OR l_change_line_id <= 0)
12889: THEN
12890:
12891: -- Call Sync Change Lifecycle Phase API
12892: Eng_Workflow_Util.SyncChangeLCPhase
12893: ( x_return_status => x_return_status
12894: , x_msg_count => x_msg_count
12895: , x_msg_data => x_msg_data
12896: , p_route_id => l_route_id
12910:
12911:
12912: -- R12B Line Workfow Routing
12913: -- In case that Route Object is Change Line Object
12914: ELSIF l_route_object_name = Eng_Workflow_Util.G_ENG_CHANGE_LINE
12915: THEN
12916:
12917:
12918: IF g_debug_flag THEN
12919: Write_Debug('4-4. Set Line Workflow Routing Action Log . . .');
12920: END IF ;
12921:
12922: -- Get Action Id and set this as parent action id
12923: Eng_Workflow_Util.GetActionId
12924: ( p_item_type => p_item_type
12925: , p_item_key => p_item_key
12926: , x_action_id => l_parent_action_id
12927: ) ;
12926: , x_action_id => l_parent_action_id
12927: ) ;
12928:
12929:
12930: l_action_type := Eng_Workflow_Util.ConvertRouteStatusToActionType
12931: ( p_route_status_code => Eng_Workflow_Util.G_RT_ABORTED
12932: , p_convert_type => 'WF_PROCESS' ) ;
12933:
12934:
12927: ) ;
12928:
12929:
12930: l_action_type := Eng_Workflow_Util.ConvertRouteStatusToActionType
12931: ( p_route_status_code => Eng_Workflow_Util.G_RT_ABORTED
12932: , p_convert_type => 'WF_PROCESS' ) ;
12933:
12934:
12935: CreateRouteAction
12955: RAISE FND_API.G_EXC_ERROR ;
12956: END IF ;
12957:
12958:
12959: END IF ; -- End if p_object_name = Eng_Workflow_Util.G_ENG_CHANGE_LINE
12960:
12961:
12962:
12963:
12978: END IF ;
12979:
12980:
12981: IF g_debug_flag THEN
12982: Write_Debug('Calling Eng_Workflow_Util.RevokeObjectRoles . . . . ');
12983: END IF ;
12984:
12985:
12986: Eng_Workflow_Util.RevokeObjectRoles
12982: Write_Debug('Calling Eng_Workflow_Util.RevokeObjectRoles . . . . ');
12983: END IF ;
12984:
12985:
12986: Eng_Workflow_Util.RevokeObjectRoles
12987: ( p_api_version => 1.0
12988: , p_init_msg_list => FND_API.G_FALSE --
12989: , p_commit => FND_API.G_FALSE --
12990: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
13004: ) ;
13005:
13006:
13007: IF g_debug_flag THEN
13008: Write_Debug('After Eng_Workflow_Util.RevokeObjectRoles.' || l_return_status );
13009: END IF ;
13010:
13011: --
13012: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
13015: -- END IF ;
13016: --
13017:
13018: -- R12B
13019: ELSIF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
13020: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE
13021: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE
13022: )
13023: THEN
13016: --
13017:
13018: -- R12B
13019: ELSIF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
13020: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE
13021: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE
13022: )
13023: THEN
13024:
13017:
13018: -- R12B
13019: ELSIF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
13020: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE
13021: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE
13022: )
13023: THEN
13024:
13025: -- Get Route Step Id
13038: , p_item_key => p_item_key
13039: , p_wf_user_id => p_wf_user_id
13040: , p_route_id => l_route_id
13041: , p_route_step_id => l_route_step_id
13042: , p_new_status_code => Eng_Workflow_Util.G_RT_ABORTED
13043: ) ;
13044:
13045:
13046: END IF ;
13090:
13091: CheckWFActivityStatus
13092: ( p_item_type => p_item_type
13093: , p_item_key => p_item_key
13094: , p_activity_name => Eng_Workflow_Util.G_BLOCK_ABORT_ACTIVITY
13095: , x_activity_status => l_activity_status
13096: );
13097:
13098: IF g_debug_flag THEN
13100: END IF ;
13101:
13102:
13103:
13104: IF (l_activity_status = Eng_Workflow_Util.G_WF_NOTIFIED)
13105: THEN
13106:
13107: IF g_debug_flag THEN
13108: Write_Debug('6-2. Complete Abort Block Activity. . .' );
13110:
13111:
13112: WF_ENGINE.CompleteActivity( p_item_type
13113: , p_item_key
13114: , Eng_Workflow_Util.G_BLOCK_ABORT_ACTIVITY
13115: , Eng_Workflow_Util.G_WF_COMPLETE
13116: );
13117:
13118: ELSE
13111:
13112: WF_ENGINE.CompleteActivity( p_item_type
13113: , p_item_key
13114: , Eng_Workflow_Util.G_BLOCK_ABORT_ACTIVITY
13115: , Eng_Workflow_Util.G_WF_COMPLETE
13116: );
13117:
13118: ELSE
13119:
13314: WHERE RoutePeople.assignee_id = EngSecPeople.person_id
13315: -- AND RoutePeople.assignee_type_code = p_assignee_type_code
13316: AND RoutePeople.step_id = p_step_id
13317: AND ( RoutePeople.response_code IS NULL
13318: OR RoutePeople.response_code = Eng_Workflow_Util.G_RT_SUBMITTED
13319: OR RoutePeople.response_code = Eng_Workflow_Util.G_RT_NOT_RECEIVED )
13320: AND EngSecPeople.user_name = wn.recipient_role
13321: AND wn.notification_id = p_notification_id ;
13322:
13315: -- AND RoutePeople.assignee_type_code = p_assignee_type_code
13316: AND RoutePeople.step_id = p_step_id
13317: AND ( RoutePeople.response_code IS NULL
13318: OR RoutePeople.response_code = Eng_Workflow_Util.G_RT_SUBMITTED
13319: OR RoutePeople.response_code = Eng_Workflow_Util.G_RT_NOT_RECEIVED )
13320: AND EngSecPeople.user_name = wn.recipient_role
13321: AND wn.notification_id = p_notification_id ;
13322:
13323: --Bug 11802032 Start
13341: WHERE RoutePeople.assignee_id = EngSecPeople.person_id
13342: -- AND RoutePeople.assignee_type_code = p_assignee_type_code
13343: AND RoutePeople.step_id = p_step_id
13344: AND ( RoutePeople.response_code IS NULL
13345: OR RoutePeople.response_code = Eng_Workflow_Util.G_RT_SUBMITTED
13346: OR RoutePeople.response_code = Eng_Workflow_Util.G_RT_NOT_RECEIVED )
13347: AND EngSecPeople.user_name = wn.recipient_role
13348: AND wn.notification_id = p_notification_id
13349: AND ( ( p_chg_rte_cnt_nonull_ntfid > 0 and RoutePeople.wf_notification_id = p_notification_id )
13342: -- AND RoutePeople.assignee_type_code = p_assignee_type_code
13343: AND RoutePeople.step_id = p_step_id
13344: AND ( RoutePeople.response_code IS NULL
13345: OR RoutePeople.response_code = Eng_Workflow_Util.G_RT_SUBMITTED
13346: OR RoutePeople.response_code = Eng_Workflow_Util.G_RT_NOT_RECEIVED )
13347: AND EngSecPeople.user_name = wn.recipient_role
13348: AND wn.notification_id = p_notification_id
13349: AND ( ( p_chg_rte_cnt_nonull_ntfid > 0 and RoutePeople.wf_notification_id = p_notification_id )
13350: OR ( p_chg_rte_cnt_nonull_ntfid = 0 and RoutePeople.wf_notification_id is null)) ;
13425: Write_Debug('Transfer only supports users, new rols is invalid ');
13426: END IF ;
13427:
13428: x_return_status := FND_API.G_RET_STS_ERROR ;
13429: Wf_Core.context('Eng_Workflow_Util', 'reassignRoutePeople',
13430: p_item_type, p_item_key, p_notification_id, p_reassign_mode);
13431: Wf_Core.Token('ROLE', WF_ENGINE.context_new_role);
13432: Wf_Core.Raise('WFNTF_TRANSFER_FAIL');
13433: end;
13501:
13502:
13503:
13504:
13505: l_default_assignee_resp := Eng_Workflow_Util.G_RT_SUBMITTED ;
13506:
13507: IF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE
13508: AND Eng_Workflow_Util.Is_Line_Ntf_WF(p_route_id => l_route_id)
13509: )
13503:
13504:
13505: l_default_assignee_resp := Eng_Workflow_Util.G_RT_SUBMITTED ;
13506:
13507: IF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE
13508: AND Eng_Workflow_Util.Is_Line_Ntf_WF(p_route_id => l_route_id)
13509: )
13510: THEN
13511:
13504:
13505: l_default_assignee_resp := Eng_Workflow_Util.G_RT_SUBMITTED ;
13506:
13507: IF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE
13508: AND Eng_Workflow_Util.Is_Line_Ntf_WF(p_route_id => l_route_id)
13509: )
13510: THEN
13511:
13512: IF g_debug_flag THEN
13512: IF g_debug_flag THEN
13513: Write_Debug('Calling GetStepDefaultRespCode ' ) ;
13514: END IF ;
13515:
13516: Eng_Workflow_Util.GetStepDefaultRespCode
13517: ( p_step_id => l_step_id
13518: , x_default_resp_code => l_default_assignee_resp
13519: ) ;
13520:
13597: -- CreateAction API will take care of inserting the action
13598: -- properly for Line Workflow too.
13599: IF l_change_id IS NOT NULL AND l_change_id > 0
13600: THEN
13601: l_action_type := Eng_Workflow_Util.ConvertRouteStatusToActionType
13602: ( p_route_status_code => l_response_code
13603: , p_convert_type => 'RESPONSE' ) ;
13604:
13605: -- Record Action
13602: ( p_route_status_code => l_response_code
13603: , p_convert_type => 'RESPONSE' ) ;
13604:
13605: -- Record Action
13606: Eng_Workflow_Util.CreateAction
13607: ( x_return_status => l_return_status
13608: , x_msg_count => l_msg_count
13609: , x_msg_data => l_msg_data
13610: , p_item_type => p_item_type
13629:
13630: --
13631: -- R12B
13632: -- Grant Object Roles for this new assignee
13633: IF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
13634: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE
13635: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE
13636: )
13637: THEN
13630: --
13631: -- R12B
13632: -- Grant Object Roles for this new assignee
13633: IF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
13634: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE
13635: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE
13636: )
13637: THEN
13638:
13631: -- R12B
13632: -- Grant Object Roles for this new assignee
13633: IF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
13634: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE
13635: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE
13636: )
13637: THEN
13638:
13639:
13639:
13640: l_obj_index := 0 ;
13641: l_person_idx := 0 ;
13642:
13643: IF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE )
13644: THEN
13645: l_target_obj_tbl := FND_TABLE_OF_VARCHAR2_30();
13646: l_target_obj_tbl.EXTEND ;
13647: l_obj_index := l_obj_index + 1 ;
13655: l_person_id_tbl(l_person_idx) := l_new_party_id ;
13656:
13657:
13658: IF g_debug_flag THEN
13659: Write_Debug('Calling Eng_Workflow_Util.GrantObjectRoles for transfer assignee: ' || l_new_party_id );
13660: END IF ;
13661:
13662: Eng_Workflow_Util.GrantObjectRoles
13663: ( p_api_version => 1.0
13658: IF g_debug_flag THEN
13659: Write_Debug('Calling Eng_Workflow_Util.GrantObjectRoles for transfer assignee: ' || l_new_party_id );
13660: END IF ;
13661:
13662: Eng_Workflow_Util.GrantObjectRoles
13663: ( p_api_version => 1.0
13664: , p_init_msg_list => FND_API.G_FALSE --
13665: , p_commit => FND_API.G_FALSE --
13666: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
13680: , p_grant_option => NULL
13681: ) ;
13682:
13683: IF g_debug_flag THEN
13684: Write_Debug('After Eng_Workflow_Util.GrantObjectRoles: ' || l_return_status );
13685: END IF ;
13686:
13687: --
13688: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
13889: END IF ;
13890:
13891:
13892: IF g_debug_flag THEN
13893: Write_Debug('Eng_Workflow_Util.GrantObjectRoles Log');
13894: Write_Debug('-----------------------------------------------------');
13895: Write_Debug('Change Id : ' || TO_CHAR(p_change_id) );
13896: Write_Debug('Change Line Id : ' || TO_CHAR(p_change_line_id) );
13897: Write_Debug('Route Id : ' || TO_CHAR(p_route_id));
14410: SELECT routes.OBJECT_ID1 CHANGE_ID
14411: , TO_NUMBER(NULL) CHANGE_LINE_ID
14412: , routes.ROUTE_ID
14413: FROM ENG_CHANGE_ROUTES routes
14414: WHERE routes.STATUS_CODE IN ( Eng_Workflow_Util.G_RT_REJECTED
14415: , Eng_Workflow_Util.G_RT_APPROVED
14416: , Eng_Workflow_Util.G_RT_COMPLETED
14417: , Eng_Workflow_Util.G_RT_TIME_OUT) -- G_RT_ABORTED was taken care by ABORT WF
14418: AND ( routes.TEMPLATE_FLAG = G_RT_INSTANCE
14411: , TO_NUMBER(NULL) CHANGE_LINE_ID
14412: , routes.ROUTE_ID
14413: FROM ENG_CHANGE_ROUTES routes
14414: WHERE routes.STATUS_CODE IN ( Eng_Workflow_Util.G_RT_REJECTED
14415: , Eng_Workflow_Util.G_RT_APPROVED
14416: , Eng_Workflow_Util.G_RT_COMPLETED
14417: , Eng_Workflow_Util.G_RT_TIME_OUT) -- G_RT_ABORTED was taken care by ABORT WF
14418: AND ( routes.TEMPLATE_FLAG = G_RT_INSTANCE
14419: OR routes.TEMPLATE_FLAG = G_RT_HISTORY)
14412: , routes.ROUTE_ID
14413: FROM ENG_CHANGE_ROUTES routes
14414: WHERE routes.STATUS_CODE IN ( Eng_Workflow_Util.G_RT_REJECTED
14415: , Eng_Workflow_Util.G_RT_APPROVED
14416: , Eng_Workflow_Util.G_RT_COMPLETED
14417: , Eng_Workflow_Util.G_RT_TIME_OUT) -- G_RT_ABORTED was taken care by ABORT WF
14418: AND ( routes.TEMPLATE_FLAG = G_RT_INSTANCE
14419: OR routes.TEMPLATE_FLAG = G_RT_HISTORY)
14420: AND routes.OBJECT_NAME = G_ENG_CHANGE
14413: FROM ENG_CHANGE_ROUTES routes
14414: WHERE routes.STATUS_CODE IN ( Eng_Workflow_Util.G_RT_REJECTED
14415: , Eng_Workflow_Util.G_RT_APPROVED
14416: , Eng_Workflow_Util.G_RT_COMPLETED
14417: , Eng_Workflow_Util.G_RT_TIME_OUT) -- G_RT_ABORTED was taken care by ABORT WF
14418: AND ( routes.TEMPLATE_FLAG = G_RT_INSTANCE
14419: OR routes.TEMPLATE_FLAG = G_RT_HISTORY)
14420: AND routes.OBJECT_NAME = G_ENG_CHANGE
14421: AND routes.OBJECT_ID1 = c_change_id ;
14427: , chg_line.CHANGE_LINE_ID
14428: , line_routes.ROUTE_ID
14429: FROM ENG_CHANGE_ROUTES line_routes
14430: , ENG_CHANGE_LINES chg_line
14431: WHERE line_routes.STATUS_CODE IN ( Eng_Workflow_Util.G_RT_REJECTED
14432: , Eng_Workflow_Util.G_RT_APPROVED
14433: , Eng_Workflow_Util.G_RT_COMPLETED
14434: , Eng_Workflow_Util.G_RT_TIME_OUT ) -- G_RT_ABORTED was taken care by ABORT WF
14435: AND ( line_routes.TEMPLATE_FLAG = G_RT_INSTANCE
14428: , line_routes.ROUTE_ID
14429: FROM ENG_CHANGE_ROUTES line_routes
14430: , ENG_CHANGE_LINES chg_line
14431: WHERE line_routes.STATUS_CODE IN ( Eng_Workflow_Util.G_RT_REJECTED
14432: , Eng_Workflow_Util.G_RT_APPROVED
14433: , Eng_Workflow_Util.G_RT_COMPLETED
14434: , Eng_Workflow_Util.G_RT_TIME_OUT ) -- G_RT_ABORTED was taken care by ABORT WF
14435: AND ( line_routes.TEMPLATE_FLAG = G_RT_INSTANCE
14436: OR line_routes.TEMPLATE_FLAG = G_RT_HISTORY)
14429: FROM ENG_CHANGE_ROUTES line_routes
14430: , ENG_CHANGE_LINES chg_line
14431: WHERE line_routes.STATUS_CODE IN ( Eng_Workflow_Util.G_RT_REJECTED
14432: , Eng_Workflow_Util.G_RT_APPROVED
14433: , Eng_Workflow_Util.G_RT_COMPLETED
14434: , Eng_Workflow_Util.G_RT_TIME_OUT ) -- G_RT_ABORTED was taken care by ABORT WF
14435: AND ( line_routes.TEMPLATE_FLAG = G_RT_INSTANCE
14436: OR line_routes.TEMPLATE_FLAG = G_RT_HISTORY)
14437: AND line_routes.object_id1 = chg_line.CHANGE_LINE_ID
14430: , ENG_CHANGE_LINES chg_line
14431: WHERE line_routes.STATUS_CODE IN ( Eng_Workflow_Util.G_RT_REJECTED
14432: , Eng_Workflow_Util.G_RT_APPROVED
14433: , Eng_Workflow_Util.G_RT_COMPLETED
14434: , Eng_Workflow_Util.G_RT_TIME_OUT ) -- G_RT_ABORTED was taken care by ABORT WF
14435: AND ( line_routes.TEMPLATE_FLAG = G_RT_INSTANCE
14436: OR line_routes.TEMPLATE_FLAG = G_RT_HISTORY)
14437: AND line_routes.object_id1 = chg_line.CHANGE_LINE_ID
14438: AND line_routes.OBJECT_NAME = G_ENG_CHANGE_LINE
14603: CURSOR c_route_step( c_route_id NUMBER )
14604: IS
14605: SELECT RouteStep.STEP_ID
14606: FROM ENG_CHANGE_ROUTE_STEPS RouteStep
14607: WHERE ( RouteStep.STEP_STATUS_CODE <> Eng_Workflow_Util.G_RT_NOT_STARTED
14608: AND RouteStep.STEP_STATUS_CODE <> Eng_Workflow_Util.G_RT_IN_PROGRESS)
14609: AND RouteStep.ROUTE_ID = c_route_id ;
14610:
14611:
14604: IS
14605: SELECT RouteStep.STEP_ID
14606: FROM ENG_CHANGE_ROUTE_STEPS RouteStep
14607: WHERE ( RouteStep.STEP_STATUS_CODE <> Eng_Workflow_Util.G_RT_NOT_STARTED
14608: AND RouteStep.STEP_STATUS_CODE <> Eng_Workflow_Util.G_RT_IN_PROGRESS)
14609: AND RouteStep.ROUTE_ID = c_route_id ;
14610:
14611:
14612:
14744: WHERE RoutePeople.ASSIGNEE_TYPE_CODE = 'PERSON'
14745: AND RoutePeople.ASSIGNEE_ID <> -1
14746: AND RoutePeople.ORIGINAL_ASSIGNEE_TYPE_CODE <> 'ROLE'
14747: AND RoutePeople.STEP_ID = RouteStep.STEP_ID
14748: AND ( RouteStep.STEP_STATUS_CODE <> Eng_Workflow_Util.G_RT_NOT_STARTED
14749: AND RouteStep.STEP_STATUS_CODE <> Eng_Workflow_Util.G_RT_IN_PROGRESS)
14750: AND RouteStep.STEP_ID = c_step_id
14751: UNION
14752: SELECT RouteStep.ROUTE_ID
14745: AND RoutePeople.ASSIGNEE_ID <> -1
14746: AND RoutePeople.ORIGINAL_ASSIGNEE_TYPE_CODE <> 'ROLE'
14747: AND RoutePeople.STEP_ID = RouteStep.STEP_ID
14748: AND ( RouteStep.STEP_STATUS_CODE <> Eng_Workflow_Util.G_RT_NOT_STARTED
14749: AND RouteStep.STEP_STATUS_CODE <> Eng_Workflow_Util.G_RT_IN_PROGRESS)
14750: AND RouteStep.STEP_ID = c_step_id
14751: UNION
14752: SELECT RouteStep.ROUTE_ID
14753: , RoutePeople.STEP_ID
14770: AND RoutePeople.ASSIGNEE_TYPE_CODE = 'PERSON'
14771: AND RoutePeople.ASSIGNEE_ID <> -1
14772: AND RoutePeople.ORIGINAL_ASSIGNEE_TYPE_CODE = 'ROLE'
14773: AND RoutePeople.STEP_ID = RouteStep.STEP_ID
14774: AND ( RouteStep.STEP_STATUS_CODE <> Eng_Workflow_Util.G_RT_NOT_STARTED
14775: AND RouteStep.STEP_STATUS_CODE <> Eng_Workflow_Util.G_RT_IN_PROGRESS)
14776: AND RouteStep.STEP_ID = c_step_id ;
14777:
14778:
14771: AND RoutePeople.ASSIGNEE_ID <> -1
14772: AND RoutePeople.ORIGINAL_ASSIGNEE_TYPE_CODE = 'ROLE'
14773: AND RoutePeople.STEP_ID = RouteStep.STEP_ID
14774: AND ( RouteStep.STEP_STATUS_CODE <> Eng_Workflow_Util.G_RT_NOT_STARTED
14775: AND RouteStep.STEP_STATUS_CODE <> Eng_Workflow_Util.G_RT_IN_PROGRESS)
14776: AND RouteStep.STEP_ID = c_step_id ;
14777:
14778:
14779:
14846: END IF ;
14847:
14848:
14849: IF g_debug_flag THEN
14850: Write_Debug('Eng_Workflow_Util.RevokeObjectRoles Log');
14851: Write_Debug('-----------------------------------------------------');
14852: Write_Debug('Change Id : ' || TO_CHAR(p_change_id) );
14853: Write_Debug('Change Line Id : ' || TO_CHAR(p_change_line_id) );
14854: Write_Debug('Route Id : ' || TO_CHAR(p_route_id));
15287:
15288: END RevokeObjectRoles ;
15289:
15290:
15291: END Eng_Workflow_Util ;