[Home] [Help]
1: PACKAGE BODY Eng_Workflow_Util AS
2: /* $Header: ENGUWKFB.pls 120.32 2007/05/11 16:05:54 asjohal 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.32 2007/05/11 16:05:54 asjohal 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));
8339: ) ;
8340:
8341:
8342: IF g_debug_flag THEN
8343: Write_Debug('Eng_Workflow_Util.SetRouteResponse Log');
8344: Write_Debug('-----------------------------------------------------');
8345: Write_Debug('Item Type : ' || p_item_type );
8346: Write_Debug('Item Key : ' || p_item_key );
8347: Write_Debug('NTF Id : ' || to_char(p_notification_id) );
8522: -- In case that Route Object is Change Object
8523: IF l_change_id IS NOT NULL AND l_change_id > 0
8524: THEN
8525:
8526: l_action_type := Eng_Workflow_Util.ConvertRouteStatusToActionType
8527: ( p_route_status_code => p_response_code
8528: , p_convert_type => 'RESPONSE' ) ;
8529:
8530: -- Record Action
8527: ( p_route_status_code => p_response_code
8528: , p_convert_type => 'RESPONSE' ) ;
8529:
8530: -- Record Action
8531: Eng_Workflow_Util.CreateAction
8532: ( x_return_status => l_return_status
8533: , x_msg_count => l_msg_count
8534: , x_msg_data => l_msg_data
8535: , p_item_type => p_item_type
8579: IF g_debug_flag THEN
8580: Write_Debug('Result is null and call RespondToDuplicateNtf: ' || dup_ntf_rec.NOTIFICATION_ID ) ;
8581: END IF ;
8582:
8583: Eng_Workflow_Util.RespondToDuplicateNtf( p_dupllicate_ntf_id => dup_ntf_rec.notification_id
8584: , p_orig_ntf_id => p_notification_id
8585: , p_responder => dup_ntf_rec.RECIPIENT_ROLE
8586: ) ;
8587: END IF ;
8605: -- If the response is the value specified in AUTO_REVOKE_RESPONSE NTF Attribute
8606: -- we will revoke roles on this wf assignee
8607: -- Record Route Response
8608: IF ( p_funcmode = 'RESPOND'
8609: AND ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
8610: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE
8611: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE
8612: )
8613: )
8606: -- we will revoke roles on this wf assignee
8607: -- Record Route Response
8608: IF ( p_funcmode = 'RESPOND'
8609: AND ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
8610: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE
8611: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE
8612: )
8613: )
8614: THEN
8607: -- Record Route Response
8608: IF ( p_funcmode = 'RESPOND'
8609: AND ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
8610: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE
8611: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE
8612: )
8613: )
8614: THEN
8615:
8636: THEN
8637:
8638: l_obj_index := 0 ;
8639: l_person_idx := 0 ;
8640: IF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE )
8641: THEN
8642: l_obj_index := l_obj_index + 1 ;
8643: l_target_obj_tbl.EXTEND ;
8644: l_target_obj_tbl(l_obj_index) := G_DOM_DOCUMENT_REVISION ;
8649: l_person_id_tbl(l_person_idx + 1) := l_performer_party_id ;
8650:
8651:
8652: IF g_debug_flag THEN
8653: Write_Debug('Calling Eng_Workflow_Util.RevokeObjectRoles for this assignee: ' || l_performer_party_id );
8654: END IF ;
8655:
8656:
8657: Eng_Workflow_Util.RevokeObjectRoles
8653: Write_Debug('Calling Eng_Workflow_Util.RevokeObjectRoles for this assignee: ' || l_performer_party_id );
8654: END IF ;
8655:
8656:
8657: Eng_Workflow_Util.RevokeObjectRoles
8658: ( p_api_version => 1.0
8659: , p_init_msg_list => FND_API.G_FALSE --
8660: , p_commit => FND_API.G_FALSE --
8661: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
8675: , p_revoke_option => NULL
8676: ) ;
8677:
8678: IF g_debug_flag THEN
8679: Write_Debug('After Eng_Workflow_Util.RevokeObjectRoles.' || l_return_status );
8680: END IF ;
8681:
8682: --
8683: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
8694: EXCEPTION
8695: WHEN OTHERS THEN
8696:
8697: IF g_debug_flag THEN
8698: Write_Debug('Eng_Workflow_Util.SetRouteResponse Unxexpected Error.' || SQLERRM);
8699: END IF ;
8700:
8701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8702:
8735: wf_item_type,
8736: wf_process_name
8737: FROM ENG_CHANGE_ROUTE_STEPS
8738: WHERE route_id = p_route_id
8739: AND step_status_code = Eng_Workflow_Util.G_RT_NOT_STARTED
8740: AND step_start_date IS NULL
8741: AND step_end_date IS NULL
8742: ORDER BY 2 ASC ;
8743:
8827:
8828: BEGIN
8829:
8830: IF g_debug_flag THEN
8831: Write_Debug('Eng_Workflow_Util.StartNextRouteStep Log');
8832: Write_Debug('-----------------------------------------------------');
8833: Write_Debug('Route Item Type : ' || p_route_item_type );
8834: Write_Debug('Route Item Key : ' || p_route_item_key );
8835: Write_Debug('Route Id : ' || TO_CHAR(p_route_id) );
8862:
8863:
8864: IF x_step_id IS NULL THEN
8865:
8866: x_return_status := Eng_Workflow_Util.G_RET_STS_NONE ;
8867: RETURN ;
8868:
8869: END IF ;
8870:
8869: END IF ;
8870:
8871:
8872: -- FND_MSG_PUB.initialize ;
8873: Eng_Workflow_Util.StartWorkflow
8874: ( p_api_version => 1.0
8875: , p_init_msg_list => FND_API.G_FALSE
8876: , p_commit => FND_API.G_FALSE
8877: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
8910:
8911: END IF ;
8912:
8913: IF g_debug_flag THEN
8914: Write_Debug('After call Eng_Workflow_Util.StartWorkflow' ) ;
8915: Write_Debug('Return Status: ' || x_return_status ) ;
8916: Write_Debug('Return Message: ' || x_msg_data ) ;
8917: Write_Debug('Started Step Id : ' || x_step_id ) ;
8918: Write_Debug('Started Step WF Item Type: ' || x_step_item_type ) ;
8969: , wi.root_activity wf_process_name
8970: FROM WF_ITEMS wi
8971: WHERE wi.parent_item_type = p_route_item_type
8972: AND wi.parent_item_key = p_route_item_key
8973: AND wi.item_type IN ( Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
8974: , Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE
8975: , Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE )
8976: AND wi.end_date IS NULL ;
8977:
8970: FROM WF_ITEMS wi
8971: WHERE wi.parent_item_type = p_route_item_type
8972: AND wi.parent_item_key = p_route_item_key
8973: AND wi.item_type IN ( Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
8974: , Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE
8975: , Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE )
8976: AND wi.end_date IS NULL ;
8977:
8978: BEGIN
8971: WHERE wi.parent_item_type = p_route_item_type
8972: AND wi.parent_item_key = p_route_item_key
8973: AND wi.item_type IN ( Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
8974: , Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE
8975: , Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE )
8976: AND wi.end_date IS NULL ;
8977:
8978: BEGIN
8979:
8977:
8978: BEGIN
8979:
8980: IF g_debug_flag THEN
8981: Write_Debug('Eng_Workflow_Util.AbortRouteStepsLog');
8982: Write_Debug('-----------------------------------------------------');
8983: Write_Debug('Route Item Type : ' || p_route_item_type );
8984: Write_Debug('Route Item Key : ' || p_route_item_key );
8985: Write_Debug('-----------------------------------------------------');
8999: Write_Debug('Step Item Key : ' || abort_step_rec.wf_item_key);
9000: END IF ;
9001:
9002:
9003: Eng_Workflow_Util.AbortWorkflow
9004: ( p_api_version => 1.0
9005: , p_init_msg_list => FND_API.G_FALSE
9006: , p_commit => FND_API.G_FALSE
9007: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
9029:
9030: END LOOP ;
9031:
9032: IF g_debug_flag THEN
9033: Write_Debug('After call Eng_Workflow_Util.AbortWorkflow' ) ;
9034: Write_Debug('Return Status: ' || x_return_status ) ;
9035: Write_Debug('Return Message: ' || x_msg_data ) ;
9036: END IF ;
9037:
9172: , ecr.wf_item_type
9173: , ecr.wf_process_name
9174: FROM ENG_CHANGE_LINES ecl
9175: , ENG_CHANGE_ROUTES ecr
9176: WHERE ( ecl.status_code <> Eng_Workflow_Util.G_CL_COMPLETED
9177: AND ecl.status_code <> Eng_Workflow_Util.G_CL_CANCELLED )
9178: AND ( ecl.approval_status_type <> Eng_Workflow_Util.G_APPROVED
9179: AND ecl.approval_status_type <> Eng_Workflow_Util.G_REQUESTED )
9180: AND ecl.sequence_number <> -1
9173: , ecr.wf_process_name
9174: FROM ENG_CHANGE_LINES ecl
9175: , ENG_CHANGE_ROUTES ecr
9176: WHERE ( ecl.status_code <> Eng_Workflow_Util.G_CL_COMPLETED
9177: AND ecl.status_code <> Eng_Workflow_Util.G_CL_CANCELLED )
9178: AND ( ecl.approval_status_type <> Eng_Workflow_Util.G_APPROVED
9179: AND ecl.approval_status_type <> Eng_Workflow_Util.G_REQUESTED )
9180: AND ecl.sequence_number <> -1
9181: -- AND ecl.parent_line_id IS NULL
9174: FROM ENG_CHANGE_LINES ecl
9175: , ENG_CHANGE_ROUTES ecr
9176: WHERE ( ecl.status_code <> Eng_Workflow_Util.G_CL_COMPLETED
9177: AND ecl.status_code <> Eng_Workflow_Util.G_CL_CANCELLED )
9178: AND ( ecl.approval_status_type <> Eng_Workflow_Util.G_APPROVED
9179: AND ecl.approval_status_type <> Eng_Workflow_Util.G_REQUESTED )
9180: AND ecl.sequence_number <> -1
9181: -- AND ecl.parent_line_id IS NULL
9182: -- AND ecr.status_code = Eng_Workflow_Util.G_RT_NOT_STARTED
9175: , ENG_CHANGE_ROUTES ecr
9176: WHERE ( ecl.status_code <> Eng_Workflow_Util.G_CL_COMPLETED
9177: AND ecl.status_code <> Eng_Workflow_Util.G_CL_CANCELLED )
9178: AND ( ecl.approval_status_type <> Eng_Workflow_Util.G_APPROVED
9179: AND ecl.approval_status_type <> Eng_Workflow_Util.G_REQUESTED )
9180: AND ecl.sequence_number <> -1
9181: -- AND ecl.parent_line_id IS NULL
9182: -- AND ecr.status_code = Eng_Workflow_Util.G_RT_NOT_STARTED
9183: AND ecl.change_type_id <> -1
9178: AND ( ecl.approval_status_type <> Eng_Workflow_Util.G_APPROVED
9179: AND ecl.approval_status_type <> Eng_Workflow_Util.G_REQUESTED )
9180: AND ecl.sequence_number <> -1
9181: -- AND ecl.parent_line_id IS NULL
9182: -- AND ecr.status_code = Eng_Workflow_Util.G_RT_NOT_STARTED
9183: AND ecl.change_type_id <> -1
9184: AND ecl.route_id = ecr.route_id
9185: AND ecl.change_id = p_change_id ;
9186:
9187:
9188: BEGIN
9189:
9190: IF g_debug_flag THEN
9191: Write_Debug('Eng_Workflow_Util.StartLineRoutes');
9192: Write_Debug('-----------------------------------------------------');
9193: Write_Debug('Item Type : ' || p_item_type );
9194: Write_Debug('Item Key : ' || p_item_key );
9195: Write_Debug('Change Id : ' || TO_CHAR(p_change_id) );
9196: Write_Debug('-----------------------------------------------------');
9197: END IF ;
9198:
9199: -- Initialize API return status to None:N
9200: l_return_status := Eng_Workflow_Util.G_RET_STS_NONE ;
9201: x_return_status := Eng_Workflow_Util.G_RET_STS_NONE ;
9202:
9203: --
9204: -- Don't try to get Parent Item Attributes from this procedure
9197: END IF ;
9198:
9199: -- Initialize API return status to None:N
9200: l_return_status := Eng_Workflow_Util.G_RET_STS_NONE ;
9201: x_return_status := Eng_Workflow_Util.G_RET_STS_NONE ;
9202:
9203: --
9204: -- Don't try to get Parent Item Attributes from this procedure
9205: -- because this proc is setting PRAGMA AUTONOMOUS_TRANSACTION
9216: l_line_item_key := null ;
9217:
9218: -- Start Change Line Workflows
9219: -- FND_MSG_PUB.initialize ;
9220: Eng_Workflow_Util.StartWorkflow
9221: ( p_api_version => 1.0
9222: , p_init_msg_list => FND_API.G_FALSE
9223: , p_commit => FND_API.G_FALSE
9224: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
9245:
9246: END IF ;
9247:
9248: IF g_debug_flag THEN
9249: Write_Debug('After call Eng_Workflow_Util.StartWorkflow' ) ;
9250: Write_Debug('Return Status: ' || l_return_status ) ;
9251: Write_Debug('Return Message: ' || x_msg_data ) ;
9252: Write_Debug('Started Change Line Id : ' || TO_CHAR(line_rec.change_line_id) ) ;
9253: Write_Debug('Started CL WF Item Type: ' || line_rec.wf_item_type) ;
9260:
9261:
9262:
9263: IF x_return_status = FND_API.G_RET_STS_SUCCESS
9264: OR x_return_status = Eng_Workflow_Util.G_RET_STS_NONE
9265: THEN
9266:
9267: COMMIT ;
9268:
9314: SELECT 'Non Approved Line Exists'
9315: FROM DUAL
9316: WHERE EXISTS ( SELECT null
9317: FROM ENG_CHANGE_LINES ecl
9318: WHERE ( ecl.status_code <> Eng_Workflow_Util.G_CL_COMPLETED
9319: AND ecl.status_code <> Eng_Workflow_Util.G_CL_CANCELLED )
9320: AND ecl.approval_status_type <> Eng_Workflow_Util.G_APPROVED
9321: AND ecl.change_type_id <> -1
9322: AND ecl.sequence_number <> -1
9315: FROM DUAL
9316: WHERE EXISTS ( SELECT null
9317: FROM ENG_CHANGE_LINES ecl
9318: WHERE ( ecl.status_code <> Eng_Workflow_Util.G_CL_COMPLETED
9319: AND ecl.status_code <> Eng_Workflow_Util.G_CL_CANCELLED )
9320: AND ecl.approval_status_type <> Eng_Workflow_Util.G_APPROVED
9321: AND ecl.change_type_id <> -1
9322: AND ecl.sequence_number <> -1
9323: -- AND ecl.parent_line_id IS NULL
9316: WHERE EXISTS ( SELECT null
9317: FROM ENG_CHANGE_LINES ecl
9318: WHERE ( ecl.status_code <> Eng_Workflow_Util.G_CL_COMPLETED
9319: AND ecl.status_code <> Eng_Workflow_Util.G_CL_CANCELLED )
9320: AND ecl.approval_status_type <> Eng_Workflow_Util.G_APPROVED
9321: AND ecl.change_type_id <> -1
9322: AND ecl.sequence_number <> -1
9323: -- AND ecl.parent_line_id IS NULL
9324: AND ecl.route_id IS NOT NULL
9330:
9331: -- Initialize API return status to success
9332: x_return_status := FND_API.G_RET_STS_SUCCESS;
9333:
9334: x_line_approval_status := Eng_Workflow_Util.G_APPROVED ;
9335:
9336: FOR l_approved_line_rec IN c_approved_line (p_change_id )
9337: LOOP
9338:
9335:
9336: FOR l_approved_line_rec IN c_approved_line (p_change_id )
9337: LOOP
9338:
9339: x_line_approval_status := Eng_Workflow_Util.G_REQUESTED ;
9340:
9341: END LOOP ;
9342:
9343:
9870: END IF ;
9871:
9872: IF MandatoryResultCode IS NOT NULL AND
9873: ( MandatoryResultCode = ResultCode
9874: OR Eng_Workflow_Util.G_MANDATORY_RESP_ANY = MandatoryResultCode
9875: ) -- Added for Route
9876: THEN
9877:
9878: --
9929: Write_Debug('l_total_voted: ' || to_char(l_total_voted) );
9930: Write_Debug('l_code_count: ' || to_char(l_code_count) );
9931: END IF ;
9932:
9933: IF ( Eng_Workflow_Util.G_MANDATORY_RESP_ANY = MandatoryResultCode )
9934: THEN
9935:
9936: IF g_debug_flag THEN
9937: Write_Debug('In case Mandaotry Response Code is ANY. . .' );
10022:
10023:
10024: exception
10025: when others then
10026: wf_core.context('Eng_Workflow_Util',
10027: 'PeopleLevelVoteCount',
10028: to_char(gid),
10029: ResultCode );
10030: raise;
10048: -- Route Notofication Call Back Functions
10049: --
10050: -- ACTIVITY ATTRIBUTES REFERENCED
10051: -- VOTING_OPTION
10052: -- Eng_Workflow_Util.G_PEOPLE - Evaluate voting after every vote.
10053: -- - After every vote voting percentages are
10054: -- - calculated as a percentage of user specified as
10055: -- - mandatory notified to vote. voting
10056: -- - percentages are calculated as a percentage
10116: end if;
10117:
10118: -- SYNCHMODE: Not allowed
10119: if (itemkey = wf_engine.eng_synch) then
10120: Wf_Core.Token('OPERATION', 'Eng_Workflow_Util.PeopleLevelVoteForResultType');
10121: Wf_Core.Raise('WFENG_SYNCH_DISABLED');
10122: end if;
10123:
10124: -- Always clear the cache first
10148:
10149:
10150: if (l_voting_option not in ('REQUIRE_ALL_VOTES', 'WAIT_FOR_ALL_VOTES',
10151: 'TALLY_ON_EVERY_VOTE'))
10152: AND (l_voting_option <> Eng_Workflow_Util.G_PEOPLE ) -- Added for Route
10153: then
10154: raise wf_invalid_command;
10155: end if;
10156:
10161: -- d. REQUIRE_ALL_VOTES and all votes are cast
10162: -- Tally votes.
10163: for result_rec in result_codes loop
10164:
10165: IF (l_voting_option = Eng_Workflow_Util.G_PEOPLE
10166: AND ( ( l_mandatory_result IS NOT NULL
10167: AND l_mandatory_result = result_rec.result_code )
10168: OR l_mandatory_result = Eng_Workflow_Util.G_MANDATORY_RESP_ANY
10169: )
10164:
10165: IF (l_voting_option = Eng_Workflow_Util.G_PEOPLE
10166: AND ( ( l_mandatory_result IS NOT NULL
10167: AND l_mandatory_result = result_rec.result_code )
10168: OR l_mandatory_result = Eng_Workflow_Util.G_MANDATORY_RESP_ANY
10169: )
10170: )
10171: THEN
10172:
10171: THEN
10172:
10173:
10174: IF g_debug_flag THEN
10175: Write_Debug('Calling Eng_Workflow_Util.PeopleLevelVoteCount . . .' );
10176: Write_Debug('Step Id : ' || to_char(l_route_step_id) );
10177: END IF ;
10178:
10179: -- Get Route Step Id
10185:
10186: -- Tally Vote Count for this result code
10187: -- in case that Votion Option is Assignee Level(PEOPLE)
10188: -- and it is reponse code should be tallied among mandatory responses
10189: Eng_Workflow_Util.PeopleLevelVoteCount
10190: (Gid => l_group_id,
10191: ResultCode => result_rec.result_code,
10192: MandatoryResultCode => l_mandatory_result,
10193: ResultCount => l_code_count,
10342:
10343:
10344: exception
10345: when wf_invalid_command then
10346: Wf_Core.Context('Eng_Workflow_Util', 'PeopleLevelVoteForResultType', itemtype,
10347: itemkey, to_char(actid), funcmode);
10348: Wf_Core.Token('COMMAND', l_voting_option);
10349: Wf_Core.Raise('WFSQL_COMMAND');
10350: when others then
10347: itemkey, to_char(actid), funcmode);
10348: Wf_Core.Token('COMMAND', l_voting_option);
10349: Wf_Core.Raise('WFSQL_COMMAND');
10350: when others then
10351: Wf_Core.Context('Eng_Workflow_Util', 'PeopleLevelVoteForResultType',itemtype,
10352: itemkey, to_char(actid), funcmode);
10353: raise;
10354:
10355:
10387: IF g_debug_flag THEN
10388: Write_Debug('Voting Option: ' || l_voting_option );
10389: END IF ;
10390:
10391: if (l_voting_option in (Eng_Workflow_Util.G_WAIT_FOR_ALL_VOTES,
10392: Eng_Workflow_Util.G_REQUIRE_ALL_VOTES,
10393: Eng_Workflow_Util.G_TALLY_ON_EVERY_VOTE)
10394: )
10395: then
10388: Write_Debug('Voting Option: ' || l_voting_option );
10389: END IF ;
10390:
10391: if (l_voting_option in (Eng_Workflow_Util.G_WAIT_FOR_ALL_VOTES,
10392: Eng_Workflow_Util.G_REQUIRE_ALL_VOTES,
10393: Eng_Workflow_Util.G_TALLY_ON_EVERY_VOTE)
10394: )
10395: then
10396:
10389: END IF ;
10390:
10391: if (l_voting_option in (Eng_Workflow_Util.G_WAIT_FOR_ALL_VOTES,
10392: Eng_Workflow_Util.G_REQUIRE_ALL_VOTES,
10393: Eng_Workflow_Util.G_TALLY_ON_EVERY_VOTE)
10394: )
10395: then
10396:
10397:
10395: then
10396:
10397:
10398: IF g_debug_flag THEN
10399: Write_Debug('Calling Eng_Workflow_Util.VoteForResultType . . . ' );
10400: END IF ;
10401:
10402: Eng_Workflow_Util.VoteForResultType
10403: ( itemtype
10398: IF g_debug_flag THEN
10399: Write_Debug('Calling Eng_Workflow_Util.VoteForResultType . . . ' );
10400: END IF ;
10401:
10402: Eng_Workflow_Util.VoteForResultType
10403: ( itemtype
10404: , itemkey
10405: , actid
10406: , funcmode
10405: , actid
10406: , funcmode
10407: , resultout ) ;
10408:
10409: elsif (l_voting_option = Eng_Workflow_Util.G_PEOPLE)
10410: then
10411:
10412:
10413: IF g_debug_flag THEN
10410: then
10411:
10412:
10413: IF g_debug_flag THEN
10414: Write_Debug('Calling Eng_Workflow_Util.Eng_Workflow_Util.PeopleLevelVoteForResultType . . . ' );
10415: END IF ;
10416:
10417: Eng_Workflow_Util.PeopleLevelVoteForResultType
10418: ( itemtype
10413: IF g_debug_flag THEN
10414: Write_Debug('Calling Eng_Workflow_Util.Eng_Workflow_Util.PeopleLevelVoteForResultType . . . ' );
10415: END IF ;
10416:
10417: Eng_Workflow_Util.PeopleLevelVoteForResultType
10418: ( itemtype
10419: , itemkey
10420: , actid
10421: , funcmode
10480:
10481:
10482:
10483: IF g_debug_flag THEN
10484: Write_Debug('Eng_Workflow_Util.ContinueHeaderRouteLog');
10485: Write_Debug('-----------------------------------------------------');
10486: Write_Debug('Item Type : ' || p_item_type );
10487: Write_Debug('Item Key : ' || p_item_key );
10488: Write_Debug('Acttivity Id : ' || to_char(p_actid));
10497:
10498: if (p_waiting_flow_type = 'APPROVAL') then
10499:
10500: -- Get Change Object Identifier
10501: Eng_Workflow_Util.GetChangeObject
10502: ( p_item_type => p_item_type
10503: , p_item_key => p_item_key
10504: , x_change_id => l_change_id
10505: ) ;
10537: WHERE item_type = l_parent_itemtype
10538: AND item_key = l_parent_itemkey
10539: FOR UPDATE ;
10540:
10541: Eng_Workflow_Util.CheckAllLineApproved
10542: ( x_return_status => x_return_status
10543: , x_msg_count => x_msg_count
10544: , x_msg_data => x_msg_data
10545: , p_change_id => l_change_id
10550: IF g_debug_flag THEN
10551: Write_Debug('After calling CheckAllLineApproved, line appr status: ' || to_char(l_line_approval_status) );
10552: END IF ;
10553:
10554: IF l_line_approval_status = Eng_Workflow_Util.G_APPROVED
10555: THEN
10556:
10557:
10558: begin
10630:
10631: if (p_continuation_flow_type = 'APPROVAL') then
10632:
10633: -- Get Change Object Identifier
10634: Eng_Workflow_Util.GetChangeObject
10635: ( p_item_type => p_item_type
10636: , p_item_key => p_item_key
10637: , x_change_id => l_change_id
10638: ) ;
10636: , p_item_key => p_item_key
10637: , x_change_id => l_change_id
10638: ) ;
10639:
10640: Eng_Workflow_Util.CheckAllLineApproved
10641: ( x_return_status => x_return_status
10642: , x_msg_count => x_msg_count
10643: , x_msg_data => x_msg_data
10644: , p_change_id => l_change_id
10645: , x_line_approval_status => l_line_approval_status
10646: ) ;
10647:
10648:
10649: IF l_line_approval_status <> Eng_Workflow_Util.G_APPROVED
10650: THEN
10651: x_resultout := wf_engine.eng_notified ||':'||
10652: wf_engine.eng_null ||':'||
10653: wf_engine.eng_null;
10730:
10731: END LOOP ;
10732:
10733:
10734: Eng_Workflow_util.GetChangeObject( p_item_type => p_itemtype
10735: , p_item_key => p_itemKey
10736: , x_change_id => l_change_Id
10737: );
10738:
10737: );
10738:
10739:
10740: -- create and start Response FYI process to send Resp FYI ntf
10741: Eng_Workflow_Util.StartWorkflow
10742: ( p_api_version => 1.0
10743: , p_init_msg_list => FND_API.G_FALSE
10744: , p_commit => FND_API.G_FALSE
10745: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
10826: x_return_status := FND_API.G_RET_STS_SUCCESS ;
10827:
10828:
10829: IF g_debug_flag THEN
10830: Write_Debug('Eng_Workflow_Util.StartValidateDefProcess Log');
10831: Write_Debug('-----------------------------------------------------');
10832: Write_Debug('Step Item Type : ' || p_step_item_type );
10833: Write_Debug('Step Item Key : ' || p_step_item_key );
10834: Write_Debug('Route Id : ' || TO_CHAR(p_route_id) );
10845: BEGIN
10846: l_return_status := FND_API.G_RET_STS_SUCCESS ;
10847:
10848: -- FND_MSG_PUB.initialize ;
10849: Eng_Workflow_Util.StartWorkflow
10850: ( p_api_version => 1.0
10851: , p_init_msg_list => FND_API.G_FALSE
10852: , p_commit => FND_API.G_FALSE
10853: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
10870: ) ;
10871:
10872:
10873: IF g_debug_flag THEN
10874: Write_Debug('After call Eng_Workflow_Util.StartWorkflow' ) ;
10875: Write_Debug('Return Status: ' || l_return_status ) ;
10876: Write_Debug('Return Message: ' || l_msg_data ) ;
10877: Write_Debug('Started Val Def WF Item Type: ' || p_val_def_item_type ) ;
10878: Write_Debug('Started Val Def WF Item Kye: ' || x_val_def_item_key ) ;
10933:
10934: IF p_convert_type = 'RESPONSE' THEN
10935:
10936: -- Convert Route Status to Action Type for User Response in Route
10937: IF p_route_status_code = Eng_Workflow_Util.G_RT_APPROVED
10938: THEN
10939:
10940: l_action_type := Eng_Workflow_Util.G_ACT_APPROVED ;
10941:
10936: -- Convert Route Status to Action Type for User Response in Route
10937: IF p_route_status_code = Eng_Workflow_Util.G_RT_APPROVED
10938: THEN
10939:
10940: l_action_type := Eng_Workflow_Util.G_ACT_APPROVED ;
10941:
10942: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_REJECTED
10943: THEN
10944:
10938: THEN
10939:
10940: l_action_type := Eng_Workflow_Util.G_ACT_APPROVED ;
10941:
10942: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_REJECTED
10943: THEN
10944:
10945: l_action_type := Eng_Workflow_Util.G_ACT_REJECTED ;
10946:
10941:
10942: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_REJECTED
10943: THEN
10944:
10945: l_action_type := Eng_Workflow_Util.G_ACT_REJECTED ;
10946:
10947: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_COMPLETED
10948: THEN
10949:
10943: THEN
10944:
10945: l_action_type := Eng_Workflow_Util.G_ACT_REJECTED ;
10946:
10947: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_COMPLETED
10948: THEN
10949:
10950: l_action_type := Eng_Workflow_Util.G_ACT_COMPLETED ;
10951:
10946:
10947: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_COMPLETED
10948: THEN
10949:
10950: l_action_type := Eng_Workflow_Util.G_ACT_COMPLETED ;
10951:
10952: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_REPLIED
10953: THEN
10954:
10948: THEN
10949:
10950: l_action_type := Eng_Workflow_Util.G_ACT_COMPLETED ;
10951:
10952: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_REPLIED
10953: THEN
10954:
10955: l_action_type := Eng_Workflow_Util.G_ACT_REPLIED;
10956:
10951:
10952: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_REPLIED
10953: THEN
10954:
10955: l_action_type := Eng_Workflow_Util.G_ACT_REPLIED;
10956:
10957:
10958: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_TIME_OUT
10959: THEN
10954:
10955: l_action_type := Eng_Workflow_Util.G_ACT_REPLIED;
10956:
10957:
10958: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_TIME_OUT
10959: THEN
10960:
10961: l_action_type := Eng_Workflow_Util.G_ACT_TIMEOUT_WF;
10962:
10957:
10958: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_TIME_OUT
10959: THEN
10960:
10961: l_action_type := Eng_Workflow_Util.G_ACT_TIMEOUT_WF;
10962:
10963: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_FORWARDED
10964: THEN
10965:
10959: THEN
10960:
10961: l_action_type := Eng_Workflow_Util.G_ACT_TIMEOUT_WF;
10962:
10963: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_FORWARDED
10964: THEN
10965:
10966: l_action_type := Eng_Workflow_Util.G_ACT_DELEGATED;
10967:
10962:
10963: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_FORWARDED
10964: THEN
10965:
10966: l_action_type := Eng_Workflow_Util.G_ACT_DELEGATED;
10967:
10968: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_TRANSFERRED
10969: THEN
10970:
10964: THEN
10965:
10966: l_action_type := Eng_Workflow_Util.G_ACT_DELEGATED;
10967:
10968: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_TRANSFERRED
10969: THEN
10970:
10971: l_action_type := Eng_Workflow_Util.G_ACT_TRANSFERRED;
10972:
10967:
10968: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_TRANSFERRED
10969: THEN
10970:
10971: l_action_type := Eng_Workflow_Util.G_ACT_TRANSFERRED;
10972:
10973:
10974: -- R12B
10975: -- Added for Line Workflow Request Response
10972:
10973:
10974: -- R12B
10975: -- Added for Line Workflow Request Response
10976: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_RECEIVED
10977: THEN
10978:
10979: l_action_type := Eng_Workflow_Util.G_ACT_RECEIVED;
10980:
10975: -- Added for Line Workflow Request Response
10976: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_RECEIVED
10977: THEN
10978:
10979: l_action_type := Eng_Workflow_Util.G_ACT_RECEIVED;
10980:
10981: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_DECLINED
10982: THEN
10983:
10977: THEN
10978:
10979: l_action_type := Eng_Workflow_Util.G_ACT_RECEIVED;
10980:
10981: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_DECLINED
10982: THEN
10983:
10984: l_action_type := Eng_Workflow_Util.G_ACT_DECLINED;
10985:
10980:
10981: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_DECLINED
10982: THEN
10983:
10984: l_action_type := Eng_Workflow_Util.G_ACT_DECLINED;
10985:
10986:
10987: ELSE
10988:
10985:
10986:
10987: ELSE
10988:
10989: l_action_type := Eng_Workflow_Util.G_ACT_COMPLETED ;
10990: END IF ;
10991:
10992: ELSIF p_convert_type = 'WF_PROCESS' THEN
10993: -- Convert Route Status to Action Type for Workflow Process Status
10991:
10992: ELSIF p_convert_type = 'WF_PROCESS' THEN
10993: -- Convert Route Status to Action Type for Workflow Process Status
10994:
10995: IF p_route_status_code = Eng_Workflow_Util.G_RT_IN_PROGRESS
10996: THEN
10997:
10998: l_action_type := Eng_Workflow_Util.G_ACT_WF_STARTED;
10999:
10994:
10995: IF p_route_status_code = Eng_Workflow_Util.G_RT_IN_PROGRESS
10996: THEN
10997:
10998: l_action_type := Eng_Workflow_Util.G_ACT_WF_STARTED;
10999:
11000: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_APPROVED
11001: THEN
11002:
10996: THEN
10997:
10998: l_action_type := Eng_Workflow_Util.G_ACT_WF_STARTED;
10999:
11000: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_APPROVED
11001: THEN
11002:
11003: l_action_type := Eng_Workflow_Util.G_ACT_WF_APPROVED ;
11004:
10999:
11000: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_APPROVED
11001: THEN
11002:
11003: l_action_type := Eng_Workflow_Util.G_ACT_WF_APPROVED ;
11004:
11005:
11006: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_REJECTED
11007: THEN
11002:
11003: l_action_type := Eng_Workflow_Util.G_ACT_WF_APPROVED ;
11004:
11005:
11006: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_REJECTED
11007: THEN
11008:
11009: l_action_type := Eng_Workflow_Util.G_ACT_WF_REJECTED;
11010:
11005:
11006: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_REJECTED
11007: THEN
11008:
11009: l_action_type := Eng_Workflow_Util.G_ACT_WF_REJECTED;
11010:
11011: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_COMPLETED
11012: THEN
11013:
11007: THEN
11008:
11009: l_action_type := Eng_Workflow_Util.G_ACT_WF_REJECTED;
11010:
11011: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_COMPLETED
11012: THEN
11013:
11014: l_action_type := Eng_Workflow_Util.G_ACT_WF_COMPLETED;
11015:
11010:
11011: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_COMPLETED
11012: THEN
11013:
11014: l_action_type := Eng_Workflow_Util.G_ACT_WF_COMPLETED;
11015:
11016: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_ABORTED
11017: THEN
11018:
11012: THEN
11013:
11014: l_action_type := Eng_Workflow_Util.G_ACT_WF_COMPLETED;
11015:
11016: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_ABORTED
11017: THEN
11018:
11019: l_action_type := Eng_Workflow_Util.G_ACT_WF_ABORTED;
11020:
11015:
11016: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_ABORTED
11017: THEN
11018:
11019: l_action_type := Eng_Workflow_Util.G_ACT_WF_ABORTED;
11020:
11021:
11022: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_TIME_OUT
11023: THEN
11018:
11019: l_action_type := Eng_Workflow_Util.G_ACT_WF_ABORTED;
11020:
11021:
11022: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_TIME_OUT
11023: THEN
11024:
11025: l_action_type := Eng_Workflow_Util.G_ACT_WF_TIME_OUT;
11026:
11021:
11022: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_TIME_OUT
11023: THEN
11024:
11025: l_action_type := Eng_Workflow_Util.G_ACT_WF_TIME_OUT;
11026:
11027: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_ERROR -- Not Stupported yet
11028: THEN
11029:
11023: THEN
11024:
11025: l_action_type := Eng_Workflow_Util.G_ACT_WF_TIME_OUT;
11026:
11027: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_ERROR -- Not Stupported yet
11028: THEN
11029:
11030: l_action_type := Eng_Workflow_Util.G_ACT_WF_PROCESS_ERROR ;
11031:
11026:
11027: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_ERROR -- Not Stupported yet
11028: THEN
11029:
11030: l_action_type := Eng_Workflow_Util.G_ACT_WF_PROCESS_ERROR ;
11031:
11032: ELSE
11033:
11034: l_action_type := Eng_Workflow_Util.G_ACT_WF_COMPLETED ;
11030: l_action_type := Eng_Workflow_Util.G_ACT_WF_PROCESS_ERROR ;
11031:
11032: ELSE
11033:
11034: l_action_type := Eng_Workflow_Util.G_ACT_WF_COMPLETED ;
11035:
11036: END IF ;
11037:
11038: END IF ;
11054:
11055: BEGIN
11056:
11057: -- Convert Notification Line Route Status to Distribution Line Status
11058: IF p_route_status_code = Eng_Workflow_Util.G_RT_IN_PROGRESS
11059: THEN
11060:
11061: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_DIST_IN_PROGRESS;
11062:
11057: -- Convert Notification Line Route Status to Distribution Line Status
11058: IF p_route_status_code = Eng_Workflow_Util.G_RT_IN_PROGRESS
11059: THEN
11060:
11061: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_DIST_IN_PROGRESS;
11062:
11063: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_APPROVED
11064: THEN
11065:
11059: THEN
11060:
11061: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_DIST_IN_PROGRESS;
11062:
11063: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_APPROVED
11064: THEN
11065:
11066: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_DISTRIBUTED ;
11067:
11062:
11063: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_APPROVED
11064: THEN
11065:
11066: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_DISTRIBUTED ;
11067:
11068:
11069: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_REJECTED
11070: THEN
11065:
11066: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_DISTRIBUTED ;
11067:
11068:
11069: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_REJECTED
11070: THEN
11071:
11072: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_NOT_DISTRIBUTED;
11073:
11068:
11069: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_REJECTED
11070: THEN
11071:
11072: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_NOT_DISTRIBUTED;
11073:
11074: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_COMPLETED
11075: THEN
11076:
11070: THEN
11071:
11072: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_NOT_DISTRIBUTED;
11073:
11074: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_COMPLETED
11075: THEN
11076:
11077: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_DISTRIBUTED;
11078:
11073:
11074: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_COMPLETED
11075: THEN
11076:
11077: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_DISTRIBUTED;
11078:
11079: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_ABORTED
11080: THEN
11081:
11075: THEN
11076:
11077: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_DISTRIBUTED;
11078:
11079: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_ABORTED
11080: THEN
11081:
11082: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_NOT_DISTRIBUTED;
11083:
11078:
11079: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_ABORTED
11080: THEN
11081:
11082: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_NOT_DISTRIBUTED;
11083:
11084:
11085: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_TIME_OUT
11086: THEN
11081:
11082: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_NOT_DISTRIBUTED;
11083:
11084:
11085: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_TIME_OUT
11086: THEN
11087:
11088: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_NOT_DISTRIBUTED;
11089:
11084:
11085: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_TIME_OUT
11086: THEN
11087:
11088: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_NOT_DISTRIBUTED;
11089:
11090: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_ERROR -- Not Stupported yet
11091: THEN
11092:
11086: THEN
11087:
11088: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_NOT_DISTRIBUTED;
11089:
11090: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_ERROR -- Not Stupported yet
11091: THEN
11092:
11093: l_dist_line_status_code := Eng_Workflow_Util.G_ACT_WF_PROCESS_ERROR ;
11094:
11089:
11090: ELSIF p_route_status_code = Eng_Workflow_Util.G_RT_ERROR -- Not Stupported yet
11091: THEN
11092:
11093: l_dist_line_status_code := Eng_Workflow_Util.G_ACT_WF_PROCESS_ERROR ;
11094:
11095: ELSE
11096:
11097: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_NOT_DISTRIBUTED ;
11093: l_dist_line_status_code := Eng_Workflow_Util.G_ACT_WF_PROCESS_ERROR ;
11094:
11095: ELSE
11096:
11097: l_dist_line_status_code := Eng_Workflow_Util.G_DIST_CL_NOT_DISTRIBUTED ;
11098:
11099: END IF ;
11100:
11101: RETURN l_dist_line_status_code ;
11153: -- Initialize API return status to success
11154: x_return_status := FND_API.G_RET_STS_SUCCESS;
11155:
11156: IF g_debug_flag THEN
11157: Write_Debug('Eng_Workflow_Util.RespondToActReqCommentFromUI Log');
11158: Write_Debug('-----------------------------------------------------');
11159: Write_Debug('Item Type : ' || p_item_type );
11160: Write_Debug('Item Key : ' || p_item_key );
11161: Write_Debug('Responder : ' || p_responder );
11274: -- Initialize API return status to success
11275: x_return_status := FND_API.G_RET_STS_SUCCESS;
11276:
11277: IF g_debug_flag THEN
11278: Write_Debug('Eng_Workflow_Util.SetChangeOrderMRPFlag Log');
11279: Write_Debug('-----------------------------------------------------');
11280: Write_Debug('Change Id : ' || to_char(p_change_id) );
11281: Write_Debug('MFP Flag : ' || to_char(p_change_id) );
11282: Write_Debug('WF User Id : ' || to_char(p_wf_user_id) );
11358: , x_msg_count OUT NOCOPY NUMBER
11359: , x_msg_data OUT NOCOPY VARCHAR2
11360: , p_item_type IN VARCHAR2
11361: , p_item_key IN VARCHAR2
11362: , p_url_type IN VARCHAR2 := Eng_Workflow_Util.G_MONITOR_DIAGRAM
11363: , p_admin_mode IN VARCHAR2 := FND_API.G_FALSE
11364: , p_option IN VARCHAR2 := NULL
11365: , x_url OUT NOCOPY VARCHAR2
11366: )
11412: l_wf_web_agent := WF_CORE.Translate('WF_WEB_AGENT') ;
11413:
11414:
11415:
11416: IF p_url_type = Eng_Workflow_Util.G_MONITOR_ACCESSKEY
11417: THEN
11418:
11419: x_url := WF_MONITOR.GetAccessKey
11420: ( x_item_type => p_item_type
11420: ( x_item_type => p_item_type
11421: , x_item_key => p_item_key
11422: , x_admin_mode => l_admin_mode ) ;
11423:
11424: ELSIF p_url_type = Eng_Workflow_Util.G_MONITOR_DIAGRAM
11425: THEN
11426:
11427: x_url := WF_MONITOR.GetDiagramURL
11428: ( x_agent => l_apps_web_agent
11429: , x_item_type => p_item_type
11430: , x_item_key => p_item_key
11431: , x_admin_mode => l_admin_mode ) ;
11432:
11433: ELSIF p_url_type = Eng_Workflow_Util.G_MONITOR_ENVELOPE
11434: THEN
11435:
11436: x_url := WF_MONITOR.GetEnvelopeURL
11437: ( x_agent => l_apps_web_agent
11439: , x_item_key => p_item_key
11440: , x_admin_mode => l_admin_mode ) ;
11441:
11442:
11443: ELSIF p_url_type = Eng_Workflow_Util.G_MONITOR_ADVANCED_ENVELOPE
11444: THEN
11445:
11446: x_url := WF_MONITOR.GetAdvancedEnvelopeURL
11447: ( x_agent => l_apps_web_agent
11709: l_action_id := p_action_id ;
11710: END IF ;
11711:
11712: IF g_debug_flag THEN
11713: Write_Debug('Eng_Workflow_Util.StartWorkflow Log');
11714: Write_Debug('-----------------------------------------------------');
11715: Write_Debug('Item Type : ' || p_item_type );
11716: Write_Debug('Item Key : ' || x_item_key );
11717: Write_Debug('Process Name : ' || p_process_name);
11809: Write_Debug('CM Workflows except Doc Phse WF Routing are not supported in Document LC ChangeObject. return. .. ');
11810: END IF ;
11811: -- At this time, not raising any error
11812: -- Set dummy item key
11813: x_item_key := Eng_Workflow_Util.G_RET_STS_NONE ;
11814: RETURN ;
11815:
11816: ELSE
11817:
11892:
11893: -- Set User Id
11894: IF p_wf_user_id IS NULL OR p_wf_user_id < 0
11895: THEN
11896: l_api_caller := Eng_Workflow_Util.G_WF_CALL ;
11897: END IF ;
11898:
11899: IF g_debug_flag THEN
11900: Write_Debug('2-2. Get Spcial API Caller: ' || l_api_caller );
11960: Write_Debug('Parent Item Key : ' || p_parent_item_key);
11961: END IF ;
11962:
11963: -- If Parent WF Info is not null and
11964: -- item_type is NOT Eng_Workflow_Util.G_CHANGE_ROUTE_ITEM_TYPE
11965: -- G_CHANGE_ROUTE_ITEM_TYPE has own API to set parent wf info
11966: IF p_parent_item_type IS NOT NULL
11967: AND p_parent_item_key IS NOT NULL
11968: AND p_item_type <> Eng_Workflow_Util.G_CHANGE_ROUTE_ITEM_TYPE
11964: -- item_type is NOT Eng_Workflow_Util.G_CHANGE_ROUTE_ITEM_TYPE
11965: -- G_CHANGE_ROUTE_ITEM_TYPE has own API to set parent wf info
11966: IF p_parent_item_type IS NOT NULL
11967: AND p_parent_item_key IS NOT NULL
11968: AND p_item_type <> Eng_Workflow_Util.G_CHANGE_ROUTE_ITEM_TYPE
11969: THEN
11970:
11971: -- Set Parent Worklfow Process
11972: WF_ENGINE.SetItemParent
11979:
11980: END IF ;
11981:
11982:
11983: IF p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_ITEM_TYPE
11984: THEN
11985:
11986: IF g_debug_flag THEN
11987: Write_Debug('4-2. Set Route Status . . .');
11991: ( p_item_type => p_item_type
11992: , p_item_key => x_item_key
11993: , p_wf_user_id => p_wf_user_id
11994: , p_route_id => p_route_id
11995: , p_new_status_code => Eng_Workflow_Util.G_RT_IN_PROGRESS
11996: , p_init_route => FND_API.G_TRUE
11997: , p_change_id => l_change_id
11998: , p_change_line_id => l_change_line_id -- Added in R12B
11999: ) ;
11999: ) ;
12000:
12001:
12002: -- In case that Route Object is Change Object
12003: IF p_object_name = Eng_Workflow_Util.G_ENG_CHANGE
12004: THEN
12005:
12006: /***********************************************
12007: --
12020: -- , p_item_key => x_item_key
12021: -- , p_change_id => l_change_id
12022: -- , p_change_line_id => l_change_line_id
12023: -- , p_wf_user_id => p_wf_user_id
12024: -- , p_new_appr_status_type => Eng_Workflow_Util.G_REQUESTED
12025: -- ) ;
12026: --
12027:
12028: -- IF g_debug_flag THEN
12039:
12040: IF g_debug_flag THEN
12041: Write_Debug('4-4. Set Workflow Routing Action Log . . .');
12042: END IF ;
12043: l_action_type := Eng_Workflow_Util.ConvertRouteStatusToActionType
12044: ( p_route_status_code => Eng_Workflow_Util.G_RT_IN_PROGRESS
12045: , p_convert_type => 'WF_PROCESS' ) ;
12046:
12047: CreateRouteAction
12040: IF g_debug_flag THEN
12041: Write_Debug('4-4. Set Workflow Routing Action Log . . .');
12042: END IF ;
12043: l_action_type := Eng_Workflow_Util.ConvertRouteStatusToActionType
12044: ( p_route_status_code => Eng_Workflow_Util.G_RT_IN_PROGRESS
12045: , p_convert_type => 'WF_PROCESS' ) ;
12046:
12047: CreateRouteAction
12048: ( x_return_status => x_return_status
12078: Write_Debug('4-5. Sync Workflow Routing Status and LC Phase WF Status. . .');
12079: END IF ;
12080:
12081: -- R12B
12082: -- No need to call Eng_Workflow_Util.SyncChangeLCPhase
12083: -- For Line
12084: IF ( l_change_line_id IS NULL OR l_change_line_id <= 0)
12085: THEN
12086:
12084: IF ( l_change_line_id IS NULL OR l_change_line_id <= 0)
12085: THEN
12086:
12087: -- Call Sync Change Lifecycle Phase API
12088: Eng_Workflow_Util.SyncChangeLCPhase
12089: ( x_return_status => x_return_status
12090: , x_msg_count => x_msg_count
12091: , x_msg_data => x_msg_data
12092: , p_route_id => p_route_id
12108:
12109:
12110: -- R12B Line Workfow Routing
12111: -- In case that Route Object is Change Line Object
12112: ELSIF p_object_name = Eng_Workflow_Util.G_ENG_CHANGE_LINE
12113: THEN
12114:
12115:
12116: IF g_debug_flag THEN
12115:
12116: IF g_debug_flag THEN
12117: Write_Debug('4-4. Set Line 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 Line 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
12150: , p_action_id => l_action_id
12151: ) ;
12152:
12153:
12154: END IF ; -- End if p_object_name = Eng_Workflow_Util.G_ENG_CHANGE_LINE
12155:
12156:
12157: /***********************************************
12158: -- In 115.10
12186:
12187:
12188:
12189:
12190: ELSIF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
12191: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE
12192: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE
12193: )
12194: THEN
12187:
12188:
12189:
12190: ELSIF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
12191: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE
12192: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE
12193: )
12194: THEN
12195:
12188:
12189:
12190: ELSIF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
12191: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE
12192: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE
12193: )
12194: THEN
12195:
12196: IF g_debug_flag THEN
12196: IF g_debug_flag THEN
12197: Write_Debug('4-2. Set Route Step Status . . .' || to_char(p_route_step_id));
12198: END IF ;
12199:
12200: Eng_Workflow_Util.SetRouteStepStatus
12201: ( p_item_type => p_item_type
12202: , p_item_key => x_item_key
12203: , p_wf_user_id => p_wf_user_id
12204: , p_route_id => p_route_id
12202: , p_item_key => x_item_key
12203: , p_wf_user_id => p_wf_user_id
12204: , p_route_id => p_route_id
12205: , p_route_step_id => p_route_step_id
12206: , p_new_status_code => Eng_Workflow_Util.G_RT_IN_PROGRESS
12207: ) ;
12208:
12209:
12210: IF g_debug_flag THEN
12232: -- same roles specified in WF Definition will be granted to the original assignee will be kept.
12233: -- In addition view grants will be provided to the new assignees
12234: --
12235: IF g_debug_flag THEN
12236: Write_Debug('calling Eng_Workflow_Util.GrantObjectRoles.' );
12237: END IF ;
12238:
12239: l_index := 0 ;
12240: l_target_obj_tbl := FND_TABLE_OF_VARCHAR2_30();
12237: END IF ;
12238:
12239: l_index := 0 ;
12240: l_target_obj_tbl := FND_TABLE_OF_VARCHAR2_30();
12241: IF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE )
12242: THEN
12243: l_target_obj_tbl.EXTEND ;
12244: l_index := l_index + 1 ;
12245: l_target_obj_tbl(l_index) := G_DOM_DOCUMENT_REVISION ;
12245: l_target_obj_tbl(l_index) := G_DOM_DOCUMENT_REVISION ;
12246: END IF ;
12247:
12248:
12249: Eng_Workflow_Util.GrantObjectRoles
12250: ( p_api_version => 1.0
12251: , p_init_msg_list => FND_API.G_FALSE --
12252: , p_commit => FND_API.G_FALSE --
12253: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
12268: ) ;
12269:
12270:
12271: IF g_debug_flag THEN
12272: Write_Debug('After Eng_Workflow_Util.GrantObjectRoles: ' || l_return_status );
12273: END IF ;
12274:
12275: --
12276: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
12535: -- END IF;
12536:
12537:
12538: IF g_debug_flag THEN
12539: Write_Debug('Eng_Workflow_Util.AbortWorkflow Log');
12540: Write_Debug('-----------------------------------------------------');
12541: Write_Debug('Item Type : ' || p_item_type );
12542: Write_Debug('Item Key : ' || p_item_Key );
12543: Write_Debug('Process Name : ' || p_process_name);
12614: ) ;
12615:
12616: ELSE
12617:
12618: l_api_caller := Eng_Workflow_Util.G_WF_CALL ;
12619:
12620: END IF ;
12621:
12622:
12626: END IF ;
12627:
12628:
12629: -- Put the Item Type specific logic here
12630: IF p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_ITEM_TYPE
12631: THEN
12632:
12633: IF g_debug_flag THEN
12634: Write_Debug('3-1. Set Route Status . . .');
12634: Write_Debug('3-1. Set Route Status . . .');
12635: END IF ;
12636:
12637: -- Get Change Object Identifier
12638: Eng_Workflow_Util.GetChangeObject
12639: ( p_item_type => p_item_type
12640: , p_item_key => p_item_key
12641: , x_change_id => l_change_id
12642: ) ;
12642: ) ;
12643:
12644:
12645: -- Get Change Line Object Identifier
12646: Eng_Workflow_Util.GetChangeLineObject
12647: ( p_item_type => p_item_type
12648: , p_item_key => p_item_key
12649: , x_change_line_id => l_change_line_id
12650: ) ;
12649: , x_change_line_id => l_change_line_id
12650: ) ;
12651:
12652: -- Get Route Id
12653: Eng_Workflow_Util.GetRouteId
12654: ( p_item_type => p_item_type
12655: , p_item_key => p_item_key
12656: , x_route_id => l_route_id
12657: ) ;
12656: , x_route_id => l_route_id
12657: ) ;
12658:
12659: -- Get Route Object Name
12660: Eng_Workflow_Util.GetRouteObject
12661: ( p_item_type => p_item_type
12662: , p_item_key => p_item_key
12663: , x_route_object => l_route_object_name
12664: ) ;
12669: ( p_item_type => p_item_type
12670: , p_item_key => p_item_key
12671: , p_wf_user_id => p_wf_user_id
12672: , p_route_id => l_route_id
12673: , p_new_status_code => Eng_Workflow_Util.G_RT_ABORTED
12674: , p_change_id => l_change_id
12675: , p_change_line_id => l_change_line_id -- Added in R12B
12676: ) ;
12677:
12689: -- , p_item_key => p_item_key
12690: -- , p_change_id => l_change_id
12691: -- , p_change_line_id => l_change_line_id
12692: -- , p_wf_user_id => p_wf_user_id
12693: -- , p_new_appr_status_type => Eng_Workflow_Util.G_NOT_SUBMITTED
12694: -- ) ;
12695:
12696: IF g_debug_flag THEN
12697: Write_Debug('After Set Approval Status .' || x_return_status );
12727: END IF ;
12728:
12729:
12730: -- In case that Route Object is Change Object
12731: IF l_route_object_name = Eng_Workflow_Util.G_ENG_CHANGE
12732: THEN
12733:
12734: --
12735: -- R12 DOM LC Phase Workflow Support
12770: Write_Debug('3-4. Set Workflow Routing Action Log . . .');
12771: END IF ;
12772:
12773: -- Get Action Id and set this as parent action id
12774: Eng_Workflow_Util.GetActionId
12775: ( p_item_type => p_item_type
12776: , p_item_key => p_item_key
12777: , x_action_id => l_parent_action_id
12778: ) ;
12776: , p_item_key => p_item_key
12777: , x_action_id => l_parent_action_id
12778: ) ;
12779:
12780: l_action_type := Eng_Workflow_Util.ConvertRouteStatusToActionType
12781: ( p_route_status_code => Eng_Workflow_Util.G_RT_ABORTED
12782: , p_convert_type => 'WF_PROCESS' ) ;
12783:
12784:
12777: , x_action_id => l_parent_action_id
12778: ) ;
12779:
12780: l_action_type := Eng_Workflow_Util.ConvertRouteStatusToActionType
12781: ( p_route_status_code => Eng_Workflow_Util.G_RT_ABORTED
12782: , p_convert_type => 'WF_PROCESS' ) ;
12783:
12784:
12785: CreateRouteAction
12806: END IF ;
12807:
12808:
12809: -- R12B
12810: -- No need to call Eng_Workflow_Util.SyncChangeLCPhase
12811: -- For Line
12812: IF ( l_change_line_id IS NULL OR l_change_line_id <= 0)
12813: THEN
12814:
12812: IF ( l_change_line_id IS NULL OR l_change_line_id <= 0)
12813: THEN
12814:
12815: -- Call Sync Change Lifecycle Phase API
12816: Eng_Workflow_Util.SyncChangeLCPhase
12817: ( x_return_status => x_return_status
12818: , x_msg_count => x_msg_count
12819: , x_msg_data => x_msg_data
12820: , p_route_id => l_route_id
12834:
12835:
12836: -- R12B Line Workfow Routing
12837: -- In case that Route Object is Change Line Object
12838: ELSIF l_route_object_name = Eng_Workflow_Util.G_ENG_CHANGE_LINE
12839: THEN
12840:
12841:
12842: IF g_debug_flag THEN
12843: Write_Debug('4-4. Set Line Workflow Routing Action Log . . .');
12844: END IF ;
12845:
12846: -- Get Action Id and set this as parent action id
12847: Eng_Workflow_Util.GetActionId
12848: ( p_item_type => p_item_type
12849: , p_item_key => p_item_key
12850: , x_action_id => l_parent_action_id
12851: ) ;
12850: , x_action_id => l_parent_action_id
12851: ) ;
12852:
12853:
12854: l_action_type := Eng_Workflow_Util.ConvertRouteStatusToActionType
12855: ( p_route_status_code => Eng_Workflow_Util.G_RT_ABORTED
12856: , p_convert_type => 'WF_PROCESS' ) ;
12857:
12858:
12851: ) ;
12852:
12853:
12854: l_action_type := Eng_Workflow_Util.ConvertRouteStatusToActionType
12855: ( p_route_status_code => Eng_Workflow_Util.G_RT_ABORTED
12856: , p_convert_type => 'WF_PROCESS' ) ;
12857:
12858:
12859: CreateRouteAction
12879: RAISE FND_API.G_EXC_ERROR ;
12880: END IF ;
12881:
12882:
12883: END IF ; -- End if p_object_name = Eng_Workflow_Util.G_ENG_CHANGE_LINE
12884:
12885:
12886:
12887:
12902: END IF ;
12903:
12904:
12905: IF g_debug_flag THEN
12906: Write_Debug('Calling Eng_Workflow_Util.RevokeObjectRoles . . . . ');
12907: END IF ;
12908:
12909:
12910: Eng_Workflow_Util.RevokeObjectRoles
12906: Write_Debug('Calling Eng_Workflow_Util.RevokeObjectRoles . . . . ');
12907: END IF ;
12908:
12909:
12910: Eng_Workflow_Util.RevokeObjectRoles
12911: ( p_api_version => 1.0
12912: , p_init_msg_list => FND_API.G_FALSE --
12913: , p_commit => FND_API.G_FALSE --
12914: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
12928: ) ;
12929:
12930:
12931: IF g_debug_flag THEN
12932: Write_Debug('After Eng_Workflow_Util.RevokeObjectRoles.' || l_return_status );
12933: END IF ;
12934:
12935: --
12936: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
12939: -- END IF ;
12940: --
12941:
12942: -- R12B
12943: ELSIF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
12944: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE
12945: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE
12946: )
12947: THEN
12940: --
12941:
12942: -- R12B
12943: ELSIF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
12944: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE
12945: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE
12946: )
12947: THEN
12948:
12941:
12942: -- R12B
12943: ELSIF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
12944: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE
12945: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE
12946: )
12947: THEN
12948:
12949: -- Get Route Step Id
12962: , p_item_key => p_item_key
12963: , p_wf_user_id => p_wf_user_id
12964: , p_route_id => l_route_id
12965: , p_route_step_id => l_route_step_id
12966: , p_new_status_code => Eng_Workflow_Util.G_RT_ABORTED
12967: ) ;
12968:
12969:
12970: END IF ;
13014:
13015: CheckWFActivityStatus
13016: ( p_item_type => p_item_type
13017: , p_item_key => p_item_key
13018: , p_activity_name => Eng_Workflow_Util.G_BLOCK_ABORT_ACTIVITY
13019: , x_activity_status => l_activity_status
13020: );
13021:
13022: IF g_debug_flag THEN
13024: END IF ;
13025:
13026:
13027:
13028: IF (l_activity_status = Eng_Workflow_Util.G_WF_NOTIFIED)
13029: THEN
13030:
13031: IF g_debug_flag THEN
13032: Write_Debug('6-2. Complete Abort Block Activity. . .' );
13034:
13035:
13036: WF_ENGINE.CompleteActivity( p_item_type
13037: , p_item_key
13038: , Eng_Workflow_Util.G_BLOCK_ABORT_ACTIVITY
13039: , Eng_Workflow_Util.G_WF_COMPLETE
13040: );
13041:
13042: ELSE
13035:
13036: WF_ENGINE.CompleteActivity( p_item_type
13037: , p_item_key
13038: , Eng_Workflow_Util.G_BLOCK_ABORT_ACTIVITY
13039: , Eng_Workflow_Util.G_WF_COMPLETE
13040: );
13041:
13042: ELSE
13043:
13235: WHERE RoutePeople.assignee_id = EngSecPeople.person_id
13236: -- AND RoutePeople.assignee_type_code = p_assignee_type_code
13237: AND RoutePeople.step_id = p_step_id
13238: AND ( RoutePeople.response_code IS NULL
13239: OR RoutePeople.response_code = Eng_Workflow_Util.G_RT_SUBMITTED
13240: OR RoutePeople.response_code = Eng_Workflow_Util.G_RT_NOT_RECEIVED )
13241: AND EngSecPeople.user_name = wn.recipient_role
13242: AND wn.notification_id = p_notification_id ;
13243:
13236: -- AND RoutePeople.assignee_type_code = p_assignee_type_code
13237: AND RoutePeople.step_id = p_step_id
13238: AND ( RoutePeople.response_code IS NULL
13239: OR RoutePeople.response_code = Eng_Workflow_Util.G_RT_SUBMITTED
13240: OR RoutePeople.response_code = Eng_Workflow_Util.G_RT_NOT_RECEIVED )
13241: AND EngSecPeople.user_name = wn.recipient_role
13242: AND wn.notification_id = p_notification_id ;
13243:
13244: CURSOR c_report_people_assocs (p_route_people_id NUMBER)
13356:
13357:
13358:
13359:
13360: l_default_assignee_resp := Eng_Workflow_Util.G_RT_SUBMITTED ;
13361:
13362: IF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE
13363: AND Eng_Workflow_Util.Is_Line_Ntf_WF(p_route_id => l_route_id)
13364: )
13358:
13359:
13360: l_default_assignee_resp := Eng_Workflow_Util.G_RT_SUBMITTED ;
13361:
13362: IF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE
13363: AND Eng_Workflow_Util.Is_Line_Ntf_WF(p_route_id => l_route_id)
13364: )
13365: THEN
13366:
13359:
13360: l_default_assignee_resp := Eng_Workflow_Util.G_RT_SUBMITTED ;
13361:
13362: IF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE
13363: AND Eng_Workflow_Util.Is_Line_Ntf_WF(p_route_id => l_route_id)
13364: )
13365: THEN
13366:
13367: IF g_debug_flag THEN
13367: IF g_debug_flag THEN
13368: Write_Debug('Calling GetStepDefaultRespCode ' ) ;
13369: END IF ;
13370:
13371: Eng_Workflow_Util.GetStepDefaultRespCode
13372: ( p_step_id => l_step_id
13373: , x_default_resp_code => l_default_assignee_resp
13374: ) ;
13375:
13452: -- CreateAction API will take care of inserting the action
13453: -- properly for Line Workflow too.
13454: IF l_change_id IS NOT NULL AND l_change_id > 0
13455: THEN
13456: l_action_type := Eng_Workflow_Util.ConvertRouteStatusToActionType
13457: ( p_route_status_code => l_response_code
13458: , p_convert_type => 'RESPONSE' ) ;
13459:
13460: -- Record Action
13457: ( p_route_status_code => l_response_code
13458: , p_convert_type => 'RESPONSE' ) ;
13459:
13460: -- Record Action
13461: Eng_Workflow_Util.CreateAction
13462: ( x_return_status => l_return_status
13463: , x_msg_count => l_msg_count
13464: , x_msg_data => l_msg_data
13465: , p_item_type => p_item_type
13484:
13485: --
13486: -- R12B
13487: -- Grant Object Roles for this new assignee
13488: IF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
13489: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE
13490: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE
13491: )
13492: THEN
13485: --
13486: -- R12B
13487: -- Grant Object Roles for this new assignee
13488: IF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
13489: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE
13490: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE
13491: )
13492: THEN
13493:
13486: -- R12B
13487: -- Grant Object Roles for this new assignee
13488: IF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
13489: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE
13490: OR p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_LINE_STEP_TYPE
13491: )
13492: THEN
13493:
13494:
13494:
13495: l_obj_index := 0 ;
13496: l_person_idx := 0 ;
13497:
13498: IF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE )
13499: THEN
13500: l_target_obj_tbl := FND_TABLE_OF_VARCHAR2_30();
13501: l_target_obj_tbl.EXTEND ;
13502: l_obj_index := l_obj_index + 1 ;
13510: l_person_id_tbl(l_person_idx) := l_new_party_id ;
13511:
13512:
13513: IF g_debug_flag THEN
13514: Write_Debug('Calling Eng_Workflow_Util.GrantObjectRoles for transfer assignee: ' || l_new_party_id );
13515: END IF ;
13516:
13517: Eng_Workflow_Util.GrantObjectRoles
13518: ( p_api_version => 1.0
13513: IF g_debug_flag THEN
13514: Write_Debug('Calling Eng_Workflow_Util.GrantObjectRoles for transfer assignee: ' || l_new_party_id );
13515: END IF ;
13516:
13517: Eng_Workflow_Util.GrantObjectRoles
13518: ( p_api_version => 1.0
13519: , p_init_msg_list => FND_API.G_FALSE --
13520: , p_commit => FND_API.G_FALSE --
13521: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
13535: , p_grant_option => NULL
13536: ) ;
13537:
13538: IF g_debug_flag THEN
13539: Write_Debug('After Eng_Workflow_Util.GrantObjectRoles: ' || l_return_status );
13540: END IF ;
13541:
13542: --
13543: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
13744: END IF ;
13745:
13746:
13747: IF g_debug_flag THEN
13748: Write_Debug('Eng_Workflow_Util.GrantObjectRoles Log');
13749: Write_Debug('-----------------------------------------------------');
13750: Write_Debug('Change Id : ' || TO_CHAR(p_change_id) );
13751: Write_Debug('Change Line Id : ' || TO_CHAR(p_change_line_id) );
13752: Write_Debug('Route Id : ' || TO_CHAR(p_route_id));
14265: SELECT routes.OBJECT_ID1 CHANGE_ID
14266: , TO_NUMBER(NULL) CHANGE_LINE_ID
14267: , routes.ROUTE_ID
14268: FROM ENG_CHANGE_ROUTES routes
14269: WHERE routes.STATUS_CODE IN ( Eng_Workflow_Util.G_RT_REJECTED
14270: , Eng_Workflow_Util.G_RT_APPROVED
14271: , Eng_Workflow_Util.G_RT_COMPLETED
14272: , Eng_Workflow_Util.G_RT_TIME_OUT) -- G_RT_ABORTED was taken care by ABORT WF
14273: AND ( routes.TEMPLATE_FLAG = G_RT_INSTANCE
14266: , TO_NUMBER(NULL) CHANGE_LINE_ID
14267: , routes.ROUTE_ID
14268: FROM ENG_CHANGE_ROUTES routes
14269: WHERE routes.STATUS_CODE IN ( Eng_Workflow_Util.G_RT_REJECTED
14270: , Eng_Workflow_Util.G_RT_APPROVED
14271: , Eng_Workflow_Util.G_RT_COMPLETED
14272: , Eng_Workflow_Util.G_RT_TIME_OUT) -- G_RT_ABORTED was taken care by ABORT WF
14273: AND ( routes.TEMPLATE_FLAG = G_RT_INSTANCE
14274: OR routes.TEMPLATE_FLAG = G_RT_HISTORY)
14267: , routes.ROUTE_ID
14268: FROM ENG_CHANGE_ROUTES routes
14269: WHERE routes.STATUS_CODE IN ( Eng_Workflow_Util.G_RT_REJECTED
14270: , Eng_Workflow_Util.G_RT_APPROVED
14271: , Eng_Workflow_Util.G_RT_COMPLETED
14272: , Eng_Workflow_Util.G_RT_TIME_OUT) -- G_RT_ABORTED was taken care by ABORT WF
14273: AND ( routes.TEMPLATE_FLAG = G_RT_INSTANCE
14274: OR routes.TEMPLATE_FLAG = G_RT_HISTORY)
14275: AND routes.OBJECT_NAME = G_ENG_CHANGE
14268: FROM ENG_CHANGE_ROUTES routes
14269: WHERE routes.STATUS_CODE IN ( Eng_Workflow_Util.G_RT_REJECTED
14270: , Eng_Workflow_Util.G_RT_APPROVED
14271: , Eng_Workflow_Util.G_RT_COMPLETED
14272: , Eng_Workflow_Util.G_RT_TIME_OUT) -- G_RT_ABORTED was taken care by ABORT WF
14273: AND ( routes.TEMPLATE_FLAG = G_RT_INSTANCE
14274: OR routes.TEMPLATE_FLAG = G_RT_HISTORY)
14275: AND routes.OBJECT_NAME = G_ENG_CHANGE
14276: AND routes.OBJECT_ID1 = c_change_id ;
14282: , chg_line.CHANGE_LINE_ID
14283: , line_routes.ROUTE_ID
14284: FROM ENG_CHANGE_ROUTES line_routes
14285: , ENG_CHANGE_LINES chg_line
14286: WHERE line_routes.STATUS_CODE IN ( Eng_Workflow_Util.G_RT_REJECTED
14287: , Eng_Workflow_Util.G_RT_APPROVED
14288: , Eng_Workflow_Util.G_RT_COMPLETED
14289: , Eng_Workflow_Util.G_RT_TIME_OUT ) -- G_RT_ABORTED was taken care by ABORT WF
14290: AND ( line_routes.TEMPLATE_FLAG = G_RT_INSTANCE
14283: , line_routes.ROUTE_ID
14284: FROM ENG_CHANGE_ROUTES line_routes
14285: , ENG_CHANGE_LINES chg_line
14286: WHERE line_routes.STATUS_CODE IN ( Eng_Workflow_Util.G_RT_REJECTED
14287: , Eng_Workflow_Util.G_RT_APPROVED
14288: , Eng_Workflow_Util.G_RT_COMPLETED
14289: , Eng_Workflow_Util.G_RT_TIME_OUT ) -- G_RT_ABORTED was taken care by ABORT WF
14290: AND ( line_routes.TEMPLATE_FLAG = G_RT_INSTANCE
14291: OR line_routes.TEMPLATE_FLAG = G_RT_HISTORY)
14284: FROM ENG_CHANGE_ROUTES line_routes
14285: , ENG_CHANGE_LINES chg_line
14286: WHERE line_routes.STATUS_CODE IN ( Eng_Workflow_Util.G_RT_REJECTED
14287: , Eng_Workflow_Util.G_RT_APPROVED
14288: , Eng_Workflow_Util.G_RT_COMPLETED
14289: , Eng_Workflow_Util.G_RT_TIME_OUT ) -- G_RT_ABORTED was taken care by ABORT WF
14290: AND ( line_routes.TEMPLATE_FLAG = G_RT_INSTANCE
14291: OR line_routes.TEMPLATE_FLAG = G_RT_HISTORY)
14292: AND line_routes.object_id1 = chg_line.CHANGE_LINE_ID
14285: , ENG_CHANGE_LINES chg_line
14286: WHERE line_routes.STATUS_CODE IN ( Eng_Workflow_Util.G_RT_REJECTED
14287: , Eng_Workflow_Util.G_RT_APPROVED
14288: , Eng_Workflow_Util.G_RT_COMPLETED
14289: , Eng_Workflow_Util.G_RT_TIME_OUT ) -- G_RT_ABORTED was taken care by ABORT WF
14290: AND ( line_routes.TEMPLATE_FLAG = G_RT_INSTANCE
14291: OR line_routes.TEMPLATE_FLAG = G_RT_HISTORY)
14292: AND line_routes.object_id1 = chg_line.CHANGE_LINE_ID
14293: AND line_routes.OBJECT_NAME = G_ENG_CHANGE_LINE
14458: CURSOR c_route_step( c_route_id NUMBER )
14459: IS
14460: SELECT RouteStep.STEP_ID
14461: FROM ENG_CHANGE_ROUTE_STEPS RouteStep
14462: WHERE ( RouteStep.STEP_STATUS_CODE <> Eng_Workflow_Util.G_RT_NOT_STARTED
14463: AND RouteStep.STEP_STATUS_CODE <> Eng_Workflow_Util.G_RT_IN_PROGRESS)
14464: AND RouteStep.ROUTE_ID = c_route_id ;
14465:
14466:
14459: IS
14460: SELECT RouteStep.STEP_ID
14461: FROM ENG_CHANGE_ROUTE_STEPS RouteStep
14462: WHERE ( RouteStep.STEP_STATUS_CODE <> Eng_Workflow_Util.G_RT_NOT_STARTED
14463: AND RouteStep.STEP_STATUS_CODE <> Eng_Workflow_Util.G_RT_IN_PROGRESS)
14464: AND RouteStep.ROUTE_ID = c_route_id ;
14465:
14466:
14467:
14599: WHERE RoutePeople.ASSIGNEE_TYPE_CODE = 'PERSON'
14600: AND RoutePeople.ASSIGNEE_ID <> -1
14601: AND RoutePeople.ORIGINAL_ASSIGNEE_TYPE_CODE <> 'ROLE'
14602: AND RoutePeople.STEP_ID = RouteStep.STEP_ID
14603: AND ( RouteStep.STEP_STATUS_CODE <> Eng_Workflow_Util.G_RT_NOT_STARTED
14604: AND RouteStep.STEP_STATUS_CODE <> Eng_Workflow_Util.G_RT_IN_PROGRESS)
14605: AND RouteStep.STEP_ID = c_step_id
14606: UNION
14607: SELECT RouteStep.ROUTE_ID
14600: AND RoutePeople.ASSIGNEE_ID <> -1
14601: AND RoutePeople.ORIGINAL_ASSIGNEE_TYPE_CODE <> 'ROLE'
14602: AND RoutePeople.STEP_ID = RouteStep.STEP_ID
14603: AND ( RouteStep.STEP_STATUS_CODE <> Eng_Workflow_Util.G_RT_NOT_STARTED
14604: AND RouteStep.STEP_STATUS_CODE <> Eng_Workflow_Util.G_RT_IN_PROGRESS)
14605: AND RouteStep.STEP_ID = c_step_id
14606: UNION
14607: SELECT RouteStep.ROUTE_ID
14608: , RoutePeople.STEP_ID
14625: AND RoutePeople.ASSIGNEE_TYPE_CODE = 'PERSON'
14626: AND RoutePeople.ASSIGNEE_ID <> -1
14627: AND RoutePeople.ORIGINAL_ASSIGNEE_TYPE_CODE = 'ROLE'
14628: AND RoutePeople.STEP_ID = RouteStep.STEP_ID
14629: AND ( RouteStep.STEP_STATUS_CODE <> Eng_Workflow_Util.G_RT_NOT_STARTED
14630: AND RouteStep.STEP_STATUS_CODE <> Eng_Workflow_Util.G_RT_IN_PROGRESS)
14631: AND RouteStep.STEP_ID = c_step_id ;
14632:
14633:
14626: AND RoutePeople.ASSIGNEE_ID <> -1
14627: AND RoutePeople.ORIGINAL_ASSIGNEE_TYPE_CODE = 'ROLE'
14628: AND RoutePeople.STEP_ID = RouteStep.STEP_ID
14629: AND ( RouteStep.STEP_STATUS_CODE <> Eng_Workflow_Util.G_RT_NOT_STARTED
14630: AND RouteStep.STEP_STATUS_CODE <> Eng_Workflow_Util.G_RT_IN_PROGRESS)
14631: AND RouteStep.STEP_ID = c_step_id ;
14632:
14633:
14634:
14701: END IF ;
14702:
14703:
14704: IF g_debug_flag THEN
14705: Write_Debug('Eng_Workflow_Util.RevokeObjectRoles Log');
14706: Write_Debug('-----------------------------------------------------');
14707: Write_Debug('Change Id : ' || TO_CHAR(p_change_id) );
14708: Write_Debug('Change Line Id : ' || TO_CHAR(p_change_line_id) );
14709: Write_Debug('Route Id : ' || TO_CHAR(p_route_id));
15142:
15143: END RevokeObjectRoles ;
15144:
15145:
15146: END Eng_Workflow_Util ;