API Script to Update Customer Organization DECLARE l_organization_rec HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE; l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE; l_profile_id NUMBER; x_return_status VARCHAR2(10) := NULL; x_msg_count NUMBER := NULL; x_msg_data LONG; l_party_obj_version NUMBER ; vMsgDummy VARCHAR2 (5000); vErrMsg LONG; ln_resp_id NUMBER; ln_resp_appl_id NUMBER; lc_exists VARCHAR2(100); BEGIN begin select responsibility_id, application_id into ln_resp_id, ln_resp_appl_id from fnd_responsibility_vl where responsibility_name = 'Application Developer'; exception when others then ln_resp_id := null; ln_resp_appl_id := null; end; fnd_global.apps_initialize(fnd_global.user_id,ln_resp_id,ln_resp_appl_id)...
Comments
Post a Comment