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

APPS.ENG_WORKFLOW_UTIL dependencies on WF_NOTIFICATION

Line 2329: FROM WF_NOTIFICATION_ATTRIBUTES na,

2325: SELECT na.NAME
2326: , na.TEXT_VALUE
2327: , na.NUMBER_VALUE
2328: , na.DATE_VALUE
2329: FROM WF_NOTIFICATION_ATTRIBUTES na,
2330: WF_MESSAGE_ATTRIBUTES ma,
2331: WF_NOTIFICATIONS ntf
2332: WHERE ntf.NOTIFICATION_ID = p_orig_ntf_id
2333: AND na.NOTIFICATION_ID = ntf.NOTIFICATION_ID

Line 2331: WF_NOTIFICATIONS ntf

2327: , na.NUMBER_VALUE
2328: , na.DATE_VALUE
2329: FROM WF_NOTIFICATION_ATTRIBUTES na,
2330: WF_MESSAGE_ATTRIBUTES ma,
2331: WF_NOTIFICATIONS ntf
2332: WHERE ntf.NOTIFICATION_ID = p_orig_ntf_id
2333: AND na.NOTIFICATION_ID = ntf.NOTIFICATION_ID
2334: AND ma.MESSAGE_NAME = ntf.MESSAGE_NAME
2335: AND ma.MESSAGE_TYPE = ntf.MESSAGE_TYPE

Line 2359: WF_NOTIFICATION.SetAttrText

2355: IF ntf_resp_rec.TEXT_VALUE IS NOT NULL
2356: THEN
2357:
2358:
2359: WF_NOTIFICATION.SetAttrText
2360: ( nid => p_dupllicate_ntf_id
2361: , aname => ntf_resp_rec.NAME
2362: , avalue => ntf_resp_rec.TEXT_VALUE
2363: );

Line 2370: WF_NOTIFICATION.SetAttrNumber

2366:
2367: IF ntf_resp_rec.NUMBER_VALUE IS NOT NULL
2368: THEN
2369:
2370: WF_NOTIFICATION.SetAttrNumber
2371: ( nid => p_dupllicate_ntf_id
2372: , aname => ntf_resp_rec.NAME
2373: , avalue => ntf_resp_rec.NUMBER_VALUE
2374: );

Line 2381: WF_NOTIFICATION.SetAttrDate

2377:
2378: IF ntf_resp_rec.DATE_VALUE IS NOT NULL
2379: THEN
2380:
2381: WF_NOTIFICATION.SetAttrDate
2382: ( nid => p_dupllicate_ntf_id
2383: , aname => ntf_resp_rec.NAME
2384: , avalue => ntf_resp_rec.DATE_VALUE
2385: );

Line 2392: Write_Debug('Calling WF_NOTIFICATION.RESPOND for Target Dup Ntf ');

2388:
2389: END LOOP ;
2390:
2391: IF g_debug_flag THEN
2392: Write_Debug('Calling WF_NOTIFICATION.RESPOND for Target Dup Ntf ');
2393: END IF ;
2394:
2395: WF_NOTIFICATION.RESPOND
2396: ( nid => p_dupllicate_ntf_id -- nid in number

Line 2395: WF_NOTIFICATION.RESPOND

2391: IF g_debug_flag THEN
2392: Write_Debug('Calling WF_NOTIFICATION.RESPOND for Target Dup Ntf ');
2393: END IF ;
2394:
2395: WF_NOTIFICATION.RESPOND
2396: ( nid => p_dupllicate_ntf_id -- nid in number
2397: , responder => p_responder -- responder in varchar2 default null
2398: ) ;
2399:

Line 7571: , WF_NOTIFICATIONS wn

7567: CURSOR c_ntf (p_notification_id NUMBER)
7568: IS
7569: SELECT fu.user_id
7570: FROM FND_USER fu
7571: , WF_NOTIFICATIONS wn
7572: WHERE fu.user_name = wn.recipient_role
7573: AND wn.notification_id = p_notification_id ;
7574:
7575:

Line 7642: l_comment := WF_NOTIFICATION.GetAttrText

7638:
7639: IF p_comment IS NULL THEN
7640:
7641: /*
7642: l_comment := WF_NOTIFICATION.GetAttrText
7643: ( nid => p_notification_id
7644: , aname => 'RESPONSE_COMMENT');
7645: */
7646:

Line 7647: l_comment := WF_NOTIFICATION.GetAttrText

7643: ( nid => p_notification_id
7644: , aname => 'RESPONSE_COMMENT');
7645: */
7646:
7647: l_comment := WF_NOTIFICATION.GetAttrText
7648: ( nid => p_notification_id
7649: , aname => 'WF_NOTE');
7650:
7651: IF g_debug_flag THEN

Line 8281: --Note: To check whether ENG_CHANGE_ROUTE_PEOPLE includes null wf_notification_id or not.

8277: l_base_change_mgmt_type_code VARCHAR2(30);
8278: l_message_text VARCHAR2(400);
8279:
8280: --Bug 11802032 Start
8281: --Note: To check whether ENG_CHANGE_ROUTE_PEOPLE includes null wf_notification_id or not.
8282: l_chg_rte_cnt_nonull_ntfid NUMBER := 0;
8283: --Bug 11802032 END
8284:
8285: CURSOR c_route_person ( p_step_id NUMBER

Line 8298: , WF_NOTIFICATIONS wn

8294: , RoutePeople.original_assignee_type_code
8295: , RoutePeople.response_condition_code
8296: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
8297: , ENG_SECURITY_PEOPLE_V EngSecPeople
8298: , WF_NOTIFICATIONS wn
8299: WHERE RoutePeople.assignee_id = EngSecPeople.person_id
8300: -- AND RoutePeople.assignee_type_code = p_assignee_type_code
8301: AND RoutePeople.step_id = p_step_id
8302: AND EngSecPeople.user_name = wn.recipient_role

Line 8306: -- Note: If p_chg_rte_cnt_nonul_ntfid >0, c_route_person_ntf includes only nonull wf_notification_id rows.

8302: AND EngSecPeople.user_name = wn.recipient_role
8303: AND wn.notification_id = p_notification_id ;
8304:
8305: --Bug 11802032 Start
8306: -- Note: If p_chg_rte_cnt_nonul_ntfid >0, c_route_person_ntf includes only nonull wf_notification_id rows.
8307: -- If p_chg_rte_cnt_nonul_ntfid =0, c_route_person_ntf includes only null wf_notification_id rows.
8308: -- To trace transfer history, do not include 'Transferred' nor 'Delegated' response_code's.
8309: CURSOR c_route_person_ntf ( p_step_id NUMBER
8310: , p_notification_id NUMBER

Line 8307: -- If p_chg_rte_cnt_nonul_ntfid =0, c_route_person_ntf includes only null wf_notification_id rows.

8303: AND wn.notification_id = p_notification_id ;
8304:
8305: --Bug 11802032 Start
8306: -- Note: If p_chg_rte_cnt_nonul_ntfid >0, c_route_person_ntf includes only nonull wf_notification_id rows.
8307: -- If p_chg_rte_cnt_nonul_ntfid =0, c_route_person_ntf includes only null wf_notification_id rows.
8308: -- To trace transfer history, do not include 'Transferred' nor 'Delegated' response_code's.
8309: CURSOR c_route_person_ntf ( p_step_id NUMBER
8310: , p_notification_id NUMBER
8311: , p_chg_rte_cnt_nonull_ntfid NUMBER)

Line 8323: , WF_NOTIFICATIONS wn

8319: , RoutePeople.original_assignee_type_code
8320: , RoutePeople.response_condition_code
8321: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
8322: , ENG_SECURITY_PEOPLE_V EngSecPeople
8323: , WF_NOTIFICATIONS wn
8324: WHERE RoutePeople.assignee_id = EngSecPeople.person_id
8325: AND RoutePeople.step_id = p_step_id
8326: AND EngSecPeople.user_name = wn.recipient_role
8327: AND ( RoutePeople.response_code <> Eng_Workflow_Util.G_ACT_DELEGATED

Line 8332: AND ( ( p_chg_rte_cnt_nonull_ntfid > 0 and RoutePeople.wf_notification_id = p_notification_id )

8328: AND RoutePeople.response_code <> Eng_Workflow_Util.G_RT_TRANSFERRED
8329: AND RoutePeople.response_code <> Eng_Workflow_Util.G_RT_FORWARDED
8330: AND RoutePeople.response_code <> Eng_Workflow_Util.G_ACT_TRANSFERRED ) -- Bug 11802032
8331: AND wn.notification_id = p_notification_id
8332: AND ( ( p_chg_rte_cnt_nonull_ntfid > 0 and RoutePeople.wf_notification_id = p_notification_id )
8333: OR ( p_chg_rte_cnt_nonull_ntfid = 0 and RoutePeople.wf_notification_id is null)) ;
8334: --Bug 11802032 End
8335:
8336: CURSOR c_duplicate_ntf ( p_item_type VARCHAR2

Line 8333: OR ( p_chg_rte_cnt_nonull_ntfid = 0 and RoutePeople.wf_notification_id is null)) ;

8329: AND RoutePeople.response_code <> Eng_Workflow_Util.G_RT_FORWARDED
8330: AND RoutePeople.response_code <> Eng_Workflow_Util.G_ACT_TRANSFERRED ) -- Bug 11802032
8331: AND wn.notification_id = p_notification_id
8332: AND ( ( p_chg_rte_cnt_nonull_ntfid > 0 and RoutePeople.wf_notification_id = p_notification_id )
8333: OR ( p_chg_rte_cnt_nonull_ntfid = 0 and RoutePeople.wf_notification_id is null)) ;
8334: --Bug 11802032 End
8335:
8336: CURSOR c_duplicate_ntf ( p_item_type VARCHAR2
8337: , p_item_key VARCHAR2

Line 8345: WF_NOTIFICATIONS ntf ,

8341: ntf.RECIPIENT_ROLE,
8342: ntf.MESSAGE_NAME,
8343: ntf.message_type
8344: FROM WF_ITEM_ACTIVITY_STATUSES wias,
8345: WF_NOTIFICATIONS ntf ,
8346: WF_NOTIFICATIONS orig_ntf
8347: WHERE ntf.STATUS = 'OPEN'
8348: AND wias.NOTIFICATION_ID = ntf.group_id
8349: AND wias.NOTIFICATION_ID IS NOT NULL

Line 8346: WF_NOTIFICATIONS orig_ntf

8342: ntf.MESSAGE_NAME,
8343: ntf.message_type
8344: FROM WF_ITEM_ACTIVITY_STATUSES wias,
8345: WF_NOTIFICATIONS ntf ,
8346: WF_NOTIFICATIONS orig_ntf
8347: WHERE ntf.STATUS = 'OPEN'
8348: AND wias.NOTIFICATION_ID = ntf.group_id
8349: AND wias.NOTIFICATION_ID IS NOT NULL
8350: AND (wias.ACTIVITY_STATUS = 'NOTIFIED' OR wias.ACTIVITY_STATUS = 'ERROR')

Line 8358: FROM WF_NOTIFICATION_ATTRIBUTES na,

8354: AND ntf.GROUP_ID = orig_ntf.GROUP_ID
8355: AND ntf.NOTIFICATION_ID <> orig_ntf.NOTIFICATION_ID
8356: AND orig_ntf.NOTIFICATION_ID = p_orig_ntf_id
8357: AND EXISTS (SELECT 1
8358: FROM WF_NOTIFICATION_ATTRIBUTES na,
8359: WF_MESSAGE_ATTRIBUTES ma
8360: WHERE na.NOTIFICATION_ID = ntf.NOTIFICATION_ID
8361: AND ma.MESSAGE_NAME = ntf.MESSAGE_NAME
8362: AND ma.MESSAGE_TYPE = ntf.MESSAGE_TYPE

Line 8461: l_comment := WF_NOTIFICATION.GetAttrText

8457:
8458: IF p_comment IS NULL THEN
8459:
8460: /*
8461: l_comment := WF_NOTIFICATION.GetAttrText
8462: ( nid => p_notification_id
8463: , aname => 'RESPONSE_COMMENT');
8464: */
8465:

Line 8466: l_comment := WF_NOTIFICATION.GetAttrText

8462: ( nid => p_notification_id
8463: , aname => 'RESPONSE_COMMENT');
8464: */
8465:
8466: l_comment := WF_NOTIFICATION.GetAttrText
8467: ( nid => p_notification_id
8468: , aname => 'WF_NOTE');
8469:
8470:

Line 8499: --Note: Check whether ENG_CHANGE_ROUTE_PEOPLE has wf_notification_id or not.

8495: Write_Debug('notification_id : ' || to_char(p_notification_id) ) ;
8496: END IF ;
8497:
8498: --Bug 11802032 Start
8499: --Note: Check whether ENG_CHANGE_ROUTE_PEOPLE has wf_notification_id or not.
8500: -- bug 16324566, not use count(), add hint
8501: begin
8502: SELECT /*+ push_pred(ENGSECPEOPLE) */ 1
8503: into l_chg_rte_cnt_nonull_ntfid

Line 8506: , WF_NOTIFICATIONS wn

8502: SELECT /*+ push_pred(ENGSECPEOPLE) */ 1
8503: into l_chg_rte_cnt_nonull_ntfid
8504: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
8505: , ENG_SECURITY_PEOPLE_V EngSecPeople
8506: , WF_NOTIFICATIONS wn
8507: WHERE RoutePeople.assignee_id = EngSecPeople.person_id
8508: AND RoutePeople.step_id = l_step_id
8509: AND EngSecPeople.user_name = wn.recipient_role
8510: AND wn.notification_id = p_notification_id

Line 8511: AND RoutePeople.wf_notification_id = p_notification_id

8507: WHERE RoutePeople.assignee_id = EngSecPeople.person_id
8508: AND RoutePeople.step_id = l_step_id
8509: AND EngSecPeople.user_name = wn.recipient_role
8510: AND wn.notification_id = p_notification_id
8511: AND RoutePeople.wf_notification_id = p_notification_id
8512: AND rownum = 1;
8513: exception
8514: when no_data_found then
8515: l_chg_rte_cnt_nonull_ntfid := 0;

Line 8555: X_WF_NOTIFICATION_ID => p_notification_id,

8551: X_RESPONSE_DATE => SYSDATE ,
8552: X_STEP_ID => l_step_id,
8553: X_ASSIGNEE_TYPE_CODE => l_assignee_type_code,
8554: X_ADHOC_PEOPLE_FLAG => l_adhoc_people_flag,
8555: X_WF_NOTIFICATION_ID => p_notification_id,
8556: X_RESPONSE_CODE => p_response_code,
8557: X_RESPONSE_DESCRIPTION => l_comment ,
8558: X_LAST_UPDATE_DATE => SYSDATE ,
8559: X_LAST_UPDATED_BY => l_performer_user_id ,

Line 8571: WF_NOTIFICATION_ID = p_notification_id,

8567: ) ;
8568: */
8569:
8570: update ENG_CHANGE_ROUTE_PEOPLE set
8571: WF_NOTIFICATION_ID = p_notification_id,
8572: RESPONSE_CODE = p_response_code ,
8573: RESPONSE_DATE = SYSDATE ,
8574: LAST_UPDATE_DATE = SYSDATE ,
8575: LAST_UPDATED_BY = l_performer_user_id ,

Line 8640: l_result := WF_NOTIFICATION.GetAttrText(nid => dup_ntf_rec.notification_id

8636: -- Check Notifiation Result to make sure
8637: -- this notifiaction has not been responded
8638: -- WF Code has cache mechanism
8639: -- So just querying table is not enough
8640: l_result := WF_NOTIFICATION.GetAttrText(nid => dup_ntf_rec.notification_id
8641: ,aname => 'RESULT' ) ;
8642:
8643: IF g_debug_flag THEN
8644: Write_Debug('Duplicate Ntf Result : ' || l_result ) ;

Line 9763: Wf_Notification.VoteCount(l_group_id,result_rec.result_code,

9759: -- d. REQUIRE_ALL_VOTES and all votes are cast
9760: -- Tally votes.
9761: for result_rec in result_codes loop
9762: -- Tally Vote Count for this result code
9763: Wf_Notification.VoteCount(l_group_id,result_rec.result_code,
9764: l_code_count,l_per_of_total,l_per_of_vote);
9765:
9766: IF g_debug_flag THEN
9767: Write_Debug('Couting result code : ' || result_rec.result_code );

Line 9870: wf_notification.OpenNotificationsExist(l_group_id)) then

9866:
9867:
9868: -- If we get here no non-default results were satisfied.
9869: if (funcmode = wf_engine.eng_run and
9870: wf_notification.OpenNotificationsExist(l_group_id)) then
9871: -- Not timed out and still open notifications.
9872: -- Return waiting to continue voting.
9873:
9874: IF g_debug_flag THEN

Line 9961: , WF_NOTIFICATIONS wn

9957: SELECT COUNT(*)
9958: INTO l_total_pop
9959: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
9960: , EGO_USER_V UserV
9961: , WF_NOTIFICATIONS wn
9962: WHERE RoutePeople.assignee_id = UserV.party_id
9963: AND RoutePeople.response_condition_code = 'MANDATORY'
9964: AND RoutePeople.step_id = StepId
9965: AND UserV.user_name = wn.recipient_role

Line 9973: , WF_NOTIFICATIONS wn

9969: SELECT COUNT(*)
9970: INTO l_total_voted
9971: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
9972: , EGO_USER_V UserV
9973: , WF_NOTIFICATIONS wn
9974: WHERE RoutePeople.assignee_id = UserV.party_id
9975: AND RoutePeople.response_condition_code = 'MANDATORY'
9976: AND RoutePeople.step_id = StepId
9977: AND UserV.user_name = wn.recipient_role

Line 9986: , WF_NOTIFICATION_ATTRIBUTES wfna

9982: SELECT COUNT(*)
9983: INTO l_code_count
9984: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
9985: , EGO_USER_V UserV
9986: , WF_NOTIFICATION_ATTRIBUTES wfna
9987: , WF_NOTIFICATIONS wn
9988: WHERE RoutePeople.assignee_id = UserV.party_id
9989: AND RoutePeople.response_condition_code = 'MANDATORY'
9990: AND RoutePeople.step_id = StepId

Line 9987: , WF_NOTIFICATIONS wn

9983: INTO l_code_count
9984: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
9985: , EGO_USER_V UserV
9986: , WF_NOTIFICATION_ATTRIBUTES wfna
9987: , WF_NOTIFICATIONS wn
9988: WHERE RoutePeople.assignee_id = UserV.party_id
9989: AND RoutePeople.response_condition_code = 'MANDATORY'
9990: AND RoutePeople.step_id = StepId
9991: AND UserV.user_name = wn.recipient_role

Line 10089: Wf_Notification.VoteCount

10085:
10086:
10087: ELSE
10088:
10089: Wf_Notification.VoteCount
10090: (Gid => Gid ,
10091: ResultCode => ResultCode ,
10092: ResultCount => ResultCount,
10093: PercentOfTotalPop => PercentOfTotalPop,

Line 10278: Wf_Notification.VoteCount(l_group_id,result_rec.result_code,

10274:
10275: ELSE
10276:
10277: -- Tally Vote Count for this result code
10278: Wf_Notification.VoteCount(l_group_id,result_rec.result_code,
10279: l_code_count,l_per_of_total,l_per_of_vote);
10280:
10281: END IF ;
10282:

Line 10388: wf_notification.OpenNotificationsExist(l_group_id)) then

10384:
10385:
10386: -- If we get here no non-default results were satisfied.
10387: if (funcmode = wf_engine.eng_run and
10388: wf_notification.OpenNotificationsExist(l_group_id)) then
10389: -- Not timed out and still open notifications.
10390: -- Return waiting to continue voting.
10391:
10392: IF g_debug_flag THEN

Line 10772: , WF_NOTIFICATIONS wf

10768: IS
10769:
10770: SELECT UserV.user_id user_id
10771: FROM EGO_USER_V UserV
10772: , WF_NOTIFICATIONS wf
10773: WHERE UserV.user_name = wf.recipient_role
10774: AND wf.notification_id = p_ntf_id ;
10775:
10776:

Line 10774: AND wf.notification_id = p_ntf_id ;

10770: SELECT UserV.user_id user_id
10771: FROM EGO_USER_V UserV
10772: , WF_NOTIFICATIONS wf
10773: WHERE UserV.user_name = wf.recipient_role
10774: AND wf.notification_id = p_ntf_id ;
10775:
10776:
10777: CURSOR c_person_id (p_user_id NUMBER)
10778: IS

Line 10889: , WF_NOTIFICATIONS wf

10885: IS
10886:
10887: SELECT UserV.user_id user_id
10888: FROM EGO_USER_V UserV
10889: , WF_NOTIFICATIONS wf
10890: WHERE UserV.user_name = wf.recipient_role
10891: AND wf.notification_id = p_ntf_id ;
10892:
10893:

Line 10891: AND wf.notification_id = p_ntf_id ;

10887: SELECT UserV.user_id user_id
10888: FROM EGO_USER_V UserV
10889: , WF_NOTIFICATIONS wf
10890: WHERE UserV.user_name = wf.recipient_role
10891: AND wf.notification_id = p_ntf_id ;
10892:
10893:
10894: CURSOR c_person_id (p_user_id NUMBER)
10895: IS

Line 11209: WF_NOTIFICATIONS ntf

11205: ntf.RECIPIENT_ROLE,
11206: ntf.MESSAGE_NAME,
11207: ntf.message_type
11208: FROM WF_ITEM_ACTIVITY_STATUSES wias,
11209: WF_NOTIFICATIONS ntf
11210: WHERE ntf.STATUS = 'OPEN'
11211: AND wias.NOTIFICATION_ID = ntf.group_id
11212: AND wias.NOTIFICATION_ID IS NOT NULL
11213: AND (wias.ACTIVITY_STATUS = 'NOTIFIED' OR wias.ACTIVITY_STATUS = 'ERROR')

Line 11218: FROM WF_NOTIFICATION_ATTRIBUTES na,

11214: AND wias.ITEM_TYPE = p_item_type
11215: AND wias.ITEM_KEY = p_item_key
11216: AND ntf.RECIPIENT_ROLE = p_responder
11217: AND EXISTS (SELECT 1
11218: FROM WF_NOTIFICATION_ATTRIBUTES na,
11219: WF_MESSAGE_ATTRIBUTES ma
11220: WHERE na.NOTIFICATION_ID = ntf.NOTIFICATION_ID
11221: AND ma.MESSAGE_NAME = ntf.MESSAGE_NAME
11222: AND ma.MESSAGE_TYPE = ntf.MESSAGE_TYPE

Line 11263: Write_Debug('Calling WF_NOTIFICATION.SetAttrText for RESULT' );

11259: END IF ;
11260:
11261:
11262: IF g_debug_flag THEN
11263: Write_Debug('Calling WF_NOTIFICATION.SetAttrText for RESULT' );
11264: END IF ;
11265:
11266:
11267: IF x_processed_ntf_id IS NOT NULL AND x_processed_ntf_id > 0

Line 11269: WF_NOTIFICATION.SetAttrText

11265:
11266:
11267: IF x_processed_ntf_id IS NOT NULL AND x_processed_ntf_id > 0
11268: THEN
11269: WF_NOTIFICATION.SetAttrText
11270: ( nid => x_processed_ntf_id
11271: , aname => 'RESULT'
11272: , avalue => G_REPLY
11273: );

Line 11276: Write_Debug('Calling WF_NOTIFICATION.SetAttrText for WF_NOTE' );

11272: , avalue => G_REPLY
11273: );
11274:
11275: IF g_debug_flag THEN
11276: Write_Debug('Calling WF_NOTIFICATION.SetAttrText for WF_NOTE' );
11277: END IF ;
11278:
11279: WF_NOTIFICATION.SetAttrText
11280: ( nid => x_processed_ntf_id

Line 11279: WF_NOTIFICATION.SetAttrText

11275: IF g_debug_flag THEN
11276: Write_Debug('Calling WF_NOTIFICATION.SetAttrText for WF_NOTE' );
11277: END IF ;
11278:
11279: WF_NOTIFICATION.SetAttrText
11280: ( nid => x_processed_ntf_id
11281: , aname => 'WF_NOTE'
11282: , avalue=> p_response_comment) ;
11283:

Line 11285: Write_Debug('Calling WF_NOTIFICATION.RESPOND' );

11281: , aname => 'WF_NOTE'
11282: , avalue=> p_response_comment) ;
11283:
11284: IF g_debug_flag THEN
11285: Write_Debug('Calling WF_NOTIFICATION.RESPOND' );
11286: END IF ;
11287:
11288: WF_NOTIFICATION.RESPOND
11289: ( nid => x_processed_ntf_id -- nid in number

Line 11288: WF_NOTIFICATION.RESPOND

11284: IF g_debug_flag THEN
11285: Write_Debug('Calling WF_NOTIFICATION.RESPOND' );
11286: END IF ;
11287:
11288: WF_NOTIFICATION.RESPOND
11289: ( nid => x_processed_ntf_id -- nid in number
11290: , responder => p_responder -- responder in varchar2 default null
11291: ) ;
11292:

Line 13313: , WF_NOTIFICATIONS wn

13309: , RoutePeople.original_assignee_type_code
13310: , RoutePeople.response_condition_code
13311: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
13312: , ENG_SECURITY_PEOPLE_V EngSecPeople
13313: , WF_NOTIFICATIONS wn
13314: WHERE RoutePeople.assignee_id = EngSecPeople.person_id
13315: -- AND RoutePeople.assignee_type_code = p_assignee_type_code
13316: AND RoutePeople.step_id = p_step_id
13317: AND ( RoutePeople.response_code IS NULL

Line 13324: -- Note: If p_chg_rte_cnt_nonull_ntfid >0, c_route_person_ntf includes only nonull wf_notification_id rows.

13320: AND EngSecPeople.user_name = wn.recipient_role
13321: AND wn.notification_id = p_notification_id ;
13322:
13323: --Bug 11802032 Start
13324: -- Note: If p_chg_rte_cnt_nonull_ntfid >0, c_route_person_ntf includes only nonull wf_notification_id rows.
13325: -- If p_chg_rte_cnt_nonull_ntfid =0, c_route_person_ntf includes only null wf_notification_id rows.
13326: CURSOR c_route_person_ntf ( p_step_id NUMBER
13327: , p_notification_id NUMBER
13328: , p_chg_rte_cnt_nonull_ntfid NUMBER)

Line 13325: -- If p_chg_rte_cnt_nonull_ntfid =0, c_route_person_ntf includes only null wf_notification_id rows.

13321: AND wn.notification_id = p_notification_id ;
13322:
13323: --Bug 11802032 Start
13324: -- Note: If p_chg_rte_cnt_nonull_ntfid >0, c_route_person_ntf includes only nonull wf_notification_id rows.
13325: -- If p_chg_rte_cnt_nonull_ntfid =0, c_route_person_ntf includes only null wf_notification_id rows.
13326: CURSOR c_route_person_ntf ( p_step_id NUMBER
13327: , p_notification_id NUMBER
13328: , p_chg_rte_cnt_nonull_ntfid NUMBER)
13329: IS

Line 13340: , WF_NOTIFICATIONS wn

13336: , RoutePeople.original_assignee_type_code
13337: , RoutePeople.response_condition_code
13338: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
13339: , ENG_SECURITY_PEOPLE_V EngSecPeople
13340: , WF_NOTIFICATIONS wn
13341: WHERE RoutePeople.assignee_id = EngSecPeople.person_id
13342: -- AND RoutePeople.assignee_type_code = p_assignee_type_code
13343: AND RoutePeople.step_id = p_step_id
13344: AND ( RoutePeople.response_code IS NULL

Line 13349: AND ( ( p_chg_rte_cnt_nonull_ntfid > 0 and RoutePeople.wf_notification_id = p_notification_id )

13345: OR RoutePeople.response_code = Eng_Workflow_Util.G_RT_SUBMITTED
13346: OR RoutePeople.response_code = Eng_Workflow_Util.G_RT_NOT_RECEIVED )
13347: AND EngSecPeople.user_name = wn.recipient_role
13348: AND wn.notification_id = p_notification_id
13349: AND ( ( p_chg_rte_cnt_nonull_ntfid > 0 and RoutePeople.wf_notification_id = p_notification_id )
13350: OR ( p_chg_rte_cnt_nonull_ntfid = 0 and RoutePeople.wf_notification_id is null)) ;
13351: --Bug 11802032 End
13352:
13353: CURSOR c_report_people_assocs (p_route_people_id NUMBER)

Line 13350: OR ( p_chg_rte_cnt_nonull_ntfid = 0 and RoutePeople.wf_notification_id is null)) ;

13346: OR RoutePeople.response_code = Eng_Workflow_Util.G_RT_NOT_RECEIVED )
13347: AND EngSecPeople.user_name = wn.recipient_role
13348: AND wn.notification_id = p_notification_id
13349: AND ( ( p_chg_rte_cnt_nonull_ntfid > 0 and RoutePeople.wf_notification_id = p_notification_id )
13350: OR ( p_chg_rte_cnt_nonull_ntfid = 0 and RoutePeople.wf_notification_id is null)) ;
13351: --Bug 11802032 End
13352:
13353: CURSOR c_report_people_assocs (p_route_people_id NUMBER)
13354: IS

Line 13450: --Note: Check whether ENG_CHANGE_ROUTE_PEOPLE has wf_notification_id or not.

13446: l_response_code := G_RT_FORWARDED ;
13447: END IF;
13448:
13449: --Bug 11802032 Start
13450: --Note: Check whether ENG_CHANGE_ROUTE_PEOPLE has wf_notification_id or not.
13451: -- bug 16324566, not use count(), add hint
13452: begin
13453: SELECT /*+ push_pred(ENGSECPEOPLE) */ 1
13454: into l_chg_rte_cnt_nonull_ntfid

Line 13457: , WF_NOTIFICATIONS wn

13453: SELECT /*+ push_pred(ENGSECPEOPLE) */ 1
13454: into l_chg_rte_cnt_nonull_ntfid
13455: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
13456: , ENG_SECURITY_PEOPLE_V EngSecPeople
13457: , WF_NOTIFICATIONS wn
13458: WHERE RoutePeople.assignee_id = EngSecPeople.person_id
13459: AND RoutePeople.step_id = l_step_id
13460: AND EngSecPeople.user_name = wn.recipient_role
13461: AND wn.notification_id = p_notification_id

Line 13462: AND RoutePeople.wf_notification_id = p_notification_id

13458: WHERE RoutePeople.assignee_id = EngSecPeople.person_id
13459: AND RoutePeople.step_id = l_step_id
13460: AND EngSecPeople.user_name = wn.recipient_role
13461: AND wn.notification_id = p_notification_id
13462: AND RoutePeople.wf_notification_id = p_notification_id
13463: AND rownum = 1;
13464: exception
13465: when no_data_found then
13466: l_chg_rte_cnt_nonull_ntfid := 0;

Line 13486: WF_NOTIFICATION_ID = p_notification_id,

13482: l_response_condition_code := rtp_rec.response_condition_code ;
13483:
13484:
13485: update ENG_CHANGE_ROUTE_PEOPLE set
13486: WF_NOTIFICATION_ID = p_notification_id,
13487: RESPONSE_CODE = l_response_code ,
13488: RESPONSE_DATE = SYSDATE ,
13489: LAST_UPDATE_DATE = SYSDATE ,
13490: LAST_UPDATED_BY = l_performer_user_id ,

Line 13537: X_WF_NOTIFICATION_ID => l_notification_id ,

13533: X_STEP_ID => l_step_id ,
13534: X_ASSIGNEE_ID => l_new_party_id,
13535: X_ASSIGNEE_TYPE_CODE => G_PERSON,
13536: X_ADHOC_PEOPLE_FLAG => 'Y',
13537: X_WF_NOTIFICATION_ID => l_notification_id ,
13538: X_RESPONSE_CODE => l_default_assignee_resp ,
13539: X_RESPONSE_DATE => TO_DATE(NULL),
13540: X_REQUEST_ID => NULL,
13541: X_ORIGINAL_SYSTEM_REFERENCE => NULL,