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.EDR_PSIG_PAGE_FLOW dependencies on EDR_PSIG_DETAILS

Line 457: Select original_recipient from edr_psig_details

453: l_esign_id VARCHAR2(100);
454: l_value VARCHAR2(100);
455:
456: CURSOR C1(l_document_id NUMBER) IS
457: Select original_recipient from edr_psig_details
458: where document_id = l_document_id and USER_RESPONSE is null;
459: -- Bug 4213923 : End
460:
461: --Bug 4577122: Start

Line 496: --clear out the status etc fields of edr_psig_details IFF voting regime is F

492:
493: l_doc_id := GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'EDR_PSIG_DOC_ID');
494:
495: --Bug 4577122: Start
496: --clear out the status etc fields of edr_psig_details IFF voting regime is F
497: if (l_voting_regime = ame_util.firstApproverVoting) then
498: edr_psig.clear_pending_signatures(l_doc_id);
499: end if;
500: --Bug 4577122: End

Line 605: --update the edr_psig_details table for correct evidence store

601: P_NTF_ROUTING_COMMENTS => l_overriding_comments,
602: P_ERR_CODE => l_error_num,
603: P_ERR_MSG => l_error_mesg);
604:
605: --update the edr_psig_details table for correct evidence store
606: --information
607: UPDATE EDR_PSIG_DETAILS
608: SET USER_NAME=nvl(l_overriding_approver,l_username),
609: SIGNATURE_OVERRIDING_COMMENTS = l_overriding_comments

Line 607: UPDATE EDR_PSIG_DETAILS

603: P_ERR_MSG => l_error_mesg);
604:
605: --update the edr_psig_details table for correct evidence store
606: --information
607: UPDATE EDR_PSIG_DETAILS
608: SET USER_NAME=nvl(l_overriding_approver,l_username),
609: SIGNATURE_OVERRIDING_COMMENTS = l_overriding_comments
610: where document_id = l_doc_id
611: and user_response is null