697: IS
698: l_user_id number := 0;
699: begin
700:
701: l_user_id := fnd_load_util.owner_id(X_OWNER);
702:
703: update ASO_SUP_COMPONENT_TL
704: set COMPONENT_NAME = P_COMPONENT_NAME,
705: DESCRIPTION = P_DESCRIPTION,
784:
785: else
786:
787:
788: if ( fnd_load_util.owner_id(P_OWNER) = 120 ) then
789:
790: l_user_id := fnd_load_util.owner_id(P_OWNER);
791:
792: open get_components;
786:
787:
788: if ( fnd_load_util.owner_id(P_OWNER) = 120 ) then
789:
790: l_user_id := fnd_load_util.owner_id(P_OWNER);
791:
792: open get_components;
793: loop
794: fetch get_components into l_COMPONENT_ID;