[Home] [Help]
1: PACKAGE BODY HR_APPROVAL_SS AS
2: /* $Header: hraprvlss.pkb 120.50.12020000.5 2013/01/30 17:34:10 aammoham ship $ */
3:
4: -- Package Variables
5: --
2: /* $Header: hraprvlss.pkb 120.50.12020000.5 2013/01/30 17:34:10 aammoham ship $ */
3:
4: -- Package Variables
5: --
6: g_package constant varchar2(25) := 'HR_APPROVAL_SS.';
7: g_debug boolean ;
8: g_no_transaction_id exception;
9: g_wf_not_initialzed exception;
10: g_wf_error_state exception;
1859:
1860: -- fix for bug 4454439
1861: begin
1862: -- re-intialize the performer roles
1863: hr_approval_ss.reinitperformerroles(p_notification_id=>null
1864: ,p_transaction_id=>null
1865: ,p_item_type=>p_item_type
1866: ,p_item_key=>p_item_key);
1867: exception
2033:
2034: else
2035: -- non AME
2036: begin
2037: hr_approval_ss.getNextCustomApprover
2038: (p_item_type=>p_item_type,
2039: p_item_key =>p_item_key,
2040: p_approvalprocesscompleteynout=>c_approvalprocesscompleteynout,
2041: p_approver_rec=>c_approver_to_notify_rec);
2041: p_approver_rec=>c_approver_to_notify_rec);
2042: exception
2043: when others then
2044: if g_debug then
2045: hr_utility.set_location('Error in isFinalApprover calling hr_approval_ss.getNextCustomApprover, SQLERRM' ||' '||to_char(SQLCODE),20);
2046: end if;
2047: raise;
2048: end;
2049: end if ; -- check for AME
3361: -- capture the approver login context information
3362:
3363: if ( funmode = 'RESPOND' OR funmode = 'TIMEOUT') then
3364:
3365: hr_approval_ss.setrespondedusercontext(p_item_type,p_item_key,p_act_id,funmode,result);
3366: end if;
3367:
3368: -- bug 5414392
3369:
3861: PQH_SS_WORKFLOW.set_txn_rfc_status(p_item_type,p_item_key,p_act_id,funmode,result);
3862: -- fix for bug 4454439
3863: begin
3864: -- re-intialize the performer roles
3865: hr_approval_ss.reinitperformerroles(p_notification_id=>null
3866: ,p_transaction_id=>null
3867: ,p_item_type=>p_item_type
3868: ,p_item_key=>p_item_key);
3869:
4246:
4247: -- fix for bug 4481775
4248: begin
4249: -- re-intialize the performer roles
4250: hr_approval_ss.reinitperformerroles(p_notification_id=>null
4251: ,p_transaction_id=>null
4252: ,p_item_type=>p_item_type
4253: ,p_item_key=>p_item_key);
4254: wf_directory.GetRoleName--GetUserName
4460:
4461: -- fix for bug 4481775
4462: begin
4463: -- re-intialize the performer roles
4464: hr_approval_ss.reinitperformerroles(p_notification_id=>null
4465: ,p_transaction_id=>null
4466: ,p_item_type=>lv_item_type
4467: ,p_item_key=>lv_item_key);
4468: exception
5435: p_status => 'Y',
5436: p_transaction_state => null);
5437:
5438: -- re-intialize the performer roles
5439: hr_approval_ss.reinitperformerroles(p_notification_id=>null
5440: ,p_transaction_id=>null
5441: ,p_item_type=>lr_hr_api_transaction_rec.item_type
5442: ,p_item_key=>lr_hr_api_transaction_rec.item_key);
5443:
5553: p_transaction_state => null);
5554:
5555:
5556: -- re-intialize the performer roles
5557: hr_approval_ss.reinitperformerroles(p_notification_id=>null
5558: ,p_transaction_id=>null
5559: ,p_item_type=>lr_hr_api_transaction_rec.item_type
5560: ,p_item_key=>lr_hr_api_transaction_rec.item_key);
5561:
5630:
5631:
5632: -- set the initial submit comments
5633: -- APPROVAL_COMMENT_COPY
5634: hr_approval_ss.create_item_attrib_if_notexist(itemtype => lr_hr_api_transaction_rec.item_type
5635: ,itemkey => lr_hr_api_transaction_rec.item_key
5636: ,aname => 'APPROVAL_COMMENT_COPY'
5637: ,text_value=>p_approval_comments
5638: ,number_value=>null,
5804:
5805: -- finally call wf engine handle to reset the state
5806: -- need to do only if the current activity id is not
5807: -- same as the ln_activity_id
5808: ln_oaf_page_act_id := hr_approval_ss.getoafpageactid(
5809: lr_hr_api_transaction_rec.item_type,
5810: lr_hr_api_transaction_rec.item_key);
5811: if(ln_activity_id is not null and ln_activity_id<>ln_oaf_page_act_id ) then
5812: WF_ENGINE.handleError(
6219:
6220: end getToString;
6221:
6222:
6223: END HR_APPROVAL_SS;
6224: