882: from fnd_security_groups
883: where security_group_key = X_SECURITY_GROUP;
884:
885: select decode(X_END_DATE,
886: fnd_load_util.null_value, null,
887: null, X_END_DATE,
888: X_END_DATE)
889: into l_end_date
890: from dual;
888: X_END_DATE)
889: into l_end_date
890: from dual;
891:
892: -- bug3649874 Modified to use fnd_load_util to get the owner_id
893:
894: l_owner := fnd_load_util.owner_id(X_OWNER);
895:
896: fnd_user_resp_groups_api.UPLOAD_ASSIGNMENT(
890: from dual;
891:
892: -- bug3649874 Modified to use fnd_load_util to get the owner_id
893:
894: l_owner := fnd_load_util.owner_id(X_OWNER);
895:
896: fnd_user_resp_groups_api.UPLOAD_ASSIGNMENT(
897: USER_ID => u_id,
898: RESPONSIBILITY_ID => resp_id,