Unfortunately there is no any API available to enter signing limit.
Is There A Method To Enter Signing Limits Other Than Through The Form? (Doc ID 171837.1)
fix: This must be done through the form. There is no supported API or alternate method which can be used.
Through form >
Payable Manager > Employee > Signing Limit
Else,
Do the direct insert to the base table ?
--
insert into ap_web_signing_limits_all
(document_type
,employee_id
,cost_center
,signing_limit
,last_update_date
,last_updated_by
,last_update_login
,creation_date
,created_by
,org_id
)
values('APEXP'
,ln_person_id
,lc_cost_center
,ln_signing_limit
,sysdate
,fnd_profile.value('USER_ID')
,fnd_profile.value('LOGIN_ID')
,sysdate
,fnd_profile.value('USER_ID')
,ln_org_id
);
Ref: http://ebsanil.blogspot.co.uk/2012/09/oracle-employee-signingapproval-limits.html
Is There A Method To Enter Signing Limits Other Than Through The Form? (Doc ID 171837.1)
fix: This must be done through the form. There is no supported API or alternate method which can be used.
Through form >
Payable Manager > Employee > Signing Limit
Else,
Do the direct insert to the base table ?
--
insert into ap_web_signing_limits_all
(document_type
,employee_id
,cost_center
,signing_limit
,last_update_date
,last_updated_by
,last_update_login
,creation_date
,created_by
,org_id
)
values('APEXP'
,ln_person_id
,lc_cost_center
,ln_signing_limit
,sysdate
,fnd_profile.value('USER_ID')
,fnd_profile.value('LOGIN_ID')
,sysdate
,fnd_profile.value('USER_ID')
,ln_org_id
);
Ref: http://ebsanil.blogspot.co.uk/2012/09/oracle-employee-signingapproval-limits.html
No comments:
Post a Comment